This question has been flagged
4 Replies
13627 Views

I am facing this problem while installing odoo 10 in windows. This error occurs while running odoo 10 in browser. I have seen log file and it gives an error:-


return application_unproxied(environ, start_response)
  File "C:\Program Files (x86)\Odoo 10.0\server\odoo\service\wsgi_server.py", line 172, in application_unproxied
    result = handler(environ, start_response)
  File "C:\Program Files (x86)\Odoo 10.0\server\odoo\http.py", line 1308, in __call__
    return self.dispatch(environ, start_response)
  File "C:\Program Files (x86)\Odoo 10.0\server\odoo\http.py", line 1282, in __call__
    return self.app(environ, start_wrapped)
  File "werkzeug\wsgi.py", line 579, in __call__

  File "C:\Program Files (x86)\Odoo 10.0\server\odoo\http.py", line 1446, in dispatch
    self.setup_db(httprequest)
  File "C:\Program Files (x86)\Odoo 10.0\server\odoo\http.py", line 1368, in setup_db
    httprequest.session.db = db_monodb(httprequest)
  File "C:\Program Files (x86)\Odoo 10.0\server\odoo\http.py", line 1530, in db_monodb
    dbs = db_list(True, httprequest)
  File "C:\Program Files (x86)\Odoo 10.0\server\odoo\http.py", line 1498, in db_list
    dbs = odoo.service.db.list_dbs(force)
  File "C:\Program Files (x86)\Odoo 10.0\server\odoo\service\db.py", line 333, in list_dbs
    with closing(db.cursor()) as cr:
  File "C:\Program Files (x86)\Odoo 10.0\server\odoo\sql_db.py", line 635, in cursor
    return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)
  File "C:\Program Files (x86)\Odoo 10.0\server\odoo\sql_db.py", line 177, in __init__
    self._cnx = pool.borrow(dsn)
  File "C:\Program Files (x86)\Odoo 10.0\server\odoo\sql_db.py", line 518, in _locked
    return fun(self, *args, **kwargs)
  File "C:\Program Files (x86)\Odoo 10.0\server\odoo\sql_db.py", line 586, in borrow
    **connection_info)
  File "psycopg2\__init__.py", line 164, in connect

OperationalError: could not connect to server: Connection refused (0x0000274D/10061)
    Is the server running on host "localhost" (::1) and accepting
    TCP/IP connections on port 5432?
could not connect to server: Connection refused (0x0000274D/10061)
    Is the server running on host "localhost" (127.0.0.1) and accepting
    TCP/IP connections on port 5432?

Can anyone help on this issue?

Avatar
Discard

If you have identified the cause in your log entries, please use a meaningful question title.

While installing if you gave different port number than you have to mention that port number. Also check postgresql is installed or not, If yes than create one postgres user same as windows user with superadmin.

Best Answer

Obviously Odoo can't access your postgres database. Most probably your odoo postgres user is not set up properly or your pg_hba.conf does not allow access or postgres is not running at all. Please read the installation docs.

Avatar
Discard
Best Answer

Hi! I am starting with Odoo. I had the same error than Gautam while installing Odoo 11 in Windows 10. Thank you Ermin Trevisan for your comment. I checked the pg_hba.conf and I changed the method to trust, then I restarted the postgresql service and refresh the page in the browser. Now Odoo is up and running!

Avatar
Discard