<html><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"><meta name="Generator" content="Microsoft Word 12 (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;}
@font-face
        {font-family:Consolas;
        panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        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;}
span.EstiloCorreo17
        {mso-style-type:personal-compose;
        font-family:Consolas;
        color:windowtext;}
.MsoChpDefault
        {mso-style-type:export-only;}
@page WordSection1
        {size:612.0pt 792.0pt;
        margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.WordSection1
        {page:WordSection1;}
--></style></head><body lang="ES-CL" link="blue" vlink="purple"><div class="WordSection1"><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">Hello.</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">I’m having a problems using the avpops with the kamailio version 3.1.2</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">I have the next configuration:</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas"> </span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">modparam("avpops", "db_url", "mysql://openser:openserrw@localhost/openser")</span></p><p class="MsoNormal">
<span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">modparam("avpops", "avp_table", "usr_preferences")</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas"> </span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">-----</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas"> </span></p><p class="MsoNormal">
<span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">route[REQINIT] {</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas"> </span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas"> if( !(avp_db_load("pike", "s:ip_origen") && avp_check("s:ip_origen", "eq/$src_ip/gi")) )</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas"> {</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas"> …</span></p><p class="MsoNormal">
<span lang="EN-US" style="font-size:10.0pt;font-family:Consolas"> } </span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas"> </span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">mysql> select * from usr_preferences;</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">+----+------+----------+--------+-----------+------+---------------+---------------------+</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">| id | uuid | username | domain | attribute | type | value | last_modified |</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">+----+------+----------+--------+-----------+------+---------------+---------------------+</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">| 1 | pike | 0 | | ip_origen | 0 | 100.20.100.20 | 1900-01-01 00:00:01 |</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">+----+------+----------+--------+-----------+------+---------------+---------------------+</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">1 row in set (0.00 sec)</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas"> </span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">When I try to start kamailio I’m getting the next error :</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas"> </span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">Apr 1 10:36:08 kamailio[15418]: ERROR: avpops [avpops_parse.c:129]: error - bad avp flags</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">Apr 1 10:36:08 kamailio[15418]: ERROR: avpops [avpops.c:299]: parse failed</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">Apr 1 10:36:08 kamailio[15418]: ERROR: <core> [route.c:1161]: fixing failed (code=-1) at cfg:/usr/local/etc/kamailio/kamailio.cfg:238</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">Apr 1 10:36:08 kamailio[15418]: ERROR: <core> [route.c:1161]: fixing failed (code=-1) at cfg:/usr/local/etc/kamailio/kamailio.cfg:263</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas"> </span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas"> </span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">I can’t find the problem.</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">Can someone help me?</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas"> </span></p><p class="MsoNormal">
<span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">Regards.</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">Ricardo.-</span></p><p class="MsoNormal"> </p></div>
</body></html>