R: Nagios with MySql

[Andreoni Antonella]

Hi,

I set up nagios with mysql, now NO problem with CGIs
the DB is up&running
the schema has been made by using the script in the distrib
I compiled and istalled nagios with db support using the following configure string:

 ./configure --prefix=/usr/local/nagios --with-cgiurl=/nagios/cgi-bin --with-htmurl=/nagios --with-nagios-user=nagios --with-nagios-grp=nagios --with-msyql-xdata --with-mysql-lib=/usr/local/mysql/lib --with-mysql-inc=/usr/local/mysql/include --with-gd-lib=/usr/local/lib --with-gd-inc=/usr/local/include


I configured cgi.cfg and resource.cfg as suggested in docs

with all parameters such as db name, db user, db port and so on

I have a doubt: what about log file in the configuration files?
I left setting for status.log and so on in nagios.cfg

nagios.cfg:log_file=/usr/local/nagios/var/nagios.log
nagios.cfg:status_file=/usr/local/nagios/var/status.log
nagios.cfg:comment_file=/usr/local/nagios/var/comment.log
nagios.cfg:downtime_file=/usr/local/nagios/var/downtime.log

I think I had to comment these lines in nagios.cfg....

but if I compile nagios with db support I expected to find those lines commented

what do you think about?

thanks

Antonella


> -----Messaggio originale-----
> Da: Ben Clewett [mailto:Ben at clewett.org.uk]
> Inviato: martedì 25 maggio 2004 17.31
> A: Andreoni Antonella
> Cc: Nagios-Users (E-mail)
> Oggetto: Re: [Nagios-users] Nagios with MySql
> 
> 
> Andreoni Antonella wrote:
> > Hi all
> > 
> > I've just started Nagios with database support but it doesn't work
> > 
> > on the web interface I got the following error:
> > 
> > Whoops!
> > Error: Could not read host and service status information!
> > 
> > And in the log file nagios.log there is the following error message
> > [1085497246] Error: Could not lock status data tables in 
> database 'nagios'
> 
> Just a pre-check: Did you run the provided script to create 
> the database?
> 
> Something like:
> 
> $ cd contrib/database
> $ cat create_myqsl | mysql -u $USER -p$PASS -D $DATABASE -h $HOST
> 
> Where $USER $PASS $DATABASE and $HOST have been correctly 
> setup, and are 
> (probably) the same as those used in nagios.cfg?
> 
> Ben
> 


-------------------------------------------------------
This SF.Net email is sponsored by: GNOME Foundation
Hackers Unite!  GUADEC: The world's #1 Open Source Desktop Event.
GNOME Users and Developers European Conference, 28-30th June in Norway
http://2004/guadec.org
_______________________________________________
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