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

Good morning,


I'm trying to setup a system DSN to our Odoo-database using the CData Odoo ODBC Driver, but am receiving the following error:

Server reported an error:psycopg2.OperationalError: FATAL: database 'gotopeo' does not exist.

I don't understand why I'm receiving this message since I've managed to setup DSN to the test-environment, following the exact same steps. 

Apparently there ar some different settings in the test-environment, but I have no clue where to look. Any help would be highly appreciated.

Avatar
Discard
Best Answer

Hi,

The error message you received indicates that the database 'gotopeo' does not exist in your Odoo environment. This suggests that either the database name is incorrect or the database has not been created yet.

To troubleshoot the issue, here are a few steps you can follow:

* Double-check the database name you are using in your DSN configuration. Make sure it matches the actual name of the database you want to connect to. In Odoo, you can typically find the database name in the configuration file (usually located at /etc/odoo.conf) under the db_name parameter.

* Confirm that the database 'gotopeo' exists in your Odoo environment. You can do this by logging into your Odoo instance and navigating to the database management page. In Odoo versions 9 and above, you can usually access it via the URL http:///web/database/manager. Ensure that 'gotopeo' appears in the list of available databases.

* Ensure that the user account specified in the DSN configuration has appropriate permissions to access the 'gotopeo' database. In Odoo, database access is typically managed through user roles. Verify that the user associated with the DSN has the necessary privileges to connect to the database.

* Compare the configuration of your production Odoo environment with the test environment where you were able to successfully set up the DSN. Look for any differences, such as database settings or access restrictions, that may explain the discrepancy.

Hope it helps

Avatar
Discard
Related Posts Replies Views Activity
2
May 24
2329
1
Sep 24
2455