Tuesday, January 13, 2015

OperationalError: fe_sendauth: no password supplied error


In OpenERP, OperationalError: fe_sendauth: no password supplied error



Sometimes while running OpenERP server after fresh installation you may get following error :

2015-01-13 06:21:15,798 7695 ERROR ? openerp.sql_db: Connection to the database failed
Traceback (most recent call last):
File "/usr/local/lib/python2.7/dist-packages/openerp-7.0_20150113-py2.7.egg/openerp/sql_db.py", line 442, 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: fe_sendauth: no password supplied



Steps suggested to get rid of this error:

1. Stop your OpenERP server using ctrl+c.

2. Stop your PostgreSQL server : $ sudo /etc/init.d/postgresql stop

3. Edit your PostgreSQL configuration file i.e. pg_hb.conf using nano or gedit editor :
$ sudo gedit /etc/postgresql/9.1/main/pg_hba.conf
4. As requested give a sudo password to open the file.
5. Now, In the pg_hba.conf file serach for following lines:
# "local" is for Unix domain socket connections only
local         all        all        peer
Here, in above line type of connection used is “peer”, change it to a “trust” i.e.
local         all        all        trust
Now, Save and close the file.
6. After making the above changes to the configuration file i.e. pg_hba.conf, Reload and start the PostgreSQL server :
$ sudo /etc/init.d/postgresql reload
$ sudo /etc/init.d/postgresql start

7. Now start OpenERP server and hit the url to http://localhost:8069 in the browser.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Thanks,
Ujwala H. Pawade..

5 comments: