Hello, can you try now with latest branch 4.4?
Thanks, Daniel On 05/07/16 14:26, Tim Balmer wrote: > Hi Daniel, > > Thanks for your quick response, please let me know if you want me to test > something. > > > Cheers, > Tim > > -----Oorspronkelijk bericht----- > Van: sr-users [mailto:sr-users-boun...@lists.sip-router.org] Namens > Daniel-Constantin Mierla > Verzonden: dinsdag 5 juli 2016 14:21 > Aan: Kamailio (SER) - Users Mailing List > Onderwerp: Re: [SR-Users] Issue with userblacklist module after 4.4.2 upgrade > > Hello, > > I did some backports based on an issue reported previously. Likely to be a > regression of that. I will check later and come back here with the results. > > Cheers, > Daniel > > > On 05/07/16 14:07, Tim Balmer wrote: >> Hello, >> >> We are running Kamailio version 4.4 and have our sipproxy servers configured >> to do auto updates within te same major version based on a 4 weekly schedule >> (we have 4 sipproxy / Kamailio servers). So this morning as expected the >> first of our sipproxy servers automatically upgraded from 4.4.1 to 4.4.2, >> unfortunately after this update we have issues with the userblacklist module. >> >> The problem is that with the 4.4.2 release every number is now matching our >> userblacklists although it is not really blacklisted. After some digging in >> the logs I found this is probably because the userblacklist module is >> looking for the wrong database table. With every check_user_blacklist call I >> see errors like this appearing in the logs: >> >> Jul 5 13:24:03 tel-dev-01 [err] /usr/sbin/kamailio[2834]: ERROR: >> db_mysql [km_dbase.c:128]: db_mysql_submit_query(): driver error on >> query: Table 'kamailio.<number>' doesn't exist (1146) Jul 5 13:24:03 >> tel-dev-01 [err] /usr/sbin/kamailio[2834]: ERROR: <core> [db_query.c:132]: >> db_do_query_internal(): error while submitting query Jul 5 13:24:03 >> tel-dev-01 [err] /usr/sbin/kamailio[2834]: ERROR: userblacklist [db.c:68]: >> db_build_userbl_tree(): error while executing query. >> Jul 5 13:24:03 tel-dev-01 [err] /usr/sbin/kamailio[2834]: ERROR: >> userblacklist [userblacklist.c:277]: check_user_list(): cannot build >> d-tree >> >> I replaced the real number with <number> in the log output but it seems like >> the userblacklist module is now looking for a database table with the name >> of the number to check against. On our development server I tested setting >> the global userblacklist_table parameter and also passing the table >> parameter within the check_user_blacklist call but both are not making any >> difference. >> >> After downgrading the sipproxy back to 4.4.1 everything is working as >> expected again so it looks to me like a bug in the 4.4.2 release. Is anyone >> else experiencing the same issues after the 4.4.2 upgrade or is it just me >> doing something wrong? >> >> >> Best Regards, >> >> Tim Balmer >> >> >> _______________________________________________ >> 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://www.kamailio.org 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 > _______________________________________________ > 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://www.kamailio.org 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
