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.