perfSONAR User Q&A and Other Discussion

["Garnizov, Ivan (RRZE)" <>]

Hello Andy, guys,

 

Here is my attempt to install the Esmond service on a dedicated pS MA CentOS 6 server using the postgresql-9.5 service / DB.

 

I have passed the steps of DB initialization and "esmond" user assignments.

/usr/bin/sudo -u postgres /usr/bin/psql -c "CREATE USER esmond WITH PASSWORD '*****'"

/usr/bin/sudo -u postgres /usr/bin/psql -c "CREATE DATABASE esmond"

/usr/bin/sudo -u postgres /usr/bin/psql -c "GRANT ALL ON DATABASE esmond to esmond"

 

I am applying also the /var/lib/pgsql/9.5/data/pg_hba.conf file.

 

I have installed the latest versions of:

esmond-database-postgresql95

esmond

 

Nevertheless I am stuck on the init of the Esmond DB:

 

 

[root@test-psma-gn-01-buc-ro ~]# /sbin/service postgresql-9.5 status

postgresql-9.5 (pid  27496) is running...

[root@test-psma-gn-01-buc-ro ~]# /usr/bin/init_esmond/sbin/service cassandra restart

[root@test-psma-gn-01-buc-ro ~]# /sbin/service cassandra restart

Shutdown Cassandra: OK

Starting Cassandra: OK

[root@test-psma-gn-01-buc-ro ~]# export ESMOND_ROOT=/usr/lib/esmond

[root@test-psma-gn-01-buc-ro ~]# export ESMOND_CONF=/etc/esmond/esmond.conf

[root@test-psma-gn-01-buc-ro ~]# export DJANGO_SETTINGS_MODULE=esmond.settings

[root@test-psma-gn-01-buc-ro ~]# cd =/usr/lib/esmond

[root@test-psma-gn-01-buc-ro esmond]# source /opt/rh/python27/enable

[root@test-psma-gn-01-buc-ro esmond]# /opt/rh/python27/root/usr/bin/virtualenv --prompt="(esmond)" .

New python executable in ./bin/python2

Not overwriting existing python script ./bin/python (you must use ./bin/python2)

Installing setuptools, pip, wheel...done.

[root@test-psma-gn-01-buc-ro esmond]# . bin/activate

(esmond)[root@test-psma-gn-01-buc-ro esmond]# python esmond/manage.py makemigrations --noinput

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 367, in execute_from_command_line

    utility.execute()

  File "/usr/lib/esmond/lib/python2.7/site-packages/django/core/management/__init__.py", line 359, 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 294, in run_from_argv

    self.execute(*args, **cmd_options)

  File "/usr/lib/esmond/lib/python2.7/site-packages/django/core/management/base.py", line 345, in execute

    output = self.handle(*args, **options)

  File "/usr/lib/esmond/lib/python2.7/site-packages/django/core/management/commands/makemigrations.py", line 109, in handle

    loader.check_consistent_history(connection)

  File "/usr/lib/esmond/lib/python2.7/site-packages/django/db/migrations/loader.py", line 276, in check_consistent_history

    applied = recorder.applied_migrations()

  File "/usr/lib/esmond/lib/python2.7/site-packages/django/db/migrations/recorder.py", line 65, in applied_migrations

    self.ensure_schema()

  File "/usr/lib/esmond/lib/python2.7/site-packages/django/db/migrations/recorder.py", line 52, in ensure_schema

    if self.Migration._meta.db_table in self.connection.introspection.table_names(self.connection.cursor()):

  File "/usr/lib/esmond/lib/python2.7/site-packages/django/db/backends/base/base.py", line 233, in cursor

    cursor = self.make_cursor(self._cursor())

  File "/usr/lib/esmond/lib/python2.7/site-packages/django/db/backends/base/base.py", line 204, in _cursor

    self.ensure_connection()

  File "/usr/lib/esmond/lib/python2.7/site-packages/django/db/backends/base/base.py", line 199, in ensure_connection

    self.connect()

  File "/usr/lib/esmond/lib/python2.7/site-packages/django/db/utils.py", line 94, in __exit__

    six.reraise(dj_exc_type, dj_exc_value, traceback)

  File "/usr/lib/esmond/lib/python2.7/site-packages/django/db/backends/base/base.py", line 199, in ensure_connection

    self.connect()

  File "/usr/lib/esmond/lib/python2.7/site-packages/django/db/backends/base/base.py", line 171, in connect

    self.connection = self.get_new_connection(conn_params)

  File "/usr/lib/esmond/lib/python2.7/site-packages/django/db/backends/postgresql/base.py", line 176, in get_new_connection

    connection = Database.connect(**conn_params)

  File "/usr/lib/esmond/lib/python2.7/site-packages/psycopg2/__init__.py", line 130, in connect

    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)

django.db.utils.OperationalError: FATAL:  Peer authentication failed for user "esmond"

 

 

 

I have tried also steps 7 and 8 from: http://software.es.net/esmond/rpm_install.html

 

[root@test-psma-gn-01-buc-ro esmond]# . bin/activate

(esmond)[root@test-psma-gn-01-buc-ro esmond]# python esmond/manage.py syncdb

Unknown command: 'syncdb'

Type 'manage.py help' for usage.

(esmond)[root@test-psma-gn-01-buc-ro esmond]# python esmond/manage.py add_api_key_user perfsonar

 

 

Please tell what’s wrong with the authentication for user “esmond”

 

Regards,

Ivan

Attachment: pg_hba.conf
Description: pg_hba.conf