<< Why the C preprocessor is a bad thing | Home | Using Maven with IntelliJ IDEA 7.0 >>

Open Archive 1.0.1 for Openfire 3.3.2 released

A XEP-0136 compliant Message Archive

Open Archive is a XEP-0136 compliant server side message archive for Openfire. It is available as a plugin from here.

Currently it supports automated message archiving and message retrieval through XEP-0136 compliant Jabber clients and a web UI for the administrator. Support for manual archiving and preferences is planned for future releases.

Version 1.0.1 requires either MySQL or the embedded HSQLDB, support for other databases might be added at a later point.

To install the plugin just rename the jar to archive.jar, place it into the plugins folder of your Openfire server and enable it in the Openfire console at Server Settings/Archive Settings.

For those interested in the source code have a look at its development site.

Update June 27, 2007:

Now we also have some screenshots available:

Archive Settings
Archive Settings

Search Archive (Web UI)
Search Archive (Web UI)



Re: Open Archive 1.0.1 for Openfire 3.3.2 released

Thank you! This is the final 'piece of the puzzle' i need to make my mobile XMPP client working. Hoping that you will contiune to perfecting the plugin... ;-)

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

Yes, there are already some enhancements in the pipeline, so stay tuned :-)
Btw. do you already have a mobile XMPP client that supports XEP-0136?

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

i want open archive 1.0.1 pl zsend me on mail link or file.

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

Running Openfire 3.3.2 and Archive 1.0.3. It works! But on my Archives Settings and Archive Search windows i get text like this:

???archive.settings.basic.title???
  ???archive.settings.basic.disabled??? 
  ???archive.settings.basic.enabled??? 
  ???archive.settings.basic.conversationTimeout??? 
  ???archive.settings.rebuildIndex.intro??? ???archive.settings.rebuildIndex??? 

I also had the ??? in front of the Links on the far LH side of the admin panel as well. I edited the plugin.xml file to correct those. But I cannot figure out how to correct it in the actual screens. If i look at your screenshots above, i can tell where to type what in the search boxes, and it will actually search and log correctly.

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

It seems you deployed the plugin with the wrong name. The jar file must be renamed to archive.jar (without the version in the filename) before deploying it to Openfire.

How do I reinstall?

Couple things I've found:

1. If I delete the plugin, my whole main page in Openfire pukes out an error saying it can't find open archive.  I have to copy the archive.jar file back into the plugins directory to get things back to normal.

2. Trying to manually delete a conversation from the database didn't seem to REALLY delete the convo.  As a result I decided to start over by deleting the archive* tables.

3. After running "archive_mysql.sql" and recreating the tables, etc... I still can't seem to make it work.

I would just like to be able to reinstall the open archive plugin from scratch and have it log to the database again.  How can I do this?

How do I reinstall?

To completely reinstall open archive you must shutdown openfire, remove all archive table and in addition remove the archive entry from jiveVersion:
DELETE FROM jiveVersion WHERE name = 'archive'
Then start openfire and open archive should recreate its table and work again.

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

::slap himself:: After i made the post i read the instructions.....again. That time i saw that i had to rename the plugin to archive.jar. Works like a charm now. Thanks a million. Now...if we can only get it to log muc chats.

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

Well that's already on the agenda but my spare time is a bit reduced right now due to customer projects...

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

Take your time my friend. Good things come to those that wait. I have tried several other logging programs and yours is the best. Good job and good luck. I would help you but.....well okay so i can't program. But i can appreciate a programmer.....so Thanks!

 

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

How i convert the archiveConverstation  ---  startTime  ,  endTime   for date or time in php or mysql  ?????

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

The time is in milliseconds since the epoch (Jan 1, 1970) so you just divide it by 1000 and use the same functions to convert a UNIX timestamp.
Hope that helps,
Stefan

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

I have trouble getting the keywords search to work. What exactly is searched when a keyword is entered?

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

The whole text of the conversation is searched. You must make sure the openfire OS user is able to write to the openfire home directory for this to work.
Try to rebuild the index and see if that helps.

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

I am from Russia, and I have a problem with codepage. We use cp1251, but in message all I see is "??? ? ???????" that's all. How can I change charset?!

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

I am from Russia, and I have a problem with codepage. We use cp1251, but in message all I see is "??? ? ???????" that's all. How can I change charset?!

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

Do you use MySQL or the embedded DB with Open Archive?

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

yes

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

cp1251 - this for IM gateway to ICQ. Sorry for triple repeat :)

Complaince Questions

I have two general questions / requests.  My company has a specific need that is records management based.  We are interested in OpenFire/Open Archive and your tool looks like it will meet most of ours needs except for the following.

1. we need to apply a retention to the data that is stored in the archive database.  basically delete all entries after 180 days. Does OpenArchive have a way to trim the database on a regular basis?

2. we would like to automatically export a copy of each thread in a text file for loading into our general purpose archive for a longer retention like 2 years.  Can OpenArchive write out threads to a file on a regular basis that I can then use to import into another archive?

 

Complaince Questions

Hi Tom,

Open Archive does not support these compliance requirements. You might want to have a look at the Enterprise Edition of Openfire which is sold by Jive Software. The Enterprise Edition includes an archive with a focus on compliance.

=Stefan

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

> Do you use MySQL or the embedded DB with Open Archive? Yes

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

Hello Stefan

I was trying the plugin and it is excellent, but I need to delete the old messages.

How I can do it?

Thanks for your help

Luis

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

Hi Luis,
currently Open Archive does not support deleting messages. You could manually remove them at the database level and rebuild the index after that as a work around.
Alternativly Open Archive will support deleting conversations through XMPP clients (i.e. by extending support for XEP-0136) but there is no fixed date for that.
Hope that helps,
Stefan

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

I'm using Open Archive 1.0.3 with Openfire 3.3.2 and for some reason I cannot do a search on users. Any time I type something in the keywords or participants fields I get a popup containing "Error". Has anyone see that before?

Also, how does one do an upgrade to 1.0.4? Do I just pop the jar file and let it do it's business?

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

Yes, to upgrade just download 1.0.4, rename it to archive.jar and upload it through the web UI (use Openfire 3.4.1 for this). The upgrade process runs automatically.
Regarding the error popup reindex the lucene index on the settings page and try again. If the problem persists look at the logs for any exceptions/error messages that appear there.

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

Is there a way to make Open Archive to work against MSSQL Server?

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

Yes, all you have to do is to update the sql file shipped with Open Archive and manually create the database schema.

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

Hi Stefan!

First of all thanks a LOT for this plugin. It is absolutely great.

My concern is about security.

I'm using it for our corporate IM and taking in count the security issue of accessing all the conversation throught this, I would like just me to be able to access the Archive Search.

Is there any simple way of to remove the item from the menu and may be access it throught a shortcut?

Thanks

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

The "search archive" tab is only available to the admins of an Openfire server. So if you are the only admin you are the only person with access to it.

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

Stefan,
  Where can I change the location of the database that open archive uses?  I found a working mssql scriplet to create the necessary tables for it, just don't see where to change what database/server open archive points to. Thanks!

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

Open Archive uses the database you've configured for Openfire.
Do you need a separate database for your conversations?

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

Preferably yes.  Otherwise, if I run the .sql against the existing mssql openfire DB will it auto-magically start logging into the mssql db?

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

Yes, as soon as the SQL script has been applied and logging has been enabled in the settings on the Openfire admin console it will start logging.

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

It works!  THanks!

Any plans for update?

Hi Stefan,
Are there any plans to update your plugin? I'm implementing client-side support for XEP-136 (see my site), so it will be nice to have a working server-side software for it. :)

Any plans for update?

Is that an "official" Psi effort? Is it realted to Synapse-IM?

Any plans for update?

Quite "official" (http://blog.xmpp.org/?p=38)
and not related to Synapse-IM.

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

Hi Stefan

I'm having problem with the search archive feature, when trying to use the from/to conversation (I have OpenFire using LDAP) I can never find the users, and the magnifier icon does nothing when clicking on it.

Suggestions?

Thanks!

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

Does it work if you enter the full Jabber address, i.e. user@host.tld ?

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

Anyway to get this to archive the group chats?

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

Did you have a look at the enterprise archive plugin which is now open source? It supports group chat archiving.
I am not sure about the future of Open Archive. If there is growing interest in the XEP-0136 features and support by clients I may expand the features otherwise the former enterprise archive plugin by Igniterealtime is a better choice.

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

Stefan, I really want to see XEP-136 fully supported by OA and Psi. Let's work together. :)

Re: Open Archive 1.0.1 for Openfire 3.3.2 released

Hey Alek,
That would be really cool and reminds me that I must have a look at the results of your SoC project ;)
If you like drop me a mail so we can prioritize the features and I have a way to check if my view of the spec is correct.

=Stefan

Add a comment Send a TrackBack