摘抄 http://www.cnblogs.com/hannover/archive/2008/12/12/1353806.html
1、启动ajmessage服务器,然后进入
http://172.16.15.110:9090/server-properties.jsp (系统属性配置)
insert into ofproperty( name, propValue) values( 'jdbcAuthProvider.passwordSQL' , 'select pass from user where name=?' );
insert into ofproperty( name, propValue) values( 'jdbcAuthProvider.passwordType' , 'plain' );
//plain属性表示是对密码不做任何加密处理
//md5
//sha1
//sha256
//sha512
insert into ofproperty( name, propValue) values( 'jdbcProvider.connectionString' , 'jdbc:mysql://172.16.32.72:3306/hb?user=root&password=admin' );
insert into ofproperty( name, propValue) values( 'jdbcProvider.driver' , 'com.mysql.jdbc.Driver' );
//用户登录使用(根据用户名来)
insert into ofproperty( name, propValue) values( 'jdbcUserProvider.loadUserSQL' , 'SELECT id,name,pass from user where name=?');
//查看所有用户使用
insert into ofproperty( name, propValue) values( 'jdbcUserProvider.allUsersSQL' , 'select name from user' );
insert into ofproperty( name, propValue) values( 'provider.auth.className' , 'org.jivesoftware.openfire.auth.JDBCAuthProvider' );
insert into ofproperty( name, propValue) values( 'provider.user.className' , 'org.jivesoftware.openfire.user.JDBCUserProvider' );
//所有的用户数量,用来分页处理
insert into ofproperty( name, propValue) values( 'jdbcUserProvider.userCountSQL' , 'SELECT count(id) from user' );
2、目标表的结构
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(8) NOT NULL,
`name` varchar(20) NOT NULL,
`pass` varchar(64) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'admin', 'admin');
INSERT INTO `user` VALUES ('2', 'hb', 'hb');
INSERT INTO `user` VALUES ('3', 'zqt', 'zqt');