perfSONAR User Q&A and Other Discussion

["Mike Cruzz" <>]

Ah well it was worth a shot trying to do the restore of the database and
running the

esmond_manage add_user_ip_address test2-user 100.100.207.0/24
cassandra_db [INFO] Checking/creating column families
cassandra_db [INFO] Schema check done
cassandra_db [DEBUG] Opening ConnectionPool
cassandra_db [INFO] Connected to ['localhost:9160']
cassandra_db [INFO] Checking/creating column families
cassandra_db [INFO] Checking/creating column families
cassandra_db [INFO] Schema check done
cassandra_db [INFO] Schema check done
cassandra_db [DEBUG] Opening ConnectionPool
cassandra_db [DEBUG] Opening ConnectionPool
cassandra_db [INFO] Connected to ['localhost:9160']
cassandra_db [INFO] Connected to ['localhost:9160']
Traceback (most recent call last):
  File "esmond/manage.py", line 14, in <module>
    execute_from_command_line(sys.argv)
  File "/usr/lib/esmond/lib/python2.7/site-packages/django/core/management/
__init__.py", line 364, in execute_from_command_line
    utility.execute()
  File "/usr/lib/esmond/lib/python2.7/site-packages/django/core/management/
__init__.py", line 356, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/usr/lib/esmond/lib/python2.7/site-packages/django/core/management/
base.py", line 283, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/usr/lib/esmond/lib/python2.7/site-packages/django/core/management/
base.py", line 330, in execute
    output = self.handle(*args, **options)
  File "/usr/lib/esmond/esmond/api/management/commands/
add_user_ip_address.py", line 23, in handle
    u = User.objects.get(username=user)
  File "/usr/lib/esmond/lib/python2.7/site-packages/django/db/models/
manager.py", line 85, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
  File "/usr/lib/esmond/lib/python2.7/site-packages/django/db/models/
query.py", line 374, in get
    num = len(clone)
  File "/usr/lib/esmond/lib/python2.7/site-packages/django/db/models/
query.py", line 232, in __len__
    self._fetch_all()
  File "/usr/lib/esmond/lib/python2.7/site-packages/django/db/models/
query.py", line 1121, in _fetch_all
    self._result_cache = list(self._iterable_class(self))
  File "/usr/lib/esmond/lib/python2.7/site-packages/django/db/models/
query.py", line 53, in __iter__
    results = compiler.execute_sql(chunked_fetch=self.chunked_fetch)
  File "/usr/lib/esmond/lib/python2.7/site-packages/django/db/models/sql/
compiler.py", line 899, in execute_sql
    raise original_exception
django.db.utils.ProgrammingError: permission denied for relation auth_user


Will try a few more alternatives but if it doesnt work will go with the second
option and try and get HA for postgrs that way on a remote VM.