org.jivesoftware.util.JiveProperties
是加载一些基本配置的类
加载配置的时候.是通过搜索ofProperty表得到的数据

SELECT NAME, propValue FROM ofProperty

 

修改provider.auth.className的对应的class类就可以

思路不错，可否说下具体编码实现的时候如何处理比较典型啊？

insert into ofproperty(name,propValue)values 
('jdbcProvider.driver','com.mysql.jdbc.Driver'),  
('jdbcProvider.connectionString','jdbc:mysql://xxx.xxx.xxx.xxx:3306/abc?

user=root&password=xxxx'),  
('admin.authorizedJIDs','adminxxx@xxx.xxx'), /*users表中的管理员用户*/ 
('jdbcAuthProvider.passwordSQL','select pass from abc.users where id=?'),  
('jdbcAuthProvider.passwordType','plain'),/*密码为明文*/
('jdbcUserProvider.loadUserSQL','select id,name,email from

abc.users whereid=?'),  
('jdbcUserProvider.userCountSQL','select count(id) from abc.users'),  
('jdbcUserProvider.allUsersSQL','select id from abc.users'),  
('jdbcUserProvider.searchSQL','select id from abc.users'),
('jdbcUserProvider.usernameField','id'),  
('jdbcUserProvider.nameField','name'),  
('jdbcUserProvider.emailField','email');
 
UPDATE ofProperty SET propValue='org.jivesoftware.openfire.user.JDBCUserProvider' WHERE

name='provider.user.className'; 
UPDATE ofProperty SET propValue='org.jivesoftware.openfire.auth.JDBCAuthProvider' WHERE

name='provider.auth.className';
/*本人已实践过*/

另外问一下，有人实践过openfire的clustering没？哪有企业版的openfire下呢？或者企业版插件？谢谢啦！！