Page MenuHomePhabricator

[Phragile] [Bug] Phragile does not produce a default value for 'conduit_certificate'
Closed, ResolvedPublic2 Estimated Story Points

Description

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

1APP_ENV=local
2APP_DEBUG=true
3APP_KEY=redacted-app-key-generated-by-artisan
4
5DB_HOST=localhost
6DB_DATABASE=phragile
7DB_USERNAME=redacted
8DB_PASSWORD=redacted
9
10CACHE_DRIVER=file
11SESSION_DRIVER=file
12
13# Phragile client ID from your Phabricator OAuth server
14OAUTH_CLIENT_ID="redacted-oauth-phid"
15# Phragile client secret from your Phabricator OAuth server
16OAUTH_CLIENT_SECRET="redacted-oauth-secret"
17
18PHABRICATOR_URL="http://redacted.phabricator.url/"
19
20# Name of your Phragile Bot user in your Phabricator instance
21PHRAGILE_BOT_NAME="phragile"
22# Conduit certificate of the Phragile Bot user
23PHRAGILE_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
26MANIPHEST_STORY_POINTS_FIELD=std:maniphest:REDACTED_COMPANY:story_points
27
28# The tag PHID that indicates whether a task is in review
29REVIEW_TAG_PHID=
30# Comma separated names of Phabricator user names that are allowed to create projects on Phragile
31PHRAGILE_ADMINS="redacted-user"
32
33# Optional: The URL of the project request task on Phabricator
34PROJECT_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

1in Connection.php line 362
2at 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
3at 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
4at 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
5at 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
6at 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
7at 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
8at 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
9at 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')
10at 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
11at 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
12at 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
13at 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
14at Model->performInsert(object(Builder), array()) in Model.php line 1485
15at Model->save() in Model.php line 529
16at Model::create(array('username' => 'readacted-user', 'phid' => 'PHID-USER-redacted')) in Model.php line 566
17at Model::firstOrCreate(array('username' => 'readacted-user', 'phid' => 'PHID-USER-redacted')) in SessionsController.php line 59
18at 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
19at SessionsController->authenticate('redacted-oauth-secret') in SessionsController.php line 21
20at SessionsController->login()
21at call_user_func_array(array(object(SessionsController), 'login'), array()) in Controller.php line 246
22at Controller->callAction('login', array()) in ControllerDispatcher.php line 162
23at ControllerDispatcher->call(object(SessionsController), object(Route), 'login') in ControllerDispatcher.php line 107
24at ControllerDispatcher->Illuminate\Routing\{closure}(object(Request))
25at call_user_func(object(Closure), object(Request)) in Pipeline.php line 141
26at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
27at call_user_func(object(Closure), object(Request)) in Pipeline.php line 101
28at Pipeline->then(object(Closure)) in ControllerDispatcher.php line 108
29at ControllerDispatcher->callWithinStack(object(SessionsController), object(Route), object(Request), 'login') in ControllerDispatcher.php line 67
30at ControllerDispatcher->dispatch(object(Route), object(Request), 'SessionsController', 'login') in Route.php line 204
31at Route->runWithCustomDispatcher(object(Request)) in Route.php line 134
32at Route->run(object(Request)) in Router.php line 701
33at Router->Illuminate\Routing\{closure}(object(Request))
34at call_user_func(object(Closure), object(Request)) in Pipeline.php line 141
35at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
36at call_user_func(object(Closure), object(Request)) in Pipeline.php line 101
37at Pipeline->then(object(Closure)) in Router.php line 703
38at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 670
39at Router->dispatchToRoute(object(Request)) in Router.php line 628
40at Router->dispatch(object(Request)) in Kernel.php line 214
41at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))
42at call_user_func(object(Closure), object(Request)) in Pipeline.php line 141
43at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in AllowAnyProxy.php line 17
44at AllowAnyProxy->handle(object(Request), object(Closure)) in Pipeline.php line 125
45at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in VerifyCsrfToken.php line 43
46at VerifyCsrfToken->handle(object(Request), object(Closure)) in VerifyCsrfToken.php line 17
47at VerifyCsrfToken->handle(object(Request), object(Closure)) in Pipeline.php line 125
48at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in ShareErrorsFromSession.php line 55
49at ShareErrorsFromSession->handle(object(Request), object(Closure)) in Pipeline.php line 125
50at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in StartSession.php line 61
51at StartSession->handle(object(Request), object(Closure)) in Pipeline.php line 125
52at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 36
53at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in Pipeline.php line 125
54at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in EncryptCookies.php line 40
55at EncryptCookies->handle(object(Request), object(Closure)) in Pipeline.php line 125
56at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in CheckForMaintenanceMode.php line 42
57at CheckForMaintenanceMode->handle(object(Request), object(Closure)) in Pipeline.php line 125
58at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
59at call_user_func(object(Closure), object(Request)) in Pipeline.php line 101
60at Pipeline->then(object(Closure)) in Kernel.php line 115
61at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 84
62at 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))

1in Connection.php line 624
2at 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
3at 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
4at 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
5at 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
6at 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
7at 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')
8at 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
9at 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
10at 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
11at 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
12at Model->performInsert(object(Builder), array()) in Model.php line 1485
13at Model->save() in Model.php line 529
14at Model::create(array('username' => 'redacted-user', 'phid' => 'PHID-USER-readacted')) in Model.php line 566
15at Model::firstOrCreate(array('username' => 'redacted-user', 'phid' => 'PHID-USER-readacted')) in SessionsController.php line 59
16at 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
17at SessionsController->authenticate('redacted-oauth-secret') in SessionsController.php line 21
18at SessionsController->login()
19at call_user_func_array(array(object(SessionsController), 'login'), array()) in Controller.php line 246
20at Controller->callAction('login', array()) in ControllerDispatcher.php line 162
21at ControllerDispatcher->call(object(SessionsController), object(Route), 'login') in ControllerDispatcher.php line 107
22at ControllerDispatcher->Illuminate\Routing\{closure}(object(Request))
23at call_user_func(object(Closure), object(Request)) in Pipeline.php line 141
24at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
25at call_user_func(object(Closure), object(Request)) in Pipeline.php line 101
26at Pipeline->then(object(Closure)) in ControllerDispatcher.php line 108
27at ControllerDispatcher->callWithinStack(object(SessionsController), object(Route), object(Request), 'login') in ControllerDispatcher.php line 67
28at ControllerDispatcher->dispatch(object(Route), object(Request), 'SessionsController', 'login') in Route.php line 204
29at Route->runWithCustomDispatcher(object(Request)) in Route.php line 134
30at Route->run(object(Request)) in Router.php line 701
31at Router->Illuminate\Routing\{closure}(object(Request))
32at call_user_func(object(Closure), object(Request)) in Pipeline.php line 141
33at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
34at call_user_func(object(Closure), object(Request)) in Pipeline.php line 101
35at Pipeline->then(object(Closure)) in Router.php line 703
36at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 670
37at Router->dispatchToRoute(object(Request)) in Router.php line 628
38at Router->dispatch(object(Request)) in Kernel.php line 214
39at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))
40at call_user_func(object(Closure), object(Request)) in Pipeline.php line 141
41at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in AllowAnyProxy.php line 17
42at AllowAnyProxy->handle(object(Request), object(Closure)) in Pipeline.php line 125
43at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in VerifyCsrfToken.php line 43
44at VerifyCsrfToken->handle(object(Request), object(Closure)) in VerifyCsrfToken.php line 17
45at VerifyCsrfToken->handle(object(Request), object(Closure)) in Pipeline.php line 125
46at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in ShareErrorsFromSession.php line 55
47at ShareErrorsFromSession->handle(object(Request), object(Closure)) in Pipeline.php line 125
48at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in StartSession.php line 61
49at StartSession->handle(object(Request), object(Closure)) in Pipeline.php line 125
50at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 36
51at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in Pipeline.php line 125
52at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in EncryptCookies.php line 40
53at EncryptCookies->handle(object(Request), object(Closure)) in Pipeline.php line 125
54at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in CheckForMaintenanceMode.php line 42
55at CheckForMaintenanceMode->handle(object(Request), object(Closure)) in Pipeline.php line 125
56at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
57at call_user_func(object(Closure), object(Request)) in Pipeline.php line 101
58at Pipeline->then(object(Closure)) in Kernel.php line 115
59at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 84
60at Kernel->handle(object(Request)) in index.php line 53

Event Timeline

tycho.tatitscheff raised the priority of this task from to Needs Triage.
tycho.tatitscheff updated the task description. (Show Details)
tycho.tatitscheff added a project: Phragile.
tycho.tatitscheff subscribed.
Restricted Application added a subscriber: Aklapper. · View Herald Transcript

i manage to do it in sql letting the certificate for conduit_certificat.
Maybe could we default it to "" and set later (or let the user set it : big warning until he navigate to certificate and paste it).

Tobi_WMDE_SW renamed this task from Phragile does not produce a default value for 'conduit_certificate' to [Phragile] [Bug] Phragile does not produce a default value for 'conduit_certificate'.Nov 18 2015, 2:33 PM
Tobi_WMDE_SW triaged this task as High priority.
Tobi_WMDE_SW set Security to None.
Tobi_WMDE_SW moved this task from Incoming to v1.1 Backlog (Q1/2016) on the Phragile board.
Tobi_WMDE_SW added a subscriber: Jakob_WMDE.
Tobi_WMDE_SW moved this task from Work in progress to Done on the Phragile board.
Tobi_WMDE_SW subscribed.