[OpenSIPS-Users] Userblacklist Module Issues

[Bogdan-Andrei Iancu]

Hi Jonathan,

1) I guess you use the check_blacklist() script function with the wrong 
parameter. Indeed, the DB table is created as "globalblacklist", so you 
need to be careful and pass this table name via the script functions 
(and not the faulty "global_blacklist")

2) check your "version" table (in the opensips DB) - you must have there 
a record containing like this:
https://github.com/OpenSIPS/opensips/blob/master/scripts/mysql/userblacklist-create.sql#L1

Regards and A Happy New Year,

Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
   https://www.opensips-solutions.com
OpenSIPS Summit 2019
   https://www.opensips.org/events/Summit-2019Amsterdam/

On 12/27/2018 03:40 PM, Jonathan Mabrito wrote:
> I am working on implementing the userblacklist Module and having a few 
> issues with it. I am running OpenSIPS 2.4.4 on Ubuntu 16.04 (using APT 
> to install it).
>
> 1.) In regards to the Global Blacklist, the script creates a table 
> called "globalblacklist" and it looks like the code is looking for a 
> table called "global_blacklist" instead. I found the 
> userblacklist-create.sql script and created the global_blacklist table 
> and all is good. What is the proper DB table name? Was the script not 
> updated or is the code wrong?
>
> Here is a INFO debug statement when it queries the global_blacklist 
> table: INFO:userblacklist:reload_sources: got 1 entries from 
> 'global_blacklist'
>
> If I run the FIFO command to reload the list, it also errors out if I 
> do not have the global_blacklist table (which is how I figured out it 
> was looking for a different table name in the first place).
>
> 2.) Having some issues on the start of OpenSIPS over time after 
> turning on the userblacklist module. After I implemented the 
> userblacklist module and all was working, I was working on the 
> Event_RabbitMQ module and restarted the service to reload the script. 
> I started seeing the following:
>
> ERROR:core:db_check_table_version: querying version for table 
> userblacklist
> ERROR:userblacklist:db_init: during table version check.
> ERROR:core:init_mod_child: failed to initializing module 
> userblacklist, rank 10
>
> ERROR:core:db_check_table_version: invalid version 0 for table 
> userblacklist found, expected 2
> ERROR:userblacklist:db_init: during table version check.
> ERROR:core:init_mod_child: failed to initializing module 
> userblacklist, rank 10
> ERROR:core:tcp_start_processes: init_children failed
>
> I honestly have no idea how its getting a version 0 on the 
> userblacklist table. I see in the version table, its set to 2. I tried 
> setting that to 0 and no luck, same message. I went ahead and dropped 
> the userblacklist and globalblacklist tables, removed the entries in 
> the version table and re-ran the SQL script. The service came online.
>
> This morning, I updated the script to change a IP and restarted the 
> service. Same issue with the DB versions of the userblacklist table. 
> If I dropped the tables and re-ran the SQL script, the service came 
> online.
>
> Any ideas on this one?
> -- 
> -Jonathan
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20190103/690954a7/attachment.html>