<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Courier New";}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.dt1
{mso-style-name:dt1;}
span.EmailStyle23
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Apologies, that shouldn’t have been added to this thread. Will post again separately.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><span style="color:black">Ben Newlin </span><o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:12.0pt;color:black">From: </span></b><span style="font-size:12.0pt;color:black">Users <users-bounces@lists.opensips.org> on behalf of Ben Newlin <Ben.Newlin@genesys.com><br>
<b>Reply-To: </b>OpenSIPS users mailling list <users@lists.opensips.org><br>
<b>Date: </b>Tuesday, January 22, 2019 at 1:57 PM<br>
<b>To: </b>OpenSIPS users mailling list <users@lists.opensips.org><br>
<b>Subject: </b>Re: [OpenSIPS-Users] Opensips caching<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal">Hi,<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<pre style="line-height:11.25pt;background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Since upgrading to 2.4.4 we are seeing the following logs scrolling nearly continuously on our servers:<br><br><br></span><o:p></o:p></pre>
<pre style="line-height:11.25pt;background:white"><span style="font-size:8.5pt;color:#333333">ALERT:core:pv_get_param: BUG: invalid parameter type 1836017711</span><o:p></o:p></pre>
<pre style="line-height:11.25pt;background:white"><span class="dt1"><span style="font-size:9.0pt;color:#F54E25">ERROR</span></span><span style="font-size:8.5pt;color:#333333">:core:comp_scriptvar: cannot get left var value</span><o:p></o:p></pre>
<pre style="line-height:11.25pt;background:white"><span style="font-size:8.5pt;color:#333333">WARNING:core:do_action: </span><span class="dt1"><span style="font-size:9.0pt;color:#F54E25">error</span></span><span style="font-size:8.5pt;color:#333333"> in expression at opensips.cfg:583</span><span style="font-family:"Calibri",sans-serif"><br></span><span style="font-size:8.5pt;color:#333333">ALERT:core:pv_get_param: BUG: invalid parameter type 1836017711</span><o:p></o:p></pre>
<pre style="line-height:11.25pt;background:white"><span class="dt1"><span style="font-size:9.0pt;color:#F54E25">ERROR</span></span><span style="font-size:8.5pt;color:#333333">:core:comp_scriptvar: cannot get left var value</span><o:p></o:p></pre>
<pre style="line-height:11.25pt;background:white"><span style="font-size:8.5pt;color:#333333">WARNING:core:do_action: </span><span class="dt1"><span style="font-size:9.0pt;color:#F54E25">error</span></span><span style="font-size:8.5pt;color:#333333"> in expression at opensips.cfg:583</span><span style="font-family:"Calibri",sans-serif"><br></span><span style="font-size:8.5pt;color:#333333">ALERT:core:pv_get_param: BUG: invalid parameter type 1836017711</span><o:p></o:p></pre>
<pre style="line-height:11.25pt;background:white"><span class="dt1"><span style="font-size:9.0pt;color:#F54E25">ERROR</span></span><span style="font-size:8.5pt;color:#333333">:core:comp_scriptvar: cannot get left var value</span><o:p></o:p></pre>
<pre style="line-height:11.25pt;background:white"><span style="font-size:8.5pt;color:#333333">ALERT:core:pv_get_param: BUG: invalid parameter type 1836017711</span><o:p></o:p></pre>
<pre style="line-height:11.25pt;background:white"><span class="dt1"><span style="font-size:9.0pt;color:#F54E25">ERROR</span></span><span style="font-size:8.5pt;color:#333333">:core:comp_scriptvar: cannot get left var value</span><o:p></o:p></pre>
<pre style="line-height:11.25pt;background:white"><span style="font-size:8.5pt;color:#333333">WARNING:core:do_action: </span><span class="dt1"><span style="font-size:9.0pt;color:#F54E25">error</span></span><span style="font-size:8.5pt;color:#333333"> in expression at opensips.cfg:439</span><o:p></o:p></pre>
<pre style="line-height:11.25pt;background:white"><span style="font-size:8.5pt;color:#333333"> </span><o:p></o:p></pre>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">It seems to be related to our use of the json module. We often pass json variable types as parameters to other routes and I believe the errors are caused by that. But it’s hard to say as there are a few different script lines referenced
in the errors, but some of them point to return statements and other code sections that don’t really make sense. For example, line 583 referenced in the error above is:<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:"Courier New";color:#333333"> return(-1);</span><o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Any ideas?<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<div>
<p class="MsoNormal"><span style="color:black">Ben Newlin </span><o:p></o:p></p>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:12.0pt;color:black">From: </span></b><span style="font-size:12.0pt;color:black">Users <users-bounces@lists.opensips.org> on behalf of Ben Newlin <Ben.Newlin@genesys.com><br>
<b>Reply-To: </b>OpenSIPS users mailling list <users@lists.opensips.org><br>
<b>Date: </b>Thursday, January 17, 2019 at 8:51 AM<br>
<b>To: </b>OpenSIPS users mailling list <users@lists.opensips.org><br>
<b>Subject: </b>Re: [OpenSIPS-Users] Opensips caching</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<p class="MsoNormal">No, the dynamic routing module will cache the entire configuration and only read from memory. It must be reloaded when the configuration changes. It’s very quick.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<div>
<p class="MsoNormal"><span style="color:black">Ben Newlin </span><o:p></o:p></p>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:12.0pt;color:black">From: </span></b><span style="font-size:12.0pt;color:black">Users <users-bounces@lists.opensips.org> on behalf of Schneur Rosenberg <rosenberg11219@gmail.com><br>
<b>Reply-To: </b>OpenSIPS users mailling list <users@lists.opensips.org><br>
<b>Date: </b>Thursday, January 17, 2019 at 2:44 AM<br>
<b>To: </b>OpenSIPS users mailling list <users@lists.opensips.org><br>
<b>Subject: </b>Re: [OpenSIPS-Users] Opensips caching</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">I believe that dynamic routing runs a SQL query every time, I don't think that can be cached, but if you do your own logic in opensips, you should be able to use cashedb_memcached<o:p></o:p></p>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<div>
<div>
<p class="MsoNormal">On Thu, Jan 17, 2019, 9:40 AM Schneur Rosenberg <<a href="mailto:rosenberg11219@gmail.com">rosenberg11219@gmail.com</a> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt">
<div>
<p class="MsoNormal">In the script you have multiple caching options, cache_store and cache_fetch from cachedb_mamcached work without external servers like cachedb_mongo that requires mongodb or other nosql modules.<o:p></o:p></p>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<div>
<div>
<p class="MsoNormal">On Thu, Jan 17, 2019, 9:18 AM Vishal Pai <<a href="mailto:vishalmpai@gmail.com" target="_blank">vishalmpai@gmail.com</a> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt">
<div>
<div>
<p class="MsoNormal">Hello everyone<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">what is the best way to implement the caching in opensips. I am doing following<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">we have a rate table with NPANXX with rate per minute. Every time when we do outbound calls we get NPANXX of dialed number and search it in database. Since in this way it will create a load on cpu for each select query.
<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Can anyone help me in this also let me know if there is any caching functionality is available in opensips ?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Vishal Pai <o:p></o:p></p>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><o:p></o:p></p>
</blockquote>
</div>
</blockquote>
</div>
</div>
</body>
</html>