加载中…openfire 整合现有表
(2013-04-17 18:08:57)
标签：
macosopenfiremysql整合it |
分类： MacOS专区 |
几经周折，终于搞好了，刚开始自己想当然的多加了一个字段，结果悲剧了，搞了很久才ok
('jdbcProvider.connectionString','jdbc:mysql://localhost:3306/openfire?user=root&password='),
('admin.authorizedJIDs','15253@localhost'),
('jdbcAuthProvider.passwordSQL','SELECT
user_passwd FROM bala_user WHERE user_id=?'),
('jdbcAuthProvider.passwordType','plain'),
('jdbcUserProvider.loadUserSQL','SELECT
user_name, user_email FROM bala_user WHERE user_id=?'),
('jdbcUserProvider.userCountSQL','SELECT
COUNT(*) FROM bala_user'),
('jdbcUserProvider.allUsersSQL','SELECT
user_id FROM bala_user'),
('jdbcUserProvider.searchSQL','SELECT
user_id FROM bala_user WHERE'),
('jdbcUserProvider.usernameField','user_id'),
('jdbcUserProvider.nameField','user_name'),
('jdbcUserProvider.emailField','user_email');
首先在安装openfire的时候选择一个本地的数据库（我用的是mysql）输入连接的用户名密码，一路下一步。
然后在你连接的数据库中执行如下sql语句
UPDATE `openfire`.`ofProperty` SET
propValue='org.jivesoftware.openfire.user.JDBCUserProvider' WHERE
name='provider.user.className';
UPDATE `openfire`.`ofProperty` SET
propValue='org.jivesoftware.openfire.auth.JDBCAuthProvider' WHERE
name='provider.auth.className';
INSERT INTO `openfire`.`ofProperty` VALUES
('jdbcProvider.driver','com.mysql.jdbc.Driver'),
openfire
是数据库名，bala_user是用的表，15253是管理员账号，登陆密码就是bala_user里面的密码
在mac os卸载openfire
sudo rm -rf /Library/PreferencePanes/Openfire.prefPane
sudo rm -rf /usr/local/openfire
sudo rm -rf
/Library/LaunchDaemons/org.jivesoftware.openfire.plist
喜欢
0
赠金笔