“This account is locked. You can’t log in” for super user in Junos Space
After a few fat-fingered attempts to get the password entered, i realised I had locked myself out of a new Space installation. There’s only one user at that stage – ‘super’. And now I’ve locked the account. Damn.
To unlock this, you will need to go on the console and enter debug mode. This means you need to know the admin and maintenance mode passwords. Assuming you do, do the following:
mysql> use build_db
Database changed
mysql> select * from USER_IP_ADDRESS;
+--------+--------------+---------------------+--------------+----------+---------+
| id | ipAddress | ipLockedTime | failureCount | isLocked | user_id |
+--------+--------------+---------------------+--------------+----------+---------+
| 229377 | 172.20.45.85 | 2014-06-11 16:29:07 | 0 | 1 | 610 |
+--------+--------------+---------------------+--------------+----------+---------+
1 row in set (0.00 sec)
Update the table to make isLocked 0:
mysql> update USER_IP_ADDRESS set isLocked=0;
Query OK, 1 row affected (0.08 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from USER_IP_ADDRESS;
+--------+--------------+---------------------+--------------+----------+---------+
| id | ipAddress | ipLockedTime | failureCount | isLocked | user_id |
+--------+--------------+---------------------+--------------+----------+---------+
| 229377 | 172.20.45.85 | 2014-06-11 16:29:07 | 0 | 0 | 610 |
+--------+--------------+---------------------+--------------+----------+---------+
1 row in set (0.00 sec)
mysql> quit
