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: prune_db and rotation (Wim Vandersmissen)
2. Re: Installing on CentOS 5.5 (Carlos Vicente)
3. Re: Who uses Netdot? (Alexander Bochmann)
4. Re: Installing on CentOS 5.5 (John Begley)
----------------------------------------------------------------------
Message: 1
Date: Wed, 12 Dec 2012 20:42:34 +0000
From: Wim Vandersmissen <[email protected]>
Subject: Re: [Netdot-users] prune_db and rotation
To: Carlos Vicente <[email protected]>
Cc: "[email protected]" <[email protected]>
Message-ID:
<c662177c398fc342aae60cbe7593707d10768...@icts-s-mbx3.luna.kuleuven.be>
Content-Type: text/plain; charset="us-ascii"
Thanks for the info.
I'd like to keep some entries though, for example a week worth of data.
I'm now using the following SQL for this (maybe useful for someone else)
For the fwentries:
mysql netdot -e 'delete fwtableentry from fwtableentry join fwtable on
fwtable.id=fwtableentry.fwtable where tstamp < (NOW() - INTERVAL 7 DAY);'
And a history of mac <-> ip addresses in a compressed table (for future use
when I've time to create a script to do more useful stuff with it :)
#!/bin/bash
#create history backup
now=$(date +%Y%m%d)
#mysql netdot -e 'create table arpcache_history_'$now' (sysname
varchar(255),name varchar(255),ipaddr bigint(20), physaddr varchar(128),
tstamp timestamp);"' KEY `key1` (`sysname`),
mysql netdot -e 'create table arpcache_history_'$now' (sysname
varchar(255),name varchar(255),ipaddr bigint(20), physaddr varchar(128),
tstamp timestamp, KEY key1 (sysname), KEY key2 (name), KEY key3 (ipaddr), KEY
key4 (physaddr), KEY key5 (tstamp));'
#load previous week
mysql netdot -e 'insert into arpcache_history_'$now' select
device.sysname,interface.name,ipblock.address,physaddr.address,arpcache.tstamp
from arpcacheentry JOIN arpcache on arpcache.id=arpcache JOIN interface on
interface.id=interface JOIN ipblock on ipblock.id=arpcacheentry.ipaddr JOIN
physaddr on physaddr.id=arpcacheentry.physaddr JOIN device on
device.id=arpcache.device where arpcache.tstamp < (NOW() - INTERVAL 7 DAY);"'
#delete everything older than 7 days
mysql netdot -e 'delete arpcacheentry from arpcacheentry join arpcache on
arpcache.id=arpcacheentry.arpcache where tstamp < (NOW() - INTERVAL 7 DAY);'
/usr/bin/myisampack -rq /var/lib/mysql/netdot/arpcache_history_$now.MYI
/usr/bin/myisamchk -cFU /var/lib/mysql/netdot/arpcache_history_$now.MYI
/usr/bin/myisamchk -t /opt/tmp/ -raq
/var/lib/mysql/netdot/arpcache_history_$now.MYI
Wim
________________________________________
From: [email protected]
[[email protected]] on behalf of Carlos Vicente
[[email protected]]
Sent: Wednesday, November 28, 2012 03:37
To: Wim Vandersmissen
Cc: [email protected]
Subject: Re: [Netdot-users] prune_db and rotation
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
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
------------------------------
Message: 2
Date: Wed, 12 Dec 2012 16:03:20 -0500
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] Installing on CentOS 5.5
To: Paul Vaysberg <[email protected]>
Cc: "'[email protected]'" <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1
That looks like a circular dependency in the RPMs. I would try
downloading the RPM files from the CentOS repo and installing them by
hand with:
rpm -Uvh --nodeps package-name.rpm
I think that you will need:
graphviz
graphviz-devel
libpng-devel
graphviz-gd
perl-GraphViz
Good luck.
cv
On 12/12/12 1:54 PM, Paul Vaysberg wrote:
> Hi Carlos,
>
> I get:
>
> graphviz-gd-2.12-8.el5.centos.x86_64 from extras has depsolving problems
> --> Missing Dependency: graphviz = 2.12-8.el5.centos is needed by package
> graphviz-gd-2.12-8.el5.centos.x86_64 (extras)
> Error: Missing Dependency: graphviz = 2.12-8.el5.centos is needed by package
> graphviz-gd-2.12-8.el5.centos.x86_64 (extras)
> You could try using --skip-broken to work around the problem
> You could try running: package-cleanup --problems
> package-cleanup --dupes
> rpm -Va --nofiles --nodigest
> the graphviz package is installed:
> ---
> Command "rpm -qa | grep graph" returns:
> graphviz-2.12-8.el5.centos
> graphviz-gd-2.12-8.el5.centos
>
> Thanks,
> Paul Vaysberg
>
>
>
> -----Original Message-----
> From: Carlos Vicente [mailto:[email protected]]
> Sent: Wednesday, December 12, 2012 8:14 AM
> To: Paul Vaysberg
> Cc: '[email protected]'
> Subject: Re: [Netdot-users] Installing on CentOS 5.5
>
> Hello Paul,
>
> On 12/12/12 9:01 AM, Paul Vaysberg wrote:
>> Does anyone have instructions for installing on a CentOS 5.5 box. I'm a
>> Linux novice and am having a heck of a time getting the dependencies
>> resolved.
>>
>
> The easiest way would be to use the install script like:
>
> make rpm-install
>
> After that, you will likely have several missing Perl modules. The
> script will ask you if you want to use CPAN to install them. This is the
> same as doing:
>
> make installdeps
>
> At the end, run this to verify:
>
> make testdeps
>
>
> If you have problems with specific modules, you can try to install them
> manually. Go to the CPAN page and download the .tar.gz package, then do
> something like:
>
> tar xzvf package-name.tar.gz
> perl Makefile.PL
> make all
> make test
> sudo make install
>
> After that, continue with the installation instructions in the manual.
>
> If any of this fails, feel free to post any specific error messages to
> this list, and I or someone else may be able to help.
>
>
--
cv
------------------------------
Message: 3
Date: Wed, 12 Dec 2012 22:00:30 +0100
From: Alexander Bochmann <[email protected]>
Subject: Re: [Netdot-users] Who uses Netdot?
To: netdot-users <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=us-ascii
...on Mon, Dec 10, 2012 at 08:01:58AM -0500, Carlos Vicente wrote:
> I would like to add a section to our website with logos or names of
> organizations that use Netdot. This would encourage new adopters and
> also gives us, the developers, incentive to keep going.
I'll have to ask if that's possible.
We're the IT subsidary of a regional energy utility in southwestern
germany, and the networking team is using Netdot mainly to collect
information about our systmens. I fear right now it's more of a personal
side project - although everyone is using it to quickly look up various
things. Still trying to make it an official tool :)
Alex.
------------------------------
Message: 4
Date: Thu, 13 Dec 2012 08:23:33 -0500
From: John Begley <[email protected]>
Subject: Re: [Netdot-users] Installing on CentOS 5.5
To: Carlos Vicente <[email protected]>
Cc: "'[email protected]'" <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Paul,
Check to be sure you have the "Development Tools" package installed.
Check by using...
yum grouplist
If it's not installed install it, and try again. Make sure to check the
exact name in the list and install it with quotes.
yum groupinstall "Development Tools"
I'm pretty sure this will clear your issue up, and you should be able to
run the install per the instructions.
JB
On 12/12/2012 4:03 PM, Carlos Vicente wrote:
> That looks like a circular dependency in the RPMs. I would try
> downloading the RPM files from the CentOS repo and installing them by
> hand with:
>
> rpm -Uvh --nodeps package-name.rpm
>
> I think that you will need:
>
> graphviz
> graphviz-devel
> libpng-devel
> graphviz-gd
> perl-GraphViz
>
> Good luck.
>
> cv
>
> On 12/12/12 1:54 PM, Paul Vaysberg wrote:
>> Hi Carlos,
>>
>> I get:
>>
>> graphviz-gd-2.12-8.el5.centos.x86_64 from extras has depsolving problems
>> --> Missing Dependency: graphviz = 2.12-8.el5.centos is needed by package
>> graphviz-gd-2.12-8.el5.centos.x86_64 (extras)
>> Error: Missing Dependency: graphviz = 2.12-8.el5.centos is needed by package
>> graphviz-gd-2.12-8.el5.centos.x86_64 (extras)
>> You could try using --skip-broken to work around the problem
>> You could try running: package-cleanup --problems
>> package-cleanup --dupes
>> rpm -Va --nofiles --nodigest
>> the graphviz package is installed:
>> ---
>> Command "rpm -qa | grep graph" returns:
>> graphviz-2.12-8.el5.centos
>> graphviz-gd-2.12-8.el5.centos
>>
>> Thanks,
>> Paul Vaysberg
>>
>>
>>
>> -----Original Message-----
>> From: Carlos Vicente [mailto:[email protected]]
>> Sent: Wednesday, December 12, 2012 8:14 AM
>> To: Paul Vaysberg
>> Cc: '[email protected]'
>> Subject: Re: [Netdot-users] Installing on CentOS 5.5
>>
>> Hello Paul,
>>
>> On 12/12/12 9:01 AM, Paul Vaysberg wrote:
>>> Does anyone have instructions for installing on a CentOS 5.5 box. I'm a
>>> Linux novice and am having a heck of a time getting the dependencies
>>> resolved.
>>>
>> The easiest way would be to use the install script like:
>>
>> make rpm-install
>>
>> After that, you will likely have several missing Perl modules. The
>> script will ask you if you want to use CPAN to install them. This is the
>> same as doing:
>>
>> make installdeps
>>
>> At the end, run this to verify:
>>
>> make testdeps
>>
>>
>> If you have problems with specific modules, you can try to install them
>> manually. Go to the CPAN page and download the .tar.gz package, then do
>> something like:
>>
>> tar xzvf package-name.tar.gz
>> perl Makefile.PL
>> make all
>> make test
>> sudo make install
>>
>> After that, continue with the installation instructions in the manual.
>>
>> If any of this fails, feel free to post any specific error messages to
>> this list, and I or someone else may be able to help.
>>
>>
>
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 49, Issue 11
********************************************
