openfire集成现有系统的用户表-CSDN博客

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

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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'