Most likely you need to leave the port section empty in your db
configuration
On Sat, Nov 5, 2011 at 9:55 PM, bluethundr <bluethu...@gmail.com> wrote:
> ## cake cannot connect to the databse
>
> Your tmp directory is writable.
>
> The FileEngine is being used for caching. To change the config edit
> APP/config/core.php
>
> Your database configuration file is present.
>
> Cake is NOT able to connect to the database.
>
> ## database config file
>
>
> class DATABASE_CONFIG {
>
> var $default = array(
> 'driver' => 'mysql',
> 'persistent' => false,
> 'host' => 'localhost',
> 'login' => 'admin',
> 'password' => 'secret',
> 'database' => 'cake',
> 'prefix' => '',
> 'port' => '/var/lib/mysql/mysql.sock',
> //'encoding' => 'utf8',
> );
>
> var $test = array(
> 'driver' => 'mysql',
> 'persistent' => false,
> 'host' => 'localhost',
> 'login' => 'admin',
> 'password' => 'secret',
> 'database' => 'cakeblog',
> 'prefix' => '',
> 'port' => '/var/lib/mysql/mysql.sock',
> //'encoding' => 'utf8',
> );
> }
>
>
>
> ## user can connect to (and use) database on the command line
>
>
> [root@cloud cake]# mysql -uadmin -psecret
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 2
> Server version: 5.5.17-log MySQL Community Server (GPL) by Remi
>
> Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights
> reserved.
>
> Oracle is a registered trademark of Oracle Corporation and/or its
> affiliates. Other names may be trademarks of their respective
> owners.
>
> Type 'help;' or '\h' for help. Type '\c' to clear the current input
> statement.
>
> mysql> use cake
> Database changed
>
> thank you!
>
> --
> Our newest site for the community: CakePHP Video Tutorials
> http://tv.cakephp.org
> Check out the new CakePHP Questions site http://ask.cakephp.org and help
> others with their CakePHP related questions.
>
>
> 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
>
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
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
