Odoo Help

Welcome!

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

-1

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

By
Neels
on 3/29/13, 3:09 AM 12,592 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)--
Tiny ERP Pvt Ltd
http://www.odoo.com
1281
| 2 2 4
India
--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

patrick

--patrick--
1958
| 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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

Asked: 3/29/13, 3:09 AM
Seen: 12592 times
Last updated: 3/16/15, 8:10 AM