Hi, I have a problem with postgres connection. Please, can any one help me ?
I am deploying an odoo 10 app in my Ubuntu 16.04 server.
I get this error when trying to open the odoo web page :
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: 2017-12-29 19:13:49,805 8336 INFO ? werkzeug: 54.36.99.87 - - [29/Dec/2017 19:13:49] "GET /favicon.ico HTTP/1.1" 500 -
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: 2017-12-29 19:13:49,812 8336 ERROR ? werkzeug: Error on request:
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: Traceback (most recent call last):
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: File "/usr/lib/python2.7/dist-packages/werkzeug/serving.py", line 180, in run_wsgi
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: execute(self.server.app)
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: File "/usr/lib/python2.7/dist-packages/werkzeug/serving.py", line 168, in execute
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: application_iter = app(environ, start_response)
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: File "/opt/odoo/odoo-10.0/odoo/service/server.py", line 249, in app
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: return self.app(e, s)
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: File "/opt/odoo/odoo-10.0/odoo/service/wsgi_server.py", line 186, in application
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: return application_unproxied(environ, start_response)
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: File "/opt/odoo/odoo-10.0/odoo/service/wsgi_server.py", line 172, in application_unproxied
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: result = handler(environ, start_response)
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: File "/opt/odoo/odoo-10.0/odoo/http.py", line 1308, in __call__
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: return self.dispatch(environ, start_response)
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: File "/opt/odoo/odoo-10.0/odoo/http.py", line 1282, in __call__
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: return self.app(environ, start_wrapped)
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: File "/usr/lib/python2.7/dist-packages/werkzeug/wsgi.py", line 591, in __call__
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: return self.app(environ, start_response)
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: File "/opt/odoo/odoo-10.0/odoo/http.py", line 1446, in dispatch
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: self.setup_db(httprequest)
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: File "/opt/odoo/odoo-10.0/odoo/http.py", line 1368, in setup_db
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: httprequest.session.db = db_monodb(httprequest)
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: File "/opt/odoo/odoo-10.0/odoo/http.py", line 1530, in db_monodb
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: dbs = db_list(True, httprequest)
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: File "/opt/odoo/odoo-10.0/odoo/http.py", line 1498, in db_list
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: dbs = odoo.service.db.list_dbs(force)
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: File "/opt/odoo/odoo-10.0/odoo/service/db.py", line 333, in list_dbs
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: with closing(db.cursor()) as cr:
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: File "/opt/odoo/odoo-10.0/odoo/sql_db.py", line 635, in cursor
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: File "/opt/odoo/odoo-10.0/odoo/sql_db.py", line 177, in __init__
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: self._cnx = pool.borrow(dsn)
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: File "/opt/odoo/odoo-10.0/odoo/sql_db.py", line 518, in _locked
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: return fun(self, *args, **kwargs)
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: File "/opt/odoo/odoo-10.0/odoo/sql_db.py", line 586, in borrow
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: **connection_info)
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: File "/usr/lib/python2.7/dist-packages/psycopg2/__init__.py", line 164, in connect
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: conn = _connect(dsn, connection_factory=connection_factory, async=async)
Dec 29 20:13:49 vpsxxxxxx odoo-bin[8336]: OperationalError: fe_sendauth: no password supplied
I am using this configuration file :
[options]
; This is the password that allows database operations:
; admin_passwd = admin
db_host = localhost
db_port = 5432
db_user = odoo
db_password = False
addons_path = /opt/odoo/odoo-10.0/addons
* I've set a password to odoo user and changed db_password to 12345 I get :
Dec 29 20:37:33 vps459020 odoo-bin[8732]: OperationalError: FATAL: password authentication failed for user "odoo"
Dec 29 20:37:33 vps459020 odoo-bin[8732]: FATAL: password authentication failed for user "odoo"
When try to log to psqgl with odoo user :
postgres@vpsxxxxxx:~$ psql -U odoo
psql: FATAL: Peer authentication failed for user "odoo"
The pg_hba.conf file contains these lines :
# TYPE DATABASE USER ADDRESS METHOD
local all postgres peer
# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# trying to allow odoo user
local all odoo md5
# IPv6 local connections:
host all all ::1/128 md5
What is wrong with my configuration ?
