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-boun...@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@tel-dev-01-[LOC]:~/kamailio# ./kamailio -h
>> version: kamailio 4.4.2 (x86_64/linux) 89c556
>>
>> The I run this latest version:
>> root@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-boun...@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-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
>> _______________________________________________
>> 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
