CakePHP on OSX: Problem using Bake.php script

  • Posted by max
  • 8 May 2007

If you are getting the following errors while trying to bake something on osx 10.4:
"Warning: mysql_connect(): Can't connect to local MySQL server through
socket ‘/var/mysql/mysql.sock’ (2) in
/Library/WebServer/Documents/development/bakery/cake/libs/model/dbo/dbo_mysql.php
on line 117″

try doing the following:
sudo ln -s /tmp /var/mysql

Or you could follow the instruction given by Apple: Mac OS X Server 10.4: Issues connecting PHP to MySQL

Information and Links

Join the fray by commenting, tracking what others have to say, or linking to it from your blog.

Information
May 8th, 2007
9 Responses
Feeds and Links
Comment Feed
From This Author
Del.icio.us
Digg
Technorati
Categories and Tags
CakePHP
osx

Other Posts
CakePHP: Central cake core install with multiple apps
Top 5 red flags of software development

Write a Comment

Take a moment to comment and tell us what you think. Some basic HTML is allowed for formatting.

Reader Comments

Comment Number:
1
Written by:
Junior baker
Posted on:
3 July 2007 at 10:45 am

Tried that, but it didn’t remove the issue for me :(
I’m using 1.2.0.5146alpha version with MAMP. CakePHP is able to connect to the database otherwise.

I have edited the /etc/my.cnf file as follows:

[mysqld]
socket=/Applications/MAMP/tmp/mysql/mysql.sock

That solved the baking issues with the stable version of cake. Can’t figure out what the problem is with 1.2. though…

Comment Number:
2
Written by:
max
Posted on:
4 July 2007 at 8:55 pm

Hi Junior Baker,

Thanks for giving the fix for others that use the MAMP install….
The fix I provided was only for the stand-alone MySQL installations.

Comment Number:
3
Written by:
Brian Pan
Posted on:
8 September 2007 at 11:35 pm

I had the same problem. Thanks for the post!

Comment Number:
4
Written by:
tm
Posted on:
28 September 2007 at 12:39 am

A temporary dirty fix for MAMP and the latest SVN build:

sudo ln -s /Applications/MAMP/tmp/mysql/mysql.sock /var/mysql/mysql.sock

Comment Number:
5
Written by:
Tomasz Zwierzchon
Posted on:
30 September 2007 at 2:34 pm

Hi.

Another (better) solution (assuming you are in scripts directory of a Cake):

* for php5
$ ../../../../bin/php5/bin/php bake.php

* for php4
../../../../bin/php4/bin/php bake.php

Works perfectly.

Comment Number:
6
Written by:
thomas
Posted on:
10 May 2008 at 7:14 pm

Hi all,

the problem is that cake uses php as command interpreter, therefore if you call “php” from the console you will use the default /bin/php
Because I have MAMP, the solution was to set the path to use the php interpreter provided:
you just have to “reverse” the path order:
export PATH=/Applications/MAMP/bin/php5/bin:$PATH

Comment Number:
7
Written by:
milkshake
Posted on:
5 June 2008 at 5:14 pm

Thanks thomas :)

Comment Number:
8
Written by:
Pablo
Posted on:
10 June 2008 at 6:08 am

Thanks TM!!

Comment Number:
9
Written by:
tim
Posted on:
1 September 2008 at 4:39 am

If yopu are using xampp rather than mamp (or the Apple webserver), the only required change is

export PATH=/Applications/xampp/xamppfiles/bin:$PATH

If you place that line in your .profile, you will always call php scripts (like cake) using the xampp php installation instead of the Apple one.