search

HenryQW / Awesome-TTRSS

🐋 Awesome TTRSS, a powerful Dockerised all-in-one RSS solution.
http://ttrss.henry.wang
MIT License
2.44k stars 493 forks source link

[Support]无法启动TTRSS #334

Closed chen23188 closed 3 years ago

chen23188 commented 3 years ago

环境为Windows 10 21H1下的Docker，使用Docker Composer安装，报错如下，另外一台相同环境的机器安装运行正常 opencc  |  opencc  | > opencc.henry.wang@0.0.0 start /usr/src/app opencc  | > node ./bin/www opencc  |  postgres  |  postgres  | PostgreSQL Database directory appears to contain a database; Skipping initialization postgres  |  postgres  | 2021-09-25 03:40:08.918 UTC [1] LOG:  starting PostgreSQL 13.4 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.3.1_git20210424) 10.3.1 20210424, 64-bit postgres  | 2021-09-25 03:40:08.918 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432 postgres  | 2021-09-25 03:40:08.918 UTC [1] LOG:  listening on IPv6 address "::", port 5432 postgres  | 2021-09-25 03:40:08.936 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" postgres  | 2021-09-25 03:40:08.998 UTC [22] LOG:  database system was shut down at 2021-09-25 03:31:23 UTC postgres  | 2021-09-25 03:40:09.052 UTC [1] LOG:  database system is ready to accept connections postgres  | 2021-09-25 03:40:09.170 UTC [30] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off postgres  | 2021-09-25 03:40:12.176 UTC [31] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off postgres  | 2021-09-25 03:40:15.182 UTC [32] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off postgres  | 2021-09-25 03:40:18.195 UTC [33] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off postgres  | 2021-09-25 03:40:21.201 UTC [34] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off postgres  | 2021-09-25 03:40:24.206 UTC [35] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off postgres  | 2021-09-25 03:40:27.211 UTC [36] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off postgres  | 2021-09-25 03:40:30.218 UTC [37] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off postgres  | 2021-09-25 03:40:33.223 UTC [38] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off postgres  | 2021-09-25 03:40:36.238 UTC [39] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off postgres  | 2021-09-25 03:40:39.245 UTC [40] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off postgres  | 2021-09-25 03:40:39.253 UTC [41] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off postgres  | 2021-09-25 03:40:42.214 UTC [43] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off postgres  | 2021-09-25 03:40:45.224 UTC [44] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off postgres  | 2021-09-25 03:40:48.233 UTC [45] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off postgres  | 2021-09-25 03:40:51.239 UTC [46] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off postgres  | 2021-09-25 03:40:54.249 UTC [47] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off postgres  | 2021-09-25 03:40:57.258 UTC [48] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off postgres  | 2021-09-25 03:41:00.267 UTC [49] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off postgres  | 2021-09-25 03:41:03.276 UTC [50] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off postgres  | 2021-09-25 03:41:06.287 UTC [51] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off postgres  | 2021-09-25 03:41:09.292 UTC [52] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off postgres  | 2021-09-25 03:41:12.301 UTC [53] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off postgres  | 2021-09-25 03:41:12.308 UTC [54] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off postgres  | 2021-09-25 03:41:14.804 UTC [56] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off ttrss     | PDOException: SQLSTATE[08006] [7] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off in /initialize.php:155 ttrss     | Stack trace: ttrss     | #0 /initialize.php(155): PDO->construct() ttrss     | #1 /initialize.php(164): connectDatabase() ttrss     | #2 /initialize.php(66): checkConnection() ttrss     | #3 {main}PDOException: SQLSTATE[08006] [7] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off in /initialize.php:155 ttrss     | Stack trace: ttrss     | #0 /initialize.php(155): PDO->__construct() ttrss     | #1 /initialize.php(164): connectDatabase() ttrss     | #2 /initialize.php(66): checkConnection() ttrss     | #3 {main}PDOException: SQLSTATE[08006] [7] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off in /initialize.php:155 ttrss     | Stack trace: ttrss     | #0 /initialize.php(155): PDO->construct() ttrss     | #1 /initialize.php(164): connectDatabase() ttrss     | #2 /initialize.php(66): checkConnection() ttrss     | #3 {main}PDOException: SQLSTATE[08006] [7] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off in /initialize.php:155 ttrss     | Stack trace: ttrss     | #0 /initialize.php(155): PDO->construct() ttrss     | #1 /initialize.php(164): connectDatabase() ttrss     | #2 /initialize.php(66): checkConnection() ttrss     | #3 {main}PDOException: SQLSTATE[08006] [7] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off in /initialize.php:155 ttrss     | Stack trace: ttrss     | #0 /initialize.php(155): PDO->__construct() ttrss     | #1 /initialize.php(164): connectDatabase() ttrss     | #2 /initialize.php(66): checkConnection() ttrss     | #3 {main}PDOException: SQLSTATE[08006] [7] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off in /initialize.php:155 ttrss     | Stack trace: ttrss     | #0 /initialize.php(155): PDO->construct() ttrss     | #1 /initialize.php(164): connectDatabase() ttrss     | #2 /initialize.php(66): checkConnection() ttrss     | #3 {main}PDOException: SQLSTATE[08006] [7] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off in /initialize.php:155 ttrss     | Stack trace: ttrss     | #0 /initialize.php(155): PDO->construct() ttrss     | #1 /initialize.php(164): connectDatabase() ttrss     | #2 /initialize.php(66): checkConnection() ttrss     | #3 {main}PDOException: SQLSTATE[08006] [7] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off in /initialize.php:155 ttrss     | Stack trace: ttrss     | #0 /initialize.php(155): PDO->__construct() ttrss     | #1 /initialize.php(164): connectDatabase() ttrss     | #2 /initialize.php(66): checkConnection() ttrss     | #3 {main}PDOException: SQLSTATE[08006] [7] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off in /initialize.php:155 ttrss     | Stack trace: ttrss     | #0 /initialize.php(155): PDO->construct() ttrss     | #1 /initialize.php(164): connectDatabase() ttrss     | #2 /initialize.php(66): checkConnection() ttrss     | #3 {main}PDOException: SQLSTATE[08006] [7] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off in /initialize.php:155 ttrss     | Stack trace: ttrss     | #0 /initialize.php(155): PDO->construct() ttrss     | #1 /initialize.php(164): connectDatabase() ttrss     | #2 /initialize.php(66): checkConnection() ttrss     | #3 {main}PDOException: SQLSTATE[08006] [7] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off in /initialize.php:155 ttrss     | Stack trace: ttrss     | #0 /initialize.php(155): PDO->__construct() ttrss     | #1 /initialize.php(164): connectDatabase() ttrss     | #2 /initialize.php(66): checkConnection() ttrss     | #3 {main}PDOException: SQLSTATE[08006] [7] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off in /initialize.php:155 ttrss     | Stack trace: ttrss     | #0 /initialize.php(155): PDO->construct() ttrss     | #1 /initialize.php(164): connectDatabase() ttrss     | #2 /initialize.php(70): checkConnection() ttrss     | #3 {main}

Exception while creating PDO object:SQLSTATE[08006] [7] could not connect to server: No such file or directory
ttrss     |     Is the server running locally and accepting
ttrss     |     connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
PDOException: SQLSTATE[08006] [7] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off in /initialize.php:155 ttrss     | Stack trace: ttrss     | #0 /initialize.php(155): PDO->construct() ttrss     | #1 /initialize.php(164): connectDatabase() ttrss     | #2 /initialize.php(66): checkConnection() ttrss     | #3 {main}PDOException: SQLSTATE[08006] [7] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off in /initialize.php:155 ttrss     | Stack trace: ttrss     | #0 /initialize.php(155): PDO->__construct() ttrss     | #1 /initialize.php(164): connectDatabase() ttrss     | #2 /initialize.php(66): checkConnection() ttrss     | #3 {main}PDOException: SQLSTATE[08006] [7] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off in /initialize.php:155 ttrss     | Stack trace: ttrss     | #0 /initialize.php(155): PDO->construct() ttrss     | #1 /initialize.php(164): connectDatabase() ttrss     | #2 /initialize.php(66): checkConnection() ttrss     | #3 {main}PDOException: SQLSTATE[08006] [7] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off in /initialize.php:155 ttrss     | Stack trace: ttrss     | #0 /initialize.php(155): PDO->construct() ttrss     | #1 /initialize.php(164): connectDatabase() ttrss     | #2 /initialize.php(66): checkConnection() ttrss     | #3 {main}PDOException: SQLSTATE[08006] [7] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off in /initialize.php:155 ttrss     | Stack trace: ttrss     | #0 /initialize.php(155): PDO->__construct() ttrss     | #1 /initialize.php(164): connectDatabase() ttrss     | #2 /initialize.php(66): checkConnection() ttrss     | #3 {main}PDOException: SQLSTATE[08006] [7] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off in /initialize.php:155 ttrss     | Stack trace: ttrss     | #0 /initialize.php(155): PDO->construct() ttrss     | #1 /initialize.php(164): connectDatabase() ttrss     | #2 /initialize.php(66): checkConnection() ttrss     | #3 {main}PDOException: SQLSTATE[08006] [7] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off in /initialize.php:155 ttrss     | Stack trace: ttrss     | #0 /initialize.php(155): PDO->construct() ttrss     | #1 /initialize.php(164): connectDatabase() ttrss     | #2 /initialize.php(66): checkConnection() ttrss     | #3 {main}PDOException: SQLSTATE[08006] [7] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off in /initialize.php:155 ttrss     | Stack trace: ttrss     | #0 /initialize.php(155): PDO->__construct() ttrss     | #1 /initialize.php(164): connectDatabase() ttrss     | #2 /initialize.php(66): checkConnection() ttrss     | #3 {main}PDOException: SQLSTATE[08006] [7] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off in /initialize.php:155 ttrss     | Stack trace: ttrss     | #0 /initialize.php(155): PDO->construct() ttrss     | #1 /initialize.php(164): connectDatabase() ttrss     | #2 /initialize.php(66): checkConnection() ttrss     | #3 {main}PDOException: SQLSTATE[08006] [7] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off in /initialize.php:155 ttrss     | Stack trace: ttrss     | #0 /initialize.php(155): PDO->construct() ttrss     | #1 /initialize.php(164): connectDatabase() ttrss     | #2 /initialize.php(66): checkConnection() ttrss     | #3 {main}PDOException: SQLSTATE[08006] [7] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off in /initialize.php:155 ttrss     | Stack trace: ttrss     | #0 /initialize.php(155): PDO->__construct() ttrss     | #1 /initialize.php(164): connectDatabase() ttrss     | #2 /initialize.php(66): checkConnection() ttrss     | #3 {main}PDOException: SQLSTATE[08006] [7] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off in /initialize.php:155 ttrss     | Stack trace: ttrss     | #0 /initialize.php(155): PDO->construct() ttrss     | #1 /initialize.php(164): connectDatabase() ttrss     | #2 /initialize.php(70): checkConnection() ttrss     | #3 {main}
Exception while creating PDO object:SQLSTATE[08006] [7] could not connect to server: No such file or directory
ttrss     |     Is the server running locally and accepting
ttrss     |     connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
PDOException: SQLSTATE[08006] [7] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off in /initialize.php:155 ttrss     | Stack trace: ttrss     | #0 /initialize.php(155): PDO->construct() ttrss     | #1 /initialize.php(164): connectDatabase() ttrss     | #2 /initialize.php(66): checkConnection() mercury   |  mercury   | > mercury-parser-api@1.0.0 start /app mercury   | > node index.js mercury   |  mercury   | 🚀Mercury Parser API listens on port 3000 postgres  | 2021-09-25 03:41:17.812 UTC [57] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off ttrss     | #3 {main}PDOException: SQLSTATE[08006] [7] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off in /initialize.php:155 ttrss     | Stack trace: ttrss     | #0 /initialize.php(155): PDO->construct() ttrss     | #1 /initialize.php(164): connectDatabase() ttrss     | #2 /initialize.php(66): checkConnection() postgres  | 2021-09-25 03:41:20.822 UTC [58] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off ttrss     | #3 {main}PDOException: SQLSTATE[08006] [7] FATAL:  no pg_hba.conf entry for host "172.18.0.3", user "postgres", database "postgres", SSL off in /initialize.php:155 ttrss     | Stack trace: ttrss     | #0 /initialize.php(155): PDO->__construct() ttrss     | #1 /initialize.php(164): connectDatabase() ttrss     | #2 /initialize.php(66): checkConnection()

chen23188 commented 3 years ago

微信截图_20210925173437 通过对比pg_hba.conf文件，发现无法启动的那一台上的文件，不知何原因，缺了最后一行“host all all all md5”，补充了这一行后，重启数据库和TTRSS，恢复正常