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

Tim Balmer t.balmer at edutel.nl
Wed Jul 6 09:46:19 CEST 2016 

Of course, 

Since the backtrace contains some phone numers and stuff I sended the actual backtrace offlist.


Regards,
Tim

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

I see that the core dump file is generated, can you get the backtrace out of it with gdb?

Cheers,
Daniel


On 06/07/16 08:47, Tim Balmer wrote:
> 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
> _______________________________________________
> 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