Consider the following configuration file:

<?php

return [
    'class' => 'yii\db\Connection',
    'dsn' => 'mysql:host=localhost;dbname=efinances_network',
    'username' => 'efinances_network',
    'password' => 'cÎìJY/FÂJ(ë[\ïjDZyLYúJ&=V4êÞ£½',
    'charset' => 'utf8',

    // Schema cache options (for production environment)
    //'enableSchemaCache' => true,
    //'schemaCacheDuration' => 60,
    //'schemaCache' => 'cache',
];

whereas the password has been generated by a simple

passgen | xclip -sel clip

The thing isn’t working none of the ways:

./yii gii/model --modelClass User --tableName users
Running 'Model Generator'...

Exception 'yii\db\Exception' with message 'SQLSTATE[HY000] [1045] Access denied for user 'efinances_network'@'localhost' (using password: YES)'

in /home/povilasbrilius/.atom-projects/e-finances.network/vendor/yiisoft/yii2/db/Connection.php:649

Error Info:
Array
(
    [0] => HY000
    [1] => 1045
    [2] => Access denied for user 'efinances_network'@'localhost' (using password: YES)
)

Caused by: Exception 'PDOException' with message 'SQLSTATE[HY000] [1045] Access denied for user 'efinances_network'@'localhost' (using password: YES)'

in /home/povilasbrilius/.atom-projects/e-finances.network/vendor/yiisoft/yii2/db/Connection.php:719

Stack trace:
#0 /home/povilasbrilius/.atom-projects/e-finances.network/vendor/yiisoft/yii2/db/Connection.php(719): PDO->__construct('mysql:host=loca...', 'efinances_netwo...', 'c\xC3\x8E\xC3\xACJY/F\xC3\x82J(\xC3\xAB...', NULL)
#1 /home/povilasbrilius/.atom-projects/e-finances.network/vendor/yiisoft/yii2/db/Connection.php(638): yii\db\Connection->createPdoInstance()
#2 /home/povilasbrilius/.atom-projects/e-finances.network/vendor/yiisoft/yii2/db/Connection.php(1059): yii\db\Connection->open()
#3 /home/povilasbrilius/.atom-projects/e-finances.network/vendor/yiisoft/yii2/db/Connection.php(1046): yii\db\Connection->getMasterPdo()
#4 /home/povilasbrilius/.atom-projects/e-finances.network/vendor/yiisoft/yii2/db/Command.php(261): yii\db\Connection->getSlavePdo()
#5 /home/povilasbrilius/.atom-projects/e-finances.network/vendor/yiisoft/yii2/db/Command.php(1163): yii\db\Command->prepare(true)
#6 /home/povilasbrilius/.atom-projects/e-finances.network/vendor/yiisoft/yii2/db/Command.php(410): yii\db\Command->queryInternal('fetchAll', NULL)
#7 /home/povilasbrilius/.atom-projects/e-finances.network/vendor/yiisoft/yii2/db/mysql/Schema.php(319): yii\db\Command->queryAll()
#8 /home/povilasbrilius/.atom-projects/e-finances.network/vendor/yiisoft/yii2/db/mysql/Schema.php(125): yii\db\mysql\Schema->findColumns(Object(yii\db\TableSchema))
#9 /home/povilasbrilius/.atom-projects/e-finances.network/vendor/yiisoft/yii2/db/Schema.php(758): yii\db\mysql\Schema->loadTableSchema('users')
#10 /home/povilasbrilius/.atom-projects/e-finances.network/vendor/yiisoft/yii2/db/Schema.php(194): yii\db\Schema->getTableMetadata('users', 'schema', true)
#11 /home/povilasbrilius/.atom-projects/e-finances.network/vendor/yiisoft/yii2/db/Connection.php(915): yii\db\Schema->getTableSchema('users', true)
#12 /home/povilasbrilius/.atom-projects/e-finances.network/vendor/yiisoft/yii2-gii/src/generators/model/Generator.php(893): yii\db\Connection->getTableSchema('users', true)
#13 /home/povilasbrilius/.atom-projects/e-finances.network/vendor/yiisoft/yii2-gii/src/generators/model/Generator.php(849): yii\gii\generators\model\Generator->getTableNames()
#14 /home/povilasbrilius/.atom-projects/e-finances.network/vendor/yiisoft/yii2/validators/InlineValidator.php(84): yii\gii\generators\model\Generator->validateTableName('tableName', NULL, Object(yii\validators\InlineValidator), 'users')
#15 /home/povilasbrilius/.atom-projects/e-finances.network/vendor/yiisoft/yii2/validators/Validator.php(261): yii\validators\InlineValidator->validateAttribute(Object(yii\gii\generators\model\Generator), 'tableName')
#16 /home/povilasbrilius/.atom-projects/e-finances.network/vendor/yiisoft/yii2/base/Model.php(368): yii\validators\Validator->validateAttributes(Object(yii\gii\generators\model\Generator), Array)
#17 /home/povilasbrilius/.atom-projects/e-finances.network/vendor/yiisoft/yii2-gii/src/console/GenerateAction.php(35): yii\base\Model->validate()
#18 [internal function]: yii\gii\console\GenerateAction->run()
#19 /home/povilasbrilius/.atom-projects/e-finances.network/vendor/yiisoft/yii2/base/Action.php(94): call_user_func_array(Array, Array)
#20 /home/povilasbrilius/.atom-projects/e-finances.network/vendor/yiisoft/yii2/base/Controller.php(181): yii\base\Action->runWithParams(Array)
#21 /home/povilasbrilius/.atom-projects/e-finances.network/vendor/yiisoft/yii2/console/Controller.php(184): yii\base\Controller->runAction('model', Array)
#22 /home/povilasbrilius/.atom-projects/e-finances.network/vendor/yiisoft/yii2/base/Module.php(534): yii\console\Controller->runAction('model', Array)
#23 /home/povilasbrilius/.atom-projects/e-finances.network/vendor/yiisoft/yii2/console/Application.php(181): yii\base\Module->runAction('gii/model', Array)
#24 /home/povilasbrilius/.atom-projects/e-finances.network/vendor/yiisoft/yii2/console/Application.php(148): yii\console\Application->runAction('gii/model', Array)
#25 /home/povilasbrilius/.atom-projects/e-finances.network/vendor/yiisoft/yii2/base/Application.php(392): yii\console\Application->handleRequest(Object(yii\console\Request))
#26 /home/povilasbrilius/.atom-projects/e-finances.network/yii(20): yii\base\Application->run()
#27 {main}
mysql -u efinances_network -p efinances_network
Found existing alias for "mysql". You should use: "my"
Enter password: 
ERROR 1045 (28000): Access denied for user 'efinances_network'@'localhost' (using password: YES)
College graduates forfeit – prom
Photo by ThisisEngineering RAEng on Unsplash

2 comments on “Yii stage – forfeited; Sony Xperia XZ Premium

%d bloggers like this: