MySQL problem after upgrade to Mac OS 10.6 #2

Mac OS version:

10.6.4

Problem:

phpMyAdmin show following error after login

"Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly."

Solution:

In folder "/etc"

Recreate "php.ini" from "php.ini.default"

- sudo cp php.ini.default php.ini

- sudo chmod 777 php.ini

- edit /etc/php.ini (using what ever editor)

-> session:auto_start = 1

-> session:save_path = /tmp

-> mysql.default_socket = /tmp/mysql.sock (x2)

- sudo chmod 444 php.ini

Restart apache

MySQL problem after upgrade to Mac OS 10.6

Mac OS version:

10.6.3

Problem:

MySQL server not started

Solution:

Create a symbolic link named "mysql"

In folder "/usr/local"

Point to "/usr/local/mysql-5.1.42-osx10.5-x86_64"

Restart computer

14" Notebook

1) Asus

A52JC

Link: http://hk.asus.com/product.aspx?P_ID=Z2t1FkxEW31lzErY

A52JR

http://hk.asus.com/product.aspx?P_ID=OdtStEQ9nbSbUSMI

A52F

http://www.price.com.hk/product.php?p=117185

2) Lenovo

Thinkpad Edge

Core i3-330M, 14" WXGA, 320G HD, 2G RAM, DVD

HDMI, 6 cell, 2.22kg, Win7 Home Premium

Color:black or red

Price: HK$5,688 up

www.lenovo-thinkpad-edge.com

T客邦 review

Handle photo with iPhone

1) Copy photo file from SD card to iPhone

ZoomIt SD Card Reader (hardware)

Info: iPhone / iPod touch 用SD讀卡機「ZoomIt」

Info: ZoomIt，iPhone的讀卡機

Google Search: iPhone SD card reader

2) Upload file to FTP server

iStorage (iPhone App)

Info: search "iStorage" in iTunes App Store

Info: istorageapp.com

Google Search: istorage

FTP On The Go (iPhone App)

Info: search "ftp" in iTunes App Store

Info: www.ftponthego.com

Google Search: ftp on the go

Google Search: iPhone upload ftp

3) Update Exif/IPTC meta data of photo file

Still searching ...

Install GD on Mac with PHP

Reference:

http://www.gigoblog.com/2008/10/08/install-gd-for-php-on-mac-os-x-105-leopard/

http://www.opensource.apple.com/source/apache_mod_php/apache_mod_php-53/libjpeg/

http://us.php.net/get/php-5.2.11.tar.bz2/from/a/mirror

1. start terminal

sudo bash

2. install libjpeg

mkdir -p /SourceCache

cd /SourceCache

curl -O http://.../jpegsrc.v6b.tar.gz

(http://www.opensource.apple.com/source/apache_mod_php/apache_mod_php-53/libjpeg)

(or download first, then cp /.../jpegsrc.v6b.tar.gz .)

tar xzpf jpegsrc.v6b.tar.gz

cd /SourceCache/jpeg-6b

cp /usr/share/libtool/config.sub .

cp /usr/share/libtool/config.guess .

(64-bit only)

MACOSX_DEPLOYMENT_TARGET=10.5 CFLAGS="-arch ppc -arch ppc64 -arch i386 -arch x86_64 -g -Os -pipe -no-cpp-precomp" CCFLAGS="-arch ppc -arch ppc64 -arch i386 -arch x86_64 -g -Os -pipe" CXXFLAGS="-arch ppc -arch ppc64 -arch i386 -arch x86_64 -g -Os -pipe" LDFLAGS="-arch ppc -arch ppc64 -arch i386 -arch x86_64 -bind_at_load" ./configure --enable-shared

make clean

make

mkdir -p /usr/local/include

mkdir -p /usr/local/bin

mkdir -p /usr/local/lib

mkdir -p /usr/local/man/man1

make install

3. Compile GD graphics library extension (gd.so)

- make sure which php version is using

mkdir -p /SourceCache

cd /SourceCache

curl -O http://.../php-5.2.11.tar.bz2

(http://us.php.net/get/php-5.2.11.tar.bz2/from/a/mirror)

(or download first, then cp /.../php-5.2.11.tar.bz2 .)

tar xjf php-5.2.11.tar.bz2

cd /SourceCache/php-5.2.11/ext/gd

phpize

(64-bit only)

MACOSX_DEPLOYMENT_TARGET=10.5 CFLAGS="-arch ppc -arch ppc64 -arch i386 -arch x86_64 -g -Os -pipe -no-cpp-precomp" CCFLAGS="-arch ppc -arch ppc64 -arch i386 -arch x86_64 -g -Os -pipe" CXXFLAGS="-arch ppc -arch ppc64 -arch i386 -arch x86_64 -g -Os -pipe" LDFLAGS="-arch ppc -arch ppc64 -arch i386 -arch x86_64 -bind_at_load" ./configure --with-zlib-dir=/usr --with-jpeg-dir=/usr/local/lib --with-png-dir=/usr/X11R6 --with-freetype-dir=/usr/X11R6 --with-xpm-dir=/usr/X11R6

make clean

make

make install

4. Add gd.so to PHP

- edit php.ini

-> add extension=gd.so

-> add extension_dir=/usr/lib/php/extensions/no-debug-non-zts-20060613

- restart apache

-> apachectl graceful

Install PHP + MySQL + PhpMyAdmin on Mac with Apache

1. activate web share

2. test apache by using test.html

- computer doc root /Library/WebServer/Documents/

- current user doc root ~/Sites/

3. test php by using phpinfo()

4. install MySQL

5. config MySQL

- /usr/local/mysql/bin/mysqladmin -u root password

- /usr/local/mysql/bin/mysqladmin -u root -p password

- sudo chmod 777 php.ini

- edit /etc/php.ini (using what ever editor)

-> session.auto_start = 1

-> session.save_path = /tmp

-> mysql.default_socket = /tmp/mysql.sock

-> mysqli.default_socket = /tmp/mysql.sock

- sudo chmod 444 php.ini

6. copy phpMyAdmin to computer doc root

7. config apache alias

- sudo chmod 777 httpd.conf

- edit /etc/apache2/httpd.conf

-> Alias /artmate "/<folder>"

-> <Directory "/<folder>">

-> Options Indexes FollowSymLinks MultiViews

-> AllowOverride None

-> Order allow,deny

-> Allow from all

-> </Directory>

- sudo chmod 644 httpd.conf