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:
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. 🙂
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:
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.
- Using a terminal or your favorite file manager, navigate to /opt/lampp/phpmyadmin.
- Using your favorite text editor, edit the file config.inc.php.
- In line 23 as seen below, type your password.
- Run sudo /opt/lampp/lampp restart.
That’s it. Hope it works for you guys. 🙂