Skip to Content
This question has been flagged
externalpostgresqllocalhostrdsodoo
3 Replies
14022 Views
Avatar
Carlos DuAl

Hello,

I'm trying to connect Odoo with a Postgresql db that's located in another machine. I set the new database hostname (I have its endpoint), port, user and password in "openerp-server.conf", however, when I launch odoo.py I get  

2016-03-03 11:51:35,170 1284 INFO ? openerp: database hostname: localhost
2016-03-03 11:51:35,170 1284 INFO ? openerp: database port: 5432


If I lauch odoo with the database hostname and port arguments, it works fine, so I'm guessing odoo is not looking at the openerp-server.conf that I changed. 

in odoo/debian/init I have changed the CONFIG attribute and it points to the new openerp-server.config


Do I need to change anything else?


Thank you

Avatar
Discard
Avatar
Ashish Singh
Best Answer

Hi, Carlos

You are getting this issue because Odoo is not able to locate your conf file. So in order to locate your conf file while running your Odoo there have multiple ways. Like

  • If you are running your Odoo directly from bin file then you need to pass your config file along with then bin file using "-c" or "--config" like below,

    • ../odoo-bin -c config_file_path

    • e.g: Path of your config file is /etc/odoo/odoo.conf

    • Then you can you command like,

      • ../odoo-bin -c /etc/odoo/odoo.conf  OR ../odoo-bin --config /etc/odoo/odoo.conf

  • Else you can achieve the same by creating a shell script file.

    • You can take help from the file,Script File

    • Or you can  refer to the Odoo Debian file.

    • Inside this file you can update your config file path inside "CONFIGFILE" attribute.

      • CONFIGFILE="/etc/odoo-server.conf"

    • Then you can you simply start/restart your shell script file using below command.

      • Script_FIle_Path start/restart

      • e.g: Path of script file is /etc/init.d/odoo-server then you can run command like below,

        • /etc/init.d/odoo-server restart 
Hope above points will help you to achieve this part. In case of any confusion feel free to ask.

Thanks,
Ashish Singh (Team Lead)
Webkul Software Private Limited
Avatar
Discard
Avatar
José Vallmitjana Llambias
Best Answer

Mira el siguiente enlace:

http://poncesoft.blogspot.com.es/2014/06/utilizar-un-servidor-independiente.html

Espero que te baya bien, recibe un cordial saludo.

Avatar
Discard
Avatar
Ijas Ahammed P
Best Answer

Try using xmlrpc

Avatar
Discard
Related Posts Replies Views Activity
Have You Faced Slow Pagination in Odoo List Views with Large Data?
postgresql odoo
Avatar
0
Apr 26
784
Digitalocean issue
postgresql odoo
Avatar
0
Dec 21
4434
2018-11-28 10:40:01,906 9672 CRITICAL ? odoo.service.server: Failed to initialize database `abc`
postgresql odoo
Avatar
Avatar
2
Feb 19
12093
How to access database of Odoo using pgAdmin III Solved
postgresql odoo
Avatar
Avatar
Avatar
Avatar
14
Dec 17
104917
How to get second and fourth saturday of given month in posstgresql ?
postgresql odoo
Avatar
0
Sep 17
4351