Creating the DB2 sample database on a Linux machine.

I re-installed Ubuntu 10.10 in my laptop and I encountered an unfamiliar error when creating the DB2 sample database. I usually create the sample database using the db2sampl command in a linux shell because the DB2 First Step didn’t work for me.

Here’s the error:

“SQL1205N  The code page “1208” and/or territory code “0” that has been specified is not valid.”

So I visit my good old friend Google and luckily, found a solution. I added these two lines to my .profile which is located in my home directory:

export LC_ALL=en_EN.UTF-8
export LANG=en_EN.UTF-8

After I rebooted my machine I ran db2sampl again and voila! It worked.. but with a single bash error.

If you noticed, there’s an error with my .profile file. So it means that I need to modify it again.

Put a # symbol after export LC_ALL=en_EN.UTF-8 to comment it out. That’s it. 🙂


Fix phpMyAdmin password after security update in XAMPP.

I installed XAMPP in my Linux machine this afternoon because I will be working on a new web project this coming February. After the installation, I conducted an overall check of the programs like MySQL and phpMyAdmin to be sure if XAMPP is installed and working properly. The XAMPP website said that I need to tweak something to fix some security weakness, so I need to run:

/opt/lampp/lampp security

Having entered a bunch of passwords, I opened phpMyAdmin and it prompted me to enter my username and password. Unfortunately my login was rejected due to bad password even though my entered password was correct. I spent an hour googling my problem but I can’t find any solution. So I figured it out by my self.

  1. Using a terminal or your favorite file manager, navigate to /opt/lampp/phpmyadmin.
  2. Using your favorite text editor, edit the file
  3. In line 23 as seen below, type your password.
  4. Run sudo /opt/lampp/lampp restart.
That’s it. Hope it works for you guys. 🙂