Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

500 Internal Server Error - Odoo 9.0-20160622

By
Dimitar Jovanovski
on 6/23/16, 1:11 PM 1,516 views

Hello,

I have problem on first start after installation

OS - Windows 10 Pro

Odoo 9.0-20160622

odoo_9.0c.latest


on browser

Internal Server Error

The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application.


in openerp-server log 

2016-06-23 16:58:19,940 4344 INFO ? openerp: OpenERP version 9.0c-20160622

2016-06-23 16:58:19,940 4344 INFO ? openerp: addons paths: [u'C:\\Users\\eSoftDeveloper03\\AppData\\Local\\OpenERP S.A.\\Odoo\\addons\\9.0', u'C:\\Program Files (x86)\\Odoo 9.0-20160622\\server\\openerp\\addons']

2016-06-23 16:58:19,940 4344 INFO ? openerp: database: openpg@localhost:5432

2016-06-23 16:58:20,569 4344 INFO ? openerp.service.server: Initiating shutdown

2016-06-23 16:58:20,569 4344 INFO ? openerp.service.server: Hit CTRL-C again or send a second signal to force the shutdown.

2016-06-23 16:58:22,375 4480 INFO ? openerp: OpenERP version 9.0c-20160622

2016-06-23 16:58:22,384 4480 INFO ? openerp: addons paths: ['C:\\Users\\eSoftDeveloper03\\AppData\\Local\\OpenERP S.A.\\Odoo\\addons\\9.0', u'C:\\Program Files (x86)\\Odoo 9.0-20160622\\server\\openerp\\addons']

2016-06-23 16:58:22,384 4480 INFO ? openerp: database: openpg@localhost:5432

2016-06-23 16:58:22,595 4480 INFO ? openerp.service.server: HTTP service (werkzeug) running on 0.0.0.0:8069

2016-06-23 17:00:33,473 4480 INFO ? openerp.addons.bus.models.bus: Bus.loop listen imbus on db postgres

2016-06-23 17:00:35,505 4480 INFO ? openerp.sql_db: Connection to the database failed

2016-06-23 17:00:35,510 4480 ERROR ? openerp.addons.bus.models.bus: Bus.loop error, sleep and retry

Traceback (most recent call last):

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\addons\bus\models\bus.py", line 168, in run

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\addons\bus\models\bus.py", line 146, in loop

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\.\openerp\sql_db.py", line 630, in cursor

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\.\openerp\sql_db.py", line 164, in __init__

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\.\openerp\sql_db.py", line 513, in _locked

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\.\openerp\sql_db.py", line 581, in borrow

File "psycopg2\__init__.pyc", 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?

2016-06-23 17:00:35,551 4480 INFO ? openerp.addons.report.models.report: Will use the Wkhtmltopdf binary at C:\Program Files (x86)\Odoo 9.0-20160622\thirdparty\wkhtmltopdf.exe

2016-06-23 17:00:36,836 4480 INFO ? openerp.http: HTTP Configuring static files

2016-06-23 17:00:38,851 4480 INFO ? openerp.sql_db: Connection to the database failed

2016-06-23 17:00:39,022 4480 INFO ? werkzeug: 127.0.0.1 - - [23/Jun/2016 17:00:39] "GET / HTTP/1.1" 500 -

2016-06-23 17:00:39,042 4480 ERROR ? werkzeug: Error on request:

Traceback (most recent call last):

File "werkzeug\serving.py", line 177, in run_wsgi

File "werkzeug\serving.py", line 165, in execute

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\service\server.py", line 246, in app

return self.app(e, s)

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\service\wsgi_server.py", line 184, in application

return application_unproxied(environ, start_response)

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\service\wsgi_server.py", line 170, in application_unproxied

result = handler(environ, start_response)

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\http.py", line 1493, in __call__

return self.dispatch(environ, start_response)

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\http.py", line 1467, in __call__

return self.app(environ, start_wrapped)

File "werkzeug\wsgi.py", line 579, in __call__

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\http.py", line 1622, in dispatch

self.setup_db(httprequest)

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\http.py", line 1553, in setup_db

httprequest.session.db = db_monodb(httprequest)

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\http.py", line 1700, in db_monodb

dbs = db_list(True, httprequest)

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\http.py", line 1674, in db_list

dbs = openerp.service.db.list_dbs(force)

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\service\db.py", line 323, in list_dbs

with closing(db.cursor()) as cr:

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\sql_db.py", line 630, in cursor

return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\sql_db.py", line 164, in __init__

self._cnx = pool.borrow(dsn)

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\sql_db.py", line 513, in _locked

return fun(self, *args, **kwargs)

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\sql_db.py", line 581, 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?

2016-06-23 17:00:41,082 4480 INFO ? openerp.sql_db: Connection to the database failed

2016-06-23 17:00:41,117 4480 INFO ? werkzeug: 127.0.0.1 - - [23/Jun/2016 17:00:41] "GET /favicon.ico HTTP/1.1" 500 -

2016-06-23 17:00:41,128 4480 ERROR ? werkzeug: Error on request:

Traceback (most recent call last):

File "werkzeug\serving.py", line 177, in run_wsgi

File "werkzeug\serving.py", line 165, in execute

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\service\server.py", line 246, in app

return self.app(e, s)

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\service\wsgi_server.py", line 184, in application

return application_unproxied(environ, start_response)

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\service\wsgi_server.py", line 170, in application_unproxied

result = handler(environ, start_response)

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\http.py", line 1493, in __call__

return self.dispatch(environ, start_response)

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\http.py", line 1467, in __call__

return self.app(environ, start_wrapped)

File "werkzeug\wsgi.py", line 579, in __call__

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\http.py", line 1622, in dispatch

self.setup_db(httprequest)

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\http.py", line 1553, in setup_db

httprequest.session.db = db_monodb(httprequest)

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\http.py", line 1700, in db_monodb

dbs = db_list(True, httprequest)

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\http.py", line 1674, in db_list

dbs = openerp.service.db.list_dbs(force)

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\service\db.py", line 323, in list_dbs

with closing(db.cursor()) as cr:

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\sql_db.py", line 630, in cursor

return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\sql_db.py", line 164, in __init__

self._cnx = pool.borrow(dsn)

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\sql_db.py", line 513, in _locked

return fun(self, *args, **kwargs)

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\sql_db.py", line 581, 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?

2016-06-23 17:01:25,512 4480 INFO ? openerp.addons.bus.models.bus: Bus.loop listen imbus on db postgres

2016-06-23 17:01:27,516 4480 INFO ? openerp.sql_db: Connection to the database failed

2016-06-23 17:01:27,516 4480 ERROR ? openerp.addons.bus.models.bus: Bus.loop error, sleep and retry

Traceback (most recent call last):

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\addons\bus\models\bus.py", line 168, in run

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\addons\bus\models\bus.py", line 146, in loop

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\.\openerp\sql_db.py", line 630, in cursor

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\.\openerp\sql_db.py", line 164, in __init__

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\.\openerp\sql_db.py", line 513, in _locked

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\.\openerp\sql_db.py", line 581, in borrow

File "psycopg2\__init__.pyc", 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?

2016-06-23 17:02:17,517 4480 INFO ? openerp.addons.bus.models.bus: Bus.loop listen imbus on db postgres

2016-06-23 17:02:19,526 4480 INFO ? openerp.sql_db: Connection to the database failed

2016-06-23 17:02:19,526 4480 ERROR ? openerp.addons.bus.models.bus: Bus.loop error, sleep and retry

Traceback (most recent call last):

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\addons\bus\models\bus.py", line 168, in run

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\openerp\addons\bus\models\bus.py", line 146, in loop

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\.\openerp\sql_db.py", line 630, in cursor

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\.\openerp\sql_db.py", line 164, in __init__

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\.\openerp\sql_db.py", line 513, in _locked

File "C:\Program Files (x86)\Odoo 9.0-20160622\server\.\openerp\sql_db.py", line 581, in borrow

File "psycopg2\__init__.pyc", 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?


Please help. This is my second try and is the same. I have to be missing something or something is wrong with the installation.

Is postgres up and running? check it by using the system services tool or whatever you have on Windows :) Sorry...i'm not a Windows user.

Davide Corio
on 6/23/16, 3:05 PM

I uninstalled postgresql

then I install new postgresql-9.5.3-1-windows-x64

then I install pgadmin4-1.0-beta1

When I try to connect to the server I get this error

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?


This must be some problem with postgresql and windows, but I cant solve it because I'am very new to this.

Dimitar Jovanovski
on 6/24/16, 3:29 AM

Please consult other sources in the internet, as this is not an Odoo related question.

Ermin Trevisan
on 6/24/16, 7:43 AM

I instaled odoo on windows XP with success.

I think it is very much related because is part of installation All In one and is not working on windows 10.

Let me make one other point that maybe will help developers here

On windows 10 I turned off UAC from control panel and from registry and with this any install should be OK. Also I started install with Run As Administrator. But problem still exist on windows 10 pro.

If there is some other post with success install on windows 10 please share it wit me.

Dimitar Jovanovski
on 6/24/16, 7:53 AM
0
Krupesh Laiya
On 6/24/16, 1:56 AM

you have to uninstall the postgres and install it again and create the user for odoo. I think this will solve your problem.

Please use the version of postgres 9.3.13.


0

Ermin Trevisan

--Ermin Trevisan--
3548
| 6 3 7
Walchwil, Switzerland
--Ermin Trevisan--


Ermin Trevisan
On 6/24/16, 12:08 AM

As Davide mentioned and your traceback clearly shows, your Odoo is trying to connect to Postgres on port 5432 but it can't. So either Postgres is not up and running (for whatever reason) or your configuration is incorrect, in any case it is an installation problem.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 6/23/16, 1:11 PM
Seen: 1516 times
Last updated: 6/24/16, 7:41 AM