userstatus Plugin Archive

Below is a list of versions that are available for the userstatus plugin. To find other plugins, please review this listing of most recent releases of all plugins.

Plugins extend and enhance the functionality of Openfire. To install plugins, copy the .jar file into the plugins directory of your Openfire installation.

User Status Plugin Readme

Overview

Openfire plugin to save the user status to the database.

This plugin automatically saves the last status (presence, IP address, logon and logoff time) per user and resource to userStatus table in the Openfire database.

Optionally you can archive user status entries (IP address, logon and logoff time) for a specified time. History entries are stored in the userStatusHistory table. The settings for history archiving can be configured on the "User Status Settings" page that you'll find on the "Server" tab of the Openfire Admin Console.

Limitations

Of the databases supported by Openfire, this plugin does notsupport Oracle. This is not due to any technical reason, just nobody hassubmitted the needed sql script to initialize the userStatus plugin databaseschema for Oracle.

Database Schema

The userStatus table contains the last status per user and resource:

CREATE TABLE userStatus (    username        VARCHAR(64)         NOT NULL,    resource        VARCHAR(64)         NOT NULL,    online          TINYINT             NOT NULL,    presence        CHAR(15),    lastIpAddress   CHAR(45)            NOT NULL,    lastLoginDate   CHAR(15)            NOT NULL,    lastLogoffDate  CHAR(15),    PRIMARY KEY pk_userStatus (username, resource));

The userStatusHistory table contains the archived status entries if enabled:

CREATE TABLE userStatusHistory (    historyID       BIGINT              NOT NULL,    username        VARCHAR(64)         NOT NULL,    resource        VARCHAR(64)         NOT NULL,    lastIpAddress   CHAR(45)            NOT NULL,    lastLoginDate   CHAR(15)            NOT NULL,    lastLogoffDate  CHAR(15)            NOT NULL,    PRIMARY KEY pk_userStatusHistory (historyID));
Copyright © 2007,2017 Stefan Reuter
Releases Info File Version Released Openfire Version
Plugin User Status Plugin
Openfire plugin to save the user status to the database.
README Changelog Download 1.3.0 Nov 28, 2023 4.0.0 +
Plugin User Status Plugin
Openfire plugin to save the user status to the database.
README Changelog Download 1.2.3 May 2, 2023 4.0.0
- 4.8.0
Plugin User Status Plugin
Openfire plugin to save the user status to the database.
README Changelog Download 1.2.2 Oct 29, 2019 4.0.0 +
Plugin User Status Plugin
Openfire plugin to save the user status to the database.
README Changelog Download 1.2.1 Jun 1, 2019 4.0.0 +
Plugin User Status Plugin
Openfire plugin to save the user status to the database.
README Changelog Download 1.2.0 Dec 13, 2017 4.0.0 +
Plugin User Status Plugin
Openfire plugin to save the user status to the database.
README Changelog Download 1.0.4 Jan 3, 2019 3.6.0 +

The plugins below, so-called SNAPSHOTS, are build automatically by the continuous integration system. They represent the latest development, but are untested.

Snapshots Info File Version Built at Openfire Version
Plugin User Status Plugin
README Changelog Download 1.3.1-SNAPSHOT Nov 28, 2023 1:58:19 PM 4.0.0 +
Plugin User Status Plugin
README Changelog Download 1.3.0-SNAPSHOT Nov 27, 2023 5:36:53 PM 4.0.0 +
Plugin User Status Plugin
README Changelog Download 1.2.4-SNAPSHOT May 2, 2023 5:05:48 PM 4.0.0
- 4.8.0
Plugin User Status Plugin
README Changelog Download 1.2.3-SNAPSHOT Apr 21, 2022 1:34:35 PM 4.0.0 +
Plugin User Status Plugin
README Changelog Download 1.2.3-SNAPSHOT Oct 27, 2021 1:47:01 PM 4.0.0 +
Plugin User Status Plugin
README Changelog Download 1.2.3-SNAPSHOT Feb 9, 2021 9:24:53 AM 4.0.0 +
Plugin User Status Plugin
README Changelog Download 1.2.3-SNAPSHOT Oct 13, 2020 11:29:47 AM 4.0.0 +
Plugin User Status Plugin
README Changelog Download 1.2.3-SNAPSHOT Oct 13, 2020 12:38:19 AM 4.0.0 +
Plugin User Status Plugin
README Changelog Download 1.2.3-SNAPSHOT Apr 2, 2020 1:42:53 PM 4.0.0 +
Plugin User Status Plugin
README Changelog Download 1.2.3-SNAPSHOT Feb 11, 2020 3:22:14 PM 4.0.0 +
Plugin User Status Plugin
README Changelog Download 1.2.3-SNAPSHOT Feb 11, 2020 2:23:39 PM 4.0.0 +
Plugin User Status Plugin
README Changelog Download 1.2.3-SNAPSHOT Jan 31, 2020 7:32:52 PM 4.0.0 +
Plugin User Status Plugin
README Changelog Download 1.2.3-SNAPSHOT Jan 31, 2020 7:18:44 PM 4.0.0 +
Plugin User Status Plugin
README Changelog Download 1.2.2-SNAPSHOT Oct 29, 2019 10:40:45 AM 4.0.0 +
Plugin User Status Plugin
README Changelog Download 1.2.2-SNAPSHOT Oct 29, 2019 10:25:37 AM 4.0.0 +
Plugin User Status Plugin
README Changelog Download 1.2.2-SNAPSHOT Oct 27, 2019 2:47:45 AM 4.0.0 +
Plugin User Status Plugin
README Changelog Download 1.2.2-SNAPSHOT Oct 27, 2019 2:25:29 AM 4.0.0 +
Plugin User Status Plugin
README Changelog Download 1.2.2-SNAPSHOT Oct 27, 2019 2:11:51 AM 4.0.0 +
Plugin User Status Plugin
README Changelog Download 1.2.1-SNAPSHOT Jun 1, 2019 11:44:07 AM 4.0.0 +
Plugin User Status Plugin
README Changelog Download 1.2.1-SNAPSHOT May 31, 2019 2:27:17 PM 4.0.0 +