<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"></head><body ><div>Better try the URI transformation:</div><div> $(du{uri.host})</div><div> to extract the ip part of the destination URI.</div><div><br></div><div>Regards,</div><div>Bogdan</div><div><br></div><div><br></div><div><div style="font-size:9px;color:#575757">Sent from Samsung Mobile</div></div><br><br>-------- Original message --------<br>From: Miguel Oyarzo <miguelaustro@gmail.com> <br>Date:19/06/2014 15:17 (GMT+02:00) <br>To: Bogdan-Andrei Iancu <bogdan@opensips.org> <br>Subject: Re: [OpenSIPS-Users] Best way to retrieve a data from location database <br><br><div dir="ltr"><div>Hi Bodgan,<br><br></div><div>I found this variable: $ds<br><br></div><div>It has the value what I need. Then, a small string subtract like<br>avp_subst("$avp(msg)/$avp(IP)/g","/^.*@([0-9\.]*):.*$/\1/s");<br>
<br></div><div>And got the IP from the location table. All good, love Opensips.<br></div><div><br></div><div>Thanks!<br></div><div><br></div><br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Jun 19, 2014 at 8:14 PM, Bogdan-Andrei Iancu <span dir="ltr"><<a href="mailto:bogdan@opensips.org" target="_blank">bogdan@opensips.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div><tt>and what is the data you are looking
for ?<br>
<br>
look at the attr_avp param too :<br>
<a href="http://www.opensips.org/html/docs/modules/1.11.x/registrar.html#id293909" target="_blank">http://www.opensips.org/html/docs/modules/1.11.x/registrar.html#id293909</a><br>
<br>
Regards,<br>
</tt><div class="">
<pre cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a></pre></div><div><div class="h5">
On 19.06.2014 12:56, Miguel Oyarzo wrote:<br>
</div></div></div><div><div class="h5">
<blockquote type="cite">
<div dir="ltr">
<div>
<div>
<div>
<div><br>
</div>
Hi Bodgan,<br>
<br>
</div>
Oh yes, but this function (lookup) doesn't seems to return
the data what I'm looking for inside of this specific table.<br>
</div>
<div>At least, the documentation you mentioned doesn't show an
example.<br>
</div>
<div><br>
</div>
Is there any way to retrieve data from that table? I need
specifically the contact info stored into location, for the
specif user.<br>
<br>
</div>
Thanks,<br>
<div><br>
<br>
</div>
</div>
<div class="gmail_extra">
<br>
<br>
<div class="gmail_quote">On Thu, Jun 19, 2014 at 7:52 PM,
Bogdan-Andrei Iancu <span dir="ltr"><<a href="mailto:bogdan@opensips.org" target="_blank">bogdan@opensips.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div><tt>Hi Miguel,<br>
<br>
Have you looked at the lookup() function from the
registrar module ?<br>
<a href="http://www.opensips.org/html/docs/modules/1.11.x/registrar.html#id294366" target="_blank">http://www.opensips.org/html/docs/modules/1.11.x/registrar.html#id294366</a><br>
<br>
Regards,<br>
</tt>
<pre cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a></pre>
<div>
<div> On 19.06.2014 12:48, Miguel Oyarzo
wrote:<br>
</div>
</div>
</div>
<blockquote type="cite">
<div>
<div>
<div dir="ltr">
<div>
<div>
<div>
<div>Hi,<br>
<br>
</div>
What is the best way to read a data from the
location database?<br>
</div>
<div>I'm using postgreSQL.<br>
<br>
</div>
<div><br>
</div>
E.g. Assuming there is a registered user:<br>
<br>
if (is_method("INVITE")) {<br>
</div>
$var(x)=read_data_from_location(" select
contact where user='71000' ");<br>
...<br>
</div>
// do something with $var(x)
<div> ..<br>
..<br>
}<br>
<div> <br>
<div>
<div>
<div>
<div>
<div>
<div>Thanks,<br clear="all">
</div>
<div><br>
-- <br>
<div dir="ltr">
<div><span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">"Efficiency
is doing things right;
effectiveness is doing the
right things</span><span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
(Peter Drucker)</span>"<br>
</span></div>
<br>
<div><span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Miguel
Oyarzo</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">DevOps
& VoIP Engineer</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Linux
User: # 483188 - </span><font color="#888888" face="arial,
sans-serif"><a href="http://counter.li.org" target="_blank">counter.li.org</a></font><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="background-color:rgb(255,255,255)"><font color="#888888" face="arial, sans-serif"><a href="http://au.linkedin.com/in/mikeaustralia" target="_blank">http://au.linkedin.com/in/mikeaustralia</a> </font><br>
<font color="#888888" face="arial, sans-serif">Melbourne,
Australia</font></span> </div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset></fieldset>
<br>
</div>
</div>
<pre>_______________________________________________
Users mailing list
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<br>
-- <br>
<div dir="ltr">
<div><span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">"Efficiency
is doing things right; effectiveness is doing the right
things</span><span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
(Peter Drucker)</span>"<br>
</span></div>
<br>
<div><span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Miguel
Oyarzo</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">DevOps
& VoIP Engineer</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Linux
User: # 483188 - </span><font color="#888888" face="arial,
sans-serif"><a href="http://counter.li.org" target="_blank">counter.li.org</a></font><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="background-color:rgb(255,255,255)"><font color="#888888" face="arial, sans-serif"><a href="http://au.linkedin.com/in/mikeaustralia" target="_blank">http://au.linkedin.com/in/mikeaustralia</a> </font><br>
<font color="#888888" face="arial, sans-serif">Melbourne,
Australia</font></span>
</div>
</div>
</div>
</blockquote>
<br>
</div></div></div>
</blockquote></div><br><br clear="all"><br>-- <br><div dir="ltr"><div><span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">"Efficiency is doing things right; effectiveness is doing the right things</span><span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"> (Peter Drucker)</span>"<br>
</span></div><br><div><span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Miguel Oyarzo</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">DevOps & VoIP Engineer</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Linux User: # 483188 - </span><font color="#888888" face="arial, sans-serif"><a href="http://counter.li.org" target="_blank">counter.li.org</a></font><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="background-color:rgb(255,255,255)"><font color="#888888" face="arial, sans-serif"><a href="http://au.linkedin.com/in/mikeaustralia" target="_blank">http://au.linkedin.com/in/mikeaustralia</a> </font><br><font color="#888888" face="arial, sans-serif">Melbourne, Australia</font></span>
</div></div>
</div>
</body>