Contact List (Roster) Sharing autoswitches back to “Disable”

Good day.
I have Openfire 4.7.1 on Rocky Linux 8.5 integrated with Active Directory.

Database and Version: MySQL 5.5.5-10.3.32-MariaDB
JDBC Driver: MySQL Connector/J
JDBC Driver Version: mysql-connector-java-8.0.28

Users and groups display correctly.

After switching on “Enable contact list group sharing” for any group, setting contact list group name, share group with all users, it works ok for several minutes (spark shows all groups) then the switch goes to “Disable contact list group sharing”. After that spark shows no groups.

Is it possible to force it to enabled state?

I cannot think of a functional reason why this would automatically switch back. Please review your Openfire log files. Something must be going wrong. Maybe Openfire fails to persist some settings in the database?

I couldn’t solve the issue. Had to use embedded database instead of MariaDB and problem is gone.

This suggests some kind of permission issue with writing to the database. Most of Openfire does not make any difference between any of the databases that can be used.

Good to hear that you found a way around the issue though!