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@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

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-bounces@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@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

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@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-bounces@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@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

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@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@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-bounces@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@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

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@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@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@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-bounces@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@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 _______________________________________________ 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

Hi Daniel,

I can confirm that with the latest branch the issue is fixed, tested both calls that are blacklisted and calls that are not blacklisted and everything is working as intended again.

Thanks a lot for your help!

Tim

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

Can you give it another try with a fresh branch 4.4?

Cheers, Daniel

On 06/07/16 09:46, Tim Balmer wrote:

Of course,

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

Regards, Tim

-- 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