Fatal error: Maximum execution time of 300 seconds exceeded with phpMyAdmin

PHPMyAdmin will not work for uploading large mysql databases. If you attempt to upload a large mysql dataset you will often get this error

Fatal error: Maximum execution time of 300 seconds exceeded

Here is the Fix

If you get this error you will need edit config.default.php inside phpmyadmin folder and look for this line

$cfg[’ExecTimeLimit’] = 300;

and replace with 0 or any larger value

$cfg[’ExecTimeLimit’] = 3600;

Install and Configure lighttpd

Lighttpd is a lightweight HTTP server. It functions much the same way Apache does, but uses up far less system resources, and in most configurations, is faster. Lighttpd is used by several popular Web 2.0 sites such as YouTube, Wikipedia, and Meebo.
Read the rest of this entry »

upgrading from RH/Fedora to CentOS 4.0 with yum

upgrading from RH/Fedora to CentOS 4.0 with yum

Substitute your choice of mirror sites

(install GPG key)
rpm –import http://www.gtlib.gatech.edu/pub/centos/4.0/os/i386/RPM-GPG-KEY-CentOS-4

(need these 3 files)

wget http://www.gtlib.gatech.edu/pub/centos/4.0/os/i386/CentOS/RPMS/centos-release-4-0.1.i386.rpm
wget http://www.gtlib.gatech.edu/pub/centos/4.0/os/i386/CentOS/RPMS/centos-yumconf-4-2.noarch.rpm
wget http://www.gtlib.gatech.edu/pub/centos/4.0/os/i386/CentOS/RPMS/yum-2.2.0-1.centos4.2.noarch.rpm

(install)
rpm -Uvh –force centos-release-4-0.1.i386.rpm centos-yumconf-4-2.noarch.rpm yum-2.2.0-1.centos4.2.noarch.rpm

(upgrade)

yum upgrade

After the list of packages is displayed, choose ‘y’ to download and install.

If a new kernel was downloaded, then you might need to modify the grub.conf to set the ‘default’ entry to the new kernel. Kernel entries in the grub.conf are numbered starting with 0, not 1.

Reboot. That’s it! You’re done! If running into problems contact our support department.

Installing SIM – system Integrity Monitor

SIM is a system and services monitor for ‘SysVinit’ systems. It is designed to be intuitive and modular in nature, and to provide a clean and informative status system……

It does this by consistently verifying that services are online, load averages are in check, and log files are at reasonable sizes. Many other SIM modules sport different and in-depth features to bring a well rounded tool to your disposal to stop otherwise common issues daunting internet hosts.

This is simple method for installing SIM on Linux server.

Login to your server via SSH as root

First step is to wget file

#wget http://www.r-fx.org/downloads/sim-current.tar.gz

Untar file by using floowing command
#tar -xzvf sim-current.tar.gz

Type: cd sim-2.5-3
./setup -i

Where is SIM installed ?This will give you path of SIM
[/usr/local/sim]:
{enter}

Where should the sim.log file be created ?
[/usr/local/sim/sim.log]:
{enter}

Max size of sim.log before rotated ? Kb
[128]:1024
{enter}

[root]:youremail@email.com
{enter}

Disable alert emails after how many events, to avoid email flood ?
(Note: events stats are cleared daily)
[10]:3
{enter}

The below are configuration options for Service modules:
press return to continue…
{enter}

Auto-restart services found to be offline ? (true=enable, false=disable)
[true]:
{enter}

Enforce laxed service checking ? (true=enable, false=disable)
[true]:
{enter}

Disable auto-restart after how many downed service events ?
(Note: events stats are cleared daily)
[10]:
{enter}

Enable FTP service monitoring ? (true=enable, false=disable)
[false]:
{enter}

Enable HTTP service monitoring ? (true=enable, false=disable)
[false]:True
{enter}

Enable DNS service monitoring ? (true=enable, false=disable)
[false]:True
{enter}

Enable SSH service monitoring ? (true=enable, false=disable)
[false]:True
{enter}

Enable MYSQL service monitoring ? (true=enable, false=disable)
[false]:True
{enter}

Enable SMTP service monitoring ? (true=enable, false=disable)
[false]:True
{enter}

TCP/IP port that SMTP operates on ?
[25]:
{enter}

Enable XINET service monitoring ? (true=enable, false=disable)
[false]:True
{enter}

TCP/IP port that any XINET service operates on (e.g: pop3, 110) ?
[110]:
{enter}

Enable ENSIM service monitoring ? (true=enable, false=disable)
[false]:
{enter}

Enable PGSQL service monitoring ? (true=enable, false=disable)
[false]:
{enter}

Please shut down HTTP , semaphore array’s may remain allocated and cause the service to fall into a loop of restarting cycle. Using this feature clears semaphore arrays on HTTP restart. Enable semaphore cleanup ?
[false]:
{enter}

This is an implemented feature in the http module, its purpose is to determine if/when the apache server locks up or otherwise stops httpd to responding. Enable URL aware monitoring ?
:True
{enter}

URL path to a local file ? (exclude HTTP://)
Note: This URL should be valid and reside on the local server, otherwise HTTP will loop restarting
[127.0.0.1/index.html]: http://ServerIP/ or Type: site.com/index.html that resides on your local server
{enter}

HTTP log files can grow large and cause the service to crash (segfault), this feature will keep the main HTTP logs incheck. Enable HTTP log monitor ?
[false]:
{enter}

MySQL uses a /tmp symlink of its mysql.sock socket file. This feature verifies that the symlink exists from the main mysql.sock file, and if not it is recreated. Enable MySQL Socket correction ?
[false]:
{enter}

Enable NETWORK monitoring ? (true=enable, false=disable)
[false]:True
{enter}

interface to monitor ?
[eth0]:
{enter}

Enable LOAD monitor ? (true=enable, false=disable)
[false]:True
{enter}

Load level before status condition ‘warning’ ?
[25]:
{enter}

Load level before status condition ‘critical’ ?
[45]:
{enter}

Enable a global (wall) message at status condition ‘warning’ & ‘critical’ ?
[false]:
{enter}

Renice services at status condition ‘warning’ or ‘critical’ ?
(3 values – warn, crit, false – false=disabled)
[false]:
{enter}

Stop nonessential services at status condition ‘warning’ or ‘critical’ ?
(3 values – warn, crit, false – false=disabled)
[false]:
{enter}

Reboot system on status condition ‘warning’ or ‘critical’ ?
(3 values – warn, crit, false – false=disabled)
[false]:
{enter}

Now SIM has been configured you can add a cron.
./setup -c
If it says “Removed SIM cronjob.” then you must type it again.
./setup -c

SIM has been installed now
Quote:

In order for SIM to work properly, it must be executed regularly, and the best method for this is by using a cronjob.

By default, a SIM cronjob is automatically added during setup and set to run every 5 minutes. To add it or remove it later, you can execute this:

/usr/local/sim/sim -j

or

/usr/local/sbin/sim -j

Enjoy,
Steven

sales@24×7servermanagement.com

Using YUM

Yum is a tool for automating package maintenance for a network or Workstations/Servers running any operating system that use the Red Hat Package Management (RPM) …..

• To search for a application

Yum will search all your enabled repos and tell you where you can obtain the package from

yum search application_name

• Yum can list all available packages from your enabled repos and tell you where you can obtain the package from:

yum list available

• To find out more info about some package

yum info application_name

• Installing applications

Inastalling is as easy as

yum install application_name

• Listing rpms

yum can list installed rpms for you from the repos you have enabled

yum list extras

• Removing rpms

Yum can remove a application and the dependencies, it installed with that application. it will not remove dependencies if another application installed needs them.

yum remove application_name

• Updating the system

Yum can update the system for you with out user interact if you want it to.

yum update

• Not sure if you have upates?

yum check-update

• Local install

downloaded a rpm and cannot install it with rpm because of dependencies?

yum localinstall /path/to/the/rpm

Enjoy,
Steven

sales@24×7servermanagement.com