openfire 快速整合第三方用户表

最新推荐文章于 2019-11-19 17:23:18 发布

转载最新推荐文章于 2019-11-19 17:23:18 发布 · 99 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/CrazyPHP/p/4241068.html

文章标签：

#数据库

本文详细介绍了如何在OpenFire服务器中配置数据库提供者和认证提供者，包括设置JDBC连接参数、数据库操作SQL语句等关键步骤。

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');

转载于:https://www.cnblogs.com/CrazyPHP/p/4241068.html