Hello,

thanks for troubleshooting further - it looks like an issue, I am going to check the sources.

Cheers,
Daniel

On 8/14/13 8:55 PM, Daniel W. Graham wrote:

Here is the debug output:

Aug 14 14:47:36 SIP01 /usr/local/sbin/kamailio[30423]: INFO: <script>: Location route

Aug 14 14:47:36 SIP01 /usr/local/sbin/kamailio[30423]: ERROR: *** cfgtrace: c=[/usr/local/etc/kamailio/kamailio.cfg] l=506 a=16 n=if

Aug 14 14:47:36 SIP01 /usr/local/sbin/kamailio[30423]: ERROR: *** cfgtrace: c=[/usr/local/etc/kamailio/kamailio.cfg] l=501 a=27 n=is_subscriber

Aug 14 14:47:36 SIP01 /usr/local/sbin/kamailio[30423]: DEBUG: auth_db [authdb_mod.c:291]: w_is_subscriber(): uri [sip:us...@domain.com] table [sip_accounts] flags [1]

Aug 14 14:47:36 SIP01 /usr/local/sbin/kamailio[30423]: ERROR: <core> [db_ut.c:280]: db_print_columns(): Invalid parameter value

Aug 14 14:47:36 SIP01 /usr/local/sbin/kamailio[30423]: ERROR: auth_db [authorize.c:97]: fetch_credentials(): failed to query database

*From:* sr-users-boun...@lists.sip-router.org [mailto:sr-users-boun...@lists.sip-router.org] *On Behalf Of *Daniel W. Graham
*Sent:* Wednesday, August 14, 2013 1:06 PM
*To:* sr-users@lists.sip-router.org
*Subject:* [SR-Users] is_subscriber function

I am having an issue with the is_subscriber function provided by auth_db module. What I want to accomplish is: if the call is not to a local subscriber then route via LCR. If the call is to a local subscriber then route via LOCATION.

My subscriber table is called sip_accounts and I am using multidomain so domain is populated in subscriber definitions.

Here is my routing block-

if (!is_subscriber("$ru", "sip_accounts", "1")){

route(LCR);

exit;

} else {

route(LOCATION);

exit;

}

Call always routes via LCR despite calling a local subscriber.

INVITE is correct:

INVITE sip:us...@domain.com SIP/2.0.

From: user1 <sip:us...@domain.com>;tag=520c9f9ade1e7026o0.

To: <sip:us...@domain.com>.

Any ideas or direction where my issue could be?

-dan



_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

--
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda

_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Reply via email to