[SR-Users] Issue with userblacklist module after 4.4.2 upgrade

Tim Balmer t.balmer at edutel.nl
Wed Jul 6 08:47:59 CEST 2016 

With the latest commit kamailio crashes as soon as the userblacklist module is hit in my config, this is wat I get in the log:

Jul  6 08:45:29 tel-dev-01 [crit] ./kamailio[3229]: CRITICAL: <core> [pass_fd.c:275]: receive_fd(): EOF on 5
Jul  6 08:45:29 tel-dev-01 [alert] ./kamailio[3217]: ALERT: <core> [main.c:739]: handle_sigs(): child process 3226 exited by a signal 11
Jul  6 08:45:29 tel-dev-01 [alert] ./kamailio[3217]: ALERT: <core> [main.c:742]: handle_sigs(): core was generated
Jul  6 08:45:29 tel-dev-01 [info] ./kamailio[3217]: INFO: <core> [main.c:754]: handle_sigs(): terminating due to SIGCHLD
Jul  6 08:45:29 tel-dev-01 [info] ./kamailio[3229]: INFO: <core> [main.c:809]: sig_usr(): signal 15 received
Jul  6 08:45:29 tel-dev-01 [info] ./kamailio[3227]: INFO: <core> [main.c:809]: sig_usr(): signal 15 received
Jul  6 08:45:29 tel-dev-01 [info] ./kamailio[3225]: INFO: <core> [main.c:809]: sig_usr(): signal 15 received
Jul  6 08:45:29 tel-dev-01 [info] ./kamailio[3224]: INFO: <core> [main.c:809]: sig_usr(): signal 15 received
Jul  6 08:45:29 tel-dev-01 [info] ./kamailio[3223]: INFO: <core> [main.c:809]: sig_usr(): signal 15 received
Jul  6 08:45:29 tel-dev-01 [info] ./kamailio[3222]: INFO: <core> [main.c:809]: sig_usr(): signal 15 received
Jul  6 08:45:29 tel-dev-01 [info] ./kamailio[3221]: INFO: <core> [main.c:809]: sig_usr(): signal 15 received
Jul  6 08:45:29 tel-dev-01 [info] ./kamailio[3220]: INFO: <core> [main.c:809]: sig_usr(): signal 15 received
Jul  6 08:45:29 tel-dev-01 [info] ./kamailio[3219]: INFO: <core> [main.c:809]: sig_usr(): signal 15 received
Jul  6 08:45:29 tel-dev-01 [info] ./kamailio[3217]: INFO: <core> [sctp_core.c:53]: sctp_core_destroy(): SCTP API not initialized


Regards,
Tim

-----Oorspronkelijk bericht-----
Van: sr-users [mailto:sr-users-bounces at lists.sip-router.org] Namens Daniel-Constantin Mierla
Verzonden: dinsdag 5 juli 2016 20:15
Aan: Kamailio (SER) - Users Mailing List
Onderwerp: Re: [SR-Users] Issue with userblacklist module after 4.4.2 upgrade

Interesting, because the previous fix was related to the 4th parameter that you weren't actually used. Also, in that case the default value for userblacklist_table should be used, which was not changed either.

I pushed another commit to add a bit more details to the log messages.
Can you try again with the latest 4.4 branch and paste again the log messages?

Cheers,
Daniel


On 05/07/16 16:54, Tim Balmer wrote:
> Of course,
>
> if (check_user_blacklist("$avp(s:caller_uuid)", 
> "$avp(s:caller_domain)", "$avp(s:c_number)"))
>
> Also in my config the userblacklist_table parameter is not set, so it should default to "userblacklist" table then according to the docs.
>
> Also tried this again:
>
> if (check_user_blacklist("$avp(s:caller_uuid)", 
> "$avp(s:caller_domain)", "$avp(s:c_number)", "userblacklist"))
>
> But with the same result.
>
>
> Regards,
> Tim
>
> -----Oorspronkelijk bericht-----
> Van: sr-users [mailto:sr-users-bounces at lists.sip-router.org] Namens 
> Daniel-Constantin Mierla
> Verzonden: dinsdag 5 juli 2016 16:39
> Aan: Kamailio (SER) - Users Mailing List
> Onderwerp: Re: [SR-Users] Issue with userblacklist module after 4.4.2 
> upgrade
>
> Hello,
>
> can you paste here how you execute the userblacklist function in the kamailio.cfg?
>
> Cheers,
> Daniel
>
>
> On 05/07/16 16:30, Tim Balmer wrote:
>> Hi,
>>
>> Unfortunately still the same issue although I have the latest git version now:
>>
>> root at tel-dev-01-[LOC]:~/kamailio# ./kamailio -h
>> version: kamailio 4.4.2 (x86_64/linux) 89c556
>>
>> The I run this latest version:
>> root at tel-dev-01-[LOC]:~/kamailio# ./kamailio -f 
>> /etc/kamailio/kamailio.cfg
>>
>> But still I got this in the logfile:
>>
>> Jul  5 16:15:09 tel-dev-01 [err] ./kamailio[3334]: ERROR: db_mysql
>> [km_dbase.c:128]: db_mysql_submit_query(): driver error on query: 
>> Table 'kamailio.<number> doesn't exist (1146) Jul  5 16:15:09 tel-dev-01 [err] ./kamailio[3334]: ERROR: <core> [db_query.c:132]: db_do_query_internal(): error while submitting query Jul  5 16:15:09 tel-dev-01 [err] ./kamailio[3334]: ERROR: userblacklist [db.c:68]: db_build_userbl_tree(): error while executing query.
>> Jul  5 16:15:09 tel-dev-01 [err] ./kamailio[3334]: ERROR: 
>> userblacklist [userblacklist.c:277]: check_user_list(): cannot build 
>> d-tree
>>
>> Regards,
>> Tim
>>
>> -----Oorspronkelijk bericht-----
>> Van: sr-users [mailto:sr-users-bounces at lists.sip-router.org] Namens 
>> Daniel-Constantin Mierla
>> Verzonden: dinsdag 5 juli 2016 15:39
>> Aan: Kamailio (SER) - Users Mailing List
>> Onderwerp: Re: [SR-Users] Issue with userblacklist module after 4.4.2 
>> upgrade
>>
>> 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-bounces at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

More information about the sr-users mailing list