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 config.inc.php.
  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. :)

Tired.

Status

It’s 9:00 AM here in the Philippines and I’m still awake. I still have some thoughts in my mind that I want to post here, but my fingers don’t want to cooperate.

Haymitch, Y U NO Learn From Dumbledore’s Mistakes?!

If only Haymitch can hear me (maybe not, he’s drinking again I think), he’ll probably say “Dammit! I should have known!”. After being engrossed with The Hunger Games by Suzanne Collins for weeks, there’s now  a very strong emotional connection exists between the book and me. That is why I’m a little frustrated when I finished reading Catching Fire and discovered that the rebellion plan went a little amiss.

“I won’t say a thing about the rebellion to Katniss and Peeta, just as Dumbledore hid the prophecy to Harry”

“You fool! You surely didn’t learn from an old man mistake don’t you?”

Haymitch probably believe that what Katniss and Peeta doesn’t know won’t hurt them, but it turned out entirely the opposite. Peeta is now under Capitol’s mercy and a handful of Victors died. I’m not saying that the books wasn’t good, hell it’s really an awesome novel. Probably there won’t be much story anyway if the rebellion plan went smoothly. It just that the similarity of Haymitch and Dumbledore’s approach in keeping their pets safe is not efficient at all.

Anyway, I’m hoping that almost all of you are PATIENTLY waiting for March 23, 2012 because my patience is now coming to a close. Haha. Happy Hunger Games everyone and may the odds be ever in your favor!

P.S. I’m still reading Mockingjay at the moment, even though I already knew the ending. Haha. My sister’s a nasty spoiler. :D

Reborn From The Trashbin

I would consider this as my worst blogging day ever. I don’t know how it happened but my previous blog has been deleted! Yeah it was gone with a blink of an eye, or shall I say a refresh of a browser? I first checked my email if there’s a confirmation about me deleting my blog, but there wasn’t. I’m not sure if my WordPress got hacked or something. I’ll contact the Support team later. Although I’m not in deep regret of what happened, that blog was only around for a month and  containing only 13-15 blog posts, still it was my first ever successful blog.