Deploy on Heroku, error on db connection

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Księgowość
Zapasy
PoS
Project
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

Deploy on Heroku, error on db connection

odoo18

1 Odpowiedz

1580 Widoki

Fabio Merendino

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

lyly

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!

lyly

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

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
How to share cash payment method with all the Shop point in POS module in Odoo 18? odoo18	1 sie 25	241
Odoo can’t be reached via MyIP:8069 odoo18	0 lip 25	494
Status bar not visible in odoo18, is there any missing library support or anything please let me know, statusbar is not visible in my local enviroment of odoo18 in all views. odoo18	0 lip 25	1128
Auto Session time out for users ODOO 18 odoo18	1 kwi 25	1628
company changing from Private Limited to Public Limited during Middle Rozwiązane odoo18	1 cze 25	1083

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!