This question has been flagged
3 Replies
3480 Views
Avatar
Fernando Gómez Bórquez

Well, my professor ask me to install OpenERP and I did it (Version 7) on Windows 8 64 bits and Mozilla Firefox send me this messege (I tried in Explorer as well). PLEASE HELP ME! My grades depends on this! 

 

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

Avatar
Discard
Avatar
Grover Menacho
Best Answer

You've to check your postgresql status. It seems that it's not allowing you to connect to database. Maybe your firewall? You have to check it. Because usually firewall blocks everything so you have to enable port 5432 on your firewall

Avatar
Discard
Avatar
ThackerS (ts)
Best Answer

Dear fernando

openerp system user can not connect to postgresql server. As you are a beginner, i recommend you to follow those steps bellow :

  1. Uninstall openerp server, openerp client and your postgresql server.
  2. Restarted your computer
  3. Download openerp all-in-one for windows platform
  4. Sees this video : http://www.youtube.com/watch?v=n6nDy8r4Tcc

Best regards.

Avatar
Discard
Avatar
Ben Bernard
Best Answer

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

I looks like postgresql server is not run yet. In Windows, if you use allinone installer, postgresql is available via windows services. Press Win+R. Enter "services.msc". Find in Name column string like "postgresql-9.2 - PostgreSQL Server 9.2". Double click it and then click the "Start" button. Now, postgresql is running. In the services dialog openerp service should be there too. You, can restart openerp service from there.

Avatar
Discard