mySQL+Nagios noob, thanks for reading

Dan Hopkins dan.hopkins at uk.easynet.net
Mon May 9 13:41:01 CEST 2005


> -----Original Message-----
> From: Dan Dycus [mailto:ddycus at gmail.com]
> Sent: 29 April 2005 19:59
> To: nagios-users at lists.sourceforge.net
> Subject: [Nagios-users] mySQL+Nagios noob, thanks for reading
> 
> 
> Hey all-
> 
> I'm brand new to this list, and I'm hoping you folks can help.  I have
> used Nagios 1.2 now for quite some time watching 949 services on over
> 180 hosts today WITHOUT mySQL.  My challenge is to get nagios compiled
> to run on mySQL and use Cacti to perform historical monitoring
> functions.  Here's what I've done so far:
> 
> 1. setup a test Suse 9 box.
> 2. installed Nagios and mySQL along with all required dependancies as
> far as I can tell since everything compiled without problems.
> 3. created the databases within mySQL by first executing mysql, and
> then running the following:
>    a. mysqladmin -u root -p  create nagios (leaving the password
> blank) thus creating the database within mySQL
>    b. then I ran "mysql> use nagios" to set the database, and ran
> "source create_mysql.sql" to setup the table space.

<snip>

> 10. When I open mySQL, and run "SELCET * FROM hoststatus;" it returns
> Emty Set and puts me back to the prompt.  EVERY table space shows
> empty set for that matter. ??? :(
> 
> If anyone can help me here I'd really appreciate it.

Bit of a late reply, you may have this sorted already, but did you check
nagios.log for errors? Sounds like you haven't configured resource.cfg with
your db details....

Danm


-------------------------------------------------------
This SF.Net email is sponsored by: NEC IT Guy Games.
Get your fingers limbered up and give it your best shot. 4 great events, 4
opportunities to win big! Highest score wins.NEC IT Guy Games. Play to
win an NEC 61 plasma display. Visit http://www.necitguy.com/?r=20
_______________________________________________
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





More information about the Users mailing list