...
Nota: lo spegnimento di tutte le VM e gli snapshot lo facciamo sulla cloud di test per poter fare rollback per poter poi ritestare la procedura di update
Cambiare le vecchie password utenti e servizi (algoritmo sha_512 non e' piu' supportato in EPOXY
mysql> SELECT
lu.user_id,
lu.name,
u.created_at,
p.expires_at
FROM local_user AS lu
INNER JOIN user AS u
ON lu.user_id = u.id
INNER JOIN (
SELECT local_user_id, MAX(id) AS max_id
FROM password
GROUP BY local_user_id
) AS latest
ON lu.id = latest.local_user_id
INNER JOIN password AS p
ON p.id = latest.max_id
WHERE u.enabled = 1
AND (p.expires_at IS NULL OR p.expires_at > NOW())
AND (p.password_hash LIKE '$6$%' OR p.password_hash LIKE '$5$%');
cambiare le password da command line con:
openstack user set --password-prompt <username>
Spegnere tutte le VM attive
...