Errors making Nagios with mysql

[Steve OBrien]

I am getting errors when I make all after configuring Nagios with mysql 
support.  I have seen references to these errors on google and the fix was 
to put LDFLAGS= -L/usr/lib/mysql -lmysqlclient in your Makefile, well mine 
already had it in there.  Anyone else had this problem, I already know 
that DB support is questionable for the future but to me it makes no sense 
to log this data to flat files.

[root at localhost nagios-1.1]# make all
cd ./base && make
make[1]: Entering directory `/home/system/src/nagios-1.1/base'
gcc -g -O2 -I/usr/include/mysql -DHAVE_CONFIG_H -DNSCORE -L/usr/lib/mysql 
-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    -lm -o 
nagios
/tmp/cc1pKEPG.o(.text+0x378): In function `xrddb_initialize':
../xdata/xrddb.c:215: undefined reference to `mysql_init'
/tmp/cc1pKEPG.o(.text+0x3f2): In function `xrddb_connect':
../xdata/xrddb.c:252: undefined reference to `mysql_real_connect'
/tmp/cc1pKEPG.o(.text+0x40d):../xdata/xrddb.c:254: undefined reference to 
`mysql_close'
/tmp/cc1pKEPG.o(.text+0x464): In function `xrddb_disconnect':
../xdata/xrddb.c:299: undefined reference to `mysql_close'
/tmp/cc1pKEPG.o(.text+0x47c): In function `xrddb_query':
../xdata/xrddb.c:329: undefined reference to `mysql_query'
/tmp/cc1pKEPG.o(.text+0xd98): In function 
`xrddb_read_program_information':
../xdata/xrddb.c:850: undefined reference to `mysql_store_result'
/tmp/cc1pKEPG.o(.text+0xdb3):../xdata/xrddb.c:854: undefined reference to 
`mysql_fetch_row'
/tmp/cc1pKEPG.o(.text+0xe79):../xdata/xrddb.c:867: undefined reference to 
`mysql_free_result'
/tmp/cc1pKEPG.o(.text+0xf38): In function `xrddb_read_host_information':
../xdata/xrddb.c:951: undefined reference to `mysql_store_result'
/tmp/cc1pKEPG.o(.text+0xf62):../xdata/xrddb.c:951: undefined reference to 
`mysql_fetch_row'
/tmp/cc1pKEPG.o(.text+0x1124):../xdata/xrddb.c:1004: undefined reference 
to `mysql_free_result'
/tmp/cc1pKEPG.o(.text+0x11b8): In function 
`xrddb_read_service_information':
../xdata/xrddb.c:1129: undefined reference to `mysql_store_result'
/tmp/cc1pKEPG.o(.text+0x11e2):../xdata/xrddb.c:1129: undefined reference 
to `mysql_fetch_row'
/tmp/cc1pKEPG.o(.text+0x1431):../xdata/xrddb.c:1195: undefined reference 
to `mysql_free_result'
/tmp/ccTEGl8x.o(.text+0x378): In function `xcddb_initialize':
../xdata/xcddb.c:234: undefined reference to `mysql_init'
/tmp/ccTEGl8x.o(.text+0x3ea): In function `xcddb_connect':
../xdata/xcddb.c:259: undefined reference to `mysql_real_connect'
/tmp/ccTEGl8x.o(.text+0x405):../xdata/xcddb.c:261: undefined reference to 
`mysql_close'
/tmp/ccTEGl8x.o(.text+0x45c): In function `xcddb_disconnect':
../xdata/xcddb.c:303: undefined reference to `mysql_close'
/tmp/ccTEGl8x.o(.text+0x474): In function `xcddb_query':
../xdata/xcddb.c:329: undefined reference to `mysql_query'
/tmp/ccTEGl8x.o(.text+0x5c3): In function `xcddb_validate_host_comments':
../xdata/xcddb.c:477: undefined reference to `mysql_store_result'
/tmp/ccTEGl8x.o(.text+0x5dd):../xdata/xcddb.c:477: undefined reference to 
`mysql_fetch_row'
/tmp/ccTEGl8x.o(.text+0x673): In function 
`xcddb_validate_service_comments':
../xdata/xcddb.c:566: undefined reference to `mysql_store_result'
/tmp/ccTEGl8x.o(.text+0x68d):../xdata/xcddb.c:566: undefined reference to 
`mysql_fetch_row'
/tmp/ccTEGl8x.o(.text+0x806): In function `xcddb_save_host_comment':
../xdata/xcddb.c:748: undefined reference to `mysql_insert_id'
/tmp/ccTEGl8x.o(.text+0x9da): In function `xcddb_save_service_comment':
../xdata/xcddb.c:847: undefined reference to `mysql_insert_id'
/tmp/cciRZnh0.o(.text+0x3e4): In function `xsddb_initialize':
../xdata/xsddb.c:253: undefined reference to `mysql_init'
/tmp/cciRZnh0.o(.text+0x45e): In function `xsddb_connect':
../xdata/xsddb.c:286: undefined reference to `mysql_real_connect'
/tmp/cciRZnh0.o(.text+0x479):../xdata/xsddb.c:288: undefined reference to 
`mysql_close'
/tmp/cciRZnh0.o(.text+0x4e0): In function `xsddb_disconnect':
../xdata/xsddb.c:335: undefined reference to `mysql_close'
/tmp/cciRZnh0.o(.text+0x4f8): In function `xsddb_check_connection':
../xdata/xsddb.c:363: undefined reference to `mysql_errno'
/tmp/cciRZnh0.o(.text+0x571):../xdata/xsddb.c:369: undefined reference to 
`mysql_close'
/tmp/cciRZnh0.o(.text+0x670): In function `xsddb_query':
../xdata/xsddb.c:463: undefined reference to `mysql_query'
/tmp/ccFlpGYl.o(.text+0x378): In function `xdddb_initialize':
../xdata/xdddb.c:234: undefined reference to `mysql_init'
/tmp/ccFlpGYl.o(.text+0x3ea): In function `xdddb_connect':
../xdata/xdddb.c:259: undefined reference to `mysql_real_connect'
/tmp/ccFlpGYl.o(.text+0x405):../xdata/xdddb.c:261: undefined reference to 
`mysql_close'
/tmp/ccFlpGYl.o(.text+0x45c): In function `xdddb_disconnect':
../xdata/xdddb.c:303: undefined reference to `mysql_close'
/tmp/ccFlpGYl.o(.text+0x474): In function `xdddb_query':
../xdata/xdddb.c:329: undefined reference to `mysql_query'
/tmp/ccFlpGYl.o(.text+0x574): In function `xdddb_validate_host_downtime':
../xdata/xdddb.c:473: undefined reference to `mysql_store_result'
/tmp/ccFlpGYl.o(.text+0x58d):../xdata/xdddb.c:473: undefined reference to 
`mysql_fetch_row'
/tmp/ccFlpGYl.o(.text+0x64c): In function 
`xdddb_validate_service_downtime':
../xdata/xdddb.c:587: undefined reference to `mysql_store_result'
/tmp/ccFlpGYl.o(.text+0x665):../xdata/xdddb.c:587: undefined reference to 
`mysql_fetch_row'
/tmp/ccFlpGYl.o(.text+0x80a): In function `xdddb_save_host_downtime':
../xdata/xdddb.c:788: undefined reference to `mysql_insert_id'
/tmp/ccFlpGYl.o(.text+0x9e6): In function `xdddb_save_service_downtime':
../xdata/xdddb.c:887: undefined reference to `mysql_insert_id'
/tmp/ccFlpGYl.o(.text+0xc1d): In function `xdddb_read_host_downtime':
../xdata/xdddb.c:1107: undefined reference to `mysql_store_result'
/tmp/ccFlpGYl.o(.text+0xc41):../xdata/xdddb.c:1107: undefined reference to 
`mysql_fetch_row'
/tmp/ccFlpGYl.o(.text+0xd23):../xdata/xdddb.c:1116: undefined reference to 
`mysql_free_result'
/tmp/ccFlpGYl.o(.text+0xd40):../xdata/xdddb.c:1149: undefined reference to 
`mysql_free_result'
/tmp/ccFlpGYl.o(.text+0xd95): In function `xdddb_read_service_downtime':
../xdata/xdddb.c:1238: undefined reference to `mysql_store_result'
/tmp/ccFlpGYl.o(.text+0xdb9):../xdata/xdddb.c:1238: undefined reference to 
`mysql_fetch_row'
/tmp/ccFlpGYl.o(.text+0xe9f):../xdata/xdddb.c:1247: undefined reference to 
`mysql_free_result'
/tmp/ccFlpGYl.o(.text+0xebc):../xdata/xdddb.c:1280: undefined reference to 
`mysql_free_result'
collect2: ld returned 1 exit status
make[1]: *** [nagios] Error 1
make[1]: Leaving directory `/home/system/src/nagios-1.1/base'
make: *** [all] Error 2

Steve O'Brien
City of Bend
Network Administrator
sobrien at ci.bend.or.us
541-322-6393
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20030821/f3155249/attachment.html>