Hans Salvisberg's blog

Start mysql as Administrator in Plesk

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

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

\q
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:

Add

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:

http://en.wikipedia.org/wiki/Tables_of_historical_exchange_rates_to_the_United_States_dollar

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

daemon.log:

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)

auth.log:

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

Fix: create the file.

Syndicate content