Monthly Archives: December 2008

Happy Christmas Everyone

I wish all you Linux geeks out there a happy christmas. I am spending this years chrismas with my family in Perth west australia. It’s my first visit to western australia and i am really enjoying it. I will try and post a few photos when i get back to berlin.

Merry Christmas

German Umlaut on Debian Console

To get Debian to correctly display german Umlauts (äöü) in a console install the following packages:

aptitude install console-setup ncurses-term language-env

I am not sure if you really need ncurses-term und language-env but i won’t hurt.

When you configure console-setup use the standard options press enter. Then issue the following command

dpkg-reconfigure console-setup

Edit  /root/.bashrc and /etc/profileand add the following line.

export LC_ALL="de_DE.UTF-8"

The reconfigure your locales with:

dpkg-reconfigure locales

And make sure you tick all boxes with:

de_DE

Then logout or reboot you system and enjoy your umlaut. This howto should also work for other languages. Just change de_DE for you locales.

Thanks for the original german howto goes to:

coffeethewebandme

Lost your debian-sys-maint account?

This has happend to me a few times. You import a mysql user database from another server and you get these horrible errors when you restart mysql.

error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'

Go find your debian-sys-maint password in

/etc/mysql/debian.cnf

Write it down you will need it later. Log on to your mysql server and issue the following command

GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'your-password' WITH GRANT OPTION;

Change your-password with the password from the file debian.cnf. I am sure the debian-sys-maint user could be given less rights but this thread is only helping to restore the previous defaults. So please be aware this could be a security issue.