powered by Jive Software

Logging all Conversations to MySql

I have successfully integrated OpenFire 3.6.4 to MySql. When testing the conversation logging, I found only the MUC in the tables, not group conversations or ono-on-ono chats. I need to persist all of them…How?

you need to install the monitoring plugin. it will log all conversations.

The monitor plugin abends Openfire with message:

Aug 28, 2009 11:54:36 AM com.javamonitor.JavaMonitorCollector$CollectorDriver run
SEVERE: This probe was hit by an unexpected exception: Server returned HTTP response code: 401 for URL:
java.io.IOException: Server returned HTTP response code: 401 for URL:
at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
at com.javamonitor.Collector.push(Collector.java:284)
at com.javamonitor.Collector.push(Collector.java:100)
at com.javamonitor.JavaMonitorCollector$CollectorDriver.run(JavaMonitorCollector.j ava:134)
at java.lang.Thread.run(Unknown Source)

Also, found no instructions for reviewing the statistics in this configuration.


Does the monitoring plugin come with a local reporting tool (within our firewall)? If so, I can use it. If the data is going to a public site outside our firewall, I cannot use it…against corporate policy. I think that’s why the tool abends Openfire upon start.

All I really wanted is to log conversations on Spark over Openfire into the attached MySQL database. Oh well.

the monitoring plugin stores everything to the local openfire database.

I’m confused… Are we speaking of the monitoring tool from Java-monitor.com?

I am on their forum, speaking with Kees Jan. He said:

Also, Java-monitor does not log conversations in any way. It just counts packets. It would not have given you what you are looking for anyway.

If this is the tool you are thinkin of, the question remains: How do I capture all conversations into the Openfire-attached MySql database using Spark?

I’m confused… Are we speaking of the monitoring tool from Java-monitor.com?

No, I think Todd means the Monitoring Plugin from http://www.igniterealtime.org/projects/openfire/plugins.jsp.

Oh…my bad…

Got it, installed it, it’s working…Thanks to all for your advise and patience!