This question has been flagged
13 Replies
15671 Views
windows8Pycharm4ConfigurationOdoo10.0odoov11
Avatar
Hassan Ali

I have installed an independent postgresSql version 9.1 (x86). Then i simply had installed odoo-11 service without the postgresql because i already have it. After that I had to download the odeo11 source code and configure it in pycharm here is the screen shot of my odoo configuration.

 https://ibb.co/eMSZsG

here is my odoo.conf


[options] 
; This is the password That Allows database operations: 
; admin_passwd = admin 
db_host = localhost 
db_port = 5432 
db_user = openpg 
db_filter =. * 
db_password = openpgpwd 
addons_path = d: \ odoo \ addons 
xmlrpc_port = 8088

Futher i had debugged with pycharm and i was successfull installing odoo-11

But i had installed odoo10 using same method then my odoo11 install got conflicted with odoo11 and console shows me error 

Skipping database pos10 as its base version is not 11.0.1.3

Avatar
Discard
Hassan Ali
Author

Please read my comment( I had used different postgresql users for each version.

Niyas Raphy (Walnut IT)

This is just a logger warning right

Hassan Ali
Author

But my odoo11 service isn't worked when i configure two instances together\

Avatar
Alejandro Bello
Best Answer

It can be done (I have), but it is a bit complicated to setup AND maintain. Ask yourself if it's really worth it.

You have been properly warned. Don't come asking for exact copy&paste instructions, because there aren't. You are diving deep into customization territory. And no, it cannot be done with Windows hosting. Microsoft sucks at port management.

For different versions, you can use the same "odoo" linux user. One postgres user for each source code (ie. /opt/odoo12, /opt/odoo13), change postgres peer login to md5 login, AND specify in each odooXX.conf file the following:

1. db_user / db_password (since you disabled "peer" login, you have to explicitly fill these parameters for EACH .conf)
2. http_port / longpolling_port. Extra odoo setups can't reuse the "standard" 8069 / 8071 ports.

I don't think we have to explain that your best friend/nemesis is port management. Otherwise, you (nor odoo) have no way to control which http request goes to which odoo version.

i.e. http://xxx.xxx.xxx:8069? --> that's odoo 12! It's here and uses this .conf file with this postgres passwords and has these databases to choose from...

 http://xxx.xxx.xxx  8169? --> Well, that's odoo 13!

And so on.

The different postgres users are to prevent from loading an odoo database into the incorrect version of odoo.

Things will get extremely dicey when you try to configure a reverse proxy for HTTPS access. You do want to keep your users information private, right?

Hope it helps!

Avatar
Discard
Avatar
Thanh Loyal
Best Answer

Try to isolate the 2 instances by explicit restricting which instance should connect to which database.

;odoo10.conf
dbfilter = odoo10_db
...


;odoo11.conf
dbfilter = odoo11_db
...


So that each instance should access one database and they should not conflict in DB aspect. 

If this still doesn't work, please post content of your log file.

Avatar
Discard
Hassan Ali
Author

[options]

; This is the password that allows database operations:

; admin_passwd = admin

db_host = localhost

db_port = 5432

db_user = openpg

db_filter=pos

db_password = openpgpwd

addons_path = d:\odoo\addons

xmlrpc_port = 8088

I had edit my conf file but still haive same error

odoo.addons.base.ir.ir_cron: Skipping database pos10 as its base version is not 11.0.1.3.

Thanh Loyal

It seems that you are using Odoo 11 to access a database which was pre-created by Odoo 10. As far as I know, this is not possible because Odoo10 and Odoo11 are incompatible. If a database was created by Odoo 10, it must be consumed by Odoo10. If you want to use Odoo11 with that DB, you must upgrade it, which is not easy.

Hassan Ali
Author

I am not using same databases Both I had assigned different databases to odoo10 and odoo11 but I dn't know how its considering pos10 as odoo11 database.this my odoo 11 conf

[options]

; This is the password that allows database operations:

; admin_passwd = admin

db_host = localhost

db_port = 5432

db_user = openpg

db_filter=pos

db_password = openpgpwd

addons_path = d:\odoo\addons

xmlrpc_port = 8088

Hassan Ali
Author

both have diferent databases and users too. And Also both have different xmlrpc_port

Thanh Loyal

Ahhh, according to Odoo document: https://www.odoo.com/documentation/11.0/reference/cmdline.html#cmdoption-odoo-bin--db-filter , the parameter must be 'dbfilter' instead of 'db_filter'.

Hassan Ali
Author

Ohoo Thank you for your time . You had done a remarkable thing for me .

Thanh Loyal

Glad to help!

Hassan Ali
Author

i had notice that my odoo 11 service isn't working that's the real issue.after installation of odoo 10 installation.