Dear Openfire Team and users,
Im trying to setup a user integration betwen atmail database and Openfire database
I read some posts like this http://www.igniterealtime.org/community/message/161843#30551
but after few hours of trying i give it up
When openfire server starts i got the setup screen, he ask for language, database server bla bla bla
I have a backup configuration and when i use it ev its good
Im running Openfire on Debian 4.0
cand be a problem because username its user@domain.com ? from the Atmail database ?
<setup>true</setup>
<jdbcProvider>
<driver>com.mysql.jdbc.Driver</driver>
<connectionString>jdbc:mysql://localhost/atmail?user=root&password=somepas s</connectionString>
</jdbcProvider>
<provider>
<auth>
<className>org.jivesoftware.openfire.auth.JDBCAuthProvider</className&g t;
</auth>
<user>
<className>org.jivesoftware.openfire.user.JDBCUserProvider</className&g t;
</user>
</provider>
<jdbcAuthProvider>
<passwordSQL>SELECT Password FROM UserSession WHERE Account=?</passwordSQL>
<passwordType>md5</passwordType>
</jdbcAuthProvider>
<jdbcUserProvider>
<loadUserSQL>SELECT CONCAT(FirstName,’ ',LastName),OtherEmail FROM Users WHERE Account=?</loadUserSQL>
<userCountSQL>SELECT COUNT(*) FROM Users</userCountSQL>
<allUsersSQL>SELECT Account FROM Users</allUsersSQL>
<searchSQL>SELECT Account FROM Users WHERE</searchSQL>
<usernameField>Account</usernameField>
<nameField>CONCAT(FirstName,’ ',LastName)</nameField>
<emailField>OtherEmail</emailField>
</jdbcUserProvider>
Atmail database its atmail
table Users contain : Account ( wich its the username to login in email service ), OtherEmail , FirstName, LastName and many more
table userSession contain : Account , and Password (using md5 ) , LastLogin etc
Ive checked the mysql query via phpmyadmin and ev its ok with the sintax
Any ideea …
Thank you in advance for your help !!!
Best Regards