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: DBD::mysql::st execute failed: Field 'data' doesn't have
a default value [for Statement "INSERT INTO datacache (tstamp,
name) (Stafford Rau)
----------------------------------------------------------------------
Message: 1
Date: Wed, 31 Jul 2013 10:10:51 -0700
From: Stafford Rau <[email protected]>
Subject: Re: [Netdot-users] DBD::mysql::st execute failed: Field
'data' doesn't have a default value [for Statement "INSERT INTO
datacache (tstamp, name)
To: [email protected], "cvicente.uo"
<[email protected]>
Message-ID:
<CAAquA9HERwV5RfOWi7=qpftwppgdzj-d+lnuonfplngchun...@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
I just dropped the database and did a new "make installdb" from the source
directory. I went to add the first device, and got these messages under
/var/log/messages:
Jul 31 10:01:56 mgt2 netdot: INFO - Netdot::Model::_audit: user: admin,
operation: insert, table: ipblock, id: 1 (10.38.0.133), fields:
(version,status,use_network_broadcast,first_seen,last_seen,address,id,prefix),
values: ('4','Static','0','2013-07-31 10:01:56','2013-07-31
10:01:56','10.38.0.133','1','32')
Jul 31 10:01:56 mgt2 netdot: ERROR - Error while inserting DataCache: Can't
insert new DataCache: DBD::mysql::st execute failed: Field 'data' doesn't
have a default value [for Statement "INSERT INTO datacache (tstamp,
name)#012VALUES (?, ?)#012" with ParamValues: 0=0, 1='iptree4'] at
/usr/share/perl5/DBIx/ContextualFetch.pm line 52, <GEN24> line 7177.#012#012
Jul 31 10:01:56 mgt2 netdot: ERROR - Error while inserting DataCache: Can't
insert new DataCache: DBD::mysql::st execute failed: Field 'data' doesn't
have a default value [for Statement "INSERT INTO datacache (tstamp,
name)#012VALUES (?, ?)#012" with ParamValues: 0=0, 1='iptree4'] at
/usr/share/perl5/DBIx/ContextualFetch.pm line 52.#012#012
Don't know if this helps at all, but I would very much like to proceed with
this install.
--Stafford
On Fri, Jul 26, 2013 at 1:40 PM, Stafford Rau <[email protected]> wrote:
> It looks like Net::Patricia is version 1.20:
>
> cpan[1]> install Net::Patricia
> <snip>
> Net::Patricia is up to date (1.20).
>
> cpan[2]>
>
> This seems to be happening anytime I initially try to add any new object.
> However, when I try the second time to add the same object, it succeeds.
>
> Adding an ip space container object:
>
> *ip.html* produced the following error:
>
> Error while inserting DataCache: Can't insert new DataCache: DBD::mysql::st
> execute failed: Field 'data' doesn't have a default value [for Statement
> "INSERT INTO datacache (tstamp, name)
> VALUES (?, ?)
> " with ParamValues: 0=0, 1='iptree4'] at
> /usr/share/perl5/DBIx/ContextualFetch.pm line 52.
>
>
> Then I added the exact same data a second time, and it worked without
> error. Odd.
>
> Address:10.38.0.0/16 Status:*Container* Description:Network ManagementFirst
> Created2013-07-26
> 13:33:31Last Modified 2013-07-26 13:33:31Owner: NetEng
> <http://mgt2.clackamas.us/netdot/management/view.html?table=Entity&id=25>
> [edit] <http://mgt2.clackamas.us/netdot/management/ip.html#> Used by:
> NetEng
> <http://mgt2.clackamas.us/netdot/management/view.html?table=Entity&id=25>
> [edit] <http://mgt2.clackamas.us/netdot/management/ip.html#> Netmask:
> 255.255.0.0 Broadcast:10.38.255.255Usable Addresses: 65536 (10.38.0.1 -
> 10.38.255.254)Address Utilization:
> Used: 104 of 65536 Available: 65432 (>99%)
> Space Allocated:
> Available: 95%
>
>
>
> On Fri, Jul 26, 2013 at 1:13 PM, Carlos Vicente <[email protected]>wrote:
>
>> I have not seen this before.
>>
>> The error suggests that the insert query does not include a value for
>> the mandatory field 'data'.
>>
>> The data should be coming from Net::Patricia. Do you have that
>> installed? If so, which version?
>>
>> cv
>>
>> On 7/26/13 12:15 PM, Stafford Rau wrote:
>> > I just installed netdot 1.0.4 on CentOS 6.4. After doing a discovery
>> > from the first device, I got a ton of the following errors & warnings
>> > when I added it: I had the "Add new subnets" and "new subnets inherit
>> > device owner/user" check boxes selected.
>> >
>> > WARN - cr01-dsbdc-county.clackamas.us
>> > <http://cr01-dsbdc-county.clackamas.us> [Vlan2]: Could not insert IP
>> > 10.32.50.1 <http://10.32.50.1>: Error while inserting DataCache:
>> > Can't insert new DataCache: DBD::mysql::st execute failed: Field
>> > 'data' doesn't have a default value [for Statement "INSERT INTO
>> > datacache (tstamp, name) ERROR - cr01-dsbdc-county.clackamas.us
>> > <http://cr01-dsbdc-county.clackamas.us> [Vlan2]: Could not insert
>> > Subnet 10.32.50.0/24 <http://10.32.50.0/24>: Error while inserting
>> > DataCache: Can't insert new DataCache: DBD::mysql::st execute failed:
>> > Field 'data' doesn't have a default value [for Statement "INSERT INTO
>> > datacache (tstamp, name)
>> >
>> > Is this normal, or a known issue? Thanks, --Stafford A. Rau
>> >
>> >
>> >
>> > _______________________________________________ Netdot-users mailing
>> > list [email protected]
>> > https://osl.uoregon.edu/mailman/listinfo/netdot-users
>>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20130731/43ac7dd8/attachment-0001.html
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 56, Issue 14
********************************************
