I am trying to integrate Openfire into an existing db. The auth and users integrated without a hitch. The groups are doing something a bit more odd. Openfire shows the groups and users within that group, but for each user it says that they are not part of any group. I know that this is part of the userGroupsSQL query. I double checked that query and it seems to work fine in phpmyadmin.
Here’'s the group section from openfire.xml:
Anybody have any ideas of what’'s going on?
Thank in advance,