mysql - OpenFire integrating external database -

hi having trouble integrating exsisting openfire installtion existing db.

i have 2 database namely (for example purposes)

1. db_mainsite
2. db_openfire

inside db_mainsite have table called tbl_user there lies 2 columns namely gw_userunique , gw_password (varchar 255, using sha-1 hashing algo).

both database lies within same machine (server) having same physical location.

in conf/openfire.xml have set following lines

<jive>   ...   <jdbcprovider>     <driver>com.mysql.jdbc.driver</driver>     <connectionstring>jdbc:mysql://localhost/db_mainsite?user=username&amp;password=secret</connectionstring>   </jdbcprovider>   <provider>     <auth>       <classname>org.jivesoftware.openfire.auth.jdbcauthprovider</classname>     </auth>   </provider>   <jdbcauthprovider>    <passwordsql>select password tbl_user gw_userunique=?</passwordsql>    <passwordtype>sha1</passwordtype>   </jdbcauthprovider>   ... </jive> 

sadly, whenever try login using username + password stored in db_mainsite fails.

i have restart openfire well.

can tell me wrong?

cheers,

no need modify config file, run script in openfire database( validated in 3.10.3):

## add jdbc drive insert `ofproperty` values ('jdbcprovider.driver', 'com.mysql.jdbc.driver'); ## external membership database connection  insert `ofproperty` values ('jdbcprovider.connectionstring', 'jdbc:mysql://youripaddress:3306/db_mainsite?user=root&password=root'); ## auth  update `ofproperty` set  propvalue='org.jivesoftware.openfire.auth.jdbcauthprovider'      name='provider.auth.classname'; ## search password  insert `ofproperty` values ('jdbcauthprovider.passwordsql', 'select  plainpassword dzmembership id= ?'); ## encrypted type：plain，md5，sha1，sha256，sha512 insert `ofproperty` values ('jdbcauthprovider.passwordtype', 'plain'); ## displyed in admin console update  `ofproperty` set propvalue='org.jivesoftware.openfire.user.jdbcuserprovider' name='provider.user.classname'; ## uyser info in admin console  insert `ofproperty` values ('jdbcuserprovider.loadusersql', 'select username name,concat(username,''_'',nickname) dzmembership id=?'); ## user amount  insert `ofproperty` values ('jdbcuserprovider.usercountsql', 'select count(*) dzmembership'); ## users  insert `ofproperty` values ('jdbcuserprovider.alluserssql', 'select id dzmembership'); ## search  insert `ofproperty` values ('jdbcuserprovider.searchsql', 'select id dzmembership where'); ## username displayed in console insert `ofproperty` values ('jdbcuserprovider.usernamefield', 'username'); ## id  displayed in console  insert `ofproperty` values ('jdbcuserprovider.namefield', 'id'); ## email displayed in console insert `ofproperty` values ('jdbcuserprovider.emailfield', 'email'); ##admin username insert `ofproperty` values ('admin.authorizedjids', '13cb2932-e855-4c3e-8e54-a58e0135802d@ipaddress'); update ofproperty set propvalue='ipaddress' name='xmpp.domain'