The MySQL Activity Report package is a tool to help MySQL database administrators to collect several database parameters and variables. These collected values can be used for server monitoring or performance tuning purposes.

The most important component of the MySQL Activity Report is mysqlard. This daemon collects the data from a MySQL server and stores these values in a Round Robin Database.

The mysqlard package also contains example graphing, cron and php scripts. The cron scripts can be used to keep archives of the generated graphics and the php script shows the generated graphics and tries to give some tuning tips.
Continue Reading »
Howto MySQL Activity Report

Backing Up & Restoring a MySQL Database using phpMyAdmin / SSH

This is just a short mini-tutorial explaining how to backup parts of the mySQL database using phpMyAdmin & also via SSH (Secure Shell) access. This tutorial should be of use to most people, as it’s an important part of any website/forum maintenance!

So, let’s get started…
Continue Reading »
Howto Backup/Restore Using phpMyAdmin/SSH

Compile Apache + (phpsuexec, not required) + php4 (mod_php4 or cgi) + php5 (cgi)

I’m using Apache 1.3.37 + phpsuexec coming with cPanel + custom php 4.4.7 compiled as cgi (actually you may use the Apache Update via WHM to compile working php4 in cgi mode/phpsuexec) + custom php 5.2.3 compiled as cgi (it is easy to do as well, I will explain)

php5 works the same as php4 and it saves the permissions and etc.
E.g. no problems with nobody as well.
Continue Reading »
Howto Install PHP4 & PHP5 on cPanel

cPanel/WHM/WebMail Login Script for Multi Servers

There are 2 files involved:

1. dologin.php
2. login.php

The first file (dologin.php) takes care of redirecting user to the correct server depending on his choice of cPanel/WHM/Webmail. All secure as well as insecure ports are supported. Any port which you don’t want to use, just remove it from the pulldown menu and rest should work without any changes.
Continue Reading »
cPanel/WHM/WebMail Login Script

This is the down and dirty on resolving your “expired license” woes.
Please let us know if you think there should be any additions.

1. Is the license expired?

This is the most obvious cause and simple to verify. Check http://verify.cpanel.net with the server’s IP.

2. Is the server’s hostname a fully qualified domain name?

I like to check this one and the whether the hostname resolves locally with this command:
Continue Reading »
cPanel Expired License Checklist

In this tutorial you will learn how to modify the cPanel bandwidth exceeded page. This page is shown for clients automatically when they run out of bandwidth. Bandwidth counts are reset every month.
Continue Reading »
Modify Bandwidth Exceeded Page cPanel/WHM

Zend Optimiser is a PHP addon which offers caching to improve speed when loading sites, it can increase perfomance by up to 40% by caching frequently viewed portions of PHP pages. Zend Encoder also is useful for encoding PHP files to protect source code.
Continue Reading »
Howto Install Zend Optimizer on cPanel/WHM