perl: warning: Setting locale failed

locale error starts to pop up when I restart the mysql server - Debian Linux distribution

/etc/init.d/mysql stop
/etc/init.d/mysql start

perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
    LANGUAGE = (unset),
    LC_ALL = (unset),
    LC_CTYPE = "UTF-8",
    LANG = "en_IN"
    are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C")

To resolve this:

debian:~# export LANGUAGE=en_US.UTF-8
debian:~# export LANG=en_US.UTF-8
debian:~# export LC_ALL=en_US.UTF-8
debian:~# locale-gen en_US.UTF-8
Generating locales (this might take a while)...
  en_IN.UTF-8... done
Generation complete.

debian:~# apt-get install locales
Reading package lists... Done
Building dependency tree... Done
The following extra packages will be installed:
  libc6 libc6-i686 tzdata
Suggested packages:
  glibc-doc
The following packages will be upgraded:
  libc6 libc6-i686 locales tzdata
4 upgraded, 0 newly installed, 0 to remove and 172 not upgraded.
Need to get 10.9MB of archives.
After unpacking 1909kB of additional disk space will be used.
Do you want to continue [Y/n]? y

After completion:

debian:~# dpkg-reconfigure locales                            
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
    LANGUAGE = "en_US.UTF-8",
    LC_ALL = "en_US.UTF-8",
    LC_CTYPE = "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
/usr/bin/locale: Cannot set LC_CTYPE to default locale: No such file or directory
/usr/bin/locale: Cannot set LC_MESSAGES to default locale: No such file or directory
/usr/bin/locale: Cannot set LC_ALL to default locale: No such file or directory

Generating locales (this might take a while)...
  en_US.UTF-8... done
Generation complete.
debian:~# /etc/init.d/mysql stop  
Stopping MySQL database server: mysqld.
debian:~# /etc/init.d/mysql start
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..

Fixed.

Microsoft Windows Software Installation and UnInstallation Log Script

The purpose is to clear all traces of software installation and uninstallation logs of various software from my local computer.

Newer versions of Microsoft Windows have a command - wevtutil

This program retrieves information from various log files on the computer about any program or publisher. It is also useful to clear all the log files from a computer.

More information and syntax about this command can be located on the Microsoft Technet site here - http://technet.microsoft.com/en-us/library/cc732848%28v=ws.10%29.aspx

A batch file .bat is attached here using this utility to clear all the various logs from the computer - this is specially helpful if you want to clear a program installation or uninstallation log - for example clear logs for publisher "microsoft" or "adobe"

A second .vbs script along with this file is used to generate a report for the logs in an excel sheet format.
To see the difference, run the .vbs file first and check the generated log in excel sheet format - then run the .bat file to clear all event logs and then run the .vbs file second time again to see the new generated excel sheet and compare with the old one.

There are two .vbs script files with "Microsoft" and "Adobe" respectively - both are configured to generate the output in the default drive path "d:\" - this path can be changed in the script to another local path - such as the desktop or even a network share such as - "\\dell25\shared" - just make sure the shared folder has full permissions - also, for Win7 - keep the default path to "d:\" or "e:\" drive - because "c:\" will again raise permission issues for non-admin users.

The batch file can be edited and vendor (publisher or software company) name can be changed - such as "Microsoft", "Corel", "Adobe", "Zend" etc.

Download Link

Clean an Adobe Installation from MAC or Windows computer

Removal instructions of Adobe Photoshop CS5 from a MAC computer on the internet only tell you to delete the respective folders from the path and remove the program from the Applications folder.

However, the Applications folder also contains an "Adobe Uninstaller" utility - which was not found in the earlier versions - and removes the installation from your computer.

Adobe also provides a Creative Suite Cleaner tool on it's own website - http://www.adobe.com/support/contact/cscleanertool.html

This tool is available for the Windows version as well. For windows, Revo Uninstaller works quite nicely as well.