Skip to Content
เมนู
คุณต้องลงทะเบียนเพื่อโต้ตอบกับคอมมูนิตี้
คำถามนี้ถูกตั้งค่าสถานะ
5 ตอบกลับ
51697 มุมมอง

I made a clean install using the packaged version of Odoo 13 into a linux server. I am trying to access the database using pgadmin4. The connection seems to be ok but I am not able to get the correct user/password combination. I read I could find the information at /etc/odoo/odoo.conf  and this is what I got :


sudo more /etc/odoo/odoo.conf 

[sudo] password for parallels: 

[options]

; This is the password that allows database operations:

; admin_passwd = admin

db_host = False

db_port = False

db_user = odoo

db_password = False

;addons_path = /usr/lib/python3/dist-packages/odoo/addons



I tried the user odoo with the passoword I entered when creating the database within Odoo but no result.

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

Hello Ben Quan,

You have to set db_password which you have created in pgadmin for user odoo and then create your database within odoo and there will you set your custom user and password.

 

trying these commands in terminal

$su postgres

$psql

*alter user odoo with password admin;

and go to odoo config file and write (db_password = admin,db_host = localhost,

db_port = 5432)


Creating Postgres User For Odoo


Thank you

อวตาร
ละทิ้ง
ผู้เขียน คำตอบที่ดีที่สุด

Thanks Pinal

I tried setting db_password. The file now reads:

[options]

; This is the password that allows database operations:

; admin_passwd = admin

db_host = False

db_port = False

db_user = odoo

db_password = mypassword

;addons_path = /usr/lib/python3/dist-packages/odoo/addons


I then deleted the database and recreated it using Odoo. But still same redult : FATAL: password authentication failed for user "odoo"

Ben



อวตาร
ละทิ้ง

Hello Ben,

trying these commands in terminal

$su postgres

$psql

*alter user odoo with password admin;

and go to odoo config file and write (db_password = admin,db_host = localhost,

db_port = 5432)

ผู้เขียน

Thanks that did the trick

Related Posts ตอบกลับ มุมมอง กิจกรรม
0
ก.พ. 25
1516
2
ม.ค. 25
8120
Odoo backend to Google Data Studio แก้ไขแล้ว
2
ม.ค. 24
10138
7
ม.ค. 24
48953
0
มี.ค. 23
2073