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

[sraustein]

much whining as if postgres was gone

{{{ From: root@ca0.rpki.net (Cron Daemon) Subject: Cron rpki@ca0 /usr/lib/rpki/rpkigui-import-routes To: rpki@ca0.rpki.net 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: root@ca0.rpki.net (Cron Daemon) Subject: Cron rpki@ca0 exec /usr/bin/rcynic-cron To: root@ca0.rpki.net 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 postgresql@9.5-main[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