Linux

Installing multilingual MediaWiki under the same domain

Multilingual is such a common thing today. Wikipedia has multilingual in subdomain. So you may read Wikipedia in English at http://en.wikipedia.org/ and in Thai at http://th.wikipedia.org/. I like it. Anyway, it will not look that pretty if your domain is not just for wiki. For example, http://www.thaigrid.or.th/ which has its wiki at http://research.thaigrid.or.th/. According to subdomain approach, they will have multilingual as follows.

How to encode video for PSP using MEncoder

Just a short note, it is possible to convert any video formats to play on PSP using MEncoder. I don't know much about PSP but my friend has one.

Port Forwarding using iptables

If you are behind a router aka ADSL router and you are assigned a private IP address, e.g., 192.168.0.0/16, 172.16.0.0/16, or 10.0.0.0/8, you will be able to use most of Internet applications like Web, E-mail, FTP, and more. However, P2P softwares might not work well because your computer can't receive incoming connection directly. You have to choice, DMZ or Port Forwarding. In case of your router is purely hardward, PortForward.com might help. Otherwise, your router might be handmade Linux router or you are using a kind of a VPN. The most common software in Linux router or VPN is iptables. This article is to describe how to set port forwarding through DNAT using iptables.

Upgrading MySQL 3.23.58 in RHEL3 and Ensim to MySQL 4.1.20 feels like a pain

Red Hat Enterprise Linux 3 aka RHEL 3 was a very popular Linux distribution during the last 2 years. However, it is not applicable by now. It came with MySQL 3.23.58 which is already obsoleted by some web applications due to lacking of unicode support and incompatibility to later version.

Yesterday was the time to remember for me. My friend asked me to help upgrading MySQL 3.23.58 in RHEL3 to newer version because he was unable to install even Joomla! and phpBB. It seems the latest version of these applications has been already dropped support for MySQL 3.x. He didn't want to upgrade the whole distribution because it supposed to take longer time to backup and restore data. That's why I have to do some painful thing. One thing to concern was Ensim. He has not been familiar to Linux including RHEL so he bought an Ensim license to manage the site just for himselves. So I have to make it work just like before.

Fail to upgrade flashplugin-nonfree 7.0.68~ubuntu1~dapper1

If you are using flashplugin-nonfree in Ubuntu Dapper from backports like me, you might see some error according to post-installation script failed.

sugree@sugree-laptop:~$ sudo apt-get upgrade flashplugin-nonfree
Reading package lists... Done
Building dependency tree... Done
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
Need to get 0B of archives.
After unpacking 0B of additional disk space will be used.
Do you want to continue [Y/n]?
Setting up flashplugin-nonfree (7.0.68~ubuntu1~dapper1) ...
Downloading...  done.
usage: update-rc.d [-n] [-f]  remove
       update-rc.d [-n]  defaults [NN | sNN kNN]
       update-rc.d [-n]  start|stop NN runlvl [runlvl] [...] .
                -n: not really
                -f: force
dpkg: error processing flashplugin-nonfree (--configure):
 subprocess post-installation script returned error exit status 1
Errors were encountered while processing:
 flashplugin-nonfree
E: Sub-process /usr/bin/dpkg returned an error code (1)

I recommend all you to upgrade as soon as possible because there are multiple vulnerabilities in current versions.

Upgrade RPM-based system properly using YUM

I found something weird after trying to upgrade some RPM packages using YUM. The problem was hang by message as follow.

Setting up package sacks

It happened when I was running yum update since the repository had changed from CentOS 4.3 to CentOS 4.4. It seems this was a popular problem because I found a thread at CentOS board. The solution is also available to guide me through the step. Not exact one but useful.