Thanks!! That was it. I couldn't find that anywhere.... 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%>"Daniel Tran" <dtran@ssc.ucla.edu> 08/21/2003 11:02 AM <table border> <tr valign=top> <td bgcolor=white> <div align=center>Please respond to <dtran@ssc.ucla.edu></div></table> <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> Run ./configure --with-mysql-xdata --with-mysql-downtime --with-mysql-comments --with-mysql-status --with-mysql-retention --with-mysql-extinfo --with-mysql-lib=/usr/lib/mysql --with-mysql-inc=/usr/include/mysql note: --with-mysql-lib and --with-mysql-inc pointing the right directory where your lib and include are installed. Daniel ps: I can never get nagios to run correctly with mysql. May you can and later on help me. -----Original Message----- From: nagios-users-admin@lists.sourceforge.net [mailto:nagios-users-admin@lists.sourceforge.net] On Behalf Of Steve OBrien Sent: Thursday, August 21, 2003 7:41 AM To: nagios-users@lists.sourceforge.net Subject: [Nagios-users] Errors making Nagios with mysql 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