reset the WebUI password

[davido38]

fog version : 1.5.9
Debian 10

Hi,
I can’t login to the webui anymore. I try to reset the WebUI password (UPDATE users SET uPass = MD5(‘password’) WHERE uName = ‘fog’;) but i have this message :
Rows matched: 0 Changed: 0 Warnings: 0

If i try this command select * from users; i have
Empty set (0.000 sec)
So do i have to create a user ? and how ?

Thanks

[Sebastian Roth]

@davido38 Well it looks like the user entry was dropped from the database. You should be able to recreate it:

INSERT INTO users VALUES (0, 'fog', MD5('password'), '2023-01-26 01:33:07', 'fog', 0, '', 0, '');

[davido38]

Problem solved !

Thanks a lot !!