Roderick Derks

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

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

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

On synology

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

read more

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

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

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

read more

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

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