Hans Salvisberg's blog

Start mysql as Administrator in Plesk

Here's what (presumably Parallels, India) did:

cat /etc/issue
/usr/local/psa/bin/admin --show-password
mysql -uadmin -p`cat /etc/psa/.psa.shadow ` psa

use psa;
select id,name from domains where cl_id = vendor_id;
select id,login from clients where parent_id is null;
update domains set vendor_id=1 where cl_id=vendor_id;

Use Alternative UI Languages on Your Drupal Site

I run some German-language sites, but I strongly prefer working with an English-language user interface. A possible solution is the Administration Language module, which lets you select an alternative langauge for the administration pages, but it falls short in several ways:

  • I want to see everything in English, not just the administration pages,
  • I have a deputy administrator who prefers to see the administrtion pages in German, and

Chinese Spam

For a while now I've been getting a Chinese piece of spam every day, supposedly sent by people like 魏碈, which is encoded as

From: =?utf-8?B?6a2P56KI?=

These pages have helped make sense of this:
BASE64 Decode and Encode
Wikipedia: Base64
UTF-8 encoding table and Unicode characters
RFC 2044 (UTF-8)

IE Privacy Policy Causes Log-in Failure

Internet Explorer's High Privacy setting "blocks all cookies from websites that do not have a compact privacy policy." This includes out-of-the-box installations of Drupal 7.

Here's a work-around:


header('P3P: CP="We do not have a P3P policy"');

to your settings.php file. Tested with IE9.

Historical Currency Exchange Rates

I'm a Swiss citizen and the continuous fall of the US Dollar and rise of the Swiss Franc has me worried.

These links drive it home:


My Firefox Extensions

Everyone has got their list of favorite extensions — here's mine...

Setting up My Eclipse / EGit for Drupal Development

This is work in progress...

I like working in Eclipse, and I've gotten used to having one project for each major Drupal version. This allows me to put the corresponding contribs inside the respective sites/all/modules directory and to just .gitignore them. That way I can let my local webserver serve each Drupal version without having to switch branches.

Set Up a Cache

Setting up msysGit

Setting up msysGit on my Win7 box has been a bit of a pain.

Open issues with a newly installed HE Linux L 4.0 VPS


mod_delay/0.6: unable to open DelayTable '/var/run/proftpd/proftpd.delay': No such file or directory

Fix: create the directory.

Possibly related: https://bugs.launchpad.net/ubuntu/+source/upstart/+bug/543506 ("runlevel unknown", #81, #94)


pam_env(sshd:setcred): Unable to open env file: /etc/default/locale: No such file or directory

Fix: create the file.

Syndicate content