[sr-dev] running out of mysql connections when [group] is given

Juha Heinanen jh at tutpro.com
Tue Jan 20 23:52:49 CET 2015


with latest master, i tried to add [group] to mysql db_urls and sqlops
urls, eg.

modparam("mtree", "db_url", "mysql://user:pass@[sip_proxy]127.0.0.1/sip_proxy")

and in my.cfg the group was defined like this:

[sip_proxy]
ssl-ca=/etc/mysql/ca-cert.pem
ssl-cert=/etc/mysql/client-cert.pem
ssl-key=/etc/mysql/client-key.pem

the result was that when i start kamailio, it starts to run out of mysql
connections and dumps core no matter how high i set max_connections in
my.cfg:

Jan 21 00:47:33 siika /usr/bin/sip-proxy[30612]: ERROR: db_mysql [km_my_con.c:114]: db_mysql_new_connection(): driver error: Too many connections
Jan 21 00:47:33 siika /usr/bin/sip-proxy[30612]: ERROR: <core> [db.c:314]: db_do_init2(): could not add connection to the pool
Jan 21 00:47:33 siika /usr/bin/sip-proxy[30612]: ERROR: mtree [mtree_mod.c:346]: mi_child_init(): failed to connect to database
Jan 21 00:47:33 siika /usr/bin/sip-proxy[30612]: ERROR: <core> [sr_module.c:900]: init_mod_child(): Error while initializing module mtree (/usr/lib/sip-proxy/modules/mtree.so)

without the [group] kamailio starts fine and does not complain about too
many connections.

is this a bug in group handling or something else?

-- juha



More information about the sr-dev mailing list