I have configured the OpenFire server to authenticate externally via JDBC and to provide the users and groups from my database versus the standard OpenFire tables. So far things seem to be working ok, but I have one or two questions.
When I view the details for a group, the count of members and admins is right and the correct users show up as belonging to those groups. However, when I view the details for the user, the Groups property which I think should show the list of groups that user belongs to always says ‘‘none’’. Is this normal? I have looked at the SQL that is used to query the groups for a user and I don’'t see a problem with it. When I execute the same SQL from the command line, I get the correct list of groups for the users.
Since users and groups are cached, if I add another user or group while the server is running, it does not recognize the new user or group. I have found that if I use the admin console to clear the user and/or group caches, it re-reads the database and all is well. What is the best way to do this programmatically? I want my custom user admin screen for my system to be able to automatically clear the appropriate caches when new users or groups are created, updated, or deleted.
Thanks in advance.
Senior Developer / DBA
Northland, A Church Distributed