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. Re: Asset Search Error (Carlos Vicente)
2. Re: IP Address field editable? (Carlos Vicente)
3. Re: bug in SNMP::Info::CiscoStpExtensions (Carlos Vicente)
4. Re: Odd error Message (Carlos Vicente)
5. Re: Odd error Message (Michael T. Voity)
----------------------------------------------------------------------
Message: 1
Date: Tue, 27 Nov 2012 15:16:04 -0500
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] Asset Search Error
To: Joe Goldberg <[email protected]>
Cc: netdot-users <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=windows-1252
Hello Joe,
That is a bug. One of the search fields should not be in the list.
In case you want to try patching, the diff is here:
https://osl.uoregon.edu/redmine/projects/netdot/repository/revisions/19a80b6f12e4b6cd0b992110d479f084a114a974/diff/htdocs/management/asset_tasks.html
This will be included in the next release (1.0.3)
Thank you.
cv
On 11/8/12 3:22 PM, Joe Goldberg wrote:
> I just installed version 1.0.2 (fresh install) and imported some
> devices. Everything seems to be working perfectly except one thing. I
> am using a Postgres DB
>
>
>
> I can?t an Asset Search (Management ? Assets ? Search. I get the error
> below:
>
>
>
> Any insight you may have, I would appreciate.
>
>
>
> Asset can't SELECT id, serial_number, product_id, inventory_number,
> physaddr, reserved_for, maint_from, maint_until
>
> FROM asset
>
> WHERE ( ( custom_serial LIKE ? OR inventory_number LIKE ? OR
> reserved_for LIKE ? OR description LIKE ? OR info LIKE ? OR po_number
> LIKE ? OR maint_contract LIKE ? ) )
>
> : DBD::Pg::st execute failed: ERROR: operator does not exist: bigint ~~
> unknown
>
> LINE 3: ...fo LIKE $5 OR po_number LIKE $6 OR maint_contract LIKE $7 ) ...
>
> ^
>
> HINT: No operator matches the given name and argument type(s). You
> might need to add explicit type casts. [for Statement "SELECT id,
> serial_number, product_id, inventory_number, physaddr, reserved_for,
> maint_from, maint_until
>
> FROM asset
>
> WHERE ( ( custom_serial LIKE ? OR inventory_number LIKE ? OR
> reserved_for LIKE ? OR description LIKE ? OR info LIKE ? OR po_number
> LIKE ? OR maint_contract LIKE ? ) )
>
> " with ParamValues: 1='%falc%', 2='%falc%', 3='%falc%', 4='%falc%',
> 5='%falc%', 6='%falc%', 7='%falc%'] at
> /usr/share/perl5/DBIx/ContextualFetch.pm line 52.
>
>
>
> Stack:
>
> [/usr/share/perl5/DBIx/ContextualFetch.pm:52]
>
> [/usr/share/perl5/DBIx/ContextualFetch.pm:32]
>
> [/usr/share/perl5/Class/DBI.pm:1139]
>
> [/usr/share/perl5/Class/DBI.pm:1083]
>
> [/usr/share/perl5/Class/DBI/AbstractSearch.pm:33]
>
> [/usr/local/netdot/htdocs/management/asset_tasks.html:243]
>
> [/usr/local/netdot/htdocs/management/autohandler:81]
>
> [/usr/share/perl5/HTML/Mason/Request.pm:936]
>
>
> [/usr/local/netdot/htdocs/masondata/obj/991023240/management/autohandler.obj:21]
>
> [/usr/local/netdot/htdocs/autohandler:76]
>
> at /usr/share/perl5/Class/DBI/AbstractSearch.pm line 33
>
>
>
>
>
> Trace begun at /usr/share/perl5/HTML/Mason/Exceptions.pm line 129
>
> HTML::Mason::Exceptions::rethrow_exception('Asset can\'t SELECT id,
> serial_number, product_id, inventory_number, physaddr, reserved_for,
> maint_from, maint_until^JFROM asset^JWHERE ( ( custom_serial LIKE ?
> OR inventory_number LIKE ? OR reserved_for LIKE ? OR description LIKE ?
> OR info LIKE ? OR po_number LIKE ? OR maint_contract LIKE ? ) )^J:
> DBD::Pg::st execute failed: ERROR: operator does not exist: bigint ~~
> unknown^JLINE 3: ...fo LIKE $5 OR po_number LIKE $6 OR maint_contract
> LIKE $7 ) ...^J
> ^^JHINT: No
> operator matches the given name and argument type(s). You might need to
> add explicit type casts. [for Statement "SELECT id, serial_number,
> product_id, inventory_number, physaddr, reserved_for, maint_from,
> maint_until^JFROM asset^JWHERE ( ( custom_serial LIKE ? OR
> inventory_number LIKE ? OR reserved_for LIKE ? OR description LIKE ? OR
> info LIKE ? OR po_number LIKE ? OR maint_contract LIKE ? ) )^J" with
> ParamValues: 1=\'%falc%\', 2=\'%falc%\', 3=\'%falc%\', 4=\'%falc%\',
> 5=\'%falc%\', 6=\'%falc%\', 7=\'%falc%\'] at
> /usr/share/perl5/DBIx/ContextualFetch.pm line 52.^J^JStack:^J
> [/usr/share/perl5/DBIx/ContextualFetch.pm:52]^J
> [/usr/share/perl5/DBIx/ContextualFetch.pm:32]^J
> [/usr/share/perl5/Class/DBI.pm:1139]^J
> [/usr/share/perl5/Class/DBI.pm:1083]^J
> [/usr/share/perl5/Class/DBI/AbstractSearch.pm:33]^J
> [/usr/local/netdot/htdocs/management/asset_tasks.html:243]^J
> [/usr/local/netdot/htdocs/management/autohandler:81]^J
> [/usr/share/perl5/HTML/Mason/Request.pm:936]^J
> [/usr/local/netdot/htdocs/masondata/obj/991023240/management/autohandler.obj:21]^J
>
> [/usr/local/netdot/htdocs/autohandler:76]^J at
> /usr/share/perl5/Class/DBI/AbstractSearch.pm line 33^J') called at
> /usr/share/perl5/Carp.pm line 44
>
> Carp::croak('Asset can\'t SELECT id, serial_number, product_id,
> inventory_number, physaddr, reserved_for, maint_from,
> maint_until^JFROM asset^JWHERE ( ( custom_serial LIKE ? OR
> inventory_number LIKE ? OR reserved_for LIKE ? OR description LIKE ? OR
> info LIKE ? OR po_number LIKE ? OR maint_contract LIKE ? ) )^J:
> DBD::Pg::st execute failed: ERROR: operator does not exist: bigint ~~
> unknown^JLINE 3: ...fo LIKE $5 OR po_number LIKE $6 OR maint_contract
> LIKE $7 ) ...^J
> ^^JHINT: No operator matches the given name and
> argument type(s). You might need to add explicit type casts. [for
> Statement "SELECT id, serial_number, product_id, inventory_number,
> physaddr, reserved_for, maint_from, maint_until^JFROM asset^JWHERE (
> ( custom_serial LIKE ? OR inventory_number LIKE ? OR reserved_for LIKE ?
> OR description LIKE ? OR info LIKE ? OR po_number LIKE ? OR
> maint_contract LIKE ? ) )^J" with ParamValues: 1=\'%falc%\',
> 2=\'%falc%\', 3=\'%falc%\', 4=\'%falc%\', 5=\'%falc%\', 6=\'%falc%\',
> 7=\'%falc%\'] at /usr/share/perl5/DBIx/ContextualFetch.pm line
> 52.^J^JStack:^J [/usr/share/perl5/DBIx/ContextualFetch.pm:52]^J
> [/usr/share/perl5/DBIx/ContextualFetch.pm:32]^J
> [/usr/share/perl5/Class/DBI.pm:1139]^J
> [/usr/share/perl5/Class/DBI.pm:1083]^J
> [/usr/share/perl5/Class/DBI/AbstractSearch.pm:33]^J
> [/usr/local/netdot/htdocs/management/asset_tasks.html:243]^J
> [/usr/local/netdot/htdocs/management/autohandler:81]^J
> [/usr/share/perl5/HTML/Mason/Request.pm:936]^J
> [/usr/local/netdot/htdocs/masondata/obj/991023240/management/autohandler.obj:21]^J
>
> [/usr/local/netdot/htdocs/autohandler:76]^J') called at
> /usr/share/perl5/Class/DBI.pm line 169
>
> Class::DBI::_croak('Asset', 'Asset can\'t SELECT id, serial_number,
> product_id, inventory_number, physaddr, reserved_for, maint_from,
> maint_until^JFROM asset^JWHERE ( ( custom_serial LIKE ? OR
> inventory_number LIKE ? OR reserved_for LIKE ? OR description LIKE ? OR
> info LIKE ? OR po_number LIKE ? OR maint_contract LIKE ? ) )^J:
> DBD::Pg::st execute failed: ERROR: operator does not exist: bigint ~~
> unknown^JLINE 3: ...fo LIKE $5 OR po_number LIKE $6 OR maint_contract
> LIKE $7 )
> ...^J
> ^^JHINT: No operator matches the given name and argument type(s). You
> might need to add explicit type casts. [for Statement "SELECT id,
> serial_number, product_id, inventory_number, physaddr, reserved_for,
> maint_from, maint_until^JFROM asset^JWHERE ( ( custom_serial LIKE ?
> OR inventory_number LIKE ? OR reserved_for LIKE ? OR description LIKE ?
> OR info LIKE ? OR po_number LIKE ? OR maint_contract LIKE ? ) )^J" with
> ParamValues: 1=\'%falc%\', 2=\'%falc%\', 3=\'%falc%\', 4=\'%falc%\',
> 5=\'%falc%\', 6=\'%falc%\', 7=\'%falc%\'] at
> /usr/share/perl5/DBIx/ContextualFetch.pm line 52.^J^JStack:^J
> [/usr/share/perl5/DBIx/ContextualFetch.pm:52]^J
> [/usr/share/perl5/DBIx/ContextualFetch.pm:32]^J
> [/usr/share/perl5/Class/DBI.pm:1139]^J
> [/usr/share/perl5/Class/DBI.pm:1083]^J
> [/usr/share/perl5/Class/DBI/AbstractSearch.pm:33]^J
> [/usr/local/netdot/htdocs/management/asset_tasks.html:243]^J
> [/usr/local/netdot/htdocs/management/autohandler:81]^J
> [/usr/share/perl5/HTML/Mason/Request.pm:936]^J
> [/usr/local/netdot/htdocs/masondata/obj/991023240/management/autohandler.obj:21]^J
>
> [/usr/local/netdot/htdocs/autohandler:76]^J', 'err',
> 'HTML::Mason::Exception=HASH(0x7f8b68789cf8)') called at
> /usr/share/perl5/Class/DBI.pm line 1143
>
> Class::DBI::sth_to_objects('Asset',
> 'DBIx::ContextualFetch::st=HASH(0x7f8b68531e88)',
> 'ARRAY(0x7f8b658590b0)') called at /usr/share/perl5/Class/DBI.pm line 1083
>
> Class::DBI::retrieve_from_sql('Asset', '( ( custom_serial LIKE ? OR
> inventory_number LIKE ? OR reserved_for LIKE ? OR description LIKE ? OR
> info LIKE ? OR po_number LIKE ? OR maint_contract LIKE ? ) )', '%falc%',
> '%falc%', '%falc%', '%falc%', '%falc%', '%falc%', '%falc%') called at
> /usr/share/perl5/Class/DBI/AbstractSearch.pm line 33
>
> Class::DBI::AbstractSearch::search_where('Asset',
> 'ARRAY(0x7f8b684e4820)') called at
> /usr/local/netdot/htdocs/management/asset_tasks.html line 243
>
> HTML::Mason::Commands::__ANON__('search', 'falc', 'submit', 'Search',
> 'search_type', 'all', 'showheader', 1, 'page', 'ASSETS') called at
> /usr/share/perl5/HTML/Mason/Component.pm line 135
>
> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f8b684d6ba0)',
> 'search', 'falc', 'submit', 'Search', 'search_type', 'all',
> 'showheader', 1, 'page', 'ASSETS') called at
> /usr/share/perl5/HTML/Mason/Request.pm line 1284
>
> eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1274
>
> HTML::Mason::Request::comp(undef, undef, undef, 'search', 'falc',
> 'submit', 'Search', 'search_type', 'all', 'showheader', 1, 'page',
> 'ASSETS') called at /usr/share/perl5/HTML/Mason/Request.pm line 943
>
> HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x7f8b68520770)',
> 'page', 'ASSETS') called at
> /usr/local/netdot/htdocs/management/autohandler line 81
>
> HTML::Mason::Commands::__ANON__('search', 'falc', 'submit', 'Search',
> 'search_type', 'all', 'showheader', 1) called at
> /usr/share/perl5/HTML/Mason/Component.pm line 157
>
> HTML::Mason::Component::run_dynamic_sub('HTML::Mason::Component::FileBased=HASH(0x7f8b680f4bd0)',
> 'main', 'search', 'falc', 'submit', 'Search', 'search_type', 'all',
> 'showheader', 1) called at /usr/share/perl5/HTML/Mason/Request.pm line 936
>
> HTML::Mason::Request::call_dynamic('HTML::Mason::Request::ApacheHandler=HASH(0x7f8b68520770)',
> 'main', 'search', 'falc', 'submit', 'Search', 'search_type', 'all',
> 'showheader', 1) called at
> /usr/local/netdot/htdocs/masondata/obj/991023240/management/autohandler.obj
> line 21
>
> HTML::Mason::Commands::__ANON__('search', 'falc', 'submit', 'Search',
> 'search_type', 'all', 'showheader', 1) called at
> /usr/share/perl5/HTML/Mason/Component.pm line 135
>
> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f8b680f4bd0)',
> 'search', 'falc', 'submit', 'Search', 'search_type', 'all',
> 'showheader', 1) called at /usr/share/perl5/HTML/Mason/Request.pm line 1284
>
> eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1274
>
> HTML::Mason::Request::comp(undef, undef, undef, 'search', 'falc',
> 'submit', 'Search', 'search_type', 'all', 'showheader', 1) called at
> /usr/share/perl5/HTML/Mason/Request.pm line 943
>
> HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x7f8b68520770)',
> 'showheader', 1) called at /usr/local/netdot/htdocs/autohandler line 76
>
> HTML::Mason::Commands::__ANON__('search', 'falc', 'submit', 'Search',
> 'search_type', 'all') called at /usr/share/perl5/HTML/Mason/Component.pm
> line 135
>
> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f8b681127e8)',
> 'search', 'falc', 'submit', 'Search', 'search_type', 'all') called at
> /usr/share/perl5/HTML/Mason/Request.pm line 1279
>
> eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1274
>
> HTML::Mason::Request::comp(undef, undef, undef, 'search', 'falc',
> 'submit', 'Search', 'search_type', 'all') called at
> /usr/share/perl5/HTML/Mason/Request.pm line 473
>
> eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 473
>
> eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 425
>
> HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x7f8b68520770)')
> called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 168
>
> HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x7f8b68520770)')
> called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 825
>
> HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x7f8b680a95a0)',
> 'Apache2::RequestRec=SCALAR(0x7f8b683f0d10)') called at
> /usr/local/netdot/lib/Netdot/Mason.pm line 59
>
> Netdot::Mason::handler('Apache2::RequestRec=SCALAR(0x7f8b683f0d10)')
> called at -e line 0
>
> eval {...} at -e line 0
>
>
>
>
>
> Thanks,
>
> Joe
>
>
>
>
>
>
>
> *Joe Goldberg*
>
> *Director, Hosted Services*
>
> FalconStor Software (NASDAQ: FALC)
>
> 2 Huntington Quadrangle
>
> Melville, NY 11747
>
> Tel.: 631.773.5816
>
> Cell: 516.510.7383
>
>
>
> */Defining Data Protection, Again?/***
>
>
>
> *Follow us:*
>
> Description: Description: Description: Description: Blogger
> <http://www.falconstor.com/community/blogs>Description: Description:
> Description: Description: Twitter1-icon
> <http://twitter.com/FalconStor> Description: Description: Description:
> Description: linkedin-icon
> <http://www.linkedin.com/groups?mostPopular=&gid=776377> Description:
> Description: Description: Description: Youtube-icon
> <http://www.youtube.com/user/FalconStor> Description: Description:
> Description: Description: Flickr-icon1
> <http://www.flickr.com/photos/falconstor/>
>
>
>
> Description: Description: Description: Description: Please consider the
> environment before printing this email.
>
> /This email and any attachment(s) is for the intended recipient only and
> may be confidential. If you are not the intended recipient, please
> delete this e-mail and advise the sender immediately. //Unauthorized use
> or distribution is prohibited./
>
>
>
>
>
> _______________________________________________
> Netdot-users mailing list
> [email protected]
> https://osl.uoregon.edu/mailman/listinfo/netdot-users
>
--
cv
------------------------------
Message: 2
Date: Tue, 27 Nov 2012 15:18:07 -0500
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] IP Address field editable?
To: Vincent Magnin <[email protected]>
Cc: "[email protected]" <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1
Hi Vincent,
On 11/9/12 3:52 AM, Vincent Magnin wrote:
> Dear List,
>
> On latest Netdot-0.9 and Nedot-1.0 (latest git version), why IP
> Address field is editable on management/ip.html page?
>
That is a good point. I can't imagine a situation in which you would
want to change the address of an IP object. I've never had to myself.
I will probably remove that option, unless someone gives me a good
reason not to.
Regards,
--
cv
------------------------------
Message: 3
Date: Tue, 27 Nov 2012 15:21:20 -0500
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] bug in SNMP::Info::CiscoStpExtensions
To: Wim Vandersmissen <[email protected]>
Cc: [email protected],
[email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1
Hi Wim,
It would make more sense to reverse the order of the checks (check for
defined, then for value unknown).
I can probably make that change (seems pretty harmless) unless anyone in
the SNMP::Info list objects.
Thx,
cv
On 11/9/12 6:54 PM, Wim Vandersmissen wrote:
> Hi,
>
> (crosspost to netdot-users (I can't be the only one using c2960's?))
>
> First time user of SNMP::Info (needed because of recent netdot installation)
>
> I think I found a bug in detecting STP on some cisco devices
> (c2960/c4900M running 15.x or 12.2(50)+)
>
> Output of running $info->stp_ver() on line 16
> SNMP::Info::_global(stp_ver) NOSUCHINSTANCE at s.pl line 16
>
> Seems like that oid doesn't exist anymore.
>
> Quick fix below (works for me)
>
> --Wim
>
> --- snmp/SNMP-Info-2.08/Info/CiscoStpExtensions.pm
> +++ /usr/lib/perl5/vendor_perl/5.8.8/SNMP/Info/CiscoStpExtensions.pm
> @@ -75,7 +75,7 @@ $VERSION = '2.08';
> sub stp_ver {
> my $self = shift;
> my $stp_ver = $self->SUPER::stp_ver();
> - if ( $stp_ver eq 'unknown' ){
> + if ( ( $stp_ver eq 'unknown' ) || !defined($stp_ver)){
> if ( defined $self->stpx_stp_type() ){
> $stp_ver = $self->stpx_stp_type();
> }
>
>
>
>
> Whole test output/script below
> ---
> SNMP::Info::_global layers : sysServices.0
> SNMP::Info::_global description : sysDescr.0
> SNMP::Info::_global id : sysObjectID.0
> SNMP::Info 2.06
> SNMP::Info::device_type() layers:00000110 id:9 sysDescr:"Cisco IOS
> Software, C2960 Software (C2960-LANBASEK9-M), Version 15.0(2)SE, RELEASE
> SOFTWARE (fc1) Technical Support: http://www.cisco.com/techsupport
> Copyright (c) 1986-2012 by Cisco Systems, Inc. Compiled Sat 28-Jul-12
> 00:29 by prod_rel_team"
> SNMP::Info::specify() - Changed Class to SNMP::Info::Layer3::C6500.
> SNMP::Info::_global name : sysName.0
> SNMP::Info::_global stp_ver : dot1dStpProtocolSpecification.0
> SNMP::Info::_global(stp_ver) NOSUCHINSTANCE at s.pl line 16
>
>
> use SNMP::Info;
>
> my $info = new SNMP::Info(
> # Auto Discover more specific Device Class
> AutoSpecify => 1,
> Debug => 1,
> # The rest is passed to SNMP::Session
> DestHost => '1.2.3.4',
> Community => 'public',
> Version => 2
> ) or die "Can't connect to device.\n";
>
> my $err = $info->error();
> $name = $info->name();
> $class = $info->class();
> print $info->stp_ver();
>
> _______________________________________________
> Netdot-users mailing list
> [email protected]
> https://osl.uoregon.edu/mailman/listinfo/netdot-users
>
------------------------------
Message: 4
Date: Tue, 27 Nov 2012 15:42:52 -0500
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] Odd error Message
To: "Michael T. Voity" <[email protected]>
Cc: "[email protected]" <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1
Hi Michael,
The error says that the table does not exist. That should definitely not
happen :-)
This table is rotated periodically (prune_db in cron job), so maybe this
process failed to complete, and left and incomplete DB.
Which version of Netdot is this?
You can find the table definition in the schema file (etc/schema.mysql)
inside the source tree. If you don't have the file, you can always
generate it with:
$ make genschema
On 11/26/12 7:37 PM, Michael T. Voity wrote:
> Hello,
>
> I started to get this message with the "DIFAT" command is being run
> "updatedevices.pl"
>
> Nothing has changed on the server and no one has made any updates -
>
> Any ideas?
>
> Could not insert FWTable at 2012/11/26 19:31:44: Error while inserting
> FWTable: Can't insert new FWTable: DBD::mysql::st execute failed: Table
> 'netdot.fwtable' doesn't exist [for Statement "INSERT INTO fwtable
> (tstamp, device)
> VALUES (?, ?)
> " with ParamValues: 0='2012/11/26 19:31:44', 1='1364'] at
> /usr/local/share/perl5/DBIx/ContextualFetch.pm line 52.
> at bin/updatedevices.pl line 201.
>
>
--
cv
------------------------------
Message: 5
Date: Tue, 27 Nov 2012 16:43:32 -0500
From: "Michael T. Voity" <[email protected]>
Subject: Re: [Netdot-users] Odd error Message
To: Carlos Vicente <[email protected]>
Cc: "[email protected]" <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Carlos,
Thanks for the reply,
We are at v1.0.1.
If I run the "make genschema" Will I lose all my data? If I re-run
the "prune_db" jobs could that fix it?
-Mike
Michael T. Voity
Network Engineer
University of Vermont
(802)656-8112
On 11/27/12 3:42 PM, Carlos Vicente wrote:
> Hi Michael,
>
> The error says that the table does not exist. That should definitely not
> happen :-)
>
> This table is rotated periodically (prune_db in cron job), so maybe this
> process failed to complete, and left and incomplete DB.
>
> Which version of Netdot is this?
>
> You can find the table definition in the schema file (etc/schema.mysql)
> inside the source tree. If you don't have the file, you can always
> generate it with:
>
> $ make genschema
>
>
>
> On 11/26/12 7:37 PM, Michael T. Voity wrote:
>> Hello,
>>
>> I started to get this message with the "DIFAT" command is being run
>> "updatedevices.pl"
>>
>> Nothing has changed on the server and no one has made any updates -
>>
>> Any ideas?
>>
>> Could not insert FWTable at 2012/11/26 19:31:44: Error while inserting
>> FWTable: Can't insert new FWTable: DBD::mysql::st execute failed: Table
>> 'netdot.fwtable' doesn't exist [for Statement "INSERT INTO fwtable
>> (tstamp, device)
>> VALUES (?, ?)
>> " with ParamValues: 0='2012/11/26 19:31:44', 1='1364'] at
>> /usr/local/share/perl5/DBIx/ContextualFetch.pm line 52.
>> at bin/updatedevices.pl line 201.
>>
>>
>
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 48, Issue 13
********************************************
