SQLSRV support

[kovijanny]

Hi Lonnie,

I hacking the Bonfire install.php and added to the supported DB driver the SQLSRV.
Install is working:
janny@janny-GT-R:~/WWW/my-app$ php spark bf:install
CodeIgniter v4.2.1 Command Line Tool - Server Time: 2022-08-04 04:43:21 UTC-05:00
Creating .env file...Exists
What URL are you running Bonfire under locally? : http://localhost:8080
Generating encryption key
Encryption key saved to .env file

Database host: [localhost]:
Database name: [bonfire]: myapp
Database username: [root]: Sa
Database password: [root]:
Database driver: [MySQLi, Postgre, SQLite3, SQLSRV]: SQLSRV
Table prefix: :

Publishing config files
Created: APPPATH/Config/Assets.php
Created: APPPATH/Config/Auth.php
Created: APPPATH/Config/AuthGroups.php
Created: APPPATH/Config/Bonfire.php
Created: APPPATH/Config/Site.php
Created: APPPATH/Config/Themes.php
Created: APPPATH/Config/Consent.php
Created: APPPATH/Config/Dashboard.php
Created: APPPATH/Config/Recycler.php
Created: APPPATH/Config/Users.php

If you need to create your database, you may run:
php spark db:create

To migrate and create the initial user, please run:
php spark bf:install --continue

Okay, so next step...
janny@janny-GT-R:~/WWW/my-app$ php spark db:create myapp
CodeIgniter v4.2.1 Command Line Tool - Server Time: 2022-08-04 04:52:42 UTC-05:00
[CodeIgniter\Database\Exceptions\DatabaseException]
Unable to connect to the database.
Main connection [SQLSRV]: Cannot open database "myapp" requested by the login. The login failed.
Login failed for user 'sa'.
at SYSTEMPATH/Database/BaseConnection.php:416
Backtrace:
1 SYSTEMPATH/Database/Database.php:67
CodeIgniter\Database\BaseConnection()->initialize()
2 SYSTEMPATH/Database/Config.php:105
CodeIgniter\Database\Database()->loadForge()
3 SYSTEMPATH/Commands/Database/CreateDatabase.php:137
CodeIgniter\Database\Config::forge()
4 SYSTEMPATH/CLI/Commands.php:63
CodeIgniter\Commands\Database\CreateDatabase()->run()
5 SYSTEMPATH/CLI/CommandRunner.php:65
CodeIgniter\CLI\Commands()->run()
6 SYSTEMPATH/CLI/CommandRunner.php:51
CodeIgniter\CLI\CommandRunner()->index()
7 SYSTEMPATH/CodeIgniter.php:889
CodeIgniter\CLI\CommandRunner()->_remap()
8 SYSTEMPATH/CodeIgniter.php:466
CodeIgniter\CodeIgniter()->runController()
9 SYSTEMPATH/CodeIgniter.php:345
CodeIgniter\CodeIgniter()->handleRequest()
10 SYSTEMPATH/CLI/Console.php:48
CodeIgniter\CodeIgniter()->run()
11 ROOTPATH/spark:86
CodeIgniter\CLI\Console()->run()

Database does't created... Hmm...
Okay, I created on hand in the DB.

Then next step:
janny@janny-GT-R:~/WWW/my-app$ php spark bf:install --continue

CodeIgniter v4.2.1 Command Line Tool - Server Time: 2022-08-04 04:53:18 UTC-05:00

Running all new migrations...
Running: (CodeIgniter\Shield) 2020-12-28-223112_CodeIgniter\Shield\Database\Migrations\CreateAuthTables
Running: (CodeIgniter\Settings) 2021-07-04-041948_CodeIgniter\Settings\Database\Migrations\CreateSettingsTable
Running: (Bonfire{Users}) 2021-09-04-044800_App\Database\Migrations\AdditionalUserFields
Running: (Bonfire{Users}) 2021-10-05-040656_App\Database\Migrations\CreateMetaTable
Running: (CodeIgniter\Settings) 2021-11-14-143905_CodeIgniter\Settings\Database\Migrations\AddContextColumn
Migrations complete.

Create initial user
Email? :
First name? : Janos
Last name? : KOVACS
Username? :
Password? :
Done. You can now login as a superadmin.

Wooow, it is good!
It also adds the user to the user table.
I think the Codeigniter DB driver could be an error that could not create the new database.
I haven't tested this there yet...
Among other DB drivers, SQLSRV could also be supported.

[lonnieezell]

That's great news. Thanks for testing that out! I'll update that now.