Using Pixture Reloaded

Picture ReloadedPixture Reloaded is a good theme for drupal, however I'd like to change something on the header and add some other css styles. Pixture Reloaded used color module, so each time it'll save to a temp folder in sites/default/files, and copy over some images and style.css , during the copy, it'll process the style.css and change some colors.

Recommend: Thinking Rock GTD

GTD: Getting Things Done

Use ThinkingRock as your trusted software to organise your life according to GTD - the stress-free productivity methodology described in the international best selling book by David Allen.

There's free version available.
http://www.trgtd.com.au/

Setup Postfix with SMTP Auth

  1. Install Postfix and SASL 
    apt-get install postfix sasl2-bin
  2. edit /etc/default/saslauthd, change the following:
    START=yes
     
  3. Start saslauthd:
    /etc/init.d/saslauthd start
  4. test if saslauthd is working:
    testsaslauthd -u username -p password
  5. Stop saslauthd:
    /etc/init.d/saslauthd stop
  6. Create file /etc/postfix/sasl/smtpd.conf:
    pwcheck_method: saslauthd
     
  7. edit /etc/postfix/main.cf :

PHP: check domain availability

function check_domain($domain) {
if(preg_match('/[;\&\|\>\<]/', $domain)) exit;

exec("whois " . escapeshellarg($domain), $output);
$result = implode("\n", $output);

return (strpos($result, 'No match') !== false);
}
if( check_domain("domain.com")){
//domain.com still available
}

Setup drconcierge.org using Drupal Part 1

This is a work log on how I setup drconcierge.org.

In this part, we are going to:

Switching from Wordpress to Drupal

  1. Install latest version of drupal
  2. Install wordpress import module, and Chaos tools module
  3. Export the wordpress blog into XML and start importing. Post -> Story, Page->Page and Comment->Comment
  4. copy wp-content folder to drupal dir, so all images/uploaded files still works

Subversion saved credentials

Windows:

C:\Documents and Settings\user\Application Data\Subversion\auth\svn.simple\

C:\Users\user\AppData\Roaming\Subversion\auth\svn.simple\

Linux:

~/.subversion/auth/svn.simple

Delete the file will clean the saved credentials. Then you can login with another account.

Moving large table to another file group

I have a large errorlog table in my database, with 2M records and 1GB data. I'd like to create a standalone file group for the error log. I tried to use management studio to modify the table, but it's timeout. So I have to do it manually. I'm sure there's better way to do this, but here's my note which works:

perl: warning: Setting locale failed

This error message happens after I did an upgrade to Debian 5.0 (lenny)

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

Then choose en_US.UTF-8 and it's fixed.