This question has been flagged
5 Replies
88103 Views
Avatar
Neels

I faced following error please give resolution..

OpenERP Server Error Client Traceback (most recent call last): File "C:\Program Files (x86)\OpenERP 7.0-20130328-001657\Server\server\openerp\addons\web\http.py", line 203, in dispatch File "C:\Program Files (x86)\OpenERP 7.0-20130328-001657\Server\server\openerp\addons\web\controllers\main.py", line 759, in get_list File "C:\Program Files (x86)\OpenERP 7.0-20130328-001657\Server\server\openerp\addons\web\controllers\main.py", line 89, in db_list File "C:\Program Files (x86)\OpenERP 7.0-20130328-001657\Server\server\openerp\addons\web\session.py", line 31, in proxy_method File "C:\Program Files (x86)\OpenERP 7.0-20130328-001657\Server\server\openerp\addons\web\session.py", line 104, in send

Server Traceback (most recent call last): File "C:\Program Files (x86)\OpenERP 7.0-20130328-001657\Server\server\openerp\addons\web\session.py", line 90, in send File "C:\Program Files (x86)\OpenERP 7.0-20130328-001657\Server\server.\openerp\netsvc.py", line 293, in dispatch_rpc File "C:\Program Files (x86)\OpenERP 7.0-20130328-001657\Server\server.\openerp\service\web_services.py", line 122, in dispatch File "C:\Program Files (x86)\OpenERP 7.0-20130328-001657\Server\server.\openerp\service\web_services.py", line 359, in exp_list File "C:\Program Files (x86)\OpenERP 7.0-20130328-001657\Server\server.\openerp\sql_db.py", line 484, in cursor File "C:\Program Files (x86)\OpenERP 7.0-20130328-001657\Server\server.\openerp\sql_db.py", line 182, in __init__ File "C:\Program Files (x86)\OpenERP 7.0-20130328-001657\Server\server.\openerp\sql_db.py", line 377, in _locked File "C:\Program Files (x86)\OpenERP 7.0-20130328-001657\Server\server.\openerp\sql_db.py", line 440, in borrow File "psycopg2__init__.pyc", line 178, in connect OperationalError: FATAL: password authentication failed for user "openpg"

Avatar
Discard
Avatar
Naresh Soni (nch)
Best Answer

Hi Neels,

This error states that the db user and db password that OpenERP server is using to connect to postgres is wrong. i.e check the server configuration file for the db_user and db_password are same as your postgres user and password.

Thanks,

Avatar
Discard
Bhavik

Hello Naresh, i am facing the same above mentioned problem. can you please let me know which file(s) to be checked to know / change the credentials. thanks!

Avatar
marocsys
Best Answer

try this

$su postgres

$psql

*alter user openpg with password admin;

and go to odoo config file and write (db_password = admin

Avatar
Discard
Avatar
patrick
Best Answer

On Linux, you have to create a specific user within the database to allow openERP to access the database.

Command (on Linux) to create a user within postgreSQL:

createuser --createdb --username postgres --no-createrole --no-superuser --pwprompt openerp

You probably have to do something simular on Windows

Avatar
Discard
Avatar
Wahab Ali Malik
Best Answer

Hi,I know this is an old post but upper results are not working for me.Well this will definitely work.

You can see this django link => "https://stackoverflow.com/questions/34264003/peer-authentication-fails-with-postgressql-in-celery-task".


Apparently there are multiple ways for authentication with postgresql.


So,if your Postgresql user is different from your linux user then one easy way is to add `--db_host` to `localhost` which is `"127.0.0.1"`:


    .odoo-bin -r "pg_user" -w 'pg_pass' --db_host "127.0.0.1"


 If you feel any problem in this,Tell me i will elaburate further

Avatar
Discard