This question has been flagged
1 Reply
3481 Views

i am a new user for open erp. after i install openerp on windos server 2008 it display follow error massage.. please help me to solve 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-20131016-232725\Server\server\openerp\addons\web\session.py\", line 89, in send\n File \"C:\Program Files (x86)\OpenERP 7.0-20131016-232725\Server\server\.\openerp\netsvc.py\", line 292, in dispatch_rpc\n File \"C:\Program Files (x86)\OpenERP 7.0-20131016-232725\Server\server\.\openerp\service\web_services.py\", line 122, in dispatch\n File \"C:\Program Files (x86)\OpenERP 7.0-20131016-232725\Server\server\.\openerp\service\web_services.py\", line 359, in exp_list\n File \"C:\Program Files (x86)\OpenERP 7.0-20131016-232725\Server\server\.\openerp\sql_db.py\", line 484, in cursor\n File \"C:\Program Files (x86)\OpenERP 7.0-20131016-232725\Server\server\.\openerp\sql_db.py\", line 182, in __init__\n File \"C:\Program Files (x86)\OpenERP 7.0-20131016-232725\Server\server\.\openerp\sql_db.py\", line 377, in _locked\n File \"C:\Program Files (x86)\OpenERP 7.0-20131016-232725\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-20131016-232725\Server\server\openerp\addons\web\http.py\", line 285, in dispatch\n File \"C:\Program Files (x86)\OpenERP 7.0-20131016-232725\Server\server\openerp\addons\web\controllers\main.py\", line 573, in index\n File \"C:\Program Files (x86)\OpenERP 7.0-20131016-232725\Server\server\openerp\addons\web\controllers\main.py\", line 98, in db_monodb_redirect\n File \"C:\Program Files (x86)\OpenERP 7.0-20131016-232725\Server\server\openerp\addons\web\controllers\main.py\", line 109, in db_redirect\n File \"C:\Program Files (x86)\OpenERP 7.0-20131016-232725\Server\server\openerp\addons\web\controllers\main.py\", line 90, in db_list\n File \"C:\Program Files (x86)\OpenERP 7.0-20131016-232725\Server\server\openerp\addons\web\session.py\", line 30, in proxy_method\n File \"C:\Program Files (x86)\OpenERP 7.0-20131016-232725\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-20131016-232725\\\\server\\\\server\\\\openerp\\\\addons\\\\web\\\\session.py\",="" line="" 89,="" in="" send\\n="" file="" \"c:\\\\program="" files="" (x86)\\\\openerp="" 7.0-20131016-232725\\\\server\\\\server\\\\.\\\\openerp\\\\netsvc.py\",="" line="" 292,="" in="" dispatch_rpc\\n="" file="" \"c:\\\\program="" files="" (x86)\\\\openerp="" 7.0-20131016-232725\\\\server\\\\server\\\\.\\\\openerp\\\\service\\\\web_services.py\",="" line="" 122,="" in="" dispatch\\n="" file="" \"c:\\\\program="" files="" (x86)\\\\openerp="" 7.0-20131016-232725\\\\server\\\\server\\\\.\\\\openerp\\\\service\\\\web_services.py\",="" line="" 359,="" in="" exp_list\\n="" file="" \"c:\\\\program="" files="" (x86)\\\\openerp="" 7.0-20131016-232725\\\\server\\\\server\\\\.\\\\openerp\\\\sql_db.py\",="" line="" 484,="" in="" cursor\\n="" file="" \"c:\\\\program="" files="" (x86)\\\\openerp="" 7.0-20131016-232725\\\\server\\\\server\\\\.\\\\openerp\\\\sql_db.py\",="" line="" 182,="" in="" __init__\\n="" file="" \"c:\\\\program="" files="" (x86)\\\\openerp="" 7.0-20131016-232725\\\\server\\\\server\\\\.\\\\openerp\\\\sql_db.py\",="" line="" 377,="" in="" _locked\\n="" file="" \"c:\\\\program="" files="" (x86)\\\\openerp="" 7.0-20131016-232725\\\\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
Best Answer

It appears that you don't have your SQL server running. Open a command line and do:

netstat -an -p TCP

You should see a line that says: TCP 0.0.0.0:5432 0.0.0.0 LISTENING

You will need to start your SQL server and then you should see that line, indicating that it is listening for incoming connections from OpenERP.

Avatar
Discard