OpenFire Fast integration of third-party user tables

UPDATE ' wmq '. ' Ofproperty ' SET propvalue= ' org.jivesoftware.openfire.user.JDBCUserProvider ' WHERE name= ' Provider.user.className ';
UPDATE ' wmq '. ' Ofproperty ' SET propvalue= ' org.jivesoftware.openfire.auth.JDBCAuthProvider ' WHERE name= ' Provider.auth.className ';
INSERT into ' wmq '. ' Ofproperty ' VALUES
(' Jdbcprovider.driver ', ' com.mysql.jdbc.Driver '),
(' jdbcprovider.connectionstring ', ' jdbc:mysql://localhost:3306/wmq?user=root&password= '),
(' Admin.authorizedjids ', ' [email protected] '),
(' Jdbcauthprovider.passwordsql ', ' SELECT pass from Wmq_member WHERE card=? '),
(' Jdbcauthprovider.passwordtype ', ' MD5 '),
(' Jdbcuserprovider.loadusersql ', ' SELECT card, AppID from Wmq_member WHERE card=? '),
(' Jdbcuserprovider.usercountsql ', ' SELECT COUNT (*) from Wmq_member '),
(' Jdbcuserprovider.alluserssql ', ' SELECT card from Wmq_member '),
(' Jdbcuserprovider.searchsql ', ' SELECT card from Wmq_member WHERE '),
(' Jdbcuserprovider.usernamefield ', ' card '),
(' Jdbcuserprovider.namefield ', ' nickname '),
(' Jdbcuserprovider.emailfield ', ' AppID ');

OpenFire Fast integration of third-party user tables