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.

1

Internal Server Error right after installation of OpenERP 7.0 (Win7 x64)

By
Katona Tamás
on 7/6/13, 5:05 PM 43,860 views

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!

Don´t Work.

OSCAR QUINTERO
on 1/5/14, 1:32 PM

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

MANOP PORNPEANVICHANON
on 2/15/14, 4:30 AM

I reinstall many times, but don't work

Isnawan Aslam
on 3/28/14, 10:29 PM
1

patrick

--patrick--
1958
| 5 4 7
Baarn, Netherlands
--patrick--
patrick
On 7/8/13, 3:39 PM

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

How to add????

Ana María
on 10/30/13, 7:25 AM
1
sridhar
On 7/8/13, 12:05 AM

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.

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?

Jose Luis Fernandez
on 7/10/13, 6:49 AM

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

odimegwu david
on 7/11/13, 6:23 AM

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

Jose Luis Fernandez
on 7/13/13, 2:56 PM

Same here on Win8 PostGreSqlForOpenERP is not present in services.

Zoltán
on 7/23/13, 8:52 PM

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

odimegwu david
on 7/24/13, 6:35 AM

I did use the all in one installer.

Zoltán
on 9/6/13, 11:32 AM

check your service postgresql.

sridhar
on 9/6/13, 11:46 AM

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!!!

Björn Lindblom
on 9/12/13, 11:16 AM

No PostGreSqlForOpenERP is present in services.

Isnawan Aslam
on 3/28/14, 10:33 PM
0
Cody Hammond
On 6/11/14, 11:56 AM

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

0
Conor McNamara
On 9/23/14, 11:10 AM

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?

0
klacus
On 5/15/14, 12:44 AM

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.

 

 

 

 

0
visualplan
On 8/5/14, 6:18 PM

where active service console using postgres ubuntu

0
odimegwu david
On 7/8/13, 1:47 PM

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.

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/

Julio Hoyos
on 7/8/13, 2:02 PM

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

Jose Luis Fernandez
on 7/9/13, 9:23 AM
0
Subhash
On 7/12/14, 2:49 AM

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"}}

0
Martín Echegaray
On 8/30/14, 2:15 AM

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

0
Poojan Vasudev
On 7/23/14, 12:09 AM

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.

0
Suthan
On 4/25/14, 2:11 AM

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.

0
Peter Vroegindewey
On 7/17/14, 8:00 AM

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. :)

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

6 follower(s)

Stats

Asked: 7/6/13, 5:05 PM
Seen: 43860 times
Last updated: 6/23/15, 7:20 PM