Problem connect to XMPP client with external database

Openfire Openfire Support
1

Hello, I can not connect external database, my user is deactivate in pidgin or other, my admin account it works fine.
I am using postgresql as a database and I turn on debian
I set up my openfire.xml.

log :

2011.10.26 00:07:50 org.jivesoftware.openfire.net.SASLAuthentication - User Login Failed. PLAIN authentication failed for: bob

thank you in advance

2

do you need more information?

3

9090

9091

XX.XX.XXX.XX

org.jivesoftware.database.DefaultConnectionProvider

org.postgresql.Driver

jdbc:postgresql://10.0.0.12:5432/openfire

openfire

password

select 1

true

true

5

25

1.0

org.jivesoftware.openfire.auth.JDBCAuthProvider

org.jivesoftware.openfire.user.JDBCUserProvider

com.mysql.jdbc.Driver

jdbc:postgresql://10.0.0.12:5432/mydatabase?user=postgres&amp ;password=password

SELECT authentication_token FROM users WHERE username=?

plain

SELECT username,email FROM users WHERE username=?

SELECT COUNT(*) FROM users

SELECT username FROM users

SELECT username FROM users WHERE

username

username

email

true

4

have the same issue with MySQL database. I’ve used HSQLDB before but I can’t use it now because of still persistent bug with admin login. it’s not fixed even on 3.7.1

i’m using mac os 10.6.8, java 1.6.0.26, openfire 3.7.1

will appreciate if anyone can share his openfire.xml file with working admin password

5

hi, its very simple use that

http://paazio.nanbudo.fi/projects/tsuka/openfire-database-integration-changes

if you have a probleme, use SELECT lower(yourdata) FROM lower(yourtables)

6

Hello, I am having the same problem, can not set up the custom database integration

I have followed the link from paazio, but found nothing of value … Only the default database credentials are set there, as far as I can see …

I am trying to make OpenFire know of users from my own database and let them authenticate… Below is my openfire.xml file (I am using the OpenFire 3.7.1, Windows 7 64 bits and postgres as DB:

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

9090

9091

en

org.postgresql.Driver

jdbc:postgresql://localhost:5432/openfire

test

test

select 1

true

true

5

25

1.0

org.jivesoftware.openfire.auth.JDBCAuthProvider

org.jivesoftware.openfire.user.JDBCUserProvider

SELECT password FROM iauser WHERE username=?

md5

SELECT username FROM iauser WHERE username=?

SELECT COUNT(*) FROM iauser

SELECT username FROM iauser

SELECT username FROM iauser WHERE

username

username

org.postgresql.Driver

jdbc:postgresql://127.0.0.1/cadtest?user=test&password=te st

org.jivesoftware.database.DefaultConnectionProvider

true

true

Thank you in advance.

7

its better if you use the admin panel, and watch the log.

8

Hey,

I have searched for it on and on, but all I have for profile serrings are default (open fire DB), LDAP and clearcase integration.

I also wanted to look through the logs, but the file debug.log is always empty

I must be missing something BIG here.

Thanks.

9

I followed the steps from the turorial: http://www.igniterealtime.org/builds/openfire/docs/latest/documentation/db-integ ration-guide.html

This is really important for us, since we do not want to have double user maintenance and we already have a user database in production.