Monthly Archives: August 2008

Install Nagios

How to install nagios In the nagios server 1)Download the tarball of nagios (Here I use nagios-1.0b5 version) #wget http://heanet.dl.sourceforge.net/sourceforge/nagios/nagios-1.0b5.tar.gz 2)Extract the tarball # tar zxvf nagios-1.0b5.tar.gz 3) Create a folder named nagios under /usr/local # mkdir /usr/local/nagios 4)Create a

Posted in Nagios

mysql error = cant connect to mysql socket via /var/lib/mysql

cd /var/lib/mysql touch mysql.sock chown mysql:mysql mysql.sock chmod 777 mysql.sock ln -s /var/lib/mysql/mysql.sock /tmp chmod 777 /tmp /scripts/mysqlup –force /etc/rc.d/init.d/mysql restart

Posted in Mysql

Mysql database restore

mysql backup: var/lib/mysql#mysqldump xx > xx.sql mysql restore: var/lib/mysql#mysql xx < xx.sql

Posted in Mysql

Exim mail queue clear

To clear SPAMS and unwanted mails from the mail queue exim -bp | awk ‘$6~”frozen” {print $3 }’ | xargs exim -Mrm grep -lr ‘nobody@’ /var/spool/exim/input/ | \sed -e ‘s/^.*\/\([a-zA-Z0-9-]*\)-[DH]$/\1/g’ | xargs exim -Mrm grep -rl ‘From: Mail Delivery System’

Posted in Mail, Scripts

Kernel Compilation

Kernel compilation Go to the /usr/src directory Unpack the source code with tar -xvzf linux-2.x.x.tag.gz. Move to the /usr/src/linux sub-directory. make mrproper make menuconfig make all –    make vmlinux —    make modules —    make bzimage make modules_install make install cp

Posted in Server Setup

Horde Issue

Cant find file: horde_sessionhandler.MYI If you get this error, you ve most likely done a file-based MySQL backup restore, and the InnoDB files are hosed. The horde_sessionhandler table isnt a MyISAM table at all – its actually an InnoDB table.

Posted in Mail

Horde Loopback

Loops back to login page in horde solution mysql mysql> use horde; mysql> drop table horde_sessionhandler; mysql> CREATE TABLE horde_sessionhandler ( session_id VARCHAR(32) NOT NULL, session_lastmodified INT NOT NULL, session_data LONGBLOB, PRIMARY KEY (session_id) ) ENGINE = InnoDB;

Posted in Mail
Blog Stats
  • 118,486 hits
Follow

Get every new post delivered to your Inbox.

Join 209 other followers