perfSONAR User Q&A and Other Discussion

["Mike Cruzz" <>]

Greetings team.

I am attempting to setup clusting for the central management archive by using
the cassandra nodes and postgres nodes on separate VM.

In the first part to set up clustering, I was able to setup clustering to
remote cassandra notes successfully by following the documentation on the
website.

However my second attempt to setup postgres clustering has failed.

The way I has done is was I had installed yum install perfsonar-
centralmanagement on a single VM. (VM1)

I then created a new VM (VM2) and installed postgres, created a username and
password and created the esmond database.

From VM1 I am able to connect to VM2 with the credentials.

psql -U esmond -h 10.10.10.1
Password for user esmond:
psql (9.5.3, server 9.6.18)
WARNING: psql major version 9.5, server major version 9.6.
         Some psql features might not work.
Type "help" for help.

esmond=>

I then edited the /etc/esmond/esmond.conf on VM1

[main]
sql_db_engine = django.db.backends.postgresql
sql_db_name = esmond
sql_db_user = esmond
sql_db_password = mypass
sql_db_host = 10.10.10.1


tsdb_root = %(ESMOND_ROOT)s/tsdb-data
tsdb_chunk_prefixes = %(ESMOND_ROOT)s/tsdb-data
api_anon_limit = 30
api_throttle_at =
api_throttle_timeframe =
api_throttle_expiration =
cassandra_servers = localhost:9160
cassandra_user =
cassandra_pass =
db_profile_on_testing = no
profile_persister = no
mib_dirs = %(ESMOND_ROOT)s/mibs
mibs =
syslog_facility = local7
syslog_priority = debug
traceback_dir = %(ESMOND_ROOT)s/crashlog
pid_dir = %(ESMOND_ROOT)s/var/
espersistd_uri = 127.0.0.1:11211
espoll_persist_uri = MemcachedPersistHandler:127.0.0.1:11211
htpasswd_file = %(ESMOND_ROOT)s/htpasswd
[persist_map]
FastPollHC = cassandra
FastPoll = cassandra
JnxFirewall = cassandra
JnxCOS = cassandra
Errors = cassandra
SentryPoll = cassandra
ALUSAPRefPoll = alusapref
ALUSAPPoll = cassandra
IfRefPoll = ifref
[persist_queues]
cassandra = CassandraPollPersister:9
ifref = IfRefPollPersister:1
infifref = InfIfRefPollPersister:1
alusapref = ALUSAPRefPersister:1


On VM1 I then ran, "esmond_manage add_user_ip_address test-user 10.10.10.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: relation "auth_user" does not exist
LINE 1: ...user"."is_active", "auth_user"."date_joined" FROM "auth_user...



I'm sure I'm doing something wrong here but if there's any guidance or hints
on what I need to look for that would be much appreciated.

Thanks in advance.