)]}'
{"id":"openstack%2Fdevstack~115103","triplet_id":"openstack%2Fdevstack~master~I046ae22d59a99ef86da786c4d5db870814ce159f","project":"openstack/devstack","branch":"master","topic":"bug/1358485","hashtags":[],"change_id":"I046ae22d59a99ef86da786c4d5db870814ce159f","subject":"Fix MySQL password on Ubuntu","status":"ABANDONED","created":"2014-08-18 20:46:11.000000000","updated":"2014-12-10 16:01:48.000000000","total_comment_count":2,"unresolved_comment_count":0,"has_review_started":true,"meta_rev_id":"fcbcfefd9a682aaf592cf010605ec5bfbbb3ecb8","_number":115103,"virtual_id_number":115103,"owner":{"_account_id":475,"name":"Rick Harris","email":"rick.harris@rackspace.com","username":"rconradharris"},"actions":{},"labels":{"Verified":{"recommended":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"all":[{"value":1,"date":"2014-08-18 22:05:53.000000000","_account_id":10385,"name":"Citrix XenServer CI","username":"citrix_xenserver_ci","tags":["SERVICE_USER"]},{"value":1,"date":"2014-08-18 21:48:43.000000000","_account_id":3,"name":"Jenkins","username":"jenkins"},{"_account_id":7175,"name":"Robbie Harwood","email":"rharwood@redhat.com","username":"frozencemetery"},{"date":"2014-08-19 00:35:07.000000000","_account_id":475,"name":"Rick Harris","email":"rick.harris@rackspace.com","username":"rconradharris"},{"_account_id":7118,"name":"Ian Wienand","email":"iwienand@redhat.com","username":"iwienand"}],"values":{"-2":"Fails","-1":"Doesn\u0027t seem to work"," 0":"No score","+1":"Works for me","+2":"Verified"},"description":"","value":1,"default_value":0,"optional":true},"Code-Review":{"disliked":{"_account_id":7175,"name":"Robbie Harwood","email":"rharwood@redhat.com","username":"frozencemetery"},"all":[{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":10385,"name":"Citrix XenServer CI","username":"citrix_xenserver_ci","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":3,"name":"Jenkins","username":"jenkins"},{"value":-1,"date":"2014-08-26 17:01:53.000000000","permitted_voting_range":{"min":-1,"max":1},"_account_id":7175,"name":"Robbie Harwood","email":"rharwood@redhat.com","username":"frozencemetery"},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":475,"name":"Rick Harris","email":"rick.harris@rackspace.com","username":"rconradharris"},{"value":-1,"date":"2014-08-18 23:31:52.000000000","permitted_voting_range":{"min":-2,"max":2},"_account_id":7118,"name":"Ian Wienand","email":"iwienand@redhat.com","username":"iwienand"}],"values":{"-2":"Do not merge","-1":"This patch needs further work before it can be merged"," 0":"No score","+1":"Looks good to me, but someone else must approve","+2":"Looks good to me (core reviewer)"},"description":"","value":-1,"default_value":0,"optional":true},"Workflow":{"all":[{"_account_id":10385,"name":"Citrix XenServer CI","username":"citrix_xenserver_ci","tags":["SERVICE_USER"]},{"_account_id":3,"name":"Jenkins","username":"jenkins"},{"_account_id":7175,"name":"Robbie Harwood","email":"rharwood@redhat.com","username":"frozencemetery"},{"value":0,"permitted_voting_range":{"min":-1,"max":0},"_account_id":475,"name":"Rick Harris","email":"rick.harris@rackspace.com","username":"rconradharris"},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":7118,"name":"Ian Wienand","email":"iwienand@redhat.com","username":"iwienand"}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Review-Priority":{"all":[{"value":0,"permitted_voting_range":{"min":0,"max":2},"_account_id":10385,"name":"Citrix XenServer CI","username":"citrix_xenserver_ci","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":0,"max":2},"_account_id":3,"name":"Jenkins","username":"jenkins"},{"value":0,"permitted_voting_range":{"min":0,"max":2},"_account_id":7175,"name":"Robbie Harwood","email":"rharwood@redhat.com","username":"frozencemetery"},{"value":0,"permitted_voting_range":{"min":0,"max":2},"_account_id":475,"name":"Rick Harris","email":"rick.harris@rackspace.com","username":"rconradharris"},{"value":0,"permitted_voting_range":{"min":-1,"max":2},"_account_id":7118,"name":"Ian Wienand","email":"iwienand@redhat.com","username":"iwienand"}],"values":{"-1":"Branch Freeze"," 0":"No Priority","+1":"Important Change","+2":"Gate Blocker Fix / Urgent Change"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":3,"name":"Jenkins","username":"jenkins"},{"_account_id":475,"name":"Rick Harris","email":"rick.harris@rackspace.com","username":"rconradharris"},{"_account_id":7118,"name":"Ian Wienand","email":"iwienand@redhat.com","username":"iwienand"},{"_account_id":7175,"name":"Robbie Harwood","email":"rharwood@redhat.com","username":"frozencemetery"},{"_account_id":10385,"name":"Citrix XenServer CI","username":"citrix_xenserver_ci","tags":["SERVICE_USER"]}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2014-08-18 21:48:43.000000000","updated_by":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"reviewer":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"state":"REVIEWER"},{"updated":"2014-08-18 22:05:53.000000000","updated_by":{"_account_id":10385,"name":"Citrix XenServer CI","username":"citrix_xenserver_ci","tags":["SERVICE_USER"]},"reviewer":{"_account_id":10385,"name":"Citrix XenServer CI","username":"citrix_xenserver_ci","tags":["SERVICE_USER"]},"state":"REVIEWER"},{"updated":"2014-08-18 23:31:52.000000000","updated_by":{"_account_id":7118,"name":"Ian Wienand","email":"iwienand@redhat.com","username":"iwienand"},"reviewer":{"_account_id":7118,"name":"Ian Wienand","email":"iwienand@redhat.com","username":"iwienand"},"state":"REVIEWER"},{"updated":"2014-08-26 17:01:53.000000000","updated_by":{"_account_id":7175,"name":"Robbie Harwood","email":"rharwood@redhat.com","username":"frozencemetery"},"reviewer":{"_account_id":7175,"name":"Robbie Harwood","email":"rharwood@redhat.com","username":"frozencemetery"},"state":"REVIEWER"}],"messages":[{"id":"495f2f88aa69a7759875595b1ca7d07b4bf41645","author":{"_account_id":475,"name":"Rick Harris","email":"rick.harris@rackspace.com","username":"rconradharris"},"date":"2014-08-18 20:46:11.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"b4e2b7a17b1cd579dccb31fcce99a8cab23916ab","author":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"date":"2014-08-18 20:46:12.000000000","message":"Patch Set 1:\n\nStarting check jobs.\nhttp://status.openstack.org/zuul/","accounts_in_message":[],"_revision_number":1},{"id":"59ee80ccb3bed11e87252fa9181accc2d5f15957","author":{"_account_id":3,"name":"Jenkins","username":"jenkins"},"date":"2014-08-18 21:48:43.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded.\n\n- check-tempest-dsvm-full http://logs.openstack.org/03/115103/1/check/check-tempest-dsvm-full/0ff0783 : SUCCESS in 40m 24s\n- check-tempest-dsvm-postgres-full http://logs.openstack.org/03/115103/1/check/check-tempest-dsvm-postgres-full/38414be : SUCCESS in 49m 23s\n- check-tempest-dsvm-neutron-full http://logs.openstack.org/03/115103/1/check/check-tempest-dsvm-neutron-full/5e2ad5a : SUCCESS in 1h 02m 24s\n- check-tempest-dsvm-neutron-heat-slow http://logs.openstack.org/03/115103/1/check/check-tempest-dsvm-neutron-heat-slow/be486ec : SUCCESS in 24m 31s\n- check-grenade-dsvm http://logs.openstack.org/03/115103/1/check/check-grenade-dsvm/3ab897b : SUCCESS in 41m 57s\n- gate-tempest-dsvm-large-ops http://logs.openstack.org/03/115103/1/check/gate-tempest-dsvm-large-ops/8fe245d : SUCCESS in 23m 29s\n- gate-tempest-dsvm-neutron-large-ops http://logs.openstack.org/03/115103/1/check/gate-tempest-dsvm-neutron-large-ops/51c742e : SUCCESS in 25m 08s\n- gate-devstack-bashate http://logs.openstack.org/03/115103/1/check/gate-devstack-bashate/a0a0bb3 : SUCCESS in 20s\n- check-devstack-dsvm-cells http://logs.openstack.org/03/115103/1/check/check-devstack-dsvm-cells/b992ca7 : SUCCESS in 16m 50s\n- check-grenade-dsvm-partial-ncpu http://logs.openstack.org/03/115103/1/check/check-grenade-dsvm-partial-ncpu/4ebf1a6 : SUCCESS in 40m 40s\n- check-neutron-dsvm-functional http://logs.openstack.org/03/115103/1/check/check-neutron-dsvm-functional/c43c66e : SUCCESS in 20m 21s\n- check-swift-dsvm-functional http://logs.openstack.org/03/115103/1/check/check-swift-dsvm-functional/ec47aca : SUCCESS in 21m 41s\n- check-tempest-dsvm-ironic-nv http://logs.openstack.org/03/115103/1/check/check-tempest-dsvm-ironic-nv/6839106 : SUCCESS in 34m 19s (non-voting)\n- check-tempest-dsvm-ironic-postgres-nv http://logs.openstack.org/03/115103/1/check/check-tempest-dsvm-ironic-postgres-nv/b9e1fa4 : SUCCESS in 35m 57s (non-voting)\n- check-tempest-dsvm-virtual-ironic-nv http://logs.openstack.org/03/115103/1/check/check-tempest-dsvm-virtual-ironic-nv/c9b8350 : SUCCESS in 34m 24s (non-voting)\n- check-tempest-dsvm-f20 http://logs.openstack.org/03/115103/1/check/check-tempest-dsvm-f20/2ab5912 : SUCCESS in 1h 01m 11s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"38bbdcd359d94ca91b42d4f360e160429374b056","author":{"_account_id":10385,"name":"Citrix XenServer CI","username":"citrix_xenserver_ci","tags":["SERVICE_USER"]},"date":"2014-08-18 22:05:53.000000000","message":"Patch Set 1: Verified+1\n\nPassed using XenAPI driver with XenServer 6.2: Logs at http://dd6b71949550285df7dc-dda4e480e005aaa13ec303551d2d8155.r49.cf1.rackcdn.com/03/115103/1/22111/results.html\n\nUse \"xenserver: recheck\" to trigger only xenserver re-check.  XenServer CI contact: openstack@citrix.com.\n\nDebugging suggestions at https://wiki.openstack.org/wiki/Debugging_XenServer_CI_failures","accounts_in_message":[],"_revision_number":1},{"id":"fe7378db81a2440a544f59ac6af0b559b27d8b41","author":{"_account_id":7118,"name":"Ian Wienand","email":"iwienand@redhat.com","username":"iwienand"},"date":"2014-08-18 23:31:52.000000000","message":"Patch Set 1: Code-Review-1\n\n(1 comment)\n\nThe password should have been generated and saved in localrc.  So that was removed?\n\nPossibly unstack.sh should purge the db, it\u0027s probably hard to argue that someone thought their db data would persist after running \"./unstack.sh\"\n\ni don\u0027t agree with purging it every run though","accounts_in_message":[],"_revision_number":1},{"id":"fd275a6764b0f25a6751668bad72f2d898faf812","author":{"_account_id":475,"name":"Rick Harris","email":"rick.harris@rackspace.com","username":"rconradharris"},"date":"2014-08-19 00:35:07.000000000","message":"Patch Set 1:\n\n\u003e The password should have been generated and saved in localrc. So that was removed?\n\nNo it\u0027s saved correctly to localrc. No problem there.\n\nThe problem is that the password is only set for MySQL on the first-run of stack.sh, when it installs the MySQL package.\n\nSubsequent runs that don\u0027t install the MySQL package will generate the password, but be unable to actually set it.\n\n\u003e i don\u0027t agree with purging it every run though\n\nAgree that this approach isn\u0027t ideal, but it does work at least.\n\nAny alternative proposals?","accounts_in_message":[],"_revision_number":1},{"id":"70eb00f311bdf34e7a558804c6e773d11bedc5e3","author":{"_account_id":7118,"name":"Ian Wienand","email":"iwienand@redhat.com","username":"iwienand"},"date":"2014-08-19 01:33:56.000000000","message":"Patch Set 1:\n\n\u003e Subsequent runs that don\u0027t install the MySQL package will generate the password, but be unable to actually set it.\n\nWhy are subsequent runs not using the existing generated password from localrc.auto, or the user-set password from localrc?","accounts_in_message":[],"_revision_number":1},{"id":"c2fa560f38d6213ca3d72a35e2c2b9c7faddac46","author":{"_account_id":475,"name":"Rick Harris","email":"rick.harris@rackspace.com","username":"rconradharris"},"date":"2014-08-19 01:44:14.000000000","message":"Patch Set 1:\n\nBecause for Ubuntu, the method of setting the password (debconf) is tied to package installation.\n\nAnd package installation only occurs once.\n\nSubsequents won\u0027t re-install the MySQL package, so MySQL will retain the password from the first run.","accounts_in_message":[],"_revision_number":1},{"id":"7cdf69f4c22383fbb60924d544fc00b0484323ae","author":{"_account_id":475,"name":"Rick Harris","email":"rick.harris@rackspace.com","username":"rconradharris"},"date":"2014-08-19 01:45:18.000000000","message":"Patch Set 1:\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"516e9a215e438c2642c9bf99667fef6c7c112306","author":{"_account_id":7118,"name":"Ian Wienand","email":"iwienand@redhat.com","username":"iwienand"},"date":"2014-08-19 01:54:28.000000000","message":"Patch Set 1:\n\n\u003e Subsequents won\u0027t re-install the MySQL package, so MySQL will retain the password from the first run.\n\nSorry, I think we\u0027re mis-understanding each other.\n\nThe password will be generated and stored in localrc (stack.sh:read_password)\n\nFor the next run, that same value should be used.  The password should not be regenerated if localrc has not been removed.","accounts_in_message":[],"_revision_number":1},{"id":"3a5b2223dfaaaf2186444af00436b92b83d1ec14","author":{"_account_id":475,"name":"Rick Harris","email":"rick.harris@rackspace.com","username":"rconradharris"},"date":"2014-08-19 02:48:04.000000000","message":"Patch Set 1:\n\n\u003eSorry, I think we\u0027re mis-understanding each other.\n\nYeah, few things going on here, so think we\u0027re focusing in on different things :-)\n\n\u003e The password will be generated and stored in localrc (stack.sh:read_password)\nFor the next run, that same value should be used. \n\nIf you have a `localrc`, it\u0027ll use the same password each time, but if you don\u0027t and instead use `.localrc.auto` , it\u0027ll be different between runs.\n\n\u003eThe password should not be regenerated if localrc has not been removed.\n\nIf the `localrc` is removed, then it\u0027s going to prompt for new passwords for all of the services: why shouldn\u0027t MySQL take on a new password, like the other services do?","accounts_in_message":[],"_revision_number":1},{"id":"64332687fb3d04e90ded44a6e6780e0523fc9dee","author":{"_account_id":7118,"name":"Ian Wienand","email":"iwienand@redhat.com","username":"iwienand"},"date":"2014-08-19 05:01:05.000000000","message":"Patch Set 1:\n\n\u003e if you ...use `.localrc.auto` , it\u0027ll be different between runs.\n\n\u003e If the `localrc` is removed, then it\u0027s going to prompt for new passwords for all of the services: why shouldn\u0027t MySQL take on a new password, like the other services do?\n\nunstack.sh has in it\n\n  # mysql and rabbit are left running as OpenStack code refreshes\n  # do not require them to be restarted.\n\nso there\u0027s really a precedent to keep them around -- i.e. not purge the database on people.  \n\nJust below this bit, the password is being saved into .my.cnf?  i think it would be reasonable to assume that if the db password is not set, and .my.cnf exists, then the password should come from that before generating a new one?","accounts_in_message":[],"_revision_number":1},{"id":"7468f143065705920ffeba08d4e9f7117532bb27","author":{"_account_id":475,"name":"Rick Harris","email":"rick.harris@rackspace.com","username":"rconradharris"},"date":"2014-08-19 05:40:22.000000000","message":"Patch Set 1:\n\n\u003e so there\u0027s really a precedent to keep them around -- i.e. not purge the database on people.\n\nYeah, that\u0027s a fair point.\n\nStill, without a fix, we\u0027re left in a situation where devstack can prompt you for a new password and then not actually perform the set-password in MySQL. Even worse, the code to GRANT privileges expects the new-password to be set.\n\nSo I think we should do /something/ to fix this, just not sure what (if not this)...\n\n[Will think about it some more tonight]","accounts_in_message":[],"_revision_number":1},{"id":"a37f56fde7165ee6d3cddb5f7df285fe9582c18d","author":{"_account_id":7175,"name":"Robbie Harwood","email":"rharwood@redhat.com","username":"frozencemetery"},"date":"2014-08-26 17:01:53.000000000","message":"Patch Set 1: Code-Review-1\n\nDoes dpkg-reconfigure not do what you want here?  Seems to me that calling that would be less overhead than purging and reinstalling.","accounts_in_message":[],"_revision_number":1},{"id":"fb53d012d33aed4ad2cfe5ba2cb6fdc3bcefc9e1","author":{"_account_id":475,"name":"Rick Harris","email":"rick.harris@rackspace.com","username":"rconradharris"},"date":"2014-12-10 16:01:48.000000000","message":"Abandoned","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"002c2b72b4d42496b6da0e11b39ee627ab01733c","revisions":{"002c2b72b4d42496b6da0e11b39ee627ab01733c":{"kind":"REWORK","_number":1,"created":"2014-08-18 20:46:11.000000000","uploader":{"_account_id":475,"name":"Rick Harris","email":"rick.harris@rackspace.com","username":"rconradharris"},"ref":"refs/changes/03/115103/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/devstack","ref":"refs/changes/03/115103/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/devstack refs/changes/03/115103/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/devstack refs/changes/03/115103/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/devstack refs/changes/03/115103/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/devstack refs/changes/03/115103/1"}}},"commit":{"parents":[{"commit":"a6a45467c412476b2cddb8526a97e421b0b74db7","subject":"Add ironic-python-agent support to devstack","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/devstack/commit/a6a45467c412476b2cddb8526a97e421b0b74db7"}]}],"author":{"name":"Rick Harris","email":"rconradharris@gmail.com","date":"2014-08-18 20:45:24.000000000","tz":-300},"committer":{"name":"Rick Harris","email":"rconradharris@gmail.com","date":"2014-08-18 20:45:24.000000000","tz":-300},"subject":"Fix MySQL password on Ubuntu","message":"Fix MySQL password on Ubuntu\n\nUbuntu relies on debconf to set the MySQL server password when the MySQL\npackage is installed. (This is done to avoid the password prompt during\ninstall).\n\nThis works the first time `./stack.sh` is run.\n\nOn subsequent runs, however, the package will already be installed, so the new\npassword won\u0027t be set.\n\nThe proposed work around is to uninstall/reinstall mysql-server on each run.\n\nChange-Id: I046ae22d59a99ef86da786c4d5db870814ce159f\nCloses-Bug: 1358485\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/devstack/commit/002c2b72b4d42496b6da0e11b39ee627ab01733c"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/devstack/commit/002c2b72b4d42496b6da0e11b39ee627ab01733c"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[],"submit_requirements":[]}