No, this one is filed because for the user the problem went away after utf8mb4_general_ci -> utf8_general_ci change in MariaDB. It wasn't a permissions issue for him.
Greg Thomas February 25, 2019 at 1:09 PM
Ah, OK, so the problem is nothing to do with charset definitions, etc? Can we close this as a duplicate of OF-1298?
wroot February 25, 2019 at 9:55 AM
Edited
The error was because of me trying to run Openfire with a user other than openfire:openfire and changing permissions. On Windows you can reproduce that by stopping Openfire service and running it via launcher without Run as admin option. If it is installed in Program files, then the launcher wouldn't have enough permissions to write changes and Openfire will show current password prompt. Actually, this is a different issue from what i have posted here. Better check: https://issues.igniterealtime.org/browse/OF-1298
Greg Thomas February 25, 2019 at 9:16 AM
wroot; in the forum thread, you said you saw the same error and fixed it. I can;t reproduce it locally (Windows 10, MariaDB 10.3.13) - so what was it exactly you changed?
User reports that he was getting current password prompt during fresh setup until he has changes UTF setting in MariaDB:
utf8mb4_general_ci -> utf8_general_ci
Maybe this is because of a new SQL connector not working correctly with MariaDB. Or MariaDB has some non standard default.