Hi,
I’ve installed Openfire 3.4.2 on my developer laptop (Windows XP SP2, MySQL 5.0.45 (latest stable)). Earlier I used 3.3.3, with what I didn’t see the following problem. I did a clean install (not upgrade) from the zip file.
I use JDBCAuthProvider to authenticate against my Drupal database, which runs on MySQL.
The relevant part of my configuration file (attached) is:
<jdbcProvider>
<driver>com.mysql.jdbc.Driver</driver>
<connectionString>jdbc:mysql://localhost/drupal_db?user=drupal_user&p assword=password</connectionString>
</jdbcProvider>
<provider>
<auth>
<className>org.jivesoftware.openfire.auth.JDBCAuthProvider</className& gt;
</auth>
</provider>
<jdbcAuthProvider>
<passwordSQL>SELECT pass FROM users WHERE name=?</passwordSQL>
<passwordType>md5</passwordType>
</jdbcAuthProvider>
I’ve received some exceptions about this (attached), but I think it works since then (see no new enrty in error log).