Matt Langtree

MySQL Lion Not Working

If you are like me you used the default MySQL, Apache and PHP provided with Mac OS X Snow Leopard. When you upgraded to Lion it most likely broke for you.

These are the steps that I followed to get MySQL working on Lion:

  1. Update php.ini - enable all mysql extensions (because I use Zend, wordpress and other frameworks)
  2. Make sure MySQL is started and you can connect to it in Sequel Pro
  3. Go to Database > Server Variables and search for ‘socket’. It will most likely be set to ‘/tmp/mysql.sock’
  4. Update the socket locations for MySQL in your php.ini to /tmp/mysql.sock

Before:

1
2
`pdo_mysql.default_socket=/var/mysql/mysql.sock mysql.default_socket =
/var/mysql/mysql.sock mysqli.default_socket = /var/mysql/mysql.sock`

After:

1
2
`pdo_mysql.default_socket=/tmp/mysql.sock mysql.default_socket =
/tmp/mysql.sock mysqli.default_socket = /tmp/mysql.sock`

Go to System Preferences > Sharing and restart ‘Web Sharing’ by unticking then ticking the checkbox next to it.

Refresh the local website you were working on it should all be working. Fingers Crossed.

First Screencast - Sequel Pro Getting Started

This is my first attempt at screencasting, so go easy. The motivation behind this was a general consensus that the release notes for Sequel Pro releases were consistently long and nobody besides the developers would even read them.

Installing Sequel Pro and Connecting via a socket and SSH Tunnel

I’ve had a fair bit of feedback from peers about the way I present in my screencasts:

  • I need to speak slower. - I need to emphasise stumbling points for new users. - Screencasts are for new users, not me. So make it easy to follow. - The typing is a little loud but it is good to get that additional audible indication of what is happening. - Mouse movements need to be more clear and concise.
    If it all gets too real, I may have to turn commenting off, but for now let me know what you think.

Medium Stack iPhone App

hide The new iPhone App for Medium Stack is in Alpha testing stages, as the final features are added to the app. Anybody who is willing to both test and provide bug reports for this new iPhone app should contact me at North of Three.

Upload and comment on your Medium Stack images, share with SMS, Twitter and via the clipboard.

The  iPhone app takes full advantage of the Medium Stack API for accessing all of your media.

Jay–Z - Death of Auto-Tune

So, here’s the story.. Jay-Z wakes up one day and gets dropped off at an abandoned warehouse, by himself.

He proceeds to rap in the empty warehouse, by himself.

He blows sh*t up and disses a bunch of rappers. finito.

Jindabyne and the Snowy Mountain Region

Richie and I went up to see the snow bunnies up at Perisher Blue, and we took the camera along. Along the way we got a small bout of snow, we experienced 1 degree temperature and had a “run in” with a kangaroo…

img_6510 img_6557 img_6537 p1000584

Have a look through the photos and leave a comment on Flickr or on the blog.

Mooloolaba to Canberra

It’s late here 1:20am and I’m heading to the snow early tomorrow.. Sorry, I haven’t labeled any of the photos yet :(

But here they are, photos from Mooloolaba to Canberra. There is plenty of video still to come :P

img_0845 img_0848 img_6366 img_0860

Here’s the quick itinerary of my last few days..

Thursday: Hang out with Belinda and Fabrizio, check out Mooloolaba Main Beach and have beers at O’Malleys with Fabrizio, drive a few hours to pick up some Trials boots for Dave from Brisbane..
Friday: Driving and driving (Mooloolaba to Coffs Harbour)
Saturday: Coffs Harbour to Newcastle (to see a relatives new 350Z and say Hi!), then to Sydney.
Saturday Night: Yummy Thai food + Buzz on PS2 + Ţuica (thanks to Marius Ursache) at Ben Perry’s apartment (avenjamin) in Sydney.
Sunday: 15 minute train ride to Sydney — saw the Harbour bridge, Opera House and Australia’s flagship Apple Store. Drive to Canberra..
Monday: Questacon in the afternoon. Taking Pelham 123 at Hoyts at Woden Plaza. Chased a wombat (we called her Jill) across the road into the bushes near KRudd’s house.
Tomorrow: Check out Jindabyne.. Perisher.. Thredbo .. :)

Townsville to Mooloolaba Photos

Sorry for the missing videocast yesterday, there was no 3G coverage in Mooloolaba where I was staying. I’ve decided to post the Townsville-Mackay, Mackay-Maryborough and Maryborough-Mooloolaba photos (Wow, did I get all the names right?) whilst I get the video ready.

img_6187 img_6198 img_6226 img_6250

Cairns to Townsville

The first leg of the trip was only short, a mere 4 hours driving. I’m staying the night in Townsville with relatives Auntie Marie, Uncle Bill and my cousin’s Timothy and Emily.

I was a bit slow off the start, with a few pre-travel requirements stealing the daylight away from me. At the last minute before I thought I was leaving, I asked my awesome dad to give the car a once over and check the essentials.

Oil .. OK, Wiper Fluid ..OK, Tyres .. FAIL!

Climbing the Walsh’s Pyramid

Was up bright and early on Saturday morning (22Aug09) to climb the local ‘Mordor” - Walsh’s Pyramid.

img_6129 img_6133 img_6126 img_4979