openfire集成现有系统的用户表

最新推荐文章于 2019-06-15 01:23:35 发布

最新推荐文章于 2019-06-15 01:23:35 发布 · 118 阅读

文章标签：

#Java #MySQL #Gmail #JDBC #JSP

openfire/xmpp 专栏收录该内容

8 篇文章

订阅专栏

本文介绍如何使用OpenFire 3.6.4版本通过SQL查询语句集成现有的系统用户表，包括配置数据库连接、用户认证及信息加载等关键步骤。

openfire 3.6.4版本集成现有系统用户表：

insert  into ofproperty(name,propValue)values
('jdbcProvider.driver','com.mysql.jdbc.Driver'),
('jdbcProvider.connectionString','jdbc:mysql://localhost/iec?user=root&password=root'),
('admin.authorizedJIDs','admin@66call'),
('jdbcAuthProvider.passwordSQL','SELECT password FROM user_account WHERE UserName=?'),
('jdbcAuthProvider.passwordType','plain'),//md5,plain,sha1
('jdbcUserProvider.loadUserSQL','SELECT name,email FROM user_account WHERE Username=?'),
('jdbcUserProvider.userCountSQL','SELECT COUNT(*) FROM user_account'),
('jdbcUserProvider.allUsersSQL','SELECT username FROM user_account'),
('jdbcUserProvider.usernameField','Username'),
('jdbcUserProvider.nameField','name'),
('jdbcUserProvider.emailField','email')

UPDATE ofProperty SET propValue='org.jivesoftware.openfire.user.JDBCUserProvider' WHERE name='provider.user.className'  
UPDATE ofProperty SET propValue='org.jivesoftware.openfire.auth.JDBCAuthProvider' WHERE name='provider.auth.className'