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 andydawso...@gmail.com: 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
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
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 andydawso...@gmail.com: 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
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 jose...@gmail.comjavascript: 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] = [_logger:protected] = ) [_type:protected] = select [_parts:protected] = Array ( [delete] = 1 [update] = Array ( ) [set] = Array ( ) [insert] = Array ( ) [values] = Array ( ) [select] = Array
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 ( ) [join] = Array ( ) [where] = [group] = Array ( ) [having] = [order] =
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 [having] = HAVING %s [order] = %s [limit] = LIMIT %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
?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
?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
h1Blog posts/h1
table
tr
thId/th
thTitle/th
thCreated/th
/tr
!-- Here is where we loop through our $posts array, printing out post
info --
?php foreach ($posts as $post): ?
tr
td?php echo $post['Post']['id']; ?/td
td
?php echo
$this-Html-link($post['Post']['title'],array('controller' = 'posts',
'action' = 'view', $post['Post']['id'])); ?
/td
td?php echo $post['Post']['created']; ?/td
/tr
?php endforeach; ?
?php unset($post); ?
/table
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.
