[prev in list] [next in list] [prev in thread] [next in thread]
List: nagios-users
Subject: Re: [Nagios-users] NDOUtils and Mysql libraries assistance needed
From: "Natalie Aloi" <naloi () experisdatacenters ! com>
Date: 2009-06-29 14:17:56
Message-ID: W849793102154961246285076 () webmail9
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
I am not sure why we are running this old version and need to find out if there is a \
reason and will upgrade if there is no reason not to. thanks for your help! Really!
Natalie
-----Original Message-----
From: Michael Friedrich [mailto:michael.friedrich@univie.ac.at]
Sent: Monday, June 29, 2009 10:10 AM
To: 'Natalie Aloi'
Cc: 'Nagios Users Mail-list'
Subject: Re: [Nagios-users] NDOUtils and Mysql libraries assistance needed
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@nagios plugins.d]# sudo service nagios stop
Stopping nagios: .done.
[root@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@nagios plugins.d]# kill 13956
[root@nagios plugins.d]# ndo2db -c /etc/nagios/ndo2db.cfg
[root@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@nagios plugins.d]# sudo service nagios start
Starting nagios: done.
[root@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@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@nagios plugins.d]#
-----Original Message-----
From: Michael Friedrich [mailto:michael.friedrich@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@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@nagios nagios]# kill 601
[root@nagios nagios]# ps -ef | grep ndo2db
root 13403 12431 0 16:07 pts/1 00:00:00 grep ndo2db
[root@nagios nagios]# cd /usr/sbin
[root@nagios sbin]# ndo2db -c /etc/nagios/ndo2db.cfg
[root@nagios sbin]# sudo service nagios restart
Running configuration check...done
Stopping nagios: .done.
Starting nagios: done.
[root@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@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@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@nagios src]# cp ndomod-2x.o /usr/sbin/ndomod.o
cp: overwrite `/usr/sbin/ndomod.o'? y
[root@nagios src]# cp ndo2db-2x /usr/sbin/ndo2db
[root@nagios src]# cd /usr/sbin
[root@nagios sbin]# ndo2db -c /etc/nagios/ndo2db.cfg
[root@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@nagios sbin]#
Except!...shoot!...I am getting that dumb error but I have those lines verified - \
ndo2db.cfg and ndomod.cfg files included
[root@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@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@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@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@nagios nagios]#
-----Original Message-----
From: Michael Friedrich [mailto:michael.friedrich@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@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@nagios /]# cd /tmp/ndoutils-1.3.1
[root@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@nagios ndoutils-1.3.1]#
-----Original Message-----
From: Natalie Aloi [mailto:naloi@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@nagios ndoutils-1.3.1]#
-----Original Message-----
From: Natalie Aloi [mailto:naloi@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@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@nagios ld.so.conf.d]# more mysql-i386.conf
/usr/lib/mysql
[root@nagios ld.so.conf.d]#
-----Original Message-----
From: Guy Waugh [mailto:guidosh@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@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@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@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@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-users@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-users@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-users@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
-- DI (FH) Michael Friedrichmichael.friedrich@univie.ac.atTel: +43 1 4277 14359Vienna \
University Computer CenterUniversitaetsstrasse 7 A-1010 Vienna, \
Austria
------------------------------------------------------------
------------------------------------------------------------------------------
------------------------------------------------------------
_______________________________________________Nagios-users mailing \
listNagios-users@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
-- DI (FH) Michael Friedrichmichael.friedrich@univie.ac.atTel: +43 1 4277 14359Vienna \
University Computer CenterUniversitaetsstrasse 7 A-1010 Vienna, Austria
[Attachment #5 (text/html)]
<html><DIV><FONT face=Verdana color=#0000ff size=2>I am not sure why we are running \
this old version and need to find out if there is a reason and will upgrade if \
there is no reason not to. thanks for your help! Really!</FONT></DIV> \
<DIV><FONT color=#0000ff size=2></FONT> </DIV> <DIV><FONT color=#0000ff \
size=2>Natalie</FONT></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> Michael Friedrich \
[mailto:michael.friedrich@univie.ac.at]<BR><B>Sent:</B> Monday, June 29, 2009 10:10 \
AM<BR><B>To:</B> 'Natalie Aloi'<BR><B>Cc:</B> 'Nagios Users \
Mail-list'<BR><B>Subject:</B> Re: [Nagios-users] NDOUtils and Mysql libraries \
assistance needed<BR><BR></FONT> <TABLE class="" id=201179 height=400 width="100%" \
bgColor=#ffffff border=0 text="#000000"> <TBODY>
<TR>
<TD class="" vAlign=top width="100%"><TT>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.</TT><BR><BR>Natalie Aloi wrote the following on \
29.06.2009 15:17: <BLOCKQUOTE cite=mid:W813014098229281246281440@webmail33 \
type="cite"> <DIV><FONT face=Verdana color=#0000ff size=2>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...</FONT></DIV> \
<DIV> </DIV> <DIV>[root@nagios plugins.d]# sudo service nagios stop<BR>Stopping \
nagios: .done.<BR>[root@nagios plugins.d]# ps -ef | grep \
ndo<BR>root 5619 12431 0 09:12 \
pts/1 00:00:00 grep ndo<BR>naloi 7450 \
7222 0 Apr28 ? 05:34:40 nautilus \
--no-default-window --sm-client-id default3<BR>root \
13956 1 0 Jun25 \
? 00:00:00 ndo2db -c \
/etc/nagios/ndo2db.cfg<BR>naloi 27692 27632 0 Apr28 \
? 05:37:24 nautilus --no-default-window \
--sm-client-id default3<BR>[root@nagios plugins.d]# kill 13956<BR>[root@nagios \
plugins.d]# ndo2db -c /etc/nagios/ndo2db.cfg<BR>[root@nagios plugins.d]# ps -ef | \
grep ndo<BR>root 5623 1 0 \
09:13 ? 00:00:00 ndo2db -c \
/etc/nagios/ndo2db.cfg<BR>root 5625 12431 0 09:13 \
pts/1 00:00:00 grep ndo<BR>naloi 7450 \
7222 0 Apr28 ? 05:34:40 nautilus \
--no-default-window --sm-client-id default3<BR>naloi 27692 \
27632 0 Apr28 ? 05:37:24 nautilus \
--no-default-window --sm-client-id default3<BR>[root@nagios plugins.d]# sudo service \
nagios start<BR>Starting nagios: done.<BR>[root@nagios plugins.d]# tail \
/var/log/nagios/nagios.log<BR>[1246281149] Caught SIGTERM, shutting \
down...<BR>[1246281149] Successfully shutdown... (PID=4779)<BR>[1246281149] ndomod: \
Shutdown complete.<BR>[1246281149] Event broker module '/usr/sbin/ndomod.o' \
deinitialized successfully.<BR>[1246281254] Nagios 2.11 starting... \
(PID=5641)<BR>[1246281254] LOG VERSION: 2.0<BR>[1246281254] ndomod: NDOMOD 1.3.1 \
Copyright (c) 2005-2006 Ethan Galstad (<A href="mailto:nagios@nagios.org" \
target=_blank moz-do-not-send="true">nagios@nagios.org</A>)<BR>[1246281254] ndomod: \
Could not open data sink! I'll keep trying, but some output may get \
lost...<BR>[1246281254] Event broker module '/usr/sbin/ndomod.o' initialized \
successfully.<BR>[1246281254] Finished daemonizing... (New PID=5642)<BR>[root@nagios \
plugins.d]#<BR></DIV> <BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; \
BORDER-LEFT: rgb(0,0,255) 2px solid; MARGIN-RIGHT: 0px"><FONT face=Tahoma \
size=2>-----Original Message-----<BR><B>From:</B> Michael Friedrich [<A \
class=moz-txt-link-freetext href="mailto:michael.friedrich@univie.ac.at" \
target=_blank>mailto:michael.friedrich@univie.ac.at</A>]<BR><B>Sent:</B> Monday, June \
29, 2009 03:29 AM<BR><B>To:</B> 'Natalie Aloi'<BR><B>Cc:</B> 'Nagios Users \
Mail-list'<BR><B>Subject:</B> Re: [Nagios-users] NDOUtils and Mysql libraries \
assistance needed<BR><BR></FONT> <TABLE class="" id=201179 height=400 width="100%" \
bgColor=#ffffff border=0 text="#000000"> <TBODY>
<TR>
<TD class="" vAlign=top width="100%"><TT>Hmmm<BR><BR>stop nagios, stop \
ndo<BR><BR>start ndo, start nagios<BR><BR>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<BR><BR>Kind regards,<BR>Michael<BR></TT><BR>Natalie \
Aloi wrote the following on 25.06.2009 23:10: <BLOCKQUOTE \
cite=mid:W6077232393294431245964248@webmail56 type="cite"> <DIV><FONT face=Verdana \
color=#0000ff size=2>I change it but am still getting could not sink data \
error...</FONT></DIV> <DIV> </DIV>
<DIV># DATABASE TABLE PREFIX<BR># Determines the prefix (if any) that should be \
prepended to table names.</DIV> <DIV>#db_prefix=<BR>db_prefix=ndo_<BR></DIV>
<DIV><FONT color=#0000ff size=2>then I stopped ndo2db and restarted it, then \
restarted nagios</FONT></DIV> <DIV>[root@nagios nagios]# ps -ef | grep \
ndo2db<BR>root 601 \
1 0 13:04 ? 00:00:00 ndo2db -c \
/etc/nagios/ndo2db.cfg<BR>root 11550 12431 0 16:01 \
pts/1 00:00:00 grep ndo2db<BR>[root@nagios nagios]# kill \
601<BR>[root@nagios nagios]# ps -ef | grep ndo2db<BR>root \
13403 12431 0 16:07 pts/1 00:00:00 grep \
ndo2db<BR>[root@nagios nagios]# cd /usr/sbin<BR>[root@nagios sbin]# ndo2db -c \
/etc/nagios/ndo2db.cfg<BR>[root@nagios sbin]# sudo service nagios restart<BR>Running \
configuration check...done<BR>Stopping nagios: .done.<BR>Starting nagios: \
done.<BR>[root@nagios sbin]# tail /var/log/nagios/nagios.log<BR>[1245960534] Caught \
SIGTERM, shutting down...<BR>[1245960534] Successfully shutdown... \
(PID=3070)<BR>[1245960534] ndomod: Shutdown complete.<BR>[1245960534] Event broker \
module '/usr/sbin/ndomod.o' deinitialized successfully.<BR>[1245960535] Nagios 2.11 \
starting... (PID=14253)<BR>[1245960535] LOG VERSION: 2.0<BR>[1245960535] ndomod: \
NDOMOD 1.3.1 Copyright (c) 2005-2006 Ethan Galstad (<A \
href="mailto:nagios@nagios.org" target=_blank \
moz-do-not-send="true">nagios@nagios.org</A>)<BR>[1245960535] ndomod: Could not open \
data sink! I'll keep trying, but some output may get lost...<BR>[1245960535] \
Event broker module '/usr/sbin/ndomod.o' initialized successfully.<BR>[1245960535] \
Finished daemonizing... (New PID=14254)<BR></DIV> <BLOCKQUOTE style="PADDING-LEFT: \
5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(0,0,255) 2px solid; MARGIN-RIGHT: 0px"><FONT \
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Michael Friedrich [<A \
class=moz-txt-link-freetext href="mailto:michael.friedrich@univie.ac.at" \
target=_blank moz-do-not-send="true">mailto:michael.friedrich@univie.ac.at</A>]<BR><B>Sent:</B> \
Thursday, June 25, 2009 02:18 PM<BR><B>To:</B> 'Natalie Aloi'<BR><B>Cc:</B> 'Nagios \
Users Mail-list'<BR><B>Subject:</B> Re: [Nagios-users] NDOUtils and Mysql libraries \
assistance needed<BR><BR></FONT> <TABLE class="" id=201179 height=400 width="100%" \
bgColor=#ffffff border=0 text="#000000"> <TBODY>
<TR>
<TD class="" vAlign=top width="100%">Your database table scheme is with prefix "ndo_" \
so you have to set that in your ndo2db.cfg too<BR><BR>and make sure you start ndo2db \
first and then nagios.<BR><BR><BR>Natalie Aloi wrote: <BLOCKQUOTE \
cite=mid:W4951716901242431245952687@webmail9 type="cite"> <DIV><FONT face=Verdana \
color=#0000ff size=2>woohoo! Thanks Michael!</FONT></DIV> <DIV>[root@nagios src]# cp \
ndomod-2x.o /usr/sbin/ndomod.o<BR>cp: overwrite `/usr/sbin/ndomod.o'? \
y<BR>[root@nagios src]# cp ndo2db-2x /usr/sbin/ndo2db<BR>[root@nagios src]# cd \
/usr/sbin<BR>[root@nagios sbin]# ndo2db -c /etc/nagios/ndo2db.cfg<BR>[root@nagios \
sbin]# ps -ef | grep ndo2db<BR>root \
601 1 0 13:04 \
? 00:00:00 ndo2db -c \
/etc/nagios/ndo2db.cfg<BR>root 617 12431 0 \
13:04 pts/1 00:00:00 grep ndo2db<BR>[root@nagios sbin]#</DIV> \
<DIV> </DIV> <DIV><FONT color=#0000ff size=2>Except!...shoot!...I am getting \
that dumb error but I have those lines verified - ndo2db.cfg and ndomod.cfg files \
included</FONT></DIV> <DIV> </DIV>
<DIV>[root@nagios nagios]# tail /var/log/nagios/nagios.log<BR>[1245950692] Caught \
SIGTERM, shutting down...<BR>[1245950692] Successfully shutdown... \
(PID=739)<BR>[1245950692] ndomod: Shutdown complete.<BR>[1245950692] Event broker \
module '/usr/sbin/ndomod.o' deinitialized successfully.<BR>[1245950693] Nagios 2.11 \
starting... (PID=1813)<BR>[1245950693] LOG VERSION: 2.0<BR>[1245950693] ndomod: \
NDOMOD 1.3.1 Copyright (c) 2005-2006 Ethan Galstad (<A \
href="mailto:nagios@nagios.org" target=_blank \
moz-do-not-send="true">nagios@nagios.org</A>)<BR>[1245950693] ndomod: Could not open \
data sink! I'll keep trying, but some output may get lost...<BR>[1245950693] \
Event broker module '/usr/sbin/ndomod.o' initialized successfully.<BR>[1245950693] \
Finished daemonizing... (New PID=1814)</DIV> <DIV> </DIV>
<DIV>[root@nagios nagios]# more \
ndomod.cfg<BR>#####################################################################<BR># \
NDOMOD CONFIG FILE<BR>#<BR># Last Modified: \
01-10-2006<BR>#####################################################################</DIV>
<DIV><BR># INSTANCE NAME<BR># This option identifies the "name" associated with this \
particular<BR># instance of Nagios and is used to seperate data coming from \
multiple<BR># instances. Defaults to 'default' (without quotes).</DIV> \
<DIV>instance_name=default</DIV> <DIV> </DIV>
<DIV># OUTPUT TYPE<BR># This option determines what type of output sink the NDO NEB \
module<BR># should use for data output. Valid options include:<BR># \
file = standard text file<BR># \
tcpsocket = TCP socket<BR># unixsocket = UNIX domain socket \
(default)</DIV> <DIV>#output_type=file<BR>#output_type=tcpsocket<BR>output_type=unixsocket</DIV>
<DIV> </DIV>
<DIV># OUTPUT<BR># This option determines the name and path of the file or UNIX \
domain<BR># socket to which output will be sent if the output type option \
specified<BR># above is "file" or "unixsocket", respectively. If the output \
type<BR># option is "tcpsocket", this option is used to specify the IP address<BR># \
of fully qualified domain name of the host that the module should<BR># connect to for \
sending output.</DIV> \
<DIV>#output=/usr/local/nagios/var/ndo.dat<BR>#output=127.0.0.1<BR>output=/var/run/nagios/ndo.sock</DIV>
<DIV> </DIV>
<DIV>[root@nagios nagios]# more \
ndo2db.cfg<BR>#####################################################################<BR># \
NDO2DB DAEMON CONFIG FILE<BR>#<BR># Last Modified: \
02-12-2006<BR>#####################################################################</DIV>
<DIV><BR># SOCKET TYPE<BR># This option determines what type of socket the daemon \
will create<BR># an accept connections from.<BR># Value:<BR># unix = Unix \
domain socket (default)<BR># tcp = TCP socket</DIV> \
<DIV>socket_type=unix<BR>#socket_type=tcp</DIV> <DIV><BR># SOCKET NAME<BR># This \
option determines the name and path of the UNIX domain<BR># socket that the daemon \
will create and accept connections from.<BR># This option is only valid if the socket \
type specified above<BR># is "unix".</DIV> \
<DIV>#socket_name=/usr/local/nagios/var/ndo.sock<BR>socket_name=/var/run/nagios/ndo.sock</DIV>
<DIV> </DIV>
<DIV># TCP PORT<BR># This option determines what port the daemon will listen for<BR># \
connections on. This option is only vlaid if the socket type<BR># specified \
above is "tcp".</DIV> <DIV>tcp_port=5668</DIV>
<DIV> </DIV>
<DIV># DATABASE SERVER TYPE<BR># This option determines what type of DB server the \
daemon should<BR># connect to.<BR># Values:<BR># \
mysql = MySQL<BR># pgsql = PostgreSQL</DIV> \
<DIV>db_servertype=mysql</DIV> <DIV> </DIV>
<DIV># DATABASE HOST<BR># This option specifies what host the DB server is running \
on.</DIV> <DIV>db_host=localhost</DIV>
<DIV> </DIV>
<DIV># DATABASE PORT<BR># This option specifies the port that the DB server is \
running on.<BR># Values:<BR># 3306 = Default \
MySQL port<BR># 5432 = Default PostgreSQL \
port</DIV> <DIV>db_port=3306</DIV>
<DIV> </DIV>
<DIV># DATABASE NAME<BR># This option specifies the name of the database that should \
be used.</DIV> <DIV>db_name=nagios</DIV>
<DIV> </DIV>
<DIV># DATABASE TABLE PREFIX<BR># Determines the prefix (if any) that should be \
prepended to table names.</DIV> <DIV>db_prefix=<BR>#db_prefix=ndo_</DIV>
<DIV> </DIV>
<DIV># DATABASE USERNAME/PASSWORD<BR># This is the username/password that will be \
used to authenticate to the DB.<BR># The user needs at least SELECT, INSERT, UPDATE, \
and DELETE privileges on<BR># the database.</DIV> \
<DIV>#db_user=ndouser<BR>#db_pass=ndopassword<BR>db_user=nagios<BR>db_pass=nagios</DIV>
<DIV><BR>## TABLE TRIMMING OPTIONS<BR># Several database tables containing Nagios \
event data can become quite large<BR># over time. Most admins will want to trim \
these tables and keep only a<BR># certain amount of data in them. The options \
below are used to specify the<BR># age (in MINUTES) that data should be allowd to \
remain in various tables<BR># before it is deleted. Using a value of zero (0) \
for any value means that<BR># that particular table should NOT be automatically \
trimmed.</DIV> <DIV># Keep timed events for 24 \
hours<BR>max_timedevents_age=1440</DIV> <DIV># Keep system commands for 1 \
week<BR>max_systemcommands_age=10080</DIV> <DIV># Keep service checks for 1 \
week<BR>max_servicechecks_age=10080</DIV> <DIV># Keep host checks for 1 \
week<BR>max_hostchecks_age=10080</DIV> <DIV># Keep event handlers for 31 \
days<BR>max_eventhandlers_age=44640<BR>[root@nagios nagios]#<BR><BR><BR><BR></DIV> \
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(0,0,255) 2px \
solid; MARGIN-RIGHT: 0px"><FONT face=Tahoma size=2>-----Original \
Message-----<BR><B>From:</B> Michael Friedrich [<A class=moz-txt-link-freetext \
href="mailto:michael.friedrich@univie.ac.at" target=_blank \
moz-do-not-send="true">mailto:michael.friedrich@univie.ac.at</A>]<BR><B>Sent:</B> \
Thursday, June 25, 2009 12:39 PM<BR><B>To:</B> 'Natalie Aloi'<BR><B>Cc:</B> 'Nagios \
Users Mail-list'<BR><B>Subject:</B> Re: [Nagios-users] NDOUtils and Mysql libraries \
assistance needed<BR><BR></FONT> <TABLE class="" id=201179 height=400 width="100%" \
bgColor=#ffffff border=0 text="#000000"> <TBODY>
<TR>
<TD class="" vAlign=top width="100%"><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 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 moz-do-not-send="true"> </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> </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: rgb(0,0,255) 2px solid; 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" target=_blank \
moz-do-not-send="true">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 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: rgb(0,0,255) 2px \
solid; 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" target=_blank \
moz-do-not-send="true">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 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></FONT></DIV> <BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: \
5px; BORDER-LEFT: rgb(0,0,255) 2px solid; 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" target=_blank \
moz-do-not-send="true">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 \
href="mailto:naloi@experisdatacenters.com" target=_blank moz-do-not-send="true" \
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>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> </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 &nbs \
p; \
|<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 \
moz-do-not-send="true" \
mce_href="mailto:e-mail%3Analoi@experisdatacenters.com">mailto:e-mail%3Analoi@experisd \
atacenters.com</A></DIV><BR>---------------------------------------------------------- \
--------------------<BR><BR>_______________________________________________<BR>Nagios-users \
mailing list<BR><A href="mailto:Nagios-users@lists.sourceforge.net" target=_blank \
moz-do-not-send="true" \
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 \
moz-do-not-send="true" \
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 width="90%" SIZE=4>
------------------------------------------------------------------------------
</PRE><PRE wrap=""><HR width="90%" SIZE=4>
_______________________________________________
Nagios-users mailing list
<A class=moz-txt-link-abbreviated href="mailto:Nagios-users@lists.sourceforge.net" \
target=_blank moz-do-not-send="true">Nagios-users@lists.sourceforge.net</A> <A \
class=moz-txt-link-freetext \
href="https://lists.sourceforge.net/lists/listinfo/nagios-users" target=_blank \
moz-do-not-send="true">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></TD></TR></TBODY><PRE wrap=""><HR width="90%" \
SIZE=4>
------------------------------------------------------------------------------
</PRE><PRE wrap=""><HR width="90%" SIZE=4>
_______________________________________________
Nagios-users mailing list
<A class=moz-txt-link-abbreviated href="mailto:Nagios-users@lists.sourceforge.net" \
target=_blank moz-do-not-send="true">Nagios-users@lists.sourceforge.net</A> <A \
class=moz-txt-link-freetext \
href="https://lists.sourceforge.net/lists/listinfo/nagios-users" target=_blank \
moz-do-not-send="true">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></TABLE></BLOCKQUOTE></BLOCKQUOTE><BR></TD></TR></TBODY><PRE \
wrap=""><HR width="90%" SIZE=4>
------------------------------------------------------------------------------
</PRE><PRE wrap=""><HR width="90%" SIZE=4>
_______________________________________________
Nagios-users mailing list
<A class=moz-txt-link-abbreviated href="mailto:Nagios-users@lists.sourceforge.net" \
target=_blank moz-do-not-send="true">Nagios-users@lists.sourceforge.net</A> <A \
class=moz-txt-link-freetext \
href="https://lists.sourceforge.net/lists/listinfo/nagios-users" target=_blank \
moz-do-not-send="true">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></TABLE></BLOCKQUOTE></BLOCKQUOTE><BR><PRE class=moz-signature \
cols="72">-- DI (FH) Michael Friedrich
<A class=moz-txt-link-abbreviated href="mailto:michael.friedrich@univie.ac.at" \
target=_blank \
moz-do-not-send="true">michael.friedrich@univie.ac.at</A>
Tel: +43 1 4277 14359
Vienna University Computer Center
Universitaetsstrasse 7
A-1010 Vienna, Austria
</PRE></TD></TR></TBODY><PRE wrap=""><HR width="90%" SIZE=4>
------------------------------------------------------------------------------
</PRE><PRE wrap=""><HR width="90%" SIZE=4>
_______________________________________________
Nagios-users mailing list
<A class=moz-txt-link-abbreviated href="mailto:Nagios-users@lists.sourceforge.net" \
target=_blank>Nagios-users@lists.sourceforge.net</A> <A class=moz-txt-link-freetext \
href="https://lists.sourceforge.net/lists/listinfo/nagios-users" \
target=_blank>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></TABLE></BLOCKQUOTE></BLOCKQUOTE><BR><PRE class=moz-signature \
cols="72">-- DI (FH) Michael Friedrich
<A class=moz-txt-link-abbreviated href="mailto:michael.friedrich@univie.ac.at" \
target=_blank>michael.friedrich@univie.ac.at</A>
Tel: +43 1 4277 14359
Vienna University Computer Center
Universitaetsstrasse 7
A-1010 Vienna, Austria
</PRE>
<BLOCKQUOTE></BLOCKQUOTE></TD></TR></TBODY>
<BLOCKQUOTE></BLOCKQUOTE>
<BLOCKQUOTE></BLOCKQUOTE>
<BLOCKQUOTE></BLOCKQUOTE>
<BLOCKQUOTE></BLOCKQUOTE>
<BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></html>
------------------------------------------------------------------------------
_______________________________________________
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
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic