I have been able to integrated the authentication, users and groups with my custom users database. The users, groups and authentication appears and works as expected - although I have to make some slight changes from what was shown in the the guide at:
The SQL statements provide has used “FORM” instead of “FROM”!
Anyways, I notice that the SQL lookups are not dynamic. They only seem to be executed on service startup. For example my loadMembers query is, :
<loadMembersSQL>SELECT username FROM users WHERE alliance=? AND member=‘true’ AND enable=‘true’</loadMembersSQL>
Thus, if the enable field is true then the account should be enabled. However, if you make this change while openfire is running then the changes will not be applied - sine the lookups do not seem to be not realtime (or semi-relatime).
Can somebody confirm that these SQL lookups are not realtime and whether there is a setting to make realtime/dynamic lookups with the custom database integration?