hello,
my odoo is odoo 14 aphla1
my odoo server and postgresql in same lan.
I first install the odoo server use local postgresql,it work ok.
but when I connect postgresql server,I get 500 error.
my other server connect the postgresql,them work ok.(example,confluence and jira）
-----------
this is my postgresql server conf:
pg_hba.conf
# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 192.168.0.0/24 md5
postgresql.conf
# - Connection Settings -
listen_addresses = '*' # what IP address(es) to listen on;
---------------------
this is my odoo server conf
db_host = 192.168.0.3
db_port = 5432
db_user = odoo
db_passwrod = vCG{82d9]GFbPY9
----------------------
I test psql connect from odoo server to postgresql,it is ok.
# psql -U odoo -h 192.168.0.3 odoo
Password for user odoo:
psql (10.12 (Ubuntu 10.12-0ubuntu0.18.04.1))
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
Type "help" for help.
odoo=>
-----------------------
but ,when I visit the odoo server,i get 500 error.
i check the odoo log,this is error log:
2020-07-04 01:20:44,930 4892 INFO ? odoo.sql_db: Connection to the database failed
2020-07-04 01:20:44,931 4892 INFO ? werkzeug: 127.0.0.1 - - [04/Jul/2020 01:20:44] "GET /favicon.ico HTTP/1.0" 500 - 0 0.000 0.005
2020-07-04 01:20:44,934 4892 ERROR ? werkzeug: Error on request:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 270, in run_wsgi
execute(self.server.app)
File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 258, in execute
application_iter = app(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 439, in app
return self.app(e, s)
File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 142, in application
return application_unproxied(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 117, in application_unproxied
result = odoo.http.root(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1291, in __call__
return self.dispatch(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1261, in __call__
return self.app(environ, start_wrapped)
File "/usr/lib/python3/dist-packages/werkzeug/wsgi.py", line 766, in __call__
return self.app(environ, start_response)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1425, in dispatch
self.setup_db(httprequest)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1348, in setup_db
httprequest.session.db = db_monodb(httprequest)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1509, in db_monodb
dbs = db_list(True, httprequest)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1476, in db_list
dbs = odoo.service.db.list_dbs(force)
File "/usr/lib/python3/dist-packages/odoo/service/db.py", line 380, in list_dbs
with closing(db.cursor()) as cr:
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 671, in cursor
return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 243, in __init__
self._cnx = pool.borrow(dsn)
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 554, in _locked
return fun(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 622, in borrow
**connection_info)
File "/usr/lib/python3/dist-packages/psycopg2/__init__.py", line 130, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: fe_sendauth: no password supplied - - -
===========================================================
What is the reason and how to solve it?
I hope everyone can help
