nagios access mysql database

[Javier Garcia]

Hi Marcelo,

I see what is your problem. The parameters in the ./configure script are
OK. The problem is that you really don't have the library. Nagios look for
a file named mysql.h. This file must be in the include folder. You need
to install mysql-devel-** in your system. Search the appropiate rpm
package for your RedHat system.
After, run again the scrip. This must work.

Regards,

j.

----
Javier Garcia
SuSE Linux C.A.
jgarcia at suse.com.ve
0416-8678334


On Sat, 3 Apr 2004, [iso-8859-1] Marcos & Marcelo wrote:

> Hi,
>
>    I'm using RedHat 9, Nagios 1.2, mysql 4.0.18 and
> I'm trying to configure Nagios
>    access the Mysql database. When I'm going to
> execute
>    ./configure --cache-file=confx.cache
> --prefix=/usr/local/nagios
>    --with-cgiurl=/nagios/cgi-bin --with-htmurl=/nagios
> --with-nagios-user=nagios
>    --with-nagios-grp=nagios --with-mysql-xdata
> --with-mysql-lib=/usr/local/mysql/lib/mysql/
>    --with-mysql-inc=/usr/local/mysql/include/mysql/
>    I receive an error message like that
>
>    *** MySQL library could not be located...
> **************************
> You chose to compile Nagios with MySQL support, but I
> was unable to
> locate the MySQL library on your system.  If the
> library is
> installed,  use the --with-mysql-lib and
> --with-mysql-inc arguments
> to specify the locations of the MySQL library and
> include files.
>
> NOTE: After you install the necessary libraries on
> your system:
>       1. Make sure /etc/ld.so.conf has an entry for
> the directory in
>          which the MySQL libraries are installed.
>       2. Run 'ldconfig' to update the run-time linker
> options.
>       3. Run 'make clean' in the Nagios distribution
> to clean out
>          any old references to your previous compile.
>       4. Rerun the configure script.
>
> ********************************************************************
>      Then, I looked to the file /etc/ld.so.conf
> 	/usr/local/mysql/lib/mysql
> 	/usr/local/mysql/include/mysql
> 	/usr/kerberos/lib
> 	/usr/X11R6/lib
> 	/usr/lib/sane
> 	/usr/lib/qt-3.1/lib
>      After that, I looked to the directory which there
> are the library and the includes files
>      root at localhost mysql]# ls
> /usr/local/mysql/lib/mysql
> 	libdbug.a    libmyisammrg.a     libmysqlclient.so.12
>     libnisam.a
> 	libheap.a    libmysqlclient.a
> libmysqlclient.so.12.0.0  libvio.a
> 	libmerge.a   libmysqlclient.la  libmystrings.a
> 	libmyisam.a  libmysqlclient.so  libmysys.a
>
> 	[root at localhost mysql]# ls
> /usr/local/mysql/include/mysql
> 	chardefs.h  my_alloc.h   my_list.h
> mysqld_error.h   readline.h
> 	errmsg.h    my_config.h  my_net.h
> mysql_embed.h    sslopt-case.h
> 	history.h   my_dbug.h    my_no_pthread.h  mysql.h
>      sslopt-longopts.h
> 	keymaps.h   my_dir.h     my_pthread.h
> mysql_version.h  sslopt-vars.h
> 	m_ctype.h   my_getopt.h  my_semaphore.h   my_sys.h
>      tilde.h
> 	m_string.h  my_global.h  mysql_com.h      raid.h
>
>      So, I don't know why nagios can not find the
> Mysql libary? Can anybody help me? Do I miss any
> parameter in the ./configure command?
>
>  Thanks,
>  Marcelo
>
>
> ______________________________________________________________________
>
> Yahoo! Mail - O melhor e-mail do Brasil! Abra sua conta agora:
> http://br.yahoo.com/info/mail.html
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> 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
>


-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
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