openstack에서 password를 5회 이상 틀렸을 경우 계정이 잠겨 사용을 못하는 현상이있습니다.
openstack DB에서 아래와 같이 조정하면된다.
보통 계정이 잠기게되면 이렇게 나옵니다.
MariaDB [keystone]> SELECT *FROM local_user;
+----+----------------------------------+----------------------------------+---------------------------------------------+-------------------+---------------------+
| id | user_id | domain_id | name | failed_auth_count | failed_auth_at |
+----+----------------------------------+----------------------------------+---------------------------------------------+-------------------+---------------------+
| 2 | a724b3b2cba3476589f8d68bff6d7efc | default | admin | 5 | NULL |
| 5 | 13aea39d2dae4616bc5b368ba3634b14 | f1d0f050421649ba99f5e09854fd9dfa | glance | 0 | NULL |
| 8 | 75cb04791df2406c95ed01615793cb9c | f1d0f050421649ba99f5e09854fd9dfa | placement | 0 | NULL |
| 11 | c4b0cbe05cbc4fe5b8530e6edb92fa13 | f1d0f050421649ba99f5e09854fd9dfa | neutron | 0 | NULL |
| 14 | c5ec8740726d49dfa87247861b6b27c9 | f1d0f050421649ba99f5e09854fd9dfa | nova | 0 | NULL |
| 17 | 7188cb855a344c5eb7c768a76d373ded | f1d0f050421649ba99f5e09854fd9dfa | cinder | 0 | NULL |
| 20 | 4917e01312db4cfea03630b6a8b8ab19 | default | internal_cinder | 0 | NULL |
| 23 | b0f694a7b38e47528624d18209d089bf | f1d0f050421649ba99f5e09854fd9dfa | barbican | 0 | NULL |
| 29 | 41736d1cd76f45028eaf16d4202cc31d | default | cloudpc_id_1593c26d1a2f40abae714a11c22510ef | 0 | NULL |
+----+----------------------------------+----------------------------------+---------------------------------------------+-------------------+---------------------+- default의 계정이 failed_count가 5로 설정되어있음
해당 값을 0으로 update시키면된다.
MariaDB [keystone]> UPDATE local_user SET failed_auth_count = 0;
Query OK, 1 row affected (0.001 sec)
Rows matched: 9 Changed: 1 Warnings: 0
MariaDB [keystone]> SELECT *FROM local_user;
+----+----------------------------------+----------------------------------+---------------------------------------------+-------------------+---------------------+
| id | user_id | domain_id | name | failed_auth_count | failed_auth_at |
+----+----------------------------------+----------------------------------+---------------------------------------------+-------------------+---------------------+
| 2 | a724b3b2cba3476589f8d68bff6d7efc | default | admin | 0 | 2024-09-11 02:37:40 |
| 5 | 13aea39d2dae4616bc5b368ba3634b14 | f1d0f050421649ba99f5e09854fd9dfa | glance | 0 | NULL |
| 8 | 75cb04791df2406c95ed01615793cb9c | f1d0f050421649ba99f5e09854fd9dfa | placement | 0 | NULL |
| 11 | c4b0cbe05cbc4fe5b8530e6edb92fa13 | f1d0f050421649ba99f5e09854fd9dfa | neutron | 0 | NULL |
| 14 | c5ec8740726d49dfa87247861b6b27c9 | f1d0f050421649ba99f5e09854fd9dfa | nova | 0 | NULL |
| 17 | 7188cb855a344c5eb7c768a76d373ded | f1d0f050421649ba99f5e09854fd9dfa | cinder | 0 | NULL |
| 20 | 4917e01312db4cfea03630b6a8b8ab19 | default | internal_cinder | 0 | NULL |
| 23 | b0f694a7b38e47528624d18209d089bf | f1d0f050421649ba99f5e09854fd9dfa | barbican | 0 | NULL |
| 29 | 41736d1cd76f45028eaf16d4202cc31d | default | cloudpc_id_1593c26d1a2f40abae714a11c22510ef | 0 | NULL |
+----+----------------------------------+----------------------------------+---------------------------------------------+-------------------+---------------------+
9 rows in set (0.001 sec)이제 접속해보면 정상적으로 접속됨을 확인할 수 있습니다.
