I tried to update my forum from 2.7.0beta3 to beta4 yesterday. This failed and since that the forum is offline. I tried the rebuild multiple times, but nothing changed.
If I unterstand this correctly, it looks like there is a problem with the ssl-cert-snakeoil.key. I copied this in the ssl/private cert, but this did not help…
What can I do?
/var/discourse# ./launcher rebuild app
Ensuring launcher is up to date
Fetching origin
Launcher is up-to-date
Stopping old container
+ /usr/bin/docker stop -t 60 app
app
cd /pups && git pull && /pups/bin/pups --stdin
Already up to date.
I, [2021-02-20T13:37:23.183058 #1] INFO -- : Loading --stdin
I, [2021-02-20T13:37:23.189847 #1] INFO -- : > locale-gen $LANG && update-locale
I, [2021-02-20T13:37:23.222699 #1] INFO -- : Generating locales (this might take a while)...
Generation complete.
I, [2021-02-20T13:37:23.222846 #1] INFO -- : > mkdir -p /shared/postgres_run
I, [2021-02-20T13:37:23.225283 #1] INFO -- :
I, [2021-02-20T13:37:23.225472 #1] INFO -- : > chown postgres:postgres /shared/postgres_run
I, [2021-02-20T13:37:23.227685 #1] INFO -- :
I, [2021-02-20T13:37:23.227857 #1] INFO -- : > chmod 775 /shared/postgres_run
I, [2021-02-20T13:37:23.229931 #1] INFO -- :
I, [2021-02-20T13:37:23.230119 #1] INFO -- : > rm -fr /var/run/postgresql
I, [2021-02-20T13:37:23.232352 #1] INFO -- :
I, [2021-02-20T13:37:23.232530 #1] INFO -- : > ln -s /shared/postgres_run /var/run/postgresql
I, [2021-02-20T13:37:23.234556 #1] INFO -- :
I, [2021-02-20T13:37:23.234716 #1] INFO -- : > socat /dev/null UNIX-CONNECT:/shared/postgres_run/.s.PGSQL.5432 || exit 0 && echo postgres already running stop container ; exit 1
2021/02/20 13:37:23 socat[27] E connect(6, AF=1 "/shared/postgres_run/.s.PGSQL.5432", 36): No such file or directory
I, [2021-02-20T13:37:23.239302 #1] INFO -- :
I, [2021-02-20T13:37:23.239467 #1] INFO -- : > rm -fr /shared/postgres_run/.s*
I, [2021-02-20T13:37:23.242307 #1] INFO -- :
I, [2021-02-20T13:37:23.242445 #1] INFO -- : > rm -fr /shared/postgres_run/*.pid
I, [2021-02-20T13:37:23.245206 #1] INFO -- :
I, [2021-02-20T13:37:23.245397 #1] INFO -- : > mkdir -p /shared/postgres_run/13-main.pg_stat_tmp
I, [2021-02-20T13:37:23.247628 #1] INFO -- :
I, [2021-02-20T13:37:23.247840 #1] INFO -- : > chown postgres:postgres /shared/postgres_run/13-main.pg_stat_tmp
I, [2021-02-20T13:37:23.250108 #1] INFO -- :
I, [2021-02-20T13:37:23.254647 #1] INFO -- : File > /etc/service/postgres/run chmod: +x chown:
I, [2021-02-20T13:37:23.259061 #1] INFO -- : File > /etc/service/postgres/log/run chmod: +x chown:
I, [2021-02-20T13:37:23.263496 #1] INFO -- : File > /etc/runit/3.d/99-postgres chmod: +x chown:
I, [2021-02-20T13:37:23.267834 #1] INFO -- : File > /root/upgrade_postgres chmod: +x chown:
I, [2021-02-20T13:37:23.268175 #1] INFO -- : > chown -R root /var/lib/postgresql/13/main
I, [2021-02-20T13:37:37.130043 #1] INFO -- :
I, [2021-02-20T13:37:37.130217 #1] INFO -- : > [ ! -e /shared/postgres_data ] && install -d -m 0755 -o postgres -g postgres /shared/postgres_data && sudo -E -u postgres /usr/lib/postgresql/13/bin/initdb -D /shared/postgres_data || exit 0
I, [2021-02-20T13:37:37.132704 #1] INFO -- :
I, [2021-02-20T13:37:37.132787 #1] INFO -- : > chown -R postgres:postgres /shared/postgres_data
I, [2021-02-20T13:37:37.145885 #1] INFO -- :
I, [2021-02-20T13:37:37.146042 #1] INFO -- : > chown -R postgres:postgres /var/run/postgresql
I, [2021-02-20T13:37:37.148661 #1] INFO -- :
I, [2021-02-20T13:37:37.148864 #1] INFO -- : > /root/upgrade_postgres
I, [2021-02-20T13:37:37.153667 #1] INFO -- :
I, [2021-02-20T13:37:37.153843 #1] INFO -- : > rm /root/upgrade_postgres
I, [2021-02-20T13:37:37.155830 #1] INFO -- :
I, [2021-02-20T13:37:37.156189 #1] INFO -- : Replacing data_directory = '/var/lib/postgresql/13/main' with data_directory = '/shared/postgres_data' in /etc/postgresql/13/main/postgresql.conf
I, [2021-02-20T13:37:37.156795 #1] INFO -- : Replacing (?-mix:#?listen_addresses *=.*) with listen_addresses = '*' in /etc/postgresql/13/main/postgresql.conf
I, [2021-02-20T13:37:37.157169 #1] INFO -- : Replacing (?-mix:#?synchronous_commit *=.*) with synchronous_commit = $db_synchronous_commit in /etc/postgresql/13/main/postgresql.conf
I, [2021-02-20T13:37:37.157504 #1] INFO -- : Replacing (?-mix:#?shared_buffers *=.*) with shared_buffers = $db_shared_buffers in /etc/postgresql/13/main/postgresql.conf
I, [2021-02-20T13:37:37.157873 #1] INFO -- : Replacing (?-mix:#?work_mem *=.*) with work_mem = $db_work_mem in /etc/postgresql/13/main/postgresql.conf
I, [2021-02-20T13:37:37.158232 #1] INFO -- : Replacing (?-mix:#?default_text_search_config *=.*) with default_text_search_config = '$db_default_text_search_config' in /etc/postgresql/13/main/postgresql.conf
I, [2021-02-20T13:37:37.158619 #1] INFO -- : > install -d -m 0755 -o postgres -g postgres /shared/postgres_backup
I, [2021-02-20T13:37:37.161251 #1] INFO -- :
I, [2021-02-20T13:37:37.161572 #1] INFO -- : Replacing (?-mix:#?checkpoint_segments *=.*) with checkpoint_segments = $db_checkpoint_segments in /etc/postgresql/13/main/postgresql.conf
I, [2021-02-20T13:37:37.161876 #1] INFO -- : Replacing (?-mix:#?logging_collector *=.*) with logging_collector = $db_logging_collector in /etc/postgresql/13/main/postgresql.conf
I, [2021-02-20T13:37:37.162217 #1] INFO -- : Replacing (?-mix:#?log_min_duration_statement *=.*) with log_min_duration_statement = $db_log_min_duration_statement in /etc/postgresql/13/main/postgresql.conf
I, [2021-02-20T13:37:37.162602 #1] INFO -- : Replacing (?-mix:^#local +replication +postgres +peer$) with local replication postgres peer in /etc/postgresql/13/main/pg_hba.conf
I, [2021-02-20T13:37:37.162912 #1] INFO -- : Replacing (?-mix:^host.*all.*all.*127.*$) with host all all 0.0.0.0/0 md5 in /etc/postgresql/13/main/pg_hba.conf
I, [2021-02-20T13:37:37.163149 #1] INFO -- : > HOME=/var/lib/postgresql USER=postgres exec chpst -u postgres:postgres:ssl-cert -U postgres:postgres:ssl-cert /usr/lib/postgresql/13/bin/postmaster -D /etc/postgresql/13/main
I, [2021-02-20T13:37:37.164636 #1] INFO -- : > sleep 5
2021-02-20 13:37:37.197 UTC [50] FATAL: could not access private key file "/etc/ssl/private/ssl-cert-snakeoil.key": Permission denied
2021-02-20 13:37:37.197 UTC [50] LOG: database system is shut down
I, [2021-02-20T13:37:42.166961 #1] INFO -- :
I, [2021-02-20T13:37:42.167363 #1] INFO -- : > su postgres -c 'createdb discourse' || true
createdb: error: could not connect to database template1: 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"?
I, [2021-02-20T13:37:42.218126 #1] INFO -- :
I, [2021-02-20T13:37:42.218344 #1] INFO -- : > su postgres -c 'psql discourse -c "create user discourse;"' || true
psql: error: 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"?
I, [2021-02-20T13:37:42.275239 #1] INFO -- :
I, [2021-02-20T13:37:42.275461 #1] INFO -- : > su postgres -c 'psql discourse -c "grant all privileges on database discourse to discourse;"' || true
psql: error: 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"?
I, [2021-02-20T13:37:42.332060 #1] INFO -- :
I, [2021-02-20T13:37:42.332325 #1] INFO -- : > su postgres -c 'psql discourse -c "alter schema public owner to discourse;"'
psql: error: 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"?
I, [2021-02-20T13:37:42.386846 #1] INFO -- :
I, [2021-02-20T13:37:42.387190 #1] INFO -- : Terminating async processes
FAILED
--------------------
Pups::ExecError: su postgres -c 'psql discourse -c "alter schema public owner to discourse;"' failed with return #<Process::Status: pid 76 exit 2>
Location of failure: /pups/lib/pups/exec_command.rb:112:in `spawn'
exec failed with the params "su postgres -c 'psql $db_name -c \"alter schema public owner to $db_user;\"'"
a3db105ffb0ece834083479085db37dcae8c0baaa6dc4691dc9057a82baf2a11
** FAILED TO BOOTSTRAP ** please scroll up and look for earlier error messages, there may be more than one.
./discourse-doctor may help diagnose the problem.
# ls -lah shared/standalone/ssl/private/
total 12K
drwxr-xr-x 2 root root 4.0K Feb 19 20:13 .
drwxr-xr-x 3 root root 4.0K Feb 19 20:13 ..
-rw-r--r-- 1 root root 1.7K Feb 19 20:11 ssl-cert-snakeoil.key