Community mailing list archives
Re: Proplem with dbfilter nginx sslby
AFAIK this is how Odoo Saas works according Olivier Dony presentation 100 databases running on a single Odoo instance on a dedicated server.
Does odoo works for multi-database with db-filter, nginx and ssl on the same ports (8069 for the different databases and 8071 for the longpolling)?or is this not recommended for production?as in my 1st mail, I had to modify the core http.py file to make this work and now I get problem with multiple cron [ref] and wonder if it is also not related to my setting.[ref] error in log postgresqlodoo@pw ERROR: could not obtain lock on row in relation "ir_cron"2016-05-24 09:50:20 EDT [5187-2] odoo@pw STATEMENT: SELECT *FROM ir_cronWHERE numbercall != 0AND activeAND nextcall <= (now() at time zone 'UTC')AND id=4FOR UPDATE NOWAITthank you--Yves Goldberg------- Original message -----From: firstname.lastname@example.orgSubject: Re: Proplem with dbfilter nginx sslDate: Sat, 21 May 2016 19:54:15 +0300Nikesh, Graeme. The problem I have is not related to using different brwser or profile. tnx 4 answering though.----- Original message -----From: Graeme Gellatly <email@example.com>To: Community <firstname.lastname@example.org>Subject: Re: Proplem with dbfilter nginx sslDate: Sat, 21 May 2016 10:52:52 -0000
You can if you use multifox extension in FirefoxOn Sat, 21 May 2016 10:07 PM Nikesh P <email@example.com> wrote:Hi,You cannot stay logged in different databases of a particular odoo instance at the same time in same browser .On Sat, May 21, 2016 at 3:04 PM, <firstname.lastname@example.org> wrote:yes. proxy_mode = Trueandthe headers in nginx are set as:proxy_set_header Host $host;proxy_set_header X-Real-IP $remote_addr;proxy_set_header X-Forwarded-For $http_host;proxy_set_header X-Forwarded-Proto https;Hi communiy,running odoo 9e with dbfilter and nginx with ssl, I've faced a problem "session expired" and thus not being able to stay logged in the different databases. This is what's in the log:Traceback (most recent call last):File "/odoo/odoo-server/openerp/http.py", line 643, in _handle_exceptionreturn super(JsonRequest, self)._handle_exception(exception)File "/odoo/odoo-server/openerp/http.py", line 1625, in _dispatch_nodbfunc, arguments = self.nodb_routing_map.bind_to_environ(request.httprequest.environ).match()File "/usr/lib/python2.7/dist-packages/werkzeug/routing.py", line 1433, in matchraise NotFound()NotFound: 404: Not FoundI followed:and modified in http.py which solve the problem.def setup_db(self, httprequest):db = httprequest.session.db# Check if session.db is legitif db:if db not in db_filter([db], httprequest=httprequest):_logger.warn("Logged into database '%s', but dbfilter " "rejects it; logging session out.", db)# httprequest.session.logout() <----------- disable the session logout# db = None <----------- return db = db, i.e. do nothing by this functiondb = dbif not db:httprequest.session.db = db_monodb(httprequest)1. Do you know a way to fix the problem without modifying core code?2. What would be the consequences of these modification to http.py?thank you.--Yves Goldberg - איב גולדברגodoo| Official Partner - OCA memberOpen Source ERP, CRM & CMSRaanana [ISRAEL]--
Email had 1 attachment:
NIKESH P PYTHON DEVELOPER Project & IT Department email@example.com +91 494 3015006 / 07 +91 8606827707 cybroopenerp