openfire整合现有业务系统用户
insert into ofproperty( name, propValue) values( 'admin.authorizedJIDs' , 'admin@hshy-053-pc'); insert into ofproperty( name, propValue) values( 'jdbcAuthProvider.passwordSQL' , 'select password from tb_user where username=?');insert into ofproperty( name, propValue) values( 'jdbcAuthProvider.passwordType' , 'md5');insert into ofproperty( name, propValue) values( 'jdbcProvider.connectionString' , 'jdbc:mysql://192.168.12.7:3306/eisp?user=root&password=root');insert into ofproperty( name, propValue) values( 'jdbcProvider.driver' , 'com.mysql.jdbc.Driver' );insert into ofproperty( name, propValue) values( 'jdbcUserProvider.allUsersSQL' , 'select username from tb_user' );insert into ofproperty( name, propValue) values( 'jdbcUserProvider.emailField' , 'email');insert into ofproperty( name, propValue) values( 'jdbcUserProvider.loadUserSQL' , 'select u.username,p.name,p.email from tb_user u left join tb_person p on u.id=p.userid where u.username=?');insert into ofproperty( name, propValue) values( 'jdbcUserProvider.nameField' , 'name');insert into ofproperty( name, propValue) values( 'jdbcUserProvider.userCountSQL' , 'select count(username) from tb_user');insert into ofproperty( name, propValue) values( 'jdbcUserProvider.usernameField' , 'username' ); UPDATE ofproperty SET propValue ='org.jivesoftware.openfire.auth.JDBCAuthProvider' WHERE NAME='provider.auth.className';UPDATE ofproperty SET propValue='org.jivesoftware.openfire.user.JDBCUserProvider' WHERE NAME='provider.user.className';
?
?
