OperationalError: fe_sendauth: no password supplied

[fooflare]

OpenERP 6.1-dev in Ubuntu10.10 64 bits

When I try to connect to the server appears this Traceback:

[2011-02-08 16:53:52,911][template1] ERROR:db.connection_pool:Connection to the database failed
Traceback (most recent call last):
  File "/home/amosoviedo/openerp6-trunk/openobject-server/openerp/sql_db.py", line 303, in borrow
    result = psycopg2.connect(dsn=dsn, connection_factory=PsycoConnection)
OperationalError: fe_sendauth: no password supplied

My configuration file is the same as when I executed the server from bin directory (I changed the path to addons, that is my unique change in config file). The configuration file is loaded correctly, I see the parameters at start of server. It appeared with the new executable in root intallation openerp server.

Thanks

[OpenBMS JSC (openbmsjsc)]

This should be critical as it stops all testing. I think this is a regression error introduced by the latest refactoring/enhancements.
I have noticed several times that check-ins without thoroughly regression tests introduce critical issues into the trunk. Maybe it's a time to think about adding such regression checking into the automatic build server that will automatically log issues/bugs if a check-ins fails (continuous integration at a more frequent level).

[OpenBMS JSC (openbmsjsc)]

work around (while waiting for bug confirmation and fix): roll back to r3350 (launchpad_translations_on_behalf_of_openerp-20110208043554-9906z613ss1lyfct)

[fooflare (fooflare)]

Hi Phong,

thank you very much for your help

[OpenBMS JSC (openbmsjsc)]

Any activity to address this issue? It looks like an regression introduced when performing code refactoring between r3350 (launchpad_translations_on_behalf_of_openerp-20110208043554-9906z613ss1lyfct) and the trunk version

[Azazahmed Saiyed (OpenERP) (saz-openerp)]

Hello Amos,

I have tested the same at my end with the latest code of trunk version and not able to find such traceback. Would you please give me the status of this bug at your end. So we can proceed further.

Waiting for your reply.

Thanks.

[fooflare (fooflare)]

Hello Azazahmed,

I don't know what is the problem, when I try starting the server, the parameter database user is correct, but not the password (I checked that the password is correct connecting manually to the postgres server), I am starting to think that the problem is with postgres configuration, but I have the same conf as in 6.0.1 version and works perfect. I tried even to download the full code again and I have the same traceback. I attach my configurations from openerp server and pg_hba.conf.

If all for you is working well, don't worry, I will investigate the problem because It has to be mine. If you don't see nothing wrong then close the issue.

Thanks.

[Azazahmed Saiyed (OpenERP) (saz-openerp)]

Hello Amos,

I have checked the configuration file send by you and it looks normal. I am not able to get the traceback with it also. You can check again the actual parameters with the config parameters and also refer https://bugs.launchpad.net/openobject-server/+bug/700814.

For now I am closing this bug and you can reopen it with the more precise point for reproducing it.

Thanks for your participation.

[fooflare (fooflare)]

Hello again,

I am sorry, I have a new question about this issue, I have tried with ident and trust option in postgres configuration and I have no problem, I get this issue just when I use md5 connection.

This is what I get in sql_db.py in 302 line:

the user you can see in this line is my system user, not my db_user in openerp-server.conf.

user=amosoviedo dbname=template1
[2011-02-23 10:27:05,802][template1] ERROR:db.connection_pool:Connection to the database failed
Traceback (most recent call last):
  File "/home/amosoviedo/openerp6-trunk/openobject-server/openerp/sql_db.py", line 304, in borrow
    result = psycopg2.connect(dsn=dsn, connection_factory=PsycoConnection)
OperationalError: fe_sendauth: no password supplied

This is the log when I start the server:

[2011-02-23 10:27:02,116][?] INFO:server:OpenERP version - 6.1-dev
[2011-02-23 10:27:02,117][?] INFO:server:addons_path - /home/amosoviedo/openerp6-trunk/openobject-addons
[2011-02-23 10:27:02,118][?] INFO:server:database hostname - localhost
[2011-02-23 10:27:02,118][?] INFO:server:database port - 5432
[2011-02-23 10:27:02,119][?] INFO:server:database user - openuser
[2011-02-23 10:27:02,119][?] INFO:server:initialising distributed objects services
[2011-02-23 10:27:02,145][?] INFO:web-services:starting HTTP service at 0.0.0.0 port 8069
[2011-02-23 10:27:02,147][?] INFO:web-services:starting HTTPS service at 0.0.0.0 port 8071
[2011-02-23 10:27:02,147][?] INFO:web-services:Registered XML-RPC over HTTP
[2011-02-23 10:27:02,149][?] INFO:web-services:starting NET-RPC service at 0.0.0.0 port 8070
[2011-02-23 10:27:02,150][?] INFO:server:Starting 3 services
[2011-02-23 10:27:02,153][?] INFO:server:OpenERP server is running, waiting for connections...

as you see my db_user is openuser. I am lost at all

Thanks and regards.

[OpenBMS JSC (openbmsjsc)]

I have experienced the same problem. I guess unless there is a change in the configuration files of openerp-server, if the configuration file works with r3350 (launchpad_translations_on_behalf_of_openerp-20110208043554-9906z613ss1lyfct) and not the following versions (where big refactoring happens) then it's likely that the problem is in the code and not in the configuration files.

I think someone should ReOpen this to resolve it, and not trying to ignore it until the release stage.

[fooflare (fooflare)]

Thank you very much Phong, I began to think that the problem was just mine. I think the problem is with md5 connection, I tried to resovle it myself but my knowledge of OpenERP is limited. I know that they work a lot,because all bugs I send are resolved really quickly . Now I connect with ident property to database but I think the md5 connection has a problem. This is my last comment, I have to thank you Phong for your help, I will try to resove it but I don't know if i would be able to.

Best regards and thank you all for your help

[OpenBMS JSC (openbmsjsc)]

Still have problem as with revision-id: launchpad_translations_on_behalf_of_openerp-20110305045223en91ygfu
oggcmjgl (3363). The following trace is immediately generated when connecting to OpenERP server. Rolling back to r3350 and still use the same configuration file, and it works again. Therefore I ReOpen this for investigation.

[2011-03-06 22:40:44,840][?] INFO:server:OpenERP server is running, waiting for
connections...
[2011-03-06 22:41:02,695][template1] ERROR:db.connection_pool:Connection to the
database failed
Traceback (most recent call last):
  File "/var/local/software/openerp-trunk/server/openerp/sql_db.py", line 303, i
n borrow
    result = psycopg2.connect(dsn=dsn, connection_factory=PsycoConnection)
OperationalError: fe_sendauth: no password supplied

[2011-03-06 22:41:02,696][template1] DEBUG:web-services:netrpc: rpc-dispatching
exception
Traceback (most recent call last):
  File "/var/local/software/openerp-trunk/server/openerp/service/netrpc_server.p
y", line 70, in run
    result = self.dispatch(msg[0], msg[1], msg[2:])
  File "/var/local/software/openerp-trunk/server/openerp/netsvc.py", line 420, i
n dispatch
    raise OpenERPDispatcherException(e, tb_s)
OpenERPDispatcherException

[Azazahmed Saiyed (OpenERP) (saz-openerp)]

Hello Phong,

The fix is available in revision 3365 of latest trunk server branch.

Thanks.

[philbona (philbona)]

openerp 7.x on fedora 17

I encounter the same issue with the 7.x release,

File "/var/lib/openerp/server/openerp/sql_db.py", line 433, in borrow
    result = psycopg2.connect(dsn=dsn, connection_factory=PsycoConnection)
  File "/usr/lib64/python2.7/site-packages/psycopg2/__init__.py", line 178, in connect
    return _connect(dsn, connection_factory=connection_factory, async=async)
OperationalError: fe_sendauth: no password supplied

pg_hba.conf was initially set with md5 authentication, I change it back to ident, but still get the same issue.

I formerly tried with openerp 6.1 which worked fine, and intend to move to 7.x ( no prob for me it isn't yet in prod, we have to evaluate OErp before launching.

many thanks

[philbona (philbona)]

[Correction] after changing pg_hba.cong I forgot to restart postgres, now it's running fine without md5.