MySQL 5.0 or 5.1 to 5.5 Upgrade Traumas on CentOS
Ignoring all the panic-mongers on the rest of the internet upgrading MySQL from 5.0 or 5.1 to 5.5 shouldn't be that difficult. My task was to upgrade from 5.0 to 5.5 on CentOS (Remi Repos). It was to fix a bug with MySQL 5.0 ignoring the wait_timeout parameter in my.cnf.
Five to five on a Friday, I dive into the swamp, which turns out to be full of alligators.
Alligator 1: Version depenencies
Alligator 2: /usr/libexec/mysqld: unknown option '--skip-locking'
Alligator 3: [ERROR] Error message file '/usr/share/mysql/english/errmsg.sys' had only 481 error messages,
but it should contain at least 641 error messages.
Or some other variation of numbers.
Install the Remi Repo in CentOS
The Remi Repo is a yum repository maintained by a French dude - Remi Collet. It contains much more up to date packages (January 2012) such as MySQL 5.5 and PHP 5.3.
Heres how I installed it on CentOS.
Installing FFmpeg and ffmpeg-php on CentOS
Whilst installing FFmpeg and ffmpeg-php for a client that required server-side MP4 processing, I ran into a few errors.
The error I came across was while compiling ffmpeg-php
How to install the nslookup, host OR dig commands in Linux?
Sometimes you are unable to use the nslookup, host OR dig command on your Linux server and receives the following message
- -bash: nslookup: command not found -bash: host: command not found -bash: dig: command not found
The reason is the package required for the commands to work isn’t installed during the OS installation.
These are all DNS related commands useful to check the DNS report of a domain/IP.
You need to install the package bind-utils which offer the commands like nslookup, host, dig and others.
SSH to your server as root and execute
- yum install bind-utils
Done!
[Snippet] Whois Client on CentOS
I can never remember how to install a whois client on CentOS.
- yum install jwhois
Thats it!
[Snippet] How to install cron (crond, crontab) in CentOS
Sometimes small installations of CentOS don't come with cron. Here's how to install cron easily and quickly.
- yum install vixie-cron crontabs
- /sbin/chkconfig crond on
- /sbin/service crond start
See my retro post I hate vi. (aka Changing your default crontab editor) for how to change the editor from vi to nano.
Installing RepoForge (RPMForge) in CentOS
RepoForge (RPMForge) contains over 5,000 extra packages for CentO. Many new packages and some updated packages not yet approved into the CentOS release repo.
1. Download the rpmforge-release package. Choose one of the two links below, selecting to match your host's architecture. If you are unsure of which one to use you can check your architecture with the command uname -i
Messing with time and date on Linux
Some Linux distros don't come with time synchronisation utilities, even though Windows has done it since Windows 2000.
Here's how I solved the issue on a basic CentOS install.
Installing nginx & PHP-FPM securely on CentOS
I won't go into the reasons why you should install nginx, if you're here, you've already decided.
Here's how I installed nginx and PHP-FPM on CentOS.
