Re: [SR-Users] is_subscriber function

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:user2@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-bounces(a)lists.sip-router.org [mailto:sr-users-bounces@lists.sip-router.org] On Behalf Of Daniel W. Graham Sent: Wednesday, August 14, 2013 1:06 PM To: sr-users(a)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:user2@domain.com SIP/2.0. From: user1 <sip:user1@domain.com>;tag=520c9f9ade1e7026o0. To: <sip:user2@domain.com>. Any ideas or direction where my issue could be? -dan