<html><DIV><FONT face=Verdana color=#0000ff size=2>I guess I'm a timid user..(not running make earlier)<IMG title="" alt="" src="http://mail.experisdatacenters.com/scripts/tiny_mce/plugins/emotions/images/e_03.gif" border=0> </FONT></DIV> <DIV><FONT face=Verdana color=#0000ff size=2>So ran make - I didn't get any errors but it still says support for database servers not found does that mean I need to re-run for postgresql? </FONT></DIV> <DIV><FONT color=#0000ff size=2></FONT> </DIV> <DIV>[root@nagios ndoutils-1.3.1]# make<BR>cd ./src/; make ; cd ..<BR>make[1]: Entering directory `/tmp/ndoutils-1.3.1/src'<BR>gcc -g -O2 -DHAVE_CONFIG_H -c -o io.o io.c<BR>gcc -g -O2 -DHAVE_CONFIG_H -c -o utils.o utils.c<BR>gcc -g -O2 -DHAVE_CONFIG_H -o file2sock file2sock.c io.o utils.o -lm -lnsl<BR>gcc -g -O2 -DHAVE_CONFIG_H -o log2ndo log2ndo.c io.o utils.o -lm -lnsl<BR>make ndo2db-2x<BR>make[2]: Entering directory `/tmp/ndoutils-1.3.1/src'<BR>gcc -g -O2 -DHAVE_CONFIG_H -c -o db.o db.c<BR>gcc -g -O2 -DHAVE_CONFIG_H -D BUILD_NAGIOS_2X -c -o dbhandlers-2x.o dbhandlers.c<BR>gcc -g -O2 -DHAVE_CONFIG_H -D BUILD_NAGIOS_2X -o ndo2db-2x ndo2db.c dbhandlers-2x.o io.o utils.o db.o -L/usr/lib/mysql -lnsl -lmysqlclient<BR>make[2]: Leaving directory `/tmp/ndoutils-1.3.1/src'<BR>make ndo2db-3x<BR>make[2]: Entering directory `/tmp/ndoutils-1.3.1/src'<BR>gcc -g -O2 -DHAVE_CONFIG_H -D BUILD_NAGIOS_3X -c -o dbhandlers-3x.o dbhandlers.c<BR>gcc -g -O2 -DHAVE_CONFIG_H -D BUILD_NAGIOS_3X -o ndo2db-3x ndo2db.c dbhandlers-3x.o io.o utils.o db.o -L/usr/lib/mysql -lnsl -lmysqlclient<BR>make[2]: Leaving directory `/tmp/ndoutils-1.3.1/src'<BR>make ndomod-2x.o<BR>make[2]: Entering directory `/tmp/ndoutils-1.3.1/src'<BR>gcc -fPIC -g -O2 -DHAVE_CONFIG_H -D BUILD_NAGIOS_2X -o ndomod-2x.o ndomod.c io.o utils.o -shared -lnsl<BR>make[2]: Leaving directory `/tmp/ndoutils-1.3.1/src'<BR>make ndomod-3x.o<BR>make[2]: Entering directory `/tmp/ndoutils-1.3.1/src'<BR>gcc -fPIC -g -O2 -DHAVE_CONFIG_H -D BUILD_NAGIOS_3X -o ndomod-3x.o ndomod.c io.o utils.o -shared -lnsl<BR>make[2]: Leaving directory `/tmp/ndoutils-1.3.1/src'<BR>gcc -g -O2 -DHAVE_CONFIG_H -o sockdebug sockdebug.c io.o utils.o -lm -lnsl<BR>make[1]: Leaving directory `/tmp/ndoutils-1.3.1/src'<BR>[root@nagios /]# cd /tmp/ndoutils-1.3.1<BR></DIV> <DIV>[root@nagios ndoutils-1.3.1]# ndo2db-2x -c /etc/nagios/ndo2db.cfg<BR>Support for the specified database server is either not yet supported, or was not found on your system.<BR>[root@nagios ndoutils-1.3.1]#<BR></DIV> <BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px"><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Natalie Aloi [mailto:naloi@experisdatacenters.com]<BR><B>Sent:</B> Thursday, June 25, 2009 09:41 AM<BR><B>To:</B> 'Nagios Users Mail-list'<BR><B>Subject:</B> Re: [Nagios-users] NDOUtils and Mysql libraries assistance needed<BR><BR></FONT> <DIV><FONT face=Verdana color=#0000ff size=2>Ok...making progress...after rerunning the config the sql libraries were found but now I get about postgresql support....Do I need this? Or Can I just run make?</FONT></DIV> <DIV>MySQL library and include file(s) were found!<BR>checking for PQconnectdb in -lpq... no</DIV> <DIV><BR>*** PostgreSQL library could not be located... *********************</DIV> <DIV>You chose to compile NDBXT with PostgreSQL support, but I was<BR>unable to locate the PostgreSQL library on your system. If the<BR>library is installed, use the --with-pgsql-lib argument to specify<BR>the location of the PostgreSQL library.</DIV> <DIV>NOTE: After you install the necessary libraries on your system:<BR> 1. Make sure /etc/ld.so.conf has an entry for the directory in<BR> which the PostgreSQL libraries are installed.<BR> 2. Run 'ldconfig' to update the run-time linker options.<BR> 3. Run 'make devclean' in the NDBXT distribution to clean out<BR> any old references to your previous compile.<BR> 4. Rerun the configure script.</DIV> <DIV>********************************************************************</DIV> <DIV><BR>checking libpq-fe.h usability... no<BR>checking libpq-fe.h presence... no<BR>checking for libpq-fe.h... no</DIV> <DIV><BR>*** PostgreSQL include file could not be located... ****************</DIV> <DIV>You chose to compile NDBXT with PostgreSQL support, but I was unable<BR>to locate <libpq-fe.h> on your system. If the include file is<BR>installed, use the --with-pgsql-inc argument to specify the location<BR>of the PostgreSQL include file.</DIV> <DIV>********************************************************************</DIV> <DIV><BR>configure: creating ./config.status<BR>config.status: creating Makefile<BR>config.status: creating src/Makefile<BR>config.status: creating include/config.h</DIV> <DIV><BR>*** ndoutils 1.3.1 02-15-2006 ***</DIV> <DIV><BR>Type 'make' to compile the NDO utilities.</DIV> <DIV>[root@nagios ndoutils-1.3.1]#<BR></DIV> <BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px"><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Natalie Aloi [mailto:naloi@experisdatacenters.com]<BR><B>Sent:</B> Thursday, June 25, 2009 09:29 AM<BR><B>To:</B> 'Nagios Users Mail-list'<BR><B>Subject:</B> Re: [Nagios-users] NDOUtils and Mysql libraries assistance needed<BR><BR></FONT> <DIV><FONT face=Verdana color=#0000ff size=2>So this is what's in ld.so.conf.d....do I just do steps 2-4 now since there is already a file that points to it - or do I need to rename mysql-i386.conf to mysql.conf?</FONT></DIV> <DIV> </DIV> <DIV><FONT face=Verdana color=#0000ff size=2>[root@nagios ld.so.conf.d]# ls -lat<BR>total 32<BR>drwxr-xr-x 144 root root 12288 2009-06-23 04:06 ..<BR>drwxr-xr-x 2 root root 4096 2009-04-28 16:01 .<BR>-rw-r--r-- 1 root root 23 2009-04-27 08:31 xulrunner-32.conf<BR>-rw-r--r-- 1 root root 15 2009-03-07 18:39 mysql-i386.conf<BR>-rw-r--r-- 1 root root 16 2008-10-21 05:02 tix-i386.conf<BR>-rw-r--r-- 1 root root 20 2008-07-07 15:49 qt-i386.conf<BR>[root@nagios ld.so.conf.d]# more mysql-i386.conf<BR>/usr/lib/mysql<BR>[root@nagios ld.so.conf.d]#<BR></DIV></FONT> <BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px"><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Guy Waugh [mailto:guidosh@gmail.com]<BR><B>Sent:</B> Thursday, June 25, 2009 09:07 AM<BR><B>To:</B> 'Natalie Aloi'<BR><B>Subject:</B> Re: [Nagios-users] NDOUtils and Mysql libraries assistance needed<BR><BR></FONT>Hello,<BR><BR> <DIV class=gmail_quote>On Thu, Jun 25, 2009 at 1:57 PM, Natalie Aloi <SPAN dir=ltr><<A href="mailto:naloi@experisdatacenters.com" target=_blank mce_href="mailto:naloi@experisdatacenters.com">naloi@experisdatacenters.com</A>></SPAN> wrote:<BR> <BLOCKQUOTE class=gmail_quote style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid"> <DIV bgcolor="#ffffff"> <DIV><FONT face=Verdana size=2></FONT></DIV> <DIV><FONT face=Verdana size=2>Hi I am having trouble getting ndoutils to work </FONT></DIV> <DIV><FONT size=2>during my install I found this information logged:</FONT></DIV> <DIV> </DIV> <DIV>*** MySQL library could not be located... **************************<BR>You chose to compile NDBXT with MySQL support, but I was unable to<BR>locate the MySQL library on your system. If the library is<BR>installed, use the --with-mysql-lib argument to specify the<BR>location of the MySQL library.<BR>NOTE: After you install the necessary libraries on your system:<BR> 1. Make sure /etc/ld.so.conf has an entry for the directory in<BR> which the MySQL libraries are installed.<BR> 2. Run 'ldconfig' to update the run-time linker options.<BR> 3. Run 'make devclean' in the NDBXT distribution to clean out<BR> any old references to your previous compile.<BR> 4. Rerun the configure script.<BR>TIP: Try the following....<BR> ./configure --with-mysql-lib=/usr/lib/mysql<BR><FONT size=2>I have a question about step 1. When I more the file all it has in it is this information:</FONT></DIV> <DIV> </DIV> <DIV>[root@nagios etc]# more ld.so.conf<BR>include ld.so.conf.d/*.conf<BR><FONT size=2> </FONT></DIV> <DIV><FONT size=2>My question is what is the syntax of the libraries I have no idea what to add into this file.</FONT></DIV> <DIV><FONT size=2>Do I just add "/usr/lib/mysql" ?</FONT></DIV></DIV></BLOCKQUOTE> <DIV><BR>The best thing to do would be to create a file in '/etc/ld.so.conf.d' called 'mysql.conf' that contains, as you suggest, one line thus: '/usr/lib/mysql' (without the quotes). Then, proceed with steps 2, 3 and 4 above.<BR><BR>Cheers,<BR>Guy.<BR> </DIV> <BLOCKQUOTE class=gmail_quote style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid"> <DIV bgcolor="#ffffff"> <DIV><FONT size=2></FONT></DIV> <DIV><FONT size=2></FONT> </DIV> <DIV><FONT size=2>I am running Fedora 9</FONT></DIV> <DIV><FONT size=2>mysql has been installed (see below:)</FONT></DIV> <DIV>[root@nagios etc]# rpm -qa | grep mysql<BR>qt-mysql-4.5.0-14.fc9.i386<BR>mysql-administrator-5.0r12-8.fc9.i386<BR>mysql-server-5.0.77-1.fc9.i386<BR>mysql-devel-5.0.77-1.fc9.i386<BR>mysql-connector-odbc-3.51.24r1071-1.fc9.i386<BR>mysql-connector-java-3.1.12-5.fc9.i386<BR>php-mysql-5.2.6-2.fc9.i386<BR>mysql-5.0.77-1.fc9.i386<BR>libdbi-dbd-mysql-0.8.3-2.fc9.i386<BR>mysql-libs-5.0.77-1.fc9.i386<BR>nagios-plugins-mysql-1.4.13-9.fc9.i386<BR>mysql-gui-common-5.0r12-8.fc9.i386</DIV> <DIV>below is infor from mysql for nagios db for ndoutils....<BR>mysql> use nagios<BR>Reading table information for completion of table and column names<BR>You can turn off this feature to get a quicker startup with -A<BR>Database changed<BR>mysql> show tables;<BR>+-------------------------------------+<BR>| Tables_in_nagios |<BR>+-------------------------------------+<BR>| ndo_acknowledgements |<BR>| ndo_commands |<BR>| ndo_commenthistory |<BR>| ndo_comments |<BR>| ndo_configfiles |<BR>| ndo_configfilevariables |<BR>| ndo_conninfo |<BR>| ndo_contact_addresses |<BR>| ndo_contact_notificationcommands |<BR>| ndo_contactgroup_members |<BR>| ndo_contactgroups |<BR>| ndo_contactnotificationmethods |<BR>| ndo_contactnotifications |<BR>| ndo_contacts |<BR>| ndo_customobjectvariables |<BR>| ndo_downtimehistory |<BR>| ndo_eventhandlers |<BR>| ndo_externalcommands |<BR>| ndo_flappinghistory |<BR>| ndo_host_contactgroups |<BR>| ndo_host_parenthosts |<BR>| ndo_hostchecks |<BR>| ndo_hostdependencies |<BR>| ndo_hostescalation_contactgroups |<BR>| ndo_hostescalations |<BR>| ndo_hostextinfo |<BR>| ndo_hostgroup_members |<BR>| ndo_hostgroups |<BR>| ndo_hosts |<BR>| ndo_hoststatus |<BR>| ndo_instances |<BR>| ndo_logentries |<BR>| ndo_notifications |<BR>| ndo_objects |<BR>| ndo_processevents |<BR>| ndo_programstatus |<BR>| ndo_runtimevariables |<BR>| ndo_scheduleddowntime |<BR>| ndo_service_contactgroups |<BR>| ndo_servicechecks |<BR>| ndo_servicedependencies |<BR>| ndo_serviceescalation_contactgroups |<BR>| ndo_serviceescalations |<BR>| ndo_serviceextinfo |<BR>| ndo_servicegroup_members |<BR>| ndo_servicegroups |<BR>| ndo_services |<BR>| ndo_servicestatus |<BR>| ndo_statehistory |<BR>| ndo_systemcommands |<BR>| ndo_timedeventqueue |<BR>| ndo_timedevents |<BR>| ndo_timeperiod_timeranges |<BR>| ndo_timeperiods |<BR>+-------------------------------------+<BR>54 rows in set (0.00 sec)<BR>mysql></DIV> <DIV> </DIV>Network Operations Center Manager <BR>Experis Data Center LLC <BR>8209 Valley Pike <BR>PO Box 535 <BR>Middletown,VA 22645 <BR>phone:540-869-8702 <BR>cell:240-988-3267 <BR>fax:540-869-8710 <BR><A href="mailto:e-mail%3Analoi@experisdatacenters.com" target=_blank mce_href="mailto:e-mail%3Analoi@experisdatacenters.com">mailto:e-mail%3Analoi@experisdatacenters.com</A></DIV><BR>------------------------------------------------------------------------------<BR><BR>_______________________________________________<BR>Nagios-users mailing list<BR><A href="mailto:Nagios-users@lists.sourceforge.net" target=_blank mce_href="mailto:Nagios-users@lists.sourceforge.net">Nagios-users@lists.sourceforge.net</A><BR><A href="https://lists.sourceforge.net/lists/listinfo/nagios-users" target=_blank mce_href="https://lists.sourceforge.net/lists/listinfo/nagios-users">https://lists.sourceforge.net/lists/listinfo/nagios-users</A><BR>::: Please include Nagios version, plugin version (-v) and OS when reporting any issue.<BR>::: Messages without supporting info will risk being sent to /dev/null<BR></BLOCKQUOTE></DIV><BR></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></html>