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

CRM
e-Commerce
Contabilitate
Inventar
PoS
Proiect
MRP

All apps

All Posts Oameni Insigne

Etichete (View all)

odoo accounting v14 pos v15

Despre acest forum

Suport

Can't connect to external database

external postgresql localhost rds odoo

3 Răspunsuri

13161 Vizualizări

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

Ashish Singh

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

José Vallmitjana Llambias

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.

Ijas Ahammed P

Try using xmlrpc

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Înscrie-te

Related Posts	Răspunsuri	Vizualizări
Digitalocean issue postgresql odoo	0 dec. 21	3515
2018-11-28 10:40:01,906 9672 CRITICAL ? odoo.service.server: Failed to initialize database `abc` postgresql odoo	2 feb. 19	11086
How to access database of Odoo using pgAdmin III Rezolvat postgresql odoo	14 dec. 17	103462
How to get second and fourth saturday of given month in posstgresql ? postgresql odoo	0 sept. 17	3668
how odoo communicates with postgresql technically ? postgresql odoo	0 mar. 15	5022

Această întrebare a fost marcată

Thanks,

Ashish Singh (Team Lead)

Webkul Software Private Limited

Enjoying the discussion? Don't just read, join in!