Posts By :

Roderick Derks

Column count of mysql.db is wrong 150 150 Roderick Derks

Column count of mysql.db is wrong

Error on starting mysqld

# tail -f /var/log/mysqld.log

120807 14:48:55  InnoDB: Started; log sequence number 0 161811
120807 14:48:55 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50***, now running 50***. Please use mysql_upgrade to fix this error.
120807 14:48:55 [ERROR] mysql.user has no `Event_priv` column at position 29
120807 14:48:55 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
120807 14:48:55 [Note] /usr/libexec/mysqld: ready for connections. Version: ‘5.*.**’  socket: ‘/var/lib/mysql/mysql.sock’  port: 3306  Source distribution
 

read more

Centreon: NTOP 150 150 Roderick Derks

Centreon: NTOP

How to install NTOP in Centreon, I started it but couldn’t finish it because of the incompatibility of NTOP module with the newer Centreon versions. Read more:

read more

Synology: howto measure disk io 150 150 Roderick Derks

Synology: howto measure disk io

By default there is no tool to measure disk IO. Bootstrap your Synology to make this possible and download the package dstat.

This is what I did on my DS411J

read more

Synology: snmp and disk temperatures 150 150 Roderick Derks

Synology: snmp and disk temperatures

On synology

Check if this command works on your Synology:
smartctl -a /dev/hda -d ata | egrep "Model|Temp"

read more

Centreon: error while updating RRD graphs 150 150 Roderick Derks

Centreon: error while updating RRD graphs

Problem

It happended to me a few times that all of the Centreon graphs would not update anymore. And in /usr/local/centreon/log/centstorage.log I get a lot of these error messages:
2012-07-07 11:52:30 - ERROR while updating /var/lib/centreon/metrics/91.rrd at 1341654743 -> 0.00 : /var/lib/centreon/metrics/91.rrd: illegal attempt to update using time 1341654743 when last update time is 1341675817 (minimum one second step)

read more

NDO2DB and kernel parameters 150 150 Roderick Derks

NDO2DB and kernel parameters

What did I do:

# cat /proc/sys/kernel/msgmnb
65536
# cat /proc/sys/kernel/msgmax
65536
# cat /proc/sys/kernel/msgmni
1985

# echo 131072 > /proc/sys/kernel/msgmnb
and
# vi /etc/sysctl.conf
and adjust the appropriate value(s).

read more

Centreon and Nagios on Centos 6.2 150 150 Roderick Derks

Centreon and Nagios on Centos 6.2

A complete guide step by step on howto install Centreon on Centos 6.2. This is worth some money guys.

read more

Nagios: setup monitoring via WMI 150 150 Roderick Derks

Nagios: setup monitoring via WMI

Download the Zenoss WMI library, compile and install.

wget http://dev.zenoss.org/svn/trunk/inst/externallibs/wmi-1.3.16.tar.bz2
tar xvjf wmi-1.3.16.tar.bz2
cd wmi-1.3.16
 

read more

Weathermap standalone install and config 150 150 Roderick Derks

Weathermap standalone install and config

Install Weathermap

cd /tmp

wget http://www.network-weathermap.com/files/php-weathermap-0.97a.zip

unzip php-weathermap-0.97a.zip
mv weathermap /usr/local
cd /usr/local/weathermap/
chown -R apache:apache *
chmod u+w ./configs
mv editor-config.php-dist editor-config.php

cd /etc/httpd/conf.d/
vi weathermap.conf

# php-weathermap-0.9
# PHP-WEATHERMAP : A php writen network weathermap graphing tool
#
Alias /weathermap “/usr/local/weathermap”

<Directory “/usr/local/weathermap”>
    #Order Deny,Allow Deny from all
    # Allow from (ip address allowed) (take care, you must remove # to make this line readable)
    Allow from 127.0.0.1
</Directory>

read more

Nagios: install check_oracle_health plugin 150 150 Roderick Derks

Nagios: install check_oracle_health plugin

Introduction

In our example scenario, we are testing against “Oracle Database 11g Express Edition”, however the monitoring should be uniform across all Oracle database platforms. Our Opsview server is running on Ubuntu 10.04 32-bit, however this document can be altered to fit RHEL/CentOS/SLES etc and also 32/64 bit with some slight changes.

read more

Your Name (required)

Your Email (required)

Subject

Your Message

Your Name (required)

Your Email (required)

Subject

Your Message