shield icon indicating copy to clipboard operation
shield copied to clipboard
verified publisher icon codeigniter4

chore: add multiple db platforms in GA workflow PHPUnit

Open kenjis opened this issue 3 years ago • 4 comments

Probably now Shield works with only ~~MySQL or~~ SQLite3.

  • [x] MySQL #336
  • [x] Postgre #339
  • [x] SQLSRV
  • [ ] OCI8

kenjis avatar Aug 02 '22 06:08 kenjis

I was wrong. Tests failed on MySQL.

There was 1 error:

1) Tests\Authentication\Authenticators\SessionAuthenticatorTest::testForgetAnotherUser
mysqli_sql_exception: Incorrect datetime value: 'nesciunt' for column 'expires' at row 1

/home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php:292
/home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:695
/home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:609
/home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseBuilder.php:1904
/home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:278
/home/runner/work/shield/shield/vendor/codeigniter4/framework/system/BaseModel.php:738
/home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:666
/home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Test/Fabricator.php:469
/home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Helpers/test_helper.php:38
/home/runner/work/shield/shield/tests/Authentication/Authenticators/SessionAuthenticatorTest.php:237
phpvfscomposer:///home/runner/work/shield/shield/vendor/phpunit/phpunit/phpunit:97

--

There were 2 failures:

1) Tests\Controllers\LoginTest::testLoginActionUsernameSuccess
The value of 'user' does not match expected value.
Failed asserting that two arrays are identical.
--- Expected
+++ Actual
@@ @@
 Array &0 (
-    'id' => 1
+    'id' => '1'
 )

/home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Test/TestResponse.php:264
/home/runner/work/shield/shield/tests/Controllers/LoginTest.php:139
phpvfscomposer:///home/runner/work/shield/shield/vendor/phpunit/phpunit/phpunit:97

2) Tests\Controllers\LoginTest::testLoginActionEmailSuccess
The value of 'user' does not match expected value.
Failed asserting that two arrays are identical.
--- Expected
+++ Actual
@@ @@
 Array &0 (
-    'id' => 1
+    'id' => '1'
 )

/home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Test/TestResponse.php:264
/home/runner/work/shield/shield/tests/Controllers/LoginTest.php:79
phpvfscomposer:///home/runner/work/shield/shield/vendor/phpunit/phpunit/phpunit:97

https://github.com/codeigniter4/shield/runs/7625886471?check_suite_focus=true

kenjis avatar Aug 02 '22 06:08 kenjis

The first one is an easy fix: RememberModel needs its fake() method defined so Fabricator doesn't try to guess fields values.

The other one... this is always an issue. Because we technically support int|string for primary keys the typing can never be certain. I think in this case since our migrations are explicitly AUTOINCREMENT INT we can set ['id' => 'int'] on BaseEntity::$casts and have consistency across the library.

MGatner avatar Aug 02 '22 11:08 MGatner

PHP 7.4 - Postgre

Run vendor/bin/phpunit --verbose --coverage-text --testsuite main
PHPUnit 9.5.21 #StandWithUkraine

Runtime:       PHP 7.4.30 with Xdebug 3.1.2
Configuration: /home/runner/work/shield/shield/phpunit.xml.dist
Random Seed:   1659774642

...............................................................  63 / 183 ( 34%)
............................................................... 126 / 183 ( 68%)
.........................................................       183 / 183 (100%)

Nexus\PHPUnit\Extension\Tachycardia identified these 3 slow tests:
+--------------------------------------------------------------------------+---------------+-------------+
| Test Case                                                                | Time Consumed | Time Limit  |
+--------------------------------------------------------------------------+---------------+-------------+
| Tests\\Controllers\\RegisterTest::testRegisterRedirectsToActionIfDefined | 00:00:01.01   | 00:00:00.50 |
| Tests\\Controllers\\RegisterTest::testRegisterActionSuccess              | 00:00:01.01   | 00:00:00.50 |
| Tests\\Unit\\DictionaryValidatorTest::testCheckTrueOnNotFound            | 00:00:00.74   | 00:00:00.50 |
+--------------------------------------------------------------------------+---------------+-------------+

Warning: Took 1.01s from 0.50s limit to run Tests\\Controllers\\RegisterTest::testRegisterRedirectsToActionIfDefined
Warning: Took 1.01s from 0.50s limit to run Tests\\Controllers\\RegisterTest::testRegisterActionSuccess
Warning: Took 0.74s from 0.50s limit to run Tests\\Unit\\DictionaryValidatorTest::testCheckTrueOnNotFound


Time: 00:23.047, Memory: 78.00 MB

OK (183 tests, 471 assertions)

kenjis avatar Aug 06 '22 08:08 kenjis

PHP 8.0 - OCI8

2022-08-06T08:35:17.7187840Z There were 26 errors:
2022-08-06T08:35:17.7187981Z 
2022-08-06T08:35:17.7188222Z 1) Tests\Authentication\Authenticators\AccessTokenAuthenticatorTest::testLoginByIdNoToken
2022-08-06T08:35:17.7188953Z ErrorException: oci_execute(): ORA-01400: cannot insert NULL into ("ORACLE"."db_auth_token_logins"."identifier")
2022-08-06T08:35:17.7189209Z 
2022-08-06T08:35:17.7189429Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php:198
2022-08-06T08:35:17.7189888Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:693
2022-08-06T08:35:17.7190329Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:620
2022-08-06T08:35:17.7190778Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseBuilder.php:1916
2022-08-06T08:35:17.7191202Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:278
2022-08-06T08:35:17.7191610Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/BaseModel.php:738
2022-08-06T08:35:17.7192016Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:666
2022-08-06T08:35:17.7192387Z /home/runner/work/shield/shield/src/Models/LoginModel.php:64
2022-08-06T08:35:17.7192770Z /home/runner/work/shield/shield/src/Authentication/Authenticators/AccessTokens.php:54
2022-08-06T08:35:17.7193180Z /home/runner/work/shield/shield/src/Authentication/Authenticators/AccessTokens.php:155
2022-08-06T08:35:17.7193649Z /home/runner/work/shield/shield/tests/Authentication/Authenticators/AccessTokenAuthenticatorTest.php:67
2022-08-06T08:35:17.7194065Z 
2022-08-06T08:35:17.7194258Z 2) Tests\Authentication\MagicLinkTest::testMagicLinkSubmitBadEmail
2022-08-06T08:35:17.7194797Z ErrorException: oci_execute(): ORA-00904: "DB_AUTH_IDENTITIES"."SECRET": invalid identifier
2022-08-06T08:35:17.7195023Z 
2022-08-06T08:35:17.7195243Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php:198
2022-08-06T08:35:17.7195699Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:693
2022-08-06T08:35:17.7196155Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:620
2022-08-06T08:35:17.7196592Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseBuilder.php:1585
2022-08-06T08:35:17.7197012Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:249
2022-08-06T08:35:17.7197869Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/BaseModel.php:622
2022-08-06T08:35:17.7198252Z /home/runner/work/shield/shield/src/Models/UserModel.php:183
2022-08-06T08:35:17.7198624Z /home/runner/work/shield/shield/src/Controllers/MagicLinkController.php:68
2022-08-06T08:35:17.7199036Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:898
2022-08-06T08:35:17.7199433Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:457
2022-08-06T08:35:17.7199852Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:340
2022-08-06T08:35:17.7200382Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Test/FeatureTestTrait.php:189
2022-08-06T08:35:17.7200836Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Test/FeatureTestTrait.php:236
2022-08-06T08:35:17.7201254Z /home/runner/work/shield/shield/tests/Authentication/MagicLinkTest.php:59
2022-08-06T08:35:17.7201564Z 
2022-08-06T08:35:17.7201760Z 3) Tests\Authentication\MagicLinkTest::testMagicLinkVerifyNoToken
2022-08-06T08:35:17.7202348Z ErrorException: oci_execute(): ORA-01400: cannot insert NULL into ("ORACLE"."db_auth_logins"."identifier")
2022-08-06T08:35:17.7202578Z 
2022-08-06T08:35:17.7202801Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php:198
2022-08-06T08:35:17.7203258Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:693
2022-08-06T08:35:17.7203703Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:620
2022-08-06T08:35:17.7204168Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseBuilder.php:1916
2022-08-06T08:35:17.7204590Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:278
2022-08-06T08:35:17.7205002Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/BaseModel.php:738
2022-08-06T08:35:17.7205404Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:666
2022-08-06T08:35:17.7205755Z /home/runner/work/shield/shield/src/Models/LoginModel.php:64
2022-08-06T08:35:17.7206124Z /home/runner/work/shield/shield/src/Controllers/MagicLinkController.php:177
2022-08-06T08:35:17.7206525Z /home/runner/work/shield/shield/src/Controllers/MagicLinkController.php:130
2022-08-06T08:35:17.7206934Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:898
2022-08-06T08:35:17.7207349Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:457
2022-08-06T08:35:17.7207765Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:340
2022-08-06T08:35:17.7208186Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Test/FeatureTestTrait.php:189
2022-08-06T08:35:17.7208640Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Test/FeatureTestTrait.php:223
2022-08-06T08:35:17.7209140Z /home/runner/work/shield/shield/tests/Authentication/MagicLinkTest.php:89
2022-08-06T08:35:17.7209354Z 
2022-08-06T08:35:17.7209543Z 4) Tests\Authentication\MagicLinkTest::testMagicLinkSubmitSuccess
2022-08-06T08:35:17.7210066Z ErrorException: oci_execute(): ORA-00904: "DB_AUTH_IDENTITIES"."SECRET": invalid identifier
2022-08-06T08:35:17.7210291Z 
2022-08-06T08:35:17.7210505Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php:198
2022-08-06T08:35:17.7210956Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:693
2022-08-06T08:35:17.7211399Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:620
2022-08-06T08:35:17.7211848Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseBuilder.php:1585
2022-08-06T08:35:17.7212269Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:249
2022-08-06T08:35:17.7212674Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/BaseModel.php:622
2022-08-06T08:35:17.7213039Z /home/runner/work/shield/shield/src/Models/UserModel.php:183
2022-08-06T08:35:17.7213410Z /home/runner/work/shield/shield/src/Controllers/MagicLinkController.php:68
2022-08-06T08:35:17.7213807Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:898
2022-08-06T08:35:17.7214222Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:457
2022-08-06T08:35:17.7214634Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:340
2022-08-06T08:35:17.7215128Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Test/FeatureTestTrait.php:189
2022-08-06T08:35:17.7215582Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Test/FeatureTestTrait.php:236
2022-08-06T08:35:17.7216002Z /home/runner/work/shield/shield/tests/Authentication/MagicLinkTest.php:75
2022-08-06T08:35:17.7216215Z 
2022-08-06T08:35:17.7216464Z 5) Tests\Authentication\Authenticators\SessionAuthenticatorTest::testAttemptCaseInsensitive
2022-08-06T08:35:17.7217016Z ErrorException: oci_execute(): ORA-00904: "DB_AUTH_IDENTITIES"."SECRET": invalid identifier
2022-08-06T08:35:17.7217238Z 
2022-08-06T08:35:17.7217453Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php:198
2022-08-06T08:35:17.7217905Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:693
2022-08-06T08:35:17.7218353Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:620
2022-08-06T08:35:17.7218806Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseBuilder.php:1585
2022-08-06T08:35:17.7219235Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:249
2022-08-06T08:35:17.7219638Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/BaseModel.php:622
2022-08-06T08:35:17.7219999Z /home/runner/work/shield/shield/src/Models/UserModel.php:183
2022-08-06T08:35:17.7220372Z /home/runner/work/shield/shield/src/Authentication/Authenticators/Session.php:287
2022-08-06T08:35:17.7220783Z /home/runner/work/shield/shield/src/Authentication/Authenticators/Session.php:103
2022-08-06T08:35:17.7221226Z /home/runner/work/shield/shield/tests/Authentication/Authenticators/SessionAuthenticatorTest.php:383
2022-08-06T08:35:17.7221486Z 
2022-08-06T08:35:17.7221717Z 6) Tests\Authentication\Authenticators\SessionAuthenticatorTest::testAttemptUsernameOnly
2022-08-06T08:35:17.7222252Z ErrorException: oci_execute(): ORA-00904: "DB_USERS"."USERNAME": invalid identifier
2022-08-06T08:35:17.7222465Z 
2022-08-06T08:35:17.7222680Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php:198
2022-08-06T08:35:17.7224264Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:693
2022-08-06T08:35:17.7224743Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:620
2022-08-06T08:35:17.7225306Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseBuilder.php:1585
2022-08-06T08:35:17.7225737Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:249
2022-08-06T08:35:17.7226142Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/BaseModel.php:622
2022-08-06T08:35:17.7226514Z /home/runner/work/shield/shield/src/Models/UserModel.php:202
2022-08-06T08:35:17.7226871Z /home/runner/work/shield/shield/src/Authentication/Authenticators/Session.php:287
2022-08-06T08:35:17.7227282Z /home/runner/work/shield/shield/src/Authentication/Authenticators/Session.php:103
2022-08-06T08:35:17.7227725Z /home/runner/work/shield/shield/tests/Authentication/Authenticators/SessionAuthenticatorTest.php:415
2022-08-06T08:35:17.7227990Z 
2022-08-06T08:35:17.7228226Z 7) Tests\Authentication\Authenticators\SessionAuthenticatorTest::testCheckCannotFindUser
2022-08-06T08:35:17.7228813Z ErrorException: oci_execute(): ORA-00904: "DB_AUTH_IDENTITIES"."SECRET": invalid identifier
2022-08-06T08:35:17.7229037Z 
2022-08-06T08:35:17.7229251Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php:198
2022-08-06T08:35:17.7229702Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:693
2022-08-06T08:35:17.7230139Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:620
2022-08-06T08:35:17.7230658Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseBuilder.php:1585
2022-08-06T08:35:17.7231082Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:249
2022-08-06T08:35:17.7231492Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/BaseModel.php:622
2022-08-06T08:35:17.7231867Z /home/runner/work/shield/shield/src/Models/UserModel.php:183
2022-08-06T08:35:17.7232244Z /home/runner/work/shield/shield/src/Authentication/Authenticators/Session.php:287
2022-08-06T08:35:17.7232695Z /home/runner/work/shield/shield/tests/Authentication/Authenticators/SessionAuthenticatorTest.php:260
2022-08-06T08:35:17.7232954Z 
2022-08-06T08:35:17.7233161Z 8) Tests\Authentication\Authenticators\SessionAuthenticatorTest::testCheckSuccess
2022-08-06T08:35:17.7233703Z ErrorException: oci_execute(): ORA-00904: "DB_AUTH_IDENTITIES"."SECRET": invalid identifier
2022-08-06T08:35:17.7233927Z 
2022-08-06T08:35:17.7234140Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php:198
2022-08-06T08:35:17.7234591Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:693
2022-08-06T08:35:17.7235047Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:620
2022-08-06T08:35:17.7235493Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseBuilder.php:1585
2022-08-06T08:35:17.7235919Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:249
2022-08-06T08:35:17.7236309Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/BaseModel.php:622
2022-08-06T08:35:17.7236680Z /home/runner/work/shield/shield/src/Models/UserModel.php:183
2022-08-06T08:35:17.7237062Z /home/runner/work/shield/shield/src/Authentication/Authenticators/Session.php:287
2022-08-06T08:35:17.7237507Z /home/runner/work/shield/shield/tests/Authentication/Authenticators/SessionAuthenticatorTest.php:295
2022-08-06T08:35:17.7237766Z 
2022-08-06T08:35:17.7238356Z 9) Tests\Authentication\Authenticators\SessionAuthenticatorTest::testCheckBadPassword
2022-08-06T08:35:17.7238958Z ErrorException: oci_execute(): ORA-00904: "DB_AUTH_IDENTITIES"."SECRET": invalid identifier
2022-08-06T08:35:17.7239185Z 
2022-08-06T08:35:17.7239403Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php:198
2022-08-06T08:35:17.7239921Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:693
2022-08-06T08:35:17.7240577Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:620
2022-08-06T08:35:17.7241032Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseBuilder.php:1585
2022-08-06T08:35:17.7241591Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:249
2022-08-06T08:35:17.7242001Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/BaseModel.php:622
2022-08-06T08:35:17.7242381Z /home/runner/work/shield/shield/src/Models/UserModel.php:183
2022-08-06T08:35:17.7242741Z /home/runner/work/shield/shield/src/Authentication/Authenticators/Session.php:287
2022-08-06T08:35:17.7243188Z /home/runner/work/shield/shield/tests/Authentication/Authenticators/SessionAuthenticatorTest.php:278
2022-08-06T08:35:17.7243447Z 
2022-08-06T08:35:17.7243700Z 10) Tests\Authentication\Authenticators\SessionAuthenticatorTest::testAttemptCannotFindUser
2022-08-06T08:35:17.7244282Z ErrorException: oci_execute(): ORA-00904: "DB_AUTH_IDENTITIES"."SECRET": invalid identifier
2022-08-06T08:35:17.7244505Z 
2022-08-06T08:35:17.7244718Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php:198
2022-08-06T08:35:17.7245169Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:693
2022-08-06T08:35:17.7245623Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:620
2022-08-06T08:35:17.7246152Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseBuilder.php:1585
2022-08-06T08:35:17.7246558Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:249
2022-08-06T08:35:17.7246959Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/BaseModel.php:622
2022-08-06T08:35:17.7247332Z /home/runner/work/shield/shield/src/Models/UserModel.php:183
2022-08-06T08:35:17.7247711Z /home/runner/work/shield/shield/src/Authentication/Authenticators/Session.php:287
2022-08-06T08:35:17.7248117Z /home/runner/work/shield/shield/src/Authentication/Authenticators/Session.php:103
2022-08-06T08:35:17.7248564Z /home/runner/work/shield/shield/tests/Authentication/Authenticators/SessionAuthenticatorTest.php:308
2022-08-06T08:35:17.7248821Z 
2022-08-06T08:35:17.7249030Z 11) Tests\Authentication\Authenticators\SessionAuthenticatorTest::testAttemptSuccess
2022-08-06T08:35:17.7249585Z ErrorException: oci_execute(): ORA-00904: "DB_AUTH_IDENTITIES"."SECRET": invalid identifier
2022-08-06T08:35:17.7249811Z 
2022-08-06T08:35:17.7250027Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php:198
2022-08-06T08:35:17.7250481Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:693
2022-08-06T08:35:17.7250931Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:620
2022-08-06T08:35:17.7251385Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseBuilder.php:1585
2022-08-06T08:35:17.7251803Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:249
2022-08-06T08:35:17.7252192Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/BaseModel.php:622
2022-08-06T08:35:17.7252562Z /home/runner/work/shield/shield/src/Models/UserModel.php:183
2022-08-06T08:35:17.7252933Z /home/runner/work/shield/shield/src/Authentication/Authenticators/Session.php:287
2022-08-06T08:35:17.7253340Z /home/runner/work/shield/shield/src/Authentication/Authenticators/Session.php:103
2022-08-06T08:35:17.7253774Z /home/runner/work/shield/shield/tests/Authentication/Authenticators/SessionAuthenticatorTest.php:334
2022-08-06T08:35:17.7254031Z 
2022-08-06T08:35:17.7254184Z 12) Tests\Unit\UserModelTest::testInsertUserObject
2022-08-06T08:35:17.7254650Z ErrorException: oci_execute(): ORA-00904: "DB_AUTH_IDENTITIES"."SECRET": invalid identifier
2022-08-06T08:35:17.7254947Z 
2022-08-06T08:35:17.7255162Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php:198
2022-08-06T08:35:17.7255615Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:693
2022-08-06T08:35:17.7256064Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:620
2022-08-06T08:35:17.7256511Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseBuilder.php:1585
2022-08-06T08:35:17.7256932Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:249
2022-08-06T08:35:17.7257334Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/BaseModel.php:622
2022-08-06T08:35:17.7257695Z /home/runner/work/shield/shield/src/Models/UserModel.php:183
2022-08-06T08:35:17.7258040Z /home/runner/work/shield/shield/tests/Unit/UserModelTest.php:52
2022-08-06T08:35:17.7258234Z 
2022-08-06T08:35:17.7258467Z 13) Tests\Unit\UserModelTest::testSaveUpdateUserObjectWithUserDataToUpdate
2022-08-06T08:35:17.7259023Z ErrorException: oci_execute(): ORA-00904: "DB_AUTH_IDENTITIES"."SECRET": invalid identifier
2022-08-06T08:35:17.7259248Z 
2022-08-06T08:35:17.7259464Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php:198
2022-08-06T08:35:17.7259913Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:693
2022-08-06T08:35:17.7260353Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:620
2022-08-06T08:35:17.7260836Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseBuilder.php:1585
2022-08-06T08:35:17.7261262Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:249
2022-08-06T08:35:17.7261662Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/BaseModel.php:622
2022-08-06T08:35:17.7262034Z /home/runner/work/shield/shield/src/Models/UserModel.php:183
2022-08-06T08:35:17.7262385Z /home/runner/work/shield/shield/tests/Unit/UserModelTest.php:110
2022-08-06T08:35:17.7262586Z 
2022-08-06T08:35:17.7262810Z 14) Tests\Unit\UserModelTest::testUpdateUserObjectWithoutUserDataToUpdate
2022-08-06T08:35:17.7263360Z ErrorException: oci_execute(): ORA-00904: "DB_AUTH_IDENTITIES"."SECRET": invalid identifier
2022-08-06T08:35:17.7263570Z 
2022-08-06T08:35:17.7263817Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php:198
2022-08-06T08:35:17.7264270Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:693
2022-08-06T08:35:17.7264725Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:620
2022-08-06T08:35:17.7265171Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseBuilder.php:1585
2022-08-06T08:35:17.7265590Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:249
2022-08-06T08:35:17.7266000Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/BaseModel.php:622
2022-08-06T08:35:17.7266372Z /home/runner/work/shield/shield/src/Models/UserModel.php:183
2022-08-06T08:35:17.7266708Z /home/runner/work/shield/shield/tests/Unit/UserModelTest.php:212
2022-08-06T08:35:17.7266907Z 
2022-08-06T08:35:17.7267053Z 15) Tests\Unit\UserModelTest::testSaveInsertUser
2022-08-06T08:35:17.7267524Z ErrorException: oci_execute(): ORA-00904: "DB_AUTH_IDENTITIES"."SECRET": invalid identifier
2022-08-06T08:35:17.7267752Z 
2022-08-06T08:35:17.7267970Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php:198
2022-08-06T08:35:17.7268414Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:693
2022-08-06T08:35:17.7268861Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:620
2022-08-06T08:35:17.7269362Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseBuilder.php:1585
2022-08-06T08:35:17.7269775Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:249
2022-08-06T08:35:17.7270182Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/BaseModel.php:622
2022-08-06T08:35:17.7270556Z /home/runner/work/shield/shield/src/Models/UserModel.php:183
2022-08-06T08:35:17.7270900Z /home/runner/work/shield/shield/tests/Unit/UserModelTest.php:33
2022-08-06T08:35:17.7271096Z 
2022-08-06T08:35:17.7271315Z 16) Tests\Unit\UserModelTest::testUpdateUserObjectWithUserDataToUpdate
2022-08-06T08:35:17.7271861Z ErrorException: oci_execute(): ORA-00904: "DB_AUTH_IDENTITIES"."SECRET": invalid identifier
2022-08-06T08:35:17.7272070Z 
2022-08-06T08:35:17.7272284Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php:198
2022-08-06T08:35:17.7272735Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:693
2022-08-06T08:35:17.7273184Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:620
2022-08-06T08:35:17.7273641Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseBuilder.php:1585
2022-08-06T08:35:17.7274063Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:249
2022-08-06T08:35:17.7274466Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/BaseModel.php:622
2022-08-06T08:35:17.7274834Z /home/runner/work/shield/shield/src/Models/UserModel.php:183
2022-08-06T08:35:17.7275217Z /home/runner/work/shield/shield/tests/Unit/UserModelTest.php:134
2022-08-06T08:35:17.7275419Z 
2022-08-06T08:35:17.7275633Z 17) Tests\Unit\UserModelTest::testUpdateUserArrayWithUserDataToUpdate
2022-08-06T08:35:17.7276174Z ErrorException: oci_execute(): ORA-00904: "DB_AUTH_IDENTITIES"."SECRET": invalid identifier
2022-08-06T08:35:17.7276398Z 
2022-08-06T08:35:17.7276611Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php:198
2022-08-06T08:35:17.7277062Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:693
2022-08-06T08:35:17.7277514Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:620
2022-08-06T08:35:17.7277952Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseBuilder.php:1585
2022-08-06T08:35:17.7278375Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:249
2022-08-06T08:35:17.7279142Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/BaseModel.php:622
2022-08-06T08:35:17.7279541Z /home/runner/work/shield/shield/src/Models/UserModel.php:183
2022-08-06T08:35:17.7279888Z /home/runner/work/shield/shield/tests/Unit/UserModelTest.php:166
2022-08-06T08:35:17.7280088Z 
2022-08-06T08:35:17.7280332Z 18) Tests\Unit\UserModelTest::testSaveUpdateUserObjectWithoutUserDataToUpdate
2022-08-06T08:35:17.7280922Z ErrorException: oci_execute(): ORA-00904: "DB_AUTH_IDENTITIES"."SECRET": invalid identifier
2022-08-06T08:35:17.7281146Z 
2022-08-06T08:35:17.7283740Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php:198
2022-08-06T08:35:17.7284215Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:693
2022-08-06T08:35:17.7284664Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:620
2022-08-06T08:35:17.7285113Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseBuilder.php:1585
2022-08-06T08:35:17.7285540Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:249
2022-08-06T08:35:17.7285953Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/BaseModel.php:622
2022-08-06T08:35:17.7286324Z /home/runner/work/shield/shield/src/Models/UserModel.php:183
2022-08-06T08:35:17.7286658Z /home/runner/work/shield/shield/tests/Unit/UserModelTest.php:194
2022-08-06T08:35:17.7286991Z 
2022-08-06T08:35:17.7287228Z 19) Tests\Controllers\MagicLinkTest::testAfterLoggedInNotAllowDisplayMagicLink
2022-08-06T08:35:17.7287819Z ErrorException: oci_execute(): ORA-00904: "DB_AUTH_IDENTITIES"."SECRET": invalid identifier
2022-08-06T08:35:17.7288045Z 
2022-08-06T08:35:17.7288262Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php:198
2022-08-06T08:35:17.7288714Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:693
2022-08-06T08:35:17.7289175Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:620
2022-08-06T08:35:17.7289625Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseBuilder.php:1585
2022-08-06T08:35:17.7290032Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:249
2022-08-06T08:35:17.7290443Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/BaseModel.php:622
2022-08-06T08:35:17.7290818Z /home/runner/work/shield/shield/src/Models/UserModel.php:183
2022-08-06T08:35:17.7291195Z /home/runner/work/shield/shield/src/Authentication/Authenticators/Session.php:287
2022-08-06T08:35:17.7291598Z /home/runner/work/shield/shield/src/Authentication/Authenticators/Session.php:103
2022-08-06T08:35:17.7291991Z /home/runner/work/shield/shield/src/Controllers/LoginController.php:46
2022-08-06T08:35:17.7292378Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:898
2022-08-06T08:35:17.7292855Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:457
2022-08-06T08:35:17.7293278Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:340
2022-08-06T08:35:17.7293713Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Test/FeatureTestTrait.php:189
2022-08-06T08:35:17.7294163Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Test/FeatureTestTrait.php:236
2022-08-06T08:35:17.7294585Z /home/runner/work/shield/shield/tests/Controllers/MagicLinkTest.php:42
2022-08-06T08:35:17.7294796Z 
2022-08-06T08:35:17.7295000Z 20) Tests\Authentication\Filters\TokenFilterTest::testFilterNotAuthorized
2022-08-06T08:35:17.7295563Z ErrorException: oci_execute(): ORA-01400: cannot insert NULL into ("ORACLE"."db_auth_token_logins"."identifier")
2022-08-06T08:35:17.7295814Z 
2022-08-06T08:35:17.7296027Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php:198
2022-08-06T08:35:17.7296489Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:693
2022-08-06T08:35:17.7296937Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:620
2022-08-06T08:35:17.7297391Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseBuilder.php:1916
2022-08-06T08:35:17.7297805Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:278
2022-08-06T08:35:17.7298211Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/BaseModel.php:738
2022-08-06T08:35:17.7298596Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:666
2022-08-06T08:35:17.7298966Z /home/runner/work/shield/shield/src/Models/LoginModel.php:64
2022-08-06T08:35:17.7299348Z /home/runner/work/shield/shield/src/Authentication/Authenticators/AccessTokens.php:54
2022-08-06T08:35:17.7299702Z /home/runner/work/shield/shield/src/Auth.php:90
2022-08-06T08:35:17.7300030Z /home/runner/work/shield/shield/src/Filters/TokenAuth.php:37
2022-08-06T08:35:17.7300412Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Filters/Filters.php:173
2022-08-06T08:35:17.7300816Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:431
2022-08-06T08:35:17.7301230Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:340
2022-08-06T08:35:17.7301725Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Test/FeatureTestTrait.php:189
2022-08-06T08:35:17.7302155Z /home/runner/work/shield/shield/tests/Authentication/Filters/TokenFilterTest.php:23
2022-08-06T08:35:17.7302388Z 
2022-08-06T08:35:17.7302576Z 21) Tests\Controllers\LoginTest::testLoginActionUsernameSuccess
2022-08-06T08:35:17.7303067Z ErrorException: oci_execute(): ORA-00904: "DB_USERS"."USERNAME": invalid identifier
2022-08-06T08:35:17.7303279Z 
2022-08-06T08:35:17.7303478Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php:198
2022-08-06T08:35:17.7303939Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:693
2022-08-06T08:35:17.7304399Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:620
2022-08-06T08:35:17.7304853Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseBuilder.php:1585
2022-08-06T08:35:17.7305273Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:249
2022-08-06T08:35:17.7305674Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/BaseModel.php:622
2022-08-06T08:35:17.7306048Z /home/runner/work/shield/shield/src/Models/UserModel.php:202
2022-08-06T08:35:17.7306405Z /home/runner/work/shield/shield/src/Authentication/Authenticators/Session.php:287
2022-08-06T08:35:17.7306806Z /home/runner/work/shield/shield/src/Authentication/Authenticators/Session.php:103
2022-08-06T08:35:17.7307203Z /home/runner/work/shield/shield/src/Controllers/LoginController.php:46
2022-08-06T08:35:17.7307686Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:898
2022-08-06T08:35:17.7308110Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:457
2022-08-06T08:35:17.7308523Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:340
2022-08-06T08:35:17.7308945Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Test/FeatureTestTrait.php:189
2022-08-06T08:35:17.7309392Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Test/FeatureTestTrait.php:236
2022-08-06T08:35:17.7309807Z /home/runner/work/shield/shield/tests/Controllers/LoginTest.php:136
2022-08-06T08:35:17.7310008Z 
2022-08-06T08:35:17.7310168Z 22) Tests\Controllers\LoginTest::testLoginBadEmail
2022-08-06T08:35:17.7310652Z ErrorException: oci_execute(): ORA-00904: "DB_AUTH_IDENTITIES"."SECRET": invalid identifier
2022-08-06T08:35:17.7310877Z 
2022-08-06T08:35:17.7311094Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php:198
2022-08-06T08:35:17.7311548Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:693
2022-08-06T08:35:17.7311980Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:620
2022-08-06T08:35:17.7312427Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseBuilder.php:1585
2022-08-06T08:35:17.7312847Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:249
2022-08-06T08:35:17.7313248Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/BaseModel.php:622
2022-08-06T08:35:17.7313624Z /home/runner/work/shield/shield/src/Models/UserModel.php:183
2022-08-06T08:35:17.7314001Z /home/runner/work/shield/shield/src/Authentication/Authenticators/Session.php:287
2022-08-06T08:35:17.7314400Z /home/runner/work/shield/shield/src/Authentication/Authenticators/Session.php:103
2022-08-06T08:35:17.7314778Z /home/runner/work/shield/shield/src/Controllers/LoginController.php:46
2022-08-06T08:35:17.7315186Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:898
2022-08-06T08:35:17.7315605Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:457
2022-08-06T08:35:17.7316017Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:340
2022-08-06T08:35:17.7316525Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Test/FeatureTestTrait.php:189
2022-08-06T08:35:17.7316975Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Test/FeatureTestTrait.php:236
2022-08-06T08:35:17.7317366Z /home/runner/work/shield/shield/tests/Controllers/LoginTest.php:46
2022-08-06T08:35:17.7317564Z 
2022-08-06T08:35:17.7317742Z 23) Tests\Controllers\LoginTest::testLoginActionEmailSuccess
2022-08-06T08:35:17.7318245Z ErrorException: oci_execute(): ORA-00904: "DB_AUTH_IDENTITIES"."SECRET": invalid identifier
2022-08-06T08:35:17.7318475Z 
2022-08-06T08:35:17.7318691Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php:198
2022-08-06T08:35:17.7319149Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:693
2022-08-06T08:35:17.7319994Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:620
2022-08-06T08:35:17.7320465Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseBuilder.php:1585
2022-08-06T08:35:17.7320871Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:249
2022-08-06T08:35:17.7321279Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/BaseModel.php:622
2022-08-06T08:35:17.7321799Z /home/runner/work/shield/shield/src/Models/UserModel.php:183
2022-08-06T08:35:17.7322182Z /home/runner/work/shield/shield/src/Authentication/Authenticators/Session.php:287
2022-08-06T08:35:17.7322680Z /home/runner/work/shield/shield/src/Authentication/Authenticators/Session.php:103
2022-08-06T08:35:17.7323080Z /home/runner/work/shield/shield/src/Controllers/LoginController.php:46
2022-08-06T08:35:17.7323467Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:898
2022-08-06T08:35:17.7323888Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:457
2022-08-06T08:35:17.7324306Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:340
2022-08-06T08:35:17.7324750Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Test/FeatureTestTrait.php:189
2022-08-06T08:35:17.7325202Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Test/FeatureTestTrait.php:236
2022-08-06T08:35:17.7325617Z /home/runner/work/shield/shield/tests/Controllers/LoginTest.php:75
2022-08-06T08:35:17.7325821Z 
2022-08-06T08:35:17.7326033Z 24) Tests\Controllers\LoginTest::testAfterLoggedInNotDisplayLoginPage
2022-08-06T08:35:17.7326580Z ErrorException: oci_execute(): ORA-00904: "DB_AUTH_IDENTITIES"."SECRET": invalid identifier
2022-08-06T08:35:17.7326816Z 
2022-08-06T08:35:17.7327030Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php:198
2022-08-06T08:35:17.7327482Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:693
2022-08-06T08:35:17.7327936Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:620
2022-08-06T08:35:17.7328384Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseBuilder.php:1585
2022-08-06T08:35:17.7328809Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:249
2022-08-06T08:35:17.7329213Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/BaseModel.php:622
2022-08-06T08:35:17.7329569Z /home/runner/work/shield/shield/src/Models/UserModel.php:183
2022-08-06T08:35:17.7329944Z /home/runner/work/shield/shield/src/Authentication/Authenticators/Session.php:287
2022-08-06T08:35:17.7330347Z /home/runner/work/shield/shield/src/Authentication/Authenticators/Session.php:103
2022-08-06T08:35:17.7330744Z /home/runner/work/shield/shield/src/Controllers/LoginController.php:46
2022-08-06T08:35:17.7331149Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:898
2022-08-06T08:35:17.7331640Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:457
2022-08-06T08:35:17.7332039Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:340
2022-08-06T08:35:17.7332475Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Test/FeatureTestTrait.php:189
2022-08-06T08:35:17.7332922Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Test/FeatureTestTrait.php:236
2022-08-06T08:35:17.7333331Z /home/runner/work/shield/shield/tests/Controllers/LoginTest.php:108
2022-08-06T08:35:17.7333535Z 
2022-08-06T08:35:17.7333744Z 25) Tests\Controllers\LoginTest::testLoginRedirectsToActionIfDefined
2022-08-06T08:35:17.7334274Z ErrorException: oci_execute(): ORA-00904: "DB_AUTH_IDENTITIES"."SECRET": invalid identifier
2022-08-06T08:35:17.7334497Z 
2022-08-06T08:35:17.7334711Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php:198
2022-08-06T08:35:17.7335150Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:693
2022-08-06T08:35:17.7335599Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:620
2022-08-06T08:35:17.7336043Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseBuilder.php:1585
2022-08-06T08:35:17.7336467Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:249
2022-08-06T08:35:17.7336867Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/BaseModel.php:622
2022-08-06T08:35:17.7337293Z /home/runner/work/shield/shield/src/Models/UserModel.php:183
2022-08-06T08:35:17.7337659Z /home/runner/work/shield/shield/src/Authentication/Authenticators/Session.php:287
2022-08-06T08:35:17.7338060Z /home/runner/work/shield/shield/src/Authentication/Authenticators/Session.php:103
2022-08-06T08:35:17.7338456Z /home/runner/work/shield/shield/src/Controllers/LoginController.php:46
2022-08-06T08:35:17.7338867Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:898
2022-08-06T08:35:17.7339286Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:457
2022-08-06T08:35:17.7339698Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:340
2022-08-06T08:35:17.7340132Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Test/FeatureTestTrait.php:189
2022-08-06T08:35:17.7340566Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Test/FeatureTestTrait.php:236
2022-08-06T08:35:17.7341210Z /home/runner/work/shield/shield/tests/Controllers/LoginTest.php:189
2022-08-06T08:35:17.7341418Z 
2022-08-06T08:35:17.7341626Z 26) Tests\Authentication\Filters\ChainFilterTest::testFilterNotAuthorized
2022-08-06T08:35:17.7342223Z ErrorException: oci_execute(): ORA-01400: cannot insert NULL into ("ORACLE"."db_auth_token_logins"."identifier")
2022-08-06T08:35:17.7342473Z 
2022-08-06T08:35:17.7342691Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php:198
2022-08-06T08:35:17.7343146Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:693
2022-08-06T08:35:17.7343600Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:620
2022-08-06T08:35:17.7344043Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseBuilder.php:1916
2022-08-06T08:35:17.7344458Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:278
2022-08-06T08:35:17.7344861Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/BaseModel.php:738
2022-08-06T08:35:17.7345260Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:666
2022-08-06T08:35:17.7345629Z /home/runner/work/shield/shield/src/Models/LoginModel.php:64
2022-08-06T08:35:17.7346011Z /home/runner/work/shield/shield/src/Authentication/Authenticators/AccessTokens.php:54
2022-08-06T08:35:17.7346568Z /home/runner/work/shield/shield/src/Authentication/Authenticators/AccessTokens.php:155
2022-08-06T08:35:17.7346926Z /home/runner/work/shield/shield/src/Auth.php:157
2022-08-06T08:35:17.7347257Z /home/runner/work/shield/shield/src/Filters/ChainAuth.php:41
2022-08-06T08:35:17.7347642Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Filters/Filters.php:173
2022-08-06T08:35:17.7348062Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:431
2022-08-06T08:35:17.7348474Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/CodeIgniter.php:340
2022-08-06T08:35:17.7348896Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Test/FeatureTestTrait.php:189
2022-08-06T08:35:17.7349327Z /home/runner/work/shield/shield/tests/Authentication/Filters/ChainFilterTest.php:23
2022-08-06T08:35:17.7349555Z 
2022-08-06T08:35:17.7349661Z --
2022-08-06T08:35:17.7349777Z 
2022-08-06T08:35:17.7349871Z There was 1 failure:
2022-08-06T08:35:17.7350006Z 
2022-08-06T08:35:17.7350311Z 1) Tests\Authentication\Authenticators\SessionAuthenticatorTest::testAttemptUserHavingSessionDataAttemptsAgain
2022-08-06T08:35:17.7351241Z Failed asserting that exception of type "ErrorException" matches expected exception "CodeIgniter\Shield\Exceptions\LogicException". Message was: "oci_execute(): ORA-00904: "DB_AUTH_IDENTITIES"."SECRET": invalid identifier" at
2022-08-06T08:35:17.7351863Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/OCI8/Connection.php:198
2022-08-06T08:35:17.7352374Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:693
2022-08-06T08:35:17.7352816Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseConnection.php:620
2022-08-06T08:35:17.7353266Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Database/BaseBuilder.php:1585
2022-08-06T08:35:17.7353685Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/Model.php:249
2022-08-06T08:35:17.7354087Z /home/runner/work/shield/shield/vendor/codeigniter4/framework/system/BaseModel.php:622
2022-08-06T08:35:17.7354455Z /home/runner/work/shield/shield/src/Models/UserModel.php:183
2022-08-06T08:35:17.7354826Z /home/runner/work/shield/shield/src/Authentication/Authenticators/Session.php:287
2022-08-06T08:35:17.7355212Z /home/runner/work/shield/shield/src/Authentication/Authenticators/Session.php:103
2022-08-06T08:35:17.7355653Z /home/runner/work/shield/shield/tests/Authentication/Authenticators/SessionAuthenticatorTest.php:369
2022-08-06T08:35:17.7355978Z .
2022-08-06T08:35:17.7356090Z 
2022-08-06T08:35:17.7356178Z ERRORS!
2022-08-06T08:35:17.7356419Z Tests: 183, Assertions: 372, Errors: 26, Failures: 1.

kenjis avatar Aug 06 '22 08:08 kenjis

All green, Do we need to list the databases that Shield supports in the documentation?

datamweb avatar Aug 30 '22 11:08 datamweb

Do we need to list the databases that Shield supports in the documentation?

It is better to have it. If you send a PR, please mention MySQL (InnoDB).

kenjis avatar Aug 30 '22 12:08 kenjis