Odoo Help


How to limit max connection per OpenERP user?

Tomas Parnarauskas
on 9/26/13, 9:09 AM 3,598 views

Is it possible to make a limit how much users can connect in OpenERP? I know you can set limit per PostgreSQL user, but usually only one PsotgreSQL user connects to openerp, so it would be best to be able to somehow set limit per OpenERP users. For example let say there are 5 total users. Admin user would not count into max connections, and the rest 4 would count. So let say there would be limit of 3 concurrent connections. So if three users (without counting admin) would be connected to OpenERP, the fourth could not connect. Does anyone know how to do it?


Ray Carnes

--Ray Carnes--
| 9 7 9
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0 and 11.0.

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

Ray Carnes
On 9/26/13, 2:33 PM

Users only 'connect' to OpenERP when they are actively using the system, such as when clicking a button.

If 100 users are reading a document in OpenERP, none of them are logged in. Once they click a button to move to another document they are logged in but are immediately logged out until they click another button.

So it would be hard to know who is actually logged in because no-one is ever logged in longer than the time it takes to process a button click.

Can you take a step back and post the problem you are trying to solve?

If you really want to do this, you probably need a step before people login to OpenERP to manage the user limits you want (and to force people to log off.)

We need to make a limit how many users can be logged into system at any given time in specific database. I tried db_maxconn parameter, but it does count connections differently and it does not reduce the count when you log out, so this options seems may not work.

NOD Baltic, UAB, Tomas Parnarauskas
on 9/27/13, 5:28 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 9/26/13, 9:09 AM
Seen: 3598 times
Last updated: 3/16/15, 8:10 AM