Connection Error OpenERP 7.0 on Ubuntu 12.04 LTS?

error connection

2 Odpowiedzi

11173 Widoki

Ahmed BENOMAR

hello all, Thank you for your help I followed to the letter all procedure, except that I have a connection problem here is my log: Thank you for your help :-) my first install i followed the method on this link (theopensourcererDOTcom/2012/12/how-to-install-openerp-7-0-on-ubuntu-12-04-lts/) I know that the problem is the password of the user "openerp", but what should I put in the file openerp-server.conf? and what to put in the connection file postgresql?

2013-07-31 20:42:21,392 2311 ERROR ? openerp.sql_db: Connection to the database failed Traceback (most recent call last): File "/opt/openerp/server/openerp/sql_db.py", line 440, in borrow result = psycopg2.connect(dsn=dsn, connection_factory=PsycoConnection) File "/usr/lib/python2.7/dist-packages/psycopg2/__init__.py", line 179, in connect connection_factory=connection_factory, async=async) OperationalError: FATAL: password authentication failed for user "openerp" 2013-07-31 20:42:21,393 2311 ERROR ? openerp.netsvc: FATAL: password authentication failed for user "openerp" Traceback (most recent call last): File "/opt/openerp/server/openerp/netsvc.py", line 292, in dispatch_rpc result = ExportService.getService(service_name).dispatch(method, params) File "/opt/openerp/server/openerp/service/web_services.py", line 122, in dispatch return fn(params) File "/opt/openerp/server/openerp/service/web_services.py", line 359, in exp_list cr = db.cursor() File "/opt/openerp/server/openerp/sql_db.py", line 484, in cursor return Cursor(self._pool, self.dbname, serialized=serialized) File "/opt/openerp/server/openerp/sql_db.py", line 182, in __init__ self._cnx = pool.borrow(dsn(dbname)) File "/opt/openerp/server/openerp/sql_db.py", line 377, in _locked return fun(self, args, *kwargs) File "/opt/openerp/server/openerp/sql_db.py", line 440, in borrow result = psycopg2.connect(dsn=dsn, connection_factory=PsycoConnection) File "/usr/lib/python2.7/dist-packages/psycopg2/__init__.py", line 179, in connect connection_factory=connection_factory, async=async) OperationalError: FATAL: password authentication failed for user "openerp" 2013-07-31 20:42:21,397 2311 INFO ? werkzeug: 192.168.1.11 - - [31/Jul/2013 20:42:21] "GET / HTTP/1.1" 500 -

Xsias

Najlepsza odpowiedź

In your openerp-server.conf : db_host = False db_port = False db_user = openerp db_password = False

But in the file here : yourinstance/scripts/config/yourfile.cfg You must specify : db_user = openerp and db_password = YourPostgreSQLPwd

When you have create the openerp postgresql user, you have put a password. It's that password you need in yourfile.cfg

After that, you can run the server with this command (when you are on the yourinstace folder) : ./openobject-server/openerp-server -c ./scripts/config/yourfile.cfg

EDIT by Amit Parik (amp)

Have you create the superuser on the postgres same as your system user (openerp).

As per your traceback you have to create superuser as openerp and go to template1 db then alter the role.

Ahmed BENOMAR

Autor

thank you for your back, but I can not find the file .cfg or folder scripts. And I do not have the folder "Openobject-server"

Amit Parik (amp)

Have you create the superuser on the postgres same as your system user (openerp).

Amit Parik (amp)

As per your traceback you have to create superuser as openerp and go to template1 db then alter the role.

Ahmed BENOMAR

Autor

thank's for all answer, it was the superuser roll it's working now

Xsias

I will edit my answer to include this part.

Ahmed BENOMAR

Autor

thank you for your back, but I can not find the file .cfg or folder scripts. And I do not have the folder "Openobject-server"

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
OperationalError: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" error connection	3 lis 23	54512
Odoo 12 Connection Lost... Trying to reconnect on nginx Rozwiązane error connection odoo12.0	5 mar 22	19654
odoo.sql_db: Connection to the database failed Rozwiązane error database connection	1 gru 23	47157
Problème 500 : Internal Server ERROR error	1 maj 26	1912
?"Your country might be blocked by our hosting provider" error when I create new website error	0 lis 25	595

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!