Re: 3.0 - Cake not connecting to MySql DB

2014-05-19 Thread Md Bayezid Alam
Thanks a lot everyone, somehow it is working for me..


On Sun, Mar 16, 2014 at 9:38 PM, Leandro Machado Pereira <
llperei...@gmail.com> wrote:

> The error composer timeout, see this:
>
> https://getcomposer.org/doc/04-schema.md#config
>
> http://www.papayasoft.com/2013/08/22/composer-process-timeout-when-fetching-large-repositories/
> Try use *COMPOSER_PROCESS_TIMEOUT=2000 php composer.phar install*
>
>
> 2014-03-16 6:38 GMT-03:00 AD7six :
>
> This doens't look to be CakePHP (version 3 or otherwise) specific.
>>
>>
>> On Saturday, 15 March 2014 17:33:10 UTC+1, Bayezid Alam wrote:
>>>
>>> Hi Jose,
>>>
>>> I did a fresh installation with two ways stated below:
>>>
>>> *From the composer, Do you want to remove the existing VCS (.gif,
>>> .svn..) history? [Y, n]? *with Y and n
>>>
>>> 1st way: For Y, i am getting Vendor's cakephp folder blank after
>>> installation and getting "localhost/cake3" nothing
>>>
>>
>> As shown by the screenshot - the download of cakephp timed out.
>>
>> That's not "Y" specific, not cake3 specific, not cakephp specific, and
>> not even composer specific =). Github or your connection to it was
>> temporarily borken when trying to download cakephp.
>>
>>
>>>
>>> 2nd Way: For n, i am getting vendor's cakephp folder with src & tests
>>> folder after installation which is working good with "localhost/testcake3"
>>> but after a few hours i am getting vendor's cakephp folder blank and
>>> nothing working for "localhost/testcake3" showing blank.
>>>
>>
>> I doubt it =) the screenshot shows the same timeout error.
>>
>> AD
>>
>> --
>> 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.
>>
>
>
>
> --
>
>
> http://leandrompereira.com.br
>
> ***Se você pretende redirecionar este e-mail, por favor, apague todos os
> endereços que aparecem nele. Outra dica de segurança é endereçá-lo no Cco.
> Desta forma você estará protegendo a mim, seus amigos e a você mesmo. Eu e
> a Campanha Contra o SPAM agradecemos.Não envie correntes.***
>
> --
> 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.
>

-- 
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: 3.0 - Cake not connecting to MySql DB

2014-03-16 Thread Leandro Machado Pereira
The error composer timeout, see this:

https://getcomposer.org/doc/04-schema.md#config
http://www.papayasoft.com/2013/08/22/composer-process-timeout-when-fetching-large-repositories/
Try use *COMPOSER_PROCESS_TIMEOUT=2000 php composer.phar install*


2014-03-16 6:38 GMT-03:00 AD7six :

> This doens't look to be CakePHP (version 3 or otherwise) specific.
>
>
> On Saturday, 15 March 2014 17:33:10 UTC+1, Bayezid Alam wrote:
>>
>> Hi Jose,
>>
>> I did a fresh installation with two ways stated below:
>>
>> *From the composer, Do you want to remove the existing VCS (.gif, .svn..)
>> history? [Y, n]? *with Y and n
>>
>> 1st way: For Y, i am getting Vendor's cakephp folder blank after
>> installation and getting "localhost/cake3" nothing
>>
>
> As shown by the screenshot - the download of cakephp timed out.
>
> That's not "Y" specific, not cake3 specific, not cakephp specific, and not
> even composer specific =). Github or your connection to it was temporarily
> borken when trying to download cakephp.
>
>
>>
>> 2nd Way: For n, i am getting vendor's cakephp folder with src & tests
>> folder after installation which is working good with "localhost/testcake3"
>> but after a few hours i am getting vendor's cakephp folder blank and
>> nothing working for "localhost/testcake3" showing blank.
>>
>
> I doubt it =) the screenshot shows the same timeout error.
>
> AD
>
> --
> 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.
>



-- 


http://leandrompereira.com.br

***Se você pretende redirecionar este e-mail, por favor, apague todos os
endereços que aparecem nele. Outra dica de segurança é endereçá-lo no Cco.
Desta forma você estará protegendo a mim, seus amigos e a você mesmo. Eu e
a Campanha Contra o SPAM agradecemos.Não envie correntes.***

-- 
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: 3.0 - Cake not connecting to MySql DB

2014-03-16 Thread AD7six
This doens't look to be CakePHP (version 3 or otherwise) specific.

On Saturday, 15 March 2014 17:33:10 UTC+1, Bayezid Alam wrote:
>
> Hi Jose,
>
> I did a fresh installation with two ways stated below:
>
> *From the composer, Do you want to remove the existing VCS (.gif, .svn..) 
> history? [Y, n]? *with Y and n
>
> 1st way: For Y, i am getting Vendor's cakephp folder blank after 
> installation and getting "localhost/cake3" nothing
>

As shown by the screenshot - the download of cakephp timed out.

That's not "Y" specific, not cake3 specific, not cakephp specific, and not 
even composer specific =). Github or your connection to it was temporarily 
borken when trying to download cakephp.
 

>
> 2nd Way: For n, i am getting vendor's cakephp folder with src & tests 
> folder after installation which is working good with "localhost/testcake3" 
> but after a few hours i am getting vendor's cakephp folder blank and 
> nothing working for "localhost/testcake3" showing blank.
>

I doubt it =) the screenshot shows the same timeout error.

AD

-- 
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: 3.0 - Cake not connecting to MySql DB

2014-03-14 Thread José Lorenzo
Oh, that looks bad. Maybe try doing a fresh install again

On Friday, March 14, 2014 6:34:48 PM UTC+1, Bayezid Alam wrote:
>
> Thanks for your suggestion 
>
> Trust me it was not work for me but working after releasing dev2 and 
> getting vendor's cakephp folder blank after a day of installation ( see the 
> attachment)
>
>
>
> On Wed, Mar 5, 2014 at 9:35 PM, José Lorenzo 
> > wrote:
>
>> What is not working exactly? What is the error? I suggest you read the 
>> complete 3.0 ORM manual before going further, it will hopefully answer the 
>> questions you have about it.
>>
>>
>> On Tuesday, March 4, 2014 7:06:13 PM UTC+1, Bayezid Alam wrote:
>>
>>>
>>> after updating, Its not working, i may missing anything.
>>>
>>> 'Datasources' => [
>>> 'default' => [
>>>  'className' => 'Cake\Database\Connection',
>>> 'driver' => 'Cake\Database\Driver\Mysql',
>>>  'persistent' => false,
>>> 'host' => 'localhost',
>>> 'login' => 'loginname',
>>>  'password' => 'password',
>>> 'database' => 'cake3_db',
>>> 'prefix' => false,
>>>  'encoding' => 'utf8',
>>> ],
>>>
>>> /**
>>>  * The test connection is used during the test suite.
>>>  */
>>> 'test' => [
>>>  'className' => 'Cake\Database\Connection',
>>> 'driver' => 'Cake\Database\Driver\Mysql',
>>>  'persistent' => false,
>>> 'host' => 'localhost',
>>> 'login' => 'my_app',
>>>  'password' => 'secret',
>>> 'database' => 'test_myapp',
>>> 'prefix' => false,
>>>  'encoding' => 'utf8',
>>> ],
>>> ],
>>>
>>>
>>> *after executing pr(), getting below msg*
>>>
>>> Cake\ORM\Query Object
>>> (
>>> [_hasFields:protected] => 
>>> [_useBufferedResults:protected] => 1
>>> [_hydrate:protected] => 1
>>> [_counter:protected] => 
>>> [_eagerLoader:protected] => 
>>> [_connection:protected] => Cake\Database\Connection Object
>>> (
>>> [_config:protected] => Array
>>> (
>>> [driver] => Cake\Database\Driver\Mysql
>>> [persistent] => 
>>> [host] => localhost
>>> [login] => loginname
>>> [password] => password
>>> [database] => cake3_db
>>> [prefix] => 
>>> [encoding] => utf8
>>> [name] => default
>>> )
>>>
>>> [_driver:protected] => Cake\Database\Driver\Mysql Object
>>> (
>>> [_baseConfig:protected] => Array
>>> (
>>> [persistent] => 1
>>> [host] => localhost
>>> [login] => loginname
>>> [password] => 
>>> [database] => cake
>>> [port] => 3306
>>> [flags] => Array
>>> (
>>> )
>>>
>>> [encoding] => utf8
>>> [timezone] => 
>>> [init] => Array
>>> (
>>> )
>>>
>>> [dsn] => 
>>> )
>>>
>>> [_config:protected] => Array
>>> (
>>> [driver] => Cake\Database\Driver\Mysql
>>> [persistent] => 
>>> [host] => localhost
>>> [login] => loginname
>>> [password] => password
>>> [database] => cake3_db
>>> [prefix] => 
>>> [encoding] => utf8
>>> [name] => default
>>> [port] => 3306
>>> [flags] => Array
>>> (
>>> )
>>>
>>> [timezone] => 
>>> [init] => Array
>>> (
>>> )
>>>
>>> [dsn] => 
>>> )
>>>
>>> [_autoQuoting:protected] => 
>>> [_startQuote:protected] => `
>>> [_endQuote:protected] => `
>>> [_schemaDialect:protected] => 
>>> Cake\Database\Schema\MysqlSchema Object
>>> (
>>> [_driver:protected] => 
>>> Cake\Database\Driver\Mysql Object
>>>  *RECURSION*
>>> )
>>>
>>> [_connection:protected] => PDO Object
>>> (
>>> )
>>>
>>> )
>>>
>>> [_transactionLevel:protected] => 0
>>> [_transactionStarted:protected] => 
>>> [_useSavePoints:protected] => 
>>> [_logQueries:protected] => 
>>>

Re: 3.0 - Cake not connecting to MySql DB

2014-03-05 Thread José Lorenzo
What is not working exactly? What is the error? I suggest you read the 
complete 3.0 ORM manual before going further, it will hopefully answer the 
questions you have about it.

On Tuesday, March 4, 2014 7:06:13 PM UTC+1, Bayezid Alam wrote:
>
>
> after updating, Its not working, i may missing anything.
>
> 'Datasources' => [
> 'default' => [
>  'className' => 'Cake\Database\Connection',
> 'driver' => 'Cake\Database\Driver\Mysql',
>  'persistent' => false,
> 'host' => 'localhost',
> 'login' => 'loginname',
>  'password' => 'password',
> 'database' => 'cake3_db',
> 'prefix' => false,
>  'encoding' => 'utf8',
> ],
>
> /**
>  * The test connection is used during the test suite.
>  */
> 'test' => [
>  'className' => 'Cake\Database\Connection',
> 'driver' => 'Cake\Database\Driver\Mysql',
>  'persistent' => false,
> 'host' => 'localhost',
> 'login' => 'my_app',
>  'password' => 'secret',
> 'database' => 'test_myapp',
> 'prefix' => false,
>  'encoding' => 'utf8',
> ],
> ],
>
>
> *after executing pr(), getting below msg*
>
> Cake\ORM\Query Object
> (
> [_hasFields:protected] => 
> [_useBufferedResults:protected] => 1
> [_hydrate:protected] => 1
> [_counter:protected] => 
> [_eagerLoader:protected] => 
> [_connection:protected] => Cake\Database\Connection Object
> (
> [_config:protected] => Array
> (
> [driver] => Cake\Database\Driver\Mysql
> [persistent] => 
> [host] => localhost
> [login] => loginname
> [password] => password
> [database] => cake3_db
> [prefix] => 
> [encoding] => utf8
> [name] => default
> )
>
> [_driver:protected] => Cake\Database\Driver\Mysql Object
> (
> [_baseConfig:protected] => Array
> (
> [persistent] => 1
> [host] => localhost
> [login] => loginname
> [password] => 
> [database] => cake
> [port] => 3306
> [flags] => Array
> (
> )
>
> [encoding] => utf8
> [timezone] => 
> [init] => Array
> (
> )
>
> [dsn] => 
> )
>
> [_config:protected] => Array
> (
> [driver] => Cake\Database\Driver\Mysql
> [persistent] => 
> [host] => localhost
> [login] => loginname
> [password] => password
> [database] => cake3_db
> [prefix] => 
> [encoding] => utf8
> [name] => default
> [port] => 3306
> [flags] => Array
> (
> )
>
> [timezone] => 
> [init] => Array
> (
> )
>
> [dsn] => 
> )
>
> [_autoQuoting:protected] => 
> [_startQuote:protected] => `
> [_endQuote:protected] => `
> [_schemaDialect:protected] => 
> Cake\Database\Schema\MysqlSchema Object
> (
> [_driver:protected] => Cake\Database\Driver\Mysql 
> Object
>  *RECURSION*
> )
>
> [_connection:protected] => PDO Object
> (
> )
>
> )
>
> [_transactionLevel:protected] => 0
> [_transactionStarted:protected] => 
> [_useSavePoints:protected] => 
> [_logQueries:protected] => 
> [_logger:protected] => 
> )
>
> [_type:protected] => select
> [_parts:protected] => Array
> (
> [delete] => 1
> [update] => Array
> (
> )
>
> [set] => Array
> (
> )
>
> [insert] => Array
> (
> )
>
> [values] => Array
> (
> )
>
> [select] => Array
> (
> )
>
> [distinct] => 
> [modifier] => Array
> (
> )
>
> [from] => Array
> 

Re: 3.0 - Cake not connecting to MySql DB

2014-03-04 Thread Md Bayezid Alam
after updating, Its not working, i may missing anything.

'Datasources' => [
'default' => [
'className' => 'Cake\Database\Connection',
'driver' => 'Cake\Database\Driver\Mysql',
'persistent' => false,
'host' => 'localhost',
'login' => 'loginname',
'password' => 'password',
'database' => 'cake3_db',
'prefix' => false,
'encoding' => 'utf8',
],

/**
 * The test connection is used during the test suite.
 */
'test' => [
'className' => 'Cake\Database\Connection',
'driver' => 'Cake\Database\Driver\Mysql',
'persistent' => false,
'host' => 'localhost',
'login' => 'my_app',
'password' => 'secret',
'database' => 'test_myapp',
'prefix' => false,
'encoding' => 'utf8',
],
],


*after executing pr(), getting below msg*

Cake\ORM\Query Object
(
[_hasFields:protected] =>
[_useBufferedResults:protected] => 1
[_hydrate:protected] => 1
[_counter:protected] =>
[_eagerLoader:protected] =>
[_connection:protected] => Cake\Database\Connection Object
(
[_config:protected] => Array
(
[driver] => Cake\Database\Driver\Mysql
[persistent] =>
[host] => localhost
[login] => loginname
[password] => password
[database] => cake3_db
[prefix] =>
[encoding] => utf8
[name] => default
)

[_driver:protected] => Cake\Database\Driver\Mysql Object
(
[_baseConfig:protected] => Array
(
[persistent] => 1
[host] => localhost
[login] => loginname
[password] =>
[database] => cake
[port] => 3306
[flags] => Array
(
)

[encoding] => utf8
[timezone] =>
[init] => Array
(
)

[dsn] =>
)

[_config:protected] => Array
(
[driver] => Cake\Database\Driver\Mysql
[persistent] =>
[host] => localhost
[login] => loginname
[password] => password
[database] => cake3_db
[prefix] =>
[encoding] => utf8
[name] => default
[port] => 3306
[flags] => Array
(
)

[timezone] =>
[init] => Array
(
)

[dsn] =>
)

[_autoQuoting:protected] =>
[_startQuote:protected] => `
[_endQuote:protected] => `
[_schemaDialect:protected] =>
Cake\Database\Schema\MysqlSchema Object
(
[_driver:protected] =>
Cake\Database\Driver\Mysql Object
 *RECURSION*
)

[_connection:protected] => PDO Object
(
)

)

[_transactionLevel:protected] => 0
[_transactionStarted:protected] =>
[_useSavePoints:protected] =>
[_logQueries:protected] =>
[_logger:protected] =>
)

[_type:protected] => select
[_parts:protected] => Array
(
[delete] => 1
[update] => Array
(
)

[set] => Array
(
)

[insert] => Array
(
)

[values] => Array
(
)

[select] => Array
(
)

[distinct] =>
[modifier] => Array
(
)

[from] => Array
(
)

[join] => Array
(
)

[where] =>
[group] => Array
(
)

[having] =>
[order] =>
[limit] =>
[offset] =>
[union] => Array
(
)

[epilog] =>
)

[_templates:protected] => Array
(
[delete] => DELETE
[update] => UPDATE %s
[where] =>  WHERE %s
[group] =>  GROUP BY %s
  

Re: 3.0 - Cake not connecting to MySql DB

2014-03-03 Thread José Lorenzo
You need to update your app template, specifically your app.php file as the 
arguments for configuring a database connection recently changed:

https://github.com/cakephp/app/blob/master/App/Config/app.default.php#L212


On Monday, March 3, 2014 4:49:53 PM UTC+1, Bayezid Alam wrote:
>
> Dears,
>
> DB Connection in Cake3
>
> Located at /var/www/cake3/App/Config/app.php
> /**
>  * Connection information used by the ORM to connect
>  * to your application's datastores.
>  */
> 'Datasources' => [
> 'default' => [
>  'className' => 'Cake\\Database\\Driver\\Mysql',
> 'persistent' => false,
>  'host' => 'localhost',
> 'login' => *'loginName*',
> 'password' => '*PassWord*',
>  'database' => '*DatabaseName*',
> 'prefix' => false,
> 'encoding' => 'utf8',
>  ],
>
> /**
>  * The test connection is used during the test suite.
>  */
> 'test' => [
> 'className' => 'Cake\\Database\\Driver\\Mysql',
>  'persistent' => false,
> 'host' => 'localhost',
> 'login' => 'my_app',
>  'password' => 'secret',
> 'database' => 'test_myapp',
> 'prefix' => false,
>  'encoding' => 'utf8',
> ],
> ],
>
> My Controller located at /var/www/cake3/App/Controller/PostsController.php
> 
> /*
>  * To change this template, choose Tools | Templates
>  * and open the template in the editor.
>  */
>
> namespace App\Controller;
>
> use Cake\ORM\TableRegistry;
>
> class PostsController extends AppController{
> public $helpers = array('Html', 'Form');
> 
> public function index(){
>
> $posts = TableRegistry::get('Posts');
> 
> $posts = $posts->find();
> 
> 
> $this->set('posts', $posts);
> }
> }
> ?>
>
> My Table located at /var/www/cake3/App/Model/Table/PostsTable.php
>
> 
> /*
>  * To change this template, choose Tools | Templates
>  * and open the template in the editor.
>  */
>
> namespace App\Model\Table;
>
> use Cake\ORM\Table;
>
> class PostsTable extends Table{
> public function initialize(array $config){
> $this->table('posts');
> }
> 
> }
> ?>
>
>
> View located at /var/www/cake3/App/Template/Posts/index.ctp
>
> Blog posts
> 
> 
> Id
> Title
> Created
> 
>
> 
> 
> 
> 
> 
>  $this->Html->link($post['Post']['title'],array('controller' => 'posts', 
> 'action' => 'view', $post['Post']['id'])); ?>
> 
> 
> 
> 
> 
> 
>
>
> It's showing only Header names, not bringing any data from Database. i 
> Have three more records on database.
>
> Please help me, am i missing any thing or not?
>
>
>

-- 
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/groups/opt_out.