I want to use an external application to add groups and memebers to the openfire 3.6.4 DataBase directly. I add group name to ofGroup table, add group sharing permission information to ofGroupProp table, and members to ofGroupUser table. everything looks good when I start couple of sparkweb cilents.
then I did one more test, I add an user , who is already in group A, into Group B by adding the data to ofGroupUser table. First, it seems admin console will not pick up this user in group B right away. secondly, when I log into sparkweb client as this user who is in Group A and Group B, only existing group A(shared by group members) info showed up., group B(also shared by group memebers) information won’t show up in the client. If I restart the openfire server, all the shared group info and its memebers will automatically show up in its memebers’ client window. it seems after openfire starts, the group and member info are cached in its memory and it never go back to DB to reload? am I right? but it seems it only happens for the users who belong to multiple groups.
any suggestion will be greatly appreciated!