Send netdisco-users mailing list submissions to
netdisco-users@lists.sourceforge.net
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
netdisco-users-requ...@lists.sourceforge.net
You can reach the person managing the list at
netdisco-users-ow...@lists.sourceforge.net
When replying, please edit your Subject line so it is more specific
than "Re: Contents of netdisco-users digest..."
Today's Topics:
1. Re: IPv6 device support (Oliver Gorwits)
2. Re: Netgear Switch name too long (Oliver Gorwits)
3. Re: auth via ldap (FreeIPA) (Oliver Gorwits)
4. Re: Expire nodes / devices problem (Oliver Gorwits)
5. Re: Github for code and tickets (Oliver Gorwits)
--- Begin Message ---
Hi Dan
On 2016-12-07 20:36, Dan Augustine wrote:
What is the status for gathering IPv6 interface and neighbor
information from Cisco switches and routers? I've searched the list
and it looks like its not currently supported.
Please add your voice to either of these tickets:
https://github.com/netdisco/netdisco/issues/47
https://github.com/netdisco/netdisco/issues/263
Add as much detail on what's missing and what you'd like to see as you
can.
Many thanks,
regards,
oliver.
Netdisco is indispensable in providing a window into our network's
current and historical state, however I'm feeling a bit blind on the
IPv6 side.
Regards,
Dan
------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today.http://sdm.link/xeonphi
_______________________________________________
Netdisco mailing list
netdisco-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/netdisco-users
--- End Message ---
--- Begin Message ---
Hi André,
On 2016-12-06 17:27, Weidner,Andre wrote:
We recently acquired some new Netgear switches, named 'GS724Tv4
ProSafe 24-port Gigabit Ethernet Smart Switch'. They are shown like
this in Netdisco. If you click on that name in the inventory, Netdisco
reports 'No matching records'.
What is the hyperlink in the inventory? Yes it looks like a bug, but I'm
not sure that it's the length of the name that's the problem. I'd like
to see what link is generated for the model.
You can open a ticket in Github on this:
https://github.com/netdisco/netdisco/issues/new
Many thanks,
Oliver.
However, you can show the switch by
clicking 'vendor' first in the inventory and then choosing the FQDN
you would like to show.
Older Netgear switches named 'GS724TS 00.00.01' in Netdisco work fine,
however. Looks like a small bug.
App::Netdisco 2.034001
DB Schema v41
Dancer 1.3134
Bootstrap 2.3.1
PostgreSQL PostgreSQL 9.2.15 on x86_64-redhat-linux-gnu, compiled by
gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit.
DBI 1.633, DBD::Pg 2.19.3
SNMP::Info 3.34
Perl 5.016003
Kind regards,
André Weidner
------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today.http://sdm.link/xeonphi
_______________________________________________
Netdisco mailing list
netdisco-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/netdisco-users
--- End Message ---
--- Begin Message ---
Hi Zarko
Looks like Netdisco cannot connect to its database? Try this workaround:
https://metacpan.org/pod/distribution/App-Netdisco/lib/App/Netdisco/Manual/Deployment.pod#Enable-MD5-authentication-to-PostgreSQL
regards,
oliver.
On 2016-10-14 20:46, Zarko Dudic wrote:
Thanks Oliver, I've enabled debugging as you suggested:
log: "debug"
warnings: 1
show_errors: 1
and then stop the web server daemon and run the web server like this
in the foreground:
~netdisco/bin/localenv plackup -R share,lib bin/netdisco-web-fg
This causes that I can't login even with local admin account, the CLI
output I see is:
[14/Oct/2016:12:19:36 -0700] "GET / HTTP/1.1" 200 6708 "-"
"Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/53.0.2785.143 Safari/537.36"
[14/Oct/2016:12:19:40 -0700] "GET /ajax/userlog HTTP/1.1" 302 0
"http://ca-netdisco.us.oracle.com:5000/inventory"; "Mozilla/5.0 (X11;
Ubuntu; Linux x86_64; rv:47.0) Gecko/20100101 Firefox/47.0"
[14/Oct/2016:12:19:41 -0700] "GET /login?return_url=%2Fajax%2Fuserlog
HTTP/1.1" 200 12528 "http://ca-netdisco.us.oracle.com:5000/inventory";
"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:47.0) Gecko/20100101
Firefox/47.0"
[1409] 2016-10-14 19:19:43 debug Attempting to authenticate admin
against realm users
[1409] 2016-10-14 19:19:43 error request to POST /login crashed:
DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI
connect('dbname=netdisco','netdisco',...) failed: FATAL: Ident
authentication failed for user "netdisco" at
/home/netdisco/perl5/lib/perl5/DBIx/Class/Storage/DBI.pm line 1487. at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Web/AuthN.pm line 63
[14/Oct/2016:12:19:43 -0700] "POST /login HTTP/1.1" 500 36289
"http://ca-netdisco:5000/"; "Mozilla/5.0 (Windows NT 6.3; WOW64)
AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.143
Safari/537.36"
[14/Oct/2016:12:19:43 -0700] "GET /css/error.css HTTP/1.1" 200 6712
"http://ca-netdisco:5000/login"; "Mozilla/5.0 (Windows NT 6.3; WOW64)
AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.143
Safari/537.36"
[14/Oct/2016:12:19:43 -0700] "GET /favicon.ico HTTP/1.1" 200 6710
"http://ca-netdisco:5000/login"; "Mozilla/5.0 (Windows NT 6.3; WOW64)
AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.143
Safari/537.36"
And the browser shows the Runtime error with messages:
DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: DBI
connect('dbname=netdisco','netdisco',...) failed: FATAL: Ident
authentication failed for user "netdisco" at
/home/netdisco/perl5/lib/perl5/DBIx/Class/Storage/DBI.pm line 1487. at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Web/AuthN.pm line 63
/home/netdisco/perl5/lib/perl5/DBIx/Class/Storage/DBI.pm around line
1487
1484 }
1485 else {
1486 require DBI;
1487 $dbh = DBI->connect(@$info);
1488 }
1489
1490 die $DBI::errstr unless $dbh;
Stack
main in /home/netdisco/perl5/bin/plackup l. 10
... and many others, not sure if it's relevant to post them here.
------------------------------------------------------------------------------
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
netdisco-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/netdisco-users
--- End Message ---
--- Begin Message ---
Hi Tobias,
If this is still an issue, I have two thoughts:
1. Try running the DELETE FROM node_ip... yourself from the "netdisco-do
psql" prompt. You could edit to a SELECT to see first what is matched.
2. That DELETE runs inside a transaction and something else could be
failing. Try each of the other DELETE statements to see if we have a
bug.
Thanks,
Oliver.
On 2016-10-04 15:13, Tobias Gerlach wrote:
Hello Oliver,
thank you for your replay.
I run the expire task again and can confirm that nodes and devices
older 14 days are deleted from the "device" and "node" table.
But again no entries from the "node_ip" table were deleted.
Do you have an idea why?
Here is the debug output:
netdisco-do expire -DQ
[4823] 2016-10-04 12:55:27 info expire: started at Tue Oct 4 14:55:27
2016
SELECT me.version, me.installed
FROM dbix_class_schema_versions me
WHERE 1 = 0
SELECT me.version
FROM dbix_class_schema_versions me
ORDER BY installed DESC
LIMIT '1'
BEGIN WORK
DELETE FROM device_ip
WHERE ip IN (
SELECT me.ip
FROM device me
WHERE last_discover < ( now( ) - '1209600' ::interval )
)
DELETE FROM device_vlan
WHERE ip IN (
SELECT me.ip
FROM device me
WHERE last_discover < ( now( ) - '1209600' ::interval )
)
DELETE FROM device_power
WHERE ip IN (
SELECT me.ip
FROM device me
WHERE last_discover < ( now( ) - '1209600' ::interval )
)
DELETE FROM device_module
WHERE ip IN (
SELECT me.ip
FROM device me
WHERE last_discover < ( now( ) - '1209600' ::interval )
)
DELETE FROM community
WHERE ip IN (
SELECT me.ip
FROM device me
WHERE last_discover < ( now( ) - '1209600' ::interval )
) AND snmp_auth_tag IS NULL
UPDATE community
SET snmp_comm_rw = NULL
WHERE ip IN (
SELECT me.ip
FROM device me
WHERE last_discover < ( now( ) - '1209600' ::interval )
)
DELETE FROM admin
WHERE device IN (
SELECT me.ip
FROM device me
WHERE last_discover < ( now( ) - '1209600' ::interval )
)
DELETE FROM topology
WHERE dev1 IN (
SELECT me.ip
FROM device me
WHERE last_discover < ( now( ) - '1209600' ::interval )
) OR dev2 IN (
SELECT me.ip
FROM device me
WHERE last_discover < ( now( ) - '1209600' ::interval )
)
DELETE FROM device_port_power
WHERE ip IN (
SELECT me.ip
FROM device_port me
WHERE ip IN (
SELECT me.ip
FROM device me
WHERE last_discover < ( now( ) - '1209600' ::interval )
)
)
DELETE FROM device_port_vlan
WHERE ip IN (
SELECT me.ip
FROM device_port me
WHERE ip IN (
SELECT me.ip
FROM device me
WHERE last_discover < ( now( ) - '1209600' ::interval )
)
)
DELETE FROM device_port_wireless
WHERE ip IN (
SELECT me.ip
FROM device_port me
WHERE ip IN (
SELECT me.ip
FROM device me
WHERE last_discover < ( now( ) - '1209600' ::interval )
)
)
DELETE FROM device_port_ssid
WHERE ip IN (
SELECT me.ip
FROM device_port me
WHERE ip IN (
SELECT me.ip
FROM device me
WHERE last_discover < ( now( ) - '1209600' ::interval )
)
)
DELETE FROM node_ip
WHERE mac IN (
SELECT me.mac
FROM node_ip me
LEFT JOIN node nodes
ON nodes.mac = me.mac
WHERE nodes.active AND me.mac IN (
SELECT me.mac
FROM node me
WHERE switch IN (
SELECT me.ip
FROM device_port me
WHERE ip IN (
SELECT me.ip
FROM device me
WHERE last_discover < ( now( ) - '1209600' ::interval
)
)
)
)
GROUP BY me.mac
HAVING count( nodes.mac ) = 0
)
DELETE FROM node_nbt
WHERE mac IN (
SELECT me.mac
FROM node_nbt me
LEFT JOIN node nodes
ON nodes.mac = me.mac
WHERE nodes.active AND me.mac IN (
SELECT me.mac
FROM node me
WHERE switch IN (
SELECT me.ip
FROM device_port me
WHERE ip IN (
SELECT me.ip
FROM device me
WHERE last_discover < ( now( ) - '1209600' ::interval
)
)
)
)
GROUP BY me.mac
HAVING count( nodes.mac ) = 0
)
DELETE FROM node_monitor
WHERE mac IN (
SELECT me.mac
FROM node me
WHERE switch IN (
SELECT me.ip
FROM device_port me
WHERE ip IN (
SELECT me.ip
FROM device me
WHERE last_discover < ( now( ) - '1209600' ::interval )
)
)
)
DELETE FROM node_wireless
WHERE mac IN (
SELECT me.mac
FROM node me
WHERE switch IN (
SELECT me.ip
FROM device_port me
WHERE ip IN (
SELECT me.ip
FROM device me
WHERE last_discover < ( now( ) - '1209600' ::interval )
)
)
)
DELETE FROM node
WHERE switch IN (
SELECT me.ip
FROM device_port me
WHERE ip IN (
SELECT me.ip
FROM device me
WHERE last_discover < ( now( ) - '1209600' ::interval )
)
)
DELETE FROM device_port
WHERE ip IN (
SELECT me.ip
FROM device me
WHERE last_discover < ( now( ) - '1209600' ::interval )
)
DELETE FROM device
WHERE last_discover < ( now( ) - '1209600' ::interval )
COMMIT
BEGIN WORK
DELETE FROM node_ip
WHERE mac IN (
SELECT me.mac
FROM node_ip me
LEFT JOIN node nodes
ON nodes.mac = me.mac
WHERE nodes.active AND me.mac IN (
SELECT me.mac
FROM node me
WHERE time_last < ( now( ) - '1209600' ::interval )
)
GROUP BY me.mac
HAVING count( nodes.mac ) = 0
)
DELETE FROM node_nbt
WHERE mac IN (
SELECT me.mac
FROM node_nbt me
LEFT JOIN node nodes
ON nodes.mac = me.mac
WHERE nodes.active AND me.mac IN (
SELECT me.mac
FROM node me
WHERE time_last < ( now( ) - '1209600' ::interval )
)
GROUP BY me.mac
HAVING count( nodes.mac ) = 0
)
DELETE FROM node_monitor
WHERE mac IN (
SELECT me.mac
FROM node me
WHERE time_last < ( now( ) - '1209600' ::interval )
)
DELETE FROM node_wireless
WHERE mac IN (
SELECT me.mac
FROM node me
WHERE time_last < ( now( ) - '1209600' ::interval )
)
DELETE FROM node
WHERE time_last < ( now( ) - '1209600' ::interval )
COMMIT
BEGIN WORK
DELETE FROM node_ip
WHERE mac IN (
SELECT me.mac
FROM node_ip me
LEFT JOIN node nodes
ON nodes.mac = me.mac
WHERE nodes.active AND me.mac IN (
SELECT me.mac
FROM node me
WHERE ( NOT active ) AND time_last < ( now( ) - '1209600'
::interval )
)
GROUP BY me.mac
HAVING count( nodes.mac ) = 0
)
DELETE FROM node_nbt
WHERE mac IN (
SELECT me.mac
FROM node_nbt me
LEFT JOIN node nodes
ON nodes.mac = me.mac
WHERE nodes.active AND me.mac IN (
SELECT me.mac
FROM node me
WHERE ( NOT active ) AND time_last < ( now( ) - '1209600'
::interval )
)
GROUP BY me.mac
HAVING count( nodes.mac ) = 0
)
DELETE FROM node_monitor
WHERE mac IN (
SELECT me.mac
FROM node me
WHERE ( NOT active ) AND time_last < ( now( ) - '1209600'
::interval )
)
DELETE FROM node_wireless
WHERE mac IN (
SELECT me.mac
FROM node me
WHERE ( NOT active ) AND time_last < ( now( ) - '1209600'
::interval )
)
DELETE FROM node
WHERE ( NOT active ) AND time_last < ( now( ) - '1209600' ::interval )
COMMIT
BEGIN WORK
DELETE FROM admin
WHERE entered < ( now( ) - '1209600' ::interval )
COMMIT
[4823] 2016-10-04 12:55:41 info expire: finished at Tue Oct 4
14:55:41 2016
[4823] 2016-10-04 12:55:41 info expire: status done: Checked expiry
for all Devices and Nodes
Regards Tobias
PS: Netdisco run as user netdisco, not as root for sure :)
2016-09-19 11:07 GMT+02:00 Tobias Gerlach <tobi...@gmail.com>:
Hello,
I'm running the latest Netdisco version and I'm wondering why no
entries are removed from the node_ip table. I expected to find there
no MAC adresses older than 14 days here after running the expire job.
Any ideas or suggestions? Thanks a lot in advance.
# cat environments/deployment.yml
..
expire_devices: 14
expire_nodes: 14
expire_nodes_archive: 14
..
# netdisco-do expire
[25938] 2016-09-19 08:56:56 info expire: started at Mon Sep 19
10:56:56 2016
[25938] 2016-09-19 08:56:57 info expire: finished at Mon Sep 19
10:56:57 2016
[25938] 2016-09-19 08:56:57 info expire: status done: Checked expiry
for all Devices and Nodes
node_ip table:
Actions mac ip active time_first time_last
dns
Edit Delete 64:27:37:59:10:11 10.239.48.133 FALSE
2014-10-21 20:07:13.548594 2014-10-21 20:07:13.385271 NULL
Edit Delete cc:07:ab:f2:07:e9 10.253.68.234 FALSE
2014-11-13 12:00:57.858954 2014-11-13 16:16:23.115927 NULL
Edit Delete 90:1b:0e:03:3a:3f 10.84.21.75 TRUE
2014-11-10 08:16:04.133489 2014-11-10 08:16:03.584933 NULL
Edit Delete 9c:fc:01:a1:d9:93 10.247.237.231 FALSE
2015-07-13 21:52:10.267051 2015-07-14 00:27:23.878609 NULL
...
------------------------------------------------------------------------------
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
netdisco-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/netdisco-users
--- End Message ---
--- Begin Message ---
Hi all,
The tickets for Netdisco and SNMP::Info (and netdisco-mibs) are now
migrated to Github:
https://github.com/netdisco/netdisco/issues
https://github.com/netdisco/snmp-info/issues
https://github.com/netdisco/netdisco-mibs/issues
The ticket numbers are not the same and the original requestor emails
have not been migrated for the sake of privacy, but the original sf.net
tickets are linked, and all requestors will have got an email about the
migration.
Many thanks!
Oliver.
On 2016-12-11 21:38, Oliver Gorwits wrote:
Hi all,
From time to time we discuss the hosting of the projects (Netdisco and
SNMP-Info). I believe there are some good reasons for considering a
move
from Sourceforge to Github:
* Better user interface for admins and users
* More well-known workflow
* Better uptime
* Github Pages for a homepage
In particular I'll pick out that the fork and merge request process in
Sourceforge is clunky and presents quite a hurdle to new or drive-by
users. Personally speaking, the outages at Sourceforge hosting have
been
a real pain, and the git repo is slow.
The only feature that sf.net uniquely has is the mail lists, so they
will remain.
Right now I'm planning my activities for the upcoming holidays and I
would be happy to migrate Netdisco and SNMP-Info to Github, leaving the
mail list(s) at sf.net and updating up web links and documentation.
Please let me know by 24 Dec if you're aware of any show-stopper to the
move, or if you think it's a really bad idea for any reason. We
recently
discussed this on the IRC channel #netdisco and there were no
objections
from the several devs present.
Feel free to reply to this email or drop by #netdisco if you have
questions, and thank you for your attention!
regards,
Oliver Gorwits.
------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today.http://sdm.link/xeonphi
_______________________________________________
Netdisco mailing list
netdisco-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/netdisco-users
--- End Message ---
------------------------------------------------------------------------------
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 - Digest Mode
netdisco-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/netdisco-users
