Skip to Content
This question has been flagged
12 Replies
62600 Views
Avatar
Katona Tamás

Hello everyone,

I am new at OpenERP and I just installed OpenERP 7.0 on Windows7 x64 using the "openerp-allinone-setup-7.0-latest.exe" All-In-One file. But when I tried to open it it gave me this error message:

Internal Server Error {"message": "OpenERP Server Error", "code": 200, "data": {"debug": "Server Traceback (most recent call last):\n File \"C:\Program Files (x86)\OpenERP 7.0-20130705-231024\Server\server\openerp\addons\web\session.py\", line 89, in send\n File \"C:\Program Files (x86)\OpenERP 7.0-20130705-231024\Server\server\.\openerp\netsvc.py\", line 292, in dispatch_rpc\n File \"C:\Program Files (x86)\OpenERP 7.0-20130705-231024\Server\server\.\openerp\service\web_services.py\", line 122, in dispatch\n File \"C:\Program Files (x86)\OpenERP 7.0-20130705-231024\Server\server\.\openerp\service\web_services.py\", line 359, in exp_list\n File \"C:\Program Files (x86)\OpenERP 7.0-20130705-231024\Server\server\.\openerp\sql_db.py\", line 484, in cursor\n File \"C:\Program Files (x86)\OpenERP 7.0-20130705-231024\Server\server\.\openerp\sql_db.py\", line 182, in __init__\n File \"C:\Program Files (x86)\OpenERP 7.0-20130705-231024\Server\server\.\openerp\sql_db.py\", line 377, in _locked\n File \"C:\Program Files (x86)\OpenERP 7.0-20130705-231024\Server\server\.\openerp\sql_db.py\", line 440, in borrow\n File \"psycopg2\__init__.pyc\", line 178, in connect\nOperationalError: could not connect to server: Connection refused (0x0000274D/10061)\n\tIs the server running on host \"localhost\" (::1) and accepting\n\tTCP/IP connections on port 5432?\ncould not connect to server: Connection refused (0x0000274D/10061)\n\tIs the server running on host \"localhost\" (127.0.0.1) and accepting\n\tTCP/IP connections on port 5432?\n\n\nClient Traceback (most recent call last):\n File \"C:\Program Files (x86)\OpenERP 7.0-20130705-231024\Server\server\openerp\addons\web\http.py\", line 285, in dispatch\n File \"C:\Program Files (x86)\OpenERP 7.0-20130705-231024\Server\server\openerp\addons\web\controllers\main.py\", line 573, in index\n File \"C:\Program Files (x86)\OpenERP 7.0-20130705-231024\Server\server\openerp\addons\web\controllers\main.py\", line 98, in db_monodb_redirect\n File \"C:\Program Files (x86)\OpenERP 7.0-20130705-231024\Server\server\openerp\addons\web\controllers\main.py\", line 109, in db_redirect\n File \"C:\Program Files (x86)\OpenERP 7.0-20130705-231024\Server\server\openerp\addons\web\controllers\main.py\", line 90, in db_list\n File \"C:\Program Files (x86)\OpenERP 7.0-20130705-231024\Server\server\openerp\addons\web\session.py\", line 30, in proxy_method\n File \"C:\Program Files (x86)\OpenERP 7.0-20130705-231024\Server\server\openerp\addons\web\session.py\", line 103, in send\nFault: <fault could="" not="" connect="" to="" server:="" connection="" refused="" (0x0000274d="" 10061)\n\tis="" the="" server="" running="" on="" host="" \"localhost\"="" (::1)="" and="" accepting\n\ttcp="" ip="" connections="" on="" port="" 5432?\ncould="" not="" connect="" to="" server:="" connection="" refused="" (0x0000274d="" 10061)\n\tis="" the="" server="" running="" on="" host="" \"localhost\"="" (127.0.0.1)="" and="" accepting\n\ttcp="" ip="" connections="" on="" port="" 5432?\n:="" 'traceback="" (most="" recent="" call="" last):\\n="" file="" \"c:\\\\program="" files="" (x86)\\\\openerp="" 7.0-20130705-231024\\\\server\\\\server\\\\openerp\\\\addons\\\\web\\\\session.py\",="" line="" 89,="" in="" send\\n="" file="" \"c:\\\\program="" files="" (x86)\\\\openerp="" 7.0-20130705-231024\\\\server\\\\server\\\\.\\\\openerp\\\\netsvc.py\",="" line="" 292,="" in="" dispatch_rpc\\n="" file="" \"c:\\\\program="" files="" (x86)\\\\openerp="" 7.0-20130705-231024\\\\server\\\\server\\\\.\\\\openerp\\\\service\\\\web_services.py\",="" line="" 122,="" in="" dispatch\\n="" file="" \"c:\\\\program="" files="" (x86)\\\\openerp="" 7.0-20130705-231024\\\\server\\\\server\\\\.\\\\openerp\\\\service\\\\web_services.py\",="" line="" 359,="" in="" exp_list\\n="" file="" \"c:\\\\program="" files="" (x86)\\\\openerp="" 7.0-20130705-231024\\\\server\\\\server\\\\.\\\\openerp\\\\sql_db.py\",="" line="" 484,="" in="" cursor\\n="" file="" \"c:\\\\program="" files="" (x86)\\\\openerp="" 7.0-20130705-231024\\\\server\\\\server\\\\.\\\\openerp\\\\sql_db.py\",="" line="" 182,="" in="" __init__\\n="" file="" \"c:\\\\program="" files="" (x86)\\\\openerp="" 7.0-20130705-231024\\\\server\\\\server\\\\.\\\\openerp\\\\sql_db.py\",="" line="" 377,="" in="" _locked\\n="" file="" \"c:\\\\program="" files="" (x86)\\\\openerp="" 7.0-20130705-231024\\\\server\\\\server\\\\.\\\\openerp\\\\sql_db.py\",="" line="" 440,="" in="" borrow\\n="" file="" \"psycopg2\\\\__init__.pyc\",="" line="" 178,="" in="" connect\\noperationalerror:="" could="" not="" connect="" to="" server:="" connection="" refused="" (0x0000274d="" 10061)\\n\\tis="" the="" server="" running="" on="" host="" \"localhost\"="" (::1)="" and="" accepting\\n\\ttcp="" ip="" connections="" on="" port="" 5432?\\ncould="" not="" connect="" to="" server:="" connection="" refused="" (0x0000274d="" 10061)\\n\\tis="" the="" server="" running="" on="" host="" \"localhost\"="" (127.0.0.1)="" and="" accepting\\n\\ttcp="" ip="" connections="" on="" port="" 5432?\\n\\n'="">\n", "fault_code": "could not connect to server: Connection refused (0x0000274D/10061)\n\tIs the server running on host \"localhost\" (::1) and accepting\n\tTCP/IP connections on port 5432?\ncould not connect to server: Connection refused (0x0000274D/10061)\n\tIs the server running on host \"localhost\" (127.0.0.1) and accepting\n\tTCP/IP connections on port 5432?\n", "type": "server_exception"}}

openerp-server.log:

2013-07-06 20:03:04,549 4648 INFO ? openerp: OpenERP version 7.0-20130705-231024 2013-07-06 20:03:04,549 4648 INFO ? openerp: addons paths: C:\Program Files (x86)\OpenERP 7.0-20130705-231024\Server\server\openerp\addons 2013-07-06 20:03:04,549 4648 INFO ? openerp: database hostname: localhost 2013-07-06 20:03:04,549 4648 INFO ? openerp: database port: 5432 2013-07-06 20:03:04,549 4648 INFO ? openerp: database user: openpg 2013-07-06 20:03:35,075 5616 INFO ? openerp: OpenERP version 7.0-20130705-231024 2013-07-06 20:03:35,075 5616 INFO ? openerp: addons paths: C:\Program Files (x86)\OpenERP 7.0-20130705-231024\Server\server\openerp\addons 2013-07-06 20:03:35,075 5616 INFO ? openerp: database hostname: localhost 2013-07-06 20:03:35,075 5616 INFO ? openerp: database port: 5432 2013-07-06 20:03:35,075 5616 INFO ? openerp: database user: openpg 2013-07-06 20:03:35,470 5616 INFO ? openerp: OpenERP server is running, waiting for connections... 2013-07-06 20:03:35,471 5616 INFO ? openerp.service.wsgi_server: HTTP service (werkzeug) running on 0.0.0.0:8069 2013-07-06 20:03:40,167 2528 INFO ? openerp: OpenERP version 7.0-20130705-231024 2013-07-06 20:03:40,167 2528 INFO ? openerp: addons paths: C:\Program Files (x86)\OpenERP 7.0-20130705-231024\Server\server\openerp\addons 2013-07-06 20:03:40,167 2528 INFO ? openerp: database hostname: localhost 2013-07-06 20:03:40,167 2528 INFO ? openerp: database port: 5432 2013-07-06 20:03:40,167 2528 INFO ? openerp: database user: openpg 2013-07-06 20:03:40,313 2528 INFO ? openerp: OpenERP server is running, waiting for connections... 2013-07-06 20:03:40,315 2528 INFO ? openerp.service.wsgi_server: HTTP service (werkzeug) running on 0.0.0.0:8069 2013-07-06 20:07:59,907 2528 ERROR ? openerp.sql_db: Connection to the database failed Traceback (most recent call last): File "C:\Program Files (x86)\OpenERP 7.0-20130705-231024\Server\server.\openerp\sql_db.py", line 440, in borrow File "psycopg2__init__.pyc", line 178, 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? 2013-07-06 20:07:59,907 2528 ERROR ? openerp.netsvc: 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? Traceback (most recent call last): File "C:\Program Files (x86)\OpenERP 7.0-20130705-231024\Server\server.\openerp\netsvc.py", line 292, in dispatch_rpc File "C:\Program Files (x86)\OpenERP 7.0-20130705-231024\Server\server.\openerp\service\web_services.py", line 122, in dispatch File "C:\Program Files (x86)\OpenERP 7.0-20130705-231024\Server\server.\openerp\service\web_services.py", line 359, in exp_list File "C:\Program Files (x86)\OpenERP 7.0-20130705-231024\Server\server.\openerp\sql_db.py", line 484, in cursor File "C:\Program Files (x86)\OpenERP 7.0-20130705-231024\Server\server.\openerp\sql_db.py", line 182, in __init__ File "C:\Program Files (x86)\OpenERP 7.0-20130705-231024\Server\server.\openerp\sql_db.py", line 377, in _locked File "C:\Program Files (x86)\OpenERP 7.0-20130705-231024\Server\server.\openerp\sql_db.py", line 440, in borrow File "psycopg2__init__.pyc", line 178, 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? 2013-07-06 20:08:00,427 2528 INFO ? werkzeug: 127.0.0.1 - - [06/Jul/2013 20:08:00] "GET / HTTP/1.1" 500 - 2013-07-06 20:08:00,509 2528 INFO ? werkzeug: 127.0.0.1 - - [06/Jul/2013 20:08:00] "GET /favicon.ico HTTP/1.1" 404 -

What is going wrong and how can I fix it?

Thanks!

Avatar
Discard
OSCAR QUINTERO

Don´t Work.

MANOP PORNPEANVICHANON

I have same proplem. I reinstall the program at "C:\Program\OpenERP7", it work!!!

Isnawan Aslam

I reinstall many times, but don't work

Avatar
sridhar
Best Answer

I think database(postgres) service is stopped u start the server, it wil work. Goto service and select the postgresql, select that and start it.

Avatar
Discard
Jose Luis Fernandez

How has you configured the postgresql service to log on with your account openpgsvc? How have you changed login with any account and to interact with the desktop?

odimegwu david

Windows 7 > Control Panel > System & Security > Administrative tools > Services > PostGreSqlForOpenERP > Properties (right-click) > Log on > Log on as local system account (!don't interact with desktop, annoying). Test it with Postgresql app, PgAdmin III. Pronto! Try your browser: localhost:8069. OpenERP client comes up

Jose Luis Fernandez

Thank you very much, but PostGreSqlForOpenERP is not present in services.

Zoltán

Same here on Win8 PostGreSqlForOpenERP is not present in services.

odimegwu david

use the all-in-one installer. It will install postgresql server and services automatically.

Zoltán

I did use the all in one installer.

sridhar

check your service postgresql.

Björn Lindblom

I also have the same problem in win 8(all in one installer), postgresql service not started(and very poor or non-existing instructions how to start it manually), is there anyone who can tell if this doesn't work with win 8 at all or what actions need to be taken?!? Have installed on 2 win 7 machines, first no problem, second worked after reinstallation, win 8 I've tried to reinstall 3 times turning of firewalls etc. same problem still!!!

Isnawan Aslam

No PostGreSqlForOpenERP is present in services.

Avatar
patrick
Best Answer

ON Ubuntu, this error means the user openerp does not have a role/user within openERP. Just add the role openerp to postgresql.

Avatar
Discard
Ana María

How to add????

Avatar
Martín Echegaray
Best Answer

Try installing openerp + postgre folders in a different folder (not in C:\ Program files). For example: C:\OpenERP. It worked for me.

Avatar
Discard
Avatar
odimegwu david
Best Answer

I have the same problem. I went to service and saw that openerp server is already started. I tried starting postgresql and it gives this response: server could not start on local computer. Error 1069: the service did not start due to a local logon failure.

Avatar
Discard
Julio Hoyos

Soy de Peru, me paso lo mismo w7 64bits con el instalador que baje de la pagina oficial, revisando el EventViewer de windows, daba este error: postgres no pudo examinar el archivo de configuraci�n �C:/Program Files (x86)/OpenERP 7.0-20130706-231041/PostgreSQL/data/postgresql.conf�: No such file or directory. Revisando la ruta del archivo no estaba, por eso no podia levantar el servicio. Solucion: desinstale desde el propio windows openerp completo incluyendo postgres, borre la carpeta de instalacion y me baje: http://nightly.openerp.com/7.0/nightly/exe/

Jose Luis Fernandez

¿Cómo desinstalas el openerp? He hecho lo mismo y me ha vuelto a dar error. Gracias.

Avatar
Cody Hammond
Best Answer

The problem is solved. rests with the opengpsvc user account created for me by openerp on my windows machine. the postgresql service was configured to log on with openpgsvc account. i changed to log on with any account and to interact with the desktop

Avatar
Discard
Avatar
Conor McNamara
Best Answer

I have the problem with Odoo V8 and OpenERP V7 on Windows 7 64bits. I tried all the tips exposed in this post but these not fix the problem. Any solution?

Does anybody test at OpenERP before putting online a new version? Wher is the documentation for v8?

Avatar
Discard
Avatar
Subhash
Best Answer

When I am install OpenERP 7.1 and PostgreSQL 9.2.8 in windows 7..........................

I have successfully installed but when click on url of OpenERP then got problem.... please help me if you know solution of this problem..........

Internal Server Error

{"message": "OpenERP Server Error", "code": 200, "data": {"debug": "Server Traceback (most recent call last):\n File \"C:\\Program Files (x86)\\OpenERP 7.0-20140622-231040\\Server\\server\\openerp\\addons\\web\\session.py\", line 89, in send\n File \"C:\\Program Files (x86)\\OpenERP 7.0-20140622-231040\\Server\\server\\.\\openerp\\netsvc.py\", line 296, in dispatch_rpc\n File \"C:\\Program Files (x86)\\OpenERP 7.0-20140622-231040\\Server\\server\\.\\openerp\\service\\web_services.py\", line 122, in dispatch\n File \"C:\\Program Files (x86)\\OpenERP 7.0-20140622-231040\\Server\\server\\.\\openerp\\service\\web_services.py\", line 359, in exp_list\n File \"C:\\Program Files (x86)\\OpenERP 7.0-20140622-231040\\Server\\server\\.\\openerp\\sql_db.py\", line 484, in cursor\n File \"C:\\Program Files (x86)\\OpenERP 7.0-20140622-231040\\Server\\server\\.\\openerp\\sql_db.py\", line 182, in __init__\n File \"C:\\Program Files (x86)\\OpenERP 7.0-20140622-231040\\Server\\server\\.\\openerp\\sql_db.py\", line 377, in _locked\n File \"C:\\Program Files (x86)\\OpenERP 7.0-20140622-231040\\Server\\server\\.\\openerp\\sql_db.py\", line 440, in borrow\n File \"psycopg2\\__init__.pyc\", line 178, in connect\nOperationalError: FATAL: password authentication failed for user \"openpg\"\n\n\nClient Traceback (most recent call last):\n File \"C:\\Program Files (x86)\\OpenERP 7.0-20140622-231040\\Server\\server\\openerp\\addons\\web\\http.py\", line 285, in dispatch\n File \"C:\\Program Files (x86)\\OpenERP 7.0-20140622-231040\\Server\\server\\openerp\\addons\\web\\controllers\\main.py\", line 570, in index\n File \"C:\\Program Files (x86)\\OpenERP 7.0-20140622-231040\\Server\\server\\openerp\\addons\\web\\controllers\\main.py\", line 98, in db_monodb_redirect\n File \"C:\\Program Files (x86)\\OpenERP 7.0-20140622-231040\\Server\\server\\openerp\\addons\\web\\controllers\\main.py\", line 109, in db_redirect\n File \"C:\\Program Files (x86)\\OpenERP 7.0-20140622-231040\\Server\\server\\openerp\\addons\\web\\controllers\\main.py\", line 90, in db_list\n File \"C:\\Program Files (x86)\\OpenERP 7.0-20140622-231040\\Server\\server\\openerp\\addons\\web\\session.py\", line 30, in proxy_method\n File \"C:\\Program Files (x86)\\OpenERP 7.0-20140622-231040\\Server\\server\\openerp\\addons\\web\\session.py\", line 103, in send\nFault: <Fault FATAL: password authentication failed for user \"openpg\"\n: 'Traceback (most recent call last):\\n File \"C:\\\\Program Files (x86)\\\\OpenERP 7.0-20140622-231040\\\\Server\\\\server\\\\openerp\\\\addons\\\\web\\\\session.py\", line 89, in send\\n File \"C:\\\\Program Files (x86)\\\\OpenERP 7.0-20140622-231040\\\\Server\\\\server\\\\.\\\\openerp\\\\netsvc.py\", line 296, in dispatch_rpc\\n File \"C:\\\\Program Files (x86)\\\\OpenERP 7.0-20140622-231040\\\\Server\\\\server\\\\.\\\\openerp\\\\service\\\\web_services.py\", line 122, in dispatch\\n File \"C:\\\\Program Files (x86)\\\\OpenERP 7.0-20140622-231040\\\\Server\\\\server\\\\.\\\\openerp\\\\service\\\\web_services.py\", line 359, in exp_list\\n File \"C:\\\\Program Files (x86)\\\\OpenERP 7.0-20140622-231040\\\\Server\\\\server\\\\.\\\\openerp\\\\sql_db.py\", line 484, in cursor\\n File \"C:\\\\Program Files (x86)\\\\OpenERP 7.0-20140622-231040\\\\Server\\\\server\\\\.\\\\openerp\\\\sql_db.py\", line 182, in __init__\\n File \"C:\\\\Program Files (x86)\\\\OpenERP 7.0-20140622-231040\\\\Server\\\\server\\\\.\\\\openerp\\\\sql_db.py\", line 377, in _locked\\n File \"C:\\\\Program Files (x86)\\\\OpenERP 7.0-20140622-231040\\\\Server\\\\server\\\\.\\\\openerp\\\\sql_db.py\", line 440, in borrow\\n File \"psycopg2\\\\__init__.pyc\", line 178, in connect\\nOperationalError: FATAL: password authentication failed for user \"openpg\"\\n\\n'>\n", "fault_code": "FATAL: password authentication failed for user \"openpg\"\n", "type": "server_exception"}}

Avatar
Discard
Avatar
Peter Vroegindewey
Best Answer

I had the same problem ({"message": "OpenERP Server Error"............."FATAL: password authentication failed for user \"openpg\"\n)  after default windows intall. In the pgAdmin PostgreSQL tool I added a Login Role with "openpg" and "openpgpwd" as name and password, gave it all authority and the OpenERP website opens as it should. :)

Avatar
Discard
Avatar
Poojan Vasudev
Best Answer

I have Windows 8. I was getting the same internal server error. Uninstalled the program and installed in a seperate folder: C:\OpenERP7

It works fine.

Avatar
Discard
Avatar
Suthan
Best Answer

Hi, I recently had the same problem. It may be because you have installed and uninstalled PostgreSQL 9.x or openerp before.

The PostgreSQL 9.x uninstaller does not cleanup the registry keys in the same fashion as the 8.3 did, and the following keys remains after a complete uninstall:

  • HKLM\Software\PostgreSQL

    +- HKLM\Software\PostgreSQL\Installations

    +- HKLM\Software\PostgreSQL\Services

So, in order to solve the problem, we just have to delete this entries manually.Open regedit, find these entries mentioned above ,delete it , and then try reinstalling again.

Avatar
Discard
Avatar
visualplan
Best Answer

where active service console using postgres ubuntu

Avatar
Discard
Avatar
klacus
Best Answer

The problem is here:

": Connection refused (0x0000274D/10061)\n\tIs the server running on host \"localhost\" (::1) and accepting\n\tTCP/IP connections on port 5432?\ncould not connect to server: Connection refused (0x0000274D/10061)\n\tIs the server running on host "

So u must set the postgres from the begining.

See this.: https://doc.openerp.com/v7.0/install/windows/postgres/

May you can use Linux with Virtualbox...

Cheers.

L.

 

 

 

 

Avatar
Discard