10 Replies Latest reply on Aug 3, 2017 8:39 AM by Daryl Herzmann

    lastLogin

    Erik

      is there any way to check "when" a user was last logged in? i heared something of a plugin "user-status-plugin", but i dont find it in the list...

        • Re: lastLogin
          Erik

          is there no way?

            • Re: lastLogin
              wroot

              I haven't heard about such plugin or a way to show last login. Because for online users you can see when the session was created (on the Sessions page). For offline users there is a Last Logout value, which may be sufficient (login in the morning, log out in the evening, so you have a ~1 day accuracy). If you really need to see last login date of an offline user, when maybe it is stored in the database (not sure about that as it doesn't seem to be a valuable information), but there is no GUI to show that.

            • Re: lastLogin
              Daryl Herzmann

              The UserStatus plugin is not within the Ignite provided plugins.  Here's a version that I generated.

              1 of 1 people found this helpful
                • Re: lastLogin
                  Erik

                  quit cool, but is this also working with the "embedded db"? how to install it?

                    • Re: lastLogin
                      wroot

                      No difference. In Admin Console go to Plugins, click on Browse, select this file and then press Upload. Its menu will appear in Server Settings tab.

                        • Re: lastLogin
                          Erik

                          yes i know, but how to create the needed tables in the db... only upload will not work:

                           

                          error.log:

                           

                          2017.07.25 08:28:29 org.jivesoftware.util.Log - Unable to update presence for m.hoth@domain.de/Spark

                          java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: USERSTATUS in statement [UPDATE userStatus SET presence = ? WHERE username = ? AND resource = ?]

                            • Re: lastLogin
                              wroot

                              That would be a question for Daryl. Maybe plugin is not compatible with your version of Openfire. What version do you have? Though plugin says its min version requirement is 3.6.0. Which is pretty old, so it might be that it is not compatible with some changes in the database schema of the current versions of Openfire.

                              • Re: lastLogin
                                Daryl Herzmann

                                Do you find other errors logged when you actually first load the plugin?  At which time the schema update should be done.