ViciBox9.0.2 - Dynportal Question

[carpenox]

I understand that the dynportal inserts the IP address into the asterisk.vicidial database, correct? How can that be transferred to the IPList: Whitelist on the admin section of the vicidial interface? Is this possible? Or where in the database does it go and ill make a query

[Kumba]

The dynamic list isn't really a list. It looks up entries from the vicidial_user_log table. It searches for LOGIN and VICIBOX entries in this table.

[carpenox]

So it doesn't allow access to the system?

[carpenox]

Ok let me ask you this, what table does the dynportal store its information or IP list? I am going to try to write a mysql query to grab the data from it and insert it into the whitelist for vicidial.

[covarrubiasgg]

Try with

Code: Select all

select computer_ip from vicidial_user_log where event = 'VICIBOX' group by computer_ip;


That will show you the logins to the Dynamic Portal, but note that you will want to use a date range or it will show you all the logs from the beginning of time and Vicibx firewall only looks for 14 day by default.

Also take a look to this query, is the one VB-firewall.pl uses to add ips to the dynamic ipset

Code: Select all

SELECT computer_ip FROM vicidial_user_log WHERE event IN ('LOGIN', 'VICIBOX') and event_date >= DATE_SUB(NOW(), INTERVAL 14 DAY) group by computer_ip;


[carpenox]

good shit, thats some good info, i am gonna have to see about changing the way i do it now to perhaps use that first query more efficiently because right now I just have the firewall updating every 60 seconds to the dynamic list

Thanks

nox

[covarrubiasgg]

Don't understand what's wrong about having the dynamic firewall running * * * * *

I only use Allow List (WhiteList) for carriers and locations with static IP, but most agents have a dynamic IP so I don't want those IPs on a white list.

Also the Allow List (White list) is loaded using the same script VB-firewall.pl

[carpenox]

nothing is wrong with dynamic firewall running, thats what i am using, the problems occurs when they go to login after validating there IP, it takes a few min for the firewall to update, i originally was trying to find a way to move the IP's from the dynamic list directly into the firewall, but i ended up with just running the vb-firewall script every 60 seconds instead

[callcentertech]

You can use multiple crons for vbfirewall with ‘sleep’ parameters. Make it run every 10 seconds and your users will have to wait max 10 secs instead of 60 secs before their IP is whitelisted.

Make sure to change the value of Redirect seconds to 10 in defaults.inc.php

nothing is wrong with dynamic firewall running, thats what i am using, the problems occurs when they go to login after validating there IP, it takes a few min for the firewall to update, i originally was trying to find a way to move the IP's from the dynamic list directly into the firewall, but i ended up with just running the vb-firewall script every 60 seconds instead