[sr-dev] [kamailio] use of ssl causes increase of mysql connections (#58)

[juha-h]

Below is an example kamailio.conf, where addition of [group] to "db_url" value increases number of mysql connections from 36 to 70.  [group] is defined in in my.cfg as:

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

With sqlops module alone the number of mysql connections is the same with or without [group].

kamailio.conf:

listen=192.98.102.33:5060
fork=yes
log_stderror=no
log_facility=LOG_LOCAL0
debug=2

loadmodule "tm"
loadmodule "auth"
loadmodule "sl"
loadmodule "pv"
loadmodule "auth_db"
loadmodule "dialplan"
loadmodule "domain"
loadmodule "htable"
loadmodule "permissions"
loadmodule "pua"
loadmodule "db_mysql"
loadmodule "sqlops"
loadmodule "xlog"

modparam("auth_db|dialplan|domain|htable|permissions|pua", "db_url", "mysql://user:pass@[group]127.0.0.1/sip_proxy")
modparam("sqlops", "sqlcon", "sip_proxy => mysql://user:pass@[group]127.0.0.1/sip_proxy")

route {

    sql_query("sip_proxy", "show status like 'ssl_cipher'", "result"); 
    xlog("L_INFO", "**** got result <variable=$dbr(result=>[0, 0])/value=$dbr(result=>[0, 1])>\n"); 
    sql_result_free("result"); 
    exit;

}


---
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/issues/58
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20150128/7b2aae32/attachment-0001.html>