help configuring nagios-mysql with nagiosgraph

[John Stile]

Hays anyone configured nagios 1.3 with mysql and nagiosgraph-0.5? 

Nagiosgraph is not creating rrd tables on my debian system. 

Is there a trick config if nagiosgraph us used with mysql enabled
nagios?

The rrd directory is world writable, but no databases are created.

The nagiosgraph log shows 'perfdata not recognized'
        Fri Sep 30 18:06:09 2005 INSERT debug: Config logfile:/var/log/nagiosgraph/nagiosgraph.log
        Fri Sep 30 18:06:09 2005 INSERT debug: Config rrddir:/usr/share/nagios/nagiosgraph/rrd
        Fri Sep 30 18:06:09 2005 INSERT debug: Config mapfile:/usr/share/nagios/nagiosgraph/map
        Fri Sep 30 18:06:09 2005 INSERT debug: Config rrdtool:/usr/bin/rrdtool
        Fri Sep 30 18:06:09 2005 INSERT debug: Config colorscheme:1
        Fri Sep 30 18:06:09 2005 INSERT debug: Config heartbeat:600
        Fri Sep 30 18:06:09 2005 INSERT debug: perfdata:
        Fri Sep 30 18:06:09 2005 INSERT info: Input lastcheck:
        Fri Sep 30 18:06:09 2005 INSERT info: Input hostname:
        Fri Sep 30 18:06:09 2005 INSERT info: Input perfdata:
        Fri Sep 30 18:06:09 2005 INSERT info: Input servicedescr:
        Fri Sep 30 18:06:09 2005 INSERT info: Input output:
        Fri Sep 30 18:06:09 2005 INSERT warn: perfdata not recognized
        Fri Sep 30 18:06:21 2005 INSERT debug: Config logfile:/var/log/nagiosgraph/nagiosgraph.log
        Fri Sep 30 18:06:21 2005 INSERT debug: Config rrddir:/usr/share/nagios/nagiosgraph/rrd
        Fri Sep 30 18:06:21 2005 INSERT debug: Config mapfile:/usr/share/nagios/nagiosgraph/map
        Fri Sep 30 18:06:21 2005 INSERT debug: Config rrdtool:/usr/bin/rrdtool
        Fri Sep 30 18:06:21 2005 INSERT debug: Config colorscheme:1
        Fri Sep 30 18:06:21 2005 INSERT debug: Config heartbeat:600
        Fri Sep 30 18:06:21 2005 INSERT debug: perfdata:
        Fri Sep 30 18:06:21 2005 INSERT info: Input lastcheck:
        Fri Sep 30 18:06:21 2005 INSERT info: Input hostname:
        Fri Sep 30 18:06:21 2005 INSERT info: Input perfdata:
        Fri Sep 30 18:06:21 2005 INSERT info: Input servicedescr:
        Fri Sep 30 18:06:21 2005 INSERT info: Input output:
        Fri Sep 30 18:06:21 2005 INSERT warn: perfdata not recognized
        Fri Sep 30 18:09:00 2005 CGI debug: Config logfile:/var/log/nagiosgraph/nagiosgraph.log
        Fri Sep 30 18:09:00 2005 CGI debug: Config rrddir:/usr/share/nagios/nagiosgraph/rrd
        Fri Sep 30 18:09:00 2005 CGI debug: Config mapfile:/usr/share/nagios/nagiosgraph/map
        Fri Sep 30 18:09:00 2005 CGI debug: Config rrdtool:/usr/bin/rrdtool
        Fri Sep 30 18:09:00 2005 CGI debug: Config colorscheme:1
        Fri Sep 30 18:09:00 2005 CGI debug: Config heartbeat:600
        Fri Sep 30 18:09:00 2005 CGI debug: Config logfile:/var/log/nagiosgraph/nagiosgraph.log
        Fri Sep 30 18:09:00 2005 CGI debug: Config rrddir:/usr/share/nagios/nagiosgraph/rrd
        Fri Sep 30 18:09:00 2005 CGI debug: Config mapfile:/usr/share/nagios/nagiosgraph/map
        Fri Sep 30 18:09:00 2005 CGI debug: Config rrdtool:/usr/bin/rrdtool
        Fri Sep 30 18:09:00 2005 CGI debug: Config colorscheme:1
        Fri Sep 30 18:09:00 2005 CGI debug: Config heartbeat:600
        Fri Sep 30 18:09:00 2005 CGI debug: @db=
        Fri Sep 30 18:09:00 2005 CGI info: Listing host_home%2Estilen%2Ecom_PING db files in /usr/share/nagios/nagiosgraph/rrd:
        Fri Sep 30 18:09:00 2005 CGI info: System /usr/bin/rrdtool graph - -a PNG --start -118800
        Fri Sep 30 18:09:00 2005 CGI info: System returncode 0 message
        
My nagiosgraph.conf
        debug = 5
        logfile = /var/log/nagiosgraph/nagiosgraph.log
        rrddir =  /usr/share/nagios/nagiosgraph/rrd
        mapfile = /usr/share/nagios/nagiosgraph/map
        rrdtool = /usr/bin/rrdtool
        colorscheme = 1
        heartbeat = 600

This was my insert statement put an icon in the services column on the
nagios web interface: 

mysql> insert into serviceextinfo \
set host_name="bugzilla.msli.com",
service_description="PING",
notes_url="/nagiosgraph/show.cgi?host=$HOSTNAME$&service=$SERVICEDESC$",
icon_image="graph.png",
icon_image_alt="View Graph";

I installed with debian nagios packages.
This is what my nagios setup looks like (nagios -m)
Nagios 1.3
Copyright (c) 1999-2004 Ethan Galstad (nagios at nagios.org)
Last Modified: 10-24-2004
License: GPL

External Data I/O
-----------------
Object Data:      TEMPLATE
Status Data:      DATABASE (MySQL)
Retention Data:   DATABASE (MySQL)
Comment Data:     DATABASE (MySQL)
Downtime Data:    DATABASE (MySQL)
Performance Data: FILE

Options
-------


Thank you,
John



-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null