openfire 快速整合第三方用户表

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/

(0)
上一篇 2014年2月5日 下午9:09
下一篇 2015年3月2日 下午9:21

相关推荐

发表评论

您的电子邮箱地址不会被公开。 必填项已用*标注