Page MenuHomePhabricator
Create Task
Maniphest T117319

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

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

P2266 .env.ini
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

P2264 PDOException in Connection.php line 362
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))

P2265 QueryException in Connection.php line 624:
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

Related Objects

Event Timeline

tycho.tatitscheff created this task.Oct 31 2015, 2:25 PM
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 project: TCB-Team (now WMDE-TechWish). · View Herald TranscriptOct 31 2015, 2:25 PM
Restricted Application added a subscriber: Aklapper. · View Herald Transcript
tycho.tatitscheff added a comment.Oct 31 2015, 3:37 PM

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).

tycho.tatitscheff mentioned this in T117323: [Phragile] [Bug] Field 'closed_statuses' doesn't have a default value.Oct 31 2015, 4:41 PM
tycho.tatitscheff mentioned this in T117324: [Phragile] [Bug] Integrity constraint violation when editing sprint without touching `Ignore story point estimates`.Oct 31 2015, 4:46 PM
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 added a project: Phragile-1.1-release.
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 added a project: TCB-Team-Sprint-2016-01-06.Jan 6 2016, 11:06 AM
Tobi_WMDE_SW removed a project: TCB-Team-Sprint-2016-01-06.Jan 6 2016, 3:19 PM
Tobi_WMDE_SW moved this task from v1.1 Backlog (Q1/2016) to Sprint Ready on the Phragile board.Jan 6 2016, 3:53 PM
Tobi_WMDE_SW edited a custom field.
Tobi_WMDE_SW added a project: TCB-Team-Sprint-2016-01-13.Jan 13 2016, 10:14 AM
WMDE-Fisch claimed this task.Jan 15 2016, 10:41 AM
WMDE-Fisch moved this task from Backlog to Doing on the TCB-Team-Sprint-2016-01-13 board.
WMDE-Fisch added a comment.Jan 15 2016, 12:02 PM

PR: https://github.com/wmde/phragile/pull/177

WMDE-Fisch moved this task from Doing to Review on the TCB-Team-Sprint-2016-01-13 board.Jan 15 2016, 12:02 PM
Tobi_WMDE_SW moved this task from Sprint Ready to Work in progress on the Phragile board.Jan 15 2016, 3:50 PM
WMDE-leszek moved this task from Review to Done on the TCB-Team-Sprint-2016-01-13 board.Jan 19 2016, 11:50 AM
Tobi_WMDE_SW moved this task from Incoming to Work in progress (TCB) on the TCB-Team (now WMDE-TechWish) board.Jan 27 2016, 10:52 AM
Tobi_WMDE_SW closed this task as Resolved.Feb 1 2016, 2:54 PM
Tobi_WMDE_SW moved this task from Work in progress to Done on the Phragile board.
Tobi_WMDE_SW subscribed.
Tobi_WMDE_SW moved this task from Work in progress (TCB) to Done on the TCB-Team (now WMDE-TechWish) board.Mar 17 2016, 2:00 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits