<p>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:</p>

<p>[group]<br>
ssl-ca=/etc/mysql/ca-cert.pem<br>
ssl-cert=/etc/mysql/client-cert.pem<br>
ssl-key=/etc/mysql/client-key.pem</p>

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

<p>kamailio.conf:</p>

<p>listen=192.98.102.33:5060<br>
fork=yes<br>
log_stderror=no<br>
log_facility=LOG_LOCAL0<br>
debug=2</p>

<p>loadmodule "tm"<br>
loadmodule "auth"<br>
loadmodule "sl"<br>
loadmodule "pv"<br>
loadmodule "auth_db"<br>
loadmodule "dialplan"<br>
loadmodule "domain"<br>
loadmodule "htable"<br>
loadmodule "permissions"<br>
loadmodule "pua"<br>
loadmodule "db_mysql"<br>
loadmodule "sqlops"<br>
loadmodule "xlog"</p>

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

<p>route {</p>

<pre><code>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;
</code></pre>

<p>}</p>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br>Reply to this email directly or <a href="https://github.com/kamailio/kamailio/issues/58">view it on GitHub</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AF36ZbpM8H1MfK7HY1AsK_C938rjS0TRks5nmZV2gaJpZM4DYuUy.gif" width="1" /></p>
<div itemscope itemtype="http://schema.org/EmailMessage">
  <div itemprop="action" itemscope itemtype="http://schema.org/ViewAction">
    <link itemprop="url" href="https://github.com/kamailio/kamailio/issues/58"></link>
    <meta itemprop="name" content="View Issue"></meta>
  </div>
  <meta itemprop="description" content="View this Issue on GitHub"></meta>
</div>