ONLYOFFICE 7.0: online forms, password protection in sheets, collaboration improvements and much more
ONLYOFFICE 7.0 released

Using remote PostgreSQL

Hi,
I just installed OO Docs Community Edition on RedHat 8 and I would like to use database on remote server.
I tried to configure that with provided script documentserver-configure.sh but without success:
[root@onlyoffice ~]# documentserver-configure.sh
Configuring database access…
Host: sa-edb-edbsrvcl-efm:5444
Database name: onlyofficedb
User: onlyoffice
Password:
Trying to establish PostgreSQL connection… FAILURE

Manually I can reach database server
[root@onlyoffice ~]# psql -h sa-edb-edbsrvcl-efm -p 5444 -U onlyoffice -d onlyofficedb
Password for user onlyoffice:
psql (10.17, server 12.8.12)
WARNING: psql major version 10, server major version 12.
Some psql features might not work.
Type “help” for help.

onlyofficedb=>

What I’m doing wrong?

Hello ts989.

It looks like you got a conflict between versions of postgres database and server:

psql (10.17, server 12.8.12)

WARNING: psql major version 10, server major version 12.

Please solve it and repeat the test.

One more thing. Please try to set database address as ip address while you are running documentserver-configure.sh

Hi Alexandre. Unfortunately, problem is still there

[root@onlyoffice data]# documentserver-configure.sh
Configuring database access…
Host: 10.170.68.84:5444
Database name: onlyofficedb
User: onlyoffice
Password:
Trying to establish PostgreSQL connection… FAILURE

[root@onlyoffice data]# psql -h sa-edb-edbsrvcl-efm -p 5444 -U onlyoffice -d onlyofficedb
Password for user onlyoffice:
psql (12.9, server 12.8.12)
WARNING: psql major version 12, server major version 12.
Some psql features might not work.
Type “help” for help.

onlyofficedb=>

Hello ts989.

Please try to deploy remote database with default port 5432. After that run script one more time but do not set port number. It should look like this:
Host: 10.170.68.84