Skip to Content
Menu
This question has been flagged
The question has been closed z dôvodu: Question / Code not indented pomocou Kabir Khan na 03.06.2024 07:06:42
1 Odpoveď
1936 Zobrazenia

Database creation error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory Is the server running locally and accepting connections on that socket?

Avatar
Zrušiť
Best Answer

Normally, PostgreSQL listens on port 5432 and not 8069.

Port 8069 is the default port used for the Odoo web server.

Have you possibly changed the port manually in a configuration file?

Avatar
Zrušiť
Autor

odoo@ip-172-31-3-182:~$ exit
logout
ubuntu@ip-172-31-3-182:~$ sudo su - postgres
This account is currently not available.
ubuntu@ip-172-31-3-182:~$ ubuntu@ip-172-31-3-182:~$ sudo su - postgres
This account is currently not available.sudo -u postgres psql
^C
ubuntu@ip-172-31-3-182:~$ sudo -u postgres psql
could not change directory to "/home/ubuntu": Permission denied
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
ubuntu@ip-172-31-3-182:~$ sudo nano /etc/odoo17.conf
GNU nano 6.2 /etc/odoo17.conf
[options]
admin_passwd = mxdk-uy6w-n28u
db_host = False
db_port = False
db_user = odoo1
db_password = False
xmlrpc_port = 8069
addons_path = /opt/odoo17/odoo17/addons
logfile = /var/log/odoo17/odoo17.log

[ Read 9 lines ]
^G Help ^O Write Out ^W Where Is ^K Cut ^T Execute ^C Location M-U Undo M-A Set Mark M-] To Bracket M-Q Previous
^X Exit ^R Read File ^\ Replace ^U Paste ^J Justify ^/ Go To Line M-E Redo M-6 Copy ^Q Where Was M-W Next

Autor

this is my conf

[options]
admin_passwd = mxdk-uy6w-n28u
db_host = False
db_port = False
db_user = odoo1
db_password = False
xmlrpc_port = 8069
addons_path = /opt/odoo17/odoo17/addons
logfile = /var/log/odoo17/odoo17.log

the configuration looks correct, but since xmlrpc_port is 8069 by default, you can remove this setting and check if it works without it.

You could also try adding "db_port = 5432" to tell Odoo the correct port directly

Related Posts Replies Zobrazenia Aktivita
1
nov 24
1311
1
júl 23
5740
1
mar 15
5207
5
nov 24
14899
1
júl 25
3245