Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
2 Trả lời
7863 Lượt xem

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,


Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

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.

Ảnh đại diện
Huỷ bỏ
Tác giả Câu trả lời hay nhất

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

Ảnh đại diện
Huỷ bỏ
Bài viết liên quan Trả lời Lượt xem Hoạt động
3
thg 1 25
4017
0
thg 3 16
4358
0
thg 5 18
2533
0
thg 1 21
3716
///// Đã xử lý
1
thg 7 20
294