Installing Webmin on Ubuntu

As a SysAd, I find Webmin invaluable. Almost all I needed to do can be done from Webmin such MySQL, mail and web administration. I have been using it for 7 years and I have no complaints whatsoever. Best of all, its free (but support is available if you want it)!

If you have not heard of Webmin, here is the description from http://webmin.com:

Webmin is a web-based interface for system administration for Unix. Using any modern web browser, you can setup user accounts, Apache, DNS, file sharing and much more. Webmin removes the need to manually edit Unix configuration files like /etc/passwd, and lets you manage a system from the console or remotely.

Installin it on Ubuntu is easy. Just download the package on the console by:

1) wget http://prdownloads.sourceforge.net/webadmin/webmin_1.500_all.deb
2) dpkg -i webmin_1.500_all.deb
3) apt-get install -f


Now its done. Enjoy!

Repair Perl Locale Errors

Thanks for this article , I was able to fix my perl locale errors on Karmic Koala.

Error Messages:

perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = (unset),
LC_ALL = "en_US",
LC_CTYPE = "en_US.UTF-8",
LANG = "en_US.UTF-8"
are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
locale: Cannot set LC_CTYPE to default locale: No such file or directory
locale: Cannot set LC_MESSAGES to default locale: No such file or directory
locale: Cannot set LC_ALL to default locale: No such file or directory

This is the solution:

sudo apt-get install language-pack-en-base
sudo dpkg-reconfigure locales

DBCC SHRINKFILE - MSSQL2000

The easiest way to shrink Transaction Logs in MSSQL 2000 is to use the GUI (Enterprise Manager). I had so much pain and agitation using DBCC SHRINKFILE and other commands related to this using MS SQL Analyzer.

You had been warned! :D