Skip to Content
คุณต้องลงทะเบียนเพื่อโต้ตอบกับคอมมูนิตี้
All Posts คน เหรียญรางวัล
แท็ก (View all)
odoo accounting v14 pos v15
เกี่ยวกับฟอรั่มนี้
คำถามนี้ถูกตั้งค่าสถานะ
5 ตอบกลับ
101594 มุมมอง
อวตาร
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"

อวตาร
ละทิ้ง
อวตาร
Naresh Soni (nch)
คำตอบที่ดีที่สุด

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,

อวตาร
ละทิ้ง
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!

อวตาร
marocsys
คำตอบที่ดีที่สุด

try this

$su postgres

$psql

*alter user openpg with password admin;

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

อวตาร
ละทิ้ง
อวตาร
patrick
คำตอบที่ดีที่สุด

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

อวตาร
ละทิ้ง
อวตาร
Wahab Ali Malik
คำตอบที่ดีที่สุด

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

อวตาร
ละทิ้ง