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. Netdisco 2.44.0 --- empty neighbours map (Miha Kralj)
2. Re: Arpwalk, Macsuck or Discover not successful on some
devices (Christian Ramseyer)
3. Re: Netdisco 2.44.0 --- empty neighbours map (Oliver Gorwits)
--- Begin Message ---
Hi,
the latest version 2.44 has bug in neighbours map. Installation is fresh on
Centos 6.10.
Previous version 2.43.1 does not have this kind of problem.
Please advice...
This is from netdisco-web.log
error request to GET /ajax/data/device/netmap crashed:
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st
execute failed: ERROR: syntax error at or near "ORDER"
LINE 5: array_agg(dp.port ORDER BY dp.port) AS left_por...
^ [for Statement "SELECT me.left_ip,
me.left_dns, me.left_name, me.left_port, me.left_descr, me.aggspeed,
me.aggports, me.right_ip, me.right_dns, me.right_name, me.right_port,
me.right_descr FROM ( WITH BothWays AS
( SELECT dp.ip AS left_ip,
ld.dns AS left_dns,
ld.name AS left_name,
array_agg(dp.port ORDER BY dp.port) AS left_port,
array_agg(dp.name ORDER BY dp.name) AS left_descr,
count(dpp.*) AS aggports,
sum(COALESCE(dpp.raw_speed, 0)) AS aggspeed,
di.ip AS right_ip,
rd.dns AS right_dns,
rd.name AS right_name,
array_agg(dp.remote_port ORDER BY dp.remote_port) AS
right_port,
array_agg(dp2.name ORDER BY dp2.name) AS right_descr
FROM device_port dp
LEFT OUTER JOIN device_port_properties dpp ON (
(dp.ip = dpp.ip) AND (dp.port = dpp.port)
AND (dp.type IS NULL
OR dp.type !~*
'^(53|ieee8023adLag|propVirtual|l2vlan|l3ipvlan|135|136|137)$')
AND (dp.is_master = 'false'
OR dp.slave_of IS NOT NULL) )
INNER JOIN device ld ON dp.ip = ld.ip
INNER JOIN device_ip di ON dp.remote_ip = di.alias
INNER JOIN device rd ON di.ip = rd.ip
LEFT OUTER JOIN device_port dp2 ON (di.ip = dp2.ip
AND ((dp.remote_port = dp2.port)
OR (dp.remote_port = dp2.name)
OR (dp.remote_port =
dp2.descr)))
WHERE dp.remote_port IS NOT NULL
AND dp.port !~* 'vlan'
AND (dp.descr IS NULL OR dp.descr !~* 'vlan')
GROUP BY left_ip,
left_dns,
left_name,
right_ip,
right_dns,
right_name )
SELECT *
FROM BothWays b
WHERE NOT EXISTS
( SELECT *
FROM BothWays b2
WHERE b2.right_ip = b.left_ip
AND b2.right_port = b.left_port
AND b2.left_ip < b.left_ip )
ORDER BY aggspeed DESC, 1, 2
) me WHERE ( ( left_ip = ? OR right_ip = ? ) )" with ParamValues:
1='10.10.254.92', 2='10.10.254.92'] at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Web/Plugin/Device/Neighbors.pm
line 178
--- End Message ---
--- Begin Message ---
On 23.09.19 16:52, Charlie Butera wrote:
> Christian,
>
> Definitely making progress! so for all jobs that are not working the
> last job in the admin table shows the job being queued on a host.
> One thing to note is that I had/have 2 netdisco hosts running both the
> frontend and the backend service with a separate host running the database.
> I have disabled one of the 2 frontend/backend netdisco hosts for the
> time being to troubleshoot this issue but it seems the issue is somehow
> related to my deployment setup.
Cool, at least we're getting somewhere. Let us know if that makes the
polling work normally again. You might have to delete the stuck entries
from the admin queue:
delete from admin where device = '<ip>'
or you can also just nuke the whole queue to start over:
delete from admin
There might be some bugs with multiple pollers that nobody discovered
yet. If you manage to reproduce stuck jobs we really appreciate if you
drop us the details here or raise an issue at
https://github.com/netdisco/netdisco/issues.
Cheers
Christian
--- End Message ---
--- Begin Message ---
Hi Miha
Please can you ensure you're running PostgreSQL version 9.4 or later, and
try again?
Many thanks,
oliver.
On Tue, 24 Sep 2019 at 14:37, Miha Kralj <[email protected]> wrote:
> Hi,
>
> the latest version 2.44 has bug in neighbours map. Installation is fresh
> on Centos 6.10.
> Previous version 2.43.1 does not have this kind of problem.
> Please advice...
>
> This is from netdisco-web.log
>
>
> error request to GET /ajax/data/device/netmap crashed:
> DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st
> execute failed: ERROR: syntax error at or near "ORDER"
> LINE 5: array_agg(dp.port ORDER BY dp.port) AS left_por...
> ^ [for Statement "SELECT
> me.left_ip, me.left_dns, me.left_name, me.left_port, me.left_descr,
> me.aggspeed, me.aggports, me.right_ip, me.right_dns, me.right_name,
> me.right_port, me.right_descr FROM ( WITH BothWays AS
> ( SELECT dp.ip AS left_ip,
> ld.dns AS left_dns,
> ld.name AS left_name,
> array_agg(dp.port ORDER BY dp.port) AS left_port,
> array_agg(dp.name ORDER BY dp.name) AS left_descr,
>
> count(dpp.*) AS aggports,
> sum(COALESCE(dpp.raw_speed, 0)) AS aggspeed,
>
> di.ip AS right_ip,
> rd.dns AS right_dns,
> rd.name AS right_name,
> array_agg(dp.remote_port ORDER BY dp.remote_port) AS
> right_port,
> array_agg(dp2.name ORDER BY dp2.name) AS right_descr
>
> FROM device_port dp
>
> LEFT OUTER JOIN device_port_properties dpp ON (
> (dp.ip = dpp.ip) AND (dp.port = dpp.port)
> AND (dp.type IS NULL
> OR dp.type !~*
> '^(53|ieee8023adLag|propVirtual|l2vlan|l3ipvlan|135|136|137)$')
> AND (dp.is_master = 'false'
> OR dp.slave_of IS NOT NULL) )
>
> INNER JOIN device ld ON dp.ip = ld.ip
> INNER JOIN device_ip di ON dp.remote_ip = di.alias
> INNER JOIN device rd ON di.ip = rd.ip
>
> LEFT OUTER JOIN device_port dp2 ON (di.ip = dp2.ip
> AND ((dp.remote_port = dp2.port)
> OR (dp.remote_port =
> dp2.name)
> OR (dp.remote_port =
> dp2.descr)))
>
> WHERE dp.remote_port IS NOT NULL
> AND dp.port !~* 'vlan'
> AND (dp.descr IS NULL OR dp.descr !~* 'vlan')
>
> GROUP BY left_ip,
> left_dns,
> left_name,
> right_ip,
> right_dns,
> right_name )
>
> SELECT *
> FROM BothWays b
> WHERE NOT EXISTS
> ( SELECT *
> FROM BothWays b2
> WHERE b2.right_ip = b.left_ip
> AND b2.right_port = b.left_port
> AND b2.left_ip < b.left_ip )
> ORDER BY aggspeed DESC, 1, 2
> ) me WHERE ( ( left_ip = ? OR right_ip = ? ) )" with ParamValues:
> 1='10.10.254.92', 2='10.10.254.92'] at
> /home/netdisco/perl5/lib/perl5/App/Netdisco/Web/Plugin/Device/Neighbors.pm
> line 178
> _______________________________________________
> 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
