<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hello,</p>
<p>in most of the cases, kamailio keeps the connections open for the
entire duration of running. A connection is shared between modules
for the same kamailio process, so if you have auth_db and
siptrace, both will use same connection. How many kamailio
processes (and thus number of db connections) are there is a
matter of children and listen parameters, as well as couple of
extra special processes (timers, rpc servers, ...).</p>
<p>Keeping the connection open is done mainly for performance
reasons.<br>
</p>
<p>Cheers,<br>
Daniel<br>
</p>
<br>
<div class="moz-cite-prefix">On 31.08.18 07:31, Roman Dissauer
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:3DAE0EE9-1DF0-43F8-82CB-27FD586912A0@dissauer.net">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
Hi,
<div class=""><br class="">
</div>
<div class="">it seems that siptrace module doesn’t close db
connections.</div>
<div class=""><br class="">
</div>
<div class="">I’m on Kamailio 5.1.4 from official debian stretch
repository with postgresql db module enabled.</div>
<div class="">siptrace config:</div>
<div class="">
<div style="margin: 0px; font-stretch: normal; line-height:
normal; font-family: Courier; color: rgb(77, 47, 45);
background-color: rgb(223, 219, 195);" class=""><span
style="font-variant-ligatures: no-common-ligatures" class="">modparam("siptrace",
"db_url", DBURL)</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal; font-family: Courier; color: rgb(77, 47, 45);
background-color: rgb(223, 219, 195);" class=""><span
style="font-variant-ligatures: no-common-ligatures" class="">modparam("siptrace",
"duplicate_uri", "<a href="sip:193.32.51.189:9060" class=""
moz-do-not-send="true">sip:193.32.51.189:9060</a>")</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal; font-family: Courier; color: rgb(77, 47, 45);
background-color: rgb(223, 219, 195);" class=""><span
style="font-variant-ligatures: no-common-ligatures" class="">modparam("siptrace",
"hep_mode_on", 1)</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal; font-family: Courier; color: rgb(77, 47, 45);
background-color: rgb(223, 219, 195);" class=""><span
style="font-variant-ligatures: no-common-ligatures" class="">modparam("siptrace",
"hep_version", 3)</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal; font-family: Courier; color: rgb(77, 47, 45);
background-color: rgb(223, 219, 195);" class=""><span
style="font-variant-ligatures: no-common-ligatures" class="">modparam</span><span
style="font-variant-ligatures: no-common-ligatures;
background-color: #00e6e6" class="">(</span><span
style="font-variant-ligatures: no-common-ligatures" class="">"siptrace",
"hep_capture_id", 1001</span><span
style="font-variant-ligatures: no-common-ligatures;
background-color: #00e6e6" class="">)</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal; font-family: Courier; color: rgb(77, 47, 45);
background-color: rgb(223, 219, 195);" class=""><span
style="font-variant-ligatures: no-common-ligatures" class="">modparam("siptrace",
"trace_mode", 1)</span></div>
</div>
<div class=""><br class="">
</div>
<div class="">Here you can see the open connections from the
kamailio host:</div>
<div class=""><br class="">
</div>
<div class="">
<div style="margin: 0px; font-stretch: normal; line-height:
normal; font-family: Courier; color: rgb(77, 47, 45);
background-color: rgb(223, 219, 195);" class="">
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""># select client_addr, state,
query from pg_stat_activity where client_addr =
'10.23.101.61';</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> client_addr | state |
query
</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class="">--------------+-------+----------------------------------------------------------------</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.101.61 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class="">(31 Zeilen)</span></div>
</div>
</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">another example, other installation with same
kamailio version 5.1.4:</div>
<div class=""><br class="">
</div>
<div class="">
<div style="margin: 0px; font-stretch: normal; line-height:
normal; font-family: Courier; color: rgb(77, 47, 45);
background-color: rgb(223, 219, 195);" class="">
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""># select client_addr, state,
query from pg_stat_activity where client_addr =
'10.23.102.1';</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> client_addr | state |
query </span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class="">-------------+-------+----------------------------------------------------------------</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class=""> 10.23.102.1 | idle |
select table_version from version where
table_name='sip_trace'</span></div>
<div style="margin: 0px; font-stretch: normal; line-height:
normal;" class=""><span style="font-variant-ligatures:
no-common-ligatures" class="">(39 Zeilen)</span></div>
</div>
</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">Thanks Roman</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Kamailio (SER) - Users Mailing List
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.kamailio.org">sr-users@lists.kamailio.org</a>
<a class="moz-txt-link-freetext" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla -- <a class="moz-txt-link-abbreviated" href="http://www.asipto.com">www.asipto.com</a>
<a class="moz-txt-link-abbreviated" href="http://www.twitter.com/miconda">www.twitter.com/miconda</a> -- <a class="moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda">www.linkedin.com/in/miconda</a>
Kamailio World Conference -- <a class="moz-txt-link-abbreviated" href="http://www.kamailioworld.com">www.kamailioworld.com</a>
Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- <a class="moz-txt-link-abbreviated" href="http://www.asipto.com">www.asipto.com</a></pre>
</body>
</html>