Send netdisco-users mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/netdisco-users
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of netdisco-users digest..."
Today's Topics:
1. Re: Updating OUI (Oliver Gorwits)
2. Re: Feature Request: Last Update alarm (Oliver Gorwits)
3. Re: Error 500 from Dancer (Oliver Gorwits)
4. Re: Custom report IP Utilization (Oliver Gorwits)
5. Re: Change query / table for Netgear GSXXX switches
(Oliver Gorwits)
6. Re: how to disable default search to look at VLAN (Oliver Gorwits)
7. Re: SNMP Connect failures - source of IP? (Oliver Gorwits)
--- Begin Message ---
Hi all
The OUI file we use is hosted in our own repo on Github (because the
IEEE site is slooooooooow). That means it was a little out of date and
re-running netdisco-deploy would not have updated it for you.
So I've just refreshed the file from IEEE and if you re-run
netdisco-deploy it will give you updated OUI values now.
(https://github.com/netdisco/upstream-sources/tree/master/ieee)
thanks,
Oliver.
On 2018-10-18 10:42, Brian R. Swan wrote:
How do I update the OUI table? I know it’s downloaded via the initial
install using the netdisco-deploy command, but I don’t think I can run
that on an existing installation without resetting it?
Thanks,
Brian
_______________________________________________
Netdisco mailing list
[email protected]
https://sourceforge.net/p/netdisco/mailman/netdisco-users/
--- End Message ---
--- Begin Message ---
thanks! I have created this issue to track the request:
https://github.com/netdisco/netdisco/issues/445
On 2018-10-12 08:22, Brian R. Swan wrote:
Hi all,
I ran into a situation where something went south on the server and
NetDisco stopped scraping MAC addresses. I noticed it about a week
later when looking for a MAC address. A restart of the server seemed
to resolve it.
Would it be possible to add a field in the menu bar that has the
date/time of the last MAC entry update and possibly throw an alarm of
some sort if there have been no changes in the last xx days or
something? I’m thinking either looking at the last_macsuck column in
the device table or doing a query on the node table for the newest
entry in the time_last column and throwing an error if its greater
then 1 day or something. I think option 2 is the best option because
not having a mac change SOMEWHERE in the network within a day or so
probably means that something isn’t working right.
Thanks!
Brian
_______________________________________________
Netdisco mailing list
[email protected]
https://sourceforge.net/p/netdisco/mailman/netdisco-users/
--- End Message ---
--- Begin Message ---
Hi Andy
Looks like a problem with the Postgres DB server rather than Netdisco?
Can you connect to it using the psql client? It may be necessary to dump
and restore the DB? (there is a tip for this in the wiki somewhere)
regards,
oliver.
On 2018-09-21 16:41, Andy Ruhl wrote:
I did some software updates to my Netdisco machine (Raspberry Pi 3 b
plus). After that, I get an Error 500 when I do some searches, such as
0.0.0.0/0 or any IP address. Reports work. Some other stuff works. So
it's not completely broken.
This error is in the web log:
[18118] 2018-09-21 15:37:17 error request to GET /search crashed:
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st
execute failed: ERROR: could not access status of transaction
4049780170
DETAIL: Could not open file "pg_clog/0F16": No such file or directory.
I tried re-installing but it didn't fix it. Well, I deleted all
directories in the netdisco user directory and did a fresh install and
then connected to my existing database anyway.
What do I do next?
Andy
_______________________________________________
Netdisco mailing list
[email protected]
https://sourceforge.net/p/netdisco/mailman/netdisco-users/
--- End Message ---
--- Begin Message ---
Hi Marios
unfortunately this is quite a complex task for a newbie! I would suggest
either making do with the existing IP inventory report(s) or else
copying the code from the sidebar as a start for your own work (however
some of the javascript is a bit magical!).
good luck,
Oliver.
On 2018-09-20 14:02, Marios Kesoulis wrote:
Hello there,
I am newbie of course and I am trying to built a custom report for IP
Utilization that it will be utilized through URL.
I need only specific columns
IP Address, DNS NAME, Time First Seen, Time Last Seen
Also I need "List IPs Never Seen"
I don't need Date Range
I also need the right search box with the above parameters
I am with this code right now inside deployment.yml
reports:
- tag: subnet_utilization
label: 'Subnet Utilization'
category: IP
columns:
- {ip: 'IP Address'}
- {dns: 'DNS Name'}
- {time_first: 'Time First Seen'}
- {time_last: 'Time Last Seen'}
query: |
SELECT DISTINCT ON (ip) ip, dns, date_trunc('second',
time_first) AS time_first, date_trunc('second', time_last) AS
time_last
FROM node_ip
WHERE ip << ?
ORDER BY ip ASC
bind_params: ['subnet']
I can not find a way to implement the "List IPs Never Seen" and the
right search box.
I need you help.
Thanks in advance,
Marios
_______________________________________________
Netdisco mailing list
[email protected]
https://sourceforge.net/p/netdisco/mailman/netdisco-users/
--- End Message ---
--- Begin Message ---
Hi Andre
Yes this is a task for the SNMP::Info Netgear.pm module - and you can
use Netdisco's netdisco-do command to help you work on it.
netdisco-do show Layer3::Netgear::interfaces
for example. I would find the Netgear.pm file and then hack about until
it works, and submit a patch to the SNMP::Info repo on Github. You will
probably already see in that code some switches for various platforms to
make the correct text appear.
regards,
oliver.
On 2018-09-06 13:24, Weidner,Andre wrote:
We have a variety of Netgear GSxxxYY switches. The only problem I got
is that in the "Ports" table, the human set port descriptions are not
shown. The table reads "Port: 1/g1|Description: unit 1 port 1 Gigabit
- Level|Name:1/g1|...|.
I guess this is because Netdisco.pm uses the "ifDescr" field for its
query but the Switch stores the value I want as "ifAlias". What would
I have to change in Netgear.pm (or any given .pm file) to accomplish
this task?
Thank you,
Andre Weidner
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Netdisco mailing list
[email protected]
https://sourceforge.net/p/netdisco/mailman/netdisco-users/
--- End Message ---
--- Begin Message ---
Hi Piotr
Have you spotted that there is a drop-down menu beside the search box?
You can select search for Node and I think that should force hostname
search rather than VLAN number. If that's not the case then please raise
a bug report!
regards,
Oliver.
On 2018-08-22 18:10, [email protected] wrote:
hi guys,
we are using netdisco to locate phones.
our voip nodes have hostname like
phonenumber.voice.domain.de
so its possible to find a device when you enter a string like
1234123.
so netdisco will look up for anything and find the node
4940421234123.voice.domain.de
^
|
without the dot at the end netdisco tries to find a vlan 1234123
anybody knows a way to disable the vlan-search or change the behavior
of the search when i enter an integer?
thanks in advance
piotr
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Netdisco mailing list
[email protected]
https://sourceforge.net/p/netdisco/mailman/netdisco-users/
--- End Message ---
--- Begin Message ---
good question - but no, we don't record the source of a neighbor in the
DB, it's only in the logs, sorry.
oliver.
On 2018-08-21 01:33, [email protected] wrote:
In the SNMP Connect Failures page are a number of IP addresses on a
subnet I do not recognize. They are current and showing connect
failures, and indeed I can't ping them either.
We have hundreds of 510 devices; they are coming from somewhere
amongst them, in a LLDP or CDP neighbor probably, maybe elsewhere.
Is there a way to tell where they originate? Short of trying to run
each device individually in debug?
Is a record kept of what causes a discovery job to be queued for an
IP, that you can look retroactively? Somewhere in the database is fine
(I looked briefly but had no clue where to start).
Linwood
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Netdisco mailing list
[email protected]
https://sourceforge.net/p/netdisco/mailman/netdisco-users/
--- End Message ---
_______________________________________________
Netdisco mailing list - Digest Mode
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users
