1. Login to the Admin account (not the normal account)
Read more (102 words) »

Let’s look at all the ways to change MySQL password, for root and other users:

Read more (78 words) »

PHP is not only a very competent web development language (and part of LAMP stack). It is also a very capable language for writing (command line) scripts. You can write simpler and cleaner scripts with php than perl. Here is a php code which takes a file name as input, trims whitespace from each line of the file and finally saves the result back in the same file.

Read more (149 words) »

Here is a simple command to auto repair, check and optimize all the tables in all databases running on a MySQL server:

Read more (149 words) »

Have you seen the error while installing a package using yum / yumex?

Error: vlc conflicts with faad2 >= 2.5
Error: Missing Dependency: faad2 < 2.5 is needed by package ffmpeg-libs

The error is because of using freshrpms repository or other repository to install recent version of faad2. Now let’s see how you can solve it.

Read more (122 words) »

A simple tip for newbies - how to get Java stack trace, the invaluable tool to debug java programs, in Linux:
Read more (93 words) »

Please read the original article - How To: Load Balancing & Failover With Dual/ Multi WAN / ADSL / Cable Connections on Linux. It contains detailed information with a sample script. Viliam Kočinský modified my script to send email when routing table changes. Also he is starting the script as a service from /etc/init.d. Read below for his enhancements:

Read more (416 words) »

SSH is aptly termed as poor man’s VPN. You can use it to either forward local host host name and port to a remote server running ssh daemon. You can also use it to forward remote server’s port to a local host and port.

Read more (224 words) »

I learned it the hard way. Our gateway machine with firewall (shorewall) has multiple ADSL connections configured with load balancing for more bandwidth and transparent fail-over. Today I faced an unenviable problem where one or other of the ADSL connections were going down sometime after a network restart. It was unique because the ADSL modems (configured as router) were accessible via telnet or ping and displayed perfect connectivity. However I was unable to use them as gateway to connect to a server on the internet. They were working fine before. With our non-trivial setup there were many suspects including the shorewall firewall and iptables (dropping certain packets?), network adapter, routing issue etc.

Read more (265 words) »

Replicating on two or more MySQL master database servers

Read more (112 words) »