Errors making Nagios with mysql

[Steve OBrien]

Thanks!!  That was it.  I couldn't find that anywhere....

Steve O'Brien
City of Bend
Network Administrator
sobrien at ci.bend.or.us
541-322-6393



"Daniel Tran" <dtran at ssc.ucla.edu> 
08/21/2003 11:02 AM
Please respond to
<dtran at ssc.ucla.edu>


To
"'Steve OBrien'" <sobrien at ci.bend.or.us>
cc

Subject
RE: [Nagios-users] Errors making Nagios with mysql






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 at lists.sourceforge.net 
[mailto:nagios-users-admin at lists.sourceforge.net] On Behalf Of Steve 
OBrien
Sent: Thursday, August 21, 2003 7:41 AM
To: nagios-users at 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 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/45acd545/attachment.html>