perfSONAR User Q&A and Other Discussion

[Andrew Lake <>]

Hi,

If you are seeing an authentication error in django.log, that sounds like an issue talking with PostgreSQL, not an issue talking to Cassandra. Looks like maybe you fixed the authentication issue and now are getting an error about a missing table. Try running /usr/lib/esmond-database/configure-pgsql95.sh. It should rebuild the tables for you.

Hope that helps,

Andy 

On October 2, 2019 at 3:44:03 AM, Johann Hugo () wrote:

Hi all

I get a "password authentication failed for user "esmond"" in /var/log/esmond/django.log

I've stopped cassandra, moved the database, start cassandra

systemctl stop cassandra

mv /var/lib/cassandra/data/system /var/lib/cassandra/data/system.old

systemctl start cassandra

Do I need more steps to recreate the DB ?

I following the steps from https://docs.perfsonar.net/FAQ.html to nuke all data and start from scratch, but I get an error:

python /usr/lib/esmond/util/ps_remove_data.py -c esmond-nuke.conf
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']
Error: relation "ps_event_types" does not exist
LINE 1: ...ary_window", "ps_event_types"."time_updated" FROM "ps_event_...
                                                             ^

Am I missing some steps here ?

BTW - The path for "configure_esmond" in the FAQ is different from my install.

/usr/lib/perfsonar/scripts/toolkit/system_environment/configure_esmond

should be:

/usr/lib/perfsonar/scripts/system_environment/configure_esmond

Regards

Johann

--
To unsubscribe from this list: https://lists.internet2.edu/sympa/signoff/perfsonar-user