Openfire probleme

Problem configuration for JDBC Provider, I can not make connection XMPP

i have test to connect to Spark, glu and Jabbear
i use linux x86_64.
here is my openfire.xml
<?xml version=\"1.0\" encoding=\"UTF-8\"?>
<jive>
<adminConsole>
<port>9090</port>
<securePort>9091</securePort>
</adminConsole>
<locale>fr</locale>
<jdbcProvider>
<connectionString>jdbc:postgresql://10.0.0.37/mydatabase?user=postgres;password =p@ssword</connectionString>
</jdbcProvider>
<provider>
<auth/>
<user>
<className>org.jivesoftware.openfire.user.JDBCUserProvider</className>
</user>
<group>
<className>org.jivesoftware.openfire.group.JDBCGroupProvider</className>
</group>
</provider>
<jdbcAuthProvider/>
<jdbcUserProvider>
<loadUserSQL>SELECT username,email FROM Users WHERE username = ?</loadUserSQL>
<userCountSQL>SELECT COUNT(*) FROM Users</userCountSQL>
<allUsersSQL>SELECT username FROM Users</allUsersSQL>
<searchSQL>SELECT username FROM Users WHERE</searchSQL>
<usernameField>username</usernameField>
<nameField>username</nameField>
<emailField>email</emailField>
</jdbcUserProvider>
<connectionProvider>
<className>org.jivesoftware.database.DefaultConnectionProvider</className>
</connectionProvider>
<database>
<defaultProvider>
<driver>org.postgresql.Driver</driver>
<serverURL>jdbc:postgresql://10.0.0.37:5432/openfire</serverURL>;
<username>openfire</username>
<password>p@ssword</password>
<testSQL>select 1</testSQL>
<testBeforeUse>true</testBeforeUse>
<testAfterUse>true</testAfterUse>
<minConnections>5</minConnections>
<maxConnections>25</maxConnections>
<connectionTimeout>1.0</connectionTimeout>
</defaultProvider>
</database>
<setup>true</setup>
</jive>

Commentaire supprimé.