)]}'
{".zuul.yaml":[{"author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"tag":"autogenerated:zuul:check","change_message_id":"9e6948030f3b0ce8738bc0d9835ce415a4b463b1","unresolved":false,"context_lines":[{"line_number":1239,"context_line":"      - playbooks/roles/registry/"},{"line_number":1240,"context_line":"      - testinfra/test_registry.py"},{"line_number":1241,"context_line":""},{"line_number":1242,"context_line":"- job:"},{"line_number":1243,"context_line":"    name: system-config-run-etherpad"},{"line_number":1244,"context_line":"    parent: system-config-run-containers"},{"line_number":1245,"context_line":"    description: |"},{"line_number":1246,"context_line":"      Run the playbook for the etherpad servers."},{"line_number":1247,"context_line":"    timeout: 3600"},{"line_number":1248,"context_line":"    nodeset:"},{"line_number":1249,"context_line":"      nodes:"},{"line_number":1250,"context_line":"        - name: bridge.openstack.org"},{"line_number":1251,"context_line":"          label: ubuntu-bionic"},{"line_number":1252,"context_line":"        - name: etherpad01.openstack.org"},{"line_number":1253,"context_line":"          label: ubuntu-xenial"},{"line_number":1254,"context_line":"    vars:"},{"line_number":1255,"context_line":"      run_playbooks:"},{"line_number":1256,"context_line":"        - playbooks/service-letsencrypt.yaml"},{"line_number":1257,"context_line":"        - playbooks/service-etherpad.yaml"},{"line_number":1258,"context_line":"    host-vars:"},{"line_number":1259,"context_line":"    files:"},{"line_number":1260,"context_line":"      - playbooks/bridge.yaml"},{"line_number":1261,"context_line":"      - playbooks/service-letsencrypt.yaml"},{"line_number":1262,"context_line":"      - playbooks/service-etherpad.yaml"},{"line_number":1263,"context_line":"      - playbooks/roles/etherpad/.*"},{"line_number":1264,"context_line":"      - docker/etherpad/.*"},{"line_number":1265,"context_line":""},{"line_number":1266,"context_line":"- job:"},{"line_number":1267,"context_line":"    name: system-config-run-gitea"},{"line_number":1268,"context_line":"    parent: system-config-run-containers"}],"source_content_type":"text/x-yaml","patch_set":1,"id":"df33271e_47d8eb1c","line":1265,"range":{"start_line":1242,"start_character":2,"end_line":1265,"end_character":0},"updated":"2020-03-31 21:46:13.000000000","message":"expected a dictionary for dictionary value @ data[\u0027host-vars\u0027]","commit_id":"02da21becb48799084a4977ac1bf788d381b4d3d"},{"author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"tag":"autogenerated:zuul:check-arm64","change_message_id":"31abe845c31d29ab39be63b00009de257f3af456","unresolved":false,"context_lines":[{"line_number":1239,"context_line":"      - playbooks/roles/registry/"},{"line_number":1240,"context_line":"      - testinfra/test_registry.py"},{"line_number":1241,"context_line":""},{"line_number":1242,"context_line":"- job:"},{"line_number":1243,"context_line":"    name: system-config-run-etherpad"},{"line_number":1244,"context_line":"    parent: system-config-run-containers"},{"line_number":1245,"context_line":"    description: |"},{"line_number":1246,"context_line":"      Run the playbook for the etherpad servers."},{"line_number":1247,"context_line":"    timeout: 3600"},{"line_number":1248,"context_line":"    nodeset:"},{"line_number":1249,"context_line":"      nodes:"},{"line_number":1250,"context_line":"        - name: bridge.openstack.org"},{"line_number":1251,"context_line":"          label: ubuntu-bionic"},{"line_number":1252,"context_line":"        - name: etherpad01.openstack.org"},{"line_number":1253,"context_line":"          label: ubuntu-xenial"},{"line_number":1254,"context_line":"    vars:"},{"line_number":1255,"context_line":"      run_playbooks:"},{"line_number":1256,"context_line":"        - playbooks/service-letsencrypt.yaml"},{"line_number":1257,"context_line":"        - playbooks/service-etherpad.yaml"},{"line_number":1258,"context_line":"    host-vars:"},{"line_number":1259,"context_line":"    files:"},{"line_number":1260,"context_line":"      - playbooks/bridge.yaml"},{"line_number":1261,"context_line":"      - playbooks/service-letsencrypt.yaml"},{"line_number":1262,"context_line":"      - playbooks/service-etherpad.yaml"},{"line_number":1263,"context_line":"      - playbooks/roles/etherpad/.*"},{"line_number":1264,"context_line":"      - docker/etherpad/.*"},{"line_number":1265,"context_line":""},{"line_number":1266,"context_line":"- job:"},{"line_number":1267,"context_line":"    name: system-config-run-gitea"},{"line_number":1268,"context_line":"    parent: system-config-run-containers"}],"source_content_type":"text/x-yaml","patch_set":1,"id":"df33271e_670c0fa5","line":1265,"range":{"start_line":1242,"start_character":2,"end_line":1265,"end_character":0},"updated":"2020-03-31 21:46:17.000000000","message":"expected a dictionary for dictionary value @ data[\u0027host-vars\u0027]","commit_id":"02da21becb48799084a4977ac1bf788d381b4d3d"},{"author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"tag":"autogenerated:zuul:check","change_message_id":"8f60de95cc74b146988e09a95cdf271ae2e57fa2","unresolved":false,"context_lines":[{"line_number":1239,"context_line":"      - playbooks/roles/registry/"},{"line_number":1240,"context_line":"      - testinfra/test_registry.py"},{"line_number":1241,"context_line":""},{"line_number":1242,"context_line":"- job:"},{"line_number":1243,"context_line":"    name: system-config-run-etherpad"},{"line_number":1244,"context_line":"    parent: system-config-run-containers"},{"line_number":1245,"context_line":"    description: |"},{"line_number":1246,"context_line":"      Run the playbook for the etherpad servers."},{"line_number":1247,"context_line":"    timeout: 3600"},{"line_number":1248,"context_line":"    nodeset:"},{"line_number":1249,"context_line":"      nodes:"},{"line_number":1250,"context_line":"        - name: bridge.openstack.org"},{"line_number":1251,"context_line":"          label: ubuntu-bionic"},{"line_number":1252,"context_line":"        - name: etherpad01.openstack.org"},{"line_number":1253,"context_line":"          label: ubuntu-xenial"},{"line_number":1254,"context_line":"    vars:"},{"line_number":1255,"context_line":"      run_playbooks:"},{"line_number":1256,"context_line":"        - playbooks/service-letsencrypt.yaml"},{"line_number":1257,"context_line":"        - playbooks/service-etherpad.yaml"},{"line_number":1258,"context_line":"    host-vars:"},{"line_number":1259,"context_line":"    files:"},{"line_number":1260,"context_line":"      - playbooks/bridge.yaml"},{"line_number":1261,"context_line":"      - playbooks/service-letsencrypt.yaml"},{"line_number":1262,"context_line":"      - playbooks/service-etherpad.yaml"},{"line_number":1263,"context_line":"      - playbooks/roles/etherpad/.*"},{"line_number":1264,"context_line":"      - docker/etherpad/.*"},{"line_number":1265,"context_line":""},{"line_number":1266,"context_line":"- job:"},{"line_number":1267,"context_line":"    name: system-config-run-gitea"},{"line_number":1268,"context_line":"    parent: system-config-run-containers"}],"source_content_type":"text/x-yaml","patch_set":1,"id":"df33271e_a7e9f7b7","line":1265,"range":{"start_line":1242,"start_character":2,"end_line":1265,"end_character":0},"updated":"2020-03-31 21:46:08.000000000","message":"expected a dictionary for dictionary value @ data[\u0027host-vars\u0027]","commit_id":"02da21becb48799084a4977ac1bf788d381b4d3d"},{"author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"tag":"autogenerated:zuul:check","change_message_id":"8f60de95cc74b146988e09a95cdf271ae2e57fa2","unresolved":false,"context_lines":[{"line_number":1478,"context_line":"    parent: infra-prod-playbook"},{"line_number":1479,"context_line":"    description: |"},{"line_number":1480,"context_line":"      Create and update projects in gerrit and gitea."},{"line_number":1481,"context_line":"    vars:"},{"line_number":1482,"context_line":"      playbook_name: manage-projects.yaml"},{"line_number":1483,"context_line":"      infra_prod_playbook_collect_log: false"},{"line_number":1484,"context_line":"      ansible_forks: 50"},{"line_number":1485,"context_line":""},{"line_number":1486,"context_line":"- job:"},{"line_number":1487,"context_line":"    name: system-config-goaccess-report"},{"line_number":1488,"context_line":"    description: |"},{"line_number":1489,"context_line":"      Run goaccess tool on static.opendev.org hosted site."},{"line_number":1490,"context_line":"    abstract: true"},{"line_number":1491,"context_line":"    protected: true"},{"line_number":1492,"context_line":"    timeout: 7200"},{"line_number":1493,"context_line":"    nodeset:"},{"line_number":1494,"context_line":"      nodes: []"},{"line_number":1495,"context_line":"    run: playbooks/periodic/goaccess.yaml"},{"line_number":1496,"context_line":""},{"line_number":1497,"context_line":"- job:"}],"source_content_type":"text/x-yaml","patch_set":1,"id":"df33271e_07d26300","line":1494,"range":{"start_line":1481,"start_character":2,"end_line":1494,"end_character":0},"updated":"2020-03-31 21:46:08.000000000","message":"Unknown project openstack/project-config","commit_id":"02da21becb48799084a4977ac1bf788d381b4d3d"},{"author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"tag":"autogenerated:zuul:check","change_message_id":"9e6948030f3b0ce8738bc0d9835ce415a4b463b1","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":1,"id":"df33271e_27d5e7e5","line":1847,"range":{"start_line":1691,"start_character":2,"end_line":1847,"end_character":0},"updated":"2020-03-31 21:46:13.000000000","message":"Job system-config-run-etherpad not defined","commit_id":"02da21becb48799084a4977ac1bf788d381b4d3d"},{"author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"tag":"autogenerated:zuul:check-arm64","change_message_id":"31abe845c31d29ab39be63b00009de257f3af456","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":1,"id":"df33271e_c7fd1b6f","line":1847,"range":{"start_line":1691,"start_character":2,"end_line":1847,"end_character":0},"updated":"2020-03-31 21:46:17.000000000","message":"Job system-config-run-etherpad not defined","commit_id":"02da21becb48799084a4977ac1bf788d381b4d3d"},{"author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"tag":"autogenerated:zuul:check","change_message_id":"ad1676c738017ddfc0bff8bc6b43f139c565f8d3","unresolved":false,"context_lines":[{"line_number":1477,"context_line":"    parent: infra-prod-playbook"},{"line_number":1478,"context_line":"    description: |"},{"line_number":1479,"context_line":"      Create and update projects in gerrit and gitea."},{"line_number":1480,"context_line":"    vars:"},{"line_number":1481,"context_line":"      playbook_name: manage-projects.yaml"},{"line_number":1482,"context_line":"      infra_prod_playbook_collect_log: false"},{"line_number":1483,"context_line":"      ansible_forks: 50"},{"line_number":1484,"context_line":""},{"line_number":1485,"context_line":"- job:"},{"line_number":1486,"context_line":"    name: system-config-goaccess-report"},{"line_number":1487,"context_line":"    description: |"},{"line_number":1488,"context_line":"      Run goaccess tool on static.opendev.org hosted site."},{"line_number":1489,"context_line":"    abstract: true"},{"line_number":1490,"context_line":"    protected: true"},{"line_number":1491,"context_line":"    timeout: 7200"},{"line_number":1492,"context_line":"    nodeset:"},{"line_number":1493,"context_line":"      nodes: []"},{"line_number":1494,"context_line":"    run: playbooks/periodic/goaccess.yaml"},{"line_number":1495,"context_line":""},{"line_number":1496,"context_line":"- job:"}],"source_content_type":"text/x-yaml","patch_set":2,"id":"df33271e_e76adf17","line":1493,"range":{"start_line":1480,"start_character":2,"end_line":1493,"end_character":0},"updated":"2020-03-31 21:49:00.000000000","message":"Unknown project openstack/project-config","commit_id":"bf8ae9721bc7533d73e080303c0e6c84d6f844f2"},{"author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"tag":"autogenerated:zuul:check","change_message_id":"cd30a3bd7883f4d8b010a080533bb5757161fe57","unresolved":false,"context_lines":[{"line_number":1477,"context_line":"    parent: infra-prod-playbook"},{"line_number":1478,"context_line":"    description: |"},{"line_number":1479,"context_line":"      Create and update projects in gerrit and gitea."},{"line_number":1480,"context_line":"    vars:"},{"line_number":1481,"context_line":"      playbook_name: manage-projects.yaml"},{"line_number":1482,"context_line":"      infra_prod_playbook_collect_log: false"},{"line_number":1483,"context_line":"      ansible_forks: 50"},{"line_number":1484,"context_line":""},{"line_number":1485,"context_line":"- job:"},{"line_number":1486,"context_line":"    name: system-config-goaccess-report"},{"line_number":1487,"context_line":"    description: |"},{"line_number":1488,"context_line":"      Run goaccess tool on static.opendev.org hosted site."},{"line_number":1489,"context_line":"    abstract: true"},{"line_number":1490,"context_line":"    protected: true"},{"line_number":1491,"context_line":"    timeout: 7200"},{"line_number":1492,"context_line":"    nodeset:"},{"line_number":1493,"context_line":"      nodes: []"},{"line_number":1494,"context_line":"    run: playbooks/periodic/goaccess.yaml"},{"line_number":1495,"context_line":""}],"source_content_type":"text/x-yaml","patch_set":3,"id":"df33271e_7c6770ea","line":1492,"range":{"start_line":1480,"start_character":2,"end_line":1492,"end_character":0},"updated":"2020-04-01 15:43:00.000000000","message":"Unknown project openstack/project-config","commit_id":"b4e4eb58bd8c72a2004e8e02bb65926232a63014"},{"author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"tag":"autogenerated:zuul:check","change_message_id":"9a824ec54904ef4fcac4e9f38ef50cd01f88306f","unresolved":false,"context_lines":[{"line_number":1477,"context_line":"    parent: infra-prod-playbook"},{"line_number":1478,"context_line":"    description: |"},{"line_number":1479,"context_line":"      Create and update projects in gerrit and gitea."},{"line_number":1480,"context_line":"    vars:"},{"line_number":1481,"context_line":"      playbook_name: manage-projects.yaml"},{"line_number":1482,"context_line":"      infra_prod_playbook_collect_log: false"},{"line_number":1483,"context_line":"      ansible_forks: 50"},{"line_number":1484,"context_line":""},{"line_number":1485,"context_line":"- job:"},{"line_number":1486,"context_line":"    name: system-config-goaccess-report"},{"line_number":1487,"context_line":"    description: |"},{"line_number":1488,"context_line":"      Run goaccess tool on static.opendev.org hosted site."},{"line_number":1489,"context_line":"    abstract: true"},{"line_number":1490,"context_line":"    protected: true"},{"line_number":1491,"context_line":"    timeout: 7200"},{"line_number":1492,"context_line":"    nodeset:"},{"line_number":1493,"context_line":"      nodes: []"},{"line_number":1494,"context_line":"    run: playbooks/periodic/goaccess.yaml"},{"line_number":1495,"context_line":""}],"source_content_type":"text/x-yaml","patch_set":4,"id":"df33271e_979a0fb6","line":1492,"range":{"start_line":1480,"start_character":2,"end_line":1492,"end_character":0},"updated":"2020-04-01 16:14:37.000000000","message":"Unknown project openstack/project-config","commit_id":"a7df0a4b60f756aa14809ded97a646c11d7dc032"},{"author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"tag":"autogenerated:zuul:check","change_message_id":"4fefe4da795dc5afc3932f23645181969b67c0ce","unresolved":false,"context_lines":[{"line_number":1477,"context_line":"    parent: infra-prod-playbook"},{"line_number":1478,"context_line":"    description: |"},{"line_number":1479,"context_line":"      Create and update projects in gerrit and gitea."},{"line_number":1480,"context_line":"    vars:"},{"line_number":1481,"context_line":"      playbook_name: manage-projects.yaml"},{"line_number":1482,"context_line":"      infra_prod_playbook_collect_log: false"},{"line_number":1483,"context_line":"      ansible_forks: 50"},{"line_number":1484,"context_line":""},{"line_number":1485,"context_line":"- job:"},{"line_number":1486,"context_line":"    name: system-config-goaccess-report"},{"line_number":1487,"context_line":"    description: |"},{"line_number":1488,"context_line":"      Run goaccess tool on static.opendev.org hosted site."},{"line_number":1489,"context_line":"    abstract: true"},{"line_number":1490,"context_line":"    protected: true"},{"line_number":1491,"context_line":"    timeout: 7200"},{"line_number":1492,"context_line":"    nodeset:"},{"line_number":1493,"context_line":"      nodes: []"},{"line_number":1494,"context_line":"    run: playbooks/periodic/goaccess.yaml"},{"line_number":1495,"context_line":""}],"source_content_type":"text/x-yaml","patch_set":5,"id":"df33271e_17255e09","line":1492,"range":{"start_line":1480,"start_character":2,"end_line":1492,"end_character":0},"updated":"2020-04-01 17:11:00.000000000","message":"Unknown project openstack/project-config","commit_id":"2599e15dc52690054c1084ab5565d329da383a5f"},{"author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"tag":"autogenerated:zuul:check","change_message_id":"60c09f6b4106acc303f26f9fac37dd4464f0b19a","unresolved":false,"context_lines":[{"line_number":1477,"context_line":"    parent: infra-prod-playbook"},{"line_number":1478,"context_line":"    description: |"},{"line_number":1479,"context_line":"      Create and update projects in gerrit and gitea."},{"line_number":1480,"context_line":"    vars:"},{"line_number":1481,"context_line":"      playbook_name: manage-projects.yaml"},{"line_number":1482,"context_line":"      infra_prod_playbook_collect_log: false"},{"line_number":1483,"context_line":"      ansible_forks: 50"},{"line_number":1484,"context_line":""},{"line_number":1485,"context_line":"- job:"},{"line_number":1486,"context_line":"    name: system-config-goaccess-report"},{"line_number":1487,"context_line":"    description: |"},{"line_number":1488,"context_line":"      Run goaccess tool on static.opendev.org hosted site."},{"line_number":1489,"context_line":"    abstract: true"},{"line_number":1490,"context_line":"    protected: true"},{"line_number":1491,"context_line":"    timeout: 7200"},{"line_number":1492,"context_line":"    nodeset:"},{"line_number":1493,"context_line":"      nodes: []"},{"line_number":1494,"context_line":"    run: playbooks/periodic/goaccess.yaml"},{"line_number":1495,"context_line":""}],"source_content_type":"text/x-yaml","patch_set":6,"id":"df33271e_57a52646","line":1492,"range":{"start_line":1480,"start_character":2,"end_line":1492,"end_character":0},"updated":"2020-04-01 17:16:33.000000000","message":"Unknown project openstack/project-config","commit_id":"9b0d86ee286f2ffd1b49199030374a2d79b5b301"},{"author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"tag":"autogenerated:zuul:check","change_message_id":"223fdd30f8239e7b2070522aa90eed12641dc87f","unresolved":false,"context_lines":[{"line_number":1477,"context_line":"    parent: infra-prod-playbook"},{"line_number":1478,"context_line":"    description: |"},{"line_number":1479,"context_line":"      Create and update projects in gerrit and gitea."},{"line_number":1480,"context_line":"    vars:"},{"line_number":1481,"context_line":"      playbook_name: manage-projects.yaml"},{"line_number":1482,"context_line":"      infra_prod_playbook_collect_log: false"},{"line_number":1483,"context_line":"      ansible_forks: 50"},{"line_number":1484,"context_line":""},{"line_number":1485,"context_line":"- job:"},{"line_number":1486,"context_line":"    name: system-config-goaccess-report"},{"line_number":1487,"context_line":"    description: |"},{"line_number":1488,"context_line":"      Run goaccess tool on static.opendev.org hosted site."},{"line_number":1489,"context_line":"    abstract: true"},{"line_number":1490,"context_line":"    protected: true"},{"line_number":1491,"context_line":"    timeout: 7200"},{"line_number":1492,"context_line":"    nodeset:"},{"line_number":1493,"context_line":"      nodes: []"},{"line_number":1494,"context_line":"    run: playbooks/periodic/goaccess.yaml"},{"line_number":1495,"context_line":""}],"source_content_type":"text/x-yaml","patch_set":7,"id":"df33271e_00ffd266","line":1492,"range":{"start_line":1480,"start_character":2,"end_line":1492,"end_character":0},"updated":"2020-04-01 18:51:46.000000000","message":"Unknown project openstack/project-config","commit_id":"f7b26a00c506d8ab69dcfc53e9bccb25cd1e02b1"}],"playbooks/host_vars/etherpad01.opendev.org.yaml":[{"author":{"_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},"change_message_id":"4f1b671b8c29fb2f4a1ecf6de888051754e939e6","unresolved":false,"context_lines":[{"line_number":3,"context_line":"  etherpad01-opendev-org-main:"},{"line_number":4,"context_line":"    - etherpad.opendev.org"},{"line_number":5,"context_line":"    - etherpad01.opendev.org"},{"line_number":6,"context_line":"    - etherpad.openstack.org"},{"line_number":7,"context_line":"etherpad_redirect_vhost: etherpad.openstack.org"}],"source_content_type":"text/x-yaml","patch_set":17,"id":"df33271e_b1753ecf","line":6,"updated":"2020-04-06 16:37:26.000000000","message":"You\u0027ll need acme records in the openstack.org domain for this.","commit_id":"4953767699d73049cf42616af713b17fd38e641b"},{"author":{"_account_id":2,"name":"Monty Taylor","email":"mordred@inaugust.com","username":"mordred"},"change_message_id":"ab16acd2006e9c421840d7fb917c7f9353de3009","unresolved":false,"context_lines":[{"line_number":3,"context_line":"  etherpad01-opendev-org-main:"},{"line_number":4,"context_line":"    - etherpad.opendev.org"},{"line_number":5,"context_line":"    - etherpad01.opendev.org"},{"line_number":6,"context_line":"    - etherpad.openstack.org"},{"line_number":7,"context_line":"etherpad_redirect_vhost: etherpad.openstack.org"}],"source_content_type":"text/x-yaml","patch_set":17,"id":"df33271e_d47f0ba9","line":6,"in_reply_to":"df33271e_b1753ecf","updated":"2020-04-06 21:24:33.000000000","message":"Yup. Already added.","commit_id":"4953767699d73049cf42616af713b17fd38e641b"}],"playbooks/roles/etherpad/files/etherpad-docker/docker-compose.yaml":[{"author":{"_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},"change_message_id":"8be4538d149696d3eb287b630d3e8806e1a9f9de","unresolved":false,"context_lines":[{"line_number":8,"context_line":"    image: docker.io/opendevorg/etherpad"},{"line_number":9,"context_line":"    network_mode: host"},{"line_number":10,"context_line":"    volumes:"},{"line_number":11,"context_line":"      - /etc/etherpad/settings.json:/opt/etherpad-lite/settings.json"}],"source_content_type":"text/x-yaml","patch_set":3,"id":"df33271e_5c270c65","line":11,"updated":"2020-04-01 15:53:23.000000000","message":"This service also needs a mysql/maria/something database. Currently we use an external trove db and feed credentials for that into the service config. In order to test this service properly in the run job we\u0027ll need a db of some sort. With gitea we run that locally via docker as well.\n\nMaybe we should take this as an opportunity to go back to running the database alongside the service on the same host? THat will make db updates simpler/easier as well as testing. Then we can take a reasonable outage and migrate the db over and call it a day.\n\nRelated, we\u0027ll want to add database backups to this new service setup (gitea has examples of doing this with docker composed things).","commit_id":"b4e4eb58bd8c72a2004e8e02bb65926232a63014"}],"playbooks/roles/etherpad/files/my.cnf":[{"author":{"_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},"change_message_id":"4f1b671b8c29fb2f4a1ecf6de888051754e939e6","unresolved":false,"context_lines":[{"line_number":1,"context_line":"[client]"},{"line_number":2,"context_line":"# Default is Latin1, if you need UTF-8 set this (also in server section)"},{"line_number":3,"context_line":"default-character-set \u003d utf8"},{"line_number":4,"context_line":""},{"line_number":5,"context_line":"[mysqld]"},{"line_number":6,"context_line":"wait_timeout \u003d 28800"}],"source_content_type":"application/octet-stream","patch_set":17,"id":"df33271e_d155621f","line":3,"updated":"2020-04-06 16:37:26.000000000","message":"Don\u0027t we need uft8mb4 for 4 byte glyphs?","commit_id":"4953767699d73049cf42616af713b17fd38e641b"},{"author":{"_account_id":2,"name":"Monty Taylor","email":"mordred@inaugust.com","username":"mordred"},"change_message_id":"ab16acd2006e9c421840d7fb917c7f9353de3009","unresolved":false,"context_lines":[{"line_number":1,"context_line":"[client]"},{"line_number":2,"context_line":"# Default is Latin1, if you need UTF-8 set this (also in server section)"},{"line_number":3,"context_line":"default-character-set \u003d utf8"},{"line_number":4,"context_line":""},{"line_number":5,"context_line":"[mysqld]"},{"line_number":6,"context_line":"wait_timeout \u003d 28800"}],"source_content_type":"application/octet-stream","patch_set":17,"id":"df33271e_b4552720","line":3,"in_reply_to":"df33271e_d155621f","updated":"2020-04-06 21:24:33.000000000","message":"This is what was set in the \"sanity\" config on rax.\n\nThat said - the database itself will have a charset and collation. These are settings for the _connection_. (charset in mysql is ... complicated)","commit_id":"4953767699d73049cf42616af713b17fd38e641b"},{"author":{"_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},"change_message_id":"c5cd664ddeeeda5d36c28fc70afbac58123489ac","unresolved":false,"context_lines":[{"line_number":12,"context_line":"character-set-server  \u003d utf8"},{"line_number":13,"context_line":"collation-server      \u003d utf8_bin"},{"line_number":14,"context_line":"character_set_server   \u003d utf8"},{"line_number":15,"context_line":"collation_server       \u003d utf8_bin"}],"source_content_type":"application/octet-stream","patch_set":19,"id":"df33271e_6a48bd86","line":15,"updated":"2020-04-07 17:07:48.000000000","message":"Based on an earlier comment shouldn\u0027t these server side settings be set to utf8mb4 and utf8mb4_bin? Otherwise we\u0027ll get 3 byte by default?","commit_id":"b23515c6230a9110791504b76d656d75490b1221"}]}