I already have a ‘User’ table (which would allow spaces in ‘user_names’ column ) and I want to integrate my ‘User’ table with openFire,
From this document Openfire: Custom Database Integration Guide In ‘Authentication Integration’ section ,
It is mentioned to set this property ‘jdbcAuthProvider.passwordSQL’ to the mysql query similar to
SELECT password FROM user_account WHERE username=?
Can I use valid mysql queries in this properties
for example :
SELECT password FROM user_account WHERE replace (user_names, ’ ', ‘’) =?
as usernames with spaces for sasl authentication is not a valid jabber id .
Note: I cannot update ‘user_names’ in my remote database but the clients connected to openfire will report ‘user_names’ without spaces.