Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
1 Balas
591 Tampilan

Hi, I'm trying to deploy odoo18 on heroku, I've added a Procfile on the root of odoo with this line :

web: python3 odoo-bin --config=odoo.conf


then on my root I created a odoo.conf file like this : 

[options]

db_user = my postgres db user

db_password = my postgres passw

db_host =my db host

db_port =5432

db_name = my dynamo

addons-path=addons

but I keep getting this error when I run odoo: 


2025-02-04T17:10:11.215872+00:00 app[web.1]: psycopg2.OperationalError: connection to server at "(mydbhost)" (mydbhostip), port 5432 failed: FATAL:  permission denied for database "postgres"

2025-02-04T17:10:11.215873+00:00 app[web.1]: DETAIL:  User does not have CONNECT privilege.

2025-02-04T17:10:11.215873+00:00 app[web.1]: 

2025-02-04T17:10:11.368498+00:00 heroku[web.1]: Process exited with status 1

2025-02-04T17:10:11.391071+00:00 heroku[web.1]: State changed from starting to crashed


how can I fix this? thx

Avatar
Buang
Jawaban Terbai

Hi Fabio, it looks like the error comes from your database configuration — specifically, the PostgreSQL user you're using doesn’t have the CONNECT privilege on the "postgres" database. Double-check that the db_name in your odoo.conf is set to the name of the actual Odoo database (not "postgres", which is usually a default admin DB). Also, make sure that your PostgreSQL user has the correct privileges for that database. You might need to create a new database and grant full access to your Odoo user. Let me know if you need help with the SQL commands to do that!

Avatar
Buang

Let me know if you need help with the SQL commands to do that! https://retrobowl25.com

Post Terkait Replies Tampilan Aktivitas
1
Apr 25
483
0
Mar 25
407
1
Feb 25
407
0
Feb 25
527
0
Mei 25
569