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