)]}'
{"/PATCHSET_LEVEL":[{"author":{"_account_id":6962,"name":"Kashyap Chamarthy","email":"kchamart@redhat.com","username":"kashyapc"},"change_message_id":"15ae0ac925c0cd171bf80bffe9309336e92ed9f6","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":1,"id":"69386f90_c1b8b7fb","updated":"2022-05-05 14:56:00.000000000","message":"Thank you for the quick fix!","commit_id":"ecce524b59f63c8899af6966b6216a61d2d90f59"}],"tools/test-setup.sh":[{"author":{"_account_id":6962,"name":"Kashyap Chamarthy","email":"kchamart@redhat.com","username":"kashyapc"},"change_message_id":"15ae0ac925c0cd171bf80bffe9309336e92ed9f6","unresolved":true,"context_lines":[{"line_number":41,"context_line":""},{"line_number":42,"context_line":"if is_rhel7 || is_rhel8 || is_fedora35; then"},{"line_number":43,"context_line":"    # mysql needs to be started on centos/rhel"},{"line_number":44,"context_line":"    sudo systemctl restart mariadb.service"},{"line_number":45,"context_line":""},{"line_number":46,"context_line":"    # postgres setup for centos"},{"line_number":47,"context_line":"    sudo postgresql-setup --initdb"}],"source_content_type":"text/x-sh","patch_set":1,"id":"0bd1d356_d1785d42","line":44,"updated":"2022-05-05 14:56:00.000000000","message":"The comment says \"started\", but the command does a \"restart\".  You might want to adjust the comment while at it.","commit_id":"ecce524b59f63c8899af6966b6216a61d2d90f59"},{"author":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"change_message_id":"ffd5ac00ca235cfaebd12988b65dbc210c2b9ec8","unresolved":true,"context_lines":[{"line_number":56,"context_line":"    sudo systemctl restart postgresql.service"},{"line_number":57,"context_line":"fi"},{"line_number":58,"context_line":""},{"line_number":59,"context_line":"sudo -H mysqladmin -u root password $DB_ROOT_PW"},{"line_number":60,"context_line":""},{"line_number":61,"context_line":"# It\u0027s best practice to remove anonymous users from the database.  If"},{"line_number":62,"context_line":"# an anonymous user exists, then it matches first for connections and"}],"source_content_type":"text/x-sh","patch_set":1,"id":"10400c67_5209bfda","line":59,"updated":"2022-05-05 16:09:19.000000000","message":"Now the job fails here with:\n\n\u003e   \n\u003e mysqladmin: [Warning] Using a password on the command line interface can be\n\u003e insecure.\n\u003e  \n\u003e 2022-05-05 15:08:05.245108 | fedora-35 | Warning: Since password will be sent\n\u003e to server in plain text, use ssl connection to ensure password safety.\n\u003e  \n\u003e 2022-05-05 15:08:05.245447 | fedora-35 | \u0007mysqladmin: unable to change password;\n\u003e error: \u0027You have an error in your SQL syntax; check the manual that corresponds \n\u003e to your MariaDB server version for the right syntax to use near \u0027() IDENTIFIED BY \n\u003e \u0027insecure_slave\u0027\u0027 at line 1\u0027\n\n\nI can reproduce the failure with a fedora 35 cloud image locally. But failed to figure out what is wrong with this simple password changing mysqladmin command.\n\n[1] https://zuul.opendev.org/t/openstack/build/82bd935baed748f8807a968046280bda/log/job-output.txt#487","commit_id":"ecce524b59f63c8899af6966b6216a61d2d90f59"}]}