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. problemw with neighbot map (Eric Doutreleau)
2. Re: problemw with neighbot map (Oliver Gorwits)
3. Re: problemw with neighbot map (Eric Doutreleau)
--- Begin Message ---
Hi
I just upgrade to the last version 2.43.1 and i discover the menu
neighbor for a device
but when i click in it i got a blank page.
I read the log file and in the netdisco
3674] 2019-09-20 14:58:08 error request to GET /ajax/data/device/netmap
crashed: DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception:
DBD::Pg::st execute failed: ERREU
R: erreur de syntaxe sur ou près de « 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='172.24.112.6', 2='172.24.112.6'] at
/usr/share/netdisco/perl5/lib/perl5/App/Netdisco/Web/Plugin/Device/N
eighbors.pm line 178
here is the version i use
Software Version
App::Netdisco 2.43.1
SNMP::Info 3.68
DB Schema 59
PostgreSQL 8.4.20
Perl 5.10.1
does someone know how to solve this problem?
--- End Message ---
--- Begin Message ---
Hi eric
This is very likely related to your version of PostgreSQL, which is quite
old. Are you able to upgrade to 9.4 or later?
Regards
Oliver.
On Fri, 20 Sep 2019 at 17:12, Eric Doutreleau <[email protected]>
wrote:
> Hi
>
>
> I just upgrade to the last version 2.43.1 and i discover the menu
> neighbor for a device
>
> but when i click in it i got a blank page.
>
> I read the log file and in the netdisco
>
> 3674] 2019-09-20 14:58:08 error request to GET /ajax/data/device/netmap
> crashed: DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception:
> DBD::Pg::st execute failed: ERREU
> R: erreur de syntaxe sur ou près de « 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='172.24.112.6', 2='172.24.112.6'] at
> /usr/share/netdisco/perl5/lib/perl5/App/Netdisco/Web/Plugin/Device/N
> eighbors.pm line 178
>
> here is the version i use
>
> Software Version
> App::Netdisco 2.43.1
> SNMP::Info 3.68
> DB Schema 59
> PostgreSQL 8.4.20
> Perl 5.10.1
>
>
> does someone know how to solve this problem?
>
>
>
>
>
>
> _______________________________________________
> Netdisco mailing list
> [email protected]
> https://sourceforge.net/p/netdisco/mailman/netdisco-users/
--- End Message ---
--- Begin Message ---
Hi
Indeed i had an old version of postgresql
i just upgrade and all is working better right now
thanks for your answer
Le 20/09/2019 à 18:20, Oliver Gorwits a écrit :
Hi eric
This is very likely related to your version of PostgreSQL, which is
quite old. Are you able to upgrade to 9.4 or later?
Regards
Oliver.
On Fri, 20 Sep 2019 at 17:12, Eric Doutreleau
<[email protected] <mailto:[email protected]>>
wrote:
Hi
I just upgrade to the last version 2.43.1 and i discover the menu
neighbor for a device
but when i click in it i got a blank page.
I read the log file and in the netdisco
3674] 2019-09-20 14:58:08 error request to GET
/ajax/data/device/netmap
crashed: DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception:
DBD::Pg::st execute failed: ERREU
R: erreur de syntaxe sur ou près de « 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 <http://ld.name> AS left_name,
array_agg(dp.port ORDER BY dp.port) AS left_port,
array_agg(dp.name <http://dp.name> ORDER BY dp.name
<http://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 <http://rd.name> AS right_name,
array_agg(dp.remote_port ORDER BY dp.remote_port) AS
right_port,
array_agg(dp2.name <http://dp2.name> ORDER BY
dp2.name <http://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 <http://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='172.24.112.6', 2='172.24.112.6'] at
/usr/share/netdisco/perl5/lib/perl5/App/Netdisco/Web/Plugin/Device/N
eighbors.pm <http://eighbors.pm> line 178
here is the version i use
Software Version
App::Netdisco 2.43.1
SNMP::Info 3.68
DB Schema 59
PostgreSQL 8.4.20
Perl 5.10.1
does someone know how to solve this problem?
_______________________________________________
Netdisco mailing list
[email protected]
<mailto:[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
