حاولت تحديث منتداي من الإصدار 2.7.0beta3 إلى beta4 أمس. فشل التحديث، ومنذ ذلك الحين أصبح المنتدى غير متصل. حاولت إعادة البناء عدة مرات، لكن لم يتغير شيء.
إذا فهمت الأمر بشكل صحيح، يبدو أن هناك مشكلة في ملف ssl-cert-snakeoil.key. قمت بنسخ هذا الملف إلى مجلد ssl/private cert، لكن ذلك لم يساعد…
ما الذي يمكنني فعله؟
/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