Bug: php spark migrate throws wrongful CodeIgniter\Database\Exceptions\DatabaseException Unable to connect to the database

[gosocial2]

Bug Description
Impossible to perform migrations through spark (experienced in versions 4.0.2 to 4.0.4)

Although DB credentials are set in .env and/orin app/Config/Database.php and successful query results obtained through Controller classes,

php spark migrate causes CodeIgniter\Database\Exceptions\DatabaseException

Exact command line output:

CodeIgniter CLI Tool - Version 4.0.4 - Server-Time: 2020-07-19 05:22:57am

Running all new migrations...
An uncaught Exception was encountered

Type:        CodeIgniter\Database\Exceptions\DatabaseException
Message:     Unable to connect to the database.
Filename:    /Applications/MAMP/ci4projs/deneme/vendor/codeigniter4/framework/system/Database/BaseConnection.php
Line Number: 425

	Backtrace:
						-646 - /Applications/MAMP/ci4projs/deneme/vendor/codeigniter4/framework/system/Database/BaseConnection.php::initialize
								-1548 - /Applications/MAMP/ci4projs/deneme/vendor/codeigniter4/framework/system/Database/BaseConnection.php::query
								-1591 - /Applications/MAMP/ci4projs/deneme/vendor/codeigniter4/framework/system/Database/BaseConnection.php::listTables
								-945 - /Applications/MAMP/ci4projs/deneme/vendor/codeigniter4/framework/system/Database/MigrationRunner.php::tableExists
								-193 - /Applications/MAMP/ci4projs/deneme/vendor/codeigniter4/framework/system/Database/MigrationRunner.php::ensureTable
								-128 - /Applications/MAMP/ci4projs/deneme/vendor/codeigniter4/framework/system/Commands/Database/Migrate.php::latest
								-100 - /Applications/MAMP/ci4projs/deneme/vendor/codeigniter4/framework/system/CLI/Commands.php::run
								-107 - /Applications/MAMP/ci4projs/deneme/vendor/codeigniter4/framework/system/CLI/CommandRunner.php::run
								-85 - /Applications/MAMP/ci4projs/deneme/vendor/codeigniter4/framework/system/CLI/CommandRunner.php::index
								-914 - /Applications/MAMP/ci4projs/deneme/vendor/codeigniter4/framework/system/CodeIgniter.php::_remap
								-404 - /Applications/MAMP/ci4projs/deneme/vendor/codeigniter4/framework/system/CodeIgniter.php::runController
								-312 - /Applications/MAMP/ci4projs/deneme/vendor/codeigniter4/framework/system/CodeIgniter.php::handleRequest
								-86 - /Applications/MAMP/ci4projs/deneme/vendor/codeigniter4/framework/system/CLI/Console.php::run
								-57 - /Applications/MAMP/ci4projs/deneme/spark::run

CodeIgniter 4 version
Last gotten in v4.0.4 release

Affected module(s)
spark

Expected behavior
All migrations performed successfully (without exceptions).

Steps to reproduce

1. Open up a Terminal / command line window
2. Change to the directory to the grand-parent level of your webserver's htdocs where htdocs will be substituted with the public directory of CI4
3. composer create-project codeigniter4/appstarter deneme
4. Open the project in your code editor and edit the .env file to set CI_ENVIRONMENT = development (duplicate it first from the file named 'env' if it doesn't exist - i.e. cp env .env)
5. Perform one or both of steps 6 and 7:
6. Enter DB credentials for MySQL in .env file (with database.default.DBDriver = MySQLi)
7. Enter DB credentials in app/Config/Database.php
8. Go back to the command line and run the following commands (in my example proj name is 'deneme':
   9: cd deneme
9. php spark migrate:create AddBlog
10. (Optional) Go back to your code editor and open the file whose name is resembles "2020_mm_dd_hhmmss_AddBlog.php" from app/Database/Migrations
11. (Optional) Replace the contents of up() and down() methods with example from https://codeigniter.com/user_guide/dbmgmt/migration.html
12. Go back to the command line and while still in the root directory of the CI4 project run
13. php spark migrate
14. Compare your Terminal output to the following output:

CodeIgniter CLI Tool - Version 4.0.4 - Server-Time: 2020-07-19 05:42:10am

Running all new migrations...
An uncaught Exception was encountered

Type:        CodeIgniter\Database\Exceptions\DatabaseException
Message:     Unable to connect to the database.
Filename:    /Applications/MAMP/ci4projs/deneme/vendor/codeigniter4/framework/system/Database/BaseConnection.php
Line Number: 425

	Backtrace:
						-646 - /Applications/MAMP/ci4projs/deneme/vendor/codeigniter4/framework/system/Database/BaseConnection.php::initialize
								-1548 - /Applications/MAMP/ci4projs/deneme/vendor/codeigniter4/framework/system/Database/BaseConnection.php::query
								-1591 - /Applications/MAMP/ci4projs/deneme/vendor/codeigniter4/framework/system/Database/BaseConnection.php::listTables
								-945 - /Applications/MAMP/ci4projs/deneme/vendor/codeigniter4/framework/system/Database/MigrationRunner.php::tableExists
								-193 - /Applications/MAMP/ci4projs/deneme/vendor/codeigniter4/framework/system/Database/MigrationRunner.php::ensureTable
								-128 - /Applications/MAMP/ci4projs/deneme/vendor/codeigniter4/framework/system/Commands/Database/Migrate.php::latest
								-100 - /Applications/MAMP/ci4projs/deneme/vendor/codeigniter4/framework/system/CLI/Commands.php::run
								-107 - /Applications/MAMP/ci4projs/deneme/vendor/codeigniter4/framework/system/CLI/CommandRunner.php::run
								-85 - /Applications/MAMP/ci4projs/deneme/vendor/codeigniter4/framework/system/CLI/CommandRunner.php::index
								-914 - /Applications/MAMP/ci4projs/deneme/vendor/codeigniter4/framework/system/CodeIgniter.php::_remap
								-404 - /Applications/MAMP/ci4projs/deneme/vendor/codeigniter4/framework/system/CodeIgniter.php::runController
								-312 - /Applications/MAMP/ci4projs/deneme/vendor/codeigniter4/framework/system/CodeIgniter.php::handleRequest
								-86 - /Applications/MAMP/ci4projs/deneme/vendor/codeigniter4/framework/system/CLI/Console.php::run
								-57 - /Applications/MAMP/ci4projs/deneme/spark::run

Context

• OS: Experienced in macOS 10.3
• Web server: Apache 2.x (in MAMP 5.4)
• PHP version 7.3.7
• MySQL 5.7

[paulbalandan]

May I know the database driver you used? I tried this using SQLite3 with :memory: as DB for the default connection and encountered no problems.

CodeIgniter CLI Tool - Version 4.0.4 - Server-Time: 2020-07-19 06:35:49am

Running all new migrations...
        Running: (App) 2020-07-19-113439_App\Database\Migrations\AddBlog
Done

[antoniodipinto]

I have exactly the same issue, tried firstly with custom migration, then switch back to tutorial migrations. When you try to use MySQLi as driver, this happens. I have also checked in the debugger for the database credentials, and everything looks fine

CodeIgniter CLI Tool - Version 4.0.4 - Server-Time: 2020-07-19 09:57:05am

An uncaught Exception was encountered

Type: CodeIgniter\Database\Exceptions\DatabaseException
Message: Unable to connect to the database.
Filename: /var/www/html/system/Database/BaseConnection.php
Line Number: 425

Backtrace:
					-109 - /var/www/html/system/Database/Database.php::initialize
							-148 - /var/www/html/system/Database/Config.php::loadForge
							-15 - /var/www/html/app/Commands/SetupApp.php::forge
							-100 - /var/www/html/system/CLI/Commands.php::run
							-107 - /var/www/html/system/CLI/CommandRunner.php::run
							-85 - /var/www/html/system/CLI/CommandRunner.php::index
							-914 - /var/www/html/system/CodeIgniter.php::_remap
							-404 - /var/www/html/system/CodeIgniter.php::runController
							-312 - /var/www/html/system/CodeIgniter.php::handleRequest
							-86 - /var/www/html/system/CLI/Console.php::run
							-57 - /var/www/html/spark::run

`

[paulbalandan]

Can you tell me the details of your DB config? Just exclude sensitive information like the password.

[gosocial2]

#--------------------------------------------------------------------
# ENVIRONMENT
#--------------------------------------------------------------------

CI_ENVIRONMENT = development

#--------------------------------------------------------------------
# DATABASE
#--------------------------------------------------------------------

database.default.hostname = localhost
database.default.database = deneme
database.default.username = arclab
database.default.password = Passw0rd
database.default.DBDriver = MySQLi

Everything else is as same as what shipped with the default env file.

[gosocial2]

May I know the database driver you used? I tried this using SQLite3 with :memory: as DB for the default connection and encountered no problems.

CodeIgniter CLI Tool - Version 4.0.4 - Server-Time: 2020-07-19 06:35:49am

Running all new migrations...
        Running: (App) 2020-07-19-113439_App\Database\Migrations\AddBlog
Done

Using database.default.DBDriver = MySQLi

[paulbalandan]

@gosocial2 have you tried checking if the database deneme exists in the MySQL server? And/or the username/password is registered?

[michalsn]

I was able to replicate this problem but only when there was no database. You have to create a database manually before running migrations.

CodeIgniter will create a database only for the SQLite3 driver.

[paulbalandan]

Yes, this is reproducible if either the database does not exist or the username/password is not registered.

[antoniodipinto]

I want to add something to this. I've just retested my case.

If I try to connect to the database using a standard model, the connection works. The database exists, and everything works.
When I try to run the migration itself he doesn't work, I have this error again.

CodeIgniter CLI Tool - Version 4.0.4 - Server-Time: 2020-07-19 09:57:05am

An uncaught Exception was encountered

Type: CodeIgniter\Database\Exceptions\DatabaseException
Message: Unable to connect to the database.
Filename: /var/www/html/system/Database/BaseConnection.php
Line Number: 425

Via controller/request is working but is not the same when I try to use commands via spark, no.

[gosocial2]

DB connection works through code in Controllers running in the web application so database is accessible alright. It just doesn't work with spark. Spark is not seeing the DB config in .env or in app\Config\Database.php .

I also tested with ci-news app - same result. Did you try to reproduce through the steps in the issue description? (e.g. using composer to create a project from scratch)

[michalsn]

@gosocial2 Yes, I followed steps from your description.

Okay... it seems like a bug but I can't reproduce it for now. And I have no idea what can cause it. I will try to deal with this tomorrow maybe.

If you think that there is something "specific" in your working environment, please share.