<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hello,<br>
<br>
On 4/1/11 5:21 PM, Ricardo Martinez wrote:
<blockquote
cite="mid:84572d0a8a7172632c02957f049167c6@mail.gmail.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<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>
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US">Hello.</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US">I’m having a problems using the
avpops with the kamailio version 3.1.2</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US">I have the next configuration:</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US">modparam("avpops", "db_url",
"mysql://openser:openserrw@localhost/openser")</span></p>
<p class="MsoNormal">
<span style="font-size: 10pt; font-family: Consolas;"
lang="EN-US">modparam("avpops", "avp_table",
"usr_preferences")</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US">-----</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US"> </span></p>
<p class="MsoNormal">
<span style="font-size: 10pt; font-family: Consolas;"
lang="EN-US">route[REQINIT] {</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US"> if( !(avp_db_load("pike",
"s:ip_origen") && avp_check("s:ip_origen",
"eq/$src_ip/gi")) )</span></p>
</div>
</blockquote>
<br>
you have to use full avp names in the parameters, like
$avp(ip_origen) . Note that 's:' is optional now if the name of the
avp is string.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<blockquote
cite="mid:84572d0a8a7172632c02957f049167c6@mail.gmail.com"
type="cite">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US"> {</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US"> …</span></p>
<p class="MsoNormal">
<span style="font-size: 10pt; font-family: Consolas;"
lang="EN-US"> } </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US">mysql> select * from
usr_preferences;</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US">+----+------+----------+--------+-----------+------+---------------+---------------------+</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US">| id | uuid | username | domain |
attribute | type | value | last_modified |</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US">+----+------+----------+--------+-----------+------+---------------+---------------------+</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US">| 1 | pike | 0 | |
ip_origen | 0 | 100.20.100.20 | 1900-01-01 00:00:01 |</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US">+----+------+----------+--------+-----------+------+---------------+---------------------+</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US">1 row in set (0.00 sec)</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US">When I try to start kamailio I’m
getting the next error :</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US">Apr 1 10:36:08 kamailio[15418]:
ERROR: avpops [avpops_parse.c:129]: error - bad avp flags</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US">Apr 1 10:36:08 kamailio[15418]:
ERROR: avpops [avpops.c:299]: parse failed</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US">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 style="font-size: 10pt; font-family:
Consolas;" lang="EN-US">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 style="font-size: 10pt; font-family:
Consolas;" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US">I can’t find the problem.</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US">Can someone help me?</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US"> </span></p>
<p class="MsoNormal">
<span style="font-size: 10pt; font-family: Consolas;"
lang="EN-US">Regards.</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
Consolas;" lang="EN-US">Ricardo.-</span></p>
<p class="MsoNormal"> </p>
</div>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.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-freetext" href="http://www.asipto.com">http://www.asipto.com</a></pre>
</body>
</html>