I’ve setup several Openfire servers in the last 2 months testing different aspects. I have LDAP authentication working (ssl to another server) with groupings automatically populating the client. I just setup a new Openfire 3.4.1 server starting from scratch and a brand new server running CentOS 5 and I wanted to add the MySQL DB. as opposed to the internal DB. I followed the database installation instructions and during the initial Openfire console set up it connected to the MySQL server. I was then able to login to the console using one of the admin users where I set some up some additional items such as security settings and server connections, etc. I then logged out and restarted the Openfire server and now I cannot log back into either the console or from a client. I’m remembering now, that I’ve had this happen before and it’s always when I turn on MySQL access. If I change the openfire.xml file to use the internal DB then I can login. I’ve granted the jabber user within mysql all priviledges, can login as that user, and see and edit the jabber table. I’m stumped. Here are the last few lines from the logs/warn.log file just after a login attempt:
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: dslaughter
at org.jivesoftware.openfire.sasl.SaslServerPlainImpl.evaluateResponse(SaslServerP lainImpl.java:127)
… 17 more
Any help would very appreciated.