Issue on baking process on linux (terminal)


#1

Hi
please help me…
i am a beginner with cakephp3,
i am facing issue with bake in cakephp 3 on linux , i have following issue at the time of enter following line on terminal (linux) " bin/cake bake all users "

mysystems:/opt/lampp/htdocs/myapps$ bin/cake bake all users

i have getting following error message on terminal (linux)

Welcome to CakePHP v3.3.15 Console
App : src
Path: /opt/lampp/htdocs/myapps/src/
PHP : 5.5.9-1ubuntu4.21
Bake All

One moment while associations are detected.
Exception: SQLSTATE[28000] [1045] Access denied for user ‘root’@‘localhost’ (using password: NO) in [/opt/lampp/htdocs/myapps/vendor/cakephp/cakephp/src/Database/Driver/PDODriverTrait.php, line 48]
2017-04-03 12:33:07 Error: [PDOException] SQLSTATE[28000] [1045] Access denied for user ‘root’@‘localhost’ (using password: NO)
Stack Trace:
#0 /opt/lampp/htdocs/myapps/vendor/cakephp/cakephp/src/Database/Driver/PDODriverTrait.php(48): PDO->__construct(‘mysql:host=loca…’, ‘root’, ‘’, Array)
#1 /opt/lampp/htdocs/myapps/vendor/cakephp/cakephp/src/Database/Driver/Mysql.php(104): Cake\Database\Driver\Mysql->_connect(‘mysql:host=loca…’, Array)
#2 /opt/lampp/htdocs/myapps/vendor/cakephp/cakephp/src/Database/Schema/BaseSchema.php(45): Cake\Database\Driver\Mysql->connect()
#3 /opt/lampp/htdocs/myapps/vendor/cakephp/cakephp/src/Database/Dialect/MysqlDialectTrait.php(63): Cake\Database\Schema\BaseSchema->__construct(Object(Cake\Database\Driver\Mysql))
#4 /opt/lampp/htdocs/myapps/vendor/cakephp/cakephp/src/Database/Schema/Collection.php(52): Cake\Database\Driver\Mysql->schemaDialect()
#5 /opt/lampp/htdocs/myapps/vendor/cakephp/cakephp/src/Database/Schema/CachedCollection.php(42): Cake\Database\Schema\Collection->__construct(Object(Cake\Database\Connection))
#6 /opt/lampp/htdocs/myapps/vendor/cakephp/cakephp/src/Database/Connection.php(322): Cake\Database\Schema\CachedCollection->__construct(Object(Cake\Database\Connection), true)
#7 /opt/lampp/htdocs/myapps/vendor/cakephp/bake/src/Shell/Task/ModelTask.php(951): Cake\Database\Connection->schemaCollection()
#8 /opt/lampp/htdocs/myapps/vendor/cakephp/bake/src/Shell/Task/ModelTask.php(903): Bake\Shell\Task\ModelTask->_getAllTables()
#9 /opt/lampp/htdocs/myapps/vendor/cakephp/bake/src/Shell/Task/ModelTask.php(207): Bake\Shell\Task\ModelTask->listAll()
#10 /opt/lampp/htdocs/myapps/vendor/cakephp/bake/src/Shell/Task/ModelTask.php(127): Bake\Shell\Task\ModelTask->getAssociations(Object(Cake\ORM\Table))
#11 /opt/lampp/htdocs/myapps/vendor/cakephp/bake/src/Shell/Task/ModelTask.php(110): Bake\Shell\Task\ModelTask->getTableContext(Object(Cake\ORM\Table), ‘users’, ‘Users’)
#12 /opt/lampp/htdocs/myapps/vendor/cakephp/bake/src/Shell/Task/ModelTask.php(97): Bake\Shell\Task\ModelTask->bake(‘Users’)
#13 /opt/lampp/htdocs/myapps/vendor/cakephp/bake/src/Shell/BakeShell.php(257): Bake\Shell\Task\ModelTask->main(‘Users’)
#14 /opt/lampp/htdocs/myapps/vendor/cakephp/cakephp/src/Collection/CollectionTrait.php(52): Bake\Shell\BakeShell->Bake\Shell{closure}(‘users’, 0)
#15 /opt/lampp/htdocs/myapps/vendor/cakephp/bake/src/Shell/BakeShell.php(260): Cake\Collection\Collection->each(Object(Closure))
#16 [internal function]: Bake\Shell\BakeShell->all(‘users’)
#17 /opt/lampp/htdocs/myapps/vendor/cakephp/cakephp/src/Console/Shell.php(458): call_user_func_array(Array, Array)
#18 /opt/lampp/htdocs/myapps/vendor/cakephp/cakephp/src/Console/ShellDispatcher.php(227): Cake\Console\Shell->runCommand(Array, true, Array)
#19 /opt/lampp/htdocs/myapps/vendor/cakephp/cakephp/src/Console/ShellDispatcher.php(182): Cake\Console\ShellDispatcher->_dispatch(Array)
#20 /opt/lampp/htdocs/myapps/vendor/cakephp/cakephp/src/Console/ShellDispatcher.php(128): Cake\Console\ShellDispatcher->dispatch(Array)
#21 /opt/lampp/htdocs/myapps/bin/cake.php(34): Cake\Console\ShellDispatcher::run(Array)
#22 {main}

Thank you


#2

Try bin/cake server and see the output, probably you haven’t configured Datasources properly in app.php.


#3

thank for your feedback Gaurav,

but i have configured my database inside my folder structure
which is look like this
lampp/htdocs/myapps/config/app.php

app.php -

‘Datasources’ => [
‘default’ => [
‘className’ => ‘Cake\Database\Connection’,
‘driver’ => ‘Cake\Database\Driver\Mysql’,
‘persistent’ => false,
‘host’ => ‘localhost’,
/**
* CakePHP will use the default DB port based on the driver selected
* MySQL on MAMP uses port 8889, MAMP users will want to uncomment
* the following line and set the port accordingly
*/
//‘port’ => ‘non_standard_port_number’,
‘username’ => ‘root’,
‘password’ => ‘’,
‘database’ => ‘cake_php’,
‘encoding’ => ‘utf8’,
‘timezone’ => ‘UTC’,
‘flags’ => [],
‘cacheMetadata’ => true,
‘log’ => false,

thank you


#4

I have not much idea about LAMP apllication but try to connect MySQL from terminal using mysql -u root -p and see what you get if you are able to login without any password then you have check your LAMP.


#5

Hi Gaurav, thank you for reply

i did as per your guidance in terminal and i have getting following message “using without password”

ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)
autoartsolutions1@autoartsolutions1:~$

thank you


#6

This means i am not able to login without password


#7

So this means you have the wrong configuration in app.php. If you remember the MySQL password then set it or re-install MySQL.


#8

ok thank you i will try…!


#9

Hi ,
I m facing issue last night as below.

Argument 1 passed to Cake\ORM\Table::save() must implement interface Cake\Datasource\EntityInterface, array given, called in /opt/lampp/htdocs/billingcake/src/Controller/BillsController.php on line 48

My code is,

<?php namespace App\Controller; use App\Controller\AppController; use Cake\ORM\Table; use Cake\Event\Event; use Cake\ORM\Query; use Cake\ORM\TableRegistry; use Cake\Routing\Router; use App\Model\Entity\Role; use Cake\Datasource\ConnectionManager; use Cake\View\Helper\HtmlHelper; use Cake\View\View; use Cake\Core\Configure; use Cake\Network\Exception\ForbiddenException; use Cake\Network\Exception\NotFoundException; use Cake\View\Exception\MissingTemplateException; use Cake\Collection\Collection; use Faker; class BillsController extends AppController { public function initialize() { parent::initialize(); $this->loadComponent('RequestHandler'); } public function index(){ $bill = $this->Bills->newEntity(); if ($this->request->is('post')) { $bill = $this->Bills->patchEntity($bill, $this->request->data); $bill = $this->request->data('product_id'); $products = TableRegistry::get('Products'); $query = $products->find('list'); $bill = $query->toArray(); if ($this->Bills->save($bill)) { $this->Flash->success(__('The billNo has been saved.')); return $this->redirect(['action' => 'index']); } $this->Flash->error(__('The billNo could not be saved. Please, try again.')); } $this->set(compact('bill')); $this->set('_serialize', ['bill']); } } ?>


#10

Try to understand this part, you are doing wrong over here. Btw the original issue is different from yours so create a new one that will be a good idea.


#11

Thanx for your reply,

I want to achieve from one table record insert into another table (db). I have created one field for product name and i want to get the product_id of particular product.
I want matched the inserted product name which is equal to matched the product like as below

$_POST[‘productname’] = $productname;

$sel_query = "SELECT * FROM PRODUCT_TABLE WHRER producname=$productname ";
$sql_query = mysqli_query($conn,$sel_query);
$row = mysqli_fetch_assoc($sql_query);
$product_id = $row[‘ID’];

Sir, I want to make a above php code into cakephp 3 code…
so how can i achieve this plz help me.


#12

Sorry, but this doesn’t make any sense to me. If you are trying to set any field to any entity just use that in object format something like $bill->product_id = $productId.


#13

Hi,

How to upload my cakephp3.4 project on online server using file zila ?Please help me sir


#14

Please go to the Larry Page. Also If you are asking some question which is not related to the current issue, then create a new issue don’t start with some random topics.
Join the channels for easy or quick questions. Btw what you are asking is not an issue!