I have a recently upgraded (from v1.8) v1.13 NetDB install and I am trying to grab data from a Force10 switch I just inherited. The force10 scraper seems to grab the data but when I query from the GUI, I do not see the switch or data. Looking in the database, I see this (abbreviated):
Do you get any results from the command line? netdb -sw core-1? How does
your interface status info look? I have a feeling that's what's missing:
select * from switchstatus where switch='core-1';
If that's missing, check the /opt/data/intstatus.txt file for core-1 data.
If it's missing, we'll need to tweak the scraper. I don't know how many
people are using the force10 scraper, it likely needs tweaking for this
model switch.
I have a recently upgraded (from v1.8) v1.13 NetDB install and I am trying
to grab data from a Force10 switch I just inherited. The force10 scraper
seems to grab the data but when I query from the GUI, I do not see the
switch or data. Looking in the database, I see this (abbreviated):
mysql> select * from switchports where switch='core-1';
+--------+--------+----------------+------+--------+-------------+-------------+---------+---------+-----------+---------------------+---------------------+
| switch | port | mac | type | s_vlan | s_ip | s_name | s_speed | minutes
| uptime | firstseen | lastseen |
Do you get any results from the command line? netdb -sw core-1? How does
your interface status info look? I have a feeling that's what's missing:
select * from switchstatus where switch='core-1';
If that's missing, check the /opt/data/intstatus.txt file for core-1 data.
If it's missing, we'll need to tweak the scraper. I don't know how many
people are using the force10 scraper, it likely needs tweaking for this
model switch.
First, thanks for your help and a great product!
netdb -sw core-1 returns nothing.
mysql> use netdb;
Database changed
mysql> select * from switchstatus where switch='core-1';
Empty set (0.00 sec)
I do have entries for core-1 in intstatus.txt. Sample below:
Glad you like it. Looks like it's missing the vlan ID/trunk status. Someone
else wrote that script but I should be able to fix it up. Can you send me a
chunk of the "show interface status" results? Hopefully it should be a
quick fix.
Do you get any results from the command line? netdb -sw core-1? How does
your interface status info look? I have a feeling that's what's missing:
select * from switchstatus where switch='core-1';
If that's missing, check the /opt/data/intstatus.txt file for core-1 data.
If it's missing, we'll need to tweak the scraper. I don't know how many
people are using the force10 scraper, it likely needs tweaking for this
model switch.
First, thanks for your help and a great product!
netdb -sw core-1 returns nothing.
mysql> use netdb;
Database changed
mysql> select * from switchstatus where switch='core-1';
Empty set (0.00 sec)
I do have entries for core-1 in intstatus.txt. Sample below:
I have a recently upgraded (from v1.8) v1.13 NetDB install and I am trying to grab data from a Force10 switch I just inherited. The force10 scraper seems to grab the data but when I query from the GUI, I do not see the switch or data. Looking in the database, I see this (abbreviated):
mysql> select * from switchports where switch='core-1';
+--------+--------+----------------+------+--------+-------------+-------------+---------+---------+-----------+---------------------+---------------------+
| switch | port | mac | type | s_vlan | s_ip | s_name | s_speed | minutes | uptime | firstseen | lastseen |
+--------+--------+----------------+------+--------+-------------+-------------+---------+---------+-----------+---------------------+---------------------+
| core-1 | Gi0/0 | 0017.c510.xxxx | | 601 | NULL | NULL | NULL | 720 | 12.0hours | 2015-08-06 15:04:09 | 2015-08-07 09:34:02 |
| core-1 | Gi0/0 | 0217.c510.xxxx | | 601 | NULL | NULL | NULL | 1755 | 1.2days | 2015-08-06 15:04:09 | 2015-08-07 09:34:02 |
| core-1 | Gi0/10 | 0050.56bf.xxxx | | 110 | NULL | NULL | NULL | 1125 | 18.8hours | 2015-08-06 15:04:09 | 2015-08-07 09:34:02 |
| core-1 | Gi0/10 | 0050.56bf.xxxx | | 110 | NULL | NULL | NULL | 1125 | 18.8hours | 2015-08-06 15:04:09 | 2015-08-07 09:34:02 |
| core-1 | Gi0/10 | 0050.56bf.xxxx | | 110 | NULL | NULL | NULL | 1125 | 18.8hours | 2015-08-06 15:04:09 | 2015-08-07 09:34:02 |
Jason,
Do you get any results from the command line? netdb -sw core-1? How does
your interface status info look? I have a feeling that's what's missing:
select * from switchstatus where switch='core-1';
If that's missing, check the /opt/data/intstatus.txt file for core-1 data.
If it's missing, we'll need to tweak the scraper. I don't know how many
people are using the force10 scraper, it likely needs tweaking for this
model switch.
Jonathan
On Fri, Aug 7, 2015 at 9:49 AM, Jason Goldman jasonmgoldman@users.sf.net
wrote:
First, thanks for your help and a great product!
netdb -sw core-1 returns nothing.
mysql> use netdb;
Database changed
mysql> select * from switchstatus where switch='core-1';
Empty set (0.00 sec)
I do have entries for core-1 in intstatus.txt. Sample below:
core-1,Gi0/0,connected,,Sonicwall-f,Up,
core-1,Gi0/1,notconnect,,,Down,
core-1,Gi0/2,notconnect,,,Down,
core-1,Gi0/3,notconnect,,,Down,
core-1,Gi0/4,connected,,,Up,
core-1,Gi0/5,connected,,,Up,
Attached is a Level 6 debug of the force10 scraper against the switch core-1
Last edit: Jason Goldman 2015-08-10
Glad you like it. Looks like it's missing the vlan ID/trunk status. Someone
else wrote that script but I should be able to fix it up. Can you send me a
chunk of the "show interface status" results? Hopefully it should be a
quick fix.
Thanks
On Mon, Aug 10, 2015 at 9:57 AM, Jason Goldman jasonmgoldman@users.sf.net
wrote:
Thanks tons!
See attached.
Jason,
Sorry for the delay but see if this works for you:
http://sourceforge.net/p/netdbtracking/code/HEAD/tree/trunk/netdbscraper/force10scraper.pl
If not, please run it with debug level 2 like this:
/opt/netdb/netdbscraper/force10scraper.pl -d yourswitch -oi /tmp/int.txt
-debug 2
I'm looking for the Int Status Debug lines if it has a problem.
Thanks
On Tue, Aug 11, 2015 at 8:27 AM, Jason Goldman jasonmgoldman@users.sf.net
wrote:
Success! Thanks again for a great product!
Awesome, no problem.
--
Jonathan Yantis