Actually No. Actually the connection to database is done in fork process. So if you have two fork process with one sqlcon param, You'll have two TCP connection. If you add one another sqlcon param in modparam, you will have four tcp connection. at finally you will have: (Number_Of_Connection=Fork_no * sqlcon_no) It is the concept of implementing Kamailio project. So if you want another treatment in this regards, you have to change in PROC_INIT process in child_init function. With Regards.Mojtaba
On Thu, Nov 22, 2018 at 7:32 AM Karthik Srinivasan ksriniva2002@gmail.com wrote:
Hello,
Is there a formula/algorithm that determines how many TCP connections are made per child process to a database server defined by sqlops' sqlcon parameter?
ex: if i have 1 database on a database server defined by sqlcon, and i have 1 UDP child process, i notice that the child process has made 2 TCP connections to the database server. ex: if i have 3 databases on the same database server defined by 3 sqlcon statements (1 pertaining to each database) and i have 4 UDP child processes, i notice that each child process makes 4 TCP connections to the database server. ex: if i have 3 databases on the same database server defined by 3 sqlcon statements (1 pertaining to each database) and i have 6 TCP child processes, i notice that each child process makes 4 TCP connections to the database server.
Basically wanting to know what governs the number of tcp connections a child process makes to a particular database server.
Thank you,
Karthik _______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users