)]}'
{"elements/mysql/install.d/20-galera-libssl-symlink":[{"author":{"_account_id":7582,"name":"Jan Provaznik","email":"jan.provaznik@gmail.com","username":"jprovazn"},"change_message_id":"58c7bb245dfed43f9be36258365a210a62d8abc3","unresolved":false,"context_lines":[{"line_number":6,"context_line":"# xtradb-cluster is built expecting libssl and libcryto have the following"},{"line_number":7,"context_line":"# versions. Doing this is terrifying stability-wise for a database."},{"line_number":8,"context_line":""},{"line_number":9,"context_line":"LIB_PREFIX\u003d/lib/x86_64-linux-gnu"},{"line_number":10,"context_line":""},{"line_number":11,"context_line":"if [ ! -L $LIB_PREFIX/libssl.so.10 ]; then"},{"line_number":12,"context_line":"    ln -s $LIB_PREFIX/libssl.so.1.0.0 $LIB_PREFIX/libssl.so.10"}],"source_content_type":"application/x-shellscript","patch_set":8,"id":"AAAAWH%2F9dM0%3D","line":9,"updated":"2014-04-04 11:51:10.000000000","message":"This is arch-specific path - we should take into account i386 too.","commit_id":"3ac1b49776c4fb55e9373db02d2b27e4075a0e35"},{"author":{"_account_id":7582,"name":"Jan Provaznik","email":"jan.provaznik@gmail.com","username":"jprovazn"},"change_message_id":"4f9e5dbb885690b0b86c43eb3829989f649e2e26","unresolved":false,"context_lines":[{"line_number":9,"context_line":"LIB_PREFIX\u003d/lib/x86_64-linux-gnu"},{"line_number":10,"context_line":""},{"line_number":11,"context_line":"if [ ! -L $LIB_PREFIX/libssl.so.10 ]; then"},{"line_number":12,"context_line":"    ln -s $LIB_PREFIX/libssl.so.1.0.0 $LIB_PREFIX/libssl.so.10"},{"line_number":13,"context_line":"fi"},{"line_number":14,"context_line":""},{"line_number":15,"context_line":"if [ ! -L $LIB_PREFIX/libcrypto.so.10 ]; then"}],"source_content_type":"application/x-shellscript","patch_set":8,"id":"AAAAWH%2F9dOM%3D","line":12,"updated":"2014-04-04 11:49:14.000000000","message":"On fedora are libssl and libvrypto libs in /usr/lib64/ (or /usr/lib for i386) dir.","commit_id":"3ac1b49776c4fb55e9373db02d2b27e4075a0e35"}],"elements/mysql/os-config-applier/mnt/state/etc/mysql/conf.d/xtradb-cluster.cnf":[{"author":{"_account_id":4190,"name":"lifeless","email":"robertc@robertcollins.net","username":"lifeless"},"change_message_id":"35161f5e91aa69c6bc6af1949dc6db932cef07ef","unresolved":false,"context_lines":[{"line_number":8,"context_line":"wsrep_sst_method\u003dxtrabackup"},{"line_number":9,"context_line":""},{"line_number":10,"context_line":"# Cluster name"},{"line_number":11,"context_line":"wsrep_cluster_name\u003dtripleo"},{"line_number":12,"context_line":""},{"line_number":13,"context_line":"# Authentication for SST method"},{"line_number":14,"context_line":"wsrep_sst_auth\u003d\"sstuser:s3cretPass\""}],"source_content_type":"application/octet-stream","patch_set":2,"id":"AAAAWH%2F%2BPSs%3D","line":11,"updated":"2014-03-28 07:01:09.000000000","message":"This will be a problem - it should probably include the stack uuid or something.","commit_id":"7127a00266b4ebafe59013a3c223924c1b2a1432"},{"author":{"_account_id":4190,"name":"lifeless","email":"robertc@robertcollins.net","username":"lifeless"},"change_message_id":"35161f5e91aa69c6bc6af1949dc6db932cef07ef","unresolved":false,"context_lines":[{"line_number":11,"context_line":"wsrep_cluster_name\u003dtripleo"},{"line_number":12,"context_line":""},{"line_number":13,"context_line":"# Authentication for SST method"},{"line_number":14,"context_line":"wsrep_sst_auth\u003d\"sstuser:s3cretPass\""}],"source_content_type":"application/octet-stream","patch_set":2,"id":"AAAAWH%2F%2BPSk%3D","line":14,"updated":"2014-03-28 07:01:09.000000000","message":"These should be parameters, no ?","commit_id":"7127a00266b4ebafe59013a3c223924c1b2a1432"},{"author":{"_account_id":7582,"name":"Jan Provaznik","email":"jan.provaznik@gmail.com","username":"jprovazn"},"change_message_id":"4e7ef6e4b0e8dc37ff306768356e860209b00ea9","unresolved":false,"context_lines":[{"line_number":13,"context_line":""},{"line_number":14,"context_line":"# Authentication for SST method"},{"line_number":15,"context_line":"# This is not required when using rsync as sst method"},{"line_number":16,"context_line":"wsrep_sst_auth\u003d\"{{mysql.sstusername}}:{{mysql.sstpassword}}\""}],"source_content_type":"application/octet-stream","patch_set":5,"id":"AAAAWH%2F947Y%3D","line":16,"updated":"2014-04-01 11:57:23.000000000","message":"What is the reason to keep it here if rsync method is used?","commit_id":"e2b20d736ba86fedb042c2ec9a6fcf35acb8b442"},{"author":{"_account_id":4190,"name":"lifeless","email":"robertc@robertcollins.net","username":"lifeless"},"change_message_id":"f14be4aec9c5ce3da101b80d42997b595d3e7edd","unresolved":false,"context_lines":[{"line_number":2,"context_line":"# Path to Galera library"},{"line_number":3,"context_line":"wsrep_provider\u003d/usr/local/mysql/lib/libgalera_smm.so"},{"line_number":4,"context_line":""},{"line_number":5,"context_line":"# Empty gcomm address is being used when cluster is getting bootstrapped"},{"line_number":6,"context_line":"wsrep_cluster_address\u003dgcomm://{{mysql.nodes}}"},{"line_number":7,"context_line":""},{"line_number":8,"context_line":"# SST method"}],"source_content_type":"application/octet-stream","patch_set":6,"id":"AAAAWH%2F9z68%3D","line":5,"updated":"2014-04-02 00:01:44.000000000","message":"This comment doesn\u0027t have enough info for me to process.","commit_id":"e513c5690afb4800e343570dae115603692e11f3"},{"author":{"_account_id":4190,"name":"lifeless","email":"robertc@robertcollins.net","username":"lifeless"},"change_message_id":"f14be4aec9c5ce3da101b80d42997b595d3e7edd","unresolved":false,"context_lines":[{"line_number":9,"context_line":"wsrep_sst_method\u003drsync"},{"line_number":10,"context_line":""},{"line_number":11,"context_line":"# Cluster name"},{"line_number":12,"context_line":"wsrep_cluster_name\u003dtripleo"}],"source_content_type":"application/octet-stream","patch_set":6,"id":"AAAAWH%2F9z6g%3D","line":12,"updated":"2014-04-02 00:01:44.000000000","message":"I believe I commented before - but this really should be unique per deploy - e.g. a heat random string.","commit_id":"e513c5690afb4800e343570dae115603692e11f3"}],"elements/mysql/os-refresh-config/configure.d/51-mysql-init":[{"author":{"_account_id":4190,"name":"lifeless","email":"robertc@robertcollins.net","username":"lifeless"},"change_message_id":"f14be4aec9c5ce3da101b80d42997b595d3e7edd","unresolved":false,"context_lines":[{"line_number":12,"context_line":"    # Needed to setup initial tables. This command is idempotent."},{"line_number":13,"context_line":"    /usr/local/mysql/scripts/mysql_install_db --user\u003dmysql --basedir\u003d/usr/local/mysql --datadir\u003d/mnt/state/var/lib/mysql --no-defaults --pid-file\u003d$pid_path  --wsrep-new-cluster"},{"line_number":14,"context_line":""},{"line_number":15,"context_line":"    # We install an init script in this element so we know the service "},{"line_number":16,"context_line":"    # command will work"},{"line_number":17,"context_line":"    service mysql bootstrap-pxc"},{"line_number":18,"context_line":"else"}],"source_content_type":"application/x-shellscript","patch_set":6,"id":"AAAAWH%2F9z78%3D","line":15,"updated":"2014-04-02 00:01:44.000000000","message":"nit: Trailing whitespace","commit_id":"e513c5690afb4800e343570dae115603692e11f3"},{"author":{"_account_id":7582,"name":"Jan Provaznik","email":"jan.provaznik@gmail.com","username":"jprovazn"},"change_message_id":"82e06cfe5bacc79108d54f01fe0f8b17fd04ddf3","unresolved":false,"context_lines":[{"line_number":12,"context_line":"if [ ! -e ${MYSQL_INITIALIZED} ]; then"},{"line_number":13,"context_line":"    if [ \"$BOOTSTRAP_NODE\" \u003d\u003d \"$MY_HOST\" ]; then"},{"line_number":14,"context_line":"        # Needed to setup initial tables. This command is idempotent."},{"line_number":15,"context_line":"        /usr/local/mysql/scripts/mysql_install_db --user\u003dmysql --basedir\u003d/usr/local/mysql --datadir\u003d/mnt/state/var/lib/mysql --no-defaults --pid-file\u003d$pid_path  --wsrep-new-cluster"},{"line_number":16,"context_line":""},{"line_number":17,"context_line":"        # We install an init script in this element so we know the service"},{"line_number":18,"context_line":"        # command will work"}],"source_content_type":"application/x-shellscript","patch_set":8,"id":"AAAAWH%2F9cnc%3D","line":15,"updated":"2014-04-04 13:15:38.000000000","message":"mysql_install_db should be executed also if mysql runs in standalone/not-clustered mode","commit_id":"3ac1b49776c4fb55e9373db02d2b27e4075a0e35"},{"author":{"_account_id":7582,"name":"Jan Provaznik","email":"jan.provaznik@gmail.com","username":"jprovazn"},"change_message_id":"927d40b52d9bd74ff4fc60eefff8ccf15497eeaa","unresolved":false,"context_lines":[{"line_number":12,"context_line":"if [ ! -e ${MYSQL_INITIALIZED} ]; then"},{"line_number":13,"context_line":"    if [ \"$BOOTSTRAP_NODE\" \u003d\u003d \"$MY_HOST\" ]; then"},{"line_number":14,"context_line":"        # Needed to setup initial tables. This command is idempotent."},{"line_number":15,"context_line":"        /usr/local/mysql/scripts/mysql_install_db --user\u003dmysql --basedir\u003d/usr/local/mysql --datadir\u003d/mnt/state/var/lib/mysql --no-defaults --pid-file\u003d$pid_path  --wsrep-new-cluster"},{"line_number":16,"context_line":""},{"line_number":17,"context_line":"        # We install an init script in this element so we know the service"},{"line_number":18,"context_line":"        # command will work"}],"source_content_type":"application/x-shellscript","patch_set":8,"id":"AAAAWH%2F9QuU%3D","line":15,"in_reply_to":"AAAAWH%2F9YtY%3D","updated":"2014-04-07 15:21:16.000000000","message":"If mysql.nodes is not set, it means that template doesn\u0027t define mysql cluster so starting node in standalone mode is reasonable.\n\nignore my original comment - I had to mix this patch with another one.","commit_id":"3ac1b49776c4fb55e9373db02d2b27e4075a0e35"},{"author":{"_account_id":10035,"name":"greghaynes","email":"greg@greghaynes.net","username":"greghaynes"},"change_message_id":"c485a93d056d6ff9afe67ef0c06b01b3b0ffa31b","unresolved":false,"context_lines":[{"line_number":12,"context_line":"if [ ! -e ${MYSQL_INITIALIZED} ]; then"},{"line_number":13,"context_line":"    if [ \"$BOOTSTRAP_NODE\" \u003d\u003d \"$MY_HOST\" ]; then"},{"line_number":14,"context_line":"        # Needed to setup initial tables. This command is idempotent."},{"line_number":15,"context_line":"        /usr/local/mysql/scripts/mysql_install_db --user\u003dmysql --basedir\u003d/usr/local/mysql --datadir\u003d/mnt/state/var/lib/mysql --no-defaults --pid-file\u003d$pid_path  --wsrep-new-cluster"},{"line_number":16,"context_line":""},{"line_number":17,"context_line":"        # We install an init script in this element so we know the service"},{"line_number":18,"context_line":"        # command will work"}],"source_content_type":"application/x-shellscript","patch_set":8,"id":"AAAAWH%2F9YtY%3D","line":15,"in_reply_to":"AAAAWH%2F9cnc%3D","updated":"2014-04-04 21:41:26.000000000","message":"This made me notice a scary bit of behavior - if the mysql.nodes and mysql.host properties are not added in the heat template every node will attempt to make itself a master.\n\nI dont understand your issue though - if there is a one node setup then the conditional will be true and mysql_install_db will execute.","commit_id":"3ac1b49776c4fb55e9373db02d2b27e4075a0e35"}],"elements/mysql/os-refresh-config/configure.d/51-mysql-install-db":[{"author":{"_account_id":7582,"name":"Jan Provaznik","email":"jan.provaznik@gmail.com","username":"jprovazn"},"change_message_id":"4e7ef6e4b0e8dc37ff306768356e860209b00ea9","unresolved":false,"context_lines":[{"line_number":9,"context_line":"chown mysql:root $(dirname $pid_path)"},{"line_number":10,"context_line":""},{"line_number":11,"context_line":"if [ \"$BOOTSTRAP_NODE\" \u003d\u003d \"$MY_HOST\" ]; then"},{"line_number":12,"context_line":"    sed -i \u0027s/wsrep_cluster_address\u003dgcomm:\\/\\/.*/wsrep_cluster_address\u003dgcomm:\\/\\//\u0027 /etc/mysql/conf.d/xtradb-cluster.cnf"},{"line_number":13,"context_line":""},{"line_number":14,"context_line":"    # Needed to setup initial tables. This command is idempotent."},{"line_number":15,"context_line":"    /usr/local/mysql/scripts/mysql_install_db --user\u003dmysql --basedir\u003d/usr/local/mysql --datadir\u003d/mnt/state/var/lib/mysql --no-defaults --pid-file\u003d$pid_path"}],"source_content_type":"application/x-shellscript","patch_set":5,"id":"AAAAWH%2F9470%3D","line":12,"updated":"2014-04-01 11:57:23.000000000","message":"If wsrep_cluster_address is changed directly in config file, I think that it should be set to \"gcomm://\" only for the \"first node init\" momment. Then it should be set back to the list of all nodes in cluster - if mysql service is later restarted on this node it should connect to the cluster which will already exist (not stay in standalone mode).\n\nNice thing is that it\u0027s not necessary to change the url directly in config file for bootstrap, you can use \"service mysql bootstrap-pxc\" for initializing cluster on first node.","commit_id":"e2b20d736ba86fedb042c2ec9a6fcf35acb8b442"}],"elements/mysql/os-refresh-config/pre-configure.d/20-galera-libssl-symlink":[{"author":{"_account_id":4190,"name":"lifeless","email":"robertc@robertcollins.net","username":"lifeless"},"change_message_id":"35161f5e91aa69c6bc6af1949dc6db932cef07ef","unresolved":false,"context_lines":[{"line_number":1,"context_line":"#!/bin/bash"},{"line_number":2,"context_line":"set -eu"},{"line_number":3,"context_line":""},{"line_number":4,"context_line":"# xtradb-cluster is built expecting libssl and libcryto have the following"},{"line_number":5,"context_line":"# versions. Doing this is terrifying stability-wise for a database."}],"source_content_type":"application/x-shellscript","patch_set":2,"id":"AAAAWH%2F%2BPSc%3D","line":2,"updated":"2014-03-28 07:01:09.000000000","message":"Missing set -o pipefail.","commit_id":"7127a00266b4ebafe59013a3c223924c1b2a1432"},{"author":{"_account_id":4190,"name":"lifeless","email":"robertc@robertcollins.net","username":"lifeless"},"change_message_id":"35161f5e91aa69c6bc6af1949dc6db932cef07ef","unresolved":false,"context_lines":[{"line_number":3,"context_line":""},{"line_number":4,"context_line":"# xtradb-cluster is built expecting libssl and libcryto have the following"},{"line_number":5,"context_line":"# versions. Doing this is terrifying stability-wise for a database."},{"line_number":6,"context_line":" "},{"line_number":7,"context_line":"$LIB_PREFIX\u003d/lib/x86_64-linux-gnu"},{"line_number":8,"context_line":""},{"line_number":9,"context_line":"if [ -L $LIB_PREFIX/libssl.so.10 ]; then"}],"source_content_type":"application/x-shellscript","patch_set":2,"id":"AAAAWH%2F%2BPSg%3D","line":6,"updated":"2014-03-28 07:01:09.000000000","message":"whitespace.","commit_id":"7127a00266b4ebafe59013a3c223924c1b2a1432"},{"author":{"_account_id":4190,"name":"lifeless","email":"robertc@robertcollins.net","username":"lifeless"},"change_message_id":"35161f5e91aa69c6bc6af1949dc6db932cef07ef","unresolved":false,"context_lines":[{"line_number":6,"context_line":" "},{"line_number":7,"context_line":"$LIB_PREFIX\u003d/lib/x86_64-linux-gnu"},{"line_number":8,"context_line":""},{"line_number":9,"context_line":"if [ -L $LIB_PREFIX/libssl.so.10 ]; then"},{"line_number":10,"context_line":"    ln -s $LIB_PREFIX/libssl.so.1.0.0 $LIB_PREFIX/libssl.so.10"},{"line_number":11,"context_line":"fi"},{"line_number":12,"context_line":""}],"source_content_type":"application/x-shellscript","patch_set":2,"id":"AAAAWH%2F%2BPRs%3D","line":9,"updated":"2014-03-28 07:01:09.000000000","message":"I\u0027d like a bug somewhere, and a reference to same, for this fugly.","commit_id":"7127a00266b4ebafe59013a3c223924c1b2a1432"},{"author":{"_account_id":4190,"name":"lifeless","email":"robertc@robertcollins.net","username":"lifeless"},"change_message_id":"35161f5e91aa69c6bc6af1949dc6db932cef07ef","unresolved":false,"context_lines":[{"line_number":10,"context_line":"    ln -s $LIB_PREFIX/libssl.so.1.0.0 $LIB_PREFIX/libssl.so.10"},{"line_number":11,"context_line":"fi"},{"line_number":12,"context_line":""},{"line_number":13,"context_line":"if [ -L $LIB_PREFIX/libcrypto.so.10 ]; then "},{"line_number":14,"context_line":"    ln -s $LIB_PREFIX/libcrypto.so.1.0.0 $LIB_PREFIX/libcrypto.so.10"},{"line_number":15,"context_line":"fi"}],"source_content_type":"application/x-shellscript","patch_set":2,"id":"AAAAWH%2F%2BPSY%3D","line":13,"updated":"2014-03-28 07:01:09.000000000","message":"whitespace","commit_id":"7127a00266b4ebafe59013a3c223924c1b2a1432"}]}