更改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');
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修改就行了!