about to rack my brain with a mySQL install

[Brian M. Weir]

Any help?  In advance...I SAY THANK YOU! :-)

Heres the deal:

I am trying to compile nagios1.0b5 with mySQL support.  I am going to give
as much detail as I can, becuase I think I am horribly forgetting something.

heres the way the machine is set up:

mysql install : /usr/local/mysql
nagios install :/home/myhomedir/nagios-source-dir


heres what I have done:

1. Issued a configure with:

./configure --prefix=/usr/local/nagios --sysconfdir=/usr/local/etc/nagios
--with-nagios-user=nagios --with-nagios-grp=nagios
--with-mail=/usr/lib/sendmail --with-mysql-xdata
--with-mysql-lib=/usr/local/mysql/lib
--with-mysql-inc=/usr/local/mysql/include --enable-embedded-perl

2.  Config went okay with no errors

3.  Did a make all, and got:

gcc -g -O2 -I/usr/local/mysql/include  -fno-strict-aliasing
-I/usr/lib/perl5/5.6.0/i386-linux/CORE  -DHAVE_CONFIG_H -DNSCORE
-L/usr/local/mysql/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
-L/usr/local/lib
/usr/lib/perl5/5.6.0/i386-linux/auto/DynaLoader/DynaLoader.a
-L/usr/lib/perl5/5.6.0/i386-linux/CORE -lperl -lnsl -ldl -lm -lc -lcrypt -lm
-o nagios
../xdata/xrddb.c:41:25: mysql/mysql.h: No such file or directory
../xdata/xrddb.c:42:26: mysql/errmsg.h: No such file or directory
../xdata/xcddb.c:49:25: mysql/mysql.h: No such file or directory
../xdata/xcddb.c:50:26: mysql/errmsg.h: No such file or directory
../xdata/xsddb.c:46:25: mysql/mysql.h: No such file or directory
../xdata/xsddb.c:47:26: mysql/errmsg.h: No such file or directory
../xdata/xdddb.c:49:25: mysql/mysql.h: No such file or directory
../xdata/xdddb.c:50:26: mysql/errmsg.h: No such file or directory
make[1]: *** [nagios] Error 1

4.  So I went to the xdata/ directory and changed the
mysql/insertheadernamehere.h
to just include <insertheadernamehere.h> for each of the .c files in xdata.

5.  I ran a make clean, and issued the same configure statement.

6.  Then I get this after running a make all:

/home/brian/nagios/nagios-1.0b5/base/../xdata/xrddb.c:215: undefined
reference to `mysql_init'
/tmp/cco0NcAT.o: In function `xrddb_connect':
/home/brian/nagios/nagios-1.0b5/base/../xdata/xrddb.c:252: undefined
reference to `mysql_real_connect'
/home/brian/nagios/nagios-1.0b5/base/../xdata/xrddb.c:254: undefined
reference to `mysql_close'
/tmp/cco0NcAT.o: In function `xrddb_disconnect':
/home/brian/nagios/nagios-1.0b5/base/../xdata/xrddb.c:299: undefined
reference to `mysql_close'
/tmp/cco0NcAT.o: In function `xrddb_query':
/home/brian/nagios/nagios-1.0b5/base/../xdata/xrddb.c:329: undefined
reference to `mysql_query'
/tmp/cco0NcAT.o: In function `xrddb_read_program_information':
/home/brian/nagios/nagios-1.0b5/base/../xdata/xrddb.c:850: undefined
reference to `mysql_store_result'
/home/brian/nagios/nagios-1.0b5/base/../xdata/xrddb.c:854: undefined
reference to `mysql_fetch_row'
/home/brian/nagios/nagios-1.0b5/base/../xdata/xrddb.c:867: undefined
reference to `mysql_free_result'
/tmp/cco0NcAT.o: In function `xrddb_read_host_information':
/home/brian/nagios/nagios-1.0b5/base/../xdata/xrddb.c:951: undefined
reference to `mysql_store_result'
/home/brian/nagios/nagios-1.0b5/base/../xdata/xrddb.c:1001: undefined
reference to `mysql_fetch_row'
/home/brian/nagios/nagios-1.0b5/base/../xdata/xrddb.c:1004: undefined
reference to `mysql_free_result'
/tmp/cco0NcAT.o: In function `xrddb_read_service_information':
/home/brian/nagios/nagios-1.0b5/base/../xdata/xrddb.c:1129: undefined
reference to `mysql_store_result'
/home/brian/nagios/nagios-1.0b5/base/../xdata/xrddb.c:1192: undefined
reference to `mysql_fetch_row'
/home/brian/nagios/nagios-1.0b5/base/../xdata/xrddb.c:1195: undefined
reference to `mysql_free_result'
/tmp/cc0UYAO8.o: In function `xcddb_initialize':
/home/brian/nagios/nagios-1.0b5/base/../xdata/xcddb.c:234: undefined
reference to `mysql_init'
/tmp/cc0UYAO8.o: In function `xcddb_connect':
/home/brian/nagios/nagios-1.0b5/base/../xdata/xcddb.c:259: undefined
reference to `mysql_real_connect'
/home/brian/nagios/nagios-1.0b5/base/../xdata/xcddb.c:261: undefined
reference to `mysql_close'
/tmp/cc0UYAO8.o: In function `xcddb_disconnect':
/home/brian/nagios/nagios-1.0b5/base/../xdata/xcddb.c:303: undefined
reference to `mysql_close'
/tmp/cc0UYAO8.o: In function `xcddb_query':
/home/brian/nagios/nagios-1.0b5/base/../xdata/xcddb.c:329: undefined
reference to `mysql_query'
/tmp/cc0UYAO8.o: In function `xcddb_validate_host_comments':
/home/brian/nagios/nagios-1.0b5/base/../xdata/xcddb.c:477: undefined
reference to `mysql_store_result'
/home/brian/nagios/nagios-1.0b5/base/../xdata/xcddb.c:489: undefined
reference to `mysql_fetch_row'
/tmp/cc0UYAO8.o: In function `xcddb_validate_service_comments':
/home/brian/nagios/nagios-1.0b5/base/../xdata/xcddb.c:566: undefined
reference to `mysql_store_result'
/home/brian/nagios/nagios-1.0b5/base/../xdata/xcddb.c:578: undefined
reference to `mysql_fetch_row'
/tmp/cc0UYAO8.o: In function `xcddb_save_host_comment':
/home/brian/nagios/nagios-1.0b5/base/../xdata/xcddb.c:748: undefined
reference to `mysql_insert_id'
/tmp/cc0UYAO8.o: In function `xcddb_save_service_comment':
/home/brian/nagios/nagios-1.0b5/base/../xdata/xcddb.c:847: undefined
reference to `mysql_insert_id'
/tmp/ccMBLgaS.o: In function `xsddb_initialize':
/home/brian/nagios/nagios-1.0b5/base/../xdata/xsddb.c:253: undefined
reference to `mysql_init'
/tmp/ccMBLgaS.o: In function `xsddb_connect':
/home/brian/nagios/nagios-1.0b5/base/../xdata/xsddb.c:286: undefined
reference to `mysql_real_connect'
/home/brian/nagios/nagios-1.0b5/base/../xdata/xsddb.c:288: undefined
reference to `mysql_close'
/tmp/ccMBLgaS.o: In function `xsddb_disconnect':
/home/brian/nagios/nagios-1.0b5/base/../xdata/xsddb.c:335: undefined
reference to `mysql_close'
/tmp/ccMBLgaS.o: In function `xsddb_check_connection':
/home/brian/nagios/nagios-1.0b5/base/../xdata/xsddb.c:363: undefined
reference to `mysql_errno'
/home/brian/nagios/nagios-1.0b5/base/../xdata/xsddb.c:369: undefined
reference to `mysql_close'
/tmp/ccMBLgaS.o: In function `xsddb_query':
/home/brian/nagios/nagios-1.0b5/base/../xdata/xsddb.c:463: undefined
reference to `mysql_query'
/tmp/ccJSkzk7.o: In function `xdddb_initialize':
/home/brian/nagios/nagios-1.0b5/base/../xdata/xdddb.c:234: undefined
reference to `mysql_init'
/tmp/ccJSkzk7.o: In function `xdddb_connect':
/home/brian/nagios/nagios-1.0b5/base/../xdata/xdddb.c:259: undefined
reference to `mysql_real_connect'
/home/brian/nagios/nagios-1.0b5/base/../xdata/xdddb.c:261: undefined
reference to `mysql_close'
/tmp/ccJSkzk7.o: In function `xdddb_disconnect':
/home/brian/nagios/nagios-1.0b5/base/../xdata/xdddb.c:303: undefined
reference to `mysql_close'
/tmp/ccJSkzk7.o: In function `xdddb_query':
/home/brian/nagios/nagios-1.0b5/base/../xdata/xdddb.c:329: undefined
reference to `mysql_query'
/tmp/ccJSkzk7.o: In function `xdddb_validate_host_downtime':
/home/brian/nagios/nagios-1.0b5/base/../xdata/xdddb.c:473: undefined
reference to `mysql_store_result'
/home/brian/nagios/nagios-1.0b5/base/../xdata/xdddb.c:494: undefined
reference to `mysql_fetch_row'
/tmp/ccJSkzk7.o: In function `xdddb_validate_service_downtime':
/home/brian/nagios/nagios-1.0b5/base/../xdata/xdddb.c:587: undefined
reference to `mysql_store_result'
/home/brian/nagios/nagios-1.0b5/base/../xdata/xdddb.c:608: undefined
reference to `mysql_fetch_row'
/tmp/ccJSkzk7.o: In function `xdddb_save_host_downtime':
/home/brian/nagios/nagios-1.0b5/base/../xdata/xdddb.c:788: undefined
reference to `mysql_insert_id'
/tmp/ccJSkzk7.o: In function `xdddb_save_service_downtime':
/home/brian/nagios/nagios-1.0b5/base/../xdata/xdddb.c:887: undefined
reference to `mysql_insert_id'
/tmp/ccJSkzk7.o: In function `xdddb_read_host_downtime':
/home/brian/nagios/nagios-1.0b5/base/../xdata/xdddb.c:1107: undefined
reference to `mysql_store_result'
/home/brian/nagios/nagios-1.0b5/base/../xdata/xdddb.c:1116: undefined
reference to `mysql_free_result'
/home/brian/nagios/nagios-1.0b5/base/../xdata/xdddb.c:1146: undefined
reference to `mysql_fetch_row'
/home/brian/nagios/nagios-1.0b5/base/../xdata/xdddb.c:1149: undefined
reference to `mysql_free_result'
/tmp/ccJSkzk7.o: In function `xdddb_read_service_downtime':
/home/brian/nagios/nagios-1.0b5/base/../xdata/xdddb.c:1238: undefined
reference to `mysql_store_result'
/home/brian/nagios/nagios-1.0b5/base/../xdata/xdddb.c:1247: undefined
reference to `mysql_free_result'
/home/brian/nagios/nagios-1.0b5/base/../xdata/xdddb.c:1277: undefined
reference to `mysql_fetch_row'
/home/brian/nagios/nagios-1.0b5/base/../xdata/xdddb.c:1280: undefined
reference to `mysql_free_result'
collect2: ld returned 1 exit status
make[1]: *** [nagios] Error 1


I am completely lost.  Any suggestions would be greatly appeciated.

Thank you!

Brian



-------------------------------------------------------
This sf.net email is sponsored by: OSDN - Tired of that same old
cell phone?  Get a new here for FREE!
https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390