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: Reports not working (Oliver Gorwits)
2. Re: Reports not working (Ankarloo, Gustaf)
3. Reports > IP Inventory - List IP?s Never Seen function
returns error ([email protected])
4. netdisco2 Scheduler not working (Chuck Sanderson)
--- Begin Message ---
Hi Gustaf
At a complete guess, I would say that something is upsetting the
DataTables plugin that renders the table on the page. Opening a
javascript console in the browser might show the issue.
However I'm not an expert in this area and I've not seen this particular
behaviour before.
regards,
oliver.
On 2017-10-11 13:17, Ankarloo, Gustaf wrote:
Hi.
I have a problem with one of my Netdisco2 installations.
No reports are working.
Inventory page lists correct values. But if I click on a vendor or a
switchmodel all I get is an empty page
Nothing of value in the logs.
But I enabled query logging in Postgres and the queries looks legit.
Any Ideas?
Med vänlig hälsning
Gustaf__
GUSTAF ANKARLOO | Technical Specialist
Dedicated Infrastructure Services South
GIS Scandinavia | CGI Sweden
Grafiska vägen 22, 400 20 Göteborg | Sweden
T: +46 31 761 14 57| M: +46 705 67 14 57
[email protected] | www.cgi.se [1]
CONFIDENTIALITY NOTICE: Proprietary/Confidential Information
belonging to CGI Group Inc. and its affiliates may be contained in
this message. If you are not a recipient indicated or intended in this
message (or responsible for delivery of this message to such person),
or you think for any reason that this message may have been addressed
to you in error, you may not use or copy or deliver this message to
anyone else. In such case, you should destroy this message and are
asked to notify the sender by reply e-mail.
Links:
------
[1] http://www.logica.se/
------------------------------------------------------------------------------
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://lists.sourceforge.net/lists/listinfo/netdisco-users
--- End Message ---
--- Begin Message ---
I will have a look at Javascript Console.
Thanks
Med vänlig hälsning
Gustaf
Gustaf Ankarloo | Technical Specialist
Dedicated Infrastructure Services South
GIS Scandinavia | CGI Sweden
Grafiska vägen 22, 400 20 Göteborg | Sweden
T: +46 31 761 14 57| M: +46 705 67 14 57
[email protected] | www.cgi.se
CONFIDENTIALITY NOTICE: Proprietary/Confidential Information belonging to CGI
Group Inc. and its affiliates may be contained in this message. If you are not
a recipient indicated or intended in this message (or responsible for delivery
of this message to such person), or you think for any reason that this message
may have been addressed to you in error, you may not use or copy or deliver
this message to anyone else. In such case, you should destroy this message and
are asked to notify the sender by reply e-mail.
-----Original Message-----
From: Oliver Gorwits [mailto:[email protected]]
Sent: Wednesday, 18 October, 2017 09:06
To: [email protected]
Subject: Re: [Netdisco] Reports not working
Hi Gustaf
At a complete guess, I would say that something is upsetting the DataTables
plugin that renders the table on the page. Opening a javascript console in the
browser might show the issue.
However I'm not an expert in this area and I've not seen this particular
behaviour before.
regards,
oliver.
On 2017-10-11 13:17, Ankarloo, Gustaf wrote:
> Hi.
>
> I have a problem with one of my Netdisco2 installations.
>
> No reports are working.
>
> Inventory page lists correct values. But if I click on a vendor or a
> switchmodel all I get is an empty page
>
> Nothing of value in the logs.
>
> But I enabled query logging in Postgres and the queries looks legit.
>
> Any Ideas?
>
> Med vänlig hälsning
> Gustaf__
>
> GUSTAF ANKARLOO | Technical Specialist
>
> Dedicated Infrastructure Services South
>
> GIS Scandinavia | CGI Sweden
> Grafiska vägen 22, 400 20 Göteborg | Sweden
> T: +46 31 761 14 57| M: +46 705 67 14 57 [email protected] |
> www.cgi.se [1]
>
> CONFIDENTIALITY NOTICE: Proprietary/Confidential Information
> belonging to CGI Group Inc. and its affiliates may be contained in
> this message. If you are not a recipient indicated or intended in this
> message (or responsible for delivery of this message to such person),
> or you think for any reason that this message may have been addressed
> to you in error, you may not use or copy or deliver this message to
> anyone else. In such case, you should destroy this message and are
> asked to notify the sender by reply e-mail.
>
>
>
> Links:
> ------
> [1] http://www.logica.se/
>
> ----------------------------------------------------------------------
> -------- 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://lists.sourceforge.net/lists/listinfo/netdisco-users
------------------------------------------------------------------------------
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://lists.sourceforge.net/lists/listinfo/netdisco-users
--- End Message ---
--- Begin Message ---
Hello,
im having a problem to list all unused IP´s in a Scope.
When accessing
http://192.168.56.2/report/ipinventory?subnet=10.200.20.0/24&daterange=2017-09-18+to+2017-10-17&limit=256&never=on
im getting "Search failed! Please contact your site administrator"
Netdisco 2.36.11 & Postgresql 10
netdisco-web.log:
[94822] 2017-10-17 12:04:50 error request to GET
/ajax/content/report/ipinventory crashed:
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute
failed: ERROR: UNION types macaddr and text cannot be matched
LINE 1: ... AS age FROM node_nbt me) me UNION (SELECT me.ip, me.mac, me...
^ [for Statement
"SELECT me.ip, me.mac, me.time_first, me.time_last, me.dns, me.active, me.node,
me.age FROM (SELECT DISTINCT ON (ip) ip, me.mac, me.dns, date_trunc('second',
time_last) AS time_last, date_trunc('second', time_first) AS time_first,
me.active, me.node, me.age FROM (SELECT me.ip, me.mac, me.time_first,
me.time_last, me.dns, me.active, me.node, me.age FROM (SELECT me.alias AS ip,
NULL as mac, me.creation AS time_first, device.last_discover AS time_last,
me.dns, true AS active, false AS node, replace( date_trunc( 'minute', age(
now(), device.last_discover ) ) ::text, 'mon', 'month') AS age FROM device_ip
me JOIN device device ON device.ip = me.ip UNION SELECT me.ip, me.mac,
me.time_first, me.time_last, me.dns, me.active, true AS node, replace(
date_trunc( 'minute', age( now(), time_last ) ) ::text, 'mon', 'month') AS age
FROM node_ip me UNION SELECT me.ip, me.mac, me.time_first, me.time_last,
me.nbname AS dns, me.active, true AS node, replace( date_trunc( 'minute', age(
now(), time_last ) ) ::text, 'mon', 'month') AS age FROM node_nbt me) me UNION
(SELECT me.ip, me.mac, me.time_first, me.time_last, me.dns, me.active, false AS
node, replace( date_trunc( 'minute', age( now(), time_last ) ) ::text, 'mon',
'month') AS age FROM (SELECT host(network (prefix) + sub.int)::inet AS ip,
NULL AS mac,
NULL::text AS dns,
NULL::timestamp AS time_first,
NULL::timestamp AS time_last,
false::boolean AS active
FROM (
SELECT prefix,
generate_series(1, (broadcast(prefix) - network(prefix) - 1)) AS int
FROM (
SELECT ?::inet AS prefix
) AS addr
) AS sub
) me)) me WHERE ( ip << ? ) ORDER BY ip ASC, active DESC) me WHERE ( ( (
time_first IS NULL AND time_last IS NULL ) OR ( time_last >= ? AND time_last <=
? ) ) ) ORDER BY age DESC, ip ASC LIMIT ?" with ParamValues:
1='10.200.20.0/24', 2='10.200.20.0/24', 3='2017-09-18 00:00:00', 4='2017-10-17
23:59:59', 5='256'] at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Web/Plugin/Report/IpInventory.pm
line 153
--- End Message ---
--- Begin Message ---
Hello
I have yet to get the scheduler working, everything else seems functional. Any
ideas?
Built using Open Source
Software
Version
App::Netdisco<http://netdisco.org/>
2.36.9
SNMP::Info<https://github.com/netdisco/snmp-info>
3.37
DB Schema<https://metacpan.org/module/netdisco-db-deploy>
44
PostgreSQL<http://www.postgresql.org/>
9.5.8
Perl<http://www.perl.org/>
5.22.1
Here's what is in the deployment.yml, when I uncomment out the workers part the
netdisco-backend stalls and the netdisco-web will not start, comment it back
and it starts but auto scheduler/poller does not work
# this is the schedule for automatically keeping netdisco up-to-date
# ``````````````````````````````````````````````````````````````````
schedule:
discoverall:
when: '5 7 * * *'
macwalk:
when:
min: 20
arpwalk:
when:
min: 50
nbtwalk:
when: '0 8,13,21 * * *'
expire:
when: '20 23 * * *'
workers:
pollers: 10
tasks: 'AUTO * 2'
sleep_time: 1
min_runtime: 0
max_deferrals: 10
retry_after: '7 days'
Thanks in advance..
Chuck Sanderson
JELD-WEN Technology Services - LAN/WAN Integration Mgr
JELD-WEN, inc.
Corporate Business Technology
[email protected]
RELIABILITY for real life*
--- 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users
