[rtg] problems installing RTG on SLES 10 (SuSE)

Thu Nov 16 18:53:07 PST 2006

On 11/16/06, Michael Andrus <centyx at centyx.net> wrote:
> On 08Nov2006 10:44AM (-0500), Yu Safin wrote:
> > On 11/8/06, Michael Andrus <centyx at centyx.net> wrote:
> > >What is your purpose for keeping this data? Monitoring? Billing?
> > >We use Cacti to monitor load/traffic/cpu/memory/mysql/apache etc stats,
> > >and use rtg only to calculate 95th percentile for billing purposes, as
> > >it is an exact total, instead of averages. I'm not sure what use you
> > >have planned for the data, but Cacti may be more what you're looking
> > >for. See http://www.cacti.net.
> > >
> > >
> > >On 07Nov2006 12:42AM (-0500), Yu Safin wrote:
> > >> On 11/6/06, Yu Safin <calanet at gmail.com> wrote:
> > >> > On 11/6/06, Yu Safin <calanet at gmail.com> wrote:
> > >> > > I am new to RTG and I am trying to install the rtg-0.7.4 package.
> > >> > > I installed "mysql" and changed the password for root (mysqladmin -u
> > >> > > root password xxxx).  I tested mysql by signing on and off.
> > >> > > Then, after "tar -xvzf rtg*.tar.gz", I run "./configure".
> > >> > > I get the following problem.
> > >> > > ......
> > >> > > ......
> > >> > > checking whether time.h and sys/time.h may both be included... yes
> > >> > > checking whether struct tm is in sys/time.h or time.h... time.h
> > >> > > checking return type of signal handlers... void
> > >> > > checking for gettimeofday... yes
> > >> > > checking for strerror... yes
> > >> > > checking for strtoll... yes
> > >> > > configure: error: Cannot find MySQL headers.  Use --with-mysql= to
> > >> > > specify non-default path.
> > >> > >
> > >> > >
> > >> > > SO, I did a "which mysql",  ran "./configure --with-mysql=/usr/bin"
> > >and got
> > >> > > .....
> > >> > > .....
> > >> > > checking return type of signal handlers... void
> > >> > > checking for gettimeofday... yes
> > >> > > checking for strerror... yes
> > >> > > checking for strtoll... yes
> > >> > > configure: error: Cannot find MySQL header files under /usr/bin
> > >> > >
> > >> > > SO, I tried ./configure --with-mysql=/usr/lib/mysql
> > >> > >
> > >> > > NORMALY header files are in the "devel" packages.  I checked my CD's
> > >> > > for mysql development RPMS and I cannot find it.
> > >> > >
> > >> > > has anybody had any success installing RTG under SLES or OpenSuSE?
> > >> > >
> > >> > I checked with the Novell WEB site and for SLES version 10.1 (I am
> > >> > running 10), they have mysql-devel version 5.  I am running SLES 10.0
> > >> > with mysql version 4.
> > >> > So I am going to upgrade my machine to 10.1.
> > >> >
> > >> I installed SLES10 Intel Enterprise Server Version and I can compile
> > >> and follow the instructions up to the point that I can start
> > >> monitoring routers.  However, I need to monitor CPU, DISK, Memory for
> > >> other Linux, Unix and Windows servers.  From what I read from
> > >> btoneill, I think that is the way I need to go.  I have gone over
> > >> google quite a bit to see if I could find a "howto" integrate
> > >> targetmaker into rtg but no luck so far.  I know it may seem obvious
> > >> to members in this list but it is not to me.  Any helping hand will be
> > >> greatly appreciated.
> > >> _______________________________________________
> > >> RTG mailing list
> > >> RTG at fireflynetworks.net
> > >> http://fireflynetworks.net/mailman/listinfo/rtg
> > >
> > >--
> > >
> > Michael,
> > thank you for getting back to me.
> > The purpose of this data is to monitor and more important plan for
> > capacity requirements for our servers (may be the network as well) in
> > terms of CPU size and memory size.  I would like to keep the collected
> > server data for up to one year before I summarize it for long term
> > trending.  I deal with hundred's of servers and soon I will go over
> > 1,000.  I have been using sar/sadc and acctcom data but it is getting
> > very cumbersome because of the amount of data I deal with.  I wrote
> > routines that scan the sar and acctcom data and push into MySQL.  We
> > currently manage the network with MRTG but if I get RTG working we
> > will probably switch.  I don't do that work since the network guys
> > have it covered.  However, I am supposed to be doing the network so I
> > like the idea of combining both responsibilities into one solution (I
> > am responsible for performance and capacity for the entire
> > infrastructure).
> > I like the documentation and extensive information available for cacti.
> > However, before I switch, I would like to get RTG working with
> > BTONEILL extensions.   I have spent most of the morning reading the
> > source code to gain a better understanding of the available code.
> >
> > My challenge is to undestand the steps to get this combo running.
> > what I believe I need to do is the following, please correct me if I am
> > wrong.
> > 1) install RTG (done)
> > 2) configure RTG for Web access (done)
> > 3) tar -xvzf BTONEILL (done)
> > 4) turn on the snmp daemon in each of my aix, linux and sun servers (done)
> > 5) run findsnmp_host (BTONEILL) <--- i am researching
> > 6) run targetmaker (BTONEILL) <--- i am researching
> > 7) in my daily cron, copy updatetargets.sh (BTONEILL)
> >
> > I sewe a lot of interesting modules such as HOST-RESOURCE_MIB.pl,
> > NetSNMP.pl and so on but I still don't know how the fit into the
> > picture.
> >
> > I was hoping Neil would get back to me but he must be very busy.
> > It will be a big help If you have any advise on how to get BTONEILL
> > working with RTG.
>
> Sorry, I've never used his scripts. Right now all I'm using RTG for is
> collecting traffic data in mysql to use for 95th percentile calculations
> for customer billing. Right now it's just polling one switch w/ 18
> active interfaces. I started w/ rtg from cvs, but went back to 0.7.4
> and am using it now. I used the default database schema and
> rtgtargmkr.pl distributed w/ rtg. These have worked fine for our
> purposes. For system monitoring/notification ( services, load, procs, host up/down,
> etc ) we use Nagios, and for more detailed monitoring/assessment we use
> Cacti.
>
> --
>
What I am finding difficult with RTG is that I don't seem to be able
to get a complete story on how to install from step 1 to the last
step.  I think the expectation is that you have to be at a level of
expertise higher than my skills.  Can I ask you for some help on how
to install RTG?  Which version should I try?  I am running SLES 10
(SuSE).

What I am after is the collection of performance data for Unix servers
(aix, sun and linux) such as CPU, disk and procs.  I am talking a lot
of servers in the hundreds.
Do you think I should switch over to cacti or nagios?  what is the
difference between those two?  when would RTG make sense?
if I was to use RTG, how can I find out what the OID's are for cpu, disk, procs?
I am new to SNMP.
I tried installing the cvs version of RTG but I am having problems with MySQL.
When I installed 0.7.4, I had problems with the definition of the
targets.cfg file so I was asked to go the cvs version.
For people who have been doing RTG, it is probably very clear.  For
new people like myself it has been a challenge.
Thank you for getting back to me.