Nagios and Mysql

[ForMatPrO ForMatPrO]

Yeps, I've checked all the makefiles... they all
include the paths.

I also see the flags when compiling, so that seems
correct too.

Finally tried the ./configure without trailing
slashes... no luck :(

Well, I'll try messing around some more for a day and
then I'll give it a try with freebsd or openbsd, maybe
then I'll have some more luck.

Thx alot for all your help Jonathan, it is
appreciated!


 --- Jonathan Rozes <jrozes at vinton.com> wrote: > Check
*all* the Makefiles, not just the top-level
> one. In each, wherever
> CFLAGS and LDFLAGS are set, they should include the
> paths you specified in
> configure, something like this:
> 
> CFLAGS=-g -O2
> -I/root/mysql-3.23.53a-pc-linux-gnu-i686/include
> -fno-strict-aliasing
> -I/usr/libdata/perl5/i386-openbsd/5.6.1/CORE
> -DHAVE_CONFIG_H
> LDFLAGS=-L/root/mysql-3.23.53a-pc-linux-gnu-i686/lib
> -lmysqlclient
> 
> And when you run 'make all' you should see the
> compiler using these flags
> when compiling and linking the nagios binary.
> 
> I'm not sure how picky your compiler is, but another
> possibility is that you
> have trailing slashes in your configure arguments.
> Try rerunning configure
> without them if the Makefiles look okay.
> 
> jonathan
> 
> > -----Original Message-----
> > From: ForMatPrO ForMatPrO
> [mailto:formatpro at yahoo.co.uk]
> > Sent: Wednesday, November 27, 2002 12:47 PM
> > To: Jonathan Rozes;
> Nagios-users at lists.sourceforge.net
> > Subject: RE: [Nagios-users] Nagios and Mysql
> > 
> > 
> > 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
> >  

__________________________________________________
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