This blog contains only tech related stuff, mostly about system administration and programming. It's sort of a notebook for me to keep track of solutions for weird and boring problems so that I don't have to debug the same problems over and over again. Hope it helps you as well!
It’s possible but not as easy as ALTER TABLE [table] ADD COLUMN [column] [type] AFTER [anothercolumn]; like supported in MySql. We need to drop all contraints, create a temporary table with the new structure, copy all data to the temporary table, drop the old table and rename the temporary table. Below is a script that [...]
I have been trying to figure out a way to move a few mailboxes from Exchange server 2003 to 2010. There is no trust relation between the two servers and they are on different networks so the included Move Request feature does work. I only seem to be able to find very complicated and time [...]
When uploading files greater than 28.6 MB (30000000 Bytes) with ASP.NET on IIS 7.5 using SWFUpload I’m getting this error: There has been an I/O Error: Error #2038
A lot of performance issues can be caused by poor disk performance. Here’s how to test the read and write performance on a Linux system using dd. 1. Write a file 2x the size of the RAM to make sure we get the real write rate. In this example the RAM of the server is [...]
I was creating a PHP-level search function using stripos to check if the search query was found in a string. Everything was working perfectly except special characters were still case sensitive. Turns out the problem is that the default locale was set to one not supporting those characters. To fix it, change the default locale [...]
1. Download and install Windows SDK 2. Open command prompt as Administrator and cd to this directory: C:\Program Files\Microsoft SDKs\Windows\v7.0\Bin 2. Create a root certificate makecert -pe -n “CN=Test Root Authority” -ss my -sr LocalMachine -a sha1 -sky signature -r “c:\Test Root Authority.cer” 3. Create the new certificate and sign it with the newly generated [...]
Today, all certificate authorities require 2048 bit private key when requesting SSL certificates. This is how it’s done: openssl req -nodes -newkey rsa:2048 -keyout cert.key -out cert.csr
Today when adding a secure binding to one of my sites in IIS 7, I got this error: One or more intermediate certificates in the certificate chain are missing. To resolve this issue, make sure that all of the intermediate certificates are installed. For more information, see http://support.microsoft.com/kb/954755.
I have been unable to login to Magento 1.4.0.1 for a few days and after testing every solution suggested in blogs and forums I decided to clear the cache. Turns out this was the solution for me: rm var/cache/* -rf
I was just upgrading a spam filter from Debian etch to lenny. After the upgrade, MailScanner seemed to be running but wasn’t processing the queue. When running MailScanner in debug mode I noticed these errors: Variable “$FIELD_NAME” is not imported at /usr/share/MailScanner/MailScanner/Message.pm line 6064. Variable “$FIELD_NAME” is not imported at /usr/share/MailScanner/MailScanner/Message.pm line 6067. Global symbol [...]