If you get the following error message:
'NULL' is not valid for password 'password', in table: 'users'
This means there is a literal password value of NULL in
From the Monitor shell, look for any users in
that do not have a password entry (or simply run
grep -B 5 -i null /etc/op5/auth_users.yml). In a valid entry, you will see both
password_algo fields and values:
realname: "John Doe"
When you get a failing entry, you will not likely have a
password_algo field and the password value will not be in double-quotes:
realname: "Jane Doe"
Copy each of the user entries that do not have passwords. You will need to re-enter this content when you add the password since any update via
op5-manage-userswill purge existing content. Please see https://support.itrsgroup.com/hc/en-us/articles/360020252513-How-to-reset-the-password-for-local-users for details.
/usr/bin/op5-manage-users to set the password, and provide the original values along with the password. Based on the example above:
op5-manage-users --update --username=jane --password=PASSWORD--realname="Jane Doe" --group=admins