not load file or assembly 'System.Windows, Version=2.0.5.0...'

if you get this error, it's because Sliverlight assembly is not in GAC. Do this to fix:


cd C:\Program Files\Microsoft Silverlight\4.0.50524.0
gacutil -i System.Core.dll
gacutil -i system.dll
gacutil -i system.net.dll
gacutil -i system.xml.dll
gacutil -i System.Runtime.Serialization.dll


check out what other people said.

Snow Leopard's NTFS read/write support

http://tool-box.info/blog/archives/1193-Snow-Leopards-NTFS-readwrite-support.html

This still stands for release version of Snow Leopard. It also works for USB disk.

update: 2010/8/6:
I switch back for NTFS-3G, the Apple built-in version is not stable and screw up my partition table. Apple did not enable it for a reason...

.NET fix: System.Security.SecurityException: Requested registry access is not allowed.

If you get something like this:

Server Error in '/applicationname' Application.
---------------------------------------------------------------------------
Security Exception 
Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file. 

Exception Details: System.Security.SecurityException: Requested registry access is not allowed.

Source Error: 
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. 

Stack Trace: 
[SecurityException: Requested registry access is not allowed.]
Microsoft.Win32.RegistryKey.OpenSubKey(String name, Boolean writable) +473
....

I'm not sure there's a secured way, but adding permission for iis daemon user solve the problem for me.

1. Find out which deamon user your app is using, by looking up App_Pool and secruity section in event log.

2. Give the user permission to read/write access for the eventlog registry entry. To do so, open regedit and navigate to the key:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog

.
Right click and select Permissions, and add permission for the user.

3. restart iis and give it a try.

MySQL 5.x Repair Cheat Sheet

If you upgrade MySQL or move the database around, you are most likely need to do those operations:

Backup

mysqldump -u root -p --default-character-set=utf8 databasename > data.sql


Restore

mysqldump -u root -p --default-character-set=utf8 databasename < data.sql
if database is larger then 100MB, this works better:
mysql -u root -p
#mysql> use the_database
#mysql> source data.sql


Check, Repair & Optimize All Tables in All Databases

If you need database server up, use mysqlcheck:
mysqlcheck -u root -p --auto-repair --check --optimize --all-databases


Or you can make it offline and do a better check:
service mysqld stop
myisamchk /var/lib/mysql/the_database/*.MYI
service mysqld start


Repair single table

mysql -u root -p
#mysql> use the_database
#mysql> repair table the_table


Reference:
http://www.felipecruz.com/repair-mysql-database.php

MySQL 5.1.x & unicode

In our recent upgrade from 5.0 to 5.1.47, the new version behaves differently and it screw up character set when user submit info from our web app powered by .NET.

After digging around for a afternoon, this is how to fix it:

vi /etc/my.cnf


And add those lines to the config:

init_connect='SET collation_connection = utf8_general_ci'
init_connect='SET NAMES utf8'
default-character-set=utf8
character-set-server=utf8
collation-server=utf8_general_ci
skip-character-set-client-handshake


There are other options for collation besides utf8_general_ci such as utf8_unicode_ci. See this article:
http://dev.mysql.com/doc/refman/5.1/en/charset-unicode-sets.html

Reference: http://rhyous.com/2009/11/05/how-to-create-a-utf-8-unicode-database-on-mysql/

RHEL: Install GNOME from console

this will do:
yum groupinstall "X Window System" "GNOME Desktop Environment"


To start the desktop, just type startx

CentOS: Install git

1. Download and install EPEL if you don't have it yet:
rpm -Uvh http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-3.noarch.rpm


2. Install git via yum
yum --enablerepo=epel install git