NDOUtils and Mysql libraries assistance needed
Michael Friedrich
michael.friedrich at univie.ac.at
Thu Jun 25 18:39:36 CEST 2009
uhm... you should copy the new compiled binary to your nagios/bin
directory, but i don't think that will resolv the error anyways.
give us a plot of your ndo2db.cfg please.
Natalie Aloi wrote:
> I guess I'm a timid user..(not running make earlier)
> 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?
>
> [root at nagios ndoutils-1.3.1]# make
> cd ./src/; make ; cd ..
> make[1]: Entering directory `/tmp/ndoutils-1.3.1/src'
> gcc -g -O2 -DHAVE_CONFIG_H -c -o io.o io.c
> gcc -g -O2 -DHAVE_CONFIG_H -c -o utils.o utils.c
> gcc -g -O2 -DHAVE_CONFIG_H -o file2sock file2sock.c io.o utils.o
> -lm -lnsl
> gcc -g -O2 -DHAVE_CONFIG_H -o log2ndo log2ndo.c io.o utils.o -lm -lnsl
> make ndo2db-2x
> make[2]: Entering directory `/tmp/ndoutils-1.3.1/src'
> gcc -g -O2 -DHAVE_CONFIG_H -c -o db.o db.c
> gcc -g -O2 -DHAVE_CONFIG_H -D BUILD_NAGIOS_2X -c -o dbhandlers-2x.o
> dbhandlers.c
> 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
> make[2]: Leaving directory `/tmp/ndoutils-1.3.1/src'
> make ndo2db-3x
> make[2]: Entering directory `/tmp/ndoutils-1.3.1/src'
> gcc -g -O2 -DHAVE_CONFIG_H -D BUILD_NAGIOS_3X -c -o dbhandlers-3x.o
> dbhandlers.c
> 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
> make[2]: Leaving directory `/tmp/ndoutils-1.3.1/src'
> make ndomod-2x.o
> make[2]: Entering directory `/tmp/ndoutils-1.3.1/src'
> gcc -fPIC -g -O2 -DHAVE_CONFIG_H -D BUILD_NAGIOS_2X -o ndomod-2x.o
> ndomod.c io.o utils.o -shared -lnsl
> make[2]: Leaving directory `/tmp/ndoutils-1.3.1/src'
> make ndomod-3x.o
> make[2]: Entering directory `/tmp/ndoutils-1.3.1/src'
> gcc -fPIC -g -O2 -DHAVE_CONFIG_H -D BUILD_NAGIOS_3X -o ndomod-3x.o
> ndomod.c io.o utils.o -shared -lnsl
> make[2]: Leaving directory `/tmp/ndoutils-1.3.1/src'
> gcc -g -O2 -DHAVE_CONFIG_H -o sockdebug sockdebug.c io.o utils.o
> -lm -lnsl
> make[1]: Leaving directory `/tmp/ndoutils-1.3.1/src'
> [root at nagios /]# cd /tmp/ndoutils-1.3.1
> [root at nagios ndoutils-1.3.1]# ndo2db-2x -c /etc/nagios/ndo2db.cfg
> Support for the specified database server is either not yet supported,
> or was not found on your system.
> [root at nagios ndoutils-1.3.1]#
>
> -----Original Message-----
> *From:* Natalie Aloi [mailto:naloi at experisdatacenters.com]
> *Sent:* Thursday, June 25, 2009 09:41 AM
> *To:* 'Nagios Users Mail-list'
> *Subject:* Re: [Nagios-users] NDOUtils and Mysql libraries
> assistance needed
>
> 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?
> MySQL library and include file(s) were found!
> checking for PQconnectdb in -lpq... no
>
> *** PostgreSQL library could not be located... *********************
> You chose to compile NDBXT with PostgreSQL support, but I was
> unable to locate the PostgreSQL library on your system. If the
> library is installed, use the --with-pgsql-lib argument to specify
> the location of the PostgreSQL library.
> NOTE: After you install the necessary libraries on your system:
> 1. Make sure /etc/ld.so.conf has an entry for the directory in
> which the PostgreSQL libraries are installed.
> 2. Run 'ldconfig' to update the run-time linker options.
> 3. Run 'make devclean' in the NDBXT distribution to clean out
> any old references to your previous compile.
> 4. Rerun the configure script.
> ********************************************************************
>
> checking libpq-fe.h usability... no
> checking libpq-fe.h presence... no
> checking for libpq-fe.h... no
>
> *** PostgreSQL include file could not be located... ****************
> You chose to compile NDBXT with PostgreSQL support, but I was unable
> to locate <libpq-fe.h> on your system. If the include file is
> installed, use the --with-pgsql-inc argument to specify the location
> of the PostgreSQL include file.
> ********************************************************************
>
> configure: creating ./config.status
> config.status: creating Makefile
> config.status: creating src/Makefile
> config.status: creating include/config.h
>
> *** ndoutils 1.3.1 02-15-2006 ***
>
> Type 'make' to compile the NDO utilities.
> [root at nagios ndoutils-1.3.1]#
>
> -----Original Message-----
> *From:* Natalie Aloi [mailto:naloi at experisdatacenters.com]
> *Sent:* Thursday, June 25, 2009 09:29 AM
> *To:* 'Nagios Users Mail-list'
> *Subject:* Re: [Nagios-users] NDOUtils and Mysql libraries
> assistance needed
>
> 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?
>
> [root at nagios ld.so.conf.d]# ls -lat
> total 32
> drwxr-xr-x 144 root root 12288 2009-06-23 04:06 ..
> drwxr-xr-x 2 root root 4096 2009-04-28 16:01 .
> -rw-r--r-- 1 root root 23 2009-04-27 08:31 xulrunner-32.conf
> -rw-r--r-- 1 root root 15 2009-03-07 18:39 mysql-i386.conf
> -rw-r--r-- 1 root root 16 2008-10-21 05:02 tix-i386.conf
> -rw-r--r-- 1 root root 20 2008-07-07 15:49 qt-i386.conf
> [root at nagios ld.so.conf.d]# more mysql-i386.conf
> /usr/lib/mysql
> [root at nagios ld.so.conf.d]#
>
> -----Original Message-----
> *From:* Guy Waugh [mailto:guidosh at gmail.com]
> *Sent:* Thursday, June 25, 2009 09:07 AM
> *To:* 'Natalie Aloi'
> *Subject:* Re: [Nagios-users] NDOUtils and Mysql libraries
> assistance needed
>
> Hello,
>
> On Thu, Jun 25, 2009 at 1:57 PM, Natalie Aloi
> <naloi at experisdatacenters.com
> <mailto:naloi at experisdatacenters.com>> wrote:
>
> Hi I am having trouble getting ndoutils to work
> during my install I found this information logged:
>
> *** MySQL library could not be located...
> **************************
> You chose to compile NDBXT with MySQL support, but I
> was unable to
> locate the MySQL library on your system. If the
> library is
> installed, use the --with-mysql-lib argument to
> specify the
> location of the MySQL library.
> NOTE: After you install the necessary libraries on
> your system:
> 1. Make sure /etc/ld.so.conf has an entry for
> the directory in
> which the MySQL libraries are installed.
> 2. Run 'ldconfig' to update the run-time linker
> options.
> 3. Run 'make devclean' in the NDBXT distribution
> to clean out
> any old references to your previous compile.
> 4. Rerun the configure script.
> TIP: Try the following....
> ./configure --with-mysql-lib=/usr/lib/mysql
> I have a question about step 1. When I more the file
> all it has in it is this information:
>
> [root at nagios etc]# more ld.so.conf
> include ld.so.conf.d/*.conf
>
> My question is what is the syntax of the libraries I
> have no idea what to add into this file.
> Do I just add "/usr/lib/mysql" ?
>
>
> 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.
>
> Cheers,
> Guy.
>
>
>
> I am running Fedora 9
> mysql has been installed (see below:)
> [root at nagios etc]# rpm -qa | grep mysql
> qt-mysql-4.5.0-14.fc9.i386
> mysql-administrator-5.0r12-8.fc9.i386
> mysql-server-5.0.77-1.fc9.i386
> mysql-devel-5.0.77-1.fc9.i386
> mysql-connector-odbc-3.51.24r1071-1.fc9.i386
> mysql-connector-java-3.1.12-5.fc9.i386
> php-mysql-5.2.6-2.fc9.i386
> mysql-5.0.77-1.fc9.i386
> libdbi-dbd-mysql-0.8.3-2.fc9.i386
> mysql-libs-5.0.77-1.fc9.i386
> nagios-plugins-mysql-1.4.13-9.fc9.i386
> mysql-gui-common-5.0r12-8.fc9.i386
> below is infor from mysql for nagios db for ndoutils....
> mysql> use nagios
> Reading table information for completion of table and
> column names
> You can turn off this feature to get a quicker startup
> with -A
> Database changed
> mysql> show tables;
> +-------------------------------------+
> | Tables_in_nagios |
> +-------------------------------------+
> | ndo_acknowledgements |
> | ndo_commands |
> | ndo_commenthistory |
> | ndo_comments |
> | ndo_configfiles |
> | ndo_configfilevariables |
> | ndo_conninfo |
> | ndo_contact_addresses |
> | ndo_contact_notificationcommands |
> | ndo_contactgroup_members |
> | ndo_contactgroups |
> | ndo_contactnotificationmethods |
> | ndo_contactnotifications |
> | ndo_contacts |
> | ndo_customobjectvariables |
> | ndo_downtimehistory |
> | ndo_eventhandlers |
> | ndo_externalcommands |
> | ndo_flappinghistory |
> | ndo_host_contactgroups |
> | ndo_host_parenthosts |
> | ndo_hostchecks |
> | ndo_hostdependencies |
> | ndo_hostescalation_contactgroups |
> | ndo_hostescalations |
> | ndo_hostextinfo |
> | ndo_hostgroup_members |
> | ndo_hostgroups |
> | ndo_hosts |
> | ndo_hoststatus |
> | ndo_instances |
> | ndo_logentries |
> | ndo_notifications |
> | ndo_objects |
> | ndo_processevents |
> | ndo_programstatus |
> | ndo_runtimevariables |
> | ndo_scheduleddowntime |
> | ndo_service_contactgroups |
> | ndo_servicechecks |
> | ndo_servicedependencies |
> | ndo_serviceescalation_contactgroups |
> | ndo_serviceescalations |
> | ndo_serviceextinfo |
> | ndo_servicegroup_members |
> | ndo_servicegroups |
> | ndo_services |
> | ndo_servicestatus |
> | ndo_statehistory |
> | ndo_systemcommands |
> | ndo_timedeventqueue |
> | ndo_timedevents |
> | ndo_timeperiod_timeranges |
> | ndo_timeperiods |
> +-------------------------------------+
> 54 rows in set (0.00 sec)
> mysql>
>
> Network Operations Center Manager
> Experis Data Center LLC
> 8209 Valley Pike
> PO Box 535
> Middletown,VA 22645
> phone:540-869-8702
> cell:240-988-3267
> fax:540-869-8710
> mailto:e-mail%3Analoi at experisdatacenters.com
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> Nagios-users mailing list
> Nagios-users at lists.sourceforge.net
> <mailto: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
>
>
> ------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20090625/ab4d4039/attachment.html>
-------------- next part --------------
------------------------------------------------------------------------------
-------------- next part --------------
_______________________________________________
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
More information about the Users
mailing list