Custom Database for not to duplicate a user external database

Openfire Openfire Support
1

Hi,

Using the doc i could find on

http://www.igniterealtime.org/builds/openfire/docs/latest/documentation/db-integ ration-guide.html

and trying to use a base name “utilisateurs” and a table containing named “util_psersonnes”

on an mysql server (which contains also the openfire base and whichs run jabber)

i wrote following openfire.xml file

9090 9091 fr org.jivesoftware.database.DefaultConnectionProvider com.mysql.jdbc.Driver jdbc:mysql://localhost:3306/openfire root select 1 true true 5 25 1.0 plain 
<!-- DOC -->
<jdbcProvider>
    <driver>com.mysql.jdbc.Driver</driver>
    <connectionString>jdbc:mysql://localhost/utilisateurs?user=root&amp;password=se cret</connectionString>
</jdbcProvider>
<provider>
  <auth>
    <className>org.jivesoftware.openfire.auth.JDBCAuthProvider</className>
  </auth> 
  <!-- DOC --> 
  <user>
    <className>org.jivesoftware.openfire.user.JDBCUserProvider</className>
  </user>
</provider> 
<!-- DOC -->
<jdbcAuthProvider>
  <passwordSQL>SELECT util_passwd FROM util_personnes WHERE username=?</passwordSQL>
  <passwordType>plain</passwordType>
</jdbcAuthProvider>
<!-- DOC -->
<jdbcUserProvider>
    <loadUserSQL>SELECT util_nom FROM util_personnes WHERE util_login=?</loadUserSQL>
    <userCountSQL>SELECT COUNT(*) FROM util_personnes</userCountSQL>
    <allUsersSQL>SELECT util_login FROM util_personnes</allUsersSQL>
    <searchSQL>SELECT util_login FROM util_personnes</searchSQL>
    <usernameField>util_login</usernameField>
</jdbcUserProvider>
true

but it does’nt work

I am not able to connect to this foreign base

Have you some advice or better a working exemple ?

Thanks for help

Marc.