ViciBox9.0.2 - Dynportal Question

Discussions about new features or changes in existing features

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

ViciBox9.0.2 - Dynportal Question

Postby carpenox » Sun Jun 14, 2020 10:23 pm

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
Leap 15.2 | Version: 2.14-822a | BUILD: 210715-1248| SVN Version: 3483 | DB Schema Version: 1639 | Asterisk 13.38.2-vici
www.CyburDial.net -:- 844-PC-SATA-2 -:- My Blog: http://vicidial.blog -:- Whatsapp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 1478
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, FL

Re: ViciBox9.0.2 - Dynportal Question

Postby Kumba » Wed Jun 17, 2020 10:28 am

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.
Kumba
 
Posts: 895
Joined: Tue Oct 16, 2007 11:44 pm
Location: Florida

Re: ViciBox9.0.2 - Dynportal Question

Postby carpenox » Wed Jun 17, 2020 6:26 pm

So it doesn't allow access to the system?
Leap 15.2 | Version: 2.14-822a | BUILD: 210715-1248| SVN Version: 3483 | DB Schema Version: 1639 | Asterisk 13.38.2-vici
www.CyburDial.net -:- 844-PC-SATA-2 -:- My Blog: http://vicidial.blog -:- Whatsapp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 1478
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, FL

Re: ViciBox9.0.2 - Dynportal Question

Postby carpenox » Wed Jul 29, 2020 11:26 pm

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.
Leap 15.2 | Version: 2.14-822a | BUILD: 210715-1248| SVN Version: 3483 | DB Schema Version: 1639 | Asterisk 13.38.2-vici
www.CyburDial.net -:- 844-PC-SATA-2 -:- My Blog: http://vicidial.blog -:- Whatsapp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 1478
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, FL

Re: ViciBox9.0.2 - Dynportal Question

Postby covarrubiasgg » Wed Nov 11, 2020 2:21 am

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;
covarrubiasgg
 
Posts: 394
Joined: Thu Jun 10, 2010 10:20 am
Location: Tijuana, Mexico

Re: ViciBox9.0.2 - Dynportal Question

Postby carpenox » Wed Nov 11, 2020 8:11 am

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
Leap 15.2 | Version: 2.14-822a | BUILD: 210715-1248| SVN Version: 3483 | DB Schema Version: 1639 | Asterisk 13.38.2-vici
www.CyburDial.net -:- 844-PC-SATA-2 -:- My Blog: http://vicidial.blog -:- Whatsapp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 1478
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, FL

Re: ViciBox9.0.2 - Dynportal Question

Postby covarrubiasgg » Wed Nov 11, 2020 12:17 pm

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
covarrubiasgg
 
Posts: 394
Joined: Thu Jun 10, 2010 10:20 am
Location: Tijuana, Mexico

Re: ViciBox9.0.2 - Dynportal Question

Postby carpenox » Wed Nov 11, 2020 12:21 pm

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
Leap 15.2 | Version: 2.14-822a | BUILD: 210715-1248| SVN Version: 3483 | DB Schema Version: 1639 | Asterisk 13.38.2-vici
www.CyburDial.net -:- 844-PC-SATA-2 -:- My Blog: http://vicidial.blog -:- Whatsapp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 1478
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, FL


Return to Features

Who is online

Users browsing this forum: No registered users and 4 guests