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

CRM
e-Commerce
Księgowość
Zapasy
PoS
Projekt
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

Can't connect to external database

external postgresql localhost rds odoo

3 Odpowiedzi

13157 Widoki

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

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
Digitalocean issue postgresql odoo	0 gru 21	3515
2018-11-28 10:40:01,906 9672 CRITICAL ? odoo.service.server: Failed to initialize database `abc` postgresql odoo	2 lut 19	11086
How to access database of Odoo using pgAdmin III Rozwiązane postgresql odoo	14 gru 17	103462
How to get second and fourth saturday of given month in posstgresql ? postgresql odoo	0 wrz 17	3668
how odoo communicates with postgresql technically ? postgresql odoo	0 mar 15	5021

To pytanie dostało ostrzeżenie

Thanks,

Ashish Singh (Team Lead)

Webkul Software Private Limited

Podoba Ci się ta dyskusja? Dołącz do niej!