Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Contabilitate
Inventar
PoS
Proiect
MRP

All apps

All Posts Oameni Insigne

Etichete (View all)

odoo accounting v14 pos v15

Despre acest forum

Suport

Connection Error OpenERP 7.0 on Ubuntu 12.04 LTS?

error connection

2 Răspunsuri

9986 Vizualizări

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

Cel mai bun răspuns

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"

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Înscrie-te

Related Posts	Răspunsuri	Vizualizări
OperationalError: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" error connection	3 nov. 23	52879
Odoo 12 Connection Lost... Trying to reconnect on nginx Rezolvat error connection odoo12.0	5 mar. 22	17964
odoo.sql_db: Connection to the database failed Rezolvat error database connection	1 dec. 23	44957
?"Your country might be blocked by our hosting provider" error when I create new website error	0 oct. 25	455
Payment Page Return Error with Razorpay on Mobile Devices error	0 sept. 25	1088

Această întrebare a fost marcată

Enjoying the discussion? Don't just read, join in!