openfire external user auth
Our company needs to use openfire for an xmpp chat app, and we would like to use the already existing table of users for authentication rather than the ofUser table that's a part of openfire.  I have already installed openfire on our server and have configured it to use our mysql database and it has created the necessary tables.  I'm trying to follow the Custom Database Integration Guide found [here][1]


  [1]: http://www.igniterealtime.org/builds/openfire/docs/latest/documentation/db-integration-guide.html 
but I can't get it to work.  My configuration file is below (with the table names changed slightly):

    <jdbcProvider>
	<driver>com.mysql.jdbc.Driver</driver>
	<connectionString>jdbc:mysql://localhost/fueledin_winkage?user=fueledin_winkage&amp;password=845Fulton</connectionString>
    </jdbcProvider>
    <provider>
      <auth>
		<className>org.jivesoftware.openfire.auth.JDBCAuthProvider</className>
      </auth>
      <user>
		<className>org.jivesoftware.openfire.user.JDBCUserProvider</className>
      </user>
    </provider>
    <jdbcAuthProvider>
        <passwordSQL>SELECT password FROM users WHERE email=?</passwordSQL>
     	<passwordType>md5</passwordType>
    </jdbcAuthProvider>
    <jdbcUserProvider>
     	<loadUserSQL>SELECT email,email FROM users WHERE email=?</loadUserSQL>
     	<userCountSQL>SELECT COUNT(*) FROM users</userCountSQL>
     	<allUsersSQL>SELECT email FROM users</allUsersSQL>
     	<searchSQL>SELECT email FROM users WHERE</searchSQL>
     	<usernameField>email</usernameField>
     	<nameField>email</nameField>
     	<emailField>email</emailField>
    </jdbcUserProvider>
    <setup>true</setup>

It's kind of a weird setup because users can change their username whenever so email is used to login.  Can someone explain what I may be doing wrong, I tried logging into the server with users in our users table but no luck.  Also, after I ran the setup wizard in the browser I edited the configuration script to look like above, and now every time I go to the browser tool it asks me to run the setup wizard again, even if I run it again it still asks afterwards. Any help appreciated thanks in advance.
openfire external user auth
===

Our company needs to use openfire for an xmpp chat app, and we would like to use the already existing table of users for authentication rather than the ofUser table that's a part of openfire.  I have already installed openfire on our server and have configured it to use our mysql database and it has created the necessary tables.  I'm trying to follow the Custom Database Integration Guide found [here][1]


  [1]: http://www.igniterealtime.org/builds/openfire/docs/latest/documentation/db-integration-guide.html 
but I can't get it to work.  My configuration file is below (with the table names changed slightly):

    <jdbcProvider>
	<driver>com.mysql.jdbc.Driver</driver>
	<connectionString>jdbc:mysql://localhost/fueledin_winkage?user=fueledin_winkage&amp;password=845Fulton</connectionString>
    </jdbcProvider>
    <provider>
      <auth>
		<className>org.jivesoftware.openfire.auth.JDBCAuthProvider</className>
      </auth>
      <user>
		<className>org.jivesoftware.openfire.user.JDBCUserProvider</className>
      </user>
    </provider>
    <jdbcAuthProvider>
        <passwordSQL>SELECT password FROM users WHERE email=?</passwordSQL>
     	<passwordType>md5</passwordType>
    </jdbcAuthProvider>
    <jdbcUserProvider>
     	<loadUserSQL>SELECT email,email FROM users WHERE email=?</loadUserSQL>
     	<userCountSQL>SELECT COUNT(*) FROM users</userCountSQL>
     	<allUsersSQL>SELECT email FROM users</allUsersSQL>
     	<searchSQL>SELECT email FROM users WHERE</searchSQL>
     	<usernameField>email</usernameField>
     	<nameField>email</nameField>
     	<emailField>email</emailField>
    </jdbcUserProvider>
    <setup>true</setup>

It's kind of a weird setup because users can change their username whenever so email is used to login.  Can someone explain what I may be doing wrong, I tried logging into the server with users in our users table but no luck.  Also, after I ran the setup wizard in the browser I edited the configuration script to look like above, and now every time I go to the browser tool it asks me to run the setup wizard again, even if I run it again it still asks afterwards. Any help appreciated thanks in advance.