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: UnVersioned database issue (Oliver Gorwits)
2. Re: UnVersioned database issue (Oliver Gorwits)
--- Begin Message ---
Hi Daniel
On 2017-06-30 12:06, Daniel Bird wrote:
We've noticed we're sometimes not seeing MAC addresses appear in our
Netdisco2 install, and I've just seen this
Do you mean they appear then disappear, or that they have never appeared
in the first place?
[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
This can happen if the Netdisco environment is not correctly
bootstrapping, so your configuration is not found, and Netdisco isn't
connecting to the correct database. I'm not sure whether it has anything
to do with your missing MAC addresses.
If you have this error all the time when running bin/netdisco*, and can
live with a few minutes of downtime, then a clean reinstall can be
achieved as follows (will not change database or config, only the app
software itself):
1. stop all Netdisco processes (double check the process table, kill
daemons and delete PID files)
2. move the ~netdisco/perl5 directory out of the way
3. follow the install instructions online ("curl ....")
4. follow the upgrade instructions online
Do let us know how you get on,
regards,
oliver.
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
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users
--- End Message ---
--- Begin Message ---
Hi Sanjeev,
I suggest you follow the four step reinstall of the software as I just
put in a reply to Daniel. This will not affect your database or your
site configuration files, as it only reinstalls the app software:
1. stop all Netdisco processes (double check the process table, kill
daemons and delete PID files)
2. move the ~netdisco/perl5 directory out of the way
3. follow the install instructions online ("curl ....")
4. follow the upgrade instructions online
My guess is that your upgrade somehow aborted or did not work fully.
regards,
oliver.
On 2017-06-30 19:08, Sanjeev Gupta wrote:
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 [1]
Links:
------
[1] http://sg.linkedin.com/in/ghane
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users
--- 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
