)]}'
{"jenkins/jobs/macros.yaml":[{"author":{"_account_id":5263,"name":"Jeremy Stanley","display_name":"fungi","email":"fungi@yuggoth.org","username":"fungi","status":"missing, presumed fed"},"change_message_id":"e46e96e341e535f18e0f640db046b51011a0ee6a","unresolved":false,"context_lines":[{"line_number":688,"context_line":"          DB_PW\u003dopenstack_citest"},{"line_number":689,"context_line":"          sudo -H mysqladmin -u root password $DB_ROOT_PW"},{"line_number":690,"context_line":"          # note; we remove anonymous users first"},{"line_number":691,"context_line":"          sudo -H mysql -u root -p$DB_ROOT_PW -h localhost -e \""},{"line_number":692,"context_line":"              DELETE FROM mysql.user WHERE User\u003d\u0027\u0027;"},{"line_number":693,"context_line":"              FLUSH PRIVILEGES;"},{"line_number":694,"context_line":"              GRANT ALL PRIVILEGES ON *.*"}],"source_content_type":"text/x-yaml","patch_set":1,"id":"1aa78d24_932afb2a","line":691,"updated":"2016-07-05 14:55:25.000000000","message":"It\u0027s possible some jobs are relying on root@127.0.0.1 working with $DB_ROOT_PW and aren\u0027t using our $DB_USER account at all. To be safe, we likely need to also:\n\n        GRANT ALL PRIVILEGES ON *.*\n            TO \u0027root\u0027@\u0027%\u0027 identified by \u0027$DB_ROOT_PW\u0027 WITH GRANT OPTION;\"","commit_id":"7b7bce7249c970cf6ca3ea73b271a114abfc9287"},{"author":{"_account_id":5263,"name":"Jeremy Stanley","display_name":"fungi","email":"fungi@yuggoth.org","username":"fungi","status":"missing, presumed fed"},"change_message_id":"ec4d1a69a09a390488d9bb05efbdc377386b52fb","unresolved":false,"context_lines":[{"line_number":688,"context_line":"          DB_PW\u003dopenstack_citest"},{"line_number":689,"context_line":"          sudo -H mysqladmin -u root password $DB_ROOT_PW"},{"line_number":690,"context_line":"          # note; we remove anonymous users first"},{"line_number":691,"context_line":"          sudo -H mysql -u root -p$DB_ROOT_PW -h localhost -e \""},{"line_number":692,"context_line":"              DELETE FROM mysql.user WHERE User\u003d\u0027\u0027;"},{"line_number":693,"context_line":"              FLUSH PRIVILEGES;"},{"line_number":694,"context_line":"              GRANT ALL PRIVILEGES ON *.*"}],"source_content_type":"text/x-yaml","patch_set":1,"id":"1aa78d24_66ea2f11","line":691,"updated":"2016-07-05 15:08:14.000000000","message":"Restricting it to 127.0.0.1 would also be fine with me, though it\u0027s not as if this is used for any secure deployments at all (the separate account being created is basically also root-equivalent and authenticated via a published password from anywhere).","commit_id":"7b7bce7249c970cf6ca3ea73b271a114abfc9287"},{"author":{"_account_id":2,"name":"Monty Taylor","email":"mordred@inaugust.com","username":"mordred"},"change_message_id":"ca07ecf3b6d8b2eee2a910de7198e60fad4da2cb","unresolved":false,"context_lines":[{"line_number":688,"context_line":"          DB_PW\u003dopenstack_citest"},{"line_number":689,"context_line":"          sudo -H mysqladmin -u root password $DB_ROOT_PW"},{"line_number":690,"context_line":"          # note; we remove anonymous users first"},{"line_number":691,"context_line":"          sudo -H mysql -u root -p$DB_ROOT_PW -h localhost -e \""},{"line_number":692,"context_line":"              DELETE FROM mysql.user WHERE User\u003d\u0027\u0027;"},{"line_number":693,"context_line":"              FLUSH PRIVILEGES;"},{"line_number":694,"context_line":"              GRANT ALL PRIVILEGES ON *.*"}],"source_content_type":"text/x-yaml","patch_set":1,"id":"1aa78d24_06eecbeb","line":691,"in_reply_to":"1aa78d24_134babb1","updated":"2016-07-05 15:11:37.000000000","message":"The grant all would work. Also, trying out update mysql.user set Host\u003d\u0027%\u0027 where Host\u003d\u0027localhost\u0027 before the flush privileges would be fine too.\n\nRemoving the anonymous user usually clears up issues with localhost vs. 127.0.0.1, but if there is new magic in xenial then yay.","commit_id":"7b7bce7249c970cf6ca3ea73b271a114abfc9287"},{"author":{"_account_id":13252,"name":"Dr. Jens Harbott","display_name":"Jens Harbott (frickler)","email":"frickler@offenerstapel.de","username":"jrosenboom"},"change_message_id":"4b057c227292fcc9fbaf7019c122e87492a52890","unresolved":false,"context_lines":[{"line_number":688,"context_line":"          DB_PW\u003dopenstack_citest"},{"line_number":689,"context_line":"          sudo -H mysqladmin -u root password $DB_ROOT_PW"},{"line_number":690,"context_line":"          # note; we remove anonymous users first"},{"line_number":691,"context_line":"          sudo -H mysql -u root -p$DB_ROOT_PW -h localhost -e \""},{"line_number":692,"context_line":"              DELETE FROM mysql.user WHERE User\u003d\u0027\u0027;"},{"line_number":693,"context_line":"              FLUSH PRIVILEGES;"},{"line_number":694,"context_line":"              GRANT ALL PRIVILEGES ON *.*"}],"source_content_type":"text/x-yaml","patch_set":1,"id":"1aa78d24_134babb1","line":691,"in_reply_to":"1aa78d24_932afb2a","updated":"2016-07-05 15:00:32.000000000","message":"Hmm, I\u0027m not sure that one would really want the @\u0027%\u0027, but @\u0027127.0.0.1\u0027 should work.","commit_id":"7b7bce7249c970cf6ca3ea73b271a114abfc9287"},{"author":{"_account_id":6547,"name":"Andreas Jaeger","email":"jaegerandi@gmail.com","username":"jaegerandi"},"change_message_id":"46ee7a33dc7763e2a06036360c3ae10ba94a8419","unresolved":false,"context_lines":[{"line_number":723,"context_line":"          #!/bin/bash -xe"},{"line_number":724,"context_line":"          DB_USER\u003dopenstack_citest"},{"line_number":725,"context_line":"          DB_PW\u003dopenstack_citest"},{"line_number":726,"context_line":"          mysql -u $DB_USER -p$DB_PW -h 127.0.0.1 -e \""},{"line_number":727,"context_line":"              SET default_storage_engine\u003dMYISAM;"},{"line_number":728,"context_line":"              DROP DATABASE IF EXISTS {db_name};"},{"line_number":729,"context_line":"              CREATE DATABASE {db_name} CHARACTER SET utf8;\""}],"source_content_type":"text/x-yaml","patch_set":1,"id":"1aa78d24_2aa75350","line":726,"range":{"start_line":726,"start_character":39,"end_line":726,"end_character":50},"updated":"2016-07-05 12:48:18.000000000","message":"Don\u0027t we need to change this as well?","commit_id":"7b7bce7249c970cf6ca3ea73b271a114abfc9287"},{"author":{"_account_id":13252,"name":"Dr. Jens Harbott","display_name":"Jens Harbott (frickler)","email":"frickler@offenerstapel.de","username":"jrosenboom"},"change_message_id":"37cab188c22e024440287852a0fb629ef589017f","unresolved":false,"context_lines":[{"line_number":723,"context_line":"          #!/bin/bash -xe"},{"line_number":724,"context_line":"          DB_USER\u003dopenstack_citest"},{"line_number":725,"context_line":"          DB_PW\u003dopenstack_citest"},{"line_number":726,"context_line":"          mysql -u $DB_USER -p$DB_PW -h 127.0.0.1 -e \""},{"line_number":727,"context_line":"              SET default_storage_engine\u003dMYISAM;"},{"line_number":728,"context_line":"              DROP DATABASE IF EXISTS {db_name};"},{"line_number":729,"context_line":"              CREATE DATABASE {db_name} CHARACTER SET utf8;\""}],"source_content_type":"text/x-yaml","patch_set":1,"id":"1aa78d24_d058fe34","line":726,"in_reply_to":"1aa78d24_2aa75350","updated":"2016-07-05 13:08:51.000000000","message":"No, after the privileges for $DB_USER are set up as above, this will work fine.","commit_id":"7b7bce7249c970cf6ca3ea73b271a114abfc9287"}]}