New Monitoring Plugin for Openfire

Dele_Olajide · December 2, 2012, 6:22pm

The folks at Globility have been very kind to release back to the Ignite Realtime community their improvements to the Openfire monitoring plugin.

They have merged the monitoring plugin with the open archive plugin by@ Stefan Reuter and have sucessfully combined chat and group chat archiving (from monitoring) as well as XEP-0136 Message Archiving support (from open archive) removing all redundant and duplicated code. The monitoring graphing and statistics pages work just fine as before.

A change to the database schema of the Monitoring plugin was made to support the XEP-0136 spec and auto-upgrade DB scripts have been provided to handle the database upgrade for all the supported DBs as best as possible.

Source:

http://svn.igniterealtime.org/svn/repos/openfire/trunk/src/plugins/monitoring/

Latest build (1.3.0) of the plugin is attached. Any bugs please file in JIRA against leonroy

I have tested it against the latest version of OfChat (Chrome extension) web client as a drop-in replacement to the open archive plugin for chat history and it works ok.

For more details, see http://community.igniterealtime.org/message/225654

wroot · December 2, 2012, 7:41pm

Good news. I hope this plugin’s bugs have been fixed in the process, or at least we have whom to send the reports to I always had doubts suggesting this plugin to users as it have stopped working for me few times with no reason and there were more reports in the forums.

Dele_Olajide · December 2, 2012, 8:39pm

Hopefully, those bugs may have been removed with the code cleanup.

In any case, Leon has taken responsibility for the plugin and has asked for all bugs to be filed in JIRA against his name

Gary_Simpson · December 10, 2012, 2:10pm

Just a FYI -

Since installing the new monitoring plugin, when archving Group Conversations the participants name in the chat body comes up as “null”

For example:

(8:01 PM) null: test

(8:01 PM) null: test2

Mr_Wizard · December 10, 2012, 9:26pm

Will this work with a mssql db backend?

Walter_Ebeling · December 19, 2012, 6:47pm

My system is much more stable than before after putting the new plugin on it. So some bugs are gone…

Dele_Olajide · December 20, 2012, 1:30pm

It does. You just have to switch it on. By default, archiving is off

Dele_Olajide · December 20, 2012, 1:32pm

Hi Walter, I am sure Leon will be pleased to hear that. They did a great job on that plugin

jcorreia · December 24, 2012, 11:53am

thanks !

lioncub · January 3, 2013, 9:38am

Doesen’t work! No new messages in Server -> Archiving

Settings:

Archive one-to-one chats - enable
Archive group chats - enable

lioncub · January 4, 2013, 5:11am

I use release 3.7.1.

stevenson_lee · January 11, 2013, 10:17am

Hi,

Is this jar already useable for a clustered setup? I tried it and the monitoring tabs don’t appear. I’m not sure if it is an issue with my setup or not.

Please advice,

Best Regards,

Stevenson Lee

Leon_Roy · January 25, 2013, 5:07pm

Glad to hear the new plugin’s working better for you all.

TBH the monitoring plugin has always had issues displaying some of the tabs, even with Openfire 3.6.4. I’m not sure why, but at a basic level we’re focusing on getting the core, auto chat archiving and xep-0136 support to be bullet proof.

Please file any bugs in JIRA though and we’ll try to fix them ASAP.

In the meanwhile we’ll take a look at the below as a high priority:

Since installing the new monitoring plugin, when archving Group Conversations the participants name in the chat body comes up as “null”

For example:

(8:01 PM) null: test

(8:01 PM) null: test2

Dele_Olajide · February 1, 2013, 4:15pm

Leon,

Thanks for fixing this and updating the changelog as requested.

Leon_Roy · February 15, 2013, 11:28am

Hi all, known issue that 1.3.0 did not save messages properly. Please see the following topic for 1.3.1 which resolves the issue (it is Openfire 3.8 only though):

jacky1 · February 21, 2013, 8:07am

I think this is because ofMessageArchive table is redesigned, separating resource from JID. The label on jsp page displays resource which the plugin should get from toJIDResource instead of toJID.

jacky1 · February 21, 2013, 8:30am

my workaround:

modify the Conversation.java file, two places:

around line 98:

// Jacky Jia 2013.02.21

// the way to minimize the impact but still to have the resource in toJID.

// private static final String LOAD_MESSAGES =

// "SELECT fromJID, toJID, sentDate, body FROM ofMessageArchive WHERE conversationID=? " +

// “ORDER BY sentDate”;

private static final String LOAD_MESSAGES =

"SELECT fromJID, toJID, sentDate, body, toJIDResource FROM ofMessageArchive WHERE conversationID=? " +

“ORDER BY sentDate”;

// -----

around line 327:

// Jacky Jia 2013.02.21

// the way to minimize the impact but still to have the resource in toJID.

// JID toJID = new JID(rs.getString(2));

JID toJID = new JID(rs.getString(2) + ‘/’ + rs.getString(5));

// -----

I think it will minimize the impact if there’s any. However, haven’t tested it fully.