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

Postgre does not run and give an error

By
new test
on 11/11/13, 4:29 AM 1,028 views

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-20130703-231023\Server\server\openerp\addons\web\session.py\", line 89, in send\n File \"C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server\.\openerp\netsvc.py\", line 292, in dispatch_rpc\n File \"C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server\.\openerp\service\web_services.py\", line 122, in dispatch\n File \"C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server\.\openerp\service\web_services.py\", line 359, in exp_list\n File \"C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server\.\openerp\sql_db.py\", line 484, in cursor\n File \"C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server\.\openerp\sql_db.py\", line 182, in __init__\n File \"C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server\.\openerp\sql_db.py\", line 377, in _locked\n File \"C:\Program Files (x86)\OpenERP 7.0-20130703-231023\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-20130703-231023\Server\server\openerp\addons\web\http.py\", line 285, in dispatch\n File \"C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server\openerp\addons\web\controllers\main.py\", line 573, in index\n File \"C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server\openerp\addons\web\controllers\main.py\", line 98, in db_monodb_redirect\n File \"C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server\openerp\addons\web\controllers\main.py\", line 109, in db_redirect\n File \"C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server\openerp\addons\web\controllers\main.py\", line 90, in db_list\n File \"C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server\openerp\addons\web\session.py\", line 30, in proxy_method\n File \"C:\Program Files (x86)\OpenERP 7.0-20130703-231023\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-20130703-231023\\server\\server\\openerp\\addons\\web\\session.py\",="" line="" 89,="" in="" send\n="" file="" \"c:\\program="" files="" (x86)\\openerp="" 7.0-20130703-231023\\server\\server\\.\\openerp\\netsvc.py\",="" line="" 292,="" in="" dispatch_rpc\n="" file="" \"c:\\program="" files="" (x86)\\openerp="" 7.0-20130703-231023\\server\\server\\.\\openerp\\service\\web_services.py\",="" line="" 122,="" in="" dispatch\n="" file="" \"c:\\program="" files="" (x86)\\openerp="" 7.0-20130703-231023\\server\\server\\.\\openerp\\service\\web_services.py\",="" line="" 359,="" in="" exp_list\n="" file="" \"c:\\program="" files="" (x86)\\openerp="" 7.0-20130703-231023\\server\\server\\.\\openerp\\sql_db.py\",="" line="" 484,="" in="" cursor\n="" file="" \"c:\\program="" files="" (x86)\\openerp="" the="" error="" is:<="" p="">

7.0-20130703-231023\\Server\\server\\.\\openerp\\sql_db.py\", line 182, in __init__\n File \"C:\\Program Files (x86)\\OpenERP 7.0-20130703-231023\\Server\\server\\.\\openerp\\sql_db.py\", line 377, in _locked\n File \"C:\\Program Files (x86)\\OpenERP 7.0-20130703-231023\\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"}}

Can you check that your Postgres service is running ?

Tuxservices, Jeudy Nicolas
on 11/11/13, 6:09 PM
0

Jeudy Nicolas

--Jeudy Nicolas--
1181
| 6 7 8
PELOUSEY, France
--Jeudy Nicolas--

- Linux administrator - Functional guy with OpenERP - Python, html, css, javascript developer OpenERP Ready Partner

Jeudy Nicolas
On 11/13/13, 3:44 AM

Hello,

Your postgresql service doesn't run. OpenERP need postgresql to work.

Have you it working know ? If yes can you mark your question as answred and check the good answer.

no it does not work i install it with openerp 7

new test
on 11/13/13, 4:08 AM

Have you an error when you launch postgresql service ?

Tuxservices, Jeudy Nicolas
on 11/13/13, 4:20 PM

postgresql service does not work and does not give an error but when we run openerp from web page the error is:

new test
on 11/15/13, 4:59 AM

This OpenERP error say: Oups, your postgresql database is not launched ! So start your postgresql service et restart openERP. OpenERP need postgresql service. Do you know how to launch Postgresql service on your computer ?

Tuxservices, Jeudy Nicolas
on 11/15/13, 1:34 PM

if you can learn me how to launch postgresql service plz

new test
on 11/16/13, 7:53 AM

you are on windows ? linux ?

Tuxservices, Jeudy Nicolas
on 11/17/13, 6:44 AM

Use services (start -> run -> services.msc) and look for the postgresql-[version] service.

this can be usefull: http://1stopit.blogspot.fr/2011/10/how-to-start-and-stop-postgresql-on.html

Tuxservices, Jeudy Nicolas
on 11/18/13, 7:30 PM

sorry for the long time to answer you i am work on windows

new test
on 11/25/13, 9:34 AM
0
new test
On 11/13/13, 3:32 AM

yes i check the postgre service and it doesn't run

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: 11/11/13, 4:29 AM
Seen: 1028 times
Last updated: 3/16/15, 8:10 AM