Hi i am having trouble integrating my exsisting OpenFire installtion with an already existing DB.
I have 2 database namely (for example purposes)
- db_mainsite
- db_openfire
Inside my db_mainsite i have a table called tbl_user where there lies 2 columns namely gw_userunique and gw_password (VARCHAR 255, however using SHA-1 hashing algo).
Both database lies within the same machine (server) thus having the same physical location.
In my conf/openfire.xml i have set the following lines
<jive>
...
<jdbcProvider>
<driver>com.mysql.jdbc.Driver</driver>
<connectionString>jdbc:mysql://localhost/db_mainsite?user=username&password=secret</connectionString>
</jdbcProvider>
<provider>
<auth>
<className>org.jivesoftware.openfire.auth.JDBCAuthProvider</className>
</auth>
</provider>
<jdbcAuthProvider>
<passwordSQL>SELECT password FROM tbl_user WHERE gw_userunique=?</passwordSQL>
<passwordType>sha1</passwordType>
</jdbcAuthProvider>
...
</jive>
Sadly, whenever i try to login using the username + password stored in db_mainsite it always fails.
I have restart OpenFire as well.
Can anyone tell me what is wrong?
Cheers,