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. UnVersioned database issue (Daniel Bird)
2. Re: UnVersioned database issue (Sanjeev Gupta)
--- Begin Message ---
Hi All,
We've noticed we're sometimes not seeing MAC addresses appear in our Netdisco2
install, and I've just seen this
[netdisco2@netmanage ~]$ bin/netdisco-do macsuck -d <device> -DISQ
DBIx::Class::Schema::Versioned::_on_connect(): Your DB is currently
unversioned. Please call upgrade on your schema to sync the DB. at
/home/netdisco2/perl5/lib/perl5/DBICx/Sugar.pm line 85
Can't locate object method "autoflush" via package "FileHandle" at
/home/netdisco2/perl5/lib/perl5/DBIx/Class/Storage/Statistics.pm line 80. at
/home/netdisco2/perl5/lib/perl5/DBIx/Class/Schema.pm line 1077.
DBIx::Class::Schema::throw_exception(App::Netdisco::DB=HASH(0x11fbf80),
"Can't locate object method \"autoflush\" via package \"FileHandl"...) called
at /home/netdisco2/perl5/lib/perl5/DBIx/Class/Storage.pm line 112
DBIx::Class::Storage::throw_exception(DBIx::Class::Storage::DBI::Pg=HASH(0x36912c8),
"Can't locate object method \"autoflush\" via package \"FileHandl"...) called
at /home/netdisco2/perl5/lib/perl5/DBIx/Class/Storage/BlockRunner.pm line 184
DBIx::Class::Storage::BlockRunner::__ANON__() called at
/home/netdisco2/perl5/lib/perl5/Context/Preserve.pm line 37
Context::Preserve::preserve_context(CODE(0x47fb188), "replace",
CODE(0x47f8a10)) called at
/home/netdisco2/perl5/lib/perl5/DBIx/Class/Storage/BlockRunner.pm line 213
DBIx::Class::Storage::BlockRunner::_run(DBIx::Class::Storage::BlockRunner=HASH(0x47fb338),
CODE(0x47fb1a0)) called at
/home/netdisco2/perl5/lib/perl5/DBIx/Class/Storage/BlockRunner.pm line 105
DBIx::Class::Storage::BlockRunner::run(DBIx::Class::Storage::BlockRunner=HASH(0x47fb338),
CODE(0x47fb1a0)) called at
/home/netdisco2/perl5/lib/perl5/DBIx/Class/Storage/DBI.pm line 857
DBIx::Class::Storage::DBI::dbh_do(undef, undef, "SELECT me.ip,
me.alias, me.subnet, me.port, me.dns, me.creati"..., ARRAY(0x47380a0),
ARRAY(0x4728840)) called at
/home/netdisco2/perl5/lib/perl5/DBIx/Class/Storage/DBI.pm line 1815
DBIx::Class::Storage::DBI::_execute(DBIx::Class::Storage::DBI::Pg=HASH(0x36912c8),
"select", ARRAY(0x48050f8), ARRAY(0x48051e8), HASH(0x392be28),
HASH(0x4728ab0)) called at
/home/netdisco2/perl5/lib/perl5/DBIx/Class/Storage/DBI.pm line 2389
DBIx::Class::Storage::DBI::_select(DBIx::Class::Storage::DBI::Pg=HASH(0x36912c8),
ARRAY(0x48050f8), ARRAY(0x48051e8), HASH(0x392be28), HASH(0x4724df8)) called
at /home/netdisco2/perl5/lib/perl5/DBIx/Class/Storage/DBI.pm line 2566
DBIx::Class::Storage::DBI::select_single(DBIx::Class::Storage::DBI::Pg=HASH(0x36912c8),
ARRAY(0x48050f8), ARRAY(0x48051e8), HASH(0x392be28), HASH(0x4724df8)) called
at /home/netdisco2/perl5/lib/perl5/DBIx/Class/ResultSet.pm line 1099
DBIx::Class::ResultSet::single(App::Netdisco::DB::ResultSet=HASH(0x4724e40))
called at /home/netdisco2/perl5/lib/perl5/DBIx/Class/ResultSet.pm line 910
DBIx::Class::ResultSet::find(App::Netdisco::DB::ResultSet=HASH(0x43c8068),
"172.16.254.239", "172.16.254.239") called at
/home/netdisco2/perl5/lib/perl5/App/Netdisco/Util/Device.pm line 56
App::Netdisco::Util::Device::get_device("172.16.254.239") called at
bin/netdisco-do line 229
Ugrading to the latest using :
# upgrade Netdisco
~/bin/localenv cpanm --notest App::Netdisco
ln -sf ~/perl5/bin/{localenv,netdisco-*} ~/bin/
# apply database schema updates, update MIBs and Vendor MACs
~/bin/netdisco-deploy
# restart web service (if you run it)
~/bin/netdisco-web restart
# stop old daemon and start new backend worker (wherever you run them)
~/bin/netdisco-daemon stop
~/bin/netdisco-backend restart
Completed without errors, and the web interface seems to be working fine.
Any pointers if this is actually an issue to correct, and on where to start
looking?
All the best
Dan
--- End Message ---
--- Begin Message ---
On Fri, Jun 30, 2017 at 7:06 PM, Daniel Bird <[email protected]> wrote:
> Any pointers if this is actually an issue to correct, and on where to
> start looking?
>
I haven't upgraded Netdisco2 for some months. Upgrading today to
App-Netdisco-2.036003 (upgraded from 2.033004). The upgrade works, but:
netdisco@netmon2:~$ ~/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 the above in place? [y/N]: y
Would you like to deploy the database schema? [y/N]: y
DBIx::Class::Storage::DBI::sql_maker(): Your storage class
(DBIx::Class::Storage::DBI::Pg) does not set sql_limit_dialect and you have
not supplied an explicit limit_dialect in your connection_info. DBIC will
attempt to use the GenericSubQ dialect, which works on most databases but
can be (and often is) painfully slow. Please file an RT ticket against
'DBIx::Class::Storage::DBI::Pg' at
/home/netdisco/perl5/lib/perl5/DBICx/Sugar.pm line 85
DBIx::Class::Schema::Versioned::_on_connect(): Your DB is currently
unversioned. Please call upgrade on your schema to sync the DB. at
/home/netdisco/perl5/lib/perl5/DBICx/Sugar.pm line 85
DBIx::Class::Storage::DBI::deployment_statements(): Unable to produce
deployment statements: translate: Error with producer
'SQL::Translator::Producer': Undefined subroutine
&SQL::Translator::Producer::Pg called at /usr/share/perl5/SQL/Translator.pm
line 387. at /home/netdisco/perl5/bin/netdisco-db-deploy line 106
DB schema update complete.
DBIx::Class::Storage::DBI::sql_maker(): Your storage class
(DBIx::Class::Storage::DBI::Pg) does not set sql_limit_dialect and you have
not supplied an explicit limit_dialect in your connection_info. DBIC will
attempt to use the GenericSubQ dialect, which works on most databases but
can be (and often is) painfully slow. Please file an RT ticket against
'DBIx::Class::Storage::DBI::Pg' at
/home/netdisco/perl5/lib/perl5/DBICx/Sugar.pm line 85
DBIx::Class::Schema::Versioned::_on_connect(): Your DB is currently
unversioned. Please call upgrade on your schema to sync the DB. at
/home/netdisco/perl5/lib/perl5/DBICx/Sugar.pm line 85
DBIx::Class::Storage::DBI::sql_maker(): Your storage class
(DBIx::Class::Storage::DBI::Pg) does not set sql_limit_dialect and you have
not supplied an explicit limit_dialect in your connection_info. DBIC will
attempt to use the GenericSubQ dialect, which works on most databases but
can be (and often is) painfully slow. Please file an RT ticket against
'DBIx::Class::Storage::DBI::Pg' at /home/netdisco/bin/netdisco-deploy line
162
Download and update vendor MAC prefixes (OUI data)? [y/N]: y
DBIx::Class::Storage::svp_begin(): Your Storage implementation doesn't
support savepoints at /home/netdisco/bin/netdisco-deploy line 223
netdisco@netmon2:~$
--
Sanjeev Gupta
+65 98551208 http://sg.linkedin.com/in/ghane
--- 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
