postgresql failed
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
matrix-synapse (Ubuntu) |
New
|
Undecided
|
Unassigned |
Bug Description
Ubuntu 20.04, matrix-
Service failed with:
```
database:
name: "psycopg2"
args:
user: "matrix"
password: "mypassword"
database: "matrix"
host: "localhost"
cp_min: 5
cp_max: 10
```
No error message.
syslog:
```
Mar 7 11:38:27 ubuntu-2gb-nbg1-1 systemd[1]: Starting Synapse Matrix homeserver...
Mar 7 11:38:29 ubuntu-2gb-nbg1-1 systemd[1]: Started Synapse Matrix homeserver.
Mar 7 11:38:30 ubuntu-2gb-nbg1-1 synapse[122934]: root: [None] ***** STARTING SERVER *****
Mar 7 11:38:30 ubuntu-2gb-nbg1-1 synapse[122934]: root: [None] Server /usr/lib/
Mar 7 11:38:30 ubuntu-2gb-nbg1-1 synapse[122934]: root: [None] Server hostname: tavda.info
Mar 7 11:38:30 ubuntu-2gb-nbg1-1 synapse[122934]: synapse.
Mar 7 11:38:30 ubuntu-2gb-nbg1-1 synapse[122934]: synapse.server: [None] Setting up.
Mar 7 11:38:31 ubuntu-2gb-nbg1-1 systemd[1]: matrix-
Mar 7 11:38:31 ubuntu-2gb-nbg1-1 systemd[1]: matrix-
Mar 7 11:38:34 ubuntu-2gb-nbg1-1 systemd[1]: matrix-
Mar 7 11:38:34 ubuntu-2gb-nbg1-1 systemd[1]: Stopped Synapse Matrix homeserver.
Mar 7 11:38:34 ubuntu-2gb-nbg1-1 systemd[1]: Starting Synapse Matrix homeserver...
Mar 7 11:38:35 ubuntu-2gb-nbg1-1 systemd[1]: Started Synapse Matrix homeserver.
```
This config work fine on Ubuntu 18.04 LTS (matrix.
SQLite work without errors.
При добавлении в конфигурацию настроек базы PostgreSQL сервис перестаёт стартовать. В syslog только сообщения об остановке процесса. При запуске с SQLite проблем не наблюдается. База данных точно доступна (захожу через Adminer (PHP) без проблем).
python3-psycopg2 required.
# sudo apt install python3-psycopg2