Skip to Content
Menu
This question has been flagged
1 Reply
39740 Views

I am new with this and I need some help to connect my odoo server to my database hosted online (elphantsql.com).

Below the details of the database (it is a test database):

Server: stampy.db.elephantsql.com (stampy-01)

User & Default database: hwyfwnxq Password: exFgXq5HZFv7XDV2P1KWlMyNmUSI7uaa Here are the configurations of my odoo.conf file:

db_host = stampy.db.elephantsql.com db_name = hwyfwnxq db_password = exFgXq5HZFv7XDV2P1KWlMyNmUSI7uaa db_user = hwyfwnxq After I restarted the odoo service, I cannot access the portal and in the log file I see:

2017-04-01 17:39:57,094 2392 INFO ? odoo: Odoo version 10.0-20170328 2017-04-01 17:39:57,094 2392 INFO ? odoo: Using configuration file at C:\Program Files\Odoo 10.0\server\odoo.conf 2017-04-01 17:39:57,094 2392 INFO ? odoo: addons paths: ['C:\\Users\\POS1\\AppData\\Local\\OpenERP S.A.\\Odoo\\addons\\10.0', u'C:\\Program Files\\Odoo 10.0\\server\\odoo\\addons']

2017-04-01 17:39:57,094 2392 INFO ? odoo: database: hwyfwnxq@stampy.db.elephantsql.com:5432 2017-04-01 17:39:58,857 2392 INFO ? odoo.sql_db: Connection to the database failed Can you please help me, because it is very important for me to fix this issue.

P.S. I can access the database with these credentials using pgAdmin4, so it is not clear why it fails.

Avatar
Discard
Best Answer
Hi,

Please make sure following parameters are correctly set:

  1. pg_hba.conf peer permission
  2. Database user is created as per name mentioned in odoo service config file
  3. If you are running application and database services on different instances (i.e different server/system) then make sure postgresql.conf file have IP permission for your application server IP
  4. You must have enough space in the instance as per the size of the database.
Avatar
Discard
Related Posts Replies Views Activity
2
Mar 24
2424
3
Nov 23
47090
0
Jun 23
3669
4
Nov 20
3617
1
Aug 16
3819