Better try the URI transformation:
$(du{uri.host})
to extract the ip part of the destination URI.
Regards,
Bogdan
Sent from Samsung Mobile
-------- Original message --------
From: Miguel Oyarzo <[email protected]>
Date:19/06/2014 15:17 (GMT+02:00)
To: Bogdan-Andrei Iancu <[email protected]>
Subject: Re: [OpenSIPS-Users] Best way to retrieve a data from location
database
Hi Bodgan,
I found this variable: $ds
It has the value what I need. Then, a small string subtract like
avp_subst("$avp(msg)/$avp(IP)/g","/^.*@([0-9\.]*):.*$/\1/s");
And got the IP from the location table. All good, love Opensips.
Thanks!
On Thu, Jun 19, 2014 at 8:14 PM, Bogdan-Andrei Iancu <[email protected]>
wrote:
and what is the data you are looking for ?
look at the attr_avp param too :
http://www.opensips.org/html/docs/modules/1.11.x/registrar.html#id293909
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com
On 19.06.2014 12:56, Miguel Oyarzo wrote:
Hi Bodgan,
Oh yes, but this function (lookup) doesn't seems to return the data what I'm
looking for inside of this specific table.
At least, the documentation you mentioned doesn't show an example.
Is there any way to retrieve data from that table? I need specifically the
contact info stored into location, for the specif user.
Thanks,
On Thu, Jun 19, 2014 at 7:52 PM, Bogdan-Andrei Iancu <[email protected]>
wrote:
Hi Miguel,
Have you looked at the lookup() function from the registrar module ?
http://www.opensips.org/html/docs/modules/1.11.x/registrar.html#id294366
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com
On 19.06.2014 12:48, Miguel Oyarzo wrote:
Hi,
What is the best way to read a data from the location database?
I'm using postgreSQL.
E.g. Assuming there is a registered user:
if (is_method("INVITE")) {
$var(x)=read_data_from_location(" select contact where user='71000' ");
...
// do something with $var(x)
..
..
}
Thanks,
--
"Efficiency is doing things right; effectiveness is doing the right things
(Peter Drucker)"
Miguel Oyarzo
DevOps & VoIP Engineer
Linux User: # 483188 - counter.li.org
http://au.linkedin.com/in/mikeaustralia
Melbourne, Australia
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
--
"Efficiency is doing things right; effectiveness is doing the right things
(Peter Drucker)"
Miguel Oyarzo
DevOps & VoIP Engineer
Linux User: # 483188 - counter.li.org
http://au.linkedin.com/in/mikeaustralia
Melbourne, Australia
--
"Efficiency is doing things right; effectiveness is doing the right things
(Peter Drucker)"
Miguel Oyarzo
DevOps & VoIP Engineer
Linux User: # 483188 - counter.li.org
http://au.linkedin.com/in/mikeaustralia
Melbourne, Australia_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
