Problems compiling with status/map MYSQl functionality

[Browett, Darren]

Thanks for the response, that worked, now I have another problem,

/usr/local/src/nagios-1.1/base/../xdata/xdddb.c:1247: undefined
reference to `mysql_free_result'
usr/local/src/nagios-1.1/base/../xdata/xdddb.c:1280: undefined
reference to `my sql_free_result'
collect2: ld returned 1 exit status
make[1]: *** [nagios] Error 1
make[1]: Leaving directory `/usr/local/src/nagios-1.1/base'
make: *** [all] Error 2
 
I can't find any reference to collect2, and it doesn't make sense why I
get the undefined reference to mysql_free_result as I did a strings on
the lib directory
and it appears the function exists.

Darren

-----Original Message-----
From: Marc Powell [mailto:mpowell at ena.com] 
Sent: Thursday, October 30, 2003 8:41 AM
To: Browett, Darren; nagios-users at lists.sourceforge.net
Subject: RE: [Nagios-users] Problems compiling with status/map MYSQl
functionality


Try this --

cd /usr/local/mysql/include; ln -s ../include mysql
cd /usr/local/mysql/lib; ln -s ../lib mysql

I had the same problem with postgres. Nagios assumes that the mysql
files are in a folder named 'mysql' in the include and lib directories.

--
Marc

> -----Original Message-----
> From: Browett, Darren [mailto:dbrowett at coquitlam.ca]
> Sent: Thursday, October 30, 2003 10:19 AM
> To: nagios-users at lists.sourceforge.net
> 
> I am trying to add statusmap and mysql funcitionality and I am unable
to
> successfully compile
> a new object on Suse Linux Enterrprise 8.0.
> 
> My config statement is as follows :
> 
>  ./configure --prefix=/usr/local/nagios \
>              --with-cgiurl=/nagios/cgi \
>              --with-htmurl=/nagios \
>              --with-nagios-user=nagios \
>              --with-nagios-grp=nagios \
>              --with-mysql-xdata \
>              --with-mysql-inc=/usr/local/mysql/include \
>              --with-mysql-lib=/usr/local/mysql/lib \
>              --enable-statusmap \
>              --with-gd-lib=/usr/local/lib  \
>              --with-gd-inc=/usr/local/include
> 
> When I run this statement, everything look good, but when I run the
make
> all ...
> 
> the last couple of lines looks like this
> 
> ../xdata/xdddb.c: In function `xdddb_read_service_downtime':
> ../xdata/xdddb.c:1210: `MYSQL_RES' undeclared (first use in this
> function)
> ../xdata/xdddb.c:1210: `query_result' undeclared (first use in this
> function)
> ../xdata/xdddb.c:1211: `MYSQL_ROW' undeclared (first use in this
> function)
> ../xdata/xdddb.c:1211: parse error before "result_row"
> ../xdata/xdddb.c:1242: `result_row' undeclared (first use in this
> function)
> make[1]: *** [nagios] Error 1
> make[1]: Leaving directory `/usr/local/src/nagios-1.1/base'
> make: *** [all] Error 2
> 
> and looking further back  ....
> 
> cc1: warning: changing search order for system directory
> "/usr/local/include"
> cc1: warning:   as it has already been specified as a non-system
> directory
> cc1: warning: changing search order for system directory
> "/usr/local/include"
> cc1: warning:   as it has already been specified as a non-system
> directory
> ../xdata/xrddb.c:41:25: mysql/mysql.h: No such file or directory
> ../xdata/xrddb.c:42:26: mysql/errmsg.h: No such file or directory
> ../xdata/xrddb.c:59: parse error before "xrddb_mysql"
> 
> Am I missing something ??
> 
> Should I try postgresql instead ???
> 
> Any help and/or direction would be much appreciated.
> 
> Thanks
> 
> Darren
> 
> 
>
------------------------------------------------------------------------
> --------------------------------------------------
> Darren Browett P.Eng 						This
> message was transmitted
> Data Administrator		 				using
> 100% recycled electrons
> Information and Communication Technology
> City of Coquitlam
> P:(604)927 - 3614
> E:dbrowett at coquitlam.ca
>
------------------------------------------------------------------------
> ---------------------------------------------------
> 
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: SF.net Giveback Program.
> Does SourceForge.net help you be more productive?  Does it
> help you create better code?   SHARE THE LOVE, and help us help
> YOU!  Click Here: http://sourceforge.net/donate/
> _______________________________________________
> 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


-------------------------------------------------------
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?   SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
_______________________________________________
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