Re: baking cakephp on MAC OS

[Akitah Blessed]

CHANGING THE LOCALHOST from localhost to 127.0.0.1 worked for me... took me 
forever to find this post on the google group but i tried the IP to 
localhost and bingo, it now works. A community at work. Thanks Roldan.


>>

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.

Re: baking cakephp on MAC OS

[theMojoWill]

Check out my post 
here 
wrote 
it during CakeFest last year!

On Sunday, January 18, 2009 7:59:57 PM UTC, bookme wrote:
>
> Hi, 
>
> I am trying to bake cake application on MAC OS but can not get 
> success. 
>
> I have tried two solution but not working. 
>
> 1 when I run cake bake command in app folder 
>  xampp/htdocs/cakephp/app> cake bake 
> it's showing cake : command not found on terminal 
>
> 2 In parent directory when I run 
> xampp/htdocs/cakephp > ./cake/console/cake bake 
> App : app 
> Path: /Application/xampp/xampfiles/htdocs/cakephp/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 
>
> --- 
> Model Bake: 
> --- 
> Database Connection: 
> [default] > 
> Warning: mysql_connect(): Can't connect to local MySQL server through 
> socket '/var/mysql/mysql.sock' (2) in /Applications/xampp/xamppfiles/ 
> htdocs/cake/cake/libs/model/datasources/dbo/dbo_mysql.php on line 370 
>
> Warning: mysql_select_db(): supplied argument is not a valid MySQL- 
> Link resource in /Applications/xampp/xamppfiles/htdocs/cake/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/xampp/xamppfiles/htdocs/cake/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/xampp/xamppfiles/htdocs/cake/cake/libs/model/ 
> datasources/dbo/dbo_mysql.php on line 407 
> Error: Your database does not have any tables. 
>
> But My database have one table..then what's wrong here? 
> can any body tell me what's wrong I am doing here? 
>
> or please tell what's tseps to run cake bake on MAC OS. 
>
> Thanks 
>
>
>

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: baking cakephp on MAC OS

[lowpass]

On Fri, Feb 15, 2013 at 10:39 PM, Roldan Aquino  wrote:
> This maybe an old topic but I also got into the same issue with CakePHP 2.xx
> in MacOS X..The solution for me was
> simple. I just changed the host value in database.php from localhost to
> 127.0.0.1 and I am able to bake again.. :)

What I do is create 2 entries in the user table:

GRANT ALL PRIVILEGES ON db_whatever.* TO username@localhost IDENTIFIED
BY 'password';
GRANT ALL PRIVILEGES ON db_whatever.* TO username@127.0.0.1 IDENTIFIED
BY 'password';

This way, I can force a TCP/IP connection (rather than a UNIX socket)
if I need to. (Or some application does.)

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: baking cakephp on MAC OS

[Roldan Aquino]

This maybe an old topic but I also got into the same issue with CakePHP 
2.xx in MacOS X..The solution for me was
simple. I just changed the host value in database.php from localhost to 
127.0.0.1 and I am able to bake again.. :)

On Wednesday, 21 January 2009 19:55:36 UTC+8, leo wrote:
>
> > I  install fresh mysql, phpmyadmin but not working ? 
>
> phpMyadmin won't help much except to say a PHP is talking to a MySQL. 
>
> When you did the ps - ef | grep mysql.sock what were the outputs for 
> file= and socket= ? Was there more than one? 
>
> Do they correspond to the XAMPP directories? 
>
> What is the status of the servers as displayed by XAMPP? 
>
> Just a thought, but it may be that if you turn off web sharing (System 
> Preferences->Internet & Network->sharing->web sharing) that will sort 
> it all out as it should (I think) stop the native Apache server. 
>
> I used XAMPP on a PC sometime ago, but I used MAMP on my Mac and 
> second Chad's comments, except to say that I didn't like the setup 
> very much and eventually it killed itself, so I performed a base 
> install of MySQL. I also had the problem that when testing on Windows 
> on a different machine, Windows could only see the native Apache and 
> not the MAMP stack. 
>
> Now everything is stable and there is no confusion about which Apache 
> is which or which PHP etc. Unless you're very confident working in 
> UNIX, have OS X install disks, good backups and no hair, I wouldn't 
> recommend this route, though. 
>
>

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: baking cakephp on MAC OS

[leo]

> I  install fresh mysql, phpmyadmin but not working ?

phpMyadmin won't help much except to say a PHP is talking to a MySQL.

When you did the ps - ef | grep mysql.sock what were the outputs for
file= and socket= ? Was there more than one?

Do they correspond to the XAMPP directories?

What is the status of the servers as displayed by XAMPP?

Just a thought, but it may be that if you turn off web sharing (System
Preferences->Internet & Network->sharing->web sharing) that will sort
it all out as it should (I think) stop the native Apache server.

I used XAMPP on a PC sometime ago, but I used MAMP on my Mac and
second Chad's comments, except to say that I didn't like the setup
very much and eventually it killed itself, so I performed a base
install of MySQL. I also had the problem that when testing on Windows
on a different machine, Windows could only see the native Apache and
not the MAMP stack.

Now everything is stable and there is no confusion about which Apache
is which or which PHP etc. Unless you're very confident working in
UNIX, have OS X install disks, good backups and no hair, I wouldn't
recommend this route, though.


--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---

Re: baking cakephp on MAC OS

[Martin Westin]

I can probably help if you can be a bit more specific about what is
not working? How far along are you?


On Jan 20, 9:23 pm, bookme  wrote:
> Thanks your suggestions...I tired all above solutions but not get
> success.
>
> I  install fresh mysql, phpmyadmin but not working ?
> still have same problem.
>
> please can somebody help me?
> Thanks
>
> On Jan 20, 2:45 pm, Martin Westin  wrote:
>
> > I second Mark's reply. If you simply call path/to/cake/console/cake
> > you will be using the system's version of php.
>
> > If you are committed to using a lot of shell stuff (such as bake), you
> > really should switch to using the system's php install. It will make
> > things easier in the long run. The setup is actually very easy. The
> > only real snag is the MySQL socket but I think that has been taken
> > care of in the latest builds of MySQL... but I may be wrong on that
> > one.
>
> > You need:
> > Install MySQL (from mysql.com).
> > Open /etc/apache2/httpd.conf and uncomment "LoadModule php5_module..."
> > around line 114. (and restart apache)
> > Drop your cake files into /Library/WebServer/Documents/ or /Users/
> > myname/Sites/
> > Do the trick for MySQL described in the post linked earlier
> > (Webweave's reply)
>
> > Optionally you can add production-style vhosts to serve several sites
> > and fake some nive domain names for each... then you will be in Cake
> > heaven. :)
>
> > There is a lot of info in the following bakery article. (But not all
> > of it is relevant 
> > still.)http://bakery.cakephp.org/articles/view/installing-cakephp-on-macos-x
>
> > /Martin
>
> > On Jan 20, 1:05 am, mark_story  wrote:
>
> > > Also since you are on macos check which php you are using.  I bet you
> > > are using the stock Apple PHP
>
> > > which php
>
> > > Should give you the path to the PHP that is the cli default.
>
> > > -Mark
>
> > > On Jan 19, 3:36 pm, leo  wrote:
>
> > > > If you're using XAMPP, I don't think it's a php/mysql config problem.
> > > > that is precisely  the problem these *AMP stacks are designed to
> > > > avoid. However, you might want to try the following. Incidentally,
> > > > that should be "Applications" PLURAL in your path.
>
> > > > Open a terminal, and type:
>
> > > >     ps -af | grep mysql.sock           [enter]
>
> > > > The result on my machine is:
>
> > > >     sh-3.2# ps -ef | grep mysql.sock
> > > >               74  2405  2379   0   0:15.88 ??         1:57.74 /usr/
> > > > local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/
> > > > mysql/data --user=mysql --pid-    file=/usr/local/mysql/data/
> > > > Leopard.local.pid --port=3306 --socket=/tmp/mysql.sock
> > > >     0  4814  4805   0   0:00.01 ttys000    0:00.01 grep mysql.sock
> > > > sh-3.2#
>
> > > > see the last bit? port=3306 socket=/tmp/mysql.sock
> > > > that path (/tmp/mysql.sock) is the path to MY socket (and the port is
> > > > the port!) yours will be different because mine is not an *AMP stack.
>
> > > > Now, in your htdocs directory create phpinfo.php with 
> > > > > as the sole content. Make sure there is no new line after the ?>
>
> > > > View the file in Safari and halfway down the first screen is the path
> > > > to the loaded configuration file. This is the one you need to edit to
> > > > configure php. Continue down the page - you'll need to scroll about
> > > > halfway down and see if there is a mysql section. If there is, I don't
> > > > think you have a problem with php.ini. If there isn't, mysql isn't
> > > > talking to PHP and you'll need to find and edit the appropriate part
> > > > of the ini file.
>
> > > > If I remember correctly, XAMPP already has a phpinfo link.
>
> > > > I don't pretend that this is a solution, but if you post the results
> > > > here, at least we'll have something to work with.
>
> > > > Good luck.
>
> > > > On Jan 19, 8:46 pm, bookme  wrote:
>
> > > > > Thanks for your solution...but still not working.
>
> > > > > I tried both above solution but not working.
>
> > > > > I am using xampp on MAC OS..
> > > > > ERROR :  Can't connect to local MySQL server through Socket '/var/
> > > > > mysql/mysql.sock ?
>
> > > > > I also set envornment variable using
> > > > > echo 'export PATH=Application/xampp/xamppfiles/htdocs/clalumni/cake/
> > > > > console/cake:$PATH' >> ~/.bash_profile
> > > > > echo 'export PATH=Application/xampp/xamppfiles/lib/php:$PATH' >>
> > > > > ~/.bash_profile
>
> > > > > but still not able to run cake bake?
>
> > > > > Please help me to run cake bake on MAC OS.
> > > > > Thanks
>
> > > > > On Jan 19, 8:22 pm, leo  wrote:
>
> > > > > > I used to use MAMP. It used a non-standard port for the DB. Check
> > > > > > which port you're using and add it as shown in the database.php
> > > > > > comments:
>
> > > > > >  * host =>
> > > > > >  * the host you connect to the database.  To add a socket or port
> > > > > > number, use 'port' => #
> > > > > >  *
--~--~-~--~~~---~--~~
You received this message because you are s

Re: baking cakephp on MAC OS

[Chad Casselman]

Are you tied to XAMPP?  I am using MAMP on Mac and baking just fine.  MAMP
is a much tighter package that XAMPP.

Chad



On Tue, Jan 20, 2009 at 3:23 PM, bookme  wrote:

>
> Thanks your suggestions...I tired all above solutions but not get
> success.
>
> I  install fresh mysql, phpmyadmin but not working ?
> still have same problem.
>
> please can somebody help me?
> Thanks
>
> On Jan 20, 2:45 pm, Martin Westin  wrote:
> > I second Mark's reply. If you simply call path/to/cake/console/cake
> > you will be using the system's version of php.
> >
> > If you are committed to using a lot of shell stuff (such as bake), you
> > really should switch to using the system's php install. It will make
> > things easier in the long run. The setup is actually very easy. The
> > only real snag is the MySQL socket but I think that has been taken
> > care of in the latest builds of MySQL... but I may be wrong on that
> > one.
> >
> > You need:
> > Install MySQL (from mysql.com).
> > Open /etc/apache2/httpd.conf and uncomment "LoadModule php5_module..."
> > around line 114. (and restart apache)
> > Drop your cake files into /Library/WebServer/Documents/ or /Users/
> > myname/Sites/
> > Do the trick for MySQL described in the post linked earlier
> > (Webweave's reply)
> >
> > Optionally you can add production-style vhosts to serve several sites
> > and fake some nive domain names for each... then you will be in Cake
> > heaven. :)
> >
> > There is a lot of info in the following bakery article. (But not all
> > of it is relevant still.)
> http://bakery.cakephp.org/articles/view/installing-cakephp-on-macos-x
> >
> > /Martin
> >
> > On Jan 20, 1:05 am, mark_story  wrote:
> >
> > > Also since you are on macos check which php you are using.  I bet you
> > > are using the stock Apple PHP
> >
> > > which php
> >
> > > Should give you the path to the PHP that is the cli default.
> >
> > > -Mark
> >
> > > On Jan 19, 3:36 pm, leo  wrote:
> >
> > > > If you're using XAMPP, I don't think it's a php/mysql config problem.
> > > > that is precisely  the problem these *AMP stacks are designed to
> > > > avoid. However, you might want to try the following. Incidentally,
> > > > that should be "Applications" PLURAL in your path.
> >
> > > > Open a terminal, and type:
> >
> > > > ps -af | grep mysql.sock   [enter]
> >
> > > > The result on my machine is:
> >
> > > > sh-3.2# ps -ef | grep mysql.sock
> > > >   74  2405  2379   0   0:15.88 ?? 1:57.74 /usr/
> > > > local/mysql/bin/mysqld --basedir=/usr/local/mysql
> --datadir=/usr/local/
> > > > mysql/data --user=mysql --pid-file=/usr/local/mysql/data/
> > > > Leopard.local.pid --port=3306 --socket=/tmp/mysql.sock
> > > > 0  4814  4805   0   0:00.01 ttys0000:00.01 grep mysql.sock
> > > > sh-3.2#
> >
> > > > see the last bit? port=3306 socket=/tmp/mysql.sock
> > > > that path (/tmp/mysql.sock) is the path to MY socket (and the port is
> > > > the port!) yours will be different because mine is not an *AMP stack.
> >
> > > > Now, in your htdocs directory create phpinfo.php with  ?
> >
> > > > > as the sole content. Make sure there is no new line after the ?>
> >
> > > > View the file in Safari and halfway down the first screen is the path
> > > > to the loaded configuration file. This is the one you need to edit to
> > > > configure php. Continue down the page - you'll need to scroll about
> > > > halfway down and see if there is a mysql section. If there is, I
> don't
> > > > think you have a problem with php.ini. If there isn't, mysql isn't
> > > > talking to PHP and you'll need to find and edit the appropriate part
> > > > of the ini file.
> >
> > > > If I remember correctly, XAMPP already has a phpinfo link.
> >
> > > > I don't pretend that this is a solution, but if you post the results
> > > > here, at least we'll have something to work with.
> >
> > > > Good luck.
> >
> > > > On Jan 19, 8:46 pm, bookme  wrote:
> >
> > > > > Thanks for your solution...but still not working.
> >
> > > > > I tried both above solution but not working.
> >
> > > > > I am using xampp on MAC OS..
> > > > > ERROR :  Can't connect to local MySQL server through Socket '/var/
> > > > > mysql/mysql.sock ?
> >
> > > > > I also set envornment variable using
> > > > > echo 'export
> PATH=Application/xampp/xamppfiles/htdocs/clalumni/cake/
> > > > > console/cake:$PATH' >> ~/.bash_profile
> > > > > echo 'export PATH=Application/xampp/xamppfiles/lib/php:$PATH' >>
> > > > > ~/.bash_profile
> >
> > > > > but still not able to run cake bake?
> >
> > > > > Please help me to run cake bake on MAC OS.
> > > > > Thanks
> >
> > > > > On Jan 19, 8:22 pm, leo  wrote:
> >
> > > > > > I used to use MAMP. It used a non-standard port for the DB. Check
> > > > > > which port you're using and add it as shown in the database.php
> > > > > > comments:
> >
> > > > > >  * host =>
> > > > > >  * the host you connect to the database.  To add a socket or port
> > > > > > number, use 'port' => #
> > > > > 

Re: baking cakephp on MAC OS

[bookme]

Thanks your suggestions...I tired all above solutions but not get
success.

I  install fresh mysql, phpmyadmin but not working ?
still have same problem.

please can somebody help me?
Thanks

On Jan 20, 2:45 pm, Martin Westin  wrote:
> I second Mark's reply. If you simply call path/to/cake/console/cake
> you will be using the system's version of php.
>
> If you are committed to using a lot of shell stuff (such as bake), you
> really should switch to using the system's php install. It will make
> things easier in the long run. The setup is actually very easy. The
> only real snag is the MySQL socket but I think that has been taken
> care of in the latest builds of MySQL... but I may be wrong on that
> one.
>
> You need:
> Install MySQL (from mysql.com).
> Open /etc/apache2/httpd.conf and uncomment "LoadModule php5_module..."
> around line 114. (and restart apache)
> Drop your cake files into /Library/WebServer/Documents/ or /Users/
> myname/Sites/
> Do the trick for MySQL described in the post linked earlier
> (Webweave's reply)
>
> Optionally you can add production-style vhosts to serve several sites
> and fake some nive domain names for each... then you will be in Cake
> heaven. :)
>
> There is a lot of info in the following bakery article. (But not all
> of it is relevant 
> still.)http://bakery.cakephp.org/articles/view/installing-cakephp-on-macos-x
>
> /Martin
>
> On Jan 20, 1:05 am, mark_story  wrote:
>
> > Also since you are on macos check which php you are using.  I bet you
> > are using the stock Apple PHP
>
> > which php
>
> > Should give you the path to the PHP that is the cli default.
>
> > -Mark
>
> > On Jan 19, 3:36 pm, leo  wrote:
>
> > > If you're using XAMPP, I don't think it's a php/mysql config problem.
> > > that is precisely  the problem these *AMP stacks are designed to
> > > avoid. However, you might want to try the following. Incidentally,
> > > that should be "Applications" PLURAL in your path.
>
> > > Open a terminal, and type:
>
> > >     ps -af | grep mysql.sock           [enter]
>
> > > The result on my machine is:
>
> > >     sh-3.2# ps -ef | grep mysql.sock
> > >               74  2405  2379   0   0:15.88 ??         1:57.74 /usr/
> > > local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/
> > > mysql/data --user=mysql --pid-    file=/usr/local/mysql/data/
> > > Leopard.local.pid --port=3306 --socket=/tmp/mysql.sock
> > >     0  4814  4805   0   0:00.01 ttys000    0:00.01 grep mysql.sock
> > > sh-3.2#
>
> > > see the last bit? port=3306 socket=/tmp/mysql.sock
> > > that path (/tmp/mysql.sock) is the path to MY socket (and the port is
> > > the port!) yours will be different because mine is not an *AMP stack.
>
> > > Now, in your htdocs directory create phpinfo.php with 
> > > > as the sole content. Make sure there is no new line after the ?>
>
> > > View the file in Safari and halfway down the first screen is the path
> > > to the loaded configuration file. This is the one you need to edit to
> > > configure php. Continue down the page - you'll need to scroll about
> > > halfway down and see if there is a mysql section. If there is, I don't
> > > think you have a problem with php.ini. If there isn't, mysql isn't
> > > talking to PHP and you'll need to find and edit the appropriate part
> > > of the ini file.
>
> > > If I remember correctly, XAMPP already has a phpinfo link.
>
> > > I don't pretend that this is a solution, but if you post the results
> > > here, at least we'll have something to work with.
>
> > > Good luck.
>
> > > On Jan 19, 8:46 pm, bookme  wrote:
>
> > > > Thanks for your solution...but still not working.
>
> > > > I tried both above solution but not working.
>
> > > > I am using xampp on MAC OS..
> > > > ERROR :  Can't connect to local MySQL server through Socket '/var/
> > > > mysql/mysql.sock ?
>
> > > > I also set envornment variable using
> > > > echo 'export PATH=Application/xampp/xamppfiles/htdocs/clalumni/cake/
> > > > console/cake:$PATH' >> ~/.bash_profile
> > > > echo 'export PATH=Application/xampp/xamppfiles/lib/php:$PATH' >>
> > > > ~/.bash_profile
>
> > > > but still not able to run cake bake?
>
> > > > Please help me to run cake bake on MAC OS.
> > > > Thanks
>
> > > > On Jan 19, 8:22 pm, leo  wrote:
>
> > > > > I used to use MAMP. It used a non-standard port for the DB. Check
> > > > > which port you're using and add it as shown in the database.php
> > > > > comments:
>
> > > > >  * host =>
> > > > >  * the host you connect to the database.  To add a socket or port
> > > > > number, use 'port' => #
> > > > >  *
--~--~-~--~~~---~--~~
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
-~--~~~~--~~---

Re: baking cakephp on MAC OS

[Martin Westin]

I second Mark's reply. If you simply call path/to/cake/console/cake
you will be using the system's version of php.

If you are committed to using a lot of shell stuff (such as bake), you
really should switch to using the system's php install. It will make
things easier in the long run. The setup is actually very easy. The
only real snag is the MySQL socket but I think that has been taken
care of in the latest builds of MySQL... but I may be wrong on that
one.

You need:
Install MySQL (from mysql.com).
Open /etc/apache2/httpd.conf and uncomment "LoadModule php5_module..."
around line 114. (and restart apache)
Drop your cake files into /Library/WebServer/Documents/ or /Users/
myname/Sites/
Do the trick for MySQL described in the post linked earlier
(Webweave's reply)

Optionally you can add production-style vhosts to serve several sites
and fake some nive domain names for each... then you will be in Cake
heaven. :)

There is a lot of info in the following bakery article. (But not all
of it is relevant still.)
http://bakery.cakephp.org/articles/view/installing-cakephp-on-macos-x


/Martin


On Jan 20, 1:05 am, mark_story  wrote:
> Also since you are on macos check which php you are using.  I bet you
> are using the stock Apple PHP
>
> which php
>
> Should give you the path to the PHP that is the cli default.
>
> -Mark
>
> On Jan 19, 3:36 pm, leo  wrote:
>
> > If you're using XAMPP, I don't think it's a php/mysql config problem.
> > that is precisely  the problem these *AMP stacks are designed to
> > avoid. However, you might want to try the following. Incidentally,
> > that should be "Applications" PLURAL in your path.
>
> > Open a terminal, and type:
>
> >     ps -af | grep mysql.sock           [enter]
>
> > The result on my machine is:
>
> >     sh-3.2# ps -ef | grep mysql.sock
> >               74  2405  2379   0   0:15.88 ??         1:57.74 /usr/
> > local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/
> > mysql/data --user=mysql --pid-    file=/usr/local/mysql/data/
> > Leopard.local.pid --port=3306 --socket=/tmp/mysql.sock
> >     0  4814  4805   0   0:00.01 ttys000    0:00.01 grep mysql.sock
> > sh-3.2#
>
> > see the last bit? port=3306 socket=/tmp/mysql.sock
> > that path (/tmp/mysql.sock) is the path to MY socket (and the port is
> > the port!) yours will be different because mine is not an *AMP stack.
>
> > Now, in your htdocs directory create phpinfo.php with 
> > > as the sole content. Make sure there is no new line after the ?>
>
> > View the file in Safari and halfway down the first screen is the path
> > to the loaded configuration file. This is the one you need to edit to
> > configure php. Continue down the page - you'll need to scroll about
> > halfway down and see if there is a mysql section. If there is, I don't
> > think you have a problem with php.ini. If there isn't, mysql isn't
> > talking to PHP and you'll need to find and edit the appropriate part
> > of the ini file.
>
> > If I remember correctly, XAMPP already has a phpinfo link.
>
> > I don't pretend that this is a solution, but if you post the results
> > here, at least we'll have something to work with.
>
> > Good luck.
>
> > On Jan 19, 8:46 pm, bookme  wrote:
>
> > > Thanks for your solution...but still not working.
>
> > > I tried both above solution but not working.
>
> > > I am using xampp on MAC OS..
> > > ERROR :  Can't connect to local MySQL server through Socket '/var/
> > > mysql/mysql.sock ?
>
> > > I also set envornment variable using
> > > echo 'export PATH=Application/xampp/xamppfiles/htdocs/clalumni/cake/
> > > console/cake:$PATH' >> ~/.bash_profile
> > > echo 'export PATH=Application/xampp/xamppfiles/lib/php:$PATH' >>
> > > ~/.bash_profile
>
> > > but still not able to run cake bake?
>
> > > Please help me to run cake bake on MAC OS.
> > > Thanks
>
> > > On Jan 19, 8:22 pm, leo  wrote:
>
> > > > I used to use MAMP. It used a non-standard port for the DB. Check
> > > > which port you're using and add it as shown in the database.php
> > > > comments:
>
> > > >  * host =>
> > > >  * the host you connect to the database.  To add a socket or port
> > > > number, use 'port' => #
> > > >  *
--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---

Re: baking cakephp on MAC OS

[mark_story]

Also since you are on macos check which php you are using.  I bet you
are using the stock Apple PHP

which php

Should give you the path to the PHP that is the cli default.

-Mark

On Jan 19, 3:36 pm, leo  wrote:
> If you're using XAMPP, I don't think it's a php/mysql config problem.
> that is precisely  the problem these *AMP stacks are designed to
> avoid. However, you might want to try the following. Incidentally,
> that should be "Applications" PLURAL in your path.
>
> Open a terminal, and type:
>
>     ps -af | grep mysql.sock           [enter]
>
> The result on my machine is:
>
>     sh-3.2# ps -ef | grep mysql.sock
>               74  2405  2379   0   0:15.88 ??         1:57.74 /usr/
> local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/
> mysql/data --user=mysql --pid-    file=/usr/local/mysql/data/
> Leopard.local.pid --port=3306 --socket=/tmp/mysql.sock
>     0  4814  4805   0   0:00.01 ttys000    0:00.01 grep mysql.sock
> sh-3.2#
>
> see the last bit? port=3306 socket=/tmp/mysql.sock
> that path (/tmp/mysql.sock) is the path to MY socket (and the port is
> the port!) yours will be different because mine is not an *AMP stack.
>
> Now, in your htdocs directory create phpinfo.php with 
> > as the sole content. Make sure there is no new line after the ?>
>
> View the file in Safari and halfway down the first screen is the path
> to the loaded configuration file. This is the one you need to edit to
> configure php. Continue down the page - you'll need to scroll about
> halfway down and see if there is a mysql section. If there is, I don't
> think you have a problem with php.ini. If there isn't, mysql isn't
> talking to PHP and you'll need to find and edit the appropriate part
> of the ini file.
>
> If I remember correctly, XAMPP already has a phpinfo link.
>
> I don't pretend that this is a solution, but if you post the results
> here, at least we'll have something to work with.
>
> Good luck.
>
> On Jan 19, 8:46 pm, bookme  wrote:
>
> > Thanks for your solution...but still not working.
>
> > I tried both above solution but not working.
>
> > I am using xampp on MAC OS..
> > ERROR :  Can't connect to local MySQL server through Socket '/var/
> > mysql/mysql.sock ?
>
> > I also set envornment variable using
> > echo 'export PATH=Application/xampp/xamppfiles/htdocs/clalumni/cake/
> > console/cake:$PATH' >> ~/.bash_profile
> > echo 'export PATH=Application/xampp/xamppfiles/lib/php:$PATH' >>
> > ~/.bash_profile
>
> > but still not able to run cake bake?
>
> > Please help me to run cake bake on MAC OS.
> > Thanks
>
> > On Jan 19, 8:22 pm, leo  wrote:
>
> > > I used to use MAMP. It used a non-standard port for the DB. Check
> > > which port you're using and add it as shown in the database.php
> > > comments:
>
> > >  * host =>
> > >  * the host you connect to the database.  To add a socket or port
> > > number, use 'port' => #
> > >  *
--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---

Re: baking cakephp on MAC OS

[leo]

If you're using XAMPP, I don't think it's a php/mysql config problem.
that is precisely  the problem these *AMP stacks are designed to
avoid. However, you might want to try the following. Incidentally,
that should be "Applications" PLURAL in your path.

Open a terminal, and type:

ps -af | grep mysql.sock   [enter]

The result on my machine is:

sh-3.2# ps -ef | grep mysql.sock
  74  2405  2379   0   0:15.88 ?? 1:57.74 /usr/
local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/
mysql/data --user=mysql --pid-file=/usr/local/mysql/data/
Leopard.local.pid --port=3306 --socket=/tmp/mysql.sock
0  4814  4805   0   0:00.01 ttys0000:00.01 grep mysql.sock
sh-3.2#

see the last bit? port=3306 socket=/tmp/mysql.sock
that path (/tmp/mysql.sock) is the path to MY socket (and the port is
the port!) yours will be different because mine is not an *AMP stack.

Now, in your htdocs directory create phpinfo.php with  as the sole content. Make sure there is no new line after the ?>

View the file in Safari and halfway down the first screen is the path
to the loaded configuration file. This is the one you need to edit to
configure php. Continue down the page - you'll need to scroll about
halfway down and see if there is a mysql section. If there is, I don't
think you have a problem with php.ini. If there isn't, mysql isn't
talking to PHP and you'll need to find and edit the appropriate part
of the ini file.

If I remember correctly, XAMPP already has a phpinfo link.

I don't pretend that this is a solution, but if you post the results
here, at least we'll have something to work with.

Good luck.


On Jan 19, 8:46 pm, bookme  wrote:
> Thanks for your solution...but still not working.
>
> I tried both above solution but not working.
>
> I am using xampp on MAC OS..
> ERROR :  Can't connect to local MySQL server through Socket '/var/
> mysql/mysql.sock ?
>
> I also set envornment variable using
> echo 'export PATH=Application/xampp/xamppfiles/htdocs/clalumni/cake/
> console/cake:$PATH' >> ~/.bash_profile
> echo 'export PATH=Application/xampp/xamppfiles/lib/php:$PATH' >>
> ~/.bash_profile
>
> but still not able to run cake bake?
>
> Please help me to run cake bake on MAC OS.
> Thanks
>
> On Jan 19, 8:22 pm, leo  wrote:
>
> > I used to use MAMP. It used a non-standard port for the DB. Check
> > which port you're using and add it as shown in the database.php
> > comments:
>
> >  * host =>
> >  * the host you connect to the database.  To add a socket or port
> > number, use 'port' => #
> >  *
--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---

Re: baking cakephp on MAC OS

[mark_story]

It has less to do with your path and more to do with your PHP is
knocking on a door, and nobody is home. You need to find out where
your mysql.sock is, and configure PHP to knock on that door instead.

-Mark

On Jan 19, 2:46 pm, bookme  wrote:
> Thanks for your solution...but still not working.
>
> I tried both above solution but not working.
>
> I am using xampp on MAC OS..
> ERROR :  Can't connect to local MySQL server through Socket '/var/
> mysql/mysql.sock ?
>
> I also set envornment variable using
> echo 'export PATH=Application/xampp/xamppfiles/htdocs/clalumni/cake/
> console/cake:$PATH' >> ~/.bash_profile
> echo 'export PATH=Application/xampp/xamppfiles/lib/php:$PATH' >>
> ~/.bash_profile
>
> but still not able to run cake bake?
>
> Please help me to run cake bake on MAC OS.
> Thanks
>
> On Jan 19, 8:22 pm, leo  wrote:
>
> > I used to use MAMP. It used a non-standard port for the DB. Check
> > which port you're using and add it as shown in the database.php
> > comments:
>
> >  * host =>
> >  * the host you connect to the database.  To add a socket or port
> > number, use 'port' => #
> >  *
--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---

Re: baking cakephp on MAC OS

[bookme]

Thanks for your solution...but still not working.

I tried both above solution but not working.

I am using xampp on MAC OS..
ERROR :  Can't connect to local MySQL server through Socket '/var/
mysql/mysql.sock ?

I also set envornment variable using
echo 'export PATH=Application/xampp/xamppfiles/htdocs/clalumni/cake/
console/cake:$PATH' >> ~/.bash_profile
echo 'export PATH=Application/xampp/xamppfiles/lib/php:$PATH' >>
~/.bash_profile

but still not able to run cake bake?

Please help me to run cake bake on MAC OS.
Thanks


On Jan 19, 8:22 pm, leo  wrote:
> I used to use MAMP. It used a non-standard port for the DB. Check
> which port you're using and add it as shown in the database.php
> comments:
>
>  * host =>
>  * the host you connect to the database.  To add a socket or port
> number, use 'port' => #
>  *
--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---

Re: baking cakephp on MAC OS

[leo]

I used to use MAMP. It used a non-standard port for the DB. Check
which port you're using and add it as shown in the database.php
comments:

 * host =>
 * the host you connect to the database.  To add a socket or port
number, use 'port' => #
 *
--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---

Re: baking cakephp on MAC OS

[Webweave]

Looks to me like you ran into the same problem as I did here:
http://blog.accuweaver.com/2008/12/20/moving-my-volunteercake-to-my-mac/

Basically your MySQL and PHP are not configured the same way, so you
need to change one of them so that PHP can talk to MySQL.

This is a pure PHP problem, the first line in your errors shows you
that PHP isn't connecting:

Warning: mysql_connect(): Can't connect to local MySQL server through
socket '/var/mysql/mysql.sock'

On Jan 18, 11:59 am, bookme  wrote:
> Hi,
>
> I am trying to bake cake application on MAC OS but can not get
> success.
>
> I have tried two solution but not working.
>
> 1 when I run cake bake command in app folder
>  xampp/htdocs/cakephp/app> cake bake
> it's showing cake : command not found on terminal
>
> 2 In parent directory when I run
> xampp/htdocs/cakephp > ./cake/console/cake bake
> App : app
> Path: /Application/xampp/xampfiles/htdocs/cakephp/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
>
> ---
> Model Bake:
> ---
> Database Connection:
> [default] >
> Warning: mysql_connect(): Can't connect to local MySQL server through
> socket '/var/mysql/mysql.sock' (2) in /Applications/xampp/xamppfiles/
> htdocs/cake/cake/libs/model/datasources/dbo/dbo_mysql.php on line 370
>
> Warning: mysql_select_db(): supplied argument is not a valid MySQL-
> Link resource in /Applications/xampp/xamppfiles/htdocs/cake/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/xampp/xamppfiles/htdocs/cake/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/xampp/xamppfiles/htdocs/cake/cake/libs/model/
> datasources/dbo/dbo_mysql.php on line 407
> Error: Your database does not have any tables.
>
> But My database have one table..then what's wrong here?
> can any body tell me what's wrong I am doing here?
>
> or please tell what's tseps to run cake bake on MAC OS.
>
> Thanks
--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---

baking cakephp on MAC OS

[bookme]

Hi,

I am trying to bake cake application on MAC OS but can not get
success.

I have tried two solution but not working.

1 when I run cake bake command in app folder
 xampp/htdocs/cakephp/app> cake bake
it's showing cake : command not found on terminal

2 In parent directory when I run
xampp/htdocs/cakephp > ./cake/console/cake bake
App : app
Path: /Application/xampp/xampfiles/htdocs/cakephp/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

---
Model Bake:
---
Database Connection:
[default] >
Warning: mysql_connect(): Can't connect to local MySQL server through
socket '/var/mysql/mysql.sock' (2) in /Applications/xampp/xamppfiles/
htdocs/cake/cake/libs/model/datasources/dbo/dbo_mysql.php on line 370

Warning: mysql_select_db(): supplied argument is not a valid MySQL-
Link resource in /Applications/xampp/xamppfiles/htdocs/cake/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/xampp/xamppfiles/htdocs/cake/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/xampp/xamppfiles/htdocs/cake/cake/libs/model/
datasources/dbo/dbo_mysql.php on line 407
Error: Your database does not have any tables.

But My database have one table..then what's wrong here?
can any body tell me what's wrong I am doing here?

or please tell what's tseps to run cake bake on MAC OS.

Thanks



--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---