The following users lack valid password hashes

Apps and Virtualization
21

After the update to 25.04.2 I also see this message. In my case the user mysql is effected.

Bildschirmfoto 2025-08-06 um 11.02.28
Bildschirmfoto 2025-08-06 um 11.02.28720×448 41.9 KB

I think the user was created by the system, at least I am not aware of having created a mysql user. How can I fix this?
I have already changed the password in the UI but the message sill exists.

22

Out of curiosity, does the mysql user actually need to access TrueNAS over SMB? Sounds like a system account. Maybe you can just uncheck the SMB box. Otherwise, you may need to just reboot to clear the alert since it gets raised / cleared whenever we resync the passdb, which happens on first boot and on system dataset move. So it may take a while to clear.

23

reboot after password change will do nothing.

24

When alert is being generated we iterate existing UI users:

        for entry in self.middleware.call_sync('user.query', [("smb", "=", True), ('local', '=', True)]):

The mysql user is something that you would have created in the UI and can possibly delete / edit in the UI. We don’t auto-create a mysql user.

25

OK, I wasn’t sure if the MySQL user was from TrueNAS. I just deactivated the check box.