Since upgrade to 4.1 many Things about Users,Groups and Rostres have become strange or broken.
Without any Pattern or Regularity any Users on Admin Console shows as Member some Groups.
Above You can see “solonenko” and “surina” as member of many Groups
And next screen as Detail of User Groups:
Actually at the same time the User “solonenko” has no Groups and User “surina” is Member of Groups “hz2” and “omts”
Your query: select count(*) from ofGroupUser where username like ‘so%’;
Your query: select * from ofGroupUser where username=‘surina’;
Next restart of Openfire server users, which get wrong Group List today will be changed randomly but users “solonenko” and “surina” will be in right List
1.8.0_111 Oracle Corporation – OpenJDK 64-Bit Server VM
OS / Hardware:
Linux / amd64
OS Process Owner:
Database and Version:
HSQL Database Engine 2.3.4