[SR-Users] Problems with avp_db_load

[Daniel-Constantin Mierla]

Hello,

can you run with debug=3 in kamailio.cfg and send all the debug messages
printed in syslog for this situation?

Cheers,
Daniel


On 29.03.17 20:48, Kevin Bushong wrote:
>
> I am using the avpops module to read from a mysql database to look for
> CFWD information for the call.  When a call is placed, it appears the
> command avp_db_load attempts to read the file but all values come back
> as NULL.  There are no messages in the log and of course the call does
> not process correctly.
>
>  
>
>  
>
> We are using a config that is exactly the same on a 4.3.4 version of
> kamailio using cento 6.7, with a local version of mysql  Ver 14.14
> Distrib 5.1.73, that works perfectly.  When moving the code to
> kamailio 4.4.4 on Debian 8, Jessie, mysql  Ver 14.14 Distrib 5.5.53
> the avp_db_load returns no information.
>
>  
>
> Here is the snippet of the code we are using.  Since I am not used to
> troubleshooting kamailio, please let me know what other information
> you need.
>
>  
>
> Thanks,
>
>  
>
> Kevin
>
>  
>
>  
>
> Code snippet:
>
>  
>
> #!ifdef WITH_CFWD
>
>         xlog ("$TF Call to $rU made it into WITH_CFWD in
> route[LOCATION] block\n");
>
>         # Call forwarding is enabled, so lets do a lookup to pull all
> AVP's for possible call forwarding types/destinations
>
>         # Below line should load all AVP's into memory from DB for the
> username portion of the TO: field from table usr_preferences
>
>         xlog("script should load from DB usr_preferences next");
>
>         avp_db_load("$tU","s/usr_preferences");
>
>         # This line i simple want to print to log when the avp load is
> complete and what the values are (for debug purposes only and should
> typically be commented out)
>
>         xlog("DB load should be complete");
>
>         xlog("SCRIPT: $TF Call Forwarding Unconditional set to
> $avp(Unconditional)\n");
>
>         xlog("SCRIPT: $TF Call Forwarding NoAnswer set to
> $avp(NoAnswer)\n");
>
>         xlog("SCRIPT: $TF Call Forwarding Busy set to $avp(Busy)\n");
>
>         avp_print();
>
>         # Check to see if the AVP's are set and if so put them in log
> for logging purposes
>
>         if(is_avp_set("$avp(Unconditional)"))
>
>         xlog("SCRIPT: $TF Call Forwarding Unconditional set to
> $avp(Unconditional)\n");
>
>         if(is_avp_set("$avp(NoAnswer)"))
>
>         xlog("SCRIPT: $TF Call Forwarding NoAnswer set to
> $avp(NoAnswer)\n");
>
>         if(is_avp_set("$avp(Busy)"))
>
>         xlog("SCRIPT: $TF Call Forwarding Busy set to $avp(Busy)\n");
>
>         t_set_fr(16000, 15000); # set fr invite timeout to 16s and no
> response at all to 15s to meet the specs for call fowarding no answer
> ringtime
>
>  
>
>  
>
>         # If Call fowarding Unconditional is set, we need to change
> the dialed number and sent it off to the original users trunk from
> subscriber table
>
>  
>
>         # Check to see if unconditional is set
>
>         if(is_avp_set("$avp(Unconditional)"))
>
>         # Shove this call into route [PSTN_CFWD] Block
>
>         route("PSTN_CFWD");
>
>  
>
>  
>
> Here is the syslog for the same snippet:
>
> 09:29 2017 Call to 15703771055 made it into WITH_CFWD in
> route[LOCATION] block
>
> Mar 29 14:09:29 Limitless-Calling-Server
> /usr/local/sbin/kamailio[7831]: ERROR: <script>: script should load
> from DB usr_preferences next
>
> Mar 29 14:09:29 Limitless-Calling-Server
> /usr/local/sbin/kamailio[7831]: ERROR: <script>: DB load should be
> complete
>
> Mar 29 14:09:29 Limitless-Calling-Server
> /usr/local/sbin/kamailio[7831]: ERROR: <script>: SCRIPT: Wed Mar 29
> 14:09:29 2017 Call Forwarding Unconditional set to <null>
>
> Mar 29 14:09:29 Limitless-Calling-Server
> /usr/local/sbin/kamailio[7831]: ERROR: <script>: SCRIPT: Wed Mar 29
> 14:09:29 2017 Call Forwarding NoAnswer set to <null>
>
> Mar 29 14:09:29 Limitless-Calling-Server
> /usr/local/sbin/kamailio[7831]: ERROR: <script>: SCRIPT: Wed Mar 29
> 14:09:29 2017 Call Forwarding Busy set to <null>
>
> Mar 29 14:09:29 Limitless-Calling-Server
> /usr/local/sbin/kamailio[7831]: INFO: avpops [avpops_impl.c:1473]:
> ops_print_avp(): p=0x7f440ed86f90, flags=0x0113
>
> Mar 29 14:09:29 Limitless-Calling-Server
> /usr/local/sbin/kamailio[7831]: INFO: avpops [avpops_impl.c:1477]:
> ops_print_avp(): #011#011#011name=<direction>
>
> Mar 29 14:09:29 Limitless-Calling-Server
> /usr/local/sbin/kamailio[7831]: INFO: avpops [avpops_impl.c:1485]:
> ops_print_avp(): #011#011#011val_str=<INCOMING / 8>
>
>  
>
>  
>
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio Advanced Training - May 22-24 (USA) - www.asipto.com
Kamailio World Conference - May 8-10, 2017 - www.kamailioworld.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20170330/c7a2867e/attachment.html>