[Apan-users] apan-sql questions/problems.

[Boulytchev, Vasiliy]

FIXED

Thanks for your help!

I was not specifying the right arguments to the plugins,  they are described
right here:

http://apan.sourceforge.net/   click on documentation,  then click on
plugins.  Read up.

Thanks again.  I knew it was an RTFM issue. 


Vasiliy Boulytchev
Colorado Information Technologies, Inc.
http://www.coinfotech.com

-----Original Message-----
From: jeff vier [mailto:jeff.vier at tradingtechnologies.com] 
Sent: Tuesday, April 13, 2004 10:12 AM
To: Boulytchev, Vasiliy
Cc: nagios-users; apan-users at lists.sourceforge.net
Subject: RE: [Apan-users] apan-sql questions/problems.


On Tue, 2004-04-13 at 10:44, Boulytchev, Vasiliy wrote:
> 	I made sure nagios.nagios is the owner,  and that nagios can
> write/read/append the file....  Is that enough?   I suppose it has to be
> permissions somewhere along the line...... 

Mine are 660 nagios.nagios, however, my apache user is also in the nagios
group (though I don't *think* that would make any difference here).

I have never used the apanconf-sql tool, so I don't know how it does things,
but create my load rrds with:
/usr/local/rrdtool/bin/rrdtool create
/usr/local/nagios/rrd/server1_CPULoad.rrd -s 300 DS:CPU-Load:GAUGE:900:0:U
RRA:AVERAGE:0.5:1:50400 RRA:AVERAGE:0.5:60:43800

and, into MySQL, I do:
echo "INSERT INTO apanservices VALUES ('','server1','CPU
Load','/usr/local/nagios/rrd/server1_CPULoad.rrd','CPU Load - with historic
graph','load/%','','','','');" | mysql -A -h mysqlserver -u nagios
--password=blahblah -P 3306 nagios -H

NEWIDX=$(echo "select idx from apanservices where host='server1' and
service='CPU Load';"|mysql -A -h mysqlserver -u nagios --password=blahblah
-P 3306 nagios -H)

echo "INSERT INTO apanserviceargs VALUES
('','$NEWIDX','1','CPULOAD','CPU-Load','LINE2');" | mysql -A -h mysqlserver
-u nagios --password=blahblah -P 3306 nagios -H

(I put in cr/lfs so you differentiate commands.  they're each on one
contigious line, of course, when you run them)

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 4357 bytes
Desc: not available
URL: <https://www.monitoring-lists.org/archive/users/attachments/20040413/0c73f027/attachment.bin>