I found out the problem. MAMP comes with its own PHP (reside in /Applications/MAMP/bin/...) Mac OS X has its own PHP (reside in /usr/var/bin/..)
So, when I run the 'cake bake', it is using the Mac OS X default PHP with its php.ini instead of the one that came with MAMP (this one is all configured fine). Hence, I had to add the path to MAMP's PHP...not sure if this would affect me in the long run when I don't use MAMP and do need actually default PHP on Mac OS X. On Mar 11, 1:31 am, bearlee <brianleeu...@gmail.com> wrote: > Hi all, > > On my Mac OS X, I've installed MAMP and followed the blog tutorial > provided on CakePHP. > Blog tutorial went fine without any errors (no configuration error). > > However, when I tried to follow the 'Simple Acl controlled > Application' tutorial, I could not run 'cake bake'. > Before I rant about my issue any further, let me show you the error > message I get: > > Welcome to CakePHP v1.2.1.8004 Console > --------------------------------------------------------------- > App : app > Path: /Applications/MAMP/htdocs/webroot/app > --------------------------------------------------------------- > Interactive Bake Shell > --------------------------------------------------------------- > [D]atabase Configuration > [M]odel > [V]iew > [C]ontroller > [P]roject > [Q]uit > What would you like to Bake? (D/M/V/C/P/Q)> M > > --------------------------------------------------------------- > Bake Model > Path: /Applications/MAMP/htdocs/webroot/app/models/ > --------------------------------------------------------------- > > Warning: mysql_pconnect(): Can't connect to local MySQL server through > socket '/var/mysql/mysql.sock' (2) in /Applications/MAMP/htdocs/ > webroot/cake/libs/model/datasources/dbo/dbo_mysql.php on line 372 > > Warning: mysql_select_db(): supplied argument is not a valid MySQL- > Link resource in /Applications/MAMP/htdocs/webroot/cake/libs/model/ > datasources/dbo/dbo_mysql.php on line 375 > > Warning: mysql_get_server_info(): supplied argument is not a valid > MySQL-Link resource in /Applications/MAMP/htdocs/webroot/cake/libs/ > model/datasources/dbo/dbo_mysql.php on line 383 > > Warning: mysql_query(): supplied argument is not a valid MySQL-Link > resource in /Applications/MAMP/htdocs/webroot/cake/libs/model/ > datasources/dbo/dbo_mysql.php on line 407 > Error: Your database does not have any tables. > > So basically, I believe that PHP is trying to connect with wrong mysql > socket, because according to the phpinfo page and the MAMP start page > indicate that the mysql socket is located /Applications/MAMP/tmp/mysql/ > mysql.sock > > I tried to change my config/database.php file around to use the socket > path instead of 'localhost' for host and also tried putting in port > (8889 as indicated on the start page of MAMP). > > Has anyone encountered the same problem and resolved it? > I don't know why the blog tutorial did not give any problems like this > (it still doesn't!), because the blog tutorial uses the database to > CRUD blog posts. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---