Not able to add users in pidgin, shows not authorized

using Openfire 3.6.4 but whenever adding a user using pidgin client, it shows offline and not authorized. The other person also not get any popup to authorize the request. this happens if adding new user and also if u delete an existing user and try to readd that user. In the error.log logs we see:

2011.11.04 09:46:33 [org.jivesoftware.openfire.handler.PresenceSubscribeHandler.process(PresenceSub scribeHandler.java:194)] Internal server error

org.jivesoftware.openfire.user.UserAlreadyExistsException:

at org.jivesoftware.openfire.roster.RosterItemProvider.createItem(RosterItemProvid er.java:109)

at org.jivesoftware.openfire.roster.Roster.provideRosterItem(Roster.java:330)

at org.jivesoftware.openfire.roster.Roster.createRosterItem(Roster.java:280)

at org.jivesoftware.openfire.roster.Roster.createRosterItem(Roster.java:264)

at org.jivesoftware.openfire.handler.PresenceSubscribeHandler.manageSub(PresenceSu bscribeHandler.java:249)

at org.jivesoftware.openfire.handler.PresenceSubscribeHandler.process(PresenceSubs cribeHandler.java:115)

at org.jivesoftware.openfire.PresenceRouter.handle(PresenceRouter.java:174)

at org.jivesoftware.openfire.PresenceRouter.route(PresenceRouter.java:70)

at org.jivesoftware.openfire.spi.PacketRouterImpl.route(PacketRouterImpl.java:76)

at org.jivesoftware.openfire.net.StanzaHandler.processPresence(StanzaHandler.java: 337)

at org.jivesoftware.openfire.net.ClientStanzaHandler.processPresence(ClientStanzaH andler.java:85)

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

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

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

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.common.IoFilterAdapter.messageReceived(IoFilterAdapter.java:80)

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:185)

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 :239)

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

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)

Please advise.

Yogesh,

I would recommend upgrading to the OpenFire 3.7.1 version. It should help with some of the memory errors that EarthLink is having as well. I thought you were going to upgrade to 3.7 in first quarter 2011?

Sometimes the mysql table gets out of sync for some reason. Maybe the id column value in ofID table needs to be incremented.

Thank you Jonathan for your post. I have also seen the post related to

increment the id value and DBAs updated the same in jabber DB ans issue

appeared to be resolved now.

On Fri, Dec 2, 2011 at 11:57 PM, jmalnati <communityadmin@igniterealtime.org