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. prune_db and rotation (Wim Vandersmissen)
2. Re: Odd error Message (Michael T. Voity)
3. Re: prune_db and rotation (Carlos Vicente)
4. Re: Odd error Message (Carlos Vicente)
5. Re: IP Address field editable? (Wim Vandersmissen)
6. MAX number of root IP blocks? (Attila Heidrich)
7. Re: MAX number of root IP blocks? (Wim Vandersmissen)
----------------------------------------------------------------------
Message: 1
Date: Tue, 27 Nov 2012 22:51:16 +0100
From: Wim Vandersmissen <[email protected]>
Subject: [Netdot-users] prune_db and rotation
To: [email protected]
Cc: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Hi Carlos,
I just read in your previous mail
'This table is rotated periodically (prune_db in cron job), so maybe
this process failed to complete, and left and incomplete DB.'
I'm using netdot 1.0.2, the prune_db.pl script with this version doesn't
do rotate, it seems to just drop the table (arpcache/fwtable)
I ran prune_db.pl -r -d 7 -F
DEBUG: init: dbi:mysql:dbname=netdot;host=localhost;mysql_local_infile=1
DEBUG: Connected successfully
INFO - Tables fwtableentry, fwtable rotated successfully
DEBUG: Disconnected successfully
Afterwards fwtableentry and fwtable are empty
mysql> select * from fwtable;
Empty set (0.01 sec)
mysql> select * from fwtableentry;
Empty set (0.01 sec)
(Luckily I had a backup ;)
Wim
------------------------------
Message: 2
Date: Tue, 27 Nov 2012 20:00:39 -0500
From: "Michael T. Voity" <[email protected]>
Subject: Re: [Netdot-users] Odd error Message
To: "[email protected]" <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset="iso-8859-1"
Carlos,
I was able to fix my database by using webmin (I know not the best
app) I was able to create the table 'fwtable' and copy the field data
from an existing table of ' fwtable_1352623504'
I then ran the update script and all appears to be well.
Thanks to Wim who pointed me in the right direction.
-Mike
Michael T. Voity
Network Engineer
University of Vermont
(802)656-8112
On 11/27/12 4:43 PM, Michael T. Voity wrote:
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20121127/4d77734d/attachment-0001.html
------------------------------
Message: 3
Date: Tue, 27 Nov 2012 21:37:24 -0500
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] prune_db and rotation
To: Wim Vandersmissen <[email protected]>
Cc: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1
On 11/27/12 4:51 PM, Wim Vandersmissen wrote:
> I'm using netdot 1.0.2, the prune_db.pl script with this version doesn't
> do rotate, it seems to just drop the table (arpcache/fwtable)
It drops it and then creates it again. It's a much faster way to delete
large numbers of rows in mysql.
The fwtable, fwtableentry, arpcache and arpcacheentry grow to millions
of rows in our network, so we empty them once a week.
--
cv
------------------------------
Message: 4
Date: Tue, 27 Nov 2012 21:38:11 -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
On 11/27/12 4:43 PM, Michael T. Voity wrote:
> We are at v1.0.1.
You should really upgrade. 1.0.1 has some nasty bugs.
--
cv
------------------------------
Message: 5
Date: Wed, 28 Nov 2012 12:53:25 +0000
From: Wim Vandersmissen <[email protected]>
Subject: Re: [Netdot-users] IP Address field editable?
To: Carlos Vicente <[email protected]>, Vincent Magnin
<[email protected]>
Cc: "[email protected]" <[email protected]>
Message-ID:
<c662177c398fc342aae60cbe7593707d10766...@icts-s-mbx3.luna.kuleuven.be>
Content-Type: text/plain; charset="us-ascii"
I've just encountered a use for this, when creating a wrong Ipv6 range
(somethings you miss a digit ;), it's handy to be able to modify the address.
Wim
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Carlos Vicente
Sent: dinsdag 27 november 2012 21:18
To: Vincent Magnin
Cc: [email protected]
Subject: Re: [Netdot-users] IP Address field editable?
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
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
------------------------------
Message: 6
Date: Wed, 28 Nov 2012 16:20:49 +0100
From: Attila Heidrich <[email protected]>
Subject: [Netdot-users] MAX number of root IP blocks?
To: [email protected]
Message-ID:
<CAJ4uBuhS8eqsV9KdOYyzXCZHqwEsy8iRa7N9Ayr-EM5y4=l...@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
There are 51 of them for me now, so I only see, that it is more than 50,
but I can not find, where can I set the configured limit higher!
Please help!
Attila
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20121128/ad4b649f/attachment-0001.html
------------------------------
Message: 7
Date: Wed, 28 Nov 2012 15:24:13 +0000
From: Wim Vandersmissen <[email protected]>
Subject: Re: [Netdot-users] MAX number of root IP blocks?
To: Attila Heidrich <[email protected]>,
"[email protected]" <[email protected]>
Message-ID:
<c662177c398fc342aae60cbe7593707d10766...@icts-s-mbx3.luna.kuleuven.be>
Content-Type: text/plain; charset="us-ascii"
Site.conf
# Max number of root blocks to display in Address Space management section
ROOT_BLOCK_SHOW_MAX => 200,
From: [email protected]
[mailto:[email protected]] On Behalf Of Attila Heidrich
Sent: woensdag 28 november 2012 16:21
To: [email protected]
Subject: [Netdot-users] MAX number of root IP blocks?
There are 51 of them for me now, so I only see, that it is more than 50, but I
can not find, where can I set the configured limit higher!
Please help!
Attila
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20121128/7652c66d/attachment.html
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 48, Issue 14
********************************************
