| 2018-03-06 01:54:19 |
Paul Collins |
bug |
|
|
added bug |
| 2018-03-06 01:54:37 |
Paul Collins |
bug |
|
|
added subscriber The Canonical Sysadmins |
| 2018-03-06 02:03:37 |
Paul Collins |
description |
During an upgrade from percona-cluster ~15.05 (r52, revision-id: jorge.niedbalski@canonical.com-20150304174216-18abugmuw832gfbj) the upgrade-charm hook failed as follows:
2018-02-08 03:01:44 INFO upgrade-charm _mysql_exceptions.OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: YES)")
I realized that all of the passwords for the various related services were in the peer relation:
stagingstack-is@wekufe:~$ alias jru='juju run --unit'
stagingstack-is@wekufe:~$ jru mysql/0 'relation-get -r $(relation-ids cluster) - mysql/0'
bootstrap-uuid: c5a4bbfa-0c79-11e8-9b00-bfea4352af21
mysql-cinder.passwd: 89S9qrK8nxGPrTYbsSW2J5P5zBZ5M2RS
mysql-glance.passwd: Fsw6NXfdnXjdMypGjSYhFRJPg9mdRBYp
mysql-keystone.passwd: t4H6YNn49hC45bnJ4NYrZNsmK3gP4fBb
mysql-neutron.passwd: LNFM4Xq48zBb8Mm5XShHGktHpTc2CVGm
mysql-nova.passwd: 74Vf7bVd6JLfhrrc97kYHp476ZN2tZHk
mysql-sstuser.passwd: notarealsstpassword
mysql.passwd: notarealrootpassword
private-address: 10.25.126.203
stagingstack-is@wekufe:~$ _
whereas the charm code was now looking at the leader settings, which had fewer and different passwords:
stagingstack-is@wekufe:~$ jru mysql/0 leader-get
bootstrap-uuid: c5a4bbfa-0c79-11e8-9b00-bfea4352af21
mysql.passwd: LtWcYLGWNT6tXpJyVb5WwHjzPMkjGZZt
sst-password: notarealsstpassword
stagingstack-is@wekufe:~$ _
Running the following before upgrading the charm avoids the problem:
jru mysql/0 'leader-set $(relation-get -r $(relation-ids cluster) - mysql/0 | grep passwd | sed -e "s/: /=/")' |
During an upgrade from percona-cluster ~15.04 (r52, revision-id: jorge.niedbalski@canonical.com-20150304174216-18abugmuw832gfbj) the upgrade-charm hook failed as follows:
2018-02-08 03:01:44 INFO upgrade-charm _mysql_exceptions.OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: YES)")
I realized that all of the passwords for the various related services were in the peer relation:
stagingstack-is@wekufe:~$ alias jru='juju run --unit'
stagingstack-is@wekufe:~$ jru mysql/0 'relation-get -r $(relation-ids cluster) - mysql/0'
bootstrap-uuid: c5a4bbfa-0c79-11e8-9b00-bfea4352af21
mysql-cinder.passwd: 89S9qrK8nxGPrTYbsSW2J5P5zBZ5M2RS
mysql-glance.passwd: Fsw6NXfdnXjdMypGjSYhFRJPg9mdRBYp
mysql-keystone.passwd: t4H6YNn49hC45bnJ4NYrZNsmK3gP4fBb
mysql-neutron.passwd: LNFM4Xq48zBb8Mm5XShHGktHpTc2CVGm
mysql-nova.passwd: 74Vf7bVd6JLfhrrc97kYHp476ZN2tZHk
mysql-sstuser.passwd: notarealsstpassword
mysql.passwd: notarealrootpassword
private-address: 10.25.126.203
stagingstack-is@wekufe:~$ _
whereas the charm code was now looking at the leader settings, which had fewer and different passwords:
stagingstack-is@wekufe:~$ jru mysql/0 leader-get
bootstrap-uuid: c5a4bbfa-0c79-11e8-9b00-bfea4352af21
mysql.passwd: LtWcYLGWNT6tXpJyVb5WwHjzPMkjGZZt
sst-password: notarealsstpassword
stagingstack-is@wekufe:~$ _
Running the following before upgrading the charm avoids the problem:
jru mysql/0 'leader-set $(relation-get -r $(relation-ids cluster) - mysql/0 | grep passwd | sed -e "s/: /=/")' |
|
| 2018-03-06 02:26:42 |
Paul Collins |
description |
During an upgrade from percona-cluster ~15.04 (r52, revision-id: jorge.niedbalski@canonical.com-20150304174216-18abugmuw832gfbj) the upgrade-charm hook failed as follows:
2018-02-08 03:01:44 INFO upgrade-charm _mysql_exceptions.OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: YES)")
I realized that all of the passwords for the various related services were in the peer relation:
stagingstack-is@wekufe:~$ alias jru='juju run --unit'
stagingstack-is@wekufe:~$ jru mysql/0 'relation-get -r $(relation-ids cluster) - mysql/0'
bootstrap-uuid: c5a4bbfa-0c79-11e8-9b00-bfea4352af21
mysql-cinder.passwd: 89S9qrK8nxGPrTYbsSW2J5P5zBZ5M2RS
mysql-glance.passwd: Fsw6NXfdnXjdMypGjSYhFRJPg9mdRBYp
mysql-keystone.passwd: t4H6YNn49hC45bnJ4NYrZNsmK3gP4fBb
mysql-neutron.passwd: LNFM4Xq48zBb8Mm5XShHGktHpTc2CVGm
mysql-nova.passwd: 74Vf7bVd6JLfhrrc97kYHp476ZN2tZHk
mysql-sstuser.passwd: notarealsstpassword
mysql.passwd: notarealrootpassword
private-address: 10.25.126.203
stagingstack-is@wekufe:~$ _
whereas the charm code was now looking at the leader settings, which had fewer and different passwords:
stagingstack-is@wekufe:~$ jru mysql/0 leader-get
bootstrap-uuid: c5a4bbfa-0c79-11e8-9b00-bfea4352af21
mysql.passwd: LtWcYLGWNT6tXpJyVb5WwHjzPMkjGZZt
sst-password: notarealsstpassword
stagingstack-is@wekufe:~$ _
Running the following before upgrading the charm avoids the problem:
jru mysql/0 'leader-set $(relation-get -r $(relation-ids cluster) - mysql/0 | grep passwd | sed -e "s/: /=/")' |
During an upgrade from percona-cluster ~15.04 (r52, revision-id: jorge.niedbalski@canonical.com-20150304174216-18abugmuw832gfbj) to 17.11,the upgrade-charm hook failed as follows:
2018-02-08 03:01:44 INFO upgrade-charm _mysql_exceptions.OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: YES)")
I realized that all of the passwords for the various related services were in the peer relation:
stagingstack-is@wekufe:~$ alias jru='juju run --unit'
stagingstack-is@wekufe:~$ jru mysql/0 'relation-get -r $(relation-ids cluster) - mysql/0'
bootstrap-uuid: c5a4bbfa-0c79-11e8-9b00-bfea4352af21
mysql-cinder.passwd: 89S9qrK8nxGPrTYbsSW2J5P5zBZ5M2RS
mysql-glance.passwd: Fsw6NXfdnXjdMypGjSYhFRJPg9mdRBYp
mysql-keystone.passwd: t4H6YNn49hC45bnJ4NYrZNsmK3gP4fBb
mysql-neutron.passwd: LNFM4Xq48zBb8Mm5XShHGktHpTc2CVGm
mysql-nova.passwd: 74Vf7bVd6JLfhrrc97kYHp476ZN2tZHk
mysql-sstuser.passwd: notarealsstpassword
mysql.passwd: notarealrootpassword
private-address: 10.25.126.203
stagingstack-is@wekufe:~$ _
whereas the charm code was now looking at the leader settings, which had fewer and different passwords:
stagingstack-is@wekufe:~$ jru mysql/0 leader-get
bootstrap-uuid: c5a4bbfa-0c79-11e8-9b00-bfea4352af21
mysql.passwd: LtWcYLGWNT6tXpJyVb5WwHjzPMkjGZZt
sst-password: notarealsstpassword
stagingstack-is@wekufe:~$ _
Running the following before upgrading the charm avoids the problem:
jru mysql/0 'leader-set $(relation-get -r $(relation-ids cluster) - mysql/0 | grep passwd | sed -e "s/: /=/")' |
|
| 2018-03-06 19:56:27 |
Paul Collins |
tags |
|
canonical-is-ps45-1711-upgrade |
|
| 2018-07-02 10:45:15 |
James Page |
tags |
canonical-is-ps45-1711-upgrade |
canonical-is-ps45-1711-upgrade upgrade |
|
| 2018-07-02 11:10:32 |
James Page |
charm-percona-cluster: status |
New |
Triaged |
|
| 2018-07-02 11:10:34 |
James Page |
charm-percona-cluster: importance |
Undecided |
High |
|
| 2018-07-02 11:10:37 |
James Page |
charm-percona-cluster: milestone |
|
18.08 |
|
| 2018-09-12 20:35:38 |
James Page |
charm-percona-cluster: milestone |
18.08 |
18.11 |
|
| 2018-11-20 00:22:08 |
David Ames |
charm-percona-cluster: milestone |
18.11 |
19.04 |
|
| 2019-04-17 22:04:42 |
David Ames |
charm-percona-cluster: milestone |
19.04 |
19.07 |
|
| 2019-08-12 21:23:01 |
David Ames |
charm-percona-cluster: milestone |
19.07 |
19.10 |
|
| 2019-10-24 23:19:49 |
David Ames |
charm-percona-cluster: milestone |
19.10 |
20.01 |
|
| 2019-11-08 13:12:27 |
Alex Kavanagh |
tags |
canonical-is-ps45-1711-upgrade upgrade |
canonical-is-ps45-1711-upgrade charm-upgrade |
|
| 2019-11-29 15:37:45 |
Alex Kavanagh |
bug task added |
|
charm-guide |
|
| 2019-11-29 15:37:51 |
Alex Kavanagh |
charm-guide: status |
New |
Triaged |
|
| 2019-11-29 15:37:54 |
Alex Kavanagh |
charm-guide: importance |
Undecided |
High |
|
| 2019-11-29 15:41:33 |
Alex Kavanagh |
charm-percona-cluster: milestone |
20.01 |
20.02 |
|
| 2019-11-29 15:41:40 |
Alex Kavanagh |
charm-guide: milestone |
|
20.02 |
|
| 2020-02-17 17:28:09 |
Liam Young |
charm-percona-cluster: milestone |
20.02 |
20.05 |
|
| 2020-02-17 17:28:49 |
Liam Young |
charm-guide: milestone |
20.02 |
20.05 |
|
| 2020-05-21 20:15:13 |
David Ames |
charm-percona-cluster: milestone |
20.05 |
20.08 |
|
| 2020-05-21 20:16:52 |
David Ames |
charm-guide: milestone |
20.05 |
20.08 |
|
| 2020-08-03 14:00:44 |
James Page |
charm-percona-cluster: milestone |
20.08 |
|
|
| 2020-08-03 14:01:30 |
James Page |
charm-guide: milestone |
20.08 |
|
|
| 2022-07-08 21:23:55 |
Peter Matulis |
charm-guide: status |
Triaged |
Won't Fix |
|
