[OpenSIPS-Users] Get IP/Port of registered user (or from Location table?)

[bluerain]

Hello Liviu,

thanks for the help.  Although one more question, on your "sip:FRANK101 at ip";

What is the "@ip"?  is that the IP of the "domain" field in the subscriber
table, or the IP in the "contact" field of the location table?

here is an example of what in my "contact" field of the "location" table:

sip:FRANK101 at 192.168.2.160:5060;transport=udp

So, do I put the entire line in the $var(aor) or I have to search for the
";" and then truncate and manipulate the "contact" field to just
"sip:FRANK101 at 192.168.2.160"  and then put it in the variable?

And sorry, lastly, just a side question regarding the location table, why is
it sometime I would see all my data in the "location" table disappear, but
when I do a "opensipsctl ul show --brief" I do see all the AOR entry and
that all the device are registered with OpenSIP.  And then even if I do a
"opensipsctl fifo ul_flush"  it still does not update the mysql database.

Sorry, another question, I also tried to use MS SQL SERVER 2008 as backend
database for usr_loc module, but it simply won't start.  I have many other
module running on SQL SERVER 2008 R2, the only 2 module I have problem is
the usr_loc and dialog module.

I even did a SQL profilier on the database, I do see opensips query the
database (select fields from location), but after that, it just won't start. 
The only way can use SQL SERVER 2008 as backend for usr_loc is if I do
db_mode 3, but I think OpenSIP crashes when it tries to read from the
database when in db_mode 3.

anyhow. Sorry for all the question, the most important one is the AOR format
for the lookup function call, if you can help me out on that, it will be
great!

Thank you!




--
View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/Get-IP-Port-of-registered-user-or-from-Location-table-tp7588494p7588543.html
Sent from the OpenSIPS - Users mailing list archive at Nabble.com.