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.