Nagios and Mysql

[ForMatPrO ForMatPrO]

Yes, I should have posted more info, I'm sorry...

ok, I started the configure script like this:
"./configure --with-mysql-xdata
--with-mysql-lib=/root/mysql-3.23.53a-pc-linux-gnu-i686/lib/
--with-mysql-inc=/root/mysql-3.23.53a-pc-linux-gnu-i686/include/"

Evertything seemed to be OK.

Some output:

"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!
checking for gdImagePng in -lgd (order 1)... yes
GD library was found!"

So it found the Mysql library...

the makefile also has '-lmysqlclient' in LDFLAGS.

Then I got this with "make all":

../xdata/xsddb.c:46:25: mysql/mysql.h: No such file or
directory
../xdata/xsddb.c:47:26: mysql/errmsg.h: No such file
or directory

So I changed the path in xsddb.c, xcddb.c, etc... so
it got the correct location to mysql.h and errmsg.h
...

example:

#include
"/root/mysql-3.23.53a-pc-linux-gnu-i686/include/mysql.h"
#include
"/root/mysql-3.23.53a-pc-linux-gnu-i686/include/errmsg.h"

After that, I got all the "undefined reference to
`mysql" errors when I try to compile.

some output:

/tmp/ccuihhQ8.o: In function `xrddb_initialize':
/root/nagios-1.0/base/../xdata/xrddb.c:215: undefined
reference to `mysql_init'
/tmp/ccuihhQ8.o: In function `xrddb_connect':
/root/nagios-1.0/base/../xdata/xrddb.c:252: undefined
reference to `mysql_real_connect'
/root/nagios-1.0/base/../xdata/xrddb.c:254: undefined
reference to `mysql_close'/tmp/ccuihhQ8.o: In function
`xrddb_disconnect':
/root/nagios-1.0/base/../xdata/xrddb.c:299: undefined
reference to `mysql_close'/tmp/ccuihhQ8.o: In function
`xrddb_query':

--- Jonathan Rozes <jrozes at vinton.com> wrote: > I'm
sure lots of people have compiled it
> successfully. I have on OpenBSD 3.1
> and 3.2, for example. Can't really help you though
> since you haven't showed
> us what led you to your current situation. What
> flags did you invoke the
> configure script with? What was the output produced
> by the configure script?
> Does it say it found the mysql client library? Does
> the resulting Makefile
> have '-lmysqlclient' in LDFLAGS? Where are your
> mysql headers and libraries
> installed? How do you expect anybody to help you if
> you don't supply any
> useful information?
> 
> jonathan
> 
> > -----Original Message-----
> > From: ForMatPrO ForMatPrO
> [mailto:formatpro at yahoo.co.uk]
> > Sent: Tuesday, November 26, 2002 11:49 PM
> > To: Nagios-users at lists.sourceforge.net
> > Subject: [Nagios-users] Nagios and Mysql
> > 
> > 
> > Hi,
> > 
> > I still can't get Nagios with Mysql to work... Did
> > anyone compile nagios with mysql? If so, what OS
> did
> > you use?  Or does anyone know with what OS it
> should
> > work right out the box?
> > 
> > I still get the "undefined reference to `mysql"
> errors
> > while compiling :/
> > 
> > Thx.


__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com


-------------------------------------------------------
This SF.net email is sponsored by: Get the new Palm Tungsten T 
handheld. Power & Color in a compact size! 
http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0002en