网上有很多很详细的了,这里我就记录一下我自己修改完后的sql吧。
不知道为啥修改配置文件不管用。待研究
/*
-- Query: SELECT * FROM openfire.ofProperty
LIMIT 0, 1000
-- Date: 2012-12-15 16:44
*/
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('admin.authorizedJIDs','admin@localhost ,admin@localhost ');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('jdbcAuthProvider.passwordSQL','SELECT pwd FROM users WHERE uid=?');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('jdbcAuthProvider.passwordType','md5');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('jdbcGroupProvider.allGroupsSQL','SELECT groupName FROM groups');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('jdbcGroupProvider.descriptionSQL','SELECT description FROM groups WHERE groupName=?');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('jdbcGroupProvider.groupCountSQL','SELECT COUNT(*) FROM groups');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('jdbcGroupProvider.loadAdminsSQL','SELECT uid FROM groupusers WHERE groupName=? AND admin=1');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('jdbcGroupProvider.loadMembersSQL','SELECT uid FROM groupusers WHERE groupName=? AND admin=0');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('jdbcGroupProvider.userGroupsSQL','SELECT groupName from groupusers WHERE uid=?');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('jdbcProvider.connectionString','jdbc:mysql://localhost:3306/test?user=root&password=123');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('jdbcProvider.driver','com.mysql.jdbc.Driver');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('jdbcUserProvider.allUsersSQL','SELECT uid FROM users');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('jdbcUserProvider.emailField','email');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('jdbcUserProvider.loadUserSQL','SELECT name,email FROM users WHERE uid=?');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('jdbcUserProvider.nameField','name');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('jdbcUserProvider.searchSQL','SELECT uid FROM users WHERE');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('jdbcUserProvider.userCountSQL','SELECT COUNT(*) FROM users');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('jdbcUserProvider.usernameField','uid');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('passwordKey','5cMv8FI8N6h0naT');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('provider.admin.className','org.jivesoftware.openfire.admin.DefaultAdminProvider');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('provider.auth.className','org.jivesoftware.openfire.auth.JDBCAuthProvider');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('provider.group.className','org.jivesoftware.openfire.group.JDBCGroupProvider');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('provider.lockout.className','org.jivesoftware.openfire.lockout.DefaultLockOutProvider');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('provider.securityAudit.className','org.jivesoftware.openfire.security.DefaultSecurityAuditProvider');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('provider.user.className','org.jivesoftware.openfire.user.JDBCUserProvider');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('provider.vcard.className','org.jivesoftware.openfire.vcard.DefaultVCardProvider');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('update.lastCheck','1355557851794');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('xmpp.auth.anonymous','true');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('xmpp.domain','localhost');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('xmpp.session.conflict-limit','0');
INSERT INTO `ofProperty` (`name`,`propValue`) VALUES ('xmpp.socket.ssl.active','true');