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: Netdot 1.0.6 release (Kristof Van Doorsselaere)
2. renamed access-point (Kristof Van Doorsselaere)
3. Constant "Error while inserting ArpCache' messages in syslog
(Roberto Greiner)
4. Re: Constant "Error while inserting ArpCache' messages in
syslog (Carlos Vicente)
5. error updating host ethernet address using REST interface
(Patrick M. Landry)
6. Re: Constant "Error while inserting ArpCache' messages in
syslog (Roberto Greiner)
----------------------------------------------------------------------
Message: 1
Date: Fri, 25 Apr 2014 09:48:31 +0000
From: Kristof Van Doorsselaere <[email protected]>
Subject: Re: [Netdot-users] Netdot 1.0.6 release
To: Patrick Landry <[email protected]>, Netdot-users
<[email protected]>
Cc: "[email protected]" <[email protected]>
Message-ID: <cf7ff6ff.211b7%[email protected]>
Content-Type: text/plain; charset="iso-8859-1"
I ran into the same issue, I had to restore the db, first I forgot to drop
the db which cause another error (tables ASN already exist).
patrick?s fix solved my problem
Kristof Van Doorsselaere
On 18/04/14 01:02, "Patrick M. Landry" <[email protected]> wrote:
>I am upgrading from 1.0.4 running mysql. The "make install" generated the
>following error:
>
># cat upgrade/error.log
>DBD::mysql::db do failed: Cannot add or update a child row: a foreign key
>constraint fails (`netdot`.<result 2 when explaining filename
>'#sql-758_2'>, CONSTRAINT `fk_bgplocalas` FOREIGN KEY (`bgplocalas`)
>REFERENCES `asn` (`id`)) at ../lib/DBUTIL.pm line 592.
>ERROR while executing ALTER TABLE device ADD CONSTRAINT `fk_bgplocalas`
>FOREIGN KEY (`bgplocalas`) REFERENCES `asn` (`id`): DBD::mysql::db do
>failed: Cannot add or update a child row: a foreign key constraint fails
>(`netdot`.<result 2 when explaining filename '#sql-758_2'>, CONSTRAINT
>`fk_bgplocalas` FOREIGN KEY (`bgplocalas`) REFERENCES `asn` (`id`)) at
>../lib/DBUTIL.pm line 592.
>
>
>I believe this is because the device.bgplocalas field has not yet been
>populated when trying to add the foreign key contraint to the device
>table generating the foreign key error.
>
>The fix was to move the creation of the device.fk_bgplocalas key after
>the update statement which populates the device.bgplocalas field.
>
># diff -C 3 updatedb /var/tmp/updatedb
>*** updatedb 2014-04-11 08:38:28.000000000 -0500
>--- /var/tmp/updatedb 2014-04-17 17:41:47.071631814 -0500
>***************
>*** 208,219 ****
> push @statements, "INSERT INTO asn (number) SELECT DISTINCT bgplocalas
>FROM device WHERE bgplocalas IS NOT NULL;";
>
> push @statements, "ALTER TABLE device MODIFY bgplocalas bigint;";
>- push @statements, "ALTER TABLE device ADD CONSTRAINT `fk_bgplocalas`
>FOREIGN KEY (`bgplocalas`) ".
>- "REFERENCES `asn` (`id`);";
> push @statements, "CREATE INDEX bgplocalas ON device (bgplocalas);";
>
> push @statements, "UPDATE device,asn SET device.bgplocalas=asn.id
>WHERE device.bgplocalas=asn.number;";
>
> push @statements, "ALTER TABLE bgppeering ADD COLUMN contactlist
>bigint;";
> push @statements, "ALTER TABLE bgppeering ADD CONSTRAINT
>`fk_contactlist_bgppeering` FOREIGN KEY (`contactlist`) ".
> "REFERENCES `contactlist` (`id`);";
>--- 208,220 ----
> push @statements, "INSERT INTO asn (number) SELECT DISTINCT bgplocalas
>FROM device WHERE bgplocalas IS NOT NULL;";
>
> push @statements, "ALTER TABLE device MODIFY bgplocalas bigint;";
> push @statements, "CREATE INDEX bgplocalas ON device (bgplocalas);";
>
> push @statements, "UPDATE device,asn SET device.bgplocalas=asn.id
>WHERE device.bgplocalas=asn.number;";
>
>+ push @statements, "ALTER TABLE device ADD CONSTRAINT `fk_bgplocalas`
>FOREIGN KEY (`bgplocalas`) ".
>+ "REFERENCES `asn` (`id`);";
>+
> push @statements, "ALTER TABLE bgppeering ADD COLUMN contactlist
>bigint;";
> push @statements, "ALTER TABLE bgppeering ADD CONSTRAINT
>`fk_contactlist_bgppeering` FOREIGN KEY (`contactlist`) ".
> "REFERENCES `contactlist` (`id`);";
>
>
>--
>patrick
>
>Patrick Landry
>University of Louisiana at Lafayette
>Director, University Computer Support Services
>
------------------------------
Message: 2
Date: Fri, 25 Apr 2014 11:15:32 +0000
From: Kristof Van Doorsselaere <[email protected]>
Subject: [Netdot-users] renamed access-point
To: Netdot-users <[email protected]>
Message-ID: <cf801072.211f7%[email protected]>
Content-Type: text/plain; charset="us-ascii"
Dear Netdot Usergroup,
One of our wireless accesspoints was renamed, but for some reason this device
was not automatically updated in netdot, is the expected behavior?
remark the accesspoint is discovered via the cisco WLC device
In the debug log I saw:
DEBUG - Device::discover: Device ap-kask-25 does not yet exist
DEBUG - Device::assign_name: A Device with IP x.x.x.x already exists:
ap-cons-2.xxx.xx
DEBUG - ap-cons-2.hogent.be type is: Access Point
INFO - Inserting new Device: ap-kask-25
DEBUG - Device::insert: Device 20629 already exists in DB as ap-cons-2.xxx.xx
Kristof Van Doorsselaere
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20140425/f9e0e9ad/attachment-0001.html
------------------------------
Message: 3
Date: Fri, 25 Apr 2014 12:16:35 -0300
From: Roberto Greiner <[email protected]>
Subject: [Netdot-users] Constant "Error while inserting ArpCache'
messages in syslog
To: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1
Hi,
I'm running netdot 1.0.6 (upgraded two days ago from 1.0.5RC1, my
initial version). I'm getting frequent syslog messages like the
following one:
Apr 25 10:00:13 leonis netdot: WARN - Device 3com8.ipiranga.unesp.br:
Could not insert ArpCache at 2014/04/25 10:00:03: Error while inserting
ArpCache: Can't insert new ArpCache: DBD::mysql::st execute failed:
Duplicate entry '7-2014-04-25 10:00:03' for key 'arpcache1' [for
Statement "INSERT INTO arpcache (tstamp, device)#012VALUES (?, ?)#012"
with ParamValues: 0='2014/04/25 10:00:03', 1='7'] at
/usr/share/perl5/DBIx/ContextualFetch.pm line 52.#012 at
/usr/local/netdot/bin/updatedevices.pl line 213#012
They occur at full hours, except at midnight, midday and 5:00PM,
coinciding with the following cronjob:
# Retrieve forwarding tables and ARP caches
0 1-11,13-16,18-23 * * * root $PREFIX/bin/updatedevices.pl -DFA
When a device, like 3Com8 in the example above, generates those messages
and I disable SNMP management in Netdot, I don't get any more messages
indicating errors for this device. Problem is that I have already
disabled many of the devices, and new ones appeared. I started getting
those errors for all my DLink switches, now I'm getting them for my 3Com
switches. I couldn't find any reference in the web to this error. Could
someone help me?
Thanks,
Roberto
PS: Netdot running in a Debian 7-64bits VM, with everything, except
Netdot itself, installed from the APT repositories.
--
-----------------------------------------------------
Marcos Roberto Greiner
Os otimistas acham que estamos no melhor dos mundos
Os pessimistas tem medo de que isto seja verdade
James Branch Cabell
-----------------------------------------------------
------------------------------
Message: 4
Date: Fri, 25 Apr 2014 11:20:50 -0400
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] Constant "Error while inserting ArpCache'
messages in syslog
To: Roberto Greiner <[email protected]>
Cc: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=windows-1252
Hi Roberto,
I have never seen this one. Are you sure that there isn?t another updatedevices
process running at the same time?
cv
On Apr 25, 2014, at 11:16 AM, Roberto Greiner <[email protected]> wrote:
> Hi,
>
> I'm running netdot 1.0.6 (upgraded two days ago from 1.0.5RC1, my
> initial version). I'm getting frequent syslog messages like the
> following one:
>
> Apr 25 10:00:13 leonis netdot: WARN - Device 3com8.ipiranga.unesp.br:
> Could not insert ArpCache at 2014/04/25 10:00:03: Error while inserting
> ArpCache: Can't insert new ArpCache: DBD::mysql::st execute failed:
> Duplicate entry '7-2014-04-25 10:00:03' for key 'arpcache1' [for
> Statement "INSERT INTO arpcache (tstamp, device)#012VALUES (?, ?)#012"
> with ParamValues: 0='2014/04/25 10:00:03', 1='7'] at
> /usr/share/perl5/DBIx/ContextualFetch.pm line 52.#012 at
> /usr/local/netdot/bin/updatedevices.pl line 213#012
>
> They occur at full hours, except at midnight, midday and 5:00PM,
> coinciding with the following cronjob:
>
> # Retrieve forwarding tables and ARP caches
> 0 1-11,13-16,18-23 * * * root $PREFIX/bin/updatedevices.pl -DFA
>
> When a device, like 3Com8 in the example above, generates those messages
> and I disable SNMP management in Netdot, I don't get any more messages
> indicating errors for this device. Problem is that I have already
> disabled many of the devices, and new ones appeared. I started getting
> those errors for all my DLink switches, now I'm getting them for my 3Com
> switches. I couldn't find any reference in the web to this error. Could
> someone help me?
>
> Thanks,
>
> Roberto
>
> PS: Netdot running in a Debian 7-64bits VM, with everything, except
> Netdot itself, installed from the APT repositories.
>
> --
> -----------------------------------------------------
> Marcos Roberto Greiner
>
> Os otimistas acham que estamos no melhor dos mundos
> Os pessimistas tem medo de que isto seja verdade
> James Branch Cabell
> -----------------------------------------------------
>
> _______________________________________________
> Netdot-users mailing list
> [email protected]
> https://osl.uoregon.edu/mailman/listinfo/netdot-users
------------------------------
Message: 5
Date: Fri, 25 Apr 2014 11:00:43 -0500 (CDT)
From: "Patrick M. Landry" <[email protected]>
Subject: [Netdot-users] error updating host ethernet address using
REST interface
To: "netdot-users " <[email protected]>
Message-ID:
<[email protected]>
Content-Type: text/plain; charset="utf-8"
When attempting to update the ethernet address of a host using the rest
interface by specifying an IpBlockId in the REST PUT request, the following
error is generated:
Apr 25 08:52:03 cannon netdot: FATAL - Cannot find ethernet in
Netdot::Model::DhcpScope metadata
Apr 25 08:52:03 cannon netdot: ERROR - Bad request: $e
This error seems to stem from the fact that the rest handler for hosts
(htdocs/rest/host) passes an argument named "ethernet" rather than "physaddr"
when making updates.
$args{ethernet} = $ethernet if ( $ethernet && !$args{duid} );
rather than
$args{physaddr} = $ethernet if ( $ethernet && !$args{duid} );
--
patrick
Patrick Landry
University of Louisiana at Lafayette
Director, University Computer Support Services
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20140425/e32f807a/attachment-0001.html
------------------------------
Message: 6
Date: Fri, 25 Apr 2014 15:15:09 -0300
From: Roberto Greiner <[email protected]>
Subject: Re: [Netdot-users] Constant "Error while inserting ArpCache'
messages in syslog
To: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=windows-1252
No other instance was running. But running the process manually, it took
a long time to finish (almost 2 minutes), and ended with the following
error:
ERROR - DBD::mysql::st execute failed: Lock wait timeout exceeded; try
restarting transaction [for Statement "INSERT INTO ipblock
(address,prefix,version,status,first_seen,last_seen)
VALUES (?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
last_seen=VALUES(last_seen);" with ParamValues:
0='53174322907827205988022887441789636709', 1=128, 2=6,
3=IpblockStatus=HASH(0x5e280e0), 4='2014/04/25 15:06:33', 5='2014/04/25
15:06:33'] at /usr/share/perl5/DBIx/ContextualFetch.pm line 52.
This looks like there is some deadlock in MySQL, so I forced a restart
in MySQL, which crashed a query (where none should be running). I ran
the same command again, and this time it finished quickly and without
errors. The problem seems to have been cleared. Will see for the next
hours if new messages are generated.
Thanks,
Roberto
On 25/04/2014 12:20, Carlos Vicente wrote:
> Hi Roberto,
>
> I have never seen this one. Are you sure that there isn?t another
> updatedevices process running at the same time?
>
> cv
>
> On Apr 25, 2014, at 11:16 AM, Roberto Greiner <[email protected]> wrote:
>
>> Hi,
>>
>> I'm running netdot 1.0.6 (upgraded two days ago from 1.0.5RC1, my
>> initial version). I'm getting frequent syslog messages like the
>> following one:
>>
>> Apr 25 10:00:13 leonis netdot: WARN - Device 3com8.ipiranga.unesp.br:
>> Could not insert ArpCache at 2014/04/25 10:00:03: Error while inserting
>> ArpCache: Can't insert new ArpCache: DBD::mysql::st execute failed:
>> Duplicate entry '7-2014-04-25 10:00:03' for key 'arpcache1' [for
>> Statement "INSERT INTO arpcache (tstamp, device)#012VALUES (?, ?)#012"
>> with ParamValues: 0='2014/04/25 10:00:03', 1='7'] at
>> /usr/share/perl5/DBIx/ContextualFetch.pm line 52.#012 at
>> /usr/local/netdot/bin/updatedevices.pl line 213#012
>>
>> They occur at full hours, except at midnight, midday and 5:00PM,
>> coinciding with the following cronjob:
>>
>> # Retrieve forwarding tables and ARP caches
>> 0 1-11,13-16,18-23 * * * root $PREFIX/bin/updatedevices.pl -DFA
>>
>> When a device, like 3Com8 in the example above, generates those messages
>> and I disable SNMP management in Netdot, I don't get any more messages
>> indicating errors for this device. Problem is that I have already
>> disabled many of the devices, and new ones appeared. I started getting
>> those errors for all my DLink switches, now I'm getting them for my 3Com
>> switches. I couldn't find any reference in the web to this error. Could
>> someone help me?
>>
>> Thanks,
>>
>> Roberto
>>
>> PS: Netdot running in a Debian 7-64bits VM, with everything, except
>> Netdot itself, installed from the APT repositories.
>>
>> --
>> -----------------------------------------------------
>> Marcos Roberto Greiner
>>
>> Os otimistas acham que estamos no melhor dos mundos
>> Os pessimistas tem medo de que isto seja verdade
>> James Branch Cabell
>> -----------------------------------------------------
>>
>> _______________________________________________
>> Netdot-users mailing list
>> [email protected]
>> https://osl.uoregon.edu/mailman/listinfo/netdot-users
>
--
-----------------------------------------------------
Marcos Roberto Greiner
Os otimistas acham que estamos no melhor dos mundos
Os pessimistas tem medo de que isto seja verdade
James Branch Cabell
-----------------------------------------------------
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 65, Issue 11
********************************************
