powered by Jive Software

Custom database appears SETUP ¿?¿?

Helo everybody.

Im trying to use a external database to autenticate the users. I followed this tutorial: http://www.igniterealtime.org/builds/openfire/docs/latest/documentation/db-integ ration-guide.html

It looks so easy but im not doind it works.

This is the XML that i created

<?xml version="1.0" encoding="UTF-8"?>

9090

9091

es

org.jivesoftware.database.DefaultConnectionProvider

com.mysql.jdbc.Driver

jdbc:mysql://localhost:3306/openfire

openfire

kjlkdsf3FP1RRFD3tga

select 1

true

true

5

25

1.0

admin

com.mysql.jdbc.Driver

jdbc:mysql://example.es/database?user=user&password=pass< /connectionString>

org.jivesoftware.openfire.auth.JDBCAuthProvider

SELECT PASSWORD FROM USUARIOS WHERE USUARIO=?

sha1

SELECT NAME, NAME2 FROM USUARIOS WHERE USUARIO=?

SELECT COUNT(*) FROM USUARIOS

SELECT USUARIOS FROM USUARIOS

SELECT NAME FROM USUARIOS WHERE

USUARIOS

NAME

NAME2

true

But when i restart openfire and i try to acces to the admin panel (http://example.com:9090) it redirects me to the SETUP webpage! I check and true is in the XML file so it should not does this.

What is wrong in the code???

Please help me. I really need it.

By the way I checked and the openfire machine is able to arrive to the database machine so this is not the problem. I can connect to the database machine from the openfire machine.

Thank you again. Im waiting for your ideas.