When trying to connect I get two exceptions (debug mode) which look the same.
I was just installing phragile on latest HEAD for phragile and phabricator.
my .env looks like
1 | APP_ENV=local |
---|---|
2 | APP_DEBUG=true |
3 | APP_KEY=redacted-app-key-generated-by-artisan |
4 | |
5 | DB_HOST=localhost |
6 | DB_DATABASE=phragile |
7 | DB_USERNAME=redacted |
8 | DB_PASSWORD=redacted |
9 | |
10 | CACHE_DRIVER=file |
11 | SESSION_DRIVER=file |
12 | |
13 | # Phragile client ID from your Phabricator OAuth server |
14 | OAUTH_CLIENT_ID="redacted-oauth-phid" |
15 | # Phragile client secret from your Phabricator OAuth server |
16 | OAUTH_CLIENT_SECRET="redacted-oauth-secret" |
17 | |
18 | PHABRICATOR_URL="http://redacted.phabricator.url/" |
19 | |
20 | # Name of your Phragile Bot user in your Phabricator instance |
21 | PHRAGILE_BOT_NAME="phragile" |
22 | # Conduit certificate of the Phragile Bot user |
23 | PHRAGILE_BOT_CERTIFICATE="redacted-hundred-caracter-long-full-certificate-ie-not-just-a-conduit-token" |
24 | |
25 | # Name of your custom field for story points in Maniphest |
26 | MANIPHEST_STORY_POINTS_FIELD=std:maniphest:REDACTED_COMPANY:story_points |
27 | |
28 | # The tag PHID that indicates whether a task is in review |
29 | REVIEW_TAG_PHID= |
30 | # Comma separated names of Phabricator user names that are allowed to create projects on Phragile |
31 | PHRAGILE_ADMINS="redacted-user" |
32 | |
33 | # Optional: The URL of the project request task on Phabricator |
34 | PROJECT_REQUEST_URL= |
I haven't yet configure REVIEW_TAG_PHID nor PROJECT_REQUEST_UR (i don't know what to put in yet : a project PHID, a column one ?) but it should'nt block login, should it ?
PDOException in Connection.php line 362: SQLSTATE[HY000]: General error: 1364 Field 'conduit_certificate' doesn't have a default value
1 | in Connection.php line 362 |
---|---|
2 | at PDOStatement->execute(array('readacted-user', 'PHID-USER-redacted', '2015-10-31 13:51:36', '2015-10-31 13:51:36')) in Connection.php line 362 |
3 | at Connection->Illuminate\Database\{closure}(object(MySqlConnection), 'insert into `users` (`username`, `phid`, `updated_at`, `created_at`) values (?, ?, ?, ?)', array('readacted-user', 'PHID-USER-redacted', '2015-10-31 13:51:36', '2015-10-31 13:51:36')) in Connection.php line 616 |
4 | at Connection->runQueryCallback('insert into `users` (`username`, `phid`, `updated_at`, `created_at`) values (?, ?, ?, ?)', array('readacted-user', 'PHID-USER-redacted', '2015-10-31 13:51:36', '2015-10-31 13:51:36'), object(Closure)) in Connection.php line 580 |
5 | at Connection->run('insert into `users` (`username`, `phid`, `updated_at`, `created_at`) values (?, ?, ?, ?)', array('readacted-user', 'PHID-USER-redacted', '2015-10-31 13:51:36', '2015-10-31 13:51:36'), object(Closure)) in Connection.php line 363 |
6 | at Connection->statement('insert into `users` (`username`, `phid`, `updated_at`, `created_at`) values (?, ?, ?, ?)', array('readacted-user', 'PHID-USER-redacted', '2015-10-31 13:51:36', '2015-10-31 13:51:36')) in Connection.php line 320 |
7 | at Connection->insert('insert into `users` (`username`, `phid`, `updated_at`, `created_at`) values (?, ?, ?, ?)', array('readacted-user', 'PHID-USER-redacted', '2015-10-31 13:51:36', '2015-10-31 13:51:36')) in Processor.php line 30 |
8 | at Processor->processInsertGetId(object(Builder), 'insert into `users` (`username`, `phid`, `updated_at`, `created_at`) values (?, ?, ?, ?)', array('readacted-user', 'PHID-USER-redacted', '2015-10-31 13:51:36', '2015-10-31 13:51:36'), 'id') in Builder.php line 1725 |
9 | at Builder->insertGetId(array('username' => 'readacted-user', 'phid' => 'PHID-USER-redacted', 'updated_at' => '2015-10-31 13:51:36', 'created_at' => '2015-10-31 13:51:36'), 'id') |
10 | at call_user_func_array(array(object(Builder), 'insertGetId'), array(array('username' => 'readacted-user', 'phid' => 'PHID-USER-redacted', 'updated_at' => '2015-10-31 13:51:36', 'created_at' => '2015-10-31 13:51:36'), 'id')) in Builder.php line 933 |
11 | at Builder->__call('insertGetId', array(array('username' => 'readacted-user', 'phid' => 'PHID-USER-redacted', 'updated_at' => '2015-10-31 13:51:36', 'created_at' => '2015-10-31 13:51:36'), 'id')) in Model.php line 1609 |
12 | at Builder->insertGetId(array('username' => 'readacted-user', 'phid' => 'PHID-USER-redacted', 'updated_at' => '2015-10-31 13:51:36', 'created_at' => '2015-10-31 13:51:36'), 'id') in Model.php line 1609 |
13 | at Model->insertAndSetId(object(Builder), array('username' => 'readacted-user', 'phid' => 'PHID-USER-redacted', 'updated_at' => '2015-10-31 13:51:36', 'created_at' => '2015-10-31 13:51:36')) in Model.php line 1579 |
14 | at Model->performInsert(object(Builder), array()) in Model.php line 1485 |
15 | at Model->save() in Model.php line 529 |
16 | at Model::create(array('username' => 'readacted-user', 'phid' => 'PHID-USER-redacted')) in Model.php line 566 |
17 | at Model::firstOrCreate(array('username' => 'readacted-user', 'phid' => 'PHID-USER-redacted')) in SessionsController.php line 59 |
18 | at SessionsController->loginAndRedirect(array('phid' => 'PHID-USER-redacted', 'userName' => 'readacted-user', 'realName' => 'James Bond', 'image' => 'http://redacted.phabricator.url/file/data/redacted/PHID-FILE-redacted/profile', 'uri' => 'http://redacted.phabricator.url/p/readacted-user/', 'roles' => array('admin', 'unverified', 'approved', 'activated'), 'primaryEmail' => null)) in SessionsController.php line 48 |
19 | at SessionsController->authenticate('redacted-oauth-secret') in SessionsController.php line 21 |
20 | at SessionsController->login() |
21 | at call_user_func_array(array(object(SessionsController), 'login'), array()) in Controller.php line 246 |
22 | at Controller->callAction('login', array()) in ControllerDispatcher.php line 162 |
23 | at ControllerDispatcher->call(object(SessionsController), object(Route), 'login') in ControllerDispatcher.php line 107 |
24 | at ControllerDispatcher->Illuminate\Routing\{closure}(object(Request)) |
25 | at call_user_func(object(Closure), object(Request)) in Pipeline.php line 141 |
26 | at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) |
27 | at call_user_func(object(Closure), object(Request)) in Pipeline.php line 101 |
28 | at Pipeline->then(object(Closure)) in ControllerDispatcher.php line 108 |
29 | at ControllerDispatcher->callWithinStack(object(SessionsController), object(Route), object(Request), 'login') in ControllerDispatcher.php line 67 |
30 | at ControllerDispatcher->dispatch(object(Route), object(Request), 'SessionsController', 'login') in Route.php line 204 |
31 | at Route->runWithCustomDispatcher(object(Request)) in Route.php line 134 |
32 | at Route->run(object(Request)) in Router.php line 701 |
33 | at Router->Illuminate\Routing\{closure}(object(Request)) |
34 | at call_user_func(object(Closure), object(Request)) in Pipeline.php line 141 |
35 | at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) |
36 | at call_user_func(object(Closure), object(Request)) in Pipeline.php line 101 |
37 | at Pipeline->then(object(Closure)) in Router.php line 703 |
38 | at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 670 |
39 | at Router->dispatchToRoute(object(Request)) in Router.php line 628 |
40 | at Router->dispatch(object(Request)) in Kernel.php line 214 |
41 | at Kernel->Illuminate\Foundation\Http\{closure}(object(Request)) |
42 | at call_user_func(object(Closure), object(Request)) in Pipeline.php line 141 |
43 | at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in AllowAnyProxy.php line 17 |
44 | at AllowAnyProxy->handle(object(Request), object(Closure)) in Pipeline.php line 125 |
45 | at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in VerifyCsrfToken.php line 43 |
46 | at VerifyCsrfToken->handle(object(Request), object(Closure)) in VerifyCsrfToken.php line 17 |
47 | at VerifyCsrfToken->handle(object(Request), object(Closure)) in Pipeline.php line 125 |
48 | at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in ShareErrorsFromSession.php line 55 |
49 | at ShareErrorsFromSession->handle(object(Request), object(Closure)) in Pipeline.php line 125 |
50 | at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in StartSession.php line 61 |
51 | at StartSession->handle(object(Request), object(Closure)) in Pipeline.php line 125 |
52 | at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 36 |
53 | at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in Pipeline.php line 125 |
54 | at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in EncryptCookies.php line 40 |
55 | at EncryptCookies->handle(object(Request), object(Closure)) in Pipeline.php line 125 |
56 | at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in CheckForMaintenanceMode.php line 42 |
57 | at CheckForMaintenanceMode->handle(object(Request), object(Closure)) in Pipeline.php line 125 |
58 | at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) |
59 | at call_user_func(object(Closure), object(Request)) in Pipeline.php line 101 |
60 | at Pipeline->then(object(Closure)) in Kernel.php line 115 |
61 | at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 84 |
62 | at Kernel->handle(object(Request)) in index.php line 53 |
QueryException in Connection.php line 624: SQLSTATE[HY000]: General error: 1364 Field 'conduit_certificate' doesn't have a default value (SQL: insert into users (username, phid, updated_at, created_at) values (redacted-user, PHID-USER-redacted, 2015-10-31 13:51:36, 2015-10-31 13:51:36))
1 | in Connection.php line 624 |
---|---|
2 | at Connection->runQueryCallback('insert into `users` (`username`, `phid`, `updated_at`, `created_at`) values (?, ?, ?, ?)', array('redacted-user', 'PHID-USER-readacted', '2015-10-31 13:51:36', '2015-10-31 13:51:36'), object(Closure)) in Connection.php line 580 |
3 | at Connection->run('insert into `users` (`username`, `phid`, `updated_at`, `created_at`) values (?, ?, ?, ?)', array('redacted-user', 'PHID-USER-readacted', '2015-10-31 13:51:36', '2015-10-31 13:51:36'), object(Closure)) in Connection.php line 363 |
4 | at Connection->statement('insert into `users` (`username`, `phid`, `updated_at`, `created_at`) values (?, ?, ?, ?)', array('redacted-user', 'PHID-USER-readacted', '2015-10-31 13:51:36', '2015-10-31 13:51:36')) in Connection.php line 320 |
5 | at Connection->insert('insert into `users` (`username`, `phid`, `updated_at`, `created_at`) values (?, ?, ?, ?)', array('redacted-user', 'PHID-USER-readacted', '2015-10-31 13:51:36', '2015-10-31 13:51:36')) in Processor.php line 30 |
6 | at Processor->processInsertGetId(object(Builder), 'insert into `users` (`username`, `phid`, `updated_at`, `created_at`) values (?, ?, ?, ?)', array('redacted-user', 'PHID-USER-readacted', '2015-10-31 13:51:36', '2015-10-31 13:51:36'), 'id') in Builder.php line 1725 |
7 | at Builder->insertGetId(array('username' => 'redacted-user', 'phid' => 'PHID-USER-readacted', 'updated_at' => '2015-10-31 13:51:36', 'created_at' => '2015-10-31 13:51:36'), 'id') |
8 | at call_user_func_array(array(object(Builder), 'insertGetId'), array(array('username' => 'redacted-user', 'phid' => 'PHID-USER-readacted', 'updated_at' => '2015-10-31 13:51:36', 'created_at' => '2015-10-31 13:51:36'), 'id')) in Builder.php line 933 |
9 | at Builder->__call('insertGetId', array(array('username' => 'redacted-user', 'phid' => 'PHID-USER-readacted', 'updated_at' => '2015-10-31 13:51:36', 'created_at' => '2015-10-31 13:51:36'), 'id')) in Model.php line 1609 |
10 | at Builder->insertGetId(array('username' => 'redacted-user', 'phid' => 'PHID-USER-readacted', 'updated_at' => '2015-10-31 13:51:36', 'created_at' => '2015-10-31 13:51:36'), 'id') in Model.php line 1609 |
11 | at Model->insertAndSetId(object(Builder), array('username' => 'redacted-user', 'phid' => 'PHID-USER-readacted', 'updated_at' => '2015-10-31 13:51:36', 'created_at' => '2015-10-31 13:51:36')) in Model.php line 1579 |
12 | at Model->performInsert(object(Builder), array()) in Model.php line 1485 |
13 | at Model->save() in Model.php line 529 |
14 | at Model::create(array('username' => 'redacted-user', 'phid' => 'PHID-USER-readacted')) in Model.php line 566 |
15 | at Model::firstOrCreate(array('username' => 'redacted-user', 'phid' => 'PHID-USER-readacted')) in SessionsController.php line 59 |
16 | at SessionsController->loginAndRedirect(array('phid' => 'PHID-USER-readacted', 'userName' => 'redacted-user', 'realName' => 'James Bond', 'image' => 'http://redacted.phabrictor.url/file/data/readacted/PHID-FILE-redacted/profile', 'uri' => 'http://redacted.phabrictor.url/p/redacted-user/', 'roles' => array('admin', 'unverified', 'approved', 'activated'), 'primaryEmail' => null)) in SessionsController.php line 48 |
17 | at SessionsController->authenticate('redacted-oauth-secret') in SessionsController.php line 21 |
18 | at SessionsController->login() |
19 | at call_user_func_array(array(object(SessionsController), 'login'), array()) in Controller.php line 246 |
20 | at Controller->callAction('login', array()) in ControllerDispatcher.php line 162 |
21 | at ControllerDispatcher->call(object(SessionsController), object(Route), 'login') in ControllerDispatcher.php line 107 |
22 | at ControllerDispatcher->Illuminate\Routing\{closure}(object(Request)) |
23 | at call_user_func(object(Closure), object(Request)) in Pipeline.php line 141 |
24 | at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) |
25 | at call_user_func(object(Closure), object(Request)) in Pipeline.php line 101 |
26 | at Pipeline->then(object(Closure)) in ControllerDispatcher.php line 108 |
27 | at ControllerDispatcher->callWithinStack(object(SessionsController), object(Route), object(Request), 'login') in ControllerDispatcher.php line 67 |
28 | at ControllerDispatcher->dispatch(object(Route), object(Request), 'SessionsController', 'login') in Route.php line 204 |
29 | at Route->runWithCustomDispatcher(object(Request)) in Route.php line 134 |
30 | at Route->run(object(Request)) in Router.php line 701 |
31 | at Router->Illuminate\Routing\{closure}(object(Request)) |
32 | at call_user_func(object(Closure), object(Request)) in Pipeline.php line 141 |
33 | at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) |
34 | at call_user_func(object(Closure), object(Request)) in Pipeline.php line 101 |
35 | at Pipeline->then(object(Closure)) in Router.php line 703 |
36 | at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 670 |
37 | at Router->dispatchToRoute(object(Request)) in Router.php line 628 |
38 | at Router->dispatch(object(Request)) in Kernel.php line 214 |
39 | at Kernel->Illuminate\Foundation\Http\{closure}(object(Request)) |
40 | at call_user_func(object(Closure), object(Request)) in Pipeline.php line 141 |
41 | at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in AllowAnyProxy.php line 17 |
42 | at AllowAnyProxy->handle(object(Request), object(Closure)) in Pipeline.php line 125 |
43 | at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in VerifyCsrfToken.php line 43 |
44 | at VerifyCsrfToken->handle(object(Request), object(Closure)) in VerifyCsrfToken.php line 17 |
45 | at VerifyCsrfToken->handle(object(Request), object(Closure)) in Pipeline.php line 125 |
46 | at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in ShareErrorsFromSession.php line 55 |
47 | at ShareErrorsFromSession->handle(object(Request), object(Closure)) in Pipeline.php line 125 |
48 | at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in StartSession.php line 61 |
49 | at StartSession->handle(object(Request), object(Closure)) in Pipeline.php line 125 |
50 | at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 36 |
51 | at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in Pipeline.php line 125 |
52 | at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in EncryptCookies.php line 40 |
53 | at EncryptCookies->handle(object(Request), object(Closure)) in Pipeline.php line 125 |
54 | at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in CheckForMaintenanceMode.php line 42 |
55 | at CheckForMaintenanceMode->handle(object(Request), object(Closure)) in Pipeline.php line 125 |
56 | at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) |
57 | at call_user_func(object(Closure), object(Request)) in Pipeline.php line 101 |
58 | at Pipeline->then(object(Closure)) in Kernel.php line 115 |
59 | at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 84 |
60 | at Kernel->handle(object(Request)) in index.php line 53 |