I change it but am still getting could not sink data error... # DATABASE TABLE PREFIX # Determines the prefix (if any) that should be prepended to table names. #db_prefix= db_prefix=ndo_
then I stopped ndo2db and restarted it, then restarted nagios [r...@nagios nagios]# ps -ef | grep ndo2db root 601 1 0 13:04 ? 00:00:00 ndo2db -c /etc/nagios/ndo2db.cfg root 11550 12431 0 16:01 pts/1 00:00:00 grep ndo2db [r...@nagios nagios]# kill 601 [r...@nagios nagios]# ps -ef | grep ndo2db root 13403 12431 0 16:07 pts/1 00:00:00 grep ndo2db [r...@nagios nagios]# cd /usr/sbin [r...@nagios sbin]# ndo2db -c /etc/nagios/ndo2db.cfg [r...@nagios sbin]# sudo service nagios restart Running configuration check...done Stopping nagios: .done. Starting nagios: done. [r...@nagios sbin]# tail /var/log/nagios/nagios.log [1245960534] Caught SIGTERM, shutting down... [1245960534] Successfully shutdown... (PID=3070) [1245960534] ndomod: Shutdown complete. [1245960534] Event broker module '/usr/sbin/ndomod.o' deinitialized successfully. [1245960535] Nagios 2.11 starting... (PID=14253) [1245960535] LOG VERSION: 2.0 [1245960535] ndomod: NDOMOD 1.3.1 Copyright (c) 2005-2006 Ethan Galstad (nag...@nagios.org) [1245960535] ndomod: Could not open data sink! I'll keep trying, but some output may get lost... [1245960535] Event broker module '/usr/sbin/ndomod.o' initialized successfully. [1245960535] Finished daemonizing... (New PID=14254) -----Original Message----- From: Michael Friedrich [mailto:michael.friedr...@univie.ac.at] Sent: Thursday, June 25, 2009 02:18 PM To: 'Natalie Aloi' Cc: 'Nagios Users Mail-list' Subject: Re: [Nagios-users] NDOUtils and Mysql libraries assistance needed Your database table scheme is with prefix "ndo_" so you have to set that in your ndo2db.cfg too and make sure you start ndo2db first and then nagios. Natalie Aloi wrote: woohoo! Thanks Michael! [r...@nagios src]# cp ndomod-2x.o /usr/sbin/ndomod.o cp: overwrite `/usr/sbin/ndomod.o'? y [r...@nagios src]# cp ndo2db-2x /usr/sbin/ndo2db [r...@nagios src]# cd /usr/sbin [r...@nagios sbin]# ndo2db -c /etc/nagios/ndo2db.cfg [r...@nagios sbin]# ps -ef | grep ndo2db root 601 1 0 13:04 ? 00:00:00 ndo2db -c /etc/nagios/ndo2db.cfg root 617 12431 0 13:04 pts/1 00:00:00 grep ndo2db [r...@nagios sbin]# Except!...shoot!...I am getting that dumb error but I have those lines verified - ndo2db.cfg and ndomod.cfg files included [r...@nagios nagios]# tail /var/log/nagios/nagios.log [1245950692] Caught SIGTERM, shutting down... [1245950692] Successfully shutdown... (PID=739) [1245950692] ndomod: Shutdown complete. [1245950692] Event broker module '/usr/sbin/ndomod.o' deinitialized successfully. [1245950693] Nagios 2.11 starting... (PID=1813) [1245950693] LOG VERSION: 2.0 [1245950693] ndomod: NDOMOD 1.3.1 Copyright (c) 2005-2006 Ethan Galstad (nag...@nagios.org) [1245950693] ndomod: Could not open data sink! I'll keep trying, but some output may get lost... [1245950693] Event broker module '/usr/sbin/ndomod.o' initialized successfully. [1245950693] Finished daemonizing... (New PID=1814) [r...@nagios nagios]# more ndomod.cfg ##################################################################### # NDOMOD CONFIG FILE # # Last Modified: 01-10-2006 ##################################################################### # INSTANCE NAME # This option identifies the "name" associated with this particular # instance of Nagios and is used to seperate data coming from multiple # instances. Defaults to 'default' (without quotes). instance_name=default # OUTPUT TYPE # This option determines what type of output sink the NDO NEB module # should use for data output. Valid options include: # file = standard text file # tcpsocket = TCP socket # unixsocket = UNIX domain socket (default) #output_type=file #output_type=tcpsocket output_type=unixsocket # OUTPUT # This option determines the name and path of the file or UNIX domain # socket to which output will be sent if the output type option specified # above is "file" or "unixsocket", respectively. If the output type # option is "tcpsocket", this option is used to specify the IP address # of fully qualified domain name of the host that the module should # connect to for sending output. #output=/usr/local/nagios/var/ndo.dat #output=127.0.0.1 output=/var/run/nagios/ndo.sock [r...@nagios nagios]# more ndo2db.cfg ##################################################################### # NDO2DB DAEMON CONFIG FILE # # Last Modified: 02-12-2006 ##################################################################### # SOCKET TYPE # This option determines what type of socket the daemon will create # an accept connections from. # Value: # unix = Unix domain socket (default) # tcp = TCP socket socket_type=unix #socket_type=tcp # SOCKET NAME # This option determines the name and path of the UNIX domain # socket that the daemon will create and accept connections from. # This option is only valid if the socket type specified above # is "unix". #socket_name=/usr/local/nagios/var/ndo.sock socket_name=/var/run/nagios/ndo.sock # TCP PORT # This option determines what port the daemon will listen for # connections on. This option is only vlaid if the socket type # specified above is "tcp". tcp_port=5668 # DATABASE SERVER TYPE # This option determines what type of DB server the daemon should # connect to. # Values: # mysql = MySQL # pgsql = PostgreSQL db_servertype=mysql # DATABASE HOST # This option specifies what host the DB server is running on. db_host=localhost # DATABASE PORT # This option specifies the port that the DB server is running on. # Values: # 3306 = Default MySQL port # 5432 = Default PostgreSQL port db_port=3306 # DATABASE NAME # This option specifies the name of the database that should be used. db_name=nagios # DATABASE TABLE PREFIX # Determines the prefix (if any) that should be prepended to table names. db_prefix= #db_prefix=ndo_ # DATABASE USERNAME/PASSWORD # This is the username/password that will be used to authenticate to the DB. # The user needs at least SELECT, INSERT, UPDATE, and DELETE privileges on # the database. #db_user=ndouser #db_pass=ndopassword db_user=nagios db_pass=nagios ## TABLE TRIMMING OPTIONS # Several database tables containing Nagios event data can become quite large # over time. Most admins will want to trim these tables and keep only a # certain amount of data in them. The options below are used to specify the # age (in MINUTES) that data should be allowd to remain in various tables # before it is deleted. Using a value of zero (0) for any value means that # that particular table should NOT be automatically trimmed. # Keep timed events for 24 hours max_timedevents_age=1440 # Keep system commands for 1 week max_systemcommands_age=10080 # Keep service checks for 1 week max_servicechecks_age=10080 # Keep host checks for 1 week max_hostchecks_age=10080 # Keep event handlers for 31 days max_eventhandlers_age=44640 [r...@nagios nagios]# -----Original Message----- From: Michael Friedrich [mailto:michael.friedr...@univie.ac.at] Sent: Thursday, June 25, 2009 12:39 PM To: 'Natalie Aloi' Cc: 'Nagios Users Mail-list' Subject: Re: [Nagios-users] NDOUtils and Mysql libraries assistance needed 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? [r...@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' [r...@nagios /]# cd /tmp/ndoutils-1.3.1 [r...@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. [r...@nagios ndoutils-1.3.1]# -----Original Message----- From: Natalie Aloi [mailto:na...@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. [r...@nagios ndoutils-1.3.1]# -----Original Message----- From: Natalie Aloi [mailto:na...@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? [r...@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 [r...@nagios ld.so.conf.d]# more mysql-i386.conf /usr/lib/mysql [r...@nagios ld.so.conf.d]# -----Original Message----- From: Guy Waugh [mailto:guid...@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 <na...@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: [r...@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:) [r...@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%3ana...@experisdatacenters.com ------------------------------------------------------------------------------ _______________________________________________ Nagios-users mailing list Nagios-users@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 listnagios-us...@lists.sourceforge.nethttps://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 listnagios-us...@lists.sourceforge.nethttps://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@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
