OS 10.5 upgrade headaches and solutions

Finally got to upgrade to 10.5 and of course various stuff was broken - one of the reasons why I did not upgrade for so long - never touch a running system. But actually my tiger was not running well - over last 8 weeks the OS X gui was simply crashing on me 2-3 time  and any work-in-progress was lost. This is just like windoze BSOD coz I had to kill the graphic subsytem to get back to work (see this apple entry w m comments somewhere).

So here the things I had to fix after my upgrade:

1) Apache - OSX now uses apache2 per dfault aka config files need to be updated:

a) apache config file now in /etc/apache2/http.conf

change:
Listen  
LoadModule php5_module libexec/apache2/libphp5.so
Alias

2) PHP - the defaut install has not enabled PHP properly:

a) copy /etc/php.ini.default to php.ini

b) Change this in file:

; define error_log file

error_log /var/log/apache2/error_log
;turn logging on:
display_errors=On

;use same socket as PHP on 10.4

mysql.default_socket=/tmp/mysql.sock

mysqli.default_socket=/tmp/mysql.sock

3) MySQL prepane does not work.

After some googling I found a patch released by my sql - grab it here