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