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: How to use nd-import-topology (Sebastian R?sch)
2. Re: How to use nd-import-topology (Jeroen van Ingen)
3. Re: How to use nd-import-topology (Oliver Gorwits)
4. Re: Netdisco v2 icons not displaying in IE11 (Oliver Gorwits)
5. Re: Custom SQL/Web reporting (Oliver Gorwits)
6. Re: Custom SQL/Web reporting (Oliver Gorwits)
7. Netdisco 2 questions (Edward Vopata)
8. Problem with initial discovery (Caines, Max)
--- Begin Message ---
Now I found, what I was looking for... The Documentation link is close on the
same site... https://metacpan.org/pod/nd-import-topology
I already imported a part of the topology, but it isn´t actually shown as
"manual topology", I still see the Icon, that means "possible Uplink".
Does the correct option appears, after the next discovery? Or did I forgot sth?
Best Regards
Sebastian
--- End Message ---
--- Begin Message ---
On 08/18/2015 12:25 PM, Sebastian Rösch wrote:
Now I found, what I was looking for… The Documentation link is close on
the same site… https://metacpan.org/pod/nd-import-topology
I already imported a part of the topology, but it isn´t actually shown
as „manual topology“, I still see the Icon, that means „possible Uplink“.
Does the correct option appears, after the next discovery? Or did I
forgot sth?
I haven't used the import function, but I believe in general: after
creating a manual topology link, "broken topology" or "possible uplink"
marking should disappear on the next discover.
Regards,
Jeroen van Ingen
ICT Service Centre
University of Twente, P.O.Box 217, 7500 AE Enschede, The Netherlands
--- End Message ---
--- Begin Message ---
On 2015-08-18 11:25, Sebastian Rösch wrote:
Now I found, what I was looking for… The Documentation link is close
on the same site… https://metacpan.org/pod/nd-import-topology [1]
After running the nd-import-topology script, Netdisco 2 should have a
populated Manual Topology table. This can be seen by visiting
http://localhost:5000/admin/topology in your browser (Admin Menu ->
Manual Topology). If that table's empty, then for some reason the import
hasn't worked.
I believe this is also separate from the actual discovery of the
devices. You might want to discover the devices by IP first (netdisco-do
in a script loop, for instance), then run the topology import to
configure the links (one time only).
regards,
oliver.
I already imported a part of the topology, but it isn´t actually
shown as „manual topology", I still see the Icon, that means
„possible Uplink".
Does the correct option appears, after the next discovery? Or did I
forgot sth?
Best Regards
Sebastian
Links:
------
[1] https://metacpan.org/pod/nd-import-topology
--- End Message ---
--- Begin Message ---
Hi Lavin,
On 2015-08-03 17:02, Lavin, Michael (ITS) wrote:
Netdisco v2 icons not displaying in IE11. Chrome shows everything
fine
but default browser in our organization is IE11.
Sorry to hear that you don't see the icons in IE11. Unfortunately I
don't think any of the Netdisco developers work with IE and we don't
have the resources (time/money) to test (e.g. with browserling).
I suggest you try Chrome, if you can.
regards,
oliver.
For example, the Legend on the Ports display has not Link Up, Link
Down, Port Free icons.
Also magnifying glass next to the search bar does not appear. To be
clear, no icons on any web page show up, just text, checkboxes, drop
downs.
The disco ball logo graphic does show up in the menu bar.
I tried compatibility view and changing the security zone settings in
IE and also tried Googling but did not find any solutions or even
mention of this issue happening for anyone else.
Is this a setting in IE I need to fix or is it an issue with how I
installed Netdisco ?
Thank you all.
P.S. Wonderful product. Vital to our ability to manage our network.
--- End Message ---
--- Begin Message ---
Hi Andy,
On 2015-08-03 06:41, Andy Sainsbury wrote:
I'm having difficulty working out the syntax required to post a
report
in the environment.yml file to represent the following SQL query:
I think you might have been tripping up because there are some
field/column names the same in both tables. Aliasing them, I was able to
get the configuration to work. I've pasted it (slightly modified) here:
http://pastie.org/10362184
I hope this helps,
regards,
oliver.
SELECT device.name [1],
device.serial,
device.model,
device.os_ver,
device_module.description,
device_module.serial,
device_module.model,
device_module.class
FROM device_module
INNER JOIN device ON device.ip=device_module.ip
WHERE device.vendor LIKE 'cisco'
AND device_module.model ~ '-SUP'
ORDER BY device.os_ver;
I can build custom reports from data originating from one table after
reading the documents:
- tag: host_list
category: Device
label: 'List of All Devices'
columns:
- {name: 'Name'}
- {model: 'Model'}
- {serial: 'Serial'}
- {os: 'OS'}
- {os_ver: 'OS Version'}
query: |
SELECT d.name [2], d.model, d.serial, d.os, d.os_ver
FROM device d
ORDER BY name
Just I can't work out the method of writing up the syntax for more
complicated SQL queries across multiple tables.
Any help much appreciated!
Regards,
Andy Sainsbury
Network Engineer
University of Melbourne
Links:
------
[1] http://device.name
[2] http://d.name
--- End Message ---
--- Begin Message ---
Hi Andy,
On 2015-08-03 14:53, Andy Ruhl wrote:
I can't find the environment.yml file to check this out.
~netdisco/environments/deployment.yml
This is just me talking out loud, I haven't actually tried this:
It would be nice if you could turn the query into a database view,
then report on the view.
You can run "~netdisco/bin/netdisco-do psql" and then "CREATE VIEW
myviewname AS (SELECT .....);" which will create the view. Then you can
use the Netdisco custom reports config to select all columns from that
view. Yes this will save some typing in the config, but you still need
to specify the column list as Netdisco cannot introspect the view in
PostgreSQL.
regards,
oliver.
Hopefully there is no connection between these reports and an actual
table name.
Andy
------------------------------------------------------------------------------
_______________________________________________
Netdisco mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users
--- End Message ---
--- Begin Message ---
Can you provide some information about the Admin (Job Queue)?
- It there something that cleans the job queue table?
- How often is the table cleaned.
I also have a question about the achieved data:
- The old Netdisco application use to create archived data files:
arp_archive-*
arp_current-*
mac_archive-*
mac_current-*
devices-*
- How is this handled with the App::NetDisco application?
Thanks,
-- Ed.
--- End Message ---
--- Begin Message ---
Hi
I've just installed Netdisco v2 (2.029014) using the VM from
http://wokka.org/netdisco/. After configuring based on the web site, I ran a
discover against the Cisco 6509 which is one of the two cores of our L2 network
and also does some L3 (though not the VLAN that the Netdisco server lives on).
Although there are lots of CDP neighbours, it didn't try to visit any of them.
The log ends
[1262] 2015-08-21 16:38:33 info discover: finished at Fri Aug 21 16:38:33 2015
[1262] 2015-08-21 16:38:33 info discover: status error: error running job:
DBIx::Class::Storage::DBI::_dbh_execute_for_fetch(): execute_for_fetch()
aborted with 'ERROR: duplicate key value violates unique constraint
"device_port_vlan_pkey"
DETAIL: Key (ip, port, vlan, native)=(134.220.191.127, GigabitEthernet1/2/19,
1, t) already exists.' at populate slice:
{
ip => "134.220.191.127",
last_discover => \"now()",
native => "t",
port => "GigabitEthernet1/2/19",
vlan => 1,
vlantype => "static"
} at /home/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 487
Given that the database was empty, I'm a bit surprised at getting a duplicate
key error. This interface is just a trunk port, and is down. The SNMP read
community is definitely correct, and the switch allows SNMP from its address.
Netdisco added 345 interfaces and 102 device VLANs, but as I say, didn't visit
any more switches.
Does anyone have any idea what the problem is? I'm in the dark myself. I
enclose the complete debug log
Thanks
Max
Max Caines | Network Design Consultant | IT Services | Directorate of Academic
Support | University of Wolverhampton | 01902 322245 | 07976 841874
For contact details and general information on IT Services please visit
http://www.wlv.ac.uk/its This email, together with any attachment, is for the
exclusive and confidential use of the addressee(s) and may contain legally
privileged information. If you receive this email in error, please visit
http://www.wlv.ac.uk/ITS-disclaimer . Please consider the environment before
printing this e-mail.
discover.log
Description: discover.log
--- End Message ---
------------------------------------------------------------------------------
_______________________________________________
Netdisco mailing list - Digest Mode
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users
