Создал тему в данном разделе, т.к. не определить другой.
Нужна помощь в интеграции с MySQL
Конфиг вроде настроил но не работает.
Код:

2010.07.24 20:57:27 Property 'provider.auth.className' as specified in openfire.xml differs from what is stored in the database. Please make property changes in the database instead of openfire.xml.
2010.07.24 20:57:28 Property 'provider.user.className' as specified in openfire.xml differs from what is stored in the database. Please make property changes in the database instead of openfire.xml.
Конфиг:
Код:

<?xml version="1.0" encoding="UTF-8"?>
<jive>
<adminConsole>
<port>9090</port>
<authorizedUsernames>newpdv</authorizedUsernames>
</adminConsole>
<locale>en</locale>
<connectionProvider>
<className>org.jivesoftware.database.DefaultConnectionProvider</className>
</connectionProvider>
<database>
<defaultProvider>
<driver>com.mysql.jdbc.Driver</driver>
<serverURL>jdbc:mysql://localhost:3306/xmpp</serverURL>
<username>root</username>
<password>root</password>
<testSQL>select 1</testSQL>
<testBeforeUse>true</testBeforeUse>
<testAfterUse>true</testAfterUse>
<minConnections>5</minConnections>
<maxConnections>25</maxConnections>
<connectionTimeout>1.0</connectionTimeout>
</defaultProvider>
</database>
<setup>true</setup>
<jdbcProvider>
<driver>com.mysql.jdbc.Driver</driver>
<connectionString>jdbc:mysql://localhost/xmpp?user=root&password=root</connectionString>
</jdbcProvider>
<provider>
<auth>
<className>org.jivesoftware.openfire.auth.JDBCAuthProvider</className>
</auth>
<user>
<className>org.jivesoftware.openfire.user.JDBCAuthProvider</className>
</user>
</provider>
<jdbcAuthProvider>
<passwordSQL>SELECT password FROM users WHERE username=?</passwordSQL>
<passwordType>md5</passwordType>
</jdbcAuthProvider>
<jdbcUserProvider>
<loadUserSQL>SELECT username,email FROM users WHERE username=?</loadUserSQL>
<userCountSQL>SELECT COUNT(*) FROM users</userCountSQL>
<allUsersSQL>SELECT username FROM users</allUsersSQL>
<searchSQL>SELECT username FROM users WHERE</searchSQL>
<usernameField>username</usernameField>
<nameField>username</nameField>
<emailField>email</emailField>
</jdbcUserProvider>
</jive>