{"id":806543,"url":"http://patchwork.ozlabs.org/api/1.0/patches/806543/?format=json","project":{"id":16,"url":"http://patchwork.ozlabs.org/api/1.0/projects/16/?format=json","name":"Patchwork","link_name":"patchwork","list_id":"patchwork.lists.ozlabs.org","list_email":"patchwork@lists.ozlabs.org","web_url":"http://jk.ozlabs.org/projects/patchwork/","scm_url":"git://github.com/getpatchwork/patchwork","webscm_url":"https://github.com/getpatchwork/patchwork"},"msgid":"<1503920358-26652-2-git-send-email-jk@ozlabs.org>","date":"2017-08-28T11:39:18","name":"[2/2] lib/sql: fix permissions for v2.0.0 on postgres","commit_ref":null,"pull_url":null,"state":"accepted","archived":false,"hash":"4098f51d821130126917c96f96ed7130eeef98a2","submitter":{"id":1,"url":"http://patchwork.ozlabs.org/api/1.0/people/1/?format=json","name":"Jeremy Kerr","email":"jk@ozlabs.org"},"delegate":null,"mbox":"http://patchwork.ozlabs.org/project/patchwork/patch/1503920358-26652-2-git-send-email-jk@ozlabs.org/mbox/","series":[{"id":144,"url":"http://patchwork.ozlabs.org/api/1.0/series/144/?format=json","date":"2017-08-28T11:39:17","name":"[1/2] tests: Run FuzzTest within a transaction","version":1,"mbox":"http://patchwork.ozlabs.org/series/144/mbox/"}],"check":"pending","checks":"http://patchwork.ozlabs.org/api/patches/806543/checks/","tags":{},"headers":{"Return-Path":"","X-Original-To":["incoming@patchwork.ozlabs.org","patchwork@lists.ozlabs.org"],"Delivered-To":["patchwork-incoming@bilbo.ozlabs.org","patchwork@lists.ozlabs.org"],"Received":["from lists.ozlabs.org (lists.ozlabs.org [103.22.144.68])\n\t(using TLSv1.2 with cipher ADH-AES256-GCM-SHA384 (256/256 bits))\n\t(No client certificate requested)\n\tby ozlabs.org (Postfix) with ESMTPS id 3xgqZM51tlz9sD9\n\tfor ;\n\tMon, 28 Aug 2017 21:40:11 +1000 (AEST)","from lists.ozlabs.org (lists.ozlabs.org [IPv6:2401:3900:2:1::3])\n\tby lists.ozlabs.org (Postfix) with ESMTP id 3xgqZM3qzdzDqBd\n\tfor ;\n\tMon, 28 Aug 2017 21:40:11 +1000 (AEST)","from ozlabs.org (bilbo.ozlabs.org [103.22.144.67])\n\t(using TLSv1.2 with cipher ADH-AES256-GCM-SHA384 (256/256 bits))\n\t(No client certificate requested)\n\tby lists.ozlabs.org (Postfix) with ESMTPS id 3xgqYw5ykKzDq77\n\tfor ;\n\tMon, 28 Aug 2017 21:39:48 +1000 (AEST)","by ozlabs.org (Postfix, from userid 1023)\n\tid 3xgqYw5454z9sD9; Mon, 28 Aug 2017 21:39:48 +1000 (AEST)"],"Authentication-Results":["ozlabs.org;\n\tdkim=fail reason=\"signature verification failed\" (2048-bit key;\n\tsecure) header.d=ozlabs.org header.i=@ozlabs.org header.b=\"DoNvx7Xa\";\n\tdkim-atps=neutral","lists.ozlabs.org;\n\tdkim=fail reason=\"signature verification failed\" (2048-bit key;\n\tsecure) header.d=ozlabs.org header.i=@ozlabs.org header.b=\"DoNvx7Xa\";\n\tdkim-atps=neutral","lists.ozlabs.org; dkim=pass (2048-bit key;\n\tsecure) header.d=ozlabs.org header.i=@ozlabs.org header.b=\"DoNvx7Xa\"; \n\tdkim-atps=neutral"],"DKIM-Signature":"v=1; a=rsa-sha256; c=relaxed/simple; d=ozlabs.org; s=201707; \n\tt=1503920388; bh=q07SyA5h5ynF4e731xl14ImbB9jPxjskqMBLAfPwk1o=;\n\th=From:To:Subject:Date:In-Reply-To:References:From;\n\tb=DoNvx7Xae51tmIkRORh0GxQFmQNsUwBzwtHLXXn44wMKd+pv+zA3xpvKD+kGi0AqZ\n\tSfwepsx/ksh9lyua1tYkuAZVNCbsNILk2sid5K2ucXR0A6yOIJO52YqIrLRWaXZF81\n\tQ3kETppcn7TXVyu5qAreu1zDR1rTpoYFtf7usbvejjTGQdAIAhmt7TzMVca4JECDAH\n\tKYQBIR+cLfioXiOmGXCcJuXD3SQcgwXkPwKuoS9LijDVjczSSID6pV2KDIPSvdhkYm\n\tj0cJsSZ2Sr7eryuEefKe3/VkqvYwufvuA2/8/BJYAGMqTh+DVlXojTM414/d80rP2V\n\tH94J2iwFcM60Q==","From":"Jeremy Kerr ","To":"patchwork@lists.ozlabs.org","Subject":"[PATCH 2/2] lib/sql: fix permissions for v2.0.0 on postgres","Date":"Mon, 28 Aug 2017 19:39:18 +0800","Message-Id":"<1503920358-26652-2-git-send-email-jk@ozlabs.org>","X-Mailer":"git-send-email 2.7.4","In-Reply-To":"<1503920358-26652-1-git-send-email-jk@ozlabs.org>","References":"<1503920358-26652-1-git-send-email-jk@ozlabs.org>","X-BeenThere":"patchwork@lists.ozlabs.org","X-Mailman-Version":"2.1.23","Precedence":"list","List-Id":"Patchwork development ","List-Unsubscribe":",\n\t","List-Archive":"","List-Post":"","List-Help":"","List-Subscribe":",\n\t","MIME-Version":"1.0","Content-Type":"text/plain; charset=\"utf-8\"","Content-Transfer-Encoding":"base64","Errors-To":"patchwork-bounces+incoming=patchwork.ozlabs.org@lists.ozlabs.org","Sender":"\"Patchwork\"\n\t"},"content":"Some tables are no longer present, and others that are used by the web\ninterface and mail parser need access permissions added.\n\nThis change was required to get patchwork going on patchwork.ozlabs.org;\nthere may be other permissions required, that we haven't hit yet. So,\nsome review would be good here.\n\nAlso: it's unlikely that we need DELETE for the mail parser, but I'm not\nconfident enough to remove that at the moment.\n\nSigned-off-by: Jeremy Kerr \n---\n lib/sql/grant-all.postgres.sql | 17 ++++++++---------\n 1 file changed, 8 insertions(+), 9 deletions(-)","diff":"diff --git a/lib/sql/grant-all.postgres.sql b/lib/sql/grant-all.postgres.sql\nindex 405ba44..c709866 100644\n--- a/lib/sql/grant-all.postgres.sql\n+++ b/lib/sql/grant-all.postgres.sql\n@@ -12,6 +12,7 @@ GRANT SELECT, UPDATE, INSERT, DELETE ON\n \tauth_group,\n \tauth_user_user_permissions,\n \tauth_permission,\n+\tauthtoken_token,\n \tpatchwork_emailconfirmation,\n \tpatchwork_state,\n \tpatchwork_comment,\n@@ -47,9 +48,7 @@ GRANT SELECT, UPDATE ON\n \tpatchwork_bundle_id_seq,\n \tpatchwork_bundlepatch_id_seq,\n \tpatchwork_comment_id_seq,\n-\tpatchwork_submission_id_seq,\n \tpatchwork_patch_id_seq,\n-\tpatchwork_coverletter_id_seq,\n \tpatchwork_series_id_seq,\n \tpatchwork_seriespatch_id_seq,\n \tpatchwork_seriesreference_id_seq,\n@@ -69,16 +68,17 @@ TO \"www-data\";\n -- cover letters) and series\n GRANT INSERT, SELECT ON\n \tpatchwork_submission,\n-\tpatchwork_patch,\n \tpatchwork_coverletter,\n-\tpatchwork_series,\n \tpatchwork_seriespatch,\n \tpatchwork_seriesreference,\n \tpatchwork_comment,\n-\tpatchwork_person\n+\tpatchwork_event\n TO \"nobody\";\n GRANT INSERT, SELECT, UPDATE, DELETE ON\n-\tpatchwork_patchtag\n+\tpatchwork_patchtag,\n+\tpatchwork_patch,\n+\tpatchwork_series,\n+\tpatchwork_person\n TO \"nobody\";\n GRANT SELECT ON\n \tpatchwork_project,\n@@ -87,15 +87,14 @@ GRANT SELECT ON\n \tpatchwork_delegationrule\n TO \"nobody\";\n GRANT UPDATE, SELECT ON\n-\tpatchwork_submission_id_seq,\n \tpatchwork_patch_id_seq,\n-\tpatchwork_coverletter_id_seq,\n \tpatchwork_series_id_seq,\n \tpatchwork_seriespatch_id_seq,\n \tpatchwork_seriesreference_id_seq,\n \tpatchwork_person_id_seq,\n \tpatchwork_comment_id_seq,\n-\tpatchwork_patchtag_id_seq\n+\tpatchwork_patchtag_id_seq,\n+\tpatchwork_event_id_seq\n TO \"nobody\";\n \n COMMIT;\n","prefixes":["2/2"]}