PHP MSSQL & PDO_DBLIB (FreeTDS) support on Mac OSX 10.9 Mavericks

Mac, PHP
So since upgrading to Mavericks I have lost the ability to use PHP's MSSQL and PDO_DBLIB database extensions. I had previously set this up on Lion/Mountain Lion. You'll need to download the latest Xcode from the Mac App Store and then run it and install the command line tools. This will allow you to build the packages below. We'll also need autoconf so download the latest source at autoconf-latest.tar.gz. At the time this article was published the latest release was v2.69. Extract this and then using terminal navigate to the extracted source directory and run the below commands: [crayon-6605e09e9d95f447911283/] Now on to FreeTDS, this is the library that will connect to MSSQL. Visit this link to get the latest stable version of FreeTDS: freetds-stable.tgz. At the time this article was…
Read More

Using syslog for your PHP application logging

Linux, Mac, PHP
In the past I have created custom log files for my PHP applications, mainly because I'd never bothered to read up on syslog and I wasn't using it for major stuff. This time I decided to do the reading and syslog really does have lots of benefits and is just as quick to set up as custom logging. Anyway, I found this nice overview and examples of how you can use syslog with your application. Check it out - Using syslog for your php applications
Read More

PHP memcached on OSX Lion

Mac, PECL, PHP
Having set up the PHP memcache extension on my mac yesterday I now need the PECL memcached extension to use with Zend_Cache. This one was a little more involved than yesterday so here is a quick list of things you'll need to do. My first instinct was to use PECL to get the extension but doing that told me that there was an unmet dependancy so it couldn't be installed. The missing dependancy was libmemcached, here's what you need to do to get libmemcached setup: First go to https://launchpad.net/libmemcached/+download and download the latest libmemcached (1.0.4 at the time of writing), once downloaded extract the archive and then open up a terminal window and cd to the new libmemcached-1.x.x directory. Now enter the commands below into the terminal window one at…
Read More

PHP memcache extension on OSX Lion

Mac, PECL, PHP
Today I needed the PHP memcache extension on my Mac OSX Lion 10.7.3 development machine for a project I'm working on. I was pleased to find out that this was a nice and easy one to get up and running. Open up a terminal window and run the command below, this will tell PECL to download, build and install the extension. [crayon-6605e09e9e1a3432198532/] Now that the extension is installed on your system, you need to enable it in your PHP configuration file. On a standard system the php.ini file can be found at /etc/php.ini. Open the file and scroll down to the extensions section, at the bottom of this section add the line extension=memcache.so and then save and close the file. After that, all that is required is for you to…
Read More

PECL UUID extension on Mac OSX

Mac, PECL, PHP
Today I needed to set up the PECL UUID PHP module on my Mac OSX 10.7 Lion development machine, I needed it for a project that I'm working on. My first reaction was to fire up terminal and run sudo pecl install uuid. It all looked good for a moment but then came to a grinding halt when 'make' failed. Here is the error for reference (and for those searching snippets of it): [crayon-6605e09e9e59c133405239/] After a bit of googling I found out what the problem was and a solution to it. The full explanation and solution can be found here: https://wp.michaelleo.com/2010/04/mamp-pecluuid-module-working-on-snow-leopard/ I can confirm that the patch and build worked on my set up (OSX 10.7 Loin) and I hope by spreading the word it some more people out.
Read More

Installing and setting up PEAR

Mac, PHP
This post will help you get PEAR installed and up and running on your machine, there are two options to below, one describes an OXS Lion specific setup and the other is more generic. Installing on OSX 10.7 Lion OSX Lion already has the PEAR install bundle so there is no need to download it, open up a terminal window and enter the following commands: [crayon-6605e09e9e915381764854/]   Downloading and installing Do not follow this part if you have just done the above steps. Otherwise enter the below into a terminal window: [crayon-6605e09e9e91a127077725/] It will ask you to enter a new installation base ($prefix). I recommend you use /usr/local   Configuring PHP include path Edit /etc/php.ini and find the line: ;include_path = ".:/php/includes". Uncomment it (remove the ; at the beginning) and add the PEAR path to…
Read More

Install MySQL 5.1 Server on OSX Lion

Mac, MySQL
So I had to get MySQL set up on my OSX Lion MacBook Pro after the recent format and upgrade to Lion. It was easier than i expected but I thought that it was still worth a post anyway. First off, head over to the MySQL site and download the Mac pre-compiles binary of MySQL Community Server 5.1.x (the latest download says it's for OSX 10.6 Snow Leopard but it works fine with 10.7 Lion). Download the latest DMG available, this can be found here http://dev.mysql.com/downloads/mysql/5.1.html. When the download finishes, open the disk image and install the main package file (mysql-5.1.xx-osx10.6-x86_64.pkg), when that finishes double-click on the preferences pane (MYSQL.prefpane file) file to install that into the System Preferences menu. If you would like the database server to start on boot then…
Read More

Apache SSL on Mac OSX Lion 10.7

Apache, Mac
Update 11-12-2013: According to a commenter this process also works for OSX 10.9 Mavericks. I have recently upgraded to OSX Lion from Snow Leopard, whilst setting up my development environment I needed to configure the built in Apache server to support SSL. Below are instructions on what needed to be done. Please note that the below is based on a clean install of OSX 10.7.2 and if you did an upgrade or are running a different version of Lion then the instructions below may need to be tweaked to suit your setup.   Generate a host key First off we'll make a home for the new SSL files. I used /private/etc/apache2/ssl. We need to change to the new directory and then run a ssh-keygen command to create the server key…
Read More