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.



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


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: