cybersource and umlauts (php api)

Don’t be surprised if cybersource’s php api craps out when calling cybs_run_transaction with any umlauts in the input (card holder name, etc.)

For me I get:

Aborted.

Fun.

converting an entire mysql server to not use isam files

So you’ve got a mysql server with an unknown number of isam tables and you need to convert them (the easy way)? Here’s how:

find /var/lib/mysql/ -name “*.ISM” -print > convert.txt

emacs convert.txt

replace: “/var/lib/mysql/” with “alter table “

replace “.ISM” with ” type = myisam;”

replace “/” with “.”

Be careful to include the spaces where I have them.

The run:

mysql -u root -p < convert.txt

How to modify return-path header in php mail function

Normally the return path is set by sendmail (or whatever the server is running, qmail, etc.)

However you can pass a fifth argument to php’s mail function to reset it to what you want. Here’s an example:

$result = mail($to, $subject, $body, “From: $from\n”, “-f$from”);

make sure you do not put a newline in after the fifth argument’s from. php will error out.