Hello and thanks for your reply..
I tried removing the port setting as you've suggested and moved from
cake 1.3 to cake 2.0 but the result was the same!
class DATABASE_CONFIG {
public $default = array(
'datasource' => 'Database/Mysql',
'persistent' => false,
'host' => 'localhost',
'login' => 'admin',
'password' => 'secret',
'database' => 'cake',
'prefix' => '',
//'encoding' => 'utf8',
);
public $test = array(
'datasource' => 'Database/Mysql',
'persistent' => false,
'host' => 'admin',
'login' => 'root',
'password' => 'secret',
'database' => 'cakeblog',
'prefix' => '',
//'encoding' => 'utf8',
);
}
On Sat, Nov 5, 2011 at 10:03 PM, Ma'moon <phpir...@gmail.com> wrote:
> 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
>
--
GPG me!!
gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
--
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
