XMPP user online duration from open fire DB tables

I would like to know if its possible to write a query that could be executed against the openfire database to find out for how long a specific xmpp user has been online.

Also, i would like to know if the openfire database stores the history of the xmpp user connections?

Your answer is very much appreciated.

Thanks

Hello,

I don’t believe either are possible with the basic distribution of openfire.

daryl

Thanks for the reply.

The reason why i wanted to know the duration for which the user is online is because we encountered BoshException while trying to initiate a client connection. I wanted to know why the client was retrying to initiate a connection when it was successfully able to establish a connection earlier.

Below is the link to the error that we encountered:

http://community.igniterealtime.org/message/224254#224254