)]}'
{"/COMMIT_MSG":[{"author":{"_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},"change_message_id":"f2145e909e4d3408745902eebf4a37fee654adae","unresolved":false,"context_lines":[{"line_number":4,"context_line":"Commit:     zenkuro \u003czenkuro@protonmail.com\u003e"},{"line_number":5,"context_line":"CommitDate: 2020-02-28 20:30:41 +0200"},{"line_number":6,"context_line":""},{"line_number":7,"context_line":"This patch extends zuul deployment from scratch documentation."},{"line_number":8,"context_line":"    it adds guide on MySQL setup"},{"line_number":9,"context_line":"    it extends zuul-from-scratch setup by adding mysql connection to zuul.conf file"},{"line_number":10,"context_line":"    it extends gerrit setup by adding Verified label to gerrit"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":1,"id":"1fa4df85_cb5e6e11","line":7,"updated":"2020-02-28 18:44:36.000000000","message":"Typically you\u0027ll want to format commit messages with a blank line between the title line and the body. A bunch of tools assume this formatting.","commit_id":"d09b1ec1dcb4bbcb30d3d14e21fe00a377914a1e"},{"author":{"_account_id":31654,"name":"Zen Kurosaky","email":"zenkuro@protonmail.com","username":"zenkuro"},"change_message_id":"49a2b5109b3fa40f253885ac3e89c1028bb9c24c","unresolved":false,"context_lines":[{"line_number":4,"context_line":"Commit:     zenkuro \u003czenkuro@protonmail.com\u003e"},{"line_number":5,"context_line":"CommitDate: 2020-02-28 20:30:41 +0200"},{"line_number":6,"context_line":""},{"line_number":7,"context_line":"This patch extends zuul deployment from scratch documentation."},{"line_number":8,"context_line":"    it adds guide on MySQL setup"},{"line_number":9,"context_line":"    it extends zuul-from-scratch setup by adding mysql connection to zuul.conf file"},{"line_number":10,"context_line":"    it extends gerrit setup by adding Verified label to gerrit"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":1,"id":"1fa4df85_0bc7a647","line":7,"in_reply_to":"1fa4df85_cb5e6e11","updated":"2020-02-29 17:01:33.000000000","message":"Done","commit_id":"d09b1ec1dcb4bbcb30d3d14e21fe00a377914a1e"}],"doc/source/howtos/gerrit_setup.rst":[{"author":{"_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},"change_message_id":"f2145e909e4d3408745902eebf4a37fee654adae","unresolved":false,"context_lines":[{"line_number":31,"context_line":""},{"line_number":32,"context_line":".. code-block:: shell"},{"line_number":33,"context_line":""},{"line_number":34,"context_line":"   ssh-keygen -N \u0027\u0027"},{"line_number":35,"context_line":"   "},{"line_number":36,"context_line":"and pressing `Enter`."},{"line_number":37,"context_line":""}],"source_content_type":"text/x-rst","patch_set":1,"id":"1fa4df85_4ba83eda","line":34,"updated":"2020-02-28 18:44:36.000000000","message":"Because the docs assume rsa below I think we should add -t rsa to this command. I think there was rumor of openssh\u0027s defaults changing in the near future.","commit_id":"d09b1ec1dcb4bbcb30d3d14e21fe00a377914a1e"},{"author":{"_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},"change_message_id":"f2145e909e4d3408745902eebf4a37fee654adae","unresolved":false,"context_lines":[{"line_number":40,"context_line":""},{"line_number":41,"context_line":".. code-block:: shell"},{"line_number":42,"context_line":""},{"line_number":43,"context_line":"   ssh-keygen -f ~/.ssh/\u003cdifferent name\u003e -N \u0027\u0027"},{"line_number":44,"context_line":""},{"line_number":45,"context_line":"Store ssh key location into a variable:"},{"line_number":46,"context_line":""}],"source_content_type":"text/x-rst","patch_set":1,"id":"1fa4df85_ebaecae5","line":43,"updated":"2020-02-28 18:44:36.000000000","message":"Add -t rsa to this command too.","commit_id":"d09b1ec1dcb4bbcb30d3d14e21fe00a377914a1e"},{"author":{"_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},"change_message_id":"f2145e909e4d3408745902eebf4a37fee654adae","unresolved":false,"context_lines":[{"line_number":101,"context_line":"Paste your public ssh key into `New SSH Key` and press `ADD NEW SSH KEY`."},{"line_number":102,"context_line":""},{"line_number":103,"context_line":".. note:: To use same `zuul` ssh key simply copy the output of `cat $PUBKEY`."},{"line_number":104,"context_line":"    For security purposes you may chose to use key that is differs from a zuul key."},{"line_number":105,"context_line":""},{"line_number":106,"context_line":"Obtain a copy of  `All-Project` git repo:"},{"line_number":107,"context_line":""}],"source_content_type":"text/x-rst","patch_set":1,"id":"1fa4df85_0baa46d1","line":104,"updated":"2020-02-28 18:44:36.000000000","message":"I think we should discourage this. Maybe:\n\n  For security purposes this is not recommended as the Zuul user shouldn\u0027t be a Gerrit admin.","commit_id":"d09b1ec1dcb4bbcb30d3d14e21fe00a377914a1e"},{"author":{"_account_id":6547,"name":"Andreas Jaeger","email":"jaegerandi@gmail.com","username":"jaegerandi"},"change_message_id":"eb4f95179eade633d9880b36fc2da621482d50b4","unresolved":false,"context_lines":[{"line_number":21,"context_line":"`stream-events \u003chttps://gerrit-review.googlesource.com/Documentation/access-control.html#global_capabilities\u003e`_"},{"line_number":22,"context_line":"ACL enabled."},{"line_number":23,"context_line":""},{"line_number":24,"context_line":"Check if you have `ssh key \u003chttps://www.ssh.com/ssh/keygen/\u003e`_  by:"},{"line_number":25,"context_line":""},{"line_number":26,"context_line":".. code-block:: shell"},{"line_number":27,"context_line":""}],"source_content_type":"text/x-rst","patch_set":2,"id":"1fa4df85_6bddfa12","line":24,"range":{"start_line":24,"start_character":13,"end_line":24,"end_character":21},"updated":"2020-02-28 19:25:52.000000000","message":"\"have a RSA ssh\"","commit_id":"4a195fc5396435601d2f8b917d98435285e272cd"},{"author":{"_account_id":6547,"name":"Andreas Jaeger","email":"jaegerandi@gmail.com","username":"jaegerandi"},"change_message_id":"eb4f95179eade633d9880b36fc2da621482d50b4","unresolved":false,"context_lines":[{"line_number":27,"context_line":""},{"line_number":28,"context_line":"   cat ~/.ssh/id_rsa.pub"},{"line_number":29,"context_line":""},{"line_number":30,"context_line":"If you lack one you can create it by:"},{"line_number":31,"context_line":""},{"line_number":32,"context_line":".. TODO: rethink key generation and naming in order to match best sec practices"},{"line_number":33,"context_line":".. code-block:: shell"}],"source_content_type":"text/x-rst","patch_set":2,"id":"1fa4df85_4bea7eac","line":30,"range":{"start_line":30,"start_character":15,"end_line":30,"end_character":36},"updated":"2020-02-28 19:25:52.000000000","message":"If you lack one,...","commit_id":"4a195fc5396435601d2f8b917d98435285e272cd"},{"author":{"_account_id":6547,"name":"Andreas Jaeger","email":"jaegerandi@gmail.com","username":"jaegerandi"},"change_message_id":"eb4f95179eade633d9880b36fc2da621482d50b4","unresolved":false,"context_lines":[{"line_number":36,"context_line":""},{"line_number":37,"context_line":"and pressing `Enter`."},{"line_number":38,"context_line":""},{"line_number":39,"context_line":"You might decide to create and use for `zuul` separate key with different name,"},{"line_number":40,"context_line":"but it might require additional adjustments later. Addition can be done by:"},{"line_number":41,"context_line":""},{"line_number":42,"context_line":".. code-block:: shell"}],"source_content_type":"text/x-rst","patch_set":2,"id":"1fa4df85_abda1214","line":39,"range":{"start_line":39,"start_character":45,"end_line":39,"end_character":46},"updated":"2020-02-28 19:25:52.000000000","message":"a separate key with a different name","commit_id":"4a195fc5396435601d2f8b917d98435285e272cd"},{"author":{"_account_id":6547,"name":"Andreas Jaeger","email":"jaegerandi@gmail.com","username":"jaegerandi"},"change_message_id":"eb4f95179eade633d9880b36fc2da621482d50b4","unresolved":false,"context_lines":[{"line_number":37,"context_line":"and pressing `Enter`."},{"line_number":38,"context_line":""},{"line_number":39,"context_line":"You might decide to create and use for `zuul` separate key with different name,"},{"line_number":40,"context_line":"but it might require additional adjustments later. Addition can be done by:"},{"line_number":41,"context_line":""},{"line_number":42,"context_line":".. code-block:: shell"},{"line_number":43,"context_line":""}],"source_content_type":"text/x-rst","patch_set":2,"id":"1fa4df85_6b065a89","line":40,"range":{"start_line":40,"start_character":51,"end_line":40,"end_character":59},"updated":"2020-02-28 19:25:52.000000000","message":"The addition...","commit_id":"4a195fc5396435601d2f8b917d98435285e272cd"},{"author":{"_account_id":6547,"name":"Andreas Jaeger","email":"jaegerandi@gmail.com","username":"jaegerandi"},"change_message_id":"eb4f95179eade633d9880b36fc2da621482d50b4","unresolved":false,"context_lines":[{"line_number":48,"context_line":".. code-block:: shell"},{"line_number":49,"context_line":""},{"line_number":50,"context_line":"   export PRIVKEY\u003d~/.ssh/id_rsa"},{"line_number":51,"context_line":"   export PUBKEY \u003d~/.ssh/id_rsa.pub"},{"line_number":52,"context_line":""},{"line_number":53,"context_line":"As the admin user, create the ``zuul`` user, and import an SSH key for"},{"line_number":54,"context_line":"``zuul``:"}],"source_content_type":"text/x-rst","patch_set":2,"id":"1fa4df85_4b035e74","line":51,"range":{"start_line":51,"start_character":16,"end_line":51,"end_character":17},"updated":"2020-02-28 19:25:52.000000000","message":"remove space, otherwise this is invalid bash syntax","commit_id":"4a195fc5396435601d2f8b917d98435285e272cd"},{"author":{"_account_id":6547,"name":"Andreas Jaeger","email":"jaegerandi@gmail.com","username":"jaegerandi"},"change_message_id":"eb4f95179eade633d9880b36fc2da621482d50b4","unresolved":false,"context_lines":[{"line_number":102,"context_line":"Paste your public ssh key into `New SSH Key` and press `ADD NEW SSH KEY`."},{"line_number":103,"context_line":""},{"line_number":104,"context_line":".. note:: To use same `zuul` ssh key simply copy the output of `cat $PUBKEY`."},{"line_number":105,"context_line":"    For security purposes this is not recommended as "},{"line_number":106,"context_line":"    the Zuul user shouldn\u0027t be a Gerrit admin."},{"line_number":107,"context_line":""},{"line_number":108,"context_line":"Obtain a copy of  `All-Project` git repo:"}],"source_content_type":"text/x-rst","patch_set":2,"id":"1fa4df85_abf3f29d","line":105,"range":{"start_line":105,"start_character":52,"end_line":105,"end_character":53},"updated":"2020-02-28 19:25:52.000000000","message":"remove extra end-of-line whitespace","commit_id":"4a195fc5396435601d2f8b917d98435285e272cd"},{"author":{"_account_id":6547,"name":"Andreas Jaeger","email":"jaegerandi@gmail.com","username":"jaegerandi"},"change_message_id":"eb4f95179eade633d9880b36fc2da621482d50b4","unresolved":false,"context_lines":[{"line_number":117,"context_line":"    git checkout meta/config"},{"line_number":118,"context_line":""},{"line_number":119,"context_line":".. note:: By putting GIT_SSH_COMMAND\u003d\u0027ssh -i ~/.ssh/$PRIVKEY\u0027"},{"line_number":120,"context_line":"   before each git command you can utilize key that is distinct from ~/.ssh/id_rsa"},{"line_number":121,"context_line":""},{"line_number":122,"context_line":"Use your favorite text editor and open `project.config`."},{"line_number":123,"context_line":"First you have to define label `Verified` by adding in the end of the file:"}],"source_content_type":"text/x-rst","patch_set":2,"id":"1fa4df85_8b2e36f8","line":120,"range":{"start_line":120,"start_character":41,"end_line":120,"end_character":45},"updated":"2020-02-28 19:25:52.000000000","message":"a key","commit_id":"4a195fc5396435601d2f8b917d98435285e272cd"},{"author":{"_account_id":6547,"name":"Andreas Jaeger","email":"jaegerandi@gmail.com","username":"jaegerandi"},"change_message_id":"eb4f95179eade633d9880b36fc2da621482d50b4","unresolved":false,"context_lines":[{"line_number":135,"context_line":""},{"line_number":136,"context_line":"Add label `Verified` to `refs/head`"},{"line_number":137,"context_line":"Finding section `[access \"refs/heads/*\"]` in same file and add line before"},{"line_number":138,"context_line":"start of the next section"},{"line_number":139,"context_line":""},{"line_number":140,"context_line":".. code-block:: shell"},{"line_number":141,"context_line":""}],"source_content_type":"text/x-rst","patch_set":2,"id":"1fa4df85_4b383e3c","line":138,"updated":"2020-02-28 19:25:52.000000000","message":"add \":\" at end","commit_id":"4a195fc5396435601d2f8b917d98435285e272cd"},{"author":{"_account_id":6547,"name":"Andreas Jaeger","email":"jaegerandi@gmail.com","username":"jaegerandi"},"change_message_id":"e7e790567c29fdc4cc8a6f50b7cdb4411fe86584","unresolved":false,"context_lines":[{"line_number":122,"context_line":"Use your favorite text editor and open `project.config`."},{"line_number":123,"context_line":"First you have to define label `Verified` by adding in the end of the file:"},{"line_number":124,"context_line":""},{"line_number":125,"context_line":".. code-block:: shell"},{"line_number":126,"context_line":""},{"line_number":127,"context_line":"    [label \"Verified\"]"},{"line_number":128,"context_line":"            function \u003d MaxWithBlock"}],"source_content_type":"text/x-rst","patch_set":5,"id":"1fa4df85_295e25e6","line":125,"range":{"start_line":125,"start_character":14,"end_line":125,"end_character":21},"updated":"2020-02-29 15:42:26.000000000","message":"this is not shell according to sphinx - and I agree.","commit_id":"7bb45a5d17a891ff227ce9d843af5f26bc9f3a7e"},{"author":{"_account_id":6547,"name":"Andreas Jaeger","email":"jaegerandi@gmail.com","username":"jaegerandi"},"change_message_id":"e7e790567c29fdc4cc8a6f50b7cdb4411fe86584","unresolved":false,"context_lines":[{"line_number":124,"context_line":""},{"line_number":125,"context_line":".. code-block:: shell"},{"line_number":126,"context_line":""},{"line_number":127,"context_line":"    [label \"Verified\"]"},{"line_number":128,"context_line":"            function \u003d MaxWithBlock"},{"line_number":129,"context_line":"            value \u003d -2 Fails"},{"line_number":130,"context_line":"            value \u003d -1 Doesn\u0027t seem to work"},{"line_number":131,"context_line":"            value \u003d  0 No score"},{"line_number":132,"context_line":"            value \u003d +1 Works for me"},{"line_number":133,"context_line":"            value \u003d +2 Verified"},{"line_number":134,"context_line":"            copyAllScoresIfNoCodeChange \u003d true"},{"line_number":135,"context_line":""},{"line_number":136,"context_line":"Add label `Verified` to `refs/head`"},{"line_number":137,"context_line":"Finding section `[access \"refs/heads/*\"]` in same file and add line before"}],"source_content_type":"text/x-rst","patch_set":5,"id":"1fa4df85_c974316b","line":134,"range":{"start_line":127,"start_character":4,"end_line":134,"end_character":46},"updated":"2020-02-29 15:42:26.000000000","message":"indent them all the same, no extra indent needed for the items.","commit_id":"7bb45a5d17a891ff227ce9d843af5f26bc9f3a7e"}],"doc/source/howtos/mysql_install.rst":[{"author":{"_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},"change_message_id":"f2145e909e4d3408745902eebf4a37fee654adae","unresolved":false,"context_lines":[{"line_number":22,"context_line":""},{"line_number":23,"context_line":"Create user zuul. Create database zuul. Grant user zuul privileges to operate over zuul database."},{"line_number":24,"context_line":""},{"line_number":25,"context_line":".. code-block:: shell"},{"line_number":26,"context_line":"   CREATE USER \u0027zuul\u0027@\u0027localhost\u0027 IDENTIFIED BY \u0027secret\u0027;"},{"line_number":27,"context_line":"   CREATE DATABASE zuul;"},{"line_number":28,"context_line":"   GRANT ALL ON zuul.* TO \u0027zuul\u0027@\u0027localhost\u0027;"}],"source_content_type":"text/x-rst","patch_set":1,"id":"1fa4df85_6b841a5f","line":25,"updated":"2020-02-28 18:44:36.000000000","message":"You might want to include the mysql client connection string that starts the database connection. That way users new to mysql/mariadb know the context for the sql statements.","commit_id":"d09b1ec1dcb4bbcb30d3d14e21fe00a377914a1e"},{"author":{"_account_id":6547,"name":"Andreas Jaeger","email":"jaegerandi@gmail.com","username":"jaegerandi"},"change_message_id":"eb4f95179eade633d9880b36fc2da621482d50b4","unresolved":false,"context_lines":[{"line_number":1,"context_line":":orphan:"},{"line_number":2,"context_line":""},{"line_number":3,"context_line":"Install Mysql"},{"line_number":4,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"},{"line_number":5,"context_line":""},{"line_number":6,"context_line":"Installation"},{"line_number":7,"context_line":"-------------"}],"source_content_type":"text/x-rst","patch_set":2,"id":"1fa4df85_8b1716a4","line":4,"range":{"start_line":3,"start_character":0,"end_line":4,"end_character":13},"updated":"2020-02-28 19:25:52.000000000","message":"underline with exact same number of \"\u003d\" as the heading","commit_id":"4a195fc5396435601d2f8b917d98435285e272cd"},{"author":{"_account_id":31654,"name":"Zen Kurosaky","email":"zenkuro@protonmail.com","username":"zenkuro"},"change_message_id":"49a2b5109b3fa40f253885ac3e89c1028bb9c24c","unresolved":false,"context_lines":[{"line_number":1,"context_line":":orphan:"},{"line_number":2,"context_line":""},{"line_number":3,"context_line":"Install Mysql"},{"line_number":4,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"},{"line_number":5,"context_line":""},{"line_number":6,"context_line":"Installation"},{"line_number":7,"context_line":"-------------"}],"source_content_type":"text/x-rst","patch_set":2,"id":"1fa4df85_9ec18d31","line":4,"range":{"start_line":3,"start_character":0,"end_line":4,"end_character":13},"in_reply_to":"1fa4df85_8b1716a4","updated":"2020-02-29 17:01:33.000000000","message":"Done","commit_id":"4a195fc5396435601d2f8b917d98435285e272cd"},{"author":{"_account_id":6547,"name":"Andreas Jaeger","email":"jaegerandi@gmail.com","username":"jaegerandi"},"change_message_id":"eb4f95179eade633d9880b36fc2da621482d50b4","unresolved":false,"context_lines":[{"line_number":23,"context_line":"Start `MySQL` as administrator by running:"},{"line_number":24,"context_line":""},{"line_number":25,"context_line":".. code-block:: shell"},{"line_number":26,"context_line":"    "},{"line_number":27,"context_line":"    sudo sudo mysql"},{"line_number":28,"context_line":""},{"line_number":29,"context_line":"Create user zuul. Create database zuul. Grant user zuul privileges to operate over zuul database."}],"source_content_type":"text/x-rst","patch_set":2,"id":"1fa4df85_0b3a4633","line":26,"range":{"start_line":26,"start_character":0,"end_line":26,"end_character":4},"updated":"2020-02-28 19:25:52.000000000","message":"remove extra whitespace, those show up as red rectangles in gerrit","commit_id":"4a195fc5396435601d2f8b917d98435285e272cd"},{"author":{"_account_id":31654,"name":"Zen Kurosaky","email":"zenkuro@protonmail.com","username":"zenkuro"},"change_message_id":"49a2b5109b3fa40f253885ac3e89c1028bb9c24c","unresolved":false,"context_lines":[{"line_number":23,"context_line":"Start `MySQL` as administrator by running:"},{"line_number":24,"context_line":""},{"line_number":25,"context_line":".. code-block:: shell"},{"line_number":26,"context_line":"    "},{"line_number":27,"context_line":"    sudo sudo mysql"},{"line_number":28,"context_line":""},{"line_number":29,"context_line":"Create user zuul. Create database zuul. Grant user zuul privileges to operate over zuul database."}],"source_content_type":"text/x-rst","patch_set":2,"id":"1fa4df85_1eb6fdda","line":26,"range":{"start_line":26,"start_character":0,"end_line":26,"end_character":4},"in_reply_to":"1fa4df85_0b3a4633","updated":"2020-02-29 17:01:33.000000000","message":"Done","commit_id":"4a195fc5396435601d2f8b917d98435285e272cd"},{"author":{"_account_id":6547,"name":"Andreas Jaeger","email":"jaegerandi@gmail.com","username":"jaegerandi"},"change_message_id":"eb4f95179eade633d9880b36fc2da621482d50b4","unresolved":false,"context_lines":[{"line_number":26,"context_line":"    "},{"line_number":27,"context_line":"    sudo sudo mysql"},{"line_number":28,"context_line":""},{"line_number":29,"context_line":"Create user zuul. Create database zuul. Grant user zuul privileges to operate over zuul database."},{"line_number":30,"context_line":""},{"line_number":31,"context_line":".. code-block:: shell"},{"line_number":32,"context_line":""}],"source_content_type":"text/x-rst","patch_set":2,"id":"1fa4df85_eb27aa11","line":29,"range":{"start_line":29,"start_character":1,"end_line":29,"end_character":97},"updated":"2020-02-28 19:25:52.000000000","message":"Create the user `zuul`, create the database `zuul`, grant the user `zuul` all privileges on the `zuul` database.","commit_id":"4a195fc5396435601d2f8b917d98435285e272cd"},{"author":{"_account_id":31654,"name":"Zen Kurosaky","email":"zenkuro@protonmail.com","username":"zenkuro"},"change_message_id":"49a2b5109b3fa40f253885ac3e89c1028bb9c24c","unresolved":false,"context_lines":[{"line_number":26,"context_line":"    "},{"line_number":27,"context_line":"    sudo sudo mysql"},{"line_number":28,"context_line":""},{"line_number":29,"context_line":"Create user zuul. Create database zuul. Grant user zuul privileges to operate over zuul database."},{"line_number":30,"context_line":""},{"line_number":31,"context_line":".. code-block:: shell"},{"line_number":32,"context_line":""}],"source_content_type":"text/x-rst","patch_set":2,"id":"1fa4df85_7ec6114b","line":29,"range":{"start_line":29,"start_character":1,"end_line":29,"end_character":97},"in_reply_to":"1fa4df85_eb27aa11","updated":"2020-02-29 17:01:33.000000000","message":"Done","commit_id":"4a195fc5396435601d2f8b917d98435285e272cd"}]}