Whoops, no this is the solution that worked for me not the last.... Sorry. Steve O'Brien City of Bend Network Administrator sobrien@ci.bend.or.us 541-322-6393 <table width=100%> <tr valign=top> <td width=40%>tnelson@starpoint.com 08/21/2003 11:42 AM <td width=59%> <table width=100%> <tr> <td> <div align=right>To</div> <td valign=top>Steve OBrien <sobrien@ci.bend.or.us> <tr> <td> <div align=right>cc</div> <td valign=top> <tr> <td> <div align=right>Subject</div> <td valign=top>Re: [Nagios-users] Errors making Nagios with mysql</table> <table> <tr valign=top> <td> <td></table> </table> I got those same errors.. it has to do w/ the way the makefile is written (at least on slackware 9.0).. find the link lines in the make files.. and add -lmysqlclient -lz jusr before -o .. example.. from my base/Makefile nagios: nagios.c $(OBJS) nagios.h $(SRC_COMMON)/locations.h $(CC) $(CFLAGS) $(LDFLAGS) nagios.c $(OBJS) $(PERLLIBS) $(MATHLIBS) -lmysqlclient -lz -o $@ It seems that the version of ld we have doesn't hang on to the symbols unless the libs are at the end.. Tony Nelson Director of IT Operations Starpoint Solutions 115 Broadway, 2nd Fl. New York, NY 10006 <table width=100%> <tr valign=top> <td width=2%> <td width=42%>Steve OBrien <sobrien@ci.bend.or.us> Sent by: nagios-users-admin@lists.sourceforge.net 08/21/2003 10:40 AM <td width=54%> To: <nagios-users@lists.sourceforge.net> cc: Subject: [Nagios-users] Errors making Nagios with mysql</table> 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@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@ci.bend.or.us 541-322-6393