NDOUtils and Mysql libraries assistance needed

Michael Friedrich michael.friedrich at univie.ac.at
Mon Jun 29 16:10:51 CEST 2009


Well ok then... Upgrade to higher Nagios version, getting 1.4b8 from cvs 
of ndoutils... don't know what to recommend right now for such an old 
architecture.

Natalie Aloi wrote the following on 29.06.2009 15:17:
> nope didn't do the trick - running nagios 2.11 running ndo 1.3.1 as I 
> didn't think 1.4b7 would work with anything less than 2.5 nagios...or 
> that is what I remember reading...
>  
> [root at nagios plugins.d]# sudo service nagios stop
> Stopping nagios: .done.
> [root at nagios plugins.d]# ps -ef | grep ndo
> root      5619 12431  0 09:12 pts/1    00:00:00 grep ndo
> naloi     7450  7222  0 Apr28 ?        05:34:40 nautilus 
> --no-default-window --sm-client-id default3
> root     13956     1  0 Jun25 ?        00:00:00 ndo2db -c 
> /etc/nagios/ndo2db.cfg
> naloi    27692 27632  0 Apr28 ?        05:37:24 nautilus 
> --no-default-window --sm-client-id default3
> [root at nagios plugins.d]# kill 13956
> [root at nagios plugins.d]# ndo2db -c /etc/nagios/ndo2db.cfg
> [root at nagios plugins.d]# ps -ef | grep ndo
> root      5623     1  0 09:13 ?        00:00:00 ndo2db -c 
> /etc/nagios/ndo2db.cfg
> root      5625 12431  0 09:13 pts/1    00:00:00 grep ndo
> naloi     7450  7222  0 Apr28 ?        05:34:40 nautilus 
> --no-default-window --sm-client-id default3
> naloi    27692 27632  0 Apr28 ?        05:37:24 nautilus 
> --no-default-window --sm-client-id default3
> [root at nagios plugins.d]# sudo service nagios start
> Starting nagios: done.
> [root at nagios plugins.d]# tail /var/log/nagios/nagios.log
> [1246281149] Caught SIGTERM, shutting down...
> [1246281149] Successfully shutdown... (PID=4779)
> [1246281149] ndomod: Shutdown complete.
> [1246281149] Event broker module '/usr/sbin/ndomod.o' deinitialized 
> successfully.
> [1246281254] Nagios 2.11 starting... (PID=5641)
> [1246281254] LOG VERSION: 2.0
> [1246281254] ndomod: NDOMOD 1.3.1 Copyright (c) 2005-2006 Ethan 
> Galstad (nagios at nagios.org <mailto:nagios at nagios.org>)
> [1246281254] ndomod: Could not open data sink!  I'll keep trying, but 
> some output may get lost...
> [1246281254] Event broker module '/usr/sbin/ndomod.o' initialized 
> successfully.
> [1246281254] Finished daemonizing... (New PID=5642)
> [root at nagios plugins.d]#
>
>     -----Original Message-----
>     *From:* Michael Friedrich [mailto:michael.friedrich at univie.ac.at]
>     *Sent:* Monday, June 29, 2009 03:29 AM
>     *To:* 'Natalie Aloi'
>     *Cc:* 'Nagios Users Mail-list'
>     *Subject:* Re: [Nagios-users] NDOUtils and Mysql libraries
>     assistance needed
>
>     Hmmm
>
>     stop nagios, stop ndo
>
>     start ndo, start nagios
>
>     if this doesn't do the trick, please tell again, which nagios
>     version and which ndo version you are currently using. afaik
>     nagios 2 works with ndo 1.4b7
>
>     Kind regards,
>     Michael
>
>     Natalie Aloi wrote the following on 25.06.2009 23:10:
>>     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
>>     [root at 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
>>     [root at nagios nagios]# kill 601
>>     [root at nagios nagios]# ps -ef | grep ndo2db
>>     root     13403 12431  0 16:07 pts/1    00:00:00 grep ndo2db
>>     [root at nagios nagios]# cd /usr/sbin
>>     [root at nagios sbin]# ndo2db -c /etc/nagios/ndo2db.cfg
>>     [root at nagios sbin]# sudo service nagios restart
>>     Running configuration check...done
>>     Stopping nagios: .done.
>>     Starting nagios: done.
>>     [root at 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 (nagios at nagios.org <mailto:nagios at 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.friedrich at 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!
>>>         [root at nagios src]# cp ndomod-2x.o /usr/sbin/ndomod.o
>>>         cp: overwrite `/usr/sbin/ndomod.o'? y
>>>         [root at nagios src]# cp ndo2db-2x /usr/sbin/ndo2db
>>>         [root at nagios src]# cd /usr/sbin
>>>         [root at nagios sbin]# ndo2db -c /etc/nagios/ndo2db.cfg
>>>         [root at 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
>>>         [root at nagios sbin]#
>>>          
>>>         Except!...shoot!...I am getting that dumb error but I have
>>>         those lines verified - ndo2db.cfg and ndomod.cfg files included
>>>          
>>>         [root at 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 (nagios at nagios.org <mailto:nagios at 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)
>>>          
>>>         [root at 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
>>>          
>>>         [root at 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
>>>         [root at nagios nagios]#
>>>
>>>
>>>
>>>             -----Original Message-----
>>>             *From:* Michael Friedrich
>>>             [mailto:michael.friedrich at 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?
>>>>              
>>>>             [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
>>>
>>>             ------------------------------------------------------------------------
>>>
>>>             ------------------------------------------------------------------------------
>>>                   
>>>
>>>             ------------------------------------------------------------------------
>>>
>>>             _______________________________________________
>>>             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
>>>
>>
>>         ------------------------------------------------------------------------
>>
>>         ------------------------------------------------------------------------------
>>               
>>
>>         ------------------------------------------------------------------------
>>
>>         _______________________________________________
>>         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
>>
>
>     -- 
>     DI (FH) Michael Friedrich
>     michael.friedrich at univie.ac.at
>     Tel: +43 1 4277 14359
>
>     Vienna University Computer Center
>     Universitaetsstrasse 7 
>     A-1010 Vienna, Austria  
>               
>
>     ------------------------------------------------------------------------
>
>     ------------------------------------------------------------------------------
>           
>
>
>     ------------------------------------------------------------------------
>
>     _______________________________________________
>     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
>

-- 
DI (FH) Michael Friedrich
michael.friedrich at univie.ac.at
Tel: +43 1 4277 14359

Vienna University Computer Center
Universitaetsstrasse 7 
A-1010 Vienna, Austria  

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20090629/325faab0/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