Custom DB Group Issue

Hi all-

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,

Adam

Yep, this was a bug in Openfire. See this thread:

http://www.igniterealtime.org/forum/thread.jspa?messageID=148594&#148594

It’'s been fixed, and should be in the latest build. If not, there is the code change in that thread.

I am still experiencing this exact issue in 3.4 beta 2. Anyone know if a fix is coming for this any time soon?

Hey guys,

Today we fixed JM-1080 which I think is what you are looking for. Openfire 3.4.0 will be out by the end of this month.

Regards,

– Gato