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: Netdisco 2.44.0 --- empty neighbours map (Miha Kralj)
--- Begin Message ---
Centos 6 has default postgres version 8.4.
Installation postgres 9.4 and netdisco re-deploy resolved issue.
Thanks for tip.
On Tue, Sep 24, 2019 at 3:36 PM 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
>
--- End Message ---
_______________________________________________
Netdisco mailing list - Digest Mode
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users
