Odoo Help

-1

OperationalError: FATAL: password authentication failed for user "openpg"

By
Neels
on 3/29/13, 3:09 AM 17,842 views

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"

1

Naresh Soni (nch)

--Naresh Soni (nch)--
--Naresh Soni (nch)--

Team Lead, Odoo(Formerly OpenERP) Support & OPW

Naresh Soni (nch)
On 3/29/13, 3:25 AM

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,

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!

Bhavik
on 7/9/13, 1:04 PM
0
Wahab Ali Malik
On 12/13/17, 12:52 AM

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

0

patrick

--patrick--

1963
| 5 4 7
Baarn, Netherlands
--patrick--
patrick
On 3/29/13, 6:59 AM

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

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

2 follower(s)

Stats

Asked: 3/29/13, 3:09 AM
Seen: 17842 times
Last updated: 12/13/17, 12:52 AM