Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
2 Replies
7870 Tampilan

Hey guys, i am trying to achieve this scenario: I have odoo and postgres running on the same VM. I want to decouple things, and i want to use a separate postgres server.

What am i doing:

1 - dump the db as postgres user from the current server(odoo1)

2 - create a non-superuser sql account on the postgres server(postgres1) and grant access to a new db. I also tested to see if i can access the remote db and everything works just fine.

3 - import the sql dump in the new db.

4 - change the odoo.conf db_user / dbfilter / db_password / db_host - to reflect the new server.

5 - copy the filestore folder+contents to a new folder that has the same name as the new db.

6 - start odoo 

The problem is that after starting odoo, i get the database selector page, instead of odoo simply working from the remote db. 

https://www.screencast.com/t/IkV4V0N9

I am pretty stuck and i have no idea what to do here.

The log shows it's connecting to the remote db, but i can't get odoo to work

2018-09-26 15:54:46,048 26475 INFO ? odoo: Odoo version 11.0

2018-09-26 15:54:46,053 26475 INFO ? odoo: Using configuration file at /etc/odoo11-machine-server.conf

2018-09-26 15:54:46,054 26475 INFO ? odoo: addons paths: ['/home/work/odoo11/.local/share/Odoo/filestore/addons/11.0', '/home/work/odoo11/odoo11-server/addons',  '/home/work/odoo11/odoo11-server/odoo/addons']

2018-09-26 15:54:46,054 26475 INFO ? odoo: database: db_user@10.111.0.12:5432

2018-09-26 15:54:46,073 26475 INFO ? odoo.service.server: HTTP service (werkzeug) running on 0.0.0.0:8069

2018-09-26 15:54:46,166 26475 INFO ? odoo.addons.base.ir.ir_actions_report: Will use the Wkhtmltopdf binary at /usr/bin/wkhtmltopdf

2018-09-26 16:28:14,953 26475 INFO ? odoo.http: HTTP Configuring static files

2018-09-26 16:28:15,025 26475 INFO ? odoo.http: Generating nondb routing

Any help would be greatly appreciated. 
Thanks in advance,


Avatar
Buang
Jawaban Terbai

This is  because of database owner, login to database and check for the owner of the database.

Eg 

Database| owner

db1             ubuntu

db2             odoo

If odoo-server is running as odoo user then only db2 will be accessible.

Avatar
Buang
Penulis Jawaban Terbai

you were right. thanks.can't believe i missed that.

Avatar
Buang
Post Terkait Replies Tampilan Aktivitas
3
Jan 25
4018
0
Mar 16
4360
0
Mei 18
2534
0
Jan 21
3717
///// Diselesaikan
1
Jul 20
294