Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
2 Odpovědi
7861 Zobrazení

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
Zrušit
Nejlepší odpověď

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
Zrušit
Autor Nejlepší odpověď

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

Avatar
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
3
led 25
4016
0
bře 16
4358
0
kvě 18
2533
0
led 21
3716
///// Vyřešeno
1
čvc 20
294