<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40"> <head> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"> <meta name=Generator content="Microsoft Word 11 (filtered medium)"> <style>  </style> </head> <body lang=EN-US link=blue vlink=purple> <div class=Section1> Hi,<o:p></o:p> <o:p> </o:p> I'm having some problems getting Nagios 1.2 to compile using pgsql or mysql. I was asked to get it working with pgsql but I had no luck with either. I've set up lots of 'normal' Nagios servers but this is the first time I attempted to use a database instead of the normal log file.<o:p></o:p> <o:p> </o:p> The reason I was asked to set this up is so we could set up some automated email reports showing the total number alerts for servers etc once in a while.<o:p></o:p> <o:p> </o:p> I tried using postgre sql in RedHat9 with Nagios 1.2 and postgresql-7.3.2-3 / postgresql-server-7.3.2-3 / postgresql-libs-7.3.2-3 / postgresql-devel-7.3.2-3 from RedHat... Also I tried in CentOS 3.3 (free RedHat ES3 clone) using rh-postgresql-7.3.4-9 / rh-postgresql-devel-7.3.4-9 / rh-postgresql-libs-7.3.4-9 / rh-postgresql-docs-7.3.4-9 ... For MySQL I tried in CentOS 3.3 using MySQL 4.0.20 from mysql.com. I was going to try using something from postgre's website but it was having problems last night and I couldn't get the 'download' page to come up.<o:p></o:p> <o:p> </o:p> For both postgre and mysql the compile errors looked pretty similar. I could ./configure fine but make all would fail. Anyone have an idea of how to get this set up? I did some searching but couldn't find anything. I was asked to try to use postgre if possible though I'm much more used to mysql...<o:p></o:p> <o:p> </o:p> Cheers!<o:p></o:p> <o:p> </o:p> ####################################################################<o:p></o:p> <o:p> </o:p> ./configure --with-mysql-comments --with-mysql-extinfo --with-mysql-retention --with-mysql-downtime --with-mysql-status --with-mysql-xdata --with-mysql-lib=/var/lib/mysql/ --with-mysql-inc=/usr/include/mysql/<o:p></o:p> <o:p> </o:p> General Options:<o:p></o:p> -------------------------<o:p></o:p> Nagios executable: nagios<o:p></o:p> Nagios user/group: nagios,nagios<o:p></o:p> Command user/group: nagios,nagios<o:p></o:p> Embedded Perl: no<o:p></o:p> Install ${prefix}: /usr/local/nagios<o:p></o:p> Lock file: ${prefix}/var/nagios.lock<o:p></o:p> Init directory: /etc/rc.d/init.d<o:p></o:p> <o:p> </o:p> Web Interface Options:<o:p></o:p> ------------------------<o:p></o:p> HTML URL: http://localhost/nagios/<o:p></o:p> CGI URL: http://localhost/nagios/cgi-bin/<o:p></o:p> Traceroute (used by WAP): /bin/traceroute<o:p></o:p> <o:p> </o:p> External Data Routines:<o:p></o:p> ------------------------<o:p></o:p> Status data: Database (MySQL)<o:p></o:p> Object data: Template-based (text file)<o:p></o:p> Comment data: Database (MySQL)<o:p></o:p> Downtime data: Database (MySQL)<o:p></o:p> Retention data: Database (MySQL)<o:p></o:p> Peformance data: Default (external commands)<o:p></o:p> Extended info data: Database (MySQL)<o:p></o:p> <o:p> </o:p> [root@orinoco nagios-1.2]# make all<o:p></o:p> cd ./base && make<o:p></o:p> make[1]: Entering directory `/usr/local/src/nagios-1.2/base'<o:p></o:p> gcc -g -O2 -I/usr/include/mysql/ -DHAVE_CONFIG_H -DNSCORE -L/var/lib/mysql/ 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<o:p></o:p> sretention.o(.text+0x27): In function `save_state_information':<o:p></o:p> /usr/local/src/nagios-1.2/base/sretention.c:86: undefined reference to `xrddefault_save_state_information'<o:p></o:p> sretention.o(.text+0x87): In function `read_initial_state_information':<o:p></o:p> /usr/local/src/nagios-1.2/base/sretention.c:122: undefined reference to `xrddefault_read_state_information'<o:p></o:p> /tmp/ccDreMLr.o(.text+0x378): In function `xrddb_initialize':<o:p></o:p> ../xdata/xrddb.c:215: undefined reference to `mysql_init'<o:p></o:p> /tmp/ccDreMLr.o(.text+0x3f2): In function `xrddb_connect':<o:p></o:p> ../xdata/xrddb.c:252: undefined reference to `mysql_real_connect'<o:p></o:p> /tmp/ccDreMLr.o(.text+0x40d):../xdata/xrddb.c:254: undefined reference to `mysql_close'<o:p></o:p> <o:p> </o:p> <snip><o:p></o:p> ../xdata/xdddb.c:1107: undefined reference to `mysql_store_result'<o:p></o:p> /tmp/cclf8JjX.o(.text+0xc41):../xdata/xdddb.c:1107: undefined reference to `mysql_fetch_row'<o:p></o:p> /tmp/cclf8JjX.o(.text+0xd23):../xdata/xdddb.c:1116: undefined reference to `mysql_free_result'<o:p></o:p> /tmp/cclf8JjX.o(.text+0xd40):../xdata/xdddb.c:1149: undefined reference to `mysql_free_result'<o:p></o:p> /tmp/cclf8JjX.o(.text+0xd95): In function `xdddb_read_service_downtime':<o:p></o:p> ../xdata/xdddb.c:1238: undefined reference to `mysql_store_result'<o:p></o:p> /tmp/cclf8JjX.o(.text+0xdb9):../xdata/xdddb.c:1238: undefined reference to `mysql_fetch_row'<o:p></o:p> /tmp/cclf8JjX.o(.text+0xe9f):../xdata/xdddb.c:1247: undefined reference to `mysql_free_result'<o:p></o:p> /tmp/cclf8JjX.o(.text+0xebc):../xdata/xdddb.c:1280: undefined reference to `mysql_free_result'<o:p></o:p> collect2: ld returned 1 exit status<o:p></o:p> make[1]: *** [nagios] Error 1<o:p></o:p> make[1]: Leaving directory `/usr/local/src/nagios-1.2/base'<o:p></o:p> make: *** [all] Error 2<o:p></o:p> <o:p> </o:p> <o:p> </o:p> ####################################################################<o:p></o:p> (I can't seem to find "libpq-fe.h" anywhere) <o:p></o:p> <o:p> </o:p> <o:p> </o:p> ./configure --with-pgsql-comments --with-pgsql-extinfo --with-pgsql-retention --with-pgsql-downtime--with-pgsql-status --with-pgsql-xdata; --with-pgsql-lib=/var/lib/pgsql/ --with-pgsql-inc=/usr/include/pgsql/ <o:p></o:p> <o:p> </o:p> General Options:<o:p></o:p> -------------------------<o:p></o:p> Nagios executable: nagios<o:p></o:p> Nagios user/group: nagios,nagios<o:p></o:p> Command user/group: nagios,nagios<o:p></o:p> Embedded Perl: no<o:p></o:p> Install ${prefix}: /usr/local/nagios<o:p></o:p> Lock file: ${prefix}/var/nagios.lock<o:p></o:p> Init directory: /etc/rc.d/init.d<o:p></o:p> <o:p> </o:p> Web Interface Options:<o:p></o:p> ------------------------<o:p></o:p> HTML URL: http://localhost/nagios/<o:p></o:p> CGI URL: http://localhost/nagios/cgi-bin/<o:p></o:p> Traceroute (used by WAP): /bin/traceroute<o:p></o:p> <o:p> </o:p> External Data Routines:<o:p></o:p> ------------------------<o:p></o:p> Status data: Database (PostgreSQL)<o:p></o:p> Object data: Template-based (text file)<o:p></o:p> Comment data: Database (PostgreSQL)<o:p></o:p> Downtime data: Database (PostgreSQL)<o:p></o:p> Retention data: Database (PostgreSQL)<o:p></o:p> Peformance data: Default (external commands)<o:p></o:p> Extended info data: Database (PostgreSQL)<o:p></o:p> <o:p> </o:p> ## in CentOS 3.3<o:p></o:p> <o:p> </o:p> [root@orinoco nagios-1.2]# make all<o:p></o:p> cd ./base && make<o:p></o:p> make[1]: Entering directory `/usr/local/src/nagios-1.2/base'<o:p></o:p> gcc -g -O2 -DHAVE_CONFIG_H -DNSCORE -lpq 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<o:p></o:p> ../xdata/xrddb.c:46:28: pgsql/libpq-fe.h: No such file or directory<o:p></o:p> ../xdata/xrddb.c:63: syntax error before '*' token<o:p></o:p> ../xdata/xrddb.c:63: warning: data definition has no type or storage class<o:p></o:p> ../xdata/xrddb.c:64: syntax error before '*' token<o:p></o:p> ../xdata/xrddb.c:64: warning: data definition has no type or storage class<o:p></o:p> ../xdata/xrddb.c: In function `xrddb_connect':<o:p></o:p> <snip><o:p></o:p> ../xdata/xdddb.c:1304: warning: passing arg 1 of `atoi' makes pointer from integer without a cast<o:p></o:p> ../xdata/xdddb.c:1307: warning: passing arg 1 of `strtoul' makes pointer from integer without a cast<o:p></o:p> ../xdata/xdddb.c:1310: warning: passing arg 1 of `add_service_downtime' makes pointer from integer without a cast<o:p></o:p> ../xdata/xdddb.c:1310: warning: passing arg 2 of `add_service_downtime' makes pointer from integer without a cast<o:p></o:p> ../xdata/xdddb.c:1310: warning: passing arg 4 of `add_service_downtime' makes pointer from integer without a cast<o:p></o:p> ../xdata/xdddb.c:1310: warning: passing arg 5 of `add_service_downtime' makes pointer from integer without a cast<o:p></o:p> make[1]: *** [nagios] Error 1<o:p></o:p> make[1]: Leaving directory `/usr/local/src/nagios-1.2/base'<o:p></o:p> make: *** [all] Error 2<o:p></o:p> <o:p> </o:p> ## in RedHat 9<o:p></o:p> <o:p> </o:p> [root@fbdnms01 nagios-1.2]# make all<o:p></o:p> cd ./base && make<o:p></o:p> make[1]: Entering directory `/root/nagios-1.2/base'<o:p></o:p> gcc -g -O2 -I/usr/include/pgsql/ -DHAVE_CONFIG_H -DNSCORE -L/var/lib/pgsql/ -lpq 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<o:p></o:p> ../xdata/xrddb.c:46:28: pgsql/libpq-fe.h: No such file or directory<o:p></o:p> ../xdata/xrddb.c:63: parse error before '*' token<o:p></o:p> ../xdata/xrddb.c:63: warning: data definition has no type or storage class<o:p></o:p> ../xdata/xrddb.c:64: parse error before '*' token<o:p></o:p> ../xdata/xrddb.c:64: warning: data definition has no type or storage class<o:p></o:p> <snip><o:p></o:p> ../xdata/xdddb.c: In function `xdddb_read_service_downtime':<o:p></o:p> ../xdata/xdddb.c:1292: warning: passing arg 1 of `atoi' makes pointer from integer without a cast<o:p></o:p> ../xdata/xdddb.c:1295: warning: passing arg 1 of `strtoul' makes pointer from integer without a cast<o:p></o:p> ../xdata/xdddb.c:1298: warning: passing arg 1 of `strtoul' makes pointer from integer without a cast<o:p></o:p> ../xdata/xdddb.c:1301: warning: passing arg 1 of `strtoul' makes pointer from integer without a cast<o:p></o:p> ../xdata/xdddb.c:1304: warning: passing arg 1 of `atoi' makes pointer from integer without a cast<o:p></o:p> ../xdata/xdddb.c:1307: warning: passing arg 1 of `strtoul' makes pointer from integer without a cast<o:p></o:p> ../xdata/xdddb.c:1310: warning: passing arg 1 of `add_service_downtime' makes pointer from integer without a cast<o:p></o:p> ../xdata/xdddb.c:1310: warning: passing arg 2 of `add_service_downtime' makes pointer from integer without a cast<o:p></o:p> ../xdata/xdddb.c:1310: warning: passing arg 4 of `add_service_downtime' makes pointer from integer without a cast<o:p></o:p> ../xdata/xdddb.c:1310: warning: passing arg 5 of `add_service_downtime' makes pointer from integer without a cast<o:p></o:p> make[1]: *** [nagios] Error 1<o:p></o:p> make[1]: Leaving directory `/root/nagios-1.2/base'<o:p></o:p> make: *** [all] Error 2<o:p></o:p> </div> </body> </html>