Hello Everyone!

Hope you're all doing well.

I seem to be having an issue.

Basically I'm using OpenSIPS as a proxy that will receive request from UAC's, 
then query a database to find out what Sipserver it belongs to then store the 
result with cachdb_local as an $avp variable, and finally modify the R-uri of 
the sip message to the UAC gets to the correct endpoint. I've got it working 
for the most part however I seem to be having an issue when I try to have 
multiple UAC's hit the proxy.

I think whats happening is the value stored in memchache is the first Sipserver 
the proxy gets a request for.

For example:

If UAC1 sends a REGISTER to the proxy and the proxy finds out it belongs on 
SIPServ1 it then sets the AVP to sipserv1

Now a few minutes later UAC2 comes along with a same REGISTER request but this 
time it belongs to SIPServ2, however this time it receives a 403 bad auth from 
sipserv2.

Here's my current logic for DB query and memcache store:

NOTE: This is also in the REQUEST Route section of my logic, so this takes 
place before it hits any other routing logic.

if(cache_fetch("local","PBX",$avp(PBX)))
                        {
                        $rd = $avp(PBX);
                        xlog("this is the value of the modified R-uri: $ru\n");
                        }
                else {
                        avp_db_query("select Servers.ipaddress from Servers 
where Servers.ID in (select phone.ServerID from phone where phone.mac in 
(select MAC FROM `phone_registrations` where auth_userid = '$fU'))", 
"$avp(PBX)");
                        cache_store("local","PBX","$avp(PBX)",1200);
                     }


Do you guys have any ideas on what I'm missing, or any advice?

Thank you in advanced!

Travis Manson-Drake
Voice Systems Analyst L1
Simply Bits, LLC
Now You're Thinkin' Smart!
5225 N. Sabino Canyon Road
Tucson, AZ 85750
Phone: 520-545-0311
Fax: 520-545-7252
Support Hotline: 5205450333
www.simplybits.com<http://www.simplybits.com/>

_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Reply via email to