Nagios And MySQL

[Andreas Ericsson]

Magnus Hultgren wrote:
> Hi! Here is another newbee question.
> 
> I'm trying to compile Nagios with MySQL support to use it with NagMin.
> 
> The configuration seems to go ok, but when I try to make all it stops with
> the errors below.
> 
> Anyone that got a clue to put me on the right track?
> 
> Best regards. Magnus.
> 
>  
> 
> /tmp/cc4yCYzT.o(.text+0x378): In function `xrddb_initialize':
> 
> ../xdata/xrddb.c:215: undefined reference to `mysql_init'
> 
> /tmp/cc4yCYzT.o(.text+0x3f2): In function `xrddb_connect':
> 
> ../xdata/xrddb.c:252: undefined reference to `mysql_real_connect'
> 
> /tmp/cc4yCYzT.o(.text+0x40f):../xdata/xrddb.c:254: undefined reference to
> `mysql_close'
> 
> /tmp/cc4yCYzT.o(.text+0x464): In function `xrddb_disconnect':
> 
> ../xdata/xrddb.c:299: undefined reference to `mysql_close'
> 
> /tmp/cc4yCYzT.o(.text+0x47c): In function `xrddb_query':
> 
> ../xdata/xrddb.c:329: undefined reference to `mysql_query'
> 
> /tmp/cc4yCYzT.o(.text+0xd5c): In function `xrddb_read_program_information':
> 
> ../xdata/xrddb.c:850: undefined reference to `mysql_store_result'
> 
> /tmp/cc4yCYzT.o(.text+0xd86):../xdata/xrddb.c:854: undefined reference to
> `mysql_fetch_row'
> 
> /tmp/cc4yCYzT.o(.text+0xe4c):../xdata/xrddb.c:867: undefined reference to
> `mysql_free_result'
> 
> /tmp/cc4yCYzT.o(.text+0xf00): In function `xrddb_read_host_information':
> 
> ./xdata/xrddb.c:951: undefined reference to `mysql_store_result'
> 
> /tmp/cc4yCYzT.o(.text+0xf2a):../xdata/xrddb.c:951: undefined reference to
> `mysql_fetch_row'
> 
> /tmp/cc4yCYzT.o(.text+0x10ec):../xdata/xrddb.c:1004: undefined reference to
> `mysql_free_result'
> 
> /tmp/cc4yCYzT.o(.text+0x1178): In function `xrddb_read_service_information':
> 
> ../xdata/xrddb.c:1129: undefined reference to `mysql_store_result'
> 
> /tmp/cc4yCYzT.o(.text+0x11a2):../xdata/xrddb.c:1129: undefined reference to
> `mysql_fetch_row'
> 
> /tmp/cc4yCYzT.o(.text+0x13f1):../xdata/xrddb.c:1195: undefined reference to
> `mysql_free_result'
> 
> /tmp/ccuFMvFo.o(.text+0x37c): In function `xcddb_initialize':
> 
> ../xdata/xcddb.c:234: undefined reference to `mysql_init'
> 
> /tmp/ccuFMvFo.o(.text+0x3ee): In function `xcddb_connect':
> 
> ../xdata/xcddb.c:259: undefined reference to `mysql_real_connect'
> 
> /tmp/ccuFMvFo.o(.text+0x40b):../xdata/xcddb.c:261: undefined reference to
> `mysql_close'
> 
> /tmp/ccuFMvFo.o(.text+0x460): In function `xcddb_disconnect':
> 
> ./xdata/xcddb.c:303: undefined reference to `mysql_close'
> 
> /tmp/ccuFMvFo.o(.text+0x478): In function `xcddb_query':
> 
> ../xdata/xcddb.c:329: undefined reference to `mysql_query'
> 
> /tmp/ccuFMvFo.o(.text+0x5c0): In function `xcddb_validate_host_comments':
> 
> ../xdata/xcddb.c:477: undefined reference to `mysql_store_result'
> 
> /tmp/ccuFMvFo.o(.text+0x5d9):../xdata/xcddb.c:477: undefined reference to
> `mysql_fetch_row'
> 
> /tmp/ccuFMvFo.o(.text+0x66c): In function `xcddb_validate_service_comments':
> 
> ../xdata/xcddb.c:566: undefined reference to `mysql_store_result'
> 
> /tmp/ccuFMvFo.o(.text+0x685):../xdata/xcddb.c:566: undefined reference to
> `mysql_fetch_row'
> 
> /tmp/ccuFMvFo.o(.text+0x7fa): In function `xcddb_save_host_comment':
> 
> ../xdata/xcddb.c:748: undefined reference to `mysql_insert_id'
> 
> /tmp/ccuFMvFo.o(.text+0x9ca): In function `xcddb_save_service_comment':
> 
> ../xdata/xcddb.c:847: undefined reference to `mysql_insert_id'
> 
> /tmp/ccms06uZ.o(.text+0x3e8): In function `xsddb_initialize':
> 
> ./xdata/xsddb.c:253: undefined reference to `mysql_init'
> 
> /tmp/ccms06uZ.o(.text+0x462): In function `xsddb_connect':
> 
> ../xdata/xsddb.c:286: undefined reference to `mysql_real_connect'
> 
> /tmp/ccms06uZ.o(.text+0x47f):../xdata/xsddb.c:288: undefined reference to
> `mysql_close'
> 
> /tmp/ccms06uZ.o(.text+0x4e4): In function `xsddb_disconnect':
> 
> ../xdata/xsddb.c:335: undefined reference to `mysql_close'
> 
> /tmp/ccms06uZ.o(.text+0x4fc): In function `xsddb_check_connection':
> 
> ../xdata/xsddb.c:363: undefined reference to `mysql_errno'
> 
> /tmp/ccms06uZ.o(.text+0x525):../xdata/xsddb.c:369: undefined reference to
> `mysql_close'
> 
> /tmp/ccms06uZ.o(.text+0x664): In function `xsddb_query':
> 
> ../xdata/xsddb.c:463: undefined reference to `mysql_query'
> 
> /tmp/cckI1Opk.o(.text+0x37c): In function `xdddb_initialize':
> 
> ../xdata/xdddb.c:234: undefined reference to `mysql_init'
> 
> /tmp/cckI1Opk.o(.text+0x3ee): In function `xdddb_connect':
> 
> ../xdata/xdddb.c:259: undefined reference to `mysql_real_connect'
> 
> /tmp/cckI1Opk.o(.text+0x40b):../xdata/xdddb.c:261: undefined reference to
> `mysql_close'
> 
> /tmp/cckI1Opk.o(.text+0x460): In function `xdddb_disconnect':
> 
> ../xdata/xdddb.c:303: undefined reference to `mysql_close'
> 
> /tmp/cckI1Opk.o(.text+0x478): In function `xdddb_query':
> 
> ../xdata/xdddb.c:329: undefined reference to `mysql_query'
> 
> /tmp/cckI1Opk.o(.text+0x57d): In function `xdddb_validate_host_downtime':
> 
> ../xdata/xdddb.c:473: undefined reference to `mysql_store_result'
> 
> /tmp/cckI1Opk.o(.text+0x595):../xdata/xdddb.c:473: undefined reference to
> `mysql_fetch_row'
> 
> /tmp/cckI1Opk.o(.text+0x651): In function `xdddb_validate_service_downtime':
> 
> ../xdata/xdddb.c:587: undefined reference to `mysql_store_result'
> 
> /tmp/cckI1Opk.o(.text+0x669):../xdata/xdddb.c:587: undefined reference to
> `mysql_fetch_row'
> 
> /tmp/cckI1Opk.o(.text+0x80a): In function `xdddb_save_host_downtime':
> 
> ../xdata/xdddb.c:788: undefined reference to `mysql_insert_id'
> 
> /tmp/cckI1Opk.o(.text+0x9e2): In function `xdddb_save_service_downtime':
> 
> ../xdata/xdddb.c:887: undefined reference to `mysql_insert_id'
> 
> /tmp/cckI1Opk.o(.text+0xc11): In function `xdddb_read_host_downtime':
> 
> ../xdata/xdddb.c:1107: undefined reference to `mysql_store_result'
> 
> /tmp/cckI1Opk.o(.text+0xc35):../xdata/xdddb.c:1107: undefined reference to
> `mysql_fetch_row'
> 
> /tmp/cckI1Opk.o(.text+0xd17):../xdata/xdddb.c:1116: undefined reference to
> `mysql_free_result'
> 
> /tmp/cckI1Opk.o(.text+0xd34):../xdata/xdddb.c:1149: undefined reference to
> `mysql_free_result'
> 
> /tmp/cckI1Opk.o(.text+0xd89): In function `xdddb_read_service_downtime':
> 
> ../xdata/xdddb.c:1238: undefined reference to `mysql_store_result'
> 
> /tmp/cckI1Opk.o(.text+0xdad):../xdata/xdddb.c:1238: undefined reference to
> `mysql_fetch_row'
> 
> /tmp/cckI1Opk.o(.text+0xe93):../xdata/xdddb.c:1247: undefined reference to
> `mysql_free_result'
> 
> /tmp/cckI1Opk.o(.text+0xeb0):../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/nn/nagios/nagios-1.2/base'
> 
> make: *** [all] Error 2
> 

You need the mysql-devel (and possibly mysql-shared) package(s), which 
contains the header files and DSO's required for compilation. Why the 
./configure-script detected it if it isn't available, I don't know...

-- 
Andreas Ericsson
OP5 AB
+46 (0)733 709032
andreas.ericsson at op5.se


-------------------------------------------------------
This SF.Net email is sponsored by: SourceForge.net Broadband
Sign-up now for SourceForge Broadband and get the fastest
6.0/768 connection for only $19.95/mo for the first 3 months!
http://ads.osdn.com/?ad_id=2562&alloc_id=6184&op=click
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null