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

إدارة علاقات العملاء
e-Commerce
المحاسبة
المخزون
PoS
المشروع
MRP

All apps

كافة المنشورات الأفراد الشارات

علامات التصنيف (عرض الكل)

odoo accounting v14 pos v15

حول هذا المنتدى

المساعدة

Can't connect to external database

external postgresql localhost rds odoo

3 الردود

13156 أدوات العرض

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

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!

أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!

تسجيل

المنشورات ذات الصلة	الردود	أدوات العرض
Digitalocean issue postgresql odoo	0 ديسمبر 21	3515
2018-11-28 10:40:01,906 9672 CRITICAL ? odoo.service.server: Failed to initialize database `abc` postgresql odoo	2 فبراير 19	11086
How to access database of Odoo using pgAdmin III تم الحل postgresql odoo	14 ديسمبر 17	103462
How to get second and fourth saturday of given month in posstgresql ? postgresql odoo	0 سبتمبر 17	3668
how odoo communicates with postgresql technically ? postgresql odoo	0 مارس 15	5021

لقد تم الإبلاغ عن هذا السؤال

Thanks,

Ashish Singh (Team Lead)

Webkul Software Private Limited

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!