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..