search

tastyigniter / TastyIgniter

:fire: Powerful, yet easy to use, open-source online ordering, table reservation and management system for restaurants
https://tastyigniter.com
MIT License
3.03k stars 990 forks source link

Tastyigniter 3.0.6 CLI install throws SQLSTATE[HY000] [1045] error #829

Closed prbt2016 closed 3 years ago

prbt2016 commented 3 years ago

Version: 3.0.6

Additional Information: O.S - Centos Linux 6.9 Final Web server - Apache/2.2.34 Database server - MYSQL 5.7.33 PHP Version - 7.3.28

Reproduce steps:

I was in the process of installation of TastyIgniter 3.0.6 version via CLI using the following steps mentioned in official documentation:

https://tastyigniter.com/docs/master/installation#command-line-installation

1) composer create-project tastyigniter/tastyigniter /{{PATH}}/{{TO}}/{{TastyIgniter}}

2) php artisan igniter:install

However after entering the correct database details and admin details on the CLI prompts I get the following error i.e : 

Migrating application and extensions...

In Connection.php line 669:

  SQLSTATE[HY000] [1045] Access denied for user 'forge'@'localhost' (using pa
  ssword: NO) (SQL: select column_name as `column_name` from information_sche
  ma.columns where table_schema = forge and table_name = ti_migrations)

In Exception.php line 18:

  SQLSTATE[HY000] [1045] Access denied for user 'forge'@'localhost' (using pa
  ssword: NO)

In PDOConnection.php line 39:

  SQLSTATE[HY000] [1045] Access denied for user 'forge'@'localhost' (using pa
  ssword: NO)

error

Also I checked that the .env file is populated with correct details.

Following is the output of /storage/logs/system.log : 

[2021-07-29 10:07:23] production.ERROR: PDOException: SQLSTATE[HY000] [1045] Access denied for user 'forge'@'localhost' (using password: NO) in /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:39
Stack trace:
#0 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(39): PDO->__construct('mysql:host=127....', 'forge', '', Array)
#1 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(67): Doctrine\DBAL\Driver\PDOConnection->__construct('mysql:host=127....', 'forge', '', Array)
#2 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(46): Illuminate\Database\Connectors\Connector->createPdoConnection('mysql:host=127....', 'forge', '', Array)
#3 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection('mysql:host=127....', Array, Array)
#4 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(182): Illuminate\Database\Connectors\MySqlConnector->connect(Array)
#5 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors\{closure}()
#6 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(924): call_user_func(Object(Closure))
#7 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(959): Illuminate\Database\Connection->getPdo()
#8 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(404): Illuminate\Database\Connection->getReadPdo()
#9 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(330): Illuminate\Database\Connection->getPdoForSelect(true)
#10 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(662): Illuminate\Database\Connection->Illuminate\Database\{closure}('select column_n...', Array)
#11 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(629): Illuminate\Database\Connection->runQueryCallback('select column_n...', Array, Object(Closure))
#12 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\Database\Connection->run('select column_n...', Array, Object(Closure))
#13 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Schema/MySqlBuilder.php(33): Illuminate\Database\Connection->select('select column_n...', Array)
#14 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(102): Illuminate\Database\Schema\MySqlBuilder->getColumnListing('ti_migrations')
#15 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\Database\Schema\Builder->hasColumns('migrations', Array)
#16 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/app/system/classes/UpdateManager.php(193): Illuminate\Support\Facades\Facade::__callStatic('hasColumns', Array)
#17 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/app/system/classes/UpdateManager.php(155): System\Classes\UpdateManager->prepareDatabase()
#18 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/app/system/console/commands/IgniterInstall.php(132): System\Classes\UpdateManager->update()
#19 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/app/system/console/commands/IgniterInstall.php(78): System\Console\Commands\IgniterInstall->migrateDatabase()
#20 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): System\Console\Commands\IgniterInstall->handle()
#21 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/Util.php(37): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#22 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure(Object(Closure))
#23 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod(Object(Igniter\Flame\Foundation\Application), Array, Object(Closure))
#24 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/Container.php(590): Illuminate\Container\BoundMethod::call(Object(Igniter\Flame\Foundation\Application), Array, Array, NULL)
#25 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Console/Command.php(134): Illuminate\Container\Container->call(Array)
#26 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/symfony/console/Command/Command.php(255): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
#27 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
#28 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/symfony/console/Application.php(1009): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#29 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/symfony/console/Application.php(273): Symfony\Component\Console\Application->doRunCommand(Object(System\Console\Commands\IgniterInstall), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#30 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/symfony/console/Application.php(149): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#31 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Console/Application.php(93): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#32 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(131): Illuminate\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#33 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/artisan(35): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#34 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HY000] [1045] Access denied for user 'forge'@'localhost' (using password: NO) in /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(43): Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException))
#1 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(67): Doctrine\DBAL\Driver\PDOConnection->__construct('mysql:host=127....', 'forge', '', Array)
#2 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(46): Illuminate\Database\Connectors\Connector->createPdoConnection('mysql:host=127....', 'forge', '', Array)
#3 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection('mysql:host=127....', Array, Array)
#4 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(182): Illuminate\Database\Connectors\MySqlConnector->connect(Array)
#5 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors\{closure}()
#6 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(924): call_user_func(Object(Closure))
#7 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(959): Illuminate\Database\Connection->getPdo()
#8 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(404): Illuminate\Database\Connection->getReadPdo()
#9 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(330): Illuminate\Database\Connection->getPdoForSelect(true)
#10 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(662): Illuminate\Database\Connection->Illuminate\Database\{closure}('select column_n...', Array)
#11 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(629): Illuminate\Database\Connection->runQueryCallback('select column_n...', Array, Object(Closure))
#12 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\Database\Connection->run('select column_n...', Array, Object(Closure))
#13 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Schema/MySqlBuilder.php(33): Illuminate\Database\Connection->select('select column_n...', Array)
#14 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(102): Illuminate\Database\Schema\MySqlBuilder->getColumnListing('ti_migrations')
#15 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\Database\Schema\Builder->hasColumns('migrations', Array)
#16 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/app/system/classes/UpdateManager.php(193): Illuminate\Support\Facades\Facade::__callStatic('hasColumns', Array)
#17 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/app/system/classes/UpdateManager.php(155): System\Classes\UpdateManager->prepareDatabase()
#18 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/app/system/console/commands/IgniterInstall.php(132): System\Classes\UpdateManager->update()
#19 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/app/system/console/commands/IgniterInstall.php(78): System\Console\Commands\IgniterInstall->migrateDatabase()
#20 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): System\Console\Commands\IgniterInstall->handle()
#21 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/Util.php(37): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#22 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure(Object(Closure))
#23 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod(Object(Igniter\Flame\Foundation\Application), Array, Object(Closure))
#24 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/Container.php(590): Illuminate\Container\BoundMethod::call(Object(Igniter\Flame\Foundation\Application), Array, Array, NULL)
#25 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Console/Command.php(134): Illuminate\Container\Container->call(Array)
#26 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/symfony/console/Command/Command.php(255): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
#27 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
#28 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/symfony/console/Application.php(1009): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#29 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/symfony/console/Application.php(273): Symfony\Component\Console\Application->doRunCommand(Object(System\Console\Commands\IgniterInstall), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#30 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/symfony/console/Application.php(149): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#31 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Console/Application.php(93): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#32 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(131): Illuminate\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#33 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/artisan(35): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#34 {main}

Next Illuminate\Database\QueryException: SQLSTATE[HY000] [1045] Access denied for user 'forge'@'localhost' (using password: NO) (SQL: select column_name as `column_name` from information_schema.columns where table_schema = forge and table_name = ti_migrations) in /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php:669
Stack trace:
#0 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(629): Illuminate\Database\Connection->runQueryCallback('select column_n...', Array, Object(Closure))
#1 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\Database\Connection->run('select column_n...', Array, Object(Closure))
#2 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Schema/MySqlBuilder.php(33): Illuminate\Database\Connection->select('select column_n...', Array)
#3 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(102): Illuminate\Database\Schema\MySqlBuilder->getColumnListing('ti_migrations')
#4 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\Database\Schema\Builder->hasColumns('migrations', Array)
#5 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/app/system/classes/UpdateManager.php(193): Illuminate\Support\Facades\Facade::__callStatic('hasColumns', Array)
#6 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/app/system/classes/UpdateManager.php(155): System\Classes\UpdateManager->prepareDatabase()
#7 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/app/system/console/commands/IgniterInstall.php(132): System\Classes\UpdateManager->update()
#8 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/app/system/console/commands/IgniterInstall.php(78): System\Console\Commands\IgniterInstall->migrateDatabase()
#9 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): System\Console\Commands\IgniterInstall->handle()
#10 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/Util.php(37): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#11 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure(Object(Closure))
#12 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod(Object(Igniter\Flame\Foundation\Application), Array, Object(Closure))
#13 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/Container.php(590): Illuminate\Container\BoundMethod::call(Object(Igniter\Flame\Foundation\Application), Array, Array, NULL)
#14 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Console/Command.php(134): Illuminate\Container\Container->call(Array)
#15 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/symfony/console/Command/Command.php(255): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
#16 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
#17 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/symfony/console/Application.php(1009): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#18 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/symfony/console/Application.php(273): Symfony\Component\Console\Application->doRunCommand(Object(System\Console\Commands\IgniterInstall), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#19 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/symfony/console/Application.php(149): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#20 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Console/Application.php(93): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#21 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(131): Illuminate\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#22 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/artisan(35): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#23 {main}

What could be causing this issue?. Could you please replicate this issue at your end and fix this?.

ryanmitchell commented 3 years ago

It seems that the password is not being picked up in the connection. Is it present in your .env file under “DB_PASSWORD=xxx” ?

On 29 Jul 2021, at 11:53, prbt2016 @.***> wrote:

Version: 3.0.6

Additional Information: O.S - Centos Linux 6.9 Final Web server - Apache/2.2.34 Database server - MYSQL 5.7.33 PHP Version - 7.3.28

Reproduce steps: (Describe the steps to reproduce the problem here)

I was in the process of installation of TastyIgniter 3.0.6 version via CLI using the following steps mentioned in official documentation:

https://tastyigniter.com/docs/master/installation#command-line-installation https://tastyigniter.com/docs/master/installation#command-line-installation composer create-project tastyigniter/tastyigniter /{{PATH}}/{{TO}}/{{TastyIgniter}}

php artisan igniter:install

However after entering the correct database details and admin details on the CLI prompts I get the following error i.e :

Migrating application and extensions...

In Connection.php line 669:

SQLSTATE[HY000] [1045] Access denied for user 'forge'@'localhost' (using pa ssword: NO) (SQL: select column_name as column_name from information_sche ma.columns where table_schema = forge and table_name = ti_migrations)

In Exception.php line 18:

SQLSTATE[HY000] [1045] Access denied for user 'forge'@'localhost' (using pa ssword: NO)

In PDOConnection.php line 39:

SQLSTATE[HY000] [1045] Access denied for user 'forge'@'localhost' (using pa ssword: NO) https://user-images.githubusercontent.com/17871448/127478821-57c94d54-b09b-44b5-857f-7152cbb69a50.jpg Also I checked that the .env file is populated with correct details.

Following is the output of /storage/logs/system.log

[2021-07-29 10:07:23] production.ERROR: PDOException: SQLSTATE[HY000] [1045] Access denied for user 'forge'@'localhost' (using password: NO) in /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:39 Stack trace:

0 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(39): PDO->__construct('mysql:host=127....', 'forge', '', Array)

1 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(67): Doctrine\DBAL\Driver\PDOConnection->__construct('mysql:host=127....', 'forge', '', Array)

2 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(46): Illuminate\Database\Connectors\Connector->createPdoConnection('mysql:host=127....', 'forge', '', Array)

3 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection('mysql:host=127....', Array, Array)

4 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(182): Illuminate\Database\Connectors\MySqlConnector->connect(Array)

5 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors{closure}()

6 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(924): call_user_func(Object(Closure))

7 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(959): Illuminate\Database\Connection->getPdo()

8 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(404): Illuminate\Database\Connection->getReadPdo()

9 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(330): Illuminate\Database\Connection->getPdoForSelect(true)

10 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(662): Illuminate\Database\Connection->Illuminate\Database{closure}('select column_n...', Array)

11 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(629): Illuminate\Database\Connection->runQueryCallback('select column_n...', Array, Object(Closure))

12 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\Database\Connection->run('select column_n...', Array, Object(Closure))

13 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Schema/MySqlBuilder.php(33): Illuminate\Database\Connection->select('select column_n...', Array)

14 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(102): Illuminate\Database\Schema\MySqlBuilder->getColumnListing('ti_migrations')

15 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\Database\Schema\Builder->hasColumns('migrations', Array)

16 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/app/system/classes/UpdateManager.php(193): Illuminate\Support\Facades\Facade::__callStatic('hasColumns', Array)

17 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/app/system/classes/UpdateManager.php(155): System\Classes\UpdateManager->prepareDatabase()

18 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/app/system/console/commands/IgniterInstall.php(132): System\Classes\UpdateManager->update()

19 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/app/system/console/commands/IgniterInstall.php(78): System\Console\Commands\IgniterInstall->migrateDatabase()

20 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): System\Console\Commands\IgniterInstall->handle()

21 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/Util.php(37): Illuminate\Container\BoundMethod::Illuminate\Container{closure}()

22 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure(Object(Closure))

23 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod(Object(Igniter\Flame\Foundation\Application), Array, Object(Closure))

24 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/Container.php(590): Illuminate\Container\BoundMethod::call(Object(Igniter\Flame\Foundation\Application), Array, Array, NULL)

25 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Console/Command.php(134): Illuminate\Container\Container->call(Array)

26 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/symfony/console/Command/Command.php(255): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))

27 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))

28 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/symfony/console/Application.php(1009): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

29 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/symfony/console/Application.php(273): Symfony\Component\Console\Application->doRunCommand(Object(System\Console\Commands\IgniterInstall), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

30 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/symfony/console/Application.php(149): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

31 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Console/Application.php(93): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

32 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(131): Illuminate\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

33 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/artisan(35): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

34 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HY000] [1045] Access denied for user 'forge'@'localhost' (using password: NO) in /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18 Stack trace:

0 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(43): Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException))

1 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(67): Doctrine\DBAL\Driver\PDOConnection->__construct('mysql:host=127....', 'forge', '', Array)

2 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(46): Illuminate\Database\Connectors\Connector->createPdoConnection('mysql:host=127....', 'forge', '', Array)

3 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection('mysql:host=127....', Array, Array)

4 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(182): Illuminate\Database\Connectors\MySqlConnector->connect(Array)

5 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors{closure}()

6 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(924): call_user_func(Object(Closure))

7 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(959): Illuminate\Database\Connection->getPdo()

8 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(404): Illuminate\Database\Connection->getReadPdo()

9 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(330): Illuminate\Database\Connection->getPdoForSelect(true)

10 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(662): Illuminate\Database\Connection->Illuminate\Database{closure}('select column_n...', Array)

11 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(629): Illuminate\Database\Connection->runQueryCallback('select column_n...', Array, Object(Closure))

12 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\Database\Connection->run('select column_n...', Array, Object(Closure))

13 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Schema/MySqlBuilder.php(33): Illuminate\Database\Connection->select('select column_n...', Array)

14 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(102): Illuminate\Database\Schema\MySqlBuilder->getColumnListing('ti_migrations')

15 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\Database\Schema\Builder->hasColumns('migrations', Array)

16 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/app/system/classes/UpdateManager.php(193): Illuminate\Support\Facades\Facade::__callStatic('hasColumns', Array)

17 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/app/system/classes/UpdateManager.php(155): System\Classes\UpdateManager->prepareDatabase()

18 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/app/system/console/commands/IgniterInstall.php(132): System\Classes\UpdateManager->update()

19 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/app/system/console/commands/IgniterInstall.php(78): System\Console\Commands\IgniterInstall->migrateDatabase()

20 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): System\Console\Commands\IgniterInstall->handle()

21 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/Util.php(37): Illuminate\Container\BoundMethod::Illuminate\Container{closure}()

22 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure(Object(Closure))

23 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod(Object(Igniter\Flame\Foundation\Application), Array, Object(Closure))

24 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/Container.php(590): Illuminate\Container\BoundMethod::call(Object(Igniter\Flame\Foundation\Application), Array, Array, NULL)

25 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Console/Command.php(134): Illuminate\Container\Container->call(Array)

26 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/symfony/console/Command/Command.php(255): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))

27 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))

28 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/symfony/console/Application.php(1009): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

29 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/symfony/console/Application.php(273): Symfony\Component\Console\Application->doRunCommand(Object(System\Console\Commands\IgniterInstall), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

30 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/symfony/console/Application.php(149): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

31 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Console/Application.php(93): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

32 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(131): Illuminate\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

33 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/artisan(35): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

34 {main}

Next Illuminate\Database\QueryException: SQLSTATE[HY000] [1045] Access denied for user 'forge'@'localhost' (using password: NO) (SQL: select column_name as column_name from information_schema.columns where table_schema = forge and table_name = ti_migrations) in /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php:669 Stack trace:

0 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(629): Illuminate\Database\Connection->runQueryCallback('select column_n...', Array, Object(Closure))

1 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\Database\Connection->run('select column_n...', Array, Object(Closure))

2 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Schema/MySqlBuilder.php(33): Illuminate\Database\Connection->select('select column_n...', Array)

3 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(102): Illuminate\Database\Schema\MySqlBuilder->getColumnListing('ti_migrations')

4 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\Database\Schema\Builder->hasColumns('migrations', Array)

5 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/app/system/classes/UpdateManager.php(193): Illuminate\Support\Facades\Facade::__callStatic('hasColumns', Array)

6 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/app/system/classes/UpdateManager.php(155): System\Classes\UpdateManager->prepareDatabase()

7 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/app/system/console/commands/IgniterInstall.php(132): System\Classes\UpdateManager->update()

8 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/app/system/console/commands/IgniterInstall.php(78): System\Console\Commands\IgniterInstall->migrateDatabase()

9 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): System\Console\Commands\IgniterInstall->handle()

10 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/Util.php(37): Illuminate\Container\BoundMethod::Illuminate\Container{closure}()

11 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure(Object(Closure))

12 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod(Object(Igniter\Flame\Foundation\Application), Array, Object(Closure))

13 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Container/Container.php(590): Illuminate\Container\BoundMethod::call(Object(Igniter\Flame\Foundation\Application), Array, Array, NULL)

14 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Console/Command.php(134): Illuminate\Container\Container->call(Array)

15 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/symfony/console/Command/Command.php(255): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))

16 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))

17 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/symfony/console/Application.php(1009): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

18 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/symfony/console/Application.php(273): Symfony\Component\Console\Application->doRunCommand(Object(System\Console\Commands\IgniterInstall), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

19 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/symfony/console/Application.php(149): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

20 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Console/Application.php(93): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

21 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(131): Illuminate\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

22 /{{PATH}}/{{TO}}/{{TASTYIGNITER}}/artisan(35): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

23 {main}

What could be causing this issue?. Could you please replicate this issue at your end and fix this?.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/tastyigniter/TastyIgniter/issues/829, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAAMVO4EF7PEJPTLF6VU4VLT2EXKPANCNFSM5BGGY6XQ.

prbt2016 commented 3 years ago

@ryanmitchell Yes the correct password is present under "DB_PASSWORD=xxx" in .env file. It seems that the default database details are being fetched from /config/database.php

ryanmitchell commented 3 years ago

if you var_dump(env('DB_USERNAME')) to the top of your /config/database.php I assume it is blank or null? And just to be really sure its nothing simple - your env file is named .env ?

prbt2016 commented 3 years ago

Yes I checked with var_dump(env('DB_USERNAME')); on top of /config/database.php it is blank, (no output). Yes the file is named .env in the root directory.

ryanmitchell commented 3 years ago

Does your APP_NAME have a space in it? if so wrap it in quotes.

e.g. APP_NAME=“xxx xxx"

And if so I’ll fix the setup installer to handle it.

On 29 Jul 2021, at 12:16, prbt2016 @.***> wrote:

Yes I checked with var_dump(env('DB_USERNAME')) on top of /config/database.php it is blank, no output. Yes the file is named .env.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/tastyigniter/TastyIgniter/issues/829#issuecomment-889031440, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAAMVOZ3GSMQRRNYD5PQGDTT2E2A7ANCNFSM5BGGY6XQ.

prbt2016 commented 3 years ago

@ryanmitchell No there is no space in APP_NAME in .env file. It's a single word i.e APP_NAME=“xxx"

ryanmitchell commented 3 years ago

Can you share you .env file minus the password, as something is causing it to not be parsed.

On 29 Jul 2021, at 12:22, prbt2016 @.***> wrote:

@ryanmitchell https://github.com/ryanmitchell No there is no space in APP_NAME in .env file. It's a single word i.e APP_NAME=“xxx"

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/tastyigniter/TastyIgniter/issues/829#issuecomment-889035183, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAAMVOZQXSBYOHFOGT235UDT2E2WVANCNFSM5BGGY6XQ.

prbt2016 commented 3 years ago 
# APP CONFIG (DO NOT REMOVE!)
APP_NAME=Tastyigniter
APP_ENV=production
APP_KEY=base64:{{KEY}}
APP_DEBUG=false
APP_URL=http://{{domain.com}}/tastyigniter306/

IGNITER_LOCATION_MODE=multiple

LOG_CHANNEL=stack

# DATABASE CONFIG (DO NOT REMOVE!)
DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=tastyigniter306
DB_USERNAME=root
DB_PASSWORD={{SOME_PASSWORD}}
DB_PREFIX=preti_

BROADCAST_DRIVER=log
CACHE_DRIVER=file
QUEUE_CONNECTION=sync
SESSION_DRIVER=file
SESSION_LIFETIME=120

REDIS_HOST=127.0.0.1
REDIS_PASSWORD=null
REDIS_PORT=6379

MAIL_MAILER=log
MAIL_HOST=null
MAIL_PORT=null
MAIL_USERNAME=null
MAIL_PASSWORD=null
MAIL_ENCRYPTION=null
MAIL_FROM_ADDRESS=noreply@tastyigniter.tld
MAIL_FROM_NAME="${APP_NAME}"

PUSHER_APP_ID=
PUSHER_APP_KEY=
PUSHER_APP_SECRET=

Here is the output for your reference. Have wrapped sensitive data in curly braces {{ }} with generic values.

ryanmitchell commented 3 years ago

It works ok for me so maybe its something in your redacted values - add some quotes around them?

prbt2016 commented 3 years ago

I am not editing the example.env file in the package and renaming it to .env.

But the example.env file is renamed by CLI installer to .env after entering the values.

Do you mean to say should I add quotes around the db details while entering them via CLI ?.

ryanmitchell commented 3 years ago

Im asking you edit it manually to see if it helps fix the issue, in which case I'll update the installer with the changes required.

prbt2016 commented 3 years ago

@ryanmitchell editing the .env file manually works fine.:+1:

ryanmitchell commented 3 years ago

What changes did you have to make so I can ensure the installer handles it in future?

prbt2016 commented 3 years ago

@ryanmitchell

I renamed the example.env file and manually entered the same details i.e :

APP_NAME, APP_URL, DB_HOST, DB_PORT(3306), DB_DATABASE, DB_USERNAME, DB_PASSWORD, DB_PREFIX (without quoting them) and then ran php artisan igniter:install.

The db migrations ran fine.

darksylinc commented 3 years ago

I've had this bug yesterday as well on a brand new Ubuntu lts 20.04 VM installation.

It appears composer installation will ignore the entered db username and password and use whatever it was saved as default.

I tried installing from the wizard first, but met a sql error (I'll upload later the log in another ticket). I saw others were having the same bug so I went to sleep.

I suggest you try installing the app in a fresh VM because currently both methods of installation are broken

ryanmitchell commented 3 years ago

Opened a PR here - https://github.com/tastyigniter/TastyIgniter/pull/830 which should fix the composer install

ryanmitchell commented 3 years ago

Should be fixed in 3.0.7, open a new issue if it still occurs.