Up to Discussions in Openfire Support
2 Replies Last post: Nov 11, 2007 4:47 PM by hill  
hill Bronze
hill
2 posts since
Nov 3, 2007
Currently Being Moderated

Nov 3, 2007 9:39 AM

Use Open-Xchange database for connection

Hello,

 

Sorry for my english

 

I want to use the database MySQL user of open-Xchange for my authentification.

 

I have a problem SASL authentication.

 

Here logs logs/warn.log

 

Javax.security.sasl.SaslException: PLAIN authentication failed Caused by javax.security.sasl.SaslException: PLAIN: user not authorized: oxadmin

...

Caused by: javax.security.sasl.SaslException: PLAIN: user not authorized: oxadmin

My configuration file conf/openfire.xml Com.mysql.jdbc.Driver jdbc: mysql://localhost:3306/open-xchange-db?User=openexchange&password=XXXX org.jivesoftware.openfire.auth.JDBCAuthProvider org.jivesoftware.openfire.user.JDBCUserProvider SELECT user.userPassword FROM user, login2user WHERE user.id=login2user.id AND login2user.uid=? md5 SELECT login2user.uid, user.mail FROM user, login2user WHERE user.id=login2user.id AND login2user.uid=? SELECT COUNT (*) FROM user SELECT uid FROM login2user SELECT uid FROM login2user WHERE login2user.uid login2user.uid user.mail org.jivesoftware.database.DefaultConnectionProvider ]]>

 

My config imap for authentication via SASL is PLAIN. The problem is here ?

 

Do you have an idea?

 

Regards,

Cyp

Tags: configuration, connection, database, mysql, sasl
carlos_is Bronze
carlos_is
4 posts since
May 24, 2007
Currently Being Moderated
Nov 7, 2007 10:54 AM in response to: hill
Re: Use Open-Xchange database for connection

I HAVE THE SAME PROBLEM

 

OPENFIRE 3.4.1

 

2007.11.07 11:49:10 SaslException

javax.security.sasl.SaslException: PLAIN authentication failed Caused by javax.security.sasl.SaslException: PLAIN: user not authorized: iramos

at org.jivesoftware.openfire.sasl.SaslServerPlainImpl.evaluateResponse(SaslServerP lainImpl.java:144)

at org.jivesoftware.openfire.net.SASLAuthentication.handle(SASLAuthentication.java :229)

at org.jivesoftware.openfire.net.StanzaHandler.process(StanzaHandler.java:152)

at org.jivesoftware.openfire.nio.ConnectionHandler.messageReceived(ConnectionHandl er.java:132)

at org.apache.mina.common.support.AbstractIoFilterChain$TailFilter.messageReceived (AbstractIoFilterChain.java:570)

at org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageReceived(Ab stractIoFilterChain.java:299)

at org.apache.mina.common.support.AbstractIoFilterChain.access$1100(AbstractIoFilt erChain.java:53)

at org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.messageReceive d(AbstractIoFilterChain.java:648)

at org.apache.mina.filter.codec.support.SimpleProtocolDecoderOutput.flush(SimplePr otocolDecoderOutput.java:58)

at org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecF ilter.java:162)

at org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageReceived(Ab stractIoFilterChain.java:299)

at org.apache.mina.common.support.AbstractIoFilterChain.access$1100(AbstractIoFilt erChain.java:53)

at org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.messageReceive d(AbstractIoFilterChain.java:648)

at org.apache.mina.filter.executor.ExecutorFilter.processEvent(ExecutorFilter.java :240)

at org.apache.mina.filter.executor.ExecutorFilter$ProcessEventsRunnable.run(Execut orFilter.java:284)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Caused by: javax.security.sasl.SaslException: PLAIN: user not authorized: iramos

at org.jivesoftware.openfire.sasl.SaslServerPlainImpl.evaluateResponse(SaslServerP lainImpl.java:124)

... 17 more

Report Abuse
hill Bronze
hill
2 posts since
Nov 3, 2007
Currently Being Moderated
Nov 11, 2007 4:47 PM in response to: carlos_is
Re: Use Open-Xchange database for connection

 

Simple  !

 

 

Change  in conf/openfire.xml

 

 

<serverURL>jdbc:mysql://localhost:3306/openfire</serverURL>

by

<serverURL>jdbc:mysql://localhost:3306/open-xchange-db</serverURL>

 

 

Have to be sure that the tables openfire are well installed in the database open-Xchange

 

 

++

Cyp

 

 

Report Abuse

More Like This

  • Retrieving data ...