Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
1 Odpowiedz
1580 Widoki

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

Awatar
Odrzuć
Najlepsza odpowiedź

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!

Awatar
Odrzuć

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

Powiązane posty Odpowiedzi Widoki Czynność
1
sie 25
241
0
lip 25
494
0
lip 25
1128
1
kwi 25
1628
1
cze 25
1083