Send Netdot-users mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://osl.uoregon.edu/mailman/listinfo/netdot-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 Netdot-users digest..."
Today's Topics:
1. problems after SNMP discovery of a device (Heidrich Attila)
----------------------------------------------------------------------
Message: 1
Date: Wed, 14 Nov 2012 18:17:26 +0000
From: Heidrich Attila <[email protected]>
Subject: [Netdot-users] problems after SNMP discovery of a device
To: "[email protected]" <[email protected]>
Message-ID:
<[email protected]>
Content-Type: text/plain; charset="iso-8859-2"
Dear All,
I use 1.0.2...
I have installed the netdisco MIs, and succesfully discovered the first C7609,
but I have two problems at the moment:
Wen I click on the device name in the dev-list, I got this:
System error
error: Netdot::Model::FWTable can't SELECT id, tstamp, device
FROM fwtable
WHERE device = ? ORDER BY tstamp DESC
: DBD::mysql::st execute failed: Table 'netdot.fwtable' doesn't exist [for
Statement "SELECT id, tstamp, device
FROM fwtable
WHERE device = ? ORDER BY tstamp DESC
" with ParamValues: 0='1'] at
/usr/lib/perl5/site_perl/5.8.8/DBIx/ContextualFetch.pm line 52.
Stack:
[/usr/lib/perl5/site_perl/5.8.8/DBIx/ContextualFetch.pm:52]
[/usr/lib/perl5/site_perl/5.8.8/DBIx/ContextualFetch.pm:32]
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI.pm:1139]
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI/Search/Basic.pm:169]
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI.pm:1094]
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI/Relationship/HasMany.pm:144]
[/usr/local/netdot/htdocs/management/device.html:292]
[/usr/local/netdot/htdocs/management/autohandler:81]
[/usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:930]
[/usr/local/netdot/htdocs/masondata/obj/1249693838/management/autohandler.obj:21]
[/usr/local/netdot/htdocs/autohandler:76]
at /usr/lib/perl5/site_perl/5.8.8/Class/DBI/Search/Basic.pm line 169
context:
...
265: # whether they should generate a full stack trace (confess() and
cluck())
266: # or simply report the caller's package (croak() and carp()),
respectively.
267: # confess() and croak() die, carp() and cluck() warn.
268:
269: sub croak { die shortmess @_ }
270: sub confess { die longmess @_ }
271: sub carp { warn shortmess @_ }
272: sub cluck { warn longmess @_ }
273:
...
code stack: /usr/lib/perl5/5.8.8/Carp.pm:269
/usr/lib/perl5/site_perl/5.8.8/Class/DBI.pm:169
/usr/lib/perl5/site_perl/5.8.8/Class/DBI.pm:1143
/usr/lib/perl5/site_perl/5.8.8/Class/DBI/Search/Basic.pm:169
/usr/lib/perl5/site_perl/5.8.8/Class/DBI.pm:1094
/usr/lib/perl5/site_perl/5.8.8/Class/DBI/Relationship/HasMany.pm:144
/usr/local/netdot/htdocs/management/device.html:292
/usr/local/netdot/htdocs/management/autohandler:81
/usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:930
/usr/local/netdot/htdocs/masondata/obj/1249693838/management/autohandler.obj:21
/usr/local/netdot/htdocs/autohandler:76
raw
error<http://ipregister.servers.intra/netdot/management/device.html?table=Device&id=1#raw>
Netdot::Model::FWTable can't SELECT id, tstamp, device
FROM fwtable
WHERE device = ? ORDER BY tstamp DESC
: DBD::mysql::st execute failed: Table 'netdot.fwtable' doesn't exist [for
Statement "SELECT id, tstamp, device
FROM fwtable
WHERE device = ? ORDER BY tstamp DESC
" with ParamValues: 0='1'] at
/usr/lib/perl5/site_perl/5.8.8/DBIx/ContextualFetch.pm line 52.
Stack:
[/usr/lib/perl5/site_perl/5.8.8/DBIx/ContextualFetch.pm:52]
[/usr/lib/perl5/site_perl/5.8.8/DBIx/ContextualFetch.pm:32]
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI.pm:1139]
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI/Search/Basic.pm:169]
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI.pm:1094]
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI/Relationship/HasMany.pm:144]
[/usr/local/netdot/htdocs/management/device.html:292]
[/usr/local/netdot/htdocs/management/autohandler:81]
[/usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:930]
[/usr/local/netdot/htdocs/masondata/obj/1249693838/management/autohandler.obj:21]
[/usr/local/netdot/htdocs/autohandler:76]
at /usr/lib/perl5/site_perl/5.8.8/Class/DBI/Search/Basic.pm line 169
Trace begun at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Exceptions.pm line
129
HTML::Mason::Exceptions::rethrow_exception('Netdot::Model::FWTable can\'t
SELECT id, tstamp, device^JFROM fwtable^JWHERE device = ? ORDER BY tstamp
DESC^J: DBD::mysql::st execute failed: Table \'netdot.fwtable\' doesn\'t exist
[for Statement "SELECT id, tstamp, device^JFROM fwtable^JWHERE device = ?
ORDER BY tstamp DESC^J" with ParamValues: 0=\'1\'] at
/usr/lib/perl5/site_perl/5.8.8/DBIx/ContextualFetch.pm line 52.^J^JStack:^J
[/usr/lib/perl5/site_perl/5.8.8/DBIx/ContextualFetch.pm:52]^J
[/usr/lib/perl5/site_perl/5.8.8/DBIx/ContextualFetch.pm:32]^J
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI.pm:1139]^J
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI/Search/Basic.pm:169]^J
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI.pm:1094]^J
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI/Relationship/HasMany.pm:144]^J
[/usr/local/netdot/htdocs/management/device.html:292]^J
[/usr/local/netdot/htdocs/management/autohandler:81]^J
[/usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:930]^J !
[/usr/local/netdot/htdocs/masondata/obj/1249693838/management/autohandler.obj:21]^J
[/usr/local/netdot/htdocs/autohandler:76]^J at
/usr/lib/perl5/site_perl/5.8.8/Class/DBI/Search/Basic.pm line 169^J') called at
/usr/lib/perl5/5.8.8/Carp.pm line 269
Carp::croak('Netdot::Model::FWTable can\'t SELECT id, tstamp, device^JFROM
fwtable^JWHERE device = ? ORDER BY tstamp DESC^J: DBD::mysql::st execute
failed: Table \'netdot.fwtable\' doesn\'t exist [for Statement "SELECT id,
tstamp, device^JFROM fwtable^JWHERE device = ? ORDER BY tstamp DESC^J" with
ParamValues: 0=\'1\'] at /usr/lib/perl5/site_perl/5.8.8/DBIx/ContextualFetch.pm
line 52.^J^JStack:^J
[/usr/lib/perl5/site_perl/5.8.8/DBIx/ContextualFetch.pm:52]^J
[/usr/lib/perl5/site_perl/5.8.8/DBIx/ContextualFetch.pm:32]^J
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI.pm:1139]^J
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI/Search/Basic.pm:169]^J
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI.pm:1094]^J
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI/Relationship/HasMany.pm:144]^J
[/usr/local/netdot/htdocs/management/device.html:292]^J
[/usr/local/netdot/htdocs/management/autohandler:81]^J
[/usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:930]^J
[/usr/local/netdot/htdocs/mason!
data/obj/1249693838/management/autohandler.obj:21]^J
[/usr/local/netdot/htdocs/autohandler:76]^J') called at
/usr/lib/perl5/site_perl/5.8.8/Class/DBI.pm line 169
Class::DBI::_croak('Netdot::Model::FWTable', 'Netdot::Model::FWTable can\'t
SELECT id, tstamp, device^JFROM fwtable^JWHERE device = ? ORDER BY tstamp
DESC^J: DBD::mysql::st execute failed: Table \'netdot.fwtable\' doesn\'t exist
[for Statement "SELECT id, tstamp, device^JFROM fwtable^JWHERE device = ?
ORDER BY tstamp DESC^J" with ParamValues: 0=\'1\'] at
/usr/lib/perl5/site_perl/5.8.8/DBIx/ContextualFetch.pm line 52.^J^JStack:^J
[/usr/lib/perl5/site_perl/5.8.8/DBIx/ContextualFetch.pm:52]^J
[/usr/lib/perl5/site_perl/5.8.8/DBIx/ContextualFetch.pm:32]^J
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI.pm:1139]^J
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI/Search/Basic.pm:169]^J
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI.pm:1094]^J
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI/Relationship/HasMany.pm:144]^J
[/usr/local/netdot/htdocs/management/device.html:292]^J
[/usr/local/netdot/htdocs/management/autohandler:81]^J
[/usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:930]^J!
[/usr/local/netdot/htdocs/masondata/obj/1249693838/management/autohandler.obj:21]^J
[/usr/local/netdot/htdocs/autohandler:76]^J', 'err',
'HTML::Mason::Exception=HASH(0xb4f6b9c)') called at
/usr/lib/perl5/site_perl/5.8.8/Class/DBI.pm line 1143
Class::DBI::sth_to_objects('Netdot::Model::FWTable',
'DBIx::ContextualFetch::st=HASH(0xb52cd00)', 'ARRAY(0xb3f9ccc)') called at
/usr/lib/perl5/site_perl/5.8.8/Class/DBI/Search/Basic.pm line 169
Class::DBI::Search::Basic::run_search('Class::DBI::Search::Basic=HASH(0xb562244)')
called at /usr/lib/perl5/site_perl/5.8.8/Class/DBI.pm line 1094
Class::DBI::__ANON__('Netdot::Model::FWTable', 'device', 1, 'HASH(0xb3bbc38)')
called at /usr/lib/perl5/site_perl/5.8.8/Class/DBI/Relationship/HasMany.pm line
144
Class::DBI::Relationship::HasMany::__ANON__('Device=HASH(0xb54fbc8)') called at
/usr/local/netdot/htdocs/management/device.html line 292
HTML::Mason::Commands::__ANON__('table', 'Device', 'id', 1, 'showheader', 1,
'page', 'DEVICE') called at
/usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb4f6800)',
'table', 'Device', 'id', 1, 'showheader', 1, 'page', 'DEVICE') called at
/usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm line 1278
eval {...} at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm line 1268
HTML::Mason::Request::comp(undef, undef, undef, 'table', 'Device', 'id', 1,
'showheader', 1, 'page', 'DEVICE') called at
/usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm line 937
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0xb5dd12c)',
'page', 'DEVICE') called at /usr/local/netdot/htdocs/management/autohandler
line 81
HTML::Mason::Commands::__ANON__('table', 'Device', 'id', 1, 'showheader', 1)
called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Component.pm line 157
HTML::Mason::Component::run_dynamic_sub('HTML::Mason::Component::FileBased=HASH(0x8eefca0)',
'main', 'table', 'Device', 'id', 1, 'showheader', 1) called at
/usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm line 930
HTML::Mason::Request::call_dynamic('HTML::Mason::Request::ApacheHandler=HASH(0xb5dd12c)',
'main', 'table', 'Device', 'id', 1, 'showheader', 1) called at
/usr/local/netdot/htdocs/masondata/obj/1249693838/management/autohandler.obj
line 21
HTML::Mason::Commands::__ANON__('table', 'Device', 'id', 1, 'showheader', 1)
called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x8eefca0)',
'table', 'Device', 'id', 1, 'showheader', 1) called at
/usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm line 1278
eval {...} at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm line 1268
HTML::Mason::Request::comp(undef, undef, undef, 'table', 'Device', 'id', 1,
'showheader', 1) called at
/usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm line 937
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0xb5dd12c)',
'showheader', 1) called at /usr/local/netdot/htdocs/autohandler line 76
HTML::Mason::Commands::__ANON__('table', 'Device', 'id', 1) called at
/usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb3392a4)',
'table', 'Device', 'id', 1) called at
/usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm line 1273
eval {...} at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm line 1268
HTML::Mason::Request::comp(undef, undef, undef, 'table', 'Device', 'id', 1)
called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm line 467
eval {...} at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm line 467
eval {...} at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm line 419
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0xb5dd12c)')
called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/ApacheHandler.pm line 168
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0xb5dd12c)')
called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/ApacheHandler.pm line 825
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x8a6863c)',
'Apache2::RequestRec=SCALAR(0xb52d144)') called at
/usr/local/netdot/lib/Netdot/Mason.pm line 59
Netdot::Mason::handler('Apache2::RequestRec=SCALAR(0xb52d144)') called at -e
line 0
eval {...} at -e line 0
I have also added another device, which have not ever been discovered. When I
try to delete this device, I got this:
delete.html produced the following error:
Transaction aborted: Netdot::Model::FWTable can't SELECT id, tstamp, device
FROM fwtable
WHERE device = ?
: DBD::mysql::st execute failed: Table 'netdot.fwtable' doesn't exist [for
Statement "SELECT id, tstamp, device
FROM fwtable
WHERE device = ?
" with ParamValues: 0='2'] at
/usr/lib/perl5/site_perl/5.8.8/DBIx/ContextualFetch.pm line 52, line 4.
Stack:
[/usr/lib/perl5/site_perl/5.8.8/DBIx/ContextualFetch.pm:52]
[/usr/lib/perl5/site_perl/5.8.8/DBIx/ContextualFetch.pm:32]
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI.pm:1139]
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI/Search/Basic.pm:169]
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI.pm:1094]
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI/Cascade/None.pm:68]
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI/Cascade/Delete.pm:21]
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI/Relationship/HasMany.pm:75]
[/usr/lib/perl5/site_perl/5.8.8/Class/Trigger.pm:74]
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI.pm:735]
[/usr/local/netdot/lib/Netdot/Model.pm:876]
[/usr/local/netdot/lib/Netdot/Model/Device.pm:2363]
[/usr/local/netdot/htdocs/generic/delete.html:161]
[/usr/local/netdot/htdocs/generic/delete.html:163]
[/usr/local/netdot/htdocs/autohandler:110]
[/usr/local/netdot/htdocs/management/dhandler:1]
[/usr/local/netdot/htdocs/management/autohandler:81]
[/usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:930]
[/usr/local/netdot/htdocs/masondata/obj/1249693838/management/autohandler.obj:21]
[/usr/local/netdot/htdocs/autohandler:76]
at /usr/lib/perl5/site_perl/5.8.8/Class/DBI/Search/Basic.pm line 169
Stack:
[/usr/lib/perl5/5.8.8/Carp.pm:269]
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI.pm:169]
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI.pm:1143]
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI/Search/Basic.pm:169]
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI.pm:1094]
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI/Cascade/None.pm:68]
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI/Cascade/Delete.pm:21]
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI/Relationship/HasMany.pm:75]
[/usr/lib/perl5/site_perl/5.8.8/Class/Trigger.pm:74]
[/usr/lib/perl5/site_perl/5.8.8/Class/DBI.pm:735]
[/usr/local/netdot/lib/Netdot/Model.pm:876]
[/usr/local/netdot/lib/Netdot/Model/Device.pm:2363]
[/usr/local/netdot/htdocs/generic/delete.html:161]
[/usr/local/netdot/htdocs/generic/delete.html:163]
[/usr/local/netdot/htdocs/autohandler:110]
[/usr/local/netdot/htdocs/management/dhandler:1]
[/usr/local/netdot/htdocs/management/autohandler:81]
[/usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:930]
[/usr/local/netdot/htdocs/masondata/obj/1249693838/management/autohandler.obj:21]
[/usr/local/netdot/htdocs/autohandler:76]
Please go back and try again.
--------------
Ezen uzenet kizarolag a cimzettjenek szol es olyan bizalmas jellegu
informaciokat tartalmazhat, amelyek feltarasat jogszabaly vagy szerzodes
tiltja. Amennyiben a jelen uzenetet On teves kezbesites folytan kapta,
kerjuk haladektalanul ertesitsen bennunket es az uzenetet annak
csatolmanyaival egyutt torolje. Amennyiben On nem cimzettje a jelen
uzenetnek, annak es mellekleteinek elolvasasa, masolasa, tovabbitasa, vagy
barmely celbol torteno felhasznalasa szigoruan tilos. Megjegyezzuk, hogy az
e-mail utjan torteno kozlesek nem garantaljak az elkuldott uzenetek
bizalmas jellegenek es teljessegenek megorzeset, valamint az uzenetek
megfelelo kezbesiteset. A fentieken tulmenoen, az Invitel Zrt.,
annak kapcsolt vallalkozasai, illetve az altaluk megbizott
harmadik felek a jelen e-mail cimrol kuldott, vagy arra erkezo barmely
uzenetet ellenorizhetnek, lemasolhatnak, felhasznalhatnak vagy harmadik fel
reszere tovabbithatnak.
This message is
intended exclusively for its addressee and may contain
confidential information protected from disclosure by law or contract. If
you have received this message in error, please immediately notify us and
delete it together with its attachments. If you are not an addressee of
this message, reading, copying, distribution or use for any purpose of the
contents of this message or its attachments is strictly forbidden.
Additionally, please note that communication by email guarantees neither
the confidentiality nor the completeness or proper receipt of the messages
sent. Furthermore, Invitel Zrt., its affiliates and
third parties retained by them may monitor, copy, use or forward to third
parties any outgoing messages from and incoming messages to this email
address.
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20121114/ee03f31c/attachment.html
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 48, Issue 9
*******************************************
