Greetings all,
Thanks to gato and daniel for a lively discussion about what Openfire does / doesn’t do with regards to recording user login and log outs. I wanted to briefly summarize the discussion and point interested folks to a few Jira issues for you to comment / vote on.
The Problem: I would like to email users on my system that have not logged into my server during the past 3 months, or email users that have created accounts but have never successfully logged in. This does not appear to be currently possible.
Currently, there appears to be no method from within the database to determine:
-
When a user last logged in.
-
If a user is currently logged in.
-
When a user last logged out when the user is currently logged in.
-
If a user has ever been able to successfully log in.
daniel created 2 Jira issues regarding this:
http://www.igniterealtime.org/issues/browse/JM-1257
http://www.igniterealtime.org/issues/browse/JM-1256
While it may be a bit late in the 3.5.0 development cycle, the openfire devs were very open to suggestions about how to better handle this. Some of these changes will require a database schema update, so now is the time to make suggestions!
I would like to see Openfire always store the last login and logout time of each user. One could use this table to determine which users are logged in (where login > logout ).
If folks have other ideas or ways to currently do this, I would be happy to know how!
Thanks for a wonderful system! daryl