Hello, here’s my openfire.xml I have setup correctly all the database side but when it comes to start openfire i get this error
2007.09.20 04:36:16 org.jivesoftware.openfire.user.UserManager.initProvider(UserManager.java:389) Error loading user provider: org.jivesoftware.openfire.auth.jdbcUserProvider
java.lang.ClassNotFoundException: org.jivesoftware.openfire.auth.jdbcUserProvider
at java.net.URLClassLoader$1.run(Unknown Source)
The page I’ve taken inspiration from looks very alike as my configuration file. what am I doing wrong?
<?xml version=“1.0” encoding=“UTF-8”?>
<jive>
<adminConsole>
<port>9090</port>
<securePort>-1</securePort>
</adminConsole>
<admin>
<authorizedUsernames>bipbip,admin</authorizedUsernames>
</admin>
<locale>en</locale>
<provider>
<auth>
<className>org.jivesoftware.openfire.auth.jdbcAuthProvider</className& gt;
</auth>
<user>
<className>org.jivesoftware.openfire.auth.jdbcUserProvider</className& gt;
</user>
</provider>
<jdbcAuthProvider>
<passwordSQL>SELECT password FROM jiveUser_fed WHERE username=?</passwordSQL>
<passwordType>md5</passwordType>
</jdbcAuthProvider>
<jdbcUserProvider>
<loadUserSQL>SELECT username,email FROM jiveUser_fed WHERE username=?</loadUserSQL>
<userCountSQL>SELECT COUNT(*) FROM members</userCountSQL>
<allUsersSQL>SELECT username FROM members</allUsersSQL>
<searchSQL>SELECT username FROM members WHERE</searchSQL>
<usernameField>username</usernameField>
<nameField>username</nameField>
<emailField>email</emailField>
<passwordType>md5</passwordType>
</jdbcUserProvider>
<connectionProvider>
<className>org.jivesoftware.database.DefaultConnectionProvider</classN ame>
</connectionProvider>
<!–
<jdbcProvider>
<driver>com.mysql.jdbc.Driver</driver>
<connectionString>jdbc:mysql://127.0.0.1/openfire?user=openfire&passw ord=xxx</connectionString>
</jdbcProvider>
–>
<database>
<defaultProvider>
<driver>com.mysql.jdbc.Driver</driver>
<serverURL>jdbc:mysql://127.0.0.1/openfire</serverURL>
<username>openfire</username>
<password>xxx</password>
<minConnections>5</minConnections>
<maxConnections>15</maxConnections>
<connectionTimeout>1.0</connectionTimeout>
</defaultProvider>
</database>
<setup>true</setup>
</jive>