Hello list,
I am wondering if anyone has some suggested values for kernel message queue
parameters when using the latest NDOUtils 1.5. These are required after the
async patch
[http://exchange.nagios.org/directory/Patches/NDOUtils/ndoutils-2Dasync/details]
by andree was added. Within seconds
Hello:
I am using NDOUtils 1.4b9.
I want trimm table logentries.
I take a log to ndo2utils.cfg and only have:
max_timedevents_age=1440
max_systemcommands_age=10080
max_servicechecks_age=10080
max_hostchecks_age=10080
max_eventhandlers_age=44640
max_externalcommands_age=44640
There any max_loge
]
[1328289822]
[1328289822]
[1328289822]
[1328289822]
[1328289822]
[1328289822]
[1328289822]
[1328289822]
From: Andrew Thompson [mailto:and...@fulgent.co.uk]
Sent: 03 February 2012 17:06
To: nagios-users@lists.sourceforge.net
Subject: [Nagios-users] NDOUtils Error writing to data sink! Some
.
[1328289822]
[1328289822]
[1328289822]
[1328289822]
[1328289822]
[1328289822]
[1328289822]
[1328289822]
[1328289822]
From: Andrew Thompson [mailto:and...@fulgent.co.uk]
Sent: 03 February 2012 17:06
To: nagios-users@lists.sourceforge.net
Subject: [Nagios-users] NDOUtils Error writing to data
Hi all,
Ubuntu 11.04 32bit Desktop edition
NDOUtils 1.4b9
Im trying to install NDOUtils so I can get Nagios writing its log files to
MYSQL.
But im not having much luck.
I have followed the install guide to the letter:
http://nagios.sourceforge.net/docs/ndoutils/NDOUtils.pdf
When all said a
Manish Kumar wrote:
> Hi Frnds,
>
> I am not able to configure NDOUtils-1.4b9 with Nagios Core-3.2.3 on
> fedora 14. I am getting this error:-
> Support for the specified database server is either not yet supported,
> or was not found on your system.
>
> I am using Mysql and its running properly.
Hi Frnds,
I am not able to configure NDOUtils-1.4b9 with Nagios Core-3.2.3 on fedora
14. I am getting this error:-
Support for the specified database server is either not yet supported, or
was not found on your system.
I am using Mysql and its running properly. I am able to see the tables
populat
we upgraded from
1.4b7 to 1.4b9
nagios version was upgraded from 2.x to 3.2.3
There is no way to correlate contact notified to notifications anymore since
the first that used to track it is now inserted with '0' all the time
(confirmed via debug mode)
the specific field is CONTACT_OBJECT_ID in NA
Arh, all ok now.
I was still using the command switch after installing the devel package. A
straight up ./configure show the lib as found.
All's good. )
From: Tristan Drinkwater [mailto:trist...@micro-p.com]
Sent: 11 May 2011 12:45
To: Nagios Users List
Subject: Re: [Nagios-users] ndo
Hi,
I'm running fedora 14 with the latest mysql-devel packages installed.
Thanks
tristan
From: ranjib dey [mailto:dey.ran...@gmail.com]
Sent: 11 May 2011 12:39
To: Nagios Users List
Subject: Re: [Nagios-users] ndoutils 1.4b9 - Mysql Library not found
which OS you are running on? Do you
which OS you are running on? Do you have the mysql headers installed
(mysql-devel.rpm or something similar)?
regards
ranjib
On Wed, May 11, 2011 at 2:34 PM, Tristan Drinkwater wrote:
> Hi guys,
>
>
>
> I’m looking to start filling a database for every alert that Nagios makes.
>
>
>
> I’ve come ac
Hi guys,
I'm looking to start filling a database for every alert that Nagios makes.
I've come across the ndoutils but when I try to ./configure the install it
keeps telling me that it can't find the mysql library's.
I have tried the --with-mysql=/usr/lib/mysql and I've checked that the library
Hi all,
I have setup Nagios passive checks to get SNMP-traps into Nagios
(using snmptrapd -> snmptt -> submit_check_result). This works
fine, even automatic clearing of old results after some days
works as expected.
Now I have setup ndoutils and NagVis. A host that sent a snmp trap
has a status "
Hi,
Carl Friend wrote:
>> Well I've sent a patch a few months ago to nagios-devel but iirc it's
>> only in CVS, not within a new beta release. An Icinga user pointed me to
>> that problem.
>>
>> http://markmail.org/message/jsolx6j6jl74aqpj
>> https://dev.icinga.org/issues/219
>>
> I caug
Michael Friedrich writes:
> Well I've sent a patch a few months ago to nagios-devel but iirc it's
> only in CVS, not within a new beta release. An Icinga user pointed me to
> that problem.
>
> http://markmail.org/message/jsolx6j6jl74aqpj
> https://dev.icinga.org/issues/219
I caught one of
Hi,
Carl Friend wrote:
> I tried updating my (perfectly working, mind you) ndoutils from
> 1.4b7 to 1.4b9 over the weekend and was primarily rewarded with
> segfaults and other grief which has resisted investigation and
> fixes. The errors were introduced in 1.4b8 and persist into 1.4b9.
> I'
Greetings,
I tried updating my (perfectly working, mind you) ndoutils from
1.4b7 to 1.4b9 over the weekend and was primarily rewarded with
segfaults and other grief which has resisted investigation and
fixes. The errors were introduced in 1.4b8 and persist into 1.4b9.
I'm running on Solaris
Can someone point out the patch location. I have searched nagios-devel
mailing list but could not find it. Thanks in advance.
On Tue, Nov 10, 2009 at 6:09 PM, Michael Friedrich <
michael.friedr...@univie.ac.at> wrote:
>
>
> Øyvind Nordang wrote:
> > Duplicate lines for each service check in ser
Hi,
After a electrical crash, I have a problem with ndoutils, nagios start
and works correctly when ndo2db isn't started .
When I start ndo2db, nagios blocks.
When ndo2db is started , nagios connect to ndo2db:
[1275478646] ndomod: Successfully reconnected to data sink! 113098
items lost, 500
Hi there,
we had an issue with servicechecks where duplicate rows where inserted
instead of updating one single row. During my analysis there was more of
that "feature"...
Looking at timedevents table ... there also is no unique constraint
since unique key != key
now it looks like this:
+
Øyvind Nordang wrote:
> Duplicate lines for each service check in servicechecks table
> (ndoutils 1.4b9)
>
> I have:
> Nagios 3.2.0
> NDOutils 1.4b9
>
> Is this a bug of feature?
I've attached the patch to nagios-devel, dunno when it will be fixed
then. But I have analyzed more queries, and the
Duplicate lines for each service check in servicechecks table (ndoutils
1.4b9)
I have:
Nagios 3.2.0
NDOutils 1.4b9
Is this a bug of feature?
I've attached a screenshot from phpmyadmin, notice the service_object_id.
It's listed twice for each service. Notice also the rest of the info, some
of the
Hi Michael,
Am Dienstag, den 22.09.2009, 09:07 +0200 schrieb Michael Friedrich:
[...]
> Before you ask there is no key value for everyone. It's highly dependant
> on the rdbm (in this case only MySQL), hardware and i/o, and on the
> Nagios config and check intervals and generated events etc.
Hi,
Denny Schierz wrote the following on 21.09.2009 23:13:
> but this helps only a few minutes (10-15min). So, any suggestions?
>
Depending on your db trimming settings and the count of hosts/services
you may encounter concurrent insert/update and delete statements.
If your event broker option
hi,
Our Nagios was running in a Vmware machine with a normal load round
about 1 or less on 4 CPU baremetal. We moved now from Vmware Server to
KVM on a CentOS. Nagios runs on Debian Lenny system with Centreon 2.x.
I don't now enough about MySQL, to solve my problem, so i need a little
bit help.
Friedrich Subject:
Re: [Nagios-users] ndoutils To: nagios-users@lists.sourceforge.net
Message-ID: <4ab57fc3.4080...@univie.ac.at> Content-Type: text/plain;
charset=ISO-8859-1; format=flowed Hi, Dusan Simek wrote:
> >
> > The libraries for mysql are in this directory:
$ rpm -qa
Hi,
Dusan Simek wrote:
>
> The libraries for mysql are in this directory:
$ rpm -qa --qf "%{n}-%{arch}\n" *mysql*
tells what?
Kind regards,
Michael
--
Come build with us! The BlackBerry® Developer Conference in SF, CA
Hi,
I have problem with compile ndoutils with mysql lib. Still I get error:
"MySQL library could not be located..."
I compile ndo utils with option ./configure --with-mysql=/usr/lib64/mysql
and try it also with --with-mysql-lib=/usr/lib64/mysql
The libraries for mysql are in this directory:
[r
On Sep 9, 2009, at 2:39 PM, Deniz Yoldüz wrote:
> ok, i've found the threads here :
> http://www.mail-archive.com/nagios-users@lists.sourceforge.net/msg08149.html
I don't see how your problem is connected with that 3 year old thread.
Can you explain the connection?
> The problem is when i try
Hi,
Deniz Yoldüz wrote:
> ok, i've found the threads here :
> http://www.mail-archive.com/nagios-users@lists.sourceforge.net/msg08149.html
> The problem is when i try to compile ndoutils with the configure
> command below, i'm getting that error.
> ./configure --prefix=/usr/local/nagios/ --enabl
ok, i've found the threads here :
http://www.mail-archive.com/nagios-users@lists.sourceforge.net/msg08149.html
The problem is when i try to compile ndoutils with the configure command
below, i'm getting that error.
./configure --prefix=/usr/local/nagios/ --enable-mysql
--with-mysql-lib=/usr/lib64/m
On Sep 9, 2009, at 7:59 AM, Deniz Yoldüz wrote:
> Hi,
> i did what you said on previous posts but still having the same
> problem. Server runs 2.6.24.4-64.fc8 x86_64 kernel. i added CFLAGS="-
> fPIC" and showed my libraries of mysql64 in configure but still no
> good configuration status i h
Hi,
i did what you said on previous posts but still having the same problem.
Server runs 2.6.24.4-64.fc8 x86_64 kernel. i added CFLAGS="-fPIC" and showed
my libraries of mysql64 in configure but still no good configuration status
i have. Any updates about this you may know?
Thnx for all.
-
My apologies... didn't mean to come across as rude. I figured that
others may have tools like Cacti along with NDOutils on the same server
and thus might find that they have multiple database types as well...
hence my email to the Nagios list instead of the mysql list. In my case,
I learned the
On Aug 7, 2009, at 3:15 PM, Andrew Davis wrote:
> Really? You sure about that? I'm pretty confident that mysql
> supports different types of databases (myISAM and InnoDB as two of
> them) as well as different table types within a database.
If you really wanted to be sure about that and not q
Really? You sure about that? I'm pretty confident that mysql supports
different types of databases (myISAM and InnoDB as two of them) as well
as different table types within a database. Your reply did help, though,
as when I ran it for the default mysql DB, I was reminded of the phrase
"engine"
On 08/07/2009 03:03 PM, Andrew Davis wrote:
> Our Nagios server also has Cacti on it. I'm pretty sure that Cacti uses
> an InnoDB database, while NDOUtils uses myISAM. The two are backed up
> differently (example: mysqlhotcopy doesn't working on InnoDB databases).
> Does anyone know what mysql c
Okay, perhaps I inverted it then. My build of Cacti stores everything to
a mysql DB, though it could admittedly be a myISAM DB with NDOutils
being of the InnoDB type. However it works out, I'm pretty confident
that I have two database types on one mysql server and I'm trying to
figure out how t
I would double check these information. Cacti runs on rrd( round robin
database). I have innodb for my ndoutils 1.47b.
On Fri, Aug 7, 2009 at 3:03 PM, Andrew Davis wrote:
> Our Nagios server also has Cacti on it. I'm pretty sure that Cacti uses an
> InnoDB database, while NDOUtils uses myISAM
On Aug 7, 2009, at 2:03 PM, Andrew Davis wrote:
> Our Nagios server also has Cacti on it. I'm pretty sure that Cacti
> uses an InnoDB database, while NDOUtils uses myISAM. The two are
> backed up differently (example: mysqlhotcopy doesn't working on
> InnoDB databases). Does anyone know wha
Our Nagios server also has Cacti on it. I'm pretty sure that Cacti uses
an InnoDB database, while NDOUtils uses myISAM. The two are backed up
differently (example: mysqlhotcopy doesn't working on InnoDB databases).
Does anyone know what mysql command you run to determine which type of
DB is use
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Am 04.08.09 20:52, schrieb shadih rahman:
> I am thinking about doing a ndoutils update to 1.48b from 1.47b.
>
> I see that I need to change db schema and make some changes.
>
> my ndo has been collecting data over 6 months for medium size instal
On Aug 4, 2009, at 1:52 PM, shadih rahman wrote:
> I am thinking about doing a ndoutils update to 1.48b from 1.47b.
>
> I see that I need to change db schema and make some changes.
>
> my ndo has been collecting data over 6 months for medium size
> installation.
>
> Should I be concerned or tak
Hello,
It would be a good idea to back up your database before you apply the
update, and make sure you know how to restore the database if the upgrade
fails.
Regards,
Guy.
On Tue, Aug 4, 2009 at 7:52 PM, shadih rahman wrote:
> I am thinking about doing a ndoutils update to 1.48b from 1.47b.
>
I am thinking about doing a ndoutils update to 1.48b from 1.47b.
I see that I need to change db schema and make some changes.
my ndo has been collecting data over 6 months for medium size installation.
Should I be concerned or take special pre-caution? Please advise on this.
Thanks
--
Cordial
-
> From: Leveau Stanislas [mailto:stanislas.lev...@ac-caen.fr]
> Sent: Thursday, July 30, 2009 1:52 PM
> To: Hardip Zhim
> Cc: nagios-users@lists.sourceforge.net
> Subject: Re: [Nagios-users] NDOUTILS install problem
>
> hi
>
> where did you have configure database access
The DB is on the same machine and I have configured it in the ndo2db.cfg
-Original Message-
From: Leveau Stanislas [mailto:stanislas.lev...@ac-caen.fr]
Sent: Thursday, July 30, 2009 1:52 PM
To: Hardip Zhim
Cc: nagios-users@lists.sourceforge.net
Subject: Re: [Nagios-users] NDOUTILS
On Thu, 30 Jul 2009, Hardip Zhim wrote:
> I am trying to install NDOUTILS version 1.4b5 on nagios 3.0.6 in a Ubuntu
> Machine.
>
> I am getting the following error message:
>
> sudo /usr/local/nagios/bin/ndo2db-3x -c /usr/local/nagios/etc/ndo2db.cfg
>
> Support for the specified database serv
hi
where did you have configure database access?
bye
Stan
> Hi,
>
>
>
> I am trying to install NDOUTILS version 1.4b5 on nagios 3.0.6 in a
> Ubuntu Machine.
>
>
>
>
>
> I am getting the following error message:
>
>
>
> sudo /usr/local/nagios/bin/ndo2db-3x -c
> /usr/local/nagios/etc/ndo2db.cfg
>
Hi,
I am trying to install NDOUTILS version 1.4b5 on nagios 3.0.6 in a
Ubuntu Machine.
I am getting the following error message:
sudo /usr/local/nagios/bin/ndo2db-3x -c
/usr/local/nagios/etc/ndo2db.cfg
Support for the specified database server is either not yet supported,
o
does anyone know what this means?
[r...@dns /]# /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
Support for the specified database server is either not yet supported, or was
not found on your system.
[r...@dns /]#
But you can see it's installed I have also included the output fr
-
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
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
*T
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 Ma
utils-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
ted, 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 assist
;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] NDO
o: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.ddo I just do steps 2-4 now since there is
already a file that points to i
Once again,
./configure --help
gives you all the help you need.
Try
ls /usr/lib/mysql | grep libmysqlclient.so
and check the output. If there is nothing found, try
find /usr/lib/ | grep libmysqlclient.so
The path to the found file (in case) is the one you need for configure e.g.
./configur
.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 P
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
in
>>Have you installed Mysql and the libmysql libraries on the machine ?
>>what distro are you using ?
below are the mysql packages that I have installed on my machine...I am using
Fedora 9
[r...@nagios etc]# rpm -qa | grep mysql
qt-mysql-4.5.0-14.fc9.i386
mysql-administrator-5.0r12-8.fc9.i386
mys
Have you installed Mysql and the libmysql libraries on the machine ?
what distro are you using ?
Assaf
On Tuesday 23 June 2009 13:01:17 Natalie Aloi wrote:
> ok during my compile I found this information...
>
> *** MySQL library could not be located... **
> You chose t
ok during my compile I found this information...
*** 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 speci
suse:
yast -i mysql-devel
rhel/centos
yum install mysql-devel
debian/ubuntu
apt-get install libmysqlclient15-dev
---
./configure --enable-mysql --with-mysql-lib=/usr/mysql/lib --disable-pgsql
make
Kind regards,
Michael
Carsten Schmidt wrote the following on 22.06.2009 21:54:
Hello Natalie,
Hello Natalie,
you need to compile ndoutils with mysql-support. A normal ./configure
should find the required files, so maybe:
a) your system lacks the mysql-development-libraries (on debian/ubuntu
the package is called "libmysqlclient-dev" I think).
configure should write out the following lin
Hello
I need some additional help for installing NDOUtils1.3.1 I am running nagios
v2.11 and am trying to get nagvis installed
I have installed the mysql database and it has this information in it
mysql> CREATE DATABASE nagios;
ERROR 1007 (HY000): Can't create database 'nagios'; database exists
yokoy...@rd.aisin.co.jp
> À: nagios-users@lists.sourceforge.net
> Envoyé: Mardi 26 Mai 2009 11h17:47 GMT +01:00 Amsterdam / Berlin /
> Berne / Rome / Stockholm / Vienne
> Objet: [Nagios-users] (ndoutils) DB create error
>
>
>
> Hi, everybody :-)
>
> I have a problem
Hello
did you create a the DB with the mysqladmin -create command before you executed
the tables
creation ?
Assaf
On Tuesday 26 May 2009 09:17:47 yokoy...@rd.aisin.co.jp wrote:
> Hi, everybody :-)
>
> I have a problem about ndoutils.
> Please help me !
>
> < Problem >
>
> ./installdb -u r
01:00 Amsterdam / Berlin / Berne / Rome
/ Stockholm / Vienne
Objet: [Nagios-users] (ndoutils) DB create error
Hi, everybody :-)
I have a problem about ndoutils.
Please help me !
< Problem >
./installdb -u root -p yokoMySql -h localhost -d ndoutils
DBD::mysql
Hi, everybody :-)
I have a problem about ndoutils.
Please help me !
< Problem >
./installdb -u root -p yokoMySql -h localhost -d ndoutils
DBD::mysql::db do failed: Table 'ndoutils.nagios_dbversion' doesn't exist
at ./installdb line 51.
No installation script found! at ./installdb line 62
So,
Hi all,
I'm thinking to use some custom variables in services' definition. As I'm using
NDOUtils, I wanted to see how those variables where saved in the database and I
found two tables : customvariables and customvariablestatus.
I understand what the customvariablestatus' fields are for, but I
Hi,
i am trying to install NDOutils to stock all events in a mysql database.
the event broker module ndomod-3x.o is starting correctly but i next get the
message :
"ndomod:unable to connect data sink"
What can i do?
Many thanks
T Granier--
Hello everyone.
I am using Nagios 3.0.6 with ndoutils 1.4b7 and MySQL 5.0 on a Linux
machine CentOS 5.2 (2.6.18) with 2GB ram and x64 Intel Xeon 2.50GHz
processor in the laboratory environment.
I chose to use the ndoutils to maintain historical information aboutchecks
on the database (tables nag
All,
I recently discovered that my nagios setup is only storing in
nagios_hostchecks table. In my ndomod.cfg file I have selected
data_processing_options=67108863, which suppose to process all data. Little
overview about my setup I have two mahcine running nagios active failover
settings. O
El Tue, 31 Mar 2009 07:51:05 -0500Marc Powell escribió:> broker_module=/usr/local/nagios/bin/ndomod.o config_file=/usr/local/ > nagios/etc/ndomod.cfgHi, Thanks, It's now solved, I passed the argument to the module and the communication was stablished. I found other problems which I solved too. May
On Mar 31, 2009, at 5:12 AM, Juan Cañete Azorin wrote:
> I tried switching the ndomod and ndo2db communication between
> unix_socket to tcp and,
>
I've had success with socket.
> althought the ndo2db starts ok, nagios always prints the lines
> below, and no connection between ndomod and ndo2d
Hi, I'm trying to configure the ndoutils plugin to store event info on a myslq database. I compiled it OK and the ndo2db process starts OK, but when I start nagios it prints this: [1238492025] Nagios 3.0.6 starting... (PID=7847)[1238492025] Local time is Tue Mar 31 11:33:45 CEST 2009[1238492025] LO
2009/3/4 Marc DeTrano :
> 2009/3/3 Livio Zanol Puppim :
> I'm no expert at MySQL performance, but we found a couple of things that
> helped speed up NDO significantly:
>
> -We are using a my.cnf based on the "my-innodb-heavy-4G.cnf" example
> that comes with MySQL.
> -The innodb_flush_log_at_trx_co
I've tweaked the ndo configuration... It doesn't saves logs at database, and
I'm still having this problem.
I'll give a try at everybody suggestion tomorow. Thanks very much! :)
2009/3/4 Marc Powell
>
> On Mar 4, 2009, at 5:19 PM, Marc DeTrano wrote:
>
> > 2009/3/3 Livio Zanol Puppim :
>
> >
>
On Mar 4, 2009, at 5:19 PM, Marc DeTrano wrote:
> 2009/3/3 Livio Zanol Puppim :
>
> -We are using a my.cnf based on the "my-innodb-heavy-4G.cnf" example
> that comes with MySQL.
> -The innodb_flush_log_at_trx_commit setting in that file is
> "2" (instead
> of 1..the difference in performance i
2009/3/3 Livio Zanol Puppim :
> >
> > I'm having huge troubles with Mysql using 100% of CPU at peculiar times. I
> > don't know when this problem starts and I don't know the reason, but when it
> > happends I kill nagios, ndoutils and Mysql, and try to restart Mysql,
> > ndoutils and Nagios at thi
Nagios at this order. When I start Nagios, the CPU
> usage of Mysql goes to 100% and everything just freezes with the
> initials INSERT/UPDATES made by ndoutils.
You can read this thread too:
[Nagios-users] NDOutils and Nagios startup speed
http://www.mail-archive.com/nagios-users@li
2009/3/3 Livio Zanol Puppim :
> Hello everyone!
>
> I'm having huge troubles with Mysql using 100% of CPU at peculiar times. I
> don't know when this problem starts and I don't know the reason, but when it
> happends I kill nagios, ndoutils and Mysql, and try to restart Mysql,
> ndoutils and Nagios
Hello everyone!
I'm having huge troubles with Mysql using 100% of CPU at peculiar times. I
don't know when this problem starts and I don't know the reason, but when it
happends I kill nagios, ndoutils and Mysql, and try to restart Mysql,
ndoutils and Nagios at this order. When I start Nagios, the
2009/1/29 Mathieu Gagné :
> One way to speed up Nagios start when using NDOutils is to tweak
> "event_broker_options".
>
> Here is my new configuration, based on constants defined in
> include/broker.h:
>
> # BROKER_EVERYTHING 1048575
> # -BROKER_TIMED_EVENTS 2
> # -BROKER_SERVICE_CHECKS 4
NDOutils is a read-only version of Nagios configuration and status.
Configuration and status are exported to NDOutils at startup and updated
by the event broker whenever there's a status change in Nagios.
Nagios configuration won't be loaded from NDOutils as it's a one-way
communication.
htt
I'm configuring my Nagios Server and I want to install NDOUtils to
later install Nagovis. I have read that when I intall and configure
NDO all my files will be stored in Data Bases. I need to know how easy
is to change any Nagios configuration file (*.cfg) once they be stored
in Data Bases.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 28/01/09 08:05 PM, Mathieu Gagné wrote:
> Hi,
>
> Marc Powell wrote:
>>> Is there a way to speed things up? Any help would be appreciated.
>>> Thanks.
>> I'm interested in tips as well.
>>
>
> One way to speed up Nagios start when using NDOutils
Hi,
Marc Powell wrote:
>
>> Is there a way to speed things up? Any help would be appreciated.
>> Thanks.
>
> I'm interested in tips as well.
>
One way to speed up Nagios start when using NDOutils is to tweak
"event_broker_options".
Here is my new configuration, based on constants defined i
Hi,
Marc Powell wrote:
> On Jan 26, 2009, at 4:46 PM, Mathieu Gagné wrote:
>
>> Unfortunately, we can't afford this kind of downtime while
>> Nagios/NDOutils is busy exporting to MySQL. Also, host/service status
>> are not available while the reload is occuring.
>
> While I can't really speak to
On Jan 26, 2009, at 4:46 PM, Mathieu Gagné wrote:
> Unfortunately, we can't afford this kind of downtime while
> Nagios/NDOutils is busy exporting to MySQL. Also, host/service status
> are not available while the reload is occuring.
While I can't really speak to the more general problem (I exper
Hi all,
We are running 5 Nagios instances (4 x Nagios2 and 1 x Nagios3) which
are all using NDOutils. (and more without NDOutils)
Our instances are restarted frequently as we are constantly adding new
hosts and services.
(re)starting an instance can take about 3-4 minutes because NDOutils has
Hi again
Like explain in this post
http://www.mail-archive.com/nagios-users@lists.sourceforge.net/msg15394.html
running ndomod with output_type tcpsocket or unixsocket slow down nagios
because until the data from nagios is stored in mysql, nagios no
continue working. (sync)
We try to work wit
Hello,
I have been trying to setup ndoutils 1.4b7 from the freebsd ports
collection and can't seem to get past loading the ndo2db_enable="YES" in
the rc.conf file. This line "/etc/rc: WARNING: run_rc_command: cannot
run /usr/local/bin/ndo2db" shows up after I see the starting Nagios
line on my co
Hi Alan,
Up to yesterday I had a similar problem with our NDO db on the same spec box as
yours.
Are your tables primarily type innodb like mine ?
I am asking as my NDO db was created by Centreon's install script and not the
normal way, if so then the following may help.
Your initial post show
On Wed, Aug 20, 2008 at 8:46 PM, Alan Cooper <[EMAIL PROTECTED]> wrote:
> Thanks for the replies,
>
> Unfortunately, all the tables are already indexed so I'm back to the
> underlying problem is that there are so many joins on big tables so
> MySQL has to copy to temp tables each time - I'd really
Thomas Guyot-Sionnest wrote:
>
> I'm not a SQL guru, but here's some thing I'd try... You may get better
> help from SQL/MySQL communities.
>
> * Make sure obj1.name1 is indexed (or is a PK)
> * Make sure every columns in the JOINs are indexed/PKs
> * Try removing the ORDER BY (i.e. sort it in the
On Aug 20, 2008, at 7:08 AM, Thomas Guyot-Sionnest wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 20/08/08 04:56 AM, Alan Cooper wrote:
>> I am having problem scaling up a system we use to gather status data
>> from the NDO db:
>>
>> Does anyone have any suggestions for improvin
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 20/08/08 04:56 AM, Alan Cooper wrote:
> I am having problem scaling up a system we use to gather status data
> from the NDO db:
>
> The query I currently use is:-
>
> SELECT
> obj1.name1 AS host_name,
> nagios_hoststatus.problem_has_been_acknowle
1 - 100 of 199 matches
Mail list logo
