We're updating the issue view to help you get more done. 

Setup fails with MariaDB because of a different UTF setting

Description

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.

Environment

MariaDB

Acceptance Test - Entry

None

Activity

Show:
Greg Thomas
February 25, 2019, 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?

wroot
February 25, 2019, 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, 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, 1:19 PM

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, 4:58 PM

Assignee

Greg Thomas

Reporter

wroot

Labels

Expected Effort

None

Components

Fix versions

Affects versions

Priority

Major
Configure