Community mailing list archives

community@mail.odoo.com

Re: Proplem with dbfilter nginx ssl

by
Ermin Trevisan
- 05/24/2016 10:23:27

On 24.05.2016 15:58, info@ygol.com wrote:
> 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?

I'm using 9.0 Community Edition and it works flawlessly. At the moment I
have 11 databases. I'm not using nginx, but caddyserver instead, but
that should not make any difference.

-- 
twanda AG
Ermin Trevisan
Artherstrasse 19
CH-6318 Walchwil
T +41 41 758 1515
M +41 79 208 7373
E trevi@twanda.com
www.twanda.ch
www.twanda.ch/page/restaurant
>  
> 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 postgresql
> 
>     odoo@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_cron
>                                                WHERE numbercall != 0
>                                                   AND active
>                                                   AND nextcall      at time zone 'UTC')
>                                                   AND id=4
>                                                FOR UPDATE NOWAIT
> 
>  
>  
> thank you
>  
> --
> *Yves Goldberg*
> --
>  
>  
> ----- Original message -----
> From: info@ygol.com <mailto:info@ygol.com>
> To: community@mail.odoo.com <mailto:community@mail.odoo.com>
> Subject: Re: Proplem with dbfilter nginx ssl
> Date: Sat, 21 May 2016 19:54:15 +0300
>  
> Nikesh, Graeme. The problem I have is not related to using different
> brwser or profile. tnx 4 answering though.
>  
>  
> ----- Original message -----
> From: Graeme Gellatly 
> To: Community 
> Subject: Re: Proplem with dbfilter nginx ssl
> Date: Sat, 21 May 2016 10:52:52 -0000
>  
> 
> You can if you use multifox extension in Firefox
> 
>  
> On Sat, 21 May 2016 10:07 PM Nikesh P <nikesh@cybrosys.in
> <mailto:nikesh@cybrosys.in>> 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, <info@ygol.com
>     <mailto:info@ygol.com>> wrote:
> 
>         yes. proxy_mode = True 
>          
>         and 
>          
>         the 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; 
>              
> 
>          
>         --
>         *Yves Goldberg - איב גולדברג*
>         *odoo*/| Official Partner// - OCA member///
>         /Open Source ERP, CRM & CMS/
>          
>         T *+972 (3) 720 8818*
>         M +972 (55) 966 1405
>         T +32 (2) 588 2500
>          
>         www.ygol.com 
>         Raanana [ISRAEL]
>          
>         LinkedIn   Skype  Github 
>          Quora 
>         
>         --
>          
> 
>          
>         ----- Original message -----
>         From: Nicolas Seinlet 
>         To: Community <community@mail.odoo.com
>         <mailto:community@mail.odoo.com>>
>         Subject: Re: Proplem with dbfilter nginx ssl
>          
>         Date: Sat, 21 May 2016 09:22:55 -0000
>          
>         Hi,
>          
>         have you enabled proxy_mode in odoo config, as well as
>         forwarding correct headers in nginx?
>          
>          
> 
>          
>          
>         Seinlet Nicolas 
>         Technical Consultant 
>         Phone : +32 81 81 37 00
>         Chaussée de Namur, 40 
>         1367 Grand-Rosière, Belgium
>         OpenERP*( Formerly *Open*ERP **- Info
>         ** )*
>         *odoo.com  **|** Facebook |
>          Twitter |
>          Linkedin |
>          Google Plus |
>          Youtube
>         ***
>          
>          
>          
> 
>          
>         On Sat, May 21, 2016 at 8:27 AM, <info@ygol.com
>         <mailto:info@ygol.com>> wrote:
>          
> 
>             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_exception
>                     return super(JsonRequest,
>                 self)._handle_exception(exception)
>                   File "/odoo/odoo-server/openerp/http.py", line 1625,
>                 in _dispatch_nodb
>                     func, 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 match
>                     raise NotFound()
>                 NotFound: 404: Not Found
> 
>              
>             I followed:
>             https://community.bitnami.com/t/your-odoo-session-expired-please-refresh-the-current-web-page/31934
>              
>             and modified in http.py which solve the problem.
>              
> 
>                 def setup_db(self, httprequest):
>                     db = httprequest.session.db
>                     # Check if session.db is legit
>                     if 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                  i.e. do nothing by this function
>                             db = db
>                     if 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 member///
>             /Open Source ERP, CRM & CMS/
>              
>             T *+972 (3) 720 8818 *
>             M +972 (55) 966 1405 
>             T +32 (2) 588 2500 
>              
>             www.ygol.com 
>             Raanana [ISRAEL]
>              
>             LinkedIn 
>              Skype  Github 
>              Quora 
>             
>             --
>              
> 
> 
>             _______________________________________________
>             Mailing-List: https://www.odoo.com/groups/community-59
>             Post to: mailto:community@mail.odoo.com
>             <mailto:community@mail.odoo.com>
>             Unsubscribe: https://www.odoo.com/groups?unsubscribe
> 
> 
>         _______________________________________________
>         Mailing-List: https://www.odoo.com/groups/community-59
>         Post to: mailto:community@mail.odoo.com
>         <mailto:community@mail.odoo.com>
>         Unsubscribe: https://www.odoo.com/groups?unsubscribe
> 
>         Email had 1 attachment:
> 
>           *
>             |image001.png|
>               4k (image/png)
> 
>          
> 
>         _______________________________________________
> 
> 
>          
>         Mailing-List:https://www.odoo.com/groups/community-59
>         Post to: mailto:community@mail.odoo.com
>         <mailto:community@mail.odoo.com>
>         Unsubscribe: https://www.odoo.com/groups?unsubscribe
> 
> 
> 
>      
>      
>      
>     -- 
>      
>     Cybrosys  
>     www.cybrosys.com 
>     	
>     NIKESH P
>     PYTHON DEVELOPER
>     Project & IT Department
> 
>      
>     * nikesh@cybrosys.in <mailto:nikesh@cybrosys.in>*
>      +91 494 3015006 / 07
>      +91 8606827707
>      cybroopenerp
>      
> 
>      
>     Facebook  Twitter
>      LinkedIn
>      Google Plus
>      Pinterest
>      Company 
>      
>     This email and any file transmitted with it are confidential and
>     intended solely for the use of the individual or entity whom they
>     are addressed.If you have received this email in error please notify
>     the system manager. The company accepts no liability for any damage
>     caused by any virus transmitted by this email.
> 
> 
>     _______________________________________________
>     Mailing-List: https://www.odoo.com/groups/community-59
>     Post to: mailto:community@mail.odoo.com <mailto:community@mail.odoo.com>
>     Unsubscribe: https://www.odoo.com/groups?unsubscribe
> 
> 
> 
> _______________________________________________
> Mailing-List: https://www.odoo.com/groups/community-59
> Post to: mailto:community@mail.odoo.com
> Unsubscribe: https://www.odoo.com/groups?unsubscribe
> 
> 
>  
> 
> _______________________________________________
> Mailing-List: https://www.odoo.com/groups/community-59
> Post to: mailto:community@mail.odoo.com
> Unsubscribe: https://www.odoo.com/groups?unsubscribe
>