I’m tring to use a table exsist in mysql database for user authtication, followed the instruction of “Custom Database Integration Guide”. There are 2 problem here.
1> Only when i set “<passwordType>plain</passwordType>” in openfire.xml , the user can login correctly. With “md5” or “sha1” , the authentication will fail. I will chage the mysql table every time i change the passwordType.
2> when i login to the admin webpage , it tells that the account table is read-only , i am pretty sure that the user set in <connectionString>…</connectionStrin> do have full privilage of operate the table.
centos-4.4 , mysql-5.0.27 , java-1.5