PHP

John,

I'm intrested in the same thing. Hopefully we'll get an answer here

This is simple using the freeBSD type ports system known as MacPorts

Install macports from here: http://www.macports.org/ it installs into the /opt directory which it will create and keep everything you install in that folder so it will not cross-contaminate any Apple default software.

macports will also create a .profile for your shell in your user home directory with the new shell paths you will need (almost all - see below about pear). These instructions assume you are using the terminal and logged in as an admin. If you use root on your server instead, you will not need to type sudo but you will need to copy the .profile file to your root home directory.

run the following commands in terminal:

sudo port selfupdate

sudo port upgrade outdated

(you will run these two commands every time you want to automatically upgrade installed packages. It will upgrade everything you installed at once so you don't need to do any line by line installation.)

Everyone will have different needs with their php. It is extremely simple to add php modules by using the below commands. You can visit the macports website and search for php5 to see all the packages you would want to install.

type

sudo port install package-name (for example: sudo port install php5-mysql)

type the name of the package you want to install (I use the following in my php)

php5-mysql

php5-gd

php5-curl

php5-iconv

php5-mcrypt

php5-ftp

php5-mbstring

pear-PEAR (NOTE about the pear install: you will need to append your .profile with /opt/local/lib/php/pear/bin) your .profile lives in the user home directory. The whole line should end up looking like this:

export PATH=/opt/local/bin:/opt/local/sbin:/opt/local/lib/php/pear/bin:$PATH

You'll notice I didn't actually type in "sudo port install php5" this is because php5 is a dependency on all the other php5 modules so it gets installed automatically. This is the case for anything you install via macports. Visit the macports site for details.

IMPORTANT ABOUT MYSQL

If you want to use Apple's mysql install, you need to do the following:

edit the file located at: /opt/local/etc/php5/php.ini

the default mysql.sock should be changed to /var/mysql/mysql.sock for mysql and mysqli and any other mysql extension. You can do a text search for anything that has mysql. For example these lines should look like this as they are blank by default:

mysql.default_socket =/var/mysql/mysql.sock

mysqli.default_socket =/var/mysql/mysql.sock

then use pear to install any pear extensions (if you have any) like:

pear install db

pear install net_ftp

pear install xml_rss

etc…

Now to load the newly installed php module:

First, edit /etc/apache2/httpd.conf and comment out the apple default php5 module which looks like this: LoadModule php5_module libexec/apache2/libphp5.so (just put a # in front of this line). You will put this line into the custom.conf.

create a file called custom.conf and put it into /etc/apache2/sites/ and add the following 2 lines:

#LoadModule php5_module libexec/apache2/libphp5.so

LoadModule php5_module /opt/local/apache2/modules/libphp5.so

(you need to do this instead of doing it in /etc/apache2/httpd.conf because the Server Admin app will constantly re-edit this file and delete the new macports php module line while leaving the Apple version alone and commented out)

After all this, do sudo apachectl restart and you should be done. If something goes wrong, uncomment the apple php module and comment out the macports php module (in the /etc/apache2/sites/custom.conf file you created) restart apache and then troubleshoot.

Nick,

I've tried your recommendations and can get PHP 5.3.9 installed but can't get it to connect back to my mySQL default database from Apple.

I've opened my original php.ini file (the default file in /etc/) and have copied the mysql default settings from that file and created the php.ini file in /opt/local/etc/php5/ folder (from the php.ini-production file) and can't get it to connect back to my original mySQL database.

Any other ideas?

Ok, I forgot: I believe that by default in macports the php.ini file was named php.ini-production and php.ini-development.

You will need to copy and rename the php.ini-production to php.ini and change the mysql default connection settings in there, these lines at the very least (there are a couple other mysql type extenstions that all connect to mysql.sock)

mysql.default_socket =/var/mysql/mysql.sock

mysqli.default_socket =/var/mysql/mysql.sock

Don't use the apple /etc/php.ini file. Also remember if you added or changed anything to /etc/php.ini you will need to duplicate those in the /opt/local/etc/php5/php.ini file

Also, the php5-mysql does not install mysql, simply the extension that allows php to use mysql. So if you didn't install that you need to!

NIck,

Tbanks! That helped. Wordpress works fine with mySQL, but my gallery 3 installation isn't working:( I guess if it isn't one thing it's another!

PhpMyAdmin works fine

phpinfo returns the correct data.

I'll figure it out.

Thanks for the help

Nick,

How do I find the pear extensions that need repaired?

We are trying to build a home for the Apple community and would very much appreciate any help from PHP developers who would like to help us do that. www.MyAppleSpace.com