<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif;">
<div>
<div>Hi.</div>
<div><br>
</div>
<div>Thank you for responding. I have now tried to add the parameter you specified in my global.inc file. I have also added “skipNormalize” => 1.</div>
<div>The search does still use forever, and according to my RadiusAcct table all CDRs are already normalized, as the value is set to 1. I don’t see why it still should use that much time..</div>
<div>as they already are normalized..?</div>
<div><br>
</div>
<div>By checking wireshark, the calls to OpenSIPS db still searches for rpid in the subscriber table and each call takes 10 minutes.</div>
<div>The latest search i did now resulted in 8 CDRs and the search took 8x10seconds = 1m 20s.</div>
<div><br>
</div>
<div>My concern is that CDRTool relies on a strict way to use OpenSIPS, as it need certain tables to be filled out?</div>
<div><br>
</div>
<div>We have made another approach to OpenSIPS and are using the grp table for listing our subscribers (not the subscriber table).</div>
<div>We are also using dr_gateways to list our external Gateways (e.g other SIP servers or external GWs).</div>
<div><br>
</div>
<div>We do not use the trusted_peers or subscriber tables which I see are queried from cdrtool.</div>
<div><br>
</div>
<div>My hope was to use CDRTool to rate calls differently if the call is placed internally (userloc-userloc) or from an internal user to an external user (and then lookup destinations with country code).</div>
<div><br>
</div>
<div>Do you see any limitations based on how we use OpenSIPS? </div>
<div><br>
</div>
<div>I really appreciate if you could assist me in the question.</div>
<div><br>
</div>
<div>Regards,</div>
<div>Tomas Andersen</div>
<div>
<div id="MAC_OUTLOOK_SIGNATURE"></div>
</div>
</div>
<div><br>
</div>
<span id="OLK_SRC_BODY_SECTION">
<div style="font-family:Calibri; font-size:12pt; text-align:left; color:black; BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<span style="font-weight:bold">From: </span><<a href="mailto:users-bounces@lists.opensips.org">users-bounces@lists.opensips.org</a>> on behalf of Tijmen de Mes<br>
<span style="font-weight:bold">Reply-To: </span>OpenSIPS users mailling list<br>
<span style="font-weight:bold">Date: </span>Monday 30 November 2015 at 13:01<br>
<span style="font-weight:bold">To: </span>OpenSIPS users mailling list<br>
<span style="font-weight:bold">Subject: </span>Re: [OpenSIPS-Users] CDR search slow in CDRTool<br>
</div>
<div><br>
</div>
<div>
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
Hi Tomas,
<div class=""><br class="">
</div>
<div class="">That query should not take 10 seconds. Here it completes in 0.02s according to mysql. The query is used to determine the flow of the calls. After the query is executed in CDRTool, more logic follows. It can easily be that the delay is in there. </div>
<div class=""><br class="">
</div>
<div class="">If web normalizing is enabled and the call is not normalized, it will also try to normalize and rate the calls while searching. This can be disabled if you don’t need/want it. Perhaps you can disable this to check if this causes the delay. </div>
<div class=""><br class="">
</div>
<div class="">To disable it add to the opensips datasource in global.inc: "skipNormalizeOnPageLoad" => 1</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">Best regards,</div>
<div class=""><br class="">
</div>
<div class="">Tijmen de Mes</div>
<div class="">—</div>
<div class="">AG Projects</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">
<div>
<blockquote type="cite" class="">
<div class="">On 30 nov. 2015, at 10:26, Tomas Andersen <<a href="mailto:tomas.andersen@ipco.no" class="">tomas.andersen@ipco.no</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; font-size: 14px; font-family: Calibri, sans-serif;" class="">
<div class="">
<div class="">Hi again.</div>
<div class=""><br class="">
</div>
<div class="">I have set up wireshark to check why the CDR rating engine uses so much time.</div>
<div class=""><br class="">
</div>
<div class="">The following SQL queries are run from CDRTool to my OpenSIPS server:</div>
<div class="">select * from domain;</div>
<div class="">select * from trusted_peers;</div>
<div class="">Select rpid from subscriber where username = ‘+47xxxxxxxx’ and domain = ‘<a href="http://example.sip.com" class="">example.sip.com</a>’</div>
<div class=""><br class="">
</div>
<div class="">(with username and domain scrambled here)</div>
<div class=""><br class="">
</div>
<div class="">The rpid select statement is run for each caller in the search period. What is strange is that these selects are only run each 10 second, and if I am searching</div>
<div class="">Within a period of time and there has been 7 different callers, it will take 70 seconds. After this the GUI is “released” and updated with the maching CDR list.</div>
<div class=""><br class="">
</div>
<div class="">My subscriber table in open sips is empty. Why does this take so long?</div>
<div class=""><br class="">
</div>
<div class="">Regards,</div>
<div class="">Tomas Andersen</div>
<div class=""><br class="">
</div>
<div class="">
<div id="" class=""></div>
</div>
</div>
<div class=""><br class="">
</div>
<span id="OLK_SRC_BODY_SECTION" class="">
<div style="font-family: Calibri; font-size: 12pt; text-align: left; border-width: 1pt medium medium; border-style: solid none none; padding: 3pt 0in 0in; border-top-color: rgb(181, 196, 223);" class="">
<span style="font-weight:bold" class="">From: </span>Tomas Andersen<br class="">
<span style="font-weight:bold" class="">Date: </span>Friday 27 November 2015 at 09:10<br class="">
<span style="font-weight:bold" class="">To: </span>"<a href="mailto:users@lists.opensips.org" class="">users@lists.opensips.org</a>"<br class="">
<span style="font-weight:bold" class="">Subject: </span>CDR search slow in CDRTool<br class="">
</div>
<div class=""><br class="">
</div>
<div class="">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; font-size: 14px; font-family: Calibri, sans-serif;" class="">
<div class="">Hi</div>
<div class=""><br class="">
</div>
<div class="">I have set up CDRTool to read CDRs from my radius database for OpenSIP calls. I am successfully rating calls, but everytime I search for CDR records using the </div>
<div class="">CDRTool GUI it takes 1-3 minutes before the search result window is shown.</div>
<div class=""><br class="">
</div>
<div class="">If there are no matching records the result window is shown immediately. Does anyone else have any experience with this? I suspect that there might be a database lock,</div>
<div class="">Database connection pool problems or just some configuration error somewhere.</div>
<div class=""><br class="">
</div>
<div class="">In my browser I get the following in my developer console / network (note the huge duration for the HTTP POST):</div>
<div class=""><br class="">
</div>
<div class="">200 POST<span class="Apple-tab-span" style="white-space:pre"> </span>
callsearch.pthml<span class="Apple-tab-span" style="white-space:pre"></span><destip><span class="Apple-tab-span" style="white-space:pre"></span>html<span class="Apple-tab-span" style="white-space:pre"></span>105.41 kb<span class="Apple-tab-span" style="white-space:pre"></span>150212
ms</div>
<div class="">200 GET<span class="Apple-tab-span" style="white-space:pre"> </span>
date picker.css<span class="Apple-tab-span" style="white-space:pre"></span><destip><span class="Apple-tab-span" style="white-space:pre"></span>css<span class="Apple-tab-span" style="white-space:pre"></span>9.96 kb<span class="Apple-tab-span" style="white-space:pre"></span>14
ms</div>
<div class=""><br class="">
</div>
<div class="">Followed by several lines of </div>
<div class="">304 GETs</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">When checking with Wireshark I notice that after the HTTP POST to callsearch, I get several TCP Keep-Alive messages as the server is slow..</div>
<div class="">After 2m 38 seconds everything is suddenly released and some HTTP GETs make the page to update.</div>
<div class=""><br class="">
</div>
<div class="">I see nothing in syslog (from cdrtool) but some mysql connection statements.. No lock/unlock or similar statements..</div>
<div class=""><br class="">
</div>
<div class="">
<div class="">I appreciate if anyone could enlighten me on this subject.</div>
<div class=""><br class="">
</div>
</div>
<div class=""><br class="">
</div>
<div class="">Best Regards,</div>
<div class="">Tomas Andersen</div>
<div class=""> </div>
<div class="">
<div id="" class=""></div>
</div>
</div>
</div>
</span></div>
_______________________________________________<br class="">
Users mailing list<br class="">
<a href="mailto:Users@lists.opensips.org" class="">Users@lists.opensips.org</a><br class="">
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br class="">
</div>
</blockquote>
</div>
<br class="">
</div>
</div>
</div>
</span>
</body>
</html>