Admin Console asking for setup info again

Openfire Openfire Support
1

I’'ve been having problems trying to get Custom Database Integration working using a MySQL database.

So this morning, I decided to wipe the database tables, reload the default xml file, and start over.

So I ran the setup wizard and checked that wildfire was working, which is was.

I edited the wildfire.xml file and added the details regarding database integration as follows (note this is not my entire xml file before anyone says I’'m missing the <jive> opening tag!):

<connectionProvider>

<className>org.jivesoftware.database.DefaultConnectionProvider</classNa me>

</connectionProvider>

<database>

<defaultProvider>

<driver>com.mysql.jdbc.Driver</driver>

<serverURL>jdbc:mysql://localhost:3306/wildfire</serverURL>

<username>wfadmin</username>

<password>*********</password>

<minConnections>5</minConnections>

<maxConnections>15</maxConnections>

<connectionTimeout>1.0</connectionTimeout>

</defaultProvider>

</database>

<setup>true</setup>

<jdbcProvider>

<jdbcDriver>

<className>com.mysql.jdbc.Driver</className>

</jdbcDriver>

<jdbcConnString>jdbc:mysql://localhost/osdgndb?user=osgndba&password=***** ******</jbcConnString>

</jdbcProvider>

<provider>

<auth>

<className>org.jivesoftware.wildfire.auth.JDBCAuthProvider</className&g t;

</auth>

<user>

<className>org.jivesoftware.wildfire.user.JDBCUserProvider</className&g t;

</user>

</provider>

<jdbcAuthProvider>

<passwordSQL>SELECT password FROM osdate_user WHERE username=?</passwordSQL>

<passwordType>md5</passwordType>

</jdbcAuthProvider>

<jdbcUserProvider>

<loadUserSQL>SELECT firstname, email FROM osdate_user WHERE username=?</loadUserSQL>

<userCountSQL>SELECT COUNT(*) FROM osdate_user</userCountSQL>

<allUsersSQL>SELECT username FROM osdate_user</allUsersSQL>

<searchSQL>SELECT username FROM osdate_user WHERE</searchSQL>

<usernameField>username</usernameField>

<nameField>firstname</nameField>

<emailField>email</emailField>

</jdbcUserProvider>

</jive>

Have restarted the wildfire server, but now when I go to the admin console, I am being asked to set-up the database again. Is this normal, should I proceed with the setup again… or are the modifications to the XML file causing the system to think it’'s in new setup mode?

Help!

2

Ignore the above regarding set-up… I’'d mis-spelt one of the closing tags.

Still can’'t log into admin console though… hmmm!

3

IMHO, one shouldn’'t be referring to the old threads that uses jdbcProvider.jdbcDriver.className and jdbcProvider.jdbcConnString. The correct form starting from version 3.0.1 (but not the early release) is jdbcProvider.driver and jdbcProvider.connectionString respectively.

This message mentioned about the JM-786 that corrected the property name bugs in JDBCAuthProvider and JDBCUserProvider. The first item description in the unsolved JM-787 is unnecessary and confusing.

Your config:

BTW, you have several threads opened with similar problem. You should continue with the same thread until your problem is solved.

Message was edited by: aznidin