Hello Ben and Rik,
First off thank you guys for your reply!
In regards to ben, the request domain should be set if there’s a value found in
the cache_local. I went ahead and added another $rd = avp(PBX) and it still
didn’t like it.
I also Xlogged each segment of the intial routing script. It looks like its
returning the proper value
I’m still getting a bad host name error though, almost as if its not modifying
the request uri’s domain
Feb 24 08:06:40 localhost /sbin/opensips[7661]: ERROR:tm:uri2proxy: bad host
name in URI <sip:5204991249@<null>:5060>
even though im telling it what to set in my logic.
if (cache_fetch("local",'$fU',$avp(PBX)))
{
$rd = $avp(PBX);
xlog("this is the Value of the Cache_local
r-uri domain: $avp(PBX) for $fU");
}
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{s.escape.common})'))", "$avp(PBX)");
cache_store("local",'$fU',"$avp(PBX)");
$rd = $avp(PBX);
xlog("this is the Value of the AVP_DB_Querry r-uri
domain: $rd");
xlog("this is the Value of the AVP_DB_Querry pseudo
variable: $avp(PBX) for $fU");
}
From: [email protected]
[mailto:[email protected]] On Behalf Of Newlin, Ben
Sent: Wednesday, February 24, 2016 7:09 AM
To: OpenSIPS users mailling list <[email protected]>
Subject: Re: [OpenSIPS-Users] question about avp DB querry
In the case where you perform the SQL query I don’t see where you are actually
setting the result into the Request-URI. You seem to only be storing it in the
cache. I think you need to add:
$rd = $avp(PBX);
to the else leg.
Ben Newlin
From:
<[email protected]<mailto:[email protected]>> on
behalf of Travis Manson-Drake
<[email protected]<mailto:[email protected]>>
Reply-To: OpenSIPS users mailling list
<[email protected]<mailto:[email protected]>>
Date: Tuesday, February 23, 2016 at 6:21 PM
To: OpenSIPS users mailling list
<[email protected]<mailto:[email protected]>>
Subject: [OpenSIPS-Users] question about avp DB querry
Hello Everyone.
For some reason whenever I try to call a host behind my proxy (who’s a just a
relay for the PBX) I get the following
Feb 23 16:10:40 localhost /sbin/opensips[6017]: ERROR:tm:uri2proxy: bad host
name in URI <sip:5204991249@<null<sip:5204991249@%3cnull>>:5060>
Feb 23 16:10:40 localhost /sbin/opensips[6017]: ERROR:tm:t_forward_nonack:
failure to add branches
I get that it cant route it because theres no valid domain.
However, in my logic I have it lookup the domain based on $fU and then append
it to the request.
For example:
route
{
if (cache_fetch("local",'$fU',$avp(PBX)))
{
$rd = $avp(PBX);
}
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{s.escape.common})'))", "$avp(PBX)");
cache_store("local",'$fU',"$avp(PBX)");
}
if ($ct.fields(expires) == '0')
{
cache_remove("local",'$fU');
exit;
}
I can even see the query being run in my mysql.log. and its returning the
correct result.
Any idea’s on this one?
Travis Manson-Drake
Voice Systems Analyst
Simply Bits, LLC
T:520.545.0311 F:520.545.7252
E:[email protected]<mailto:[email protected]>
5225 N. Sabino Canyon Road
Tucson, AZ 85750
Support Hotline: 520.545.0333
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
