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: Upgrade to 2.42 fails (Jon Gerdes)
2. Re: Upgrade to 2.42 fails (Jon Gerdes)
--- Begin Message ---
Nikolaos
I've just upgraded 2.40.7 right now. My procedure is this:
# su - netdisco
$ ~/bin/localenv cpanm --notest App::Netdisco
$ ln -sf ~/perl5/bin/{localenv,netdisco-*} ~/bin/
$ ~/bin/netdisco-deploy
# systemctl restart netdisco-backend
# systemctl restart netdisco-web
Note the third command (ln -sf ...) which I see you don't run in the
output you posted. Please try that.
Cheers
Jon
On Fri, 2019-08-23 at 16:02 +0300, Nikolaos Milas wrote:
> Hello,
>
> I am running Netdisco 2 on CentOS 6 (with PostgreSQL v8.4.20).
>
> Upgrades usually work fine, but this time, I had a problem: Version
> 2.42
> failed during deployment. I am including below the terminal output
> for
> your reference.
>
> After the above, NetDisco continues to operate, however system info
> shows the old version, which - as I understand - means that the
> installation of the new version has failed.
>
> Please guide me to find what is wrong so that I can complete the
> upgrade
> procedure.
>
> Thanks in advance!
>
> Best Regards,
> Nick
>
>
> Follows the upgrade procedure output:
>
>
> -------------------------------------------------------------------
> -----------------
>
> [netdisco@netgaze ~]$ ~/bin/localenv cpanm --notest App::Netdisco
> --> Working on App::Netdisco
> Fetching
> http://www.cpan.org/authors/id/O/OL/OLIVER/App-Netdisco-2.042010.tar.gz
> ... OK
> Configuring App-Netdisco-2.042010 ... OK
> ==> Found dependencies: List::MoreUtils, SNMP::Info, Regexp::Common,
> Dancer::Plugin::Swagger
> --> Working on List::MoreUtils
> Fetching
> http://www.cpan.org/authors/id/R/RE/REHSACK/List-MoreUtils-0.428.tar.gz
> ... OK
> Configuring List-MoreUtils-0.428 ... OK
> ==> Found dependencies: Exporter::Tiny, List::MoreUtils::XS
> --> Working on Exporter::Tiny
> Fetching
> http://www.cpan.org/authors/id/T/TO/TOBYINK/Exporter-Tiny-1.002001.tar.gz
> ... OK
> Configuring Exporter-Tiny-1.002001 ... OK
> Building Exporter-Tiny-1.002001 ... OK
> Successfully installed Exporter-Tiny-1.002001
> --> Working on List::MoreUtils::XS
> Fetching
> http://www.cpan.org/authors/id/R/RE/REHSACK/List-MoreUtils-XS-0.428.tar.gz
> ... OK
> Configuring List-MoreUtils-XS-0.428 ... OK
> ==> Found dependencies: XSLoader
> --> Working on XSLoader
> Fetching
> http://www.cpan.org/authors/id/S/SA/SAPER/XSLoader-0.24.tar.gz
> ... OK
> Configuring XSLoader-0.24 ... OK
> Building XSLoader-0.24 ... OK
> Successfully installed XSLoader-0.24 (upgraded from 0.10)
> Building List-MoreUtils-XS-0.428 ... OK
> Successfully installed List-MoreUtils-XS-0.428
> Building List-MoreUtils-0.428 ... OK
> Successfully installed List-MoreUtils-0.428 (upgraded from 0.33)
> --> Working on SNMP::Info
> Fetching
> http://www.cpan.org/authors/id/O/OL/OLIVER/SNMP-Info-3.68.tar.gz ...
> OK
> Configuring SNMP-Info-3.68 ... OK
> Building SNMP-Info-3.68 ... OK
> Successfully installed SNMP-Info-3.68 (upgraded from 3.64)
> --> Working on Regexp::Common
> Fetching
> http://www.cpan.org/authors/id/A/AB/ABIGAIL/Regexp-Common-2017060201.tar.gz
> ... OK
> Configuring Regexp-Common-2017060201 ... OK
> Building Regexp-Common-2017060201 ... OK
> Successfully installed Regexp-Common-2017060201
> --> Working on Dancer::Plugin::Swagger
> Fetching
> http://www.cpan.org/authors/id/Y/YA/YANICK/Dancer-Plugin-Swagger-0.2.0.tar.gz
> ... OK
> ==> Found dependencies: File::ShareDir::Install
> --> Working on File::ShareDir::Install
> Fetching
> http://www.cpan.org/authors/id/E/ET/ETHER/File-ShareDir-Install-0.13.tar.gz
> ... OK
> Configuring File-ShareDir-Install-0.13 ... OK
> Building File-ShareDir-Install-0.13 ... OK
> Successfully installed File-ShareDir-Install-0.13 (upgraded from
> 0.05)
> Configuring Dancer-Plugin-Swagger-0.2.0 ... OK
> ==> Found dependencies: PerlX::Maybe, Path::Tiny,
> File::ShareDir::Tarball, Class::Load, Dancer::Plugin::REST,
> List::AllUtils, MooseX::MungeHas, MooX::Singleton
> --> Working on PerlX::Maybe
> Fetching
> http://www.cpan.org/authors/id/T/TO/TOBYINK/PerlX-Maybe-1.201.tar.gz
> ... OK
> Configuring PerlX-Maybe-1.201 ... OK
> Building PerlX-Maybe-1.201 ... OK
> Successfully installed PerlX-Maybe-1.201
> --> Working on Path::Tiny
> Fetching
> http://www.cpan.org/authors/id/D/DA/DAGOLDEN/Path-Tiny-0.108.tar.gz
> ... OK
> Configuring Path-Tiny-0.108 ... OK
> Building Path-Tiny-0.108 ... OK
> Successfully installed Path-Tiny-0.108
> --> Working on File::ShareDir::Tarball
> Fetching
> http://www.cpan.org/authors/id/Y/YA/YANICK/File-ShareDir-Tarball-0.2.2.tar.gz
> ... OK
> Configuring File-ShareDir-Tarball-0.2.2 ... OK
> ==> Found dependencies: File::chdir, Test::File::ShareDir
> --> Working on File::chdir
> Fetching
> http://www.cpan.org/authors/id/D/DA/DAGOLDEN/File-chdir-0.1010.tar.gz
> ... OK
> Configuring File-chdir-0.1010 ... OK
> Building File-chdir-0.1010 ... OK
> Successfully installed File-chdir-0.1010
> --> Working on Test::File::ShareDir
> Fetching
> http://www.cpan.org/authors/id/K/KE/KENTNL/Test-File-ShareDir-1.001002.tar.gz
> ... OK
> Configuring Test-File-ShareDir-1.001002 ... OK
> ==> Found dependencies: Class::Tiny
> --> Working on Class::Tiny
> Fetching
> http://www.cpan.org/authors/id/D/DA/DAGOLDEN/Class-Tiny-1.006.tar.gz
> ... OK
> Configuring Class-Tiny-1.006 ... OK
> Building Class-Tiny-1.006 ... OK
> Successfully installed Class-Tiny-1.006
> Building Test-File-ShareDir-1.001002 ... OK
> Successfully installed Test-File-ShareDir-1.001002
> Building File-ShareDir-Tarball-0.2.2 ... OK
> Successfully installed File-ShareDir-Tarball-0.2.2
> --> Working on Class::Load
> Fetching
> http://www.cpan.org/authors/id/E/ET/ETHER/Class-Load-0.25.tar.gz ...
> OK
> Configuring Class-Load-0.25 ... OK
> ==> Found dependencies: Data::OptList
> --> Working on Data::OptList
> Fetching
> http://www.cpan.org/authors/id/R/RJ/RJBS/Data-OptList-0.110.tar.gz
> ... OK
> Configuring Data-OptList-0.110 ... OK
> Building Data-OptList-0.110 ... OK
> Successfully installed Data-OptList-0.110 (upgraded from 0.108)
> Building Class-Load-0.25 ... OK
> Successfully installed Class-Load-0.25
> --> Working on Dancer::Plugin::REST
> Fetching
> http://www.cpan.org/authors/id/Y/YA/YANICK/Dancer-Plugin-REST-0.11.tar.gz
> ... OK
> Configuring Dancer-Plugin-REST-0.11 ... OK
> Building Dancer-Plugin-REST-0.11 ... OK
> Successfully installed Dancer-Plugin-REST-0.11
> --> Working on List::AllUtils
> Fetching
> http://www.cpan.org/authors/id/D/DR/DROLSKY/List-AllUtils-0.15.tar.gz
> ... OK
> Configuring List-AllUtils-0.15 ... OK
> ==> Found dependencies: List::UtilsBy, List::SomeUtils
> --> Working on List::UtilsBy
> Fetching
> http://www.cpan.org/authors/id/P/PE/PEVANS/List-UtilsBy-0.11.tar.gz
> ... OK
> Configuring List-UtilsBy-0.11 ... OK
> Building List-UtilsBy-0.11 ... OK
> Successfully installed List-UtilsBy-0.11
> --> Working on List::SomeUtils
> Fetching
> http://www.cpan.org/authors/id/D/DR/DROLSKY/List-SomeUtils-0.56.tar.gz
> ... OK
> Configuring List-SomeUtils-0.56 ... OK
> ==> Found dependencies: List::SomeUtils::XS
> --> Working on List::SomeUtils::XS
> Fetching
> http://www.cpan.org/authors/id/D/DR/DROLSKY/List-SomeUtils-XS-0.58.tar.gz
> ... OK
> Configuring List-SomeUtils-XS-0.58 ... OK
> Building List-SomeUtils-XS-0.58 ... OK
> Successfully installed List-SomeUtils-XS-0.58
> Building List-SomeUtils-0.56 ... OK
> Successfully installed List-SomeUtils-0.56
> Building List-AllUtils-0.15 ... OK
> Successfully installed List-AllUtils-0.15
> --> Working on MooseX::MungeHas
> Fetching
> http://www.cpan.org/authors/id/T/TO/TOBYINK/MooseX-MungeHas-0.011.tar.gz
> ... OK
> Configuring MooseX-MungeHas-0.011 ... OK
> Building MooseX-MungeHas-0.011 ... OK
> Successfully installed MooseX-MungeHas-0.011
> --> Working on MooX::Singleton
> Fetching
> http://www.cpan.org/authors/id/A/AJ/AJGB/MooX-Singleton-1.20.tar.gz
> ... OK
> Configuring MooX-Singleton-1.20 ... OK
> Building MooX-Singleton-1.20 ... OK
> Successfully installed MooX-Singleton-1.20
> Building Dancer-Plugin-Swagger-0.2.0 ... OK
> Successfully installed Dancer-Plugin-Swagger-0.2.0
> Building App-Netdisco-2.042010 ... OK
> Successfully installed App-Netdisco-2.042010 (upgraded from 2.040003)
> 24 distributions installed
> [netdisco@netgaze ~]$
> [netdisco@netgaze ~]$ ~/bin/netdisco-deploy
> This is the Netdisco II deployment script.
>
> Before we continue, the following prerequisites must be in place:
> * Database added to PostgreSQL for Netdisco
> * User added to PostgreSQL with rights to the Netdisco Database
> * "~/environments/deployment.yml" file configured with Database
> dsn/user/pass
> * A full backup of any existing Netdisco database data
> * Internet access (for OUIs and MIBs)
>
> You will be asked to confirm all changes to your system.
>
> So, is all of the above in place? [y/N]: y
>
> Would you like to deploy the database schema? [y/N]: y
> DBIx::Class::Schema::Versioned::_on_connect(): Versions out of sync.
> This is 58, your database contains version 53, please call upgrade
> on
> your Schema. at /home/netdisco/perl5/lib/perl5/Dancer/Plugin/DBIC.pm
> line 62
> DBIx::Class::Schema::Versioned::upgrade_single_step(): DB version
> (53)
> is lower than the schema version (58). Attempting upgrade.
> DBIx::Class::Schema::Versioned::upgrade_single_step(): DB version
> (54)
> is lower than the schema version (58). Attempting upgrade.
> DBIx::Class::Schema::Versioned::upgrade_single_step(): DB version
> (55)
> is lower than the schema version (58). Attempting upgrade.
> DBIx::Class::Schema::Versioned::upgrade_single_step(): DB version
> (56)
> is lower than the schema version (58). Attempting upgrade.
> DBIx::Class::Schema::Versioned::upgrade_single_step(): DB version
> (57)
> is lower than the schema version (58). Attempting upgrade.
> NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index
> "device_port_wireless_pkey" for table "device_port_wireless"
> NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index
> "device_port_log_pkey" for table "device_port_log"
> DB schema update complete.
> 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 "INSERT
> INTO
> statistics ( day, device_count, device_ip_count, device_link_count,
> device_port_count, device_port_up_count, ip_active_count,
> ip_table_count, netdisco_ver, node_active_count, node_table_count,
> perl_ver, pg_ver, schema_ver, snmpinfo_ver) VALUES ( ?, (SELECT
> COUNT( *
> ) FROM device me), (SELECT COUNT( * ) FROM device_ip me), (SELECT
> COALESCE( SUM( aggports ), 0 ) 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), (SELECT COUNT( * ) FROM device_port me), (SELECT COUNT( * )
> FROM
> device_port me WHERE ( up = ? )), (SELECT COUNT( * ) FROM (SELECT
> me.ip
> FROM node_ip me WHERE ( active ) GROUP BY me.ip) me), (SELECT COUNT(
> * )
> FROM node_ip me), ?, (SELECT COUNT( * ) FROM (SELECT me.mac FROM node
> me
> WHERE ( active ) GROUP BY me.mac) me), (SELECT COUNT( * ) FROM node
> me),
> ?, ?, ?, ? )" with ParamValues: 1='2019-08-23', 2='up', 3='2.42.10',
> 4='5.10.1', 5='8.4.20', 6='58', 7='3.68'] at
> /home/netdisco/perl5/lib/perl5/App/Netdisco/Util/Statistics.pm line
> 42
> Updating statistics...
>
> [netdisco@netgaze ~]$ rpm -qa | grep postgres
> postgresql-server-8.4.20-8.el6_9.x86_64
> postgresql-8.4.20-8.el6_9.x86_64
> postgresql-devel-8.4.20-8.el6_9.x86_64
> postgresql-libs-8.4.20-8.el6_9.x86_64
>
> -------------------------------------------------------------------
> -----------------
>
>
>
>
>
>
>
> _______________________________________________
> Netdisco mailing list
> [email protected]
> https://sourceforge.net/p/netdisco/mailman/netdisco-users/
--- End Message ---
--- Begin Message ---
Nikolaos
Sorry, I should have noticed, you are running Postgres <old>. I can
see a thread here where Oliver is going to take a look. Scott Harrison
- 20th June 2019 ("Upgrade to 2.042010 fails when running
~/bin/netdisco-deploy")
I'm not 100% sure but a new Postgres may be the way to go. My Ubuntu
LTS has version 10 on it.
Cheers
Jon
On Sun, 2019-08-25 at 13:26 +0000, Jon Gerdes wrote:
> Nikolaos
>
> I've just upgraded 2.40.7 right now. My procedure is this:
>
> # su - netdisco
> $ ~/bin/localenv cpanm --notest App::Netdisco
> $ ln -sf ~/perl5/bin/{localenv,netdisco-*} ~/bin/
> $ ~/bin/netdisco-deploy
>
> # systemctl restart netdisco-backend
> # systemctl restart netdisco-web
>
> Note the third command (ln -sf ...) which I see you don't run in the
> output you posted. Please try that.
>
> Cheers
> Jon
>
>
>
> On Fri, 2019-08-23 at 16:02 +0300, Nikolaos Milas wrote:
> > Hello,
> >
> > I am running Netdisco 2 on CentOS 6 (with PostgreSQL v8.4.20).
> >
> > Upgrades usually work fine, but this time, I had a problem: Version
> > 2.42
> > failed during deployment. I am including below the terminal output
> > for
> > your reference.
> >
> > After the above, NetDisco continues to operate, however system
> > info
> > shows the old version, which - as I understand - means that the
> > installation of the new version has failed.
> >
> > Please guide me to find what is wrong so that I can complete the
> > upgrade
> > procedure.
> >
> > Thanks in advance!
> >
> > Best Regards,
> > Nick
> >
> >
> > Follows the upgrade procedure output:
> >
> >
> > -------------------------------------------------------------------
> > -----------------
> >
> > [netdisco@netgaze ~]$ ~/bin/localenv cpanm --notest App::Netdisco
> > --> Working on App::Netdisco
> > Fetching
> > http://www.cpan.org/authors/id/O/OL/OLIVER/App-Netdisco-2.042010.tar.gz
> > ... OK
> > Configuring App-Netdisco-2.042010 ... OK
> > ==> Found dependencies: List::MoreUtils, SNMP::Info,
> > Regexp::Common,
> > Dancer::Plugin::Swagger
> > --> Working on List::MoreUtils
> > Fetching
> > http://www.cpan.org/authors/id/R/RE/REHSACK/List-MoreUtils-0.428.tar.gz
> > ... OK
> > Configuring List-MoreUtils-0.428 ... OK
> > ==> Found dependencies: Exporter::Tiny, List::MoreUtils::XS
> > --> Working on Exporter::Tiny
> > Fetching
> > http://www.cpan.org/authors/id/T/TO/TOBYINK/Exporter-Tiny-1.002001.tar.gz
> > ... OK
> > Configuring Exporter-Tiny-1.002001 ... OK
> > Building Exporter-Tiny-1.002001 ... OK
> > Successfully installed Exporter-Tiny-1.002001
> > --> Working on List::MoreUtils::XS
> > Fetching
> > http://www.cpan.org/authors/id/R/RE/REHSACK/List-MoreUtils-XS-0.428.tar.gz
> > ... OK
> > Configuring List-MoreUtils-XS-0.428 ... OK
> > ==> Found dependencies: XSLoader
> > --> Working on XSLoader
> > Fetching
> > http://www.cpan.org/authors/id/S/SA/SAPER/XSLoader-0.24.tar.gz
> > ... OK
> > Configuring XSLoader-0.24 ... OK
> > Building XSLoader-0.24 ... OK
> > Successfully installed XSLoader-0.24 (upgraded from 0.10)
> > Building List-MoreUtils-XS-0.428 ... OK
> > Successfully installed List-MoreUtils-XS-0.428
> > Building List-MoreUtils-0.428 ... OK
> > Successfully installed List-MoreUtils-0.428 (upgraded from 0.33)
> > --> Working on SNMP::Info
> > Fetching
> > http://www.cpan.org/authors/id/O/OL/OLIVER/SNMP-Info-3.68.tar.gz
> > ...
> > OK
> > Configuring SNMP-Info-3.68 ... OK
> > Building SNMP-Info-3.68 ... OK
> > Successfully installed SNMP-Info-3.68 (upgraded from 3.64)
> > --> Working on Regexp::Common
> > Fetching
> > http://www.cpan.org/authors/id/A/AB/ABIGAIL/Regexp-Common-2017060201.tar.gz
> > ... OK
> > Configuring Regexp-Common-2017060201 ... OK
> > Building Regexp-Common-2017060201 ... OK
> > Successfully installed Regexp-Common-2017060201
> > --> Working on Dancer::Plugin::Swagger
> > Fetching
> > http://www.cpan.org/authors/id/Y/YA/YANICK/Dancer-Plugin-Swagger-0.2.0.tar.gz
> >
> > ... OK
> > ==> Found dependencies: File::ShareDir::Install
> > --> Working on File::ShareDir::Install
> > Fetching
> > http://www.cpan.org/authors/id/E/ET/ETHER/File-ShareDir-Install-0.13.tar.gz
> > ... OK
> > Configuring File-ShareDir-Install-0.13 ... OK
> > Building File-ShareDir-Install-0.13 ... OK
> > Successfully installed File-ShareDir-Install-0.13 (upgraded from
> > 0.05)
> > Configuring Dancer-Plugin-Swagger-0.2.0 ... OK
> > ==> Found dependencies: PerlX::Maybe, Path::Tiny,
> > File::ShareDir::Tarball, Class::Load, Dancer::Plugin::REST,
> > List::AllUtils, MooseX::MungeHas, MooX::Singleton
> > --> Working on PerlX::Maybe
> > Fetching
> > http://www.cpan.org/authors/id/T/TO/TOBYINK/PerlX-Maybe-1.201.tar.gz
> > ... OK
> > Configuring PerlX-Maybe-1.201 ... OK
> > Building PerlX-Maybe-1.201 ... OK
> > Successfully installed PerlX-Maybe-1.201
> > --> Working on Path::Tiny
> > Fetching
> > http://www.cpan.org/authors/id/D/DA/DAGOLDEN/Path-Tiny-0.108.tar.gz
> > ... OK
> > Configuring Path-Tiny-0.108 ... OK
> > Building Path-Tiny-0.108 ... OK
> > Successfully installed Path-Tiny-0.108
> > --> Working on File::ShareDir::Tarball
> > Fetching
> > http://www.cpan.org/authors/id/Y/YA/YANICK/File-ShareDir-Tarball-0.2.2.tar.gz
> >
> > ... OK
> > Configuring File-ShareDir-Tarball-0.2.2 ... OK
> > ==> Found dependencies: File::chdir, Test::File::ShareDir
> > --> Working on File::chdir
> > Fetching
> > http://www.cpan.org/authors/id/D/DA/DAGOLDEN/File-chdir-0.1010.tar.gz
> > ... OK
> > Configuring File-chdir-0.1010 ... OK
> > Building File-chdir-0.1010 ... OK
> > Successfully installed File-chdir-0.1010
> > --> Working on Test::File::ShareDir
> > Fetching
> > http://www.cpan.org/authors/id/K/KE/KENTNL/Test-File-ShareDir-1.001002.tar.gz
> >
> > ... OK
> > Configuring Test-File-ShareDir-1.001002 ... OK
> > ==> Found dependencies: Class::Tiny
> > --> Working on Class::Tiny
> > Fetching
> > http://www.cpan.org/authors/id/D/DA/DAGOLDEN/Class-Tiny-1.006.tar.gz
> > ... OK
> > Configuring Class-Tiny-1.006 ... OK
> > Building Class-Tiny-1.006 ... OK
> > Successfully installed Class-Tiny-1.006
> > Building Test-File-ShareDir-1.001002 ... OK
> > Successfully installed Test-File-ShareDir-1.001002
> > Building File-ShareDir-Tarball-0.2.2 ... OK
> > Successfully installed File-ShareDir-Tarball-0.2.2
> > --> Working on Class::Load
> > Fetching
> > http://www.cpan.org/authors/id/E/ET/ETHER/Class-Load-0.25.tar.gz
> > ...
> > OK
> > Configuring Class-Load-0.25 ... OK
> > ==> Found dependencies: Data::OptList
> > --> Working on Data::OptList
> > Fetching
> > http://www.cpan.org/authors/id/R/RJ/RJBS/Data-OptList-0.110.tar.gz
> > ... OK
> > Configuring Data-OptList-0.110 ... OK
> > Building Data-OptList-0.110 ... OK
> > Successfully installed Data-OptList-0.110 (upgraded from 0.108)
> > Building Class-Load-0.25 ... OK
> > Successfully installed Class-Load-0.25
> > --> Working on Dancer::Plugin::REST
> > Fetching
> > http://www.cpan.org/authors/id/Y/YA/YANICK/Dancer-Plugin-REST-0.11.tar.gz
> > ... OK
> > Configuring Dancer-Plugin-REST-0.11 ... OK
> > Building Dancer-Plugin-REST-0.11 ... OK
> > Successfully installed Dancer-Plugin-REST-0.11
> > --> Working on List::AllUtils
> > Fetching
> > http://www.cpan.org/authors/id/D/DR/DROLSKY/List-AllUtils-0.15.tar.gz
> > ... OK
> > Configuring List-AllUtils-0.15 ... OK
> > ==> Found dependencies: List::UtilsBy, List::SomeUtils
> > --> Working on List::UtilsBy
> > Fetching
> > http://www.cpan.org/authors/id/P/PE/PEVANS/List-UtilsBy-0.11.tar.gz
> > ... OK
> > Configuring List-UtilsBy-0.11 ... OK
> > Building List-UtilsBy-0.11 ... OK
> > Successfully installed List-UtilsBy-0.11
> > --> Working on List::SomeUtils
> > Fetching
> > http://www.cpan.org/authors/id/D/DR/DROLSKY/List-SomeUtils-0.56.tar.gz
> > ... OK
> > Configuring List-SomeUtils-0.56 ... OK
> > ==> Found dependencies: List::SomeUtils::XS
> > --> Working on List::SomeUtils::XS
> > Fetching
> > http://www.cpan.org/authors/id/D/DR/DROLSKY/List-SomeUtils-XS-0.58.tar.gz
> > ... OK
> > Configuring List-SomeUtils-XS-0.58 ... OK
> > Building List-SomeUtils-XS-0.58 ... OK
> > Successfully installed List-SomeUtils-XS-0.58
> > Building List-SomeUtils-0.56 ... OK
> > Successfully installed List-SomeUtils-0.56
> > Building List-AllUtils-0.15 ... OK
> > Successfully installed List-AllUtils-0.15
> > --> Working on MooseX::MungeHas
> > Fetching
> > http://www.cpan.org/authors/id/T/TO/TOBYINK/MooseX-MungeHas-0.011.tar.gz
> > ... OK
> > Configuring MooseX-MungeHas-0.011 ... OK
> > Building MooseX-MungeHas-0.011 ... OK
> > Successfully installed MooseX-MungeHas-0.011
> > --> Working on MooX::Singleton
> > Fetching
> > http://www.cpan.org/authors/id/A/AJ/AJGB/MooX-Singleton-1.20.tar.gz
> > ... OK
> > Configuring MooX-Singleton-1.20 ... OK
> > Building MooX-Singleton-1.20 ... OK
> > Successfully installed MooX-Singleton-1.20
> > Building Dancer-Plugin-Swagger-0.2.0 ... OK
> > Successfully installed Dancer-Plugin-Swagger-0.2.0
> > Building App-Netdisco-2.042010 ... OK
> > Successfully installed App-Netdisco-2.042010 (upgraded from
> > 2.040003)
> > 24 distributions installed
> > [netdisco@netgaze ~]$
> > [netdisco@netgaze ~]$ ~/bin/netdisco-deploy
> > This is the Netdisco II deployment script.
> >
> > Before we continue, the following prerequisites must be in place:
> > * Database added to PostgreSQL for Netdisco
> > * User added to PostgreSQL with rights to the Netdisco Database
> > * "~/environments/deployment.yml" file configured with Database
> > dsn/user/pass
> > * A full backup of any existing Netdisco database data
> > * Internet access (for OUIs and MIBs)
> >
> > You will be asked to confirm all changes to your system.
> >
> > So, is all of the above in place? [y/N]: y
> >
> > Would you like to deploy the database schema? [y/N]: y
> > DBIx::Class::Schema::Versioned::_on_connect(): Versions out of
> > sync.
> > This is 58, your database contains version 53, please call upgrade
> > on
> > your Schema. at
> > /home/netdisco/perl5/lib/perl5/Dancer/Plugin/DBIC.pm
> > line 62
> > DBIx::Class::Schema::Versioned::upgrade_single_step(): DB version
> > (53)
> > is lower than the schema version (58). Attempting upgrade.
> > DBIx::Class::Schema::Versioned::upgrade_single_step(): DB version
> > (54)
> > is lower than the schema version (58). Attempting upgrade.
> > DBIx::Class::Schema::Versioned::upgrade_single_step(): DB version
> > (55)
> > is lower than the schema version (58). Attempting upgrade.
> > DBIx::Class::Schema::Versioned::upgrade_single_step(): DB version
> > (56)
> > is lower than the schema version (58). Attempting upgrade.
> > DBIx::Class::Schema::Versioned::upgrade_single_step(): DB version
> > (57)
> > is lower than the schema version (58). Attempting upgrade.
> > NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index
> > "device_port_wireless_pkey" for table "device_port_wireless"
> > NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index
> > "device_port_log_pkey" for table "device_port_log"
> > DB schema update complete.
> > 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 "INSERT
> > INTO
> > statistics ( day, device_count, device_ip_count,
> > device_link_count,
> > device_port_count, device_port_up_count, ip_active_count,
> > ip_table_count, netdisco_ver, node_active_count, node_table_count,
> > perl_ver, pg_ver, schema_ver, snmpinfo_ver) VALUES ( ?, (SELECT
> > COUNT( *
> > ) FROM device me), (SELECT COUNT( * ) FROM device_ip me), (SELECT
> > COALESCE( SUM( aggports ), 0 ) 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), (SELECT COUNT( * ) FROM device_port me), (SELECT COUNT( * )
> > FROM
> > device_port me WHERE ( up = ? )), (SELECT COUNT( * ) FROM (SELECT
> > me.ip
> > FROM node_ip me WHERE ( active ) GROUP BY me.ip) me), (SELECT
> > COUNT(
> > * )
> > FROM node_ip me), ?, (SELECT COUNT( * ) FROM (SELECT me.mac FROM
> > node
> > me
> > WHERE ( active ) GROUP BY me.mac) me), (SELECT COUNT( * ) FROM node
> > me),
> > ?, ?, ?, ? )" with ParamValues: 1='2019-08-23', 2='up',
> > 3='2.42.10',
> > 4='5.10.1', 5='8.4.20', 6='58', 7='3.68'] at
> > /home/netdisco/perl5/lib/perl5/App/Netdisco/Util/Statistics.pm line
> > 42
> > Updating statistics...
> >
> > [netdisco@netgaze ~]$ rpm -qa | grep postgres
> > postgresql-server-8.4.20-8.el6_9.x86_64
> > postgresql-8.4.20-8.el6_9.x86_64
> > postgresql-devel-8.4.20-8.el6_9.x86_64
> > postgresql-libs-8.4.20-8.el6_9.x86_64
> >
> > -------------------------------------------------------------------
> > -----------------
> >
> >
> >
> >
> >
> >
> >
> > _______________________________________________
> > Netdisco mailing list
> > [email protected]
> > https://sourceforge.net/p/netdisco/mailman/netdisco-users/
>
> _______________________________________________
> 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
