Compiling With MySQL Support

[carole verdon]

Look at this:
http://article.gmane.org/gmane.network.nagios.user/14423


Donahue, Pat wrote:

> Hi,
>  
> I'm having problems compiling with MySQL support. I've passed the 
> appropriate flags to the compiler (note that the db was installed as a 
> binary distribution):
>  
> ./configure --with-mysql-xdata --with-mysql-lib=/usr/local/mysql/lib 
> --with-mysql-inc=/usr/local/mysql/include
>  
> I was getting this error: ../xdata/xrddb.c:41: mysql/mysql.h: No such 
> file or directory
>  
> so I copied the includes into a subdirectory named mysql within 
> /usr/local/mysql/include. That took care of the missing header files. 
> The next problem was that gcc couldn't seem to find the appropriate 
> library files, even though I had specified them on the config command 
> line. As you can see the library directory is specified with -L and 
> the library itself is specified with -l. I tried removing these 
> LDFLAGS and just simply specifying the path to the library.. still no 
> luck.
>  
> Here is the current error:
>  
> # make all
> ...
> gcc -g -O2 -I/usr/local/mysql/include -DHAVE_CONFIG_H -DNSCORE 
> -L/usr/local/mysql/lib -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/ccokJN8q.o: In function `xrddb_initialize':
> /usr/local/src/nagios-1.2/base/../xdata/xrddb.c:224: undefined 
> reference to `mysql_init'
> /tmp/ccokJN8q.o: In function `xrddb_connect':
> /usr/local/src/nagios-1.2/base/../xdata/xrddb.c:286: undefined 
> reference to `mysql_real_connect'
> /usr/local/src/nagios-1.2/base/../xdata/xrddb.c:256: undefined 
> reference to `mysql_close'
> ...
>  
> Why can't Nagios find the MySQL library? During config it even claims 
> it can!
>  
> # ./configure --with-mysql-lib=/usr/local/mysql/lib 
> --with-mysql-inc=/usr/local/mysql/include --with-mysql-xdata
> ...
> We'll use MySQL database routines (in xdata/xsddb.*) for status data 
> I/O...
> We'll use MySQL database routines (in xdata/xcddb.*) for comment data 
> I/O...
> We'll use MySQL database routines (in xdata/xeddb.*) for extended data 
> I/O...
> We'll use MySQL database routines (in xdata/xrddb.*) for retention 
> data I/O...
> We'll use template-based routines (in xdata/xodtemplate.*) for object 
> data I/O...
> We'll use default routines (in xdata/xpddefault.*) for performance 
> data I/O...
> We'll use MySQL database routines (in xdata/xdddb.*) for scheduled 
> downtime data I/O...
> checking for main in -lmysqlclient... yes
> MySQL library was found!
>  
> Thanks in advance for the help,
> Pat
>

-- 
**********************************
VERDON Carole
Ingénieur Système
CICT - Université Paul Sabatier
118, route de Narbonne
31062 Toulouse Cedex
Tél.: 05.61.36.60.44
Fax: 05.61.52.14.58
Mail: verdon at cict.fr
**********************************	

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20040707/16248716/attachment.html>