MAC Entries: 6849
ARP Entries: 7359
Switch Entries: 0
WiFi Entries: 41583
Status Entries: 5585
Registrations: 0
DB Transactions: 374
Total Rows in DB: 61750
As you can see, a lot of wifi entries... It's really weird because I have no wifi devices on my network !
Any idea to find out what it is...
regards
Julien
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
If you check your devicelist.csv, are there any devices in there that have "wifi" after them, or are you possibly using an arubascraper instead of an arubaswitchscraper?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I believe that this is a problem with the way that NetDB.pm counts switch port and WiFi entries. Line 1419 (standard switch ports) looks for rows in the 'switchports' table where 'type' is null, and line 1423 (WiFi) looks for rows where 'type' is not null. However, when the table is populated (at least on my system), 'type' is always set to an empty string, which is not the same as null (unset). WiFi entries always have 'type' set to 'wifi', so that's what the the queries should be looking for. Unless I'm mis-understanding this, of course.
Max
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Guys, I've obviously got a bug here and Max I think you are on the right track. I tried changing those lines to look like this. See how that goes and I will get this updated in the latest version.
$dbs_h = $dbh->prepare( "SELECT COUNT(1) FROM switchports where lastseen > '$search_dt' AND type IS NULL OR type = ''" );
$dbs_h = $dbh->prepare( "SELECT COUNT(1) FROM switchports where lastseen > '$search_dt' AND type = 'wifi'" );
Thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi Jonathan,
I have modified the two lines. It works great.
[Server]# netdbctl -st
NetDB Statistics
MAC Entries: 7309
ARP Entries: 10700
Switch Entries: 51734
WiFi Entries: 0
Status Entries: 6054
Registrations: 0
DB Transactions: 935
Total Rows in DB: 76732
Thank you.
Ju
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello Jonathan,
Another easy question for you :-)
I have the following result :
netdbctl -st
NetDB Statistics
MAC Entries: 6849
ARP Entries: 7359
Switch Entries: 0
WiFi Entries: 41583
Status Entries: 5585
Registrations: 0
DB Transactions: 374
Total Rows in DB: 61750
As you can see, a lot of wifi entries... It's really weird because I have no wifi devices on my network !
Any idea to find out what it is...
regards
Julien
If you check your devicelist.csv, are there any devices in there that have "wifi" after them, or are you possibly using an arubascraper instead of an arubaswitchscraper?
Hi,
I don't have any devices with the "Wifi" statement in my devicelist file.
I'm not using aruba scraper.
Very strange ;-P
Ju
I believe that this is a problem with the way that NetDB.pm counts switch port and WiFi entries. Line 1419 (standard switch ports) looks for rows in the 'switchports' table where 'type' is null, and line 1423 (WiFi) looks for rows where 'type' is not null. However, when the table is populated (at least on my system), 'type' is always set to an empty string, which is not the same as null (unset). WiFi entries always have 'type' set to 'wifi', so that's what the the queries should be looking for. Unless I'm mis-understanding this, of course.
Max
Guys, I've obviously got a bug here and Max I think you are on the right track. I tried changing those lines to look like this. See how that goes and I will get this updated in the latest version.
Thanks
Hi Jonathan,
I have modified the two lines. It works great.
[Server]# netdbctl -st
NetDB Statistics
MAC Entries: 7309
ARP Entries: 10700
Switch Entries: 51734
WiFi Entries: 0
Status Entries: 6054
Registrations: 0
DB Transactions: 935
Total Rows in DB: 76732
Thank you.
Ju