)]}'
{"manifests/server.pp":[{"author":{"_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},"change_message_id":"3eaafbbf71cbdc8dbd7cb3b5a883d04cd96c0c50","unresolved":false,"context_lines":[{"line_number":36,"context_line":"    ensure  \u003d\u003e present,"},{"line_number":37,"context_line":"    owner   \u003d\u003e \u0027root\u0027,"},{"line_number":38,"context_line":"    group   \u003d\u003e \u0027root\u0027,"},{"line_number":39,"context_line":"    mode    \u003d\u003e \u00270555\u0027,"},{"line_number":40,"context_line":"    content \u003d\u003e template(\u0027subunit2sql/subunit2sql-my.cnf.erb\u0027),"},{"line_number":41,"context_line":"  }"},{"line_number":42,"context_line":""}],"source_content_type":"text/x-puppet","patch_set":7,"id":"9a80dd14_99bf1afb","line":39,"updated":"2015-03-06 00:15:35.000000000","message":"The mode should probably be 0400 so that random users can\u0027t read the mysql secrets.","commit_id":"ae468a26a3dba663e569c1c017b06eb5a27000d1"},{"author":{"_account_id":5196,"name":"Matthew Treinish","email":"mtreinish@kortar.org","username":"treinish"},"change_message_id":"3355cf14448c730a1d833400085471dcb52009a0","unresolved":false,"context_lines":[{"line_number":36,"context_line":"    ensure  \u003d\u003e present,"},{"line_number":37,"context_line":"    owner   \u003d\u003e \u0027root\u0027,"},{"line_number":38,"context_line":"    group   \u003d\u003e \u0027root\u0027,"},{"line_number":39,"context_line":"    mode    \u003d\u003e \u00270555\u0027,"},{"line_number":40,"context_line":"    content \u003d\u003e template(\u0027subunit2sql/subunit2sql-my.cnf.erb\u0027),"},{"line_number":41,"context_line":"  }"},{"line_number":42,"context_line":""}],"source_content_type":"text/x-puppet","patch_set":7,"id":"9a80dd14_99563ad1","line":39,"in_reply_to":"9a80dd14_99bf1afb","updated":"2015-03-06 00:22:45.000000000","message":"Done","commit_id":"ae468a26a3dba663e569c1c017b06eb5a27000d1"},{"author":{"_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},"change_message_id":"3eaafbbf71cbdc8dbd7cb3b5a883d04cd96c0c50","unresolved":false,"context_lines":[{"line_number":41,"context_line":"  }"},{"line_number":42,"context_line":""},{"line_number":43,"context_line":"  exec { \u0027backup_subunit2sql_db\u0027:"},{"line_number":44,"context_line":"    command     \u003d\u003e \u0027mysqldump --defaults-file\u003d/etc/subunit2sql-my.cnf --opt --ignore-table mysql.event $db_name | gzip -9 \u003e /opt/subunit2sql.sql.gz\u0027,"},{"line_number":45,"context_line":"    path        \u003d\u003e \u0027/usr/local/bin:/usr/bin:/bin/\u0027,"},{"line_number":46,"context_line":"    subscribe   \u003d\u003e ["},{"line_number":47,"context_line":"      Package[\u0027subunit2sql\u0027],"}],"source_content_type":"text/x-puppet","patch_set":7,"id":"9a80dd14_b9ba1e08","line":44,"updated":"2015-03-06 00:15:35.000000000","message":"Can\u0027t you ignore the entire mysql db rather than just the table?","commit_id":"ae468a26a3dba663e569c1c017b06eb5a27000d1"},{"author":{"_account_id":5196,"name":"Matthew Treinish","email":"mtreinish@kortar.org","username":"treinish"},"change_message_id":"3355cf14448c730a1d833400085471dcb52009a0","unresolved":false,"context_lines":[{"line_number":41,"context_line":"  }"},{"line_number":42,"context_line":""},{"line_number":43,"context_line":"  exec { \u0027backup_subunit2sql_db\u0027:"},{"line_number":44,"context_line":"    command     \u003d\u003e \u0027mysqldump --defaults-file\u003d/etc/subunit2sql-my.cnf --opt --ignore-table mysql.event $db_name | gzip -9 \u003e /opt/subunit2sql.sql.gz\u0027,"},{"line_number":45,"context_line":"    path        \u003d\u003e \u0027/usr/local/bin:/usr/bin:/bin/\u0027,"},{"line_number":46,"context_line":"    subscribe   \u003d\u003e ["},{"line_number":47,"context_line":"      Package[\u0027subunit2sql\u0027],"}],"source_content_type":"text/x-puppet","patch_set":7,"id":"9a80dd14_d906f2cd","line":44,"in_reply_to":"9a80dd14_b9ba1e08","updated":"2015-03-06 00:22:45.000000000","message":"Actually this is just lazy copy and paste from the mysql_backup module. It wouldn\u0027t even try to copy this table because we\u0027re only running it on the subunit2sql db. (the mysql_backup module does everything on mysql IIRC)","commit_id":"ae468a26a3dba663e569c1c017b06eb5a27000d1"},{"author":{"_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},"change_message_id":"3eaafbbf71cbdc8dbd7cb3b5a883d04cd96c0c50","unresolved":false,"context_lines":[{"line_number":45,"context_line":"    path        \u003d\u003e \u0027/usr/local/bin:/usr/bin:/bin/\u0027,"},{"line_number":46,"context_line":"    subscribe   \u003d\u003e ["},{"line_number":47,"context_line":"      Package[\u0027subunit2sql\u0027],"},{"line_number":48,"context_line":"      File[\u0027/etc/subunit2sql-my.cnf\u0027],"},{"line_number":49,"context_line":"    ],"},{"line_number":50,"context_line":"    refreshonly \u003d\u003e true,"},{"line_number":51,"context_line":"  }"}],"source_content_type":"text/x-puppet","patch_set":7,"id":"9a80dd14_d938b2a2","line":48,"updated":"2015-03-06 00:15:35.000000000","message":"You should require his file but don\u0027t subscribe against it, otherwise each time the file changes you will get a new backup.","commit_id":"ae468a26a3dba663e569c1c017b06eb5a27000d1"},{"author":{"_account_id":5196,"name":"Matthew Treinish","email":"mtreinish@kortar.org","username":"treinish"},"change_message_id":"3355cf14448c730a1d833400085471dcb52009a0","unresolved":false,"context_lines":[{"line_number":45,"context_line":"    path        \u003d\u003e \u0027/usr/local/bin:/usr/bin:/bin/\u0027,"},{"line_number":46,"context_line":"    subscribe   \u003d\u003e ["},{"line_number":47,"context_line":"      Package[\u0027subunit2sql\u0027],"},{"line_number":48,"context_line":"      File[\u0027/etc/subunit2sql-my.cnf\u0027],"},{"line_number":49,"context_line":"    ],"},{"line_number":50,"context_line":"    refreshonly \u003d\u003e true,"},{"line_number":51,"context_line":"  }"}],"source_content_type":"text/x-puppet","patch_set":7,"id":"9a80dd14_39146ef4","line":48,"in_reply_to":"9a80dd14_d938b2a2","updated":"2015-03-06 00:22:45.000000000","message":"Done","commit_id":"ae468a26a3dba663e569c1c017b06eb5a27000d1"},{"author":{"_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},"change_message_id":"3eaafbbf71cbdc8dbd7cb3b5a883d04cd96c0c50","unresolved":false,"context_lines":[{"line_number":53,"context_line":"  exec { \u0027upgrade_subunit2sql_db\u0027:"},{"line_number":54,"context_line":"    command     \u003d\u003e \u0027subunit2sql-db-manage --config-file /etc/subunit2sql.conf upgrade head\u0027,"},{"line_number":55,"context_line":"    path        \u003d\u003e \u0027/usr/local/bin:/usr/bin:/bin/\u0027,"},{"line_number":56,"context_line":"    subscribe   \u003d\u003e Exec[\u0027backup_subunit2sql_db\u0027],"},{"line_number":57,"context_line":"  }"},{"line_number":58,"context_line":"}"}],"source_content_type":"text/x-puppet","patch_set":7,"id":"9a80dd14_f93bb699","line":56,"updated":"2015-03-06 00:15:35.000000000","message":"This should still be a refreshonly otherwise you will migrate on every puppet run iirc.","commit_id":"ae468a26a3dba663e569c1c017b06eb5a27000d1"},{"author":{"_account_id":5196,"name":"Matthew Treinish","email":"mtreinish@kortar.org","username":"treinish"},"change_message_id":"3355cf14448c730a1d833400085471dcb52009a0","unresolved":false,"context_lines":[{"line_number":53,"context_line":"  exec { \u0027upgrade_subunit2sql_db\u0027:"},{"line_number":54,"context_line":"    command     \u003d\u003e \u0027subunit2sql-db-manage --config-file /etc/subunit2sql.conf upgrade head\u0027,"},{"line_number":55,"context_line":"    path        \u003d\u003e \u0027/usr/local/bin:/usr/bin:/bin/\u0027,"},{"line_number":56,"context_line":"    subscribe   \u003d\u003e Exec[\u0027backup_subunit2sql_db\u0027],"},{"line_number":57,"context_line":"  }"},{"line_number":58,"context_line":"}"}],"source_content_type":"text/x-puppet","patch_set":7,"id":"9a80dd14_b99bfe70","line":56,"in_reply_to":"9a80dd14_f93bb699","updated":"2015-03-06 00:22:45.000000000","message":"Done","commit_id":"ae468a26a3dba663e569c1c017b06eb5a27000d1"}]}
