openfire整合现有系统用户

openfire数据库的整合，只需要在openfire数据表ofProperty添加相应的数据就可以实现整合现有的系统用户，该表中一共就两个字段，name（配置名称）和propValue（配置的值），我已将该表中的数据已经导出来了，仅供参考

INSERT INTO `ofproperty` VALUES (‘admin.authorizedJIDs’, ‘admin@127.0.0.1′);
INSERT INTO `ofproperty` VALUES (‘jdbcAuthProvider.passwordSQL’, ‘SELECT plainPassword FROM myUser WHERE username=?’);
INSERT INTO `ofproperty` VALUES (‘jdbcAuthProvider.passwordType’, ‘plain’);
INSERT INTO `ofproperty` VALUES (‘jdbcGroupProvider.allGroupsSQL’, ‘SELECT groupName FROM myGroup’);
INSERT INTO `ofproperty` VALUES (‘jdbcGroupProvider.descriptionSQL’, ‘SELECT groupDescription FROM myGroup WHERE groupName=?’);
INSERT INTO `ofproperty` VALUES (‘jdbcGroupProvider.groupCountSQL’, ‘SELECT count(*) FROM myGroup’);
INSERT INTO `ofproperty` VALUES (‘jdbcGroupProvider.loadAdminsSQL’, ‘0e5ae32da0fd5e9d566f45d7f521963ec64771f2ff273a7cd53c17a87476367854230b7605a2b5f682af77c7ffce009098e97bcefbda8c6a264065d4d7f60f0fe89f2ecf3ffc4cba44fdb8569eb4c662d7ad89a10eb69e0a70a308f62a471ef5d4ce7e1c978a6db9a129f8d6d3229968531524a74aa82f7b1f4e0f60e4f5b1c84d43f5c2fbfc4b383bc0ed87173ce5f2′);
INSERT INTO `ofproperty` VALUES (‘jdbcGroupProvider.loadMembersSQL’, ‘37636bcbbdb149ab9f2fac95fe0aeb1f3da09afb8083b9fb5055d200a8133657399e71f8443bc38e8ab5ce64229957bfc59da8ae52ae1e8358112ff4973746946e046baaa57239b031ce703fc9264a07ba10dc2ef3527fe8d3e24ef990b080b8f0bead825088e5a9d82a9f8786e07434f7bd747b3d618368447dca2595fd2d0e1e88102516c5ee0fe2454aa025051543′);
INSERT INTO `ofproperty` VALUES (‘jdbcGroupProvider.userGroupsSQL’, ’12b7acd4647e76fdac6fbf97b5eace85d79f84034922b4a9ba72270b0a434e9b60947ef0a4f6b6ea85ad89b3d481ad5fc93374626b41129d70455077147dc7fd46265f98c3c50acc341259a02dd0051f54781fe37e8e2ee466f6b893f8d45f86d828c964013a7cdc871b02fb4f6825d3′);
INSERT INTO `ofproperty` VALUES (‘jdbcProvider.connectionString’, ‘jdbc:mysql://127.0.0.1:39725/blueball?user=root&password=5121305Chh’);
INSERT INTO `ofproperty` VALUES (‘jdbcProvider.driver’, ‘com.mysql.jdbc.Driver’);
INSERT INTO `ofproperty` VALUES (‘jdbcUserProvider.allUsersSQL’, ‘SELECT username FROM myUser’);
INSERT INTO `ofproperty` VALUES (‘jdbcUserProvider.emailField’, ’email’);
INSERT INTO `ofproperty` VALUES (‘jdbcUserProvider.loadUserSQL’, ‘SELECT name,email FROM myUser WHERE username=?’);
INSERT INTO `ofproperty` VALUES (‘jdbcUserProvider.nameField’, ‘name’);
INSERT INTO `ofproperty` VALUES (‘jdbcUserProvider.searchSQL’, ‘SELECT username FROM myUser WHERE’);
INSERT INTO `ofproperty` VALUES (‘jdbcUserProvider.userCountSQL’, ‘SELECT COUNT(*) FROM myUser’);
INSERT INTO `ofproperty` VALUES (‘jdbcUserProvider.usernameField’, ‘username’);
INSERT INTO `ofproperty` VALUES (‘passwordKey’, ‘6hS5x9y79p4LB0k’);
INSERT INTO `ofproperty` VALUES (‘provider.admin.className’, ‘org.jivesoftware.openfire.admin.DefaultAdminProvider’);
INSERT INTO `ofproperty` VALUES (‘provider.auth.className’, ‘org.jivesoftware.openfire.auth.JDBCAuthProvider’);
INSERT INTO `ofproperty` VALUES (‘provider.group.className’, ‘org.jivesoftware.openfire.group.JDBCGroupProvider’);
INSERT INTO `ofproperty` VALUES (‘provider.lockout.className’, ‘org.jivesoftware.openfire.lockout.DefaultLockOutProvider’);
INSERT INTO `ofproperty` VALUES (‘provider.securityAudit.className’, ‘org.jivesoftware.openfire.security.DefaultSecurityAuditProvider’);
INSERT INTO `ofproperty` VALUES (‘provider.user.className’, ‘org.jivesoftware.openfire.user.JDBCUserProvider’);
INSERT INTO `ofproperty` VALUES (‘provider.vcard.className’, ‘org.jivesoftware.openfire.vcard.DefaultVCardProvider’);
INSERT INTO `ofproperty` VALUES (‘update.lastCheck’, ‘1403668110015’);
INSERT INTO `ofproperty` VALUES (‘xmpp.auth.anonymous’, ‘true’);
INSERT INTO `ofproperty` VALUES (‘xmpp.domain’, ‘127.0.0.1’);
INSERT INTO `ofproperty` VALUES (‘xmpp.jmx.enabled’, ‘false’);
INSERT INTO `ofproperty` VALUES (‘xmpp.jmx.port’, ‘1099’);
INSERT INTO `ofproperty` VALUES (‘xmpp.jmx.secure’, ‘true’);
INSERT INTO `ofproperty` VALUES (‘xmpp.session.conflict-limit’, ‘0’);
INSERT INTO `ofproperty` VALUES (‘xmpp.socket.ssl.active’, ‘true’);

 

声明：本文由 admin 原创编译，转载请注明出自：http://www.cua0702.com/?p=139