powered by Jive Software

Error loading user provider: org.jivesoftware.openfire.auth.jdbcUserProvider

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>

Hi musso, welcome to Igniterealtime community B-).

Java is case sensitive, and so org.jivesoftware.openfire.auth.jdbcUserProvider should be spelled as org.jivesoftware.openfire.auth.JDBCUserProvider instead.

Thank you very much for the welcome and the tip.

I’m not an edge with Java, so the problem was exactly solved minding the case of the classes.

thanks a lot