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

CRM
e-Commerce
Financeiro
Inventário
PoS
Projeto
MRP

All apps

Todas as publicações Pessoas Emblemas

Marcadores (Ver tudo)

odoo accounting v14 pos v15

Sobre este fórum

Ajuda

Connection Error OpenERP 7.0 on Ubuntu 12.04 LTS?

error connection

2 Respostas

9983 Visualizações

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

Melhor resposta

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"

Está gostando da discussão? Não fique apenas lendo, participe!

Crie uma conta hoje mesmo para aproveitar os recursos exclusivos e interagir com nossa incrível comunidade!

Publicações relacionadas	Respostas	Visualizações
OperationalError: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" error connection	3 nov. 23	52873
Odoo 12 Connection Lost... Trying to reconnect on nginx Resolvido error connection odoo12.0	5 mar. 22	17959
odoo.sql_db: Connection to the database failed Resolvido error database connection	1 dez. 23	44955
?"Your country might be blocked by our hosting provider" error when I create new website error	0 out. 25	450
Payment Page Return Error with Razorpay on Mobile Devices error	0 set. 25	1084

Esta pergunta foi sinalizada

Está gostando da discussão? Não fique apenas lendo, participe!