Sunday, June 29, 2014

"421 service not available closing channel" error

I was trying to send emails to my localhost account in Windows Live Mail and it's giving me an error message "421 service not available closing channel". This is nothing to do with the email client. This is an issue in xampp's MercuryMail folder.

I am using XAMPP 1.8.3 and it appears MercuryMail seems to have "QUEUE" folder missing.

Place a "QUEUE" folder inside MercuryMail as in "C:\xampp1.8.3\MercuryMail\QUEUE" and this problem goes away. The same path for the QUEUE folder should be used in the "Mail queue" tab in Mercury's Configuration > Mercury Core Module Configuration.

Friday, June 20, 2014

Case sensitive table names in MySQL

In Windows, MySQL database tables are saved with lowercase letters. When you import tables with case sensitive names, these get converted into lowercase names. If you want to maintain case sensitivity in MySQL database, do the following:
  • In your MySQL installation folder, find my.ini file and open it. If you are using xampp, it's usually located in /mysql/bin/ directory.
  • In [mysqld] section, modify the value of lower_case_table_names to 0. If this entry is not there already, simply add this line:
    lower_case_table_names = 0
  • Then restart your MySQL server.