<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1400" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I'm still trying to get Nagios, Fedora and MySQL to
play happy together.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I seem to configure OK but as soon as i try and
make it bombs. Below is my configure and the error thrown when i 'make
all'</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>./configure --prefix=/opt/nagios-1.2
--with-nagios-user=nagios --with-nagios-grp=nagios --with-mail=/bin/mail
--with-mysql-lib=/opt/mysql/lib --with-mysql-inc=/opt/mysql/include
--with-gd-lib=/opt/gd/lib --with-gd-inc=/opt/gd/include
--with-cgiurl=/nagios/cgi-bin --with-htmurl=/nagios --enable-embedded-perl
--with-perlcache --with-init-dir=/etc/rc.d/init.d
--with-lockfile=/opt/nagios-1.2/var/nagios.lock --with-mysql-xdata
--with-mysql-status --with-mysql-comments --with-mysql-extinfo
--with-mysql-retention --with-mysql-downtime</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>This runs fine however a 'make all' throws the
following (sorry for the long paste)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2># make all<BR>cd ./base && make<BR>make[1]:
Entering directory `/home/tom/source/nagios-1.2/base'<BR>gcc -g -O2
-I/opt/mysql/include -I/opt/gd/include -D_REENTRANT -D_GNU_SOURCE
-DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm
-I/usr/lib/perl5/5.8.3/i386-linux-thread-multi/CORE -DHAVE_CONFIG_H
-DNSCORE -L/opt/mysql/lib -L/opt/gd/lib -lmysqlclient nagios.c checks.o
config.o commands.o flapping.o logging.o notifications.o sehandlers.o utils.o
sretention.o ../xdata/xrddb.c ../common/comments.c ../xdata/xcddb.c
../common/objects.c ../xdata/xodtemplate.c ../common/statusdata.c
../xdata/xsddb.c perfdata.o ../xdata/xpddefault.c ../common/downtime.c
../xdata/xdddb.c -rdynamic
-Wl,-rpath,/usr/lib/perl5/5.8.3/i386-linux-thread-multi/CORE
-L/usr/local/lib
/usr/lib/perl5/5.8.3/i386-linux-thread-multi/auto/DynaLoader/DynaLoader.a
-L/usr/lib/perl5/5.8.3/i386-linux-thread-multi/CORE -lperl -lnsl -ldl -lm
-lcrypt -lutil -lpthread -lc -lm -o nagios<BR>/tmp/ccwNa87n.o(.text+0x378): In
function `xrddb_initialize':<BR>../xdata/xrddb.c:215: undefined reference to
`mysql_init'<BR>/tmp/ccwNa87n.o(.text+0x3f2): In function
`xrddb_connect':<BR>../xdata/xrddb.c:252: undefined reference to
`mysql_real_connect'<BR>/tmp/ccwNa87n.o(.text+0x40f):../xdata/xrddb.c:254:
undefined reference to `mysql_close'<BR>/tmp/ccwNa87n.o(.text+0x464): In
function `xrddb_disconnect':<BR>../xdata/xrddb.c:299: undefined reference to
`mysql_close'<BR>/tmp/ccwNa87n.o(.text+0x47c): In function
`xrddb_query':<BR>../xdata/xrddb.c:329: undefined reference to
`mysql_query'<BR>/tmp/ccwNa87n.o(.text+0xd5c): In function
`xrddb_read_program_information':<BR>../xdata/xrddb.c:850: undefined reference
to `mysql_store_result'<BR>/tmp/ccwNa87n.o(.text+0xd86):../xdata/xrddb.c:854:
undefined reference to
`mysql_fetch_row'<BR>/tmp/ccwNa87n.o(.text+0xe4c):../xdata/xrddb.c:867:
undefined reference to `mysql_free_result'<BR>/tmp/ccwNa87n.o(.text+0xf00): In
function `xrddb_read_host_information':<BR>../xdata/xrddb.c:951: undefined
reference to
`mysql_store_result'<BR>/tmp/ccwNa87n.o(.text+0xf2a):../xdata/xrddb.c:951:
undefined reference to
`mysql_fetch_row'<BR>/tmp/ccwNa87n.o(.text+0x10ec):../xdata/xrddb.c:1004:
undefined reference to `mysql_free_result'<BR>/tmp/ccwNa87n.o(.text+0x1178): In
function `xrddb_read_service_information':<BR>../xdata/xrddb.c:1129: undefined
reference to
`mysql_store_result'<BR>/tmp/ccwNa87n.o(.text+0x11a2):../xdata/xrddb.c:1129:
undefined reference to
`mysql_fetch_row'<BR>/tmp/ccwNa87n.o(.text+0x13f1):../xdata/xrddb.c:1195:
undefined reference to `mysql_free_result'<BR>/tmp/ccwimMFA.o(.text+0x37c): In
function `xcddb_initialize':<BR>../xdata/xcddb.c:234: undefined reference to
`mysql_init'<BR>/tmp/ccwimMFA.o(.text+0x3ee): In function
`xcddb_connect':<BR>../xdata/xcddb.c:259: undefined reference to
`mysql_real_connect'<BR>/tmp/ccwimMFA.o(.text+0x40b):../xdata/xcddb.c:261:
undefined reference to `mysql_close'<BR>/tmp/ccwimMFA.o(.text+0x460): In
function `xcddb_disconnect':<BR>../xdata/xcddb.c:303: undefined reference to
`mysql_close'<BR>/tmp/ccwimMFA.o(.text+0x478): In function
`xcddb_query':<BR>../xdata/xcddb.c:329: undefined reference to
`mysql_query'<BR>/tmp/ccwimMFA.o(.text+0x5c0): In function
`xcddb_validate_host_comments':<BR>../xdata/xcddb.c:477: undefined reference to
`mysql_store_result'<BR>/tmp/ccwimMFA.o(.text+0x5d9):../xdata/xcddb.c:477:
undefined reference to `mysql_fetch_row'<BR>/tmp/ccwimMFA.o(.text+0x66c): In
function `xcddb_validate_service_comments':<BR>../xdata/xcddb.c:566: undefined
reference to
`mysql_store_result'<BR>/tmp/ccwimMFA.o(.text+0x685):../xdata/xcddb.c:566:
undefined reference to `mysql_fetch_row'<BR>/tmp/ccwimMFA.o(.text+0x7fa): In
function `xcddb_save_host_comment':<BR>../xdata/xcddb.c:748: undefined reference
to `mysql_insert_id'<BR>/tmp/ccwimMFA.o(.text+0x9ca): In function
`xcddb_save_service_comment':<BR>../xdata/xcddb.c:847: undefined reference to
`mysql_insert_id'<BR>/tmp/ccXxf6jB.o(.text+0x3e8): In function
`xsddb_initialize':<BR>../xdata/xsddb.c:253: undefined reference to
`mysql_init'<BR>/tmp/ccXxf6jB.o(.text+0x462): In function
`xsddb_connect':<BR>../xdata/xsddb.c:286: undefined reference to
`mysql_real_connect'<BR>/tmp/ccXxf6jB.o(.text+0x47f):../xdata/xsddb.c:288:
undefined reference to `mysql_close'<BR>/tmp/ccXxf6jB.o(.text+0x4e4): In
function `xsddb_disconnect':<BR>../xdata/xsddb.c:335: undefined reference to
`mysql_close'<BR>/tmp/ccXxf6jB.o(.text+0x4fc): In function
`xsddb_check_connection':<BR>../xdata/xsddb.c:363: undefined reference to
`mysql_errno'<BR>/tmp/ccXxf6jB.o(.text+0x525):../xdata/xsddb.c:369: undefined
reference to `mysql_close'<BR>/tmp/ccXxf6jB.o(.text+0x664): In function
`xsddb_query':<BR>../xdata/xsddb.c:463: undefined reference to
`mysql_query'<BR>/tmp/ccRMUPPF.o(.text+0x37c): In function
`xdddb_initialize':<BR>../xdata/xdddb.c:234: undefined reference to
`mysql_init'<BR>/tmp/ccRMUPPF.o(.text+0x3ee): In function
`xdddb_connect':<BR>../xdata/xdddb.c:259: undefined reference to
`mysql_real_connect'<BR>/tmp/ccRMUPPF.o(.text+0x40b):../xdata/xdddb.c:261:
undefined reference to `mysql_close'<BR>/tmp/ccRMUPPF.o(.text+0x460): In
function `xdddb_disconnect':<BR>../xdata/xdddb.c:303: undefined reference to
`mysql_close'<BR>/tmp/ccRMUPPF.o(.text+0x478): In function
`xdddb_query':<BR>../xdata/xdddb.c:329: undefined reference to
`mysql_query'<BR>/tmp/ccRMUPPF.o(.text+0x57d): In function
`xdddb_validate_host_downtime':<BR>../xdata/xdddb.c:473: undefined reference to
`mysql_store_result'<BR>/tmp/ccRMUPPF.o(.text+0x595):../xdata/xdddb.c:473:
undefined reference to `mysql_fetch_row'<BR>/tmp/ccRMUPPF.o(.text+0x651): In
function `xdddb_validate_service_downtime':<BR>../xdata/xdddb.c:587: undefined
reference to
`mysql_store_result'<BR>/tmp/ccRMUPPF.o(.text+0x669):../xdata/xdddb.c:587:
undefined reference to `mysql_fetch_row'<BR>/tmp/ccRMUPPF.o(.text+0x80a): In
function `xdddb_save_host_downtime':<BR>../xdata/xdddb.c:788: undefined
reference to `mysql_insert_id'<BR>/tmp/ccRMUPPF.o(.text+0x9e2): In function
`xdddb_save_service_downtime':<BR>../xdata/xdddb.c:887: undefined reference to
`mysql_insert_id'<BR>/tmp/ccRMUPPF.o(.text+0xc11): In function
`xdddb_read_host_downtime':<BR>../xdata/xdddb.c:1107: undefined reference to
`mysql_store_result'<BR>/tmp/ccRMUPPF.o(.text+0xc35):../xdata/xdddb.c:1107:
undefined reference to
`mysql_fetch_row'<BR>/tmp/ccRMUPPF.o(.text+0xd17):../xdata/xdddb.c:1116:
undefined reference to
`mysql_free_result'<BR>/tmp/ccRMUPPF.o(.text+0xd34):../xdata/xdddb.c:1149:
undefined reference to `mysql_free_result'<BR>/tmp/ccRMUPPF.o(.text+0xd89): In
function `xdddb_read_service_downtime':<BR>../xdata/xdddb.c:1238: undefined
reference to
`mysql_store_result'<BR>/tmp/ccRMUPPF.o(.text+0xdad):../xdata/xdddb.c:1238:
undefined reference to
`mysql_fetch_row'<BR>/tmp/ccRMUPPF.o(.text+0xe93):../xdata/xdddb.c:1247:
undefined reference to
`mysql_free_result'<BR>/tmp/ccRMUPPF.o(.text+0xeb0):../xdata/xdddb.c:1280:
undefined reference to `mysql_free_result'<BR>collect2: ld returned 1 exit
status<BR>make[1]: *** [nagios] Error 1<BR>make[1]: Leaving directory
`/home/tom/source/nagios-1.2/base'<BR>make: *** [all] Error 2</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>What can i di to try and resolve this - I really
need to have MySQL support compiled in to Nagios. If i exclude the MySQL config
then it will compile OK.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>thanks for any help - suggestions so far seem to
have not got me anywhere.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Tom</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>