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) (Carlos Vicente)
2. 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: Thu, 01 Aug 2013 09:57:25 -0400
From: Carlos Vicente <[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: Stafford Rau <[email protected]>
Cc: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1
Stafford,
It's the same. The data field is required and is not being set.
I haven't seen this problem before so I'm not sure how to help.
cv
On 7/31/13 1:10 PM, Stafford Rau wrote:
> 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]
> <mailto:[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 <http://10.38.0.0/16>
> Status: *Container*
> Description: Network Management
> First Created 2013-07-26 13:33:31
> Last Modified 2013-07-26 13:33:31
> Owner: 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.255
> Usable 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] <mailto:[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>
> > <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>
> > <http://cr01-dsbdc-county.clackamas.us> [Vlan2]: Could not
> insert
> > Subnet 10.32.50.0/24 <http://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]
> <mailto:[email protected]>
> > https://osl.uoregon.edu/mailman/listinfo/netdot-users
>
>
>
>
------------------------------
Message: 2
Date: Thu, 1 Aug 2013 07:22:34 -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: Carlos Vicente <[email protected]>
Cc: [email protected]
Message-ID:
<caaqua9hr7mm4wybqfnrgvxruogpyx6yy-i_l+freql9qkmv...@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
The CentOS box this was running on was a fairly new installation, so I
completely removed & re-installed MySQL, then rebuilt netdot. All seems to
be working correctly now, so I'm going to say it was either a permissions
problem or just a bad MySQL install.
Thanks much for looking in to it - I'm pretty impressed with netdot so far.
--Stafford
On Thu, Aug 1, 2013 at 6:57 AM, Carlos Vicente <[email protected]>wrote:
> Stafford,
>
> It's the same. The data field is required and is not being set.
>
> I haven't seen this problem before so I'm not sure how to help.
>
> cv
>
> On 7/31/13 1:10 PM, Stafford Rau wrote:
> > 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]
> > <mailto:[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 <http://10.38.0.0/16>
> > Status: *Container*
> > Description: Network Management
> > First Created 2013-07-26 13:33:31
> > Last Modified 2013-07-26 13:33:31
> > Owner: 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.255
> > Usable 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] <mailto:[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>
> > > <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>
> > > <http://cr01-dsbdc-county.clackamas.us> [Vlan2]: Could not
> > insert
> > > Subnet 10.32.50.0/24 <http://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]
> > <mailto:[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/20130801/61d335c7/attachment-0001.html
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 57, Issue 1
*******************************************
