openfire整合现有系统用户

更改ofproperty表,

1增加如下记录:

INSERT  INTO `ofproperty`(`name`,`propValue`) VALUES ('jdbcAuthProvider.passwordSQL','SELECT password FROM user_info WHERE username=?');
INSERT  INTO `ofproperty`(`name`,`propValue`) VALUES ('jdbcAuthProvider.passwordType','special');
INSERT  INTO `ofproperty`(`name`,`propValue`) VALUES ('jdbcAuthProvider.setPasswordSQL','UPDATE user_info SET password=? WHERE username=?');
INSERT  INTO `ofproperty`(`name`,`propValue`) VALUES ('jdbcProvider.connectionString','jdbc:mysql://192.168.2.10:3306/kingshine?user=root&password=kingshine');
INSERT  INTO `ofproperty`(`name`,`propValue`) VALUES ('jdbcProvider.driver','com.mysql.jdbc.Driver');
INSERT  INTO `ofproperty`(`name`,`propValue`) VALUES ('jdbcUserProvider.allUsersSQL','SELECT username FROM user_info');
INSERT  INTO `ofproperty`(`name`,`propValue`) VALUES ('jdbcUserProvider.emailField','e_mail');
INSERT  INTO `ofproperty`(`name`,`propValue`) VALUES ('jdbcUserProvider.loadUserSQL','SELECT nickname,e_mail FROM user_info WHERE username=?');
INSERT  INTO `ofproperty`(`name`,`propValue`) VALUES ('jdbcUserProvider.nameField','nickname');
INSERT  INTO `ofproperty`(`name`,`propValue`) VALUES ('jdbcUserProvider.searchSQL','SELECT username FROM user_info WHERE');
INSERT  INTO `ofproperty`(`name`,`propValue`) VALUES ('jdbcUserProvider.userCountSQL','SELECT COUNT(*) FROM user_info');

INSERT  INTO `ofproperty`(`name`,`propValue`) VALUES ('jdbcUserProvider.usernameField','username');

INSERT  INTO `ofproperty`(`name`,`propValue`) VALUES ('jdbcAuthProvider.allowUpdate','true');

2.修改如下记录
UPDATE `ofproperty` SET `propValue`='org.jivesoftware.openfire.auth.KingAuthProvider' WHERE `name`='provider.auth.className';

UPDATE `ofproperty` SET `propValue`='org.jivesoftware.openfire.user.JDBCUserProvider' WHERE `name`='provider.user.className';

备注:

'jdbcAuthProvider.passwordType','special' 自定义加密方式对应自定义的provider.auth.className:org.jivesoftware.openfire.auth.KingAuthProvider,参照默认的AuthProvider修改就行了!