<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8"> <META NAME="GENERATOR" CONTENT="GtkHTML/3.0.8"> </HEAD> <BODY> Sorry to say but I was told the RPM's are not compiled for database support. You will have to compile Nagios with DB support. I am working on a procedure to do just this. I recommend the following Redhat RPM packages be installed before starting, they all may not be required but Nagios compile clean after installing them: autoconf gd-devel gd-progs libgd libgd-dev libpng libpng-devel libpng10 libpng10-devel libungif libungif-devel libungif-progs mysql mysql-devel mysql-server The steps below are what I did to compile Nagios with MySQL support, they have not been verified (ran from a fresh install of RH) so I would take them with a grain-of-salt; the most important thing the is the RPsM listed above and to run autoconf before continuing. Hope this helps. 1) This step prepares Nagios to be compiled. Expand the Nagios download to /tmp/nagios-1.1 and cd into it. <PRE> autoconf ./configure --with-htmurl=/monitor --with-cgiurl=/monitor/cgi-bin \ --prefix=/opt/monitorsvr \ --with-nagios-user=nagios --with-nagios-grp=nagios \ --with-mysql-inc=/usr/include/mysql --with-mysql-lib=/usr/lib/mysql \ --with-mysql-xdata </PRE> 2) Compile Nagios: make all 3) Install Nagios, supporting init script and command file permissions: make install; make install-init; make install-commandmode 3a) If you wish to install SAMPLE configuration files run: make install-config 4) Cd'ed to /opt/monitorsvr/etc and copied cgi.cfg-example and resource.cfg-sample to cgi-cfg and resource.cfg respectively. Edited all DataBase directives to match the MySQL database information. DB Name: nagios DB user: nagios DB Port: 3306 DB host: localhost DB Password: <password> 5) Created a DB Using phpMyAdmin called nagios. Created a user named nagios and gave full control of the nagios DataBase to user nagios. NOTE: This step does not have to be done if a DB user has already been established - Sorry I will not cover this. This user will need the following DB permissions to the nagios database: SELECT, INSERT, UPDATE, DELETE and CREATE. CREATE is only needed for the next step so it can be revoked afterwords. 6) Run: mysql --user=nagios --password=<password> nagios \ < /tmp/nagios-1.1/contrib/database/create_mysql NOTE: I use the nagios user so I can make sure the appropriate DB permission have been set. On Tue, 2003-11-25 at 02:13, k.l. muthu kumar wrote: <BLOCKQUOTE TYPE=CITE> <PRE>I have installed nagios in redhat 9 using rpm. now i would like to have mysql database support for nagios. can anyone tellme how to configure database support in this senario. Thanks, KLM Need a new email address that people can remember Check out the new EudoraMail at <A HREF="http://www.eudoramail.com">http://www.eudoramail.com</A> ------------------------------------------------------- This SF.net email is sponsored by: SF.net Giveback Program. Does SourceForge.net help you be more productive? Does it help you create better code? SHARE THE LOVE, and help us help YOU! Click Here: <A HREF="http://sourceforge.net/donate/">http://sourceforge.net/donate/</A> _______________________________________________ Nagios-users mailing list Nagios-users@lists.sourceforge.net <A HREF="https://lists.sourceforge.net/lists/listinfo/nagios-users">https://lists.sourceforge.net/lists/listinfo/nagios-users</A> ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null</PRE> </BLOCKQUOTE> <PRE><TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%"> <TR> <TD> <PRE>-- Jamie Bohr Agilent Technologies, Inc. IT | Technical Computing 719-590-2396 Jamie_Bohr@Agilent.com</PRE> </TD> </TR> </TABLE> </PRE> </BODY> </HTML>