Skip to content

Internal 'root' superuser account

Recover a locked account

You will need write access to the FMR installation's database.

Identify the 'registry_root_security' table.

sql> select * from registry_root_security;
+----------+-----------+-----------+--------------------------------------------------------------+
| username | is_locked | max_login | pwd                                                          |
+----------+-----------+-----------+--------------------------------------------------------------+
| root     |         0 |        -1 | $2a$10$DvnMm3u74kaWQnWzkG0kqOpPd8TEQl2wdxa0laTxwCkGb8W421ena |
+----------+-----------+-----------+--------------------------------------------------------------+

This table contains the following information about the root account:

  • username
  • password (encrypted)
  • the maximum number of failed login attempts before the account is locked
  • whether or not the root account is locked (1=locked, 0=unlocked)

To unlock a locked root user set the value of the column 'is_locked' to 0.

sql> update registry_root_security set is_locked=0 where username='root';