<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>uhm... you should copy the new compiled binary to your nagios/bin
directory, but i don't think that will resolv the error anyways.<br>
<br>
give us a plot of your ndo2db.cfg please.<br>
<br>
<br>
</tt><br>
Natalie Aloi wrote:
<blockquote cite="mid:W43488111765531245943805@webmail15" type="cite">
<div><font color="#0000ff" face="Verdana" size="2">I guess I'm a
timid user..(not running make earlier)<img moz-do-not-send="true"
title="" alt=""
src="http://mail.experisdatacenters.com/scripts/tiny_mce/plugins/emotions/images/e_03.gif"
border="0"> </font></div>
<div><font color="#0000ff" face="Verdana" 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> </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="border-left: 2px solid rgb(0, 0, 255); padding-left: 5px; margin-left: 5px; margin-right: 0px;"><font
face="Tahoma" size="2">-----Original Message-----<br>
<b>From:</b> Natalie Aloi [<a class="moz-txt-link-freetext" href="mailto:naloi@experisdatacenters.com">mailto:naloi@experisdatacenters.com</a>]<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 color="#0000ff" face="Verdana" 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="border-left: 2px solid rgb(0, 0, 255); padding-left: 5px; margin-left: 5px; margin-right: 0px;"><font
face="Tahoma" size="2">-----Original Message-----<br>
<b>From:</b> Natalie Aloi [<a class="moz-txt-link-freetext" href="mailto:naloi@experisdatacenters.com">mailto:naloi@experisdatacenters.com</a>]<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 color="#0000ff" face="Verdana" 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 color="#0000ff" face="Verdana" 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>
</font></div>
<blockquote
style="border-left: 2px solid rgb(0, 0, 255); padding-left: 5px; margin-left: 5px; margin-right: 0px;"><font
face="Tahoma" size="2">-----Original Message-----<br>
<b>From:</b> Guy Waugh [<a class="moz-txt-link-freetext" href="mailto:guidosh@gmail.com">mailto:guidosh@gmail.com</a>]<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 moz-do-not-send="true"
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="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div bgcolor="#ffffff">
<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="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div bgcolor="#ffffff">
<div> </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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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>
<pre wrap="">
<hr size="4" width="90%">
------------------------------------------------------------------------------
</pre>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
Nagios-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Nagios-users@lists.sourceforge.net">Nagios-users@lists.sourceforge.net</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/nagios-users">https://lists.sourceforge.net/lists/listinfo/nagios-users</a>
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue.
::: Messages without supporting info will risk being sent to /dev/null</pre>
</blockquote>
<br>
</body>
</html>