Hi Carl,
Paostgresql has been installed just before onlyoffice installation like in documentation. So installation of postresql 15 was new. Never tried with v16 as v15 is last version proposed by repository of Debian.
As i can’t give rights to onlyoffice user on onlyoffice database, i changed the owner of the database from postgresql to only office:
onlyoffice=> \l
Liste des bases de données
Nom | Propriétaire | Encodage | Collationnement | Type caract. | Locale ICU | Fournisseur de locale | Droits d'accès
------------+--------------+----------+-----------------+--------------+------------+-----------------------+-------------------------
onlyoffice | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | | libc | =Tc/postgres +
| | | | | | | postgres=CTc/postgres +
| | | | | | | onlyoffice=CTc/postgres
postgres | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | | libc |
template0 | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | | libc | =c/postgres +
| | | | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | | libc | =c/postgres +
| | | | | | | postgres=CTc/postgres
(4 lignes)
postgres=# ALTER DATABASE onlyoffice OWNER TO onlyoffice;
postgres=# \l
Liste des bases de données
Nom | Propriétaire | Encodage | Collationnement | Type caract. | Locale ICU | Fournisseur de locale | Droits d'accès
------------+--------------+----------+-----------------+--------------+------------+-----------------------+---------------------------
onlyoffice | onlyoffice | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | | libc | =Tc/onlyoffice +
| | | | | | | onlyoffice=CTc/onlyoffice
postgres | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | | libc |
template0 | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | | libc | =c/postgres +
| | | | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | fr_FR.UTF-8 | fr_FR.UTF-8 | | libc | =c/postgres +
| | | | | | | postgres=CTc/postgres
(4 lignes)
with the result i can’t execute the script createdb.sql with no error:
psql -h localhost -U onlyoffice -d onlyoffice -f /var/www/onlyoffice/documentserver/server/schema/postgresql/createdb.sql
Mot de passe pour l'utilisateur onlyoffice :
CREATE TABLE
CREATE TABLE
CREATE FUNCTION
When I create a new document, or try to open a document, i have this new error:
[2024-01-15T15:36:34.481] [ERROR] [localhost] [10.0.2.2new.docx1704815924806] [uid-1] nodeJS - postData error: url = http://127.0.0.1:8181/example/track?filename=new.docx&useraddress=10.0.2.2;data = {"key":"10.0.2.2new.docx1704815924806","status":1,"users":["uid-1"],"actions":[{"type":1,"userid":"uid-1"}],"token":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJrZXkiOiIxMC4wLjIuMm5ldy5kb2N4MTcwNDgxNTkyNDgwNiIsInN0YXR1cyI6MSwidXNlcnMiOlsidWlkLTEiXSwiYWN0aW9ucyI6W3sidHlwZSI6MSwidXNlcmlkIjoidWlkLTEifV0sImlhdCI6MTcwNTMyOTM5NCwiZXhwIjoxNzA1MzI5Njk0fQ.SagFjz8mK5yx5R2sM1yeNMYnMkBOOPeE6ArJUmc-5uo"} Error: connect ECONNREFUSED 127.0.0.1:8181
at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1159:16)