ca0 - could not connect to server: No such file or directory

[sraustein]

much whining as if postgres was gone

{{{
From: [email protected] (Cron Daemon)
Subject: Cron rpki@ca0 /usr/lib/rpki/rpkigui-import-routes
To: [email protected]
Date: Sat, 02 Jul 2016 00:21:14 +0000

2016-07-02 00:21:14 rpkigui-import-routes[3120]: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
: OperationalError: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
}}}

and

{{{
From: [email protected] (Cron Daemon)
Subject: Cron rpki@ca0 exec /usr/bin/rcynic-cron
To: [email protected]
Date: Sat, 02 Jul 2016 00:36:02 +0000

Traceback (most recent call last):
File "/usr/bin/rcynic", line 1493, in
main()
File "/usr/bin/rcynic", line 1464, in main
django.core.management.call_command("migrate", verbosity = 0, interactive = False)
File "/usr/lib/python2.7/dist-packages/django/core/management/init.py", line 120, in call_command
return command.execute(_args, *_defaults)
File "/usr/lib/python2.7/dist-packages/django/core/management/base.py", line 445, in execute
output = self.handle(_args, *_options)
File "/usr/lib/python2.7/dist-packages/django/core/management/commands/migrate.py", line 93, in handle
executor = MigrationExecutor(connection, self.migration_progress_callback)
File "/usr/lib/python2.7/dist-packages/django/db/migrations/executor.py", line 19, in init
self.loader = MigrationLoader(self.connection)
File "/usr/lib/python2.7/dist-packages/django/db/migrations/loader.py", line 47, in init
self.build_graph()
File "/usr/lib/python2.7/dist-packages/django/db/migrations/loader.py", line 191, in build_graph
self.applied_migrations = recorder.applied_migrations()
File "/usr/lib/python2.7/dist-packages/django/db/migrations/recorder.py", line 59, in applied_migrations
self.ensure_schema()
File "/usr/lib/python2.7/dist-packages/django/db/migrations/recorder.py", line 49, in ensure_schema
if self.Migration._meta.db_table in self.connection.introspection.table_names(self.connection.cursor()):
File "/usr/lib/python2.7/dist-packages/django/db/backends/base/base.py", line 164, in cursor
cursor = self.make_cursor(self._cursor())
File "/usr/lib/python2.7/dist-packages/django/db/backends/base/base.py", line 135, in _cursor
self.ensure_connection()
File "/usr/lib/python2.7/dist-packages/django/db/backends/base/base.py", line 130, in ensure_connection
self.connect()
File "/usr/lib/python2.7/dist-packages/django/db/utils.py", line 98, in exit
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/usr/lib/python2.7/dist-packages/django/db/backends/base/base.py", line 130, in ensure_connection
self.connect()
File "/usr/lib/python2.7/dist-packages/django/db/backends/base/base.py", line 119, in connect
self.connection = self.get_new_connection(conn_params)
File "/usr/lib/python2.7/dist-packages/django/db/backends/postgresql_psycopg2/base.py", line 176, in get_new_connection
connection = Database.connect(**conn_params)
File "/usr/lib/python2.7/dist-packages/psycopg2/init.py", line 164, in connect
conn = _connect(dsn, connection_factory=connection_factory, async=async)
django.db.utils.OperationalError: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

Program /usr/bin/rcynic exited with status 1
}}}

Trac ticket #837 component rpkid priority critical, owner None, created by randy on 2016-07-02T02:26:28Z, last modified 2016-07-02T05:48:02Z

[sraustein]

{{{
ca0.rpki.net:/root# l /var/run/postgresql
total 0
drwxr-s--- 2 postgres postgres 40 Jul 1 22:48 9.5-main.pg_stat_tmp/
}

oh, and i did rpki-ca restart a few hours back to try to clear this

Trac comment by randy on 2016-07-02T02:28:13Z

[sraustein]

found in log
{{{
Jul 2 05:44:11 ca0 [email protected][9239]: 2016-07-02 05:44:10 UTC [9247-1]
FATAL: could not load server certificate file "/etc/ssl/certs/ssl-cert-snakeoil.pem": Permission denied
}}}

monthly Lets Encrypt run may be a little conservative on perms

Trac comment by randy on 2016-07-02T05:47:52Z

[sraustein]

Closed with resolution fixed