Passa al contenuto
Menu
È necessario essere registrati per interagire con la community.
La domanda è stata contrassegnata
1 Rispondi
1607 Visualizzazioni

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
Abbandona
Risposta migliore

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
Abbandona

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

Post correlati Risposte Visualizzazioni Attività
1
ago 25
303
0
lug 25
501
0
lug 25
1147
1
apr 25
1669
1
giu 25
1096