MacOS Sierra - Custom PHP Compiled from Source with Threading and Custom ODBC Support

I recently got a new Macbook Pro and wanted to document how I setup my PHP environment. I like full control of how PHP is built and I usually build it from source. I do this because I often add custom extensions and modules not found in the common PHP OSX installers. If your looking for a easier method than building from source try https://php-osx.liip.ch/.

NOTE: This post assumes you are running a fresh install of MacOS Sierra 10.12.16 with System Integrity Protection disabled. If you don't know how to disable it just boot into recovery mode and open a terminal and type csrutil disable, or google search it :) This post also assumes you are using Zsh instead of Bash shell. If you are using Bash you can replace anytime you see ~/.zshrc with ~/.bashrc.

First lets get some of the prerequisites. Start by grabbing the command line tools neccessary:

xcode-select --install

Next install homebrew:

/usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"

Then install some generic libraries needed:

brew install wget
brew install openssl
brew install libxml2
brew link libxml2 --force
brew install jpeg
brew install libpng
brew install libmcrypt

I like to setup a location for stuff I compile from source. I good place to put stuff is /usr/local/src. Here is how to setup that location:

sudo mkdir -p /usr/local/src
sudo chown $(whoami):staff /usr/local/src
cd /usr/local/src

There is an issue with linking the PHP compilation process to the built-in OSX Apache. In order to prevent an error during complication you need to do the following:

brew install apr apr-util

sudo mkdir -p /Applications/Xcode.app/Contents/Developer/Toolchains/OSX10.13.xctoolchain/usr/local/bin/
sudo ln -s /usr/local/opt/apr/bin/apr-1-config /Applications/Xcode.app/Contents/Developer/Toolchains/OSX10.13.xctoolchain/usr/local/bin/
sudo ln -s /usr/local/opt/apr-util/bin/apu-1-config /Applications/Xcode.app/Contents/Developer/Toolchains/OSX10.13.xctoolchain/usr/local/bin/

Set the correct path:

sudo xcode-select -s /Library/Developer/CommandLineTools

Get OpenSSL from source:

cd /usr/local/src
wget https://www.openssl.org/source/openssl-1.1.0c.tar.gz
tar xzvf openssl-1.1.0c.tar.gz
cd openssl-1.1.0c
./configure shared darwin64-x86_64-cc
make depend
make -j4
sudo make install

Grab ICU4C which is needed ICU 58 for php-intl package:

cd /usr/local/src
wget http://download.icu-project.org/files/icu4c/58.2/icu4c-58_2-src.tgz
tar xzvf icu4c-58_2-src.tgz
cd icu/source
./runConfigureICU MacOSX
make -j4
sudo make install

Download the PHP source code:

cd /usr/local/src
wget http://php.net/distributions/php-7.2.3.tar.gz

Extract the archive and move into the folder:

tar -xzvf php-7.2.3.tar.gz
rm php-7.2.3.tar.gz

Optional Steps for ODBC

If you are interested in compiling custom ODBC support into PHP so it can connect to a Teradata data warehouse you can do the following steps. If you will not be using PHP to connect to an Teradata ODBC data source you can skip this step.

Download ODBC Admin Tool: http://support.apple.com/kb/DL895

Get the Teradata ODBC Driver for Mac OS X: https://downloads.teradata.com/download/connectivity/teradata-odbc-driver-for-mac-os-x

Install system odbc drivers:

brew install unixodbc

Next setup a symlink to make the path to Teradata more saine:

sudo ln -s /Library/Application\ Support/teradata /opt/teradata

Setup some paths:

vi ~/.zshrc

Add at the bottom:

export ODBC_HOME=/opt/teradata/client/16.00
export ODBCINI=$ODBC_HOME/odbc/odbc.ini
export CPPFLAGS="-I$ODBC_HOME/include"
export CUSTOM_ODBC_LIBS="-L$ODBC_HOME/lib -lodbc -lodbcinst"
export LD_LIBRARY_PATH=$ODBC_HOME/lib

Create a odbc.ini configuration file:

sudo vi $ODBCINI

Here is an example of the contets:

[ODBC]
Trace=0
TraceFile=/tmp/dmtrace.log

[ODBC Data Sources]
gedw=tdata.dylib

[MY_DSN_NAME_HERE]
Driver=/Library/Application Support/teradata/client/16.00/lib/tdata.dylib
Description=My Data Warehouse
DBCName=MY_SERVER_IP
LastUser=
Username=my_user_name
Password=my_pass_word
Database=
DefaultDatabase=

Now for the fun part. Let's get started by running a ./configure in the PHP source directory. The options I have below are good options that I use that allow PHP Threading support. If you have never tried threading in PHP using pthreads you are missing out :) https://github.com/krakjoe/pthreads.

If you skiped out on the ODBC connection above. I assume most of you did. You can omitt the --with-custom-odbc line in the configure statement below.

Lets get started:

cd /usr/local/src
cd php-7.2.3

./configure \
  --prefix=/usr/local/dev/php-7.2.3 \
  --with-config-file-path=/usr/local/dev/php-7.2.3/etc \
  --with-config-file-scan-dir=/usr/local/php-7.2.3/ext \
  --enable-bcmath \
  --enable-cli \
  --enable-mbstring \
  --enable-gd-jis-conv \
  --enable-sockets \
  --enable-exif \
  --enable-ftp \
  --enable-intl \
  --enable-soap \
  --enable-zip \
  --enable-opcache \
  --enable-simplexml \
  --enable-maintainer-zts \
  --with-sqlite3 \
  --enable-xmlreader \
  --enable-xmlwriter \
  --with-mysql-sock=/tmp/mysql.sock \
  --with-mysqli=mysqlnd \
  --with-pdo-mysql=mysqlnd \
  --with-pdo-sqlite \
  --with-bz2 \
  --with-curl \
  --with-gd \
  --with-imap-ssl \
  --with-pear \
  --with-libxml-dir=/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.13.sdk/usr/ \
  --with-openssl=/usr/local/Cellar/openssl/1.0.2j \
  --with-xmlrpc \
  --with-xsl \
  --with-zlib \
  --with-apxs2 \
  --with-iconv=/usr \
  --with-ldap \
  --with-custom-odbc=$ODBC_HOME

Tell the compiler where it can find openssl:

export LDFLAGS=-L/usr/local/opt/openssl/lib
export CPPFLAGS=-I/usr/local/opt/openssl/include

Now lets compile PHP. Make sure to run tests too.

make -j4
make test
sudo make install

After it is compiled I like to setup a directory symlink, this helpful, so whenever a new PHP version comes out I can easily run the same steps above but just change the symlink directory to it's location.

# create a symlink
ln -s /usr/local/dev/php-7.2.3 /usr/local/php

PHP ships with a configuration template for development. I typically tweak the memory_limit and a few other settings, but for now lets just copy it over to the directory you defined as configuration:

sudo cp /usr/local/src/php-7.2.3/php.ini-development /usr/local/php/etc/php.ini
/usr/local/php/bin/pecl config-set php_ini /usr/local/php/etc/php.ini
/usr/local/php/bin/pear config-set php_ini /usr/local/php/etc/php.ini

Now we need to tell our system where to find our new PHP version. To do this lets add to our PATH.

vi ~/.zshrc

Add this to the bottom and save:

export PATH=/usr/local/php/bin:$PATH
export MANPATH=/usr/local/php/php/man:$MANPATH

source ~./zshrc

Now lets ensure the system Apache is using the correct PHP module. Check the /etc/apache/httpd.conf find the following line:

LoadModule php5_module libexec/apache2/libphp5.so

And comment it out, as we're no longer use php 5, it should look like this:

LoadModule php7_module libexec/apache2/libphp7.so

Next lets give Apache the proper instructions when it encourates a PHP file type. To do this create a new file:

sudo vi /etc/apache2/other/php7.conf

Add this to the file and save:

<IfModule php7_module>
        AddType application/x-httpd-php .php
        <IfModule dir_module>
                DirectoryIndex index.html index.php
        </IfModule>
</IfModule>

Finally restart Apache and you should be good to go:

sudo apachectl restart

New blog on Teradata PHP - https://developer.teradata.com/blog/odbcteam/2016/02/php-with-teradata-odbc

julienbourdeau/MacOS Sierra - Custom PHP Compiled from Source with Threading and Custom ODBC Support.md

Optional Steps for ODBC