UPDATE `wmq`.`ofProperty` SET propValue='org.jivesoftware.openfire.user.JDBCUserProvider' WHERE name='provider.user.className';
UPDATE `wmq`.`ofProperty` SET propValue='org.jivesoftware.openfire.auth.JDBCAuthProvider' WHERE name='provider.auth.className';
INSERT INTO `wmq`.`ofProperty` VALUES
('jdbcProvider.driver','com.mysql.jdbc.Driver'),
('jdbcProvider.connectionString','jdbc:mysql://localhost:3306/wmq?user=root&password='),
('admin.authorizedJIDs','8324554@localhost'),
('jdbcAuthProvider.passwordSQL','SELECT pass FROM wmq_member WHERE card=?'),
('jdbcAuthProvider.passwordType','md5'),
('jdbcUserProvider.loadUserSQL','SELECT card, appid FROM wmq_member WHERE card=?'),
('jdbcUserProvider.userCountSQL','SELECT COUNT(*) FROM wmq_member'),
('jdbcUserProvider.allUsersSQL','SELECT card FROM wmq_member'),
('jdbcUserProvider.searchSQL','SELECT card FROM wmq_member WHERE'),
('jdbcUserProvider.usernameField','card'),
('jdbcUserProvider.nameField','nickname'),
('jdbcUserProvider.emailField','appid');
原创文章,作者:CrazyCodes,如若转载,请注明出处:https://blog.fastrun.cn/2015/01/22/1-45/