Community Plugins : Open Archive: Server side message archive with support for XEP-0136. : Comments

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Sat, 22 Sep 2007 02:26:20 GMT

Does this log Conference rooms too,

I briefly enabled this but it started throwing a bunch of errors. Are there any known issues or conflicts. I also tried re-indexing the archive and that gave errors.

I am using the latest Openfire and mySQL

just curious

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Sat, 22 Sep 2007 03:05:35 GMT

Please disregard. I just reinstalled and it is working. Not sure what happened there

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Tue, 23 Oct 2007 13:40:28 GMT

Where can I get the source?

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Tue, 23 Oct 2007 13:59:43 GMT

Oops, i get it...

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Wed, 24 Oct 2007 00:02:00 GMT

To make it a bit easier for the next one looking for the source, here is the link to the subversion repo:

http://svn.reucon.net/repos/openfire/plugins/archive/

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Sat, 27 Oct 2007 10:22:22 GMT

This sounds like a great plugin. I am looking forward to the time when it has Oracle database support! ,

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Sat, 27 Oct 2007 10:24:31 GMT

I currently don't have an Oracle instance to play with but if you translate the MySQL DDL script to Oracle it will probably work fine.

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Mon, 12 Nov 2007 18:55:02 GMT

so if I convert that mysql script to ms sql... will the plugin then work with ms sql?

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Mon, 12 Nov 2007 21:23:31 GMT

Yes that should work. Please report back if it worked and post the script so I can include it, too.

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Tue, 13 Nov 2007 21:24:10 GMT

i seem to get duplicates of all conversations... like it takes the sending as a message and then the receiving as a message... so all conversations are in there twice... otherwise it seems to be working fine.

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Fri, 04 Jan 2008 18:39:26 GMT

Can you post the Mod that you did? I too am looking to use this with MS SQL

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Wed, 09 Jan 2008 04:12:01 GMT

The MySQL DDL script only contains the code to create the tables needed. Where is the search query code? Wouldn't that need to be modified as well?

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Wed, 09 Jan 2008 06:45:42 GMT

Generally the queries are the same across all databases, they are hardcoded into the application.

You can have a look at them here.

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Wed, 09 Jan 2008 14:55:21 GMT

Thanks for the quick reply. So all we need to do is modify the archive_mysql.sql and call it archive_sqlserver.sql ? If so, I will post the mod her so others can use it if needed.

Will it automatically know to use archive_sqlserver.sql if we have set OpenFire up to use MS SQL Server?

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Wed, 09 Jan 2008 17:08:07 GMT

yes that's all you have to do. Openfire automatically pics up the correct sql file for your database product.

If you post it here I will also include it in the official distribtion so it will be part of the next release

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Thu, 17 Jan 2008 13:36:03 GMT

Hi jeffk..

I'm using the same environment (Openfire + MSSQL Server).. Did you get OpenArchive working against SQL Server?

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Thu, 17 Jan 2008 14:05:03 GMT

I got it working with MSSQL... here is the script I used... not sure if it is all right but it seems to work fine

CREATE TABLE archiveConversations (

conversationId BIGINT NOT NULL,

startTime BIGINT NOT NULL,

endTime BIGINT NOT NULL,

ownerJid VARCHAR(255) NOT NULL,

ownerResource VARCHAR(255),

withJid VARCHAR(255) NOT NULL,

withResource VARCHAR(255),

subject VARCHAR(255),

thread VARCHAR(255),

PRIMARY KEY (conversationId)

);

CREATE INDEX idx_archiveConversations_startTime ON archiveConversations (startTime);

CREATE INDEX idx_archiveConversations_endTime ON archiveConversations (endTime);

CREATE INDEX idx_archiveConversations_ownerJid ON archiveConversations (ownerJid);

CREATE INDEX idx_archiveConversations_withJid ON archiveConversations (withJid);

CREATE TABLE archiveParticipants (

participantId BIGINT NOT NULL,

startTime BIGINT NOT NULL,

endTime BIGINT,

jid VARCHAR(255) NOT NULL,

nick VARCHAR(255),

conversationId BIGINT NOT NULL,

PRIMARY KEY (participantId)

);

CREATE INDEX idx_archiveParticipants_conversationId ON archiveParticipants(conversationId);

CREATE INDEX idx_archiveParticipants_jid ON archiveParticipants(jid);

CREATE TABLE archiveMessages (

messageId BIGINT NOT NULL,

time BIGINT NOT NULL,

direction CHAR(4) NOT NULL,

type CHAR(15) NOT NULL,

subject VARCHAR(255),

body TEXT,

conversationId BIGINT NOT NULL,

PRIMARY KEY (messageId)

);

CREATE INDEX idx_archiveMessages_conversationId ON archiveMessages (conversationId);

CREATE INDEX idx_archiveMessages_time ON archiveMessages (time);

CREATE TABLE archivePrefItems (

username VARCHAR(64) NOT NULL,

jid VARCHAR(255),

saveMode INTEGER,

otrMode INTEGER,

expireTime BIGINT,

PRIMARY KEY (username,jid)

);

CREATE TABLE archivePrefMethods (

username VARCHAR(64) NOT NULL,

methodType VARCHAR(255) NOT NULL,

methodUsage INTEGER,

PRIMARY KEY (username,methodType)

);

INSERT INTO jive.jiveVersion (name, version) VALUES ('archive', 2);

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Thu, 17 Jan 2008 14:11:43 GMT

We changed our plan and stayed with the current setup of MySQL. I will check with our database guy and see if he has time to submit a MSSQL MOD. I will post it here when and if I get it. It will be untested, but should be a good start.

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Thu, 17 Jan 2008 14:20:46 GMT

Thanks for your contribution, I've added your script to SVN so it will be part of 1.0.5.

=Stefan

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Fri, 18 Jan 2008 18:29:11 GMT

Do any clients support XEP-0136 yet? Also, do you plan on providing an administrative interface to set/manage the negotiation of OTR modes between the server and clients?

Thanks,

-B

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Fri, 18 Jan 2008 18:57:27 GMT

Open Archive is an attempt to overcome the hen and egg problem of missing client/server support for XEP-0136. Up to now I am not aware of a client supporting the XEP.

Currently there are now plans to expand the features of Open Archive though that might change as soon as there is more interest.

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Tue, 22 Jan 2008 20:45:39 GMT

I'm receiving "???login.title???" on title page.

Only this message have problem.

I have already renamed the plugin file to archive.jar.

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Tue, 22 Jan 2008 21:07:05 GMT

That's a known issue but without functional implication

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Thu, 24 Jan 2008 14:32:35 GMT

thanx for your the plugin!

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Thu, 24 Jan 2008 14:59:49 GMT

*sorry for the typo

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Thu, 31 Jan 2008 10:38:12 GMT

"Open Archive is an attempt to overcome the hen and egg problem of missing client/server support for XEP-0136. Up to now I am not aware of a client supporting the XEP".

Thank you very much for this plugin. It is a very great XMPP enhancement.

Since few days, Synapse-IM, a (very cool) fork of Psi, supports Message Archiving in the SVN repository.

"Currently there are now plans to expand the features of Open Archive though that might change as soon as there is more interest."

I, for one, would be very interested into archiving PubSub ATOM messages like the ones published @ xmpp:pubsub.ik.nu. I'm thinking to a mailbox-like GUI in which PubSub messages would be stored to avoid losing notifications and perhaps for an offline/disconnected mode.

Cheers.

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Thu, 31 Jan 2008 20:57:48 GMT

Cool that looks promising. Did you already have a chance to test it wit Open Archive?

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Thu, 31 Jan 2008 21:48:15 GMT

Yes, I'm currently using it with Openfire 3.4.4 and Archive 1.0.4 and it works well, except sometimes where it seems buggy but no sure (actually, it displays that some messages exist but they're not seen then).

Yeah, that really looks promising.

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Fri, 01 Feb 2008 02:58:15 GMT

Tried to compile an run it from svn trunk on Ubuntu 7.10 64bit but it dumped core as soon as I tried to add a new account. Are there binary snapshots somewhere?

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Sat, 02 Feb 2008 14:16:42 GMT

Hey jstreit12,

Thank you to share this MOD... It works like a charm..

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Sat, 02 Feb 2008 18:31:40 GMT

Unfortunately, there's no recent binary snapshots .

I'm running SVNed Synapse-IM on Ubuntu Gusty and it works normally (except some dev bugs).

Odd it crashes on 64bit PC.

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Sun, 03 Feb 2008 11:30:10 GMT

You may want to try rev 226, now.

The next release will probably be available in one week, and there might be a binary snapshot for 64bits PC.

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Sun, 03 Feb 2008 12:12:28 GMT

Hi, I'm developer of Synapse-IM. I've just tested my client on Ubuntu 7.10 64 bit without any problems (except I needed to get to know how to install any thing under Ubuntu). After that I compiled and launched Synapse-IM. It created account without problem.

But I knew where is "bug". You did not launched

sudo make install

and QCA 2.0 library cannot find plugins.

If you will have any problems with Synapse-IM let me know

xmpp://andrzej@xmpp.hi-low.eu

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Mon, 04 Feb 2008 04:50:13 GMT

Yes it turned out it was the missing "make install".

Works quite well now and really cool to finally see a first client in the wild

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Tue, 05 Feb 2008 21:05:25 GMT

I'd have several questions :

1. Is there a way to export archives ? I'd like to reinstall my system and save the archives file (currently using the embedded DB). This would a great feature to enhance the plugin.

2. When querying an disco#info, the XEP-0136 namespace doesn't appear in the result. Am I missing something ?

3. Regarding message archiving per se, apparently only "raw" and XHTML-IM messages are saved ; Pubsub messages aren't. I was wondering if Pubsub messages could be archived too.

For example, when subscribing to <xmpp:pubsub.ik.nu;?node=mimir/news/slashdot> with :

The pubsub server then sends XMPP messages which contain several ATOM items per message and look like this :

So I'm wondering if it'd be possible to save these messages using XEP-0136, with separated messages per entry.

Actually, it looks like the combination of Pubsub, ATOM notifications over XMPP and message archiving could be used to build an

XMPP ATOM aggregator

(with offline capability amongst other features).

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Tue, 05 Feb 2008 23:53:37 GMT

ad 1: Currently there is no such feature but you can export the tables at the db level and reimport into the new database. Then you can rebuild the index and everything should be fine again.

ad 2: There is a feature element when the connection is established. Does the XEP also require a disco item?

If it is and Open Archive is still missing it, just open a bug at http://jira.reucon.org/browse/OA

ad 3: In general this is possible, its just interesting how we could map this to the concept of a conversation and how (if) we would display that in the conversation browser on the UI. If you'ld like to add more information feel free to open a feature request on jira.

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Mon, 03 Mar 2008 14:51:26 GMT

Love the plugin! but I am having a few problems. I am receiving an 'error' when entering a search field and clicking the rebuild index button. Conversations are split and the header for the main page has "Openfire ???login.title???. I think it may have something to do with the version of openfire. I put the latest version on (3.4.5) and then found this plugin to play with so Im not sure if it would work better on an earlier version. Any ideas?

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Wed, 04 Feb 2009 19:13:05 GMT

I hate to throw my hat in the ring with a "me, too", but, well.. Me, too. I can't get the openfire web admin interface to search on the archives and if I begin to type names in, I get a javascript pop-up with "Error".

I had this plugin working with an older version of Openfire, but it seems to have broken under Openfire 3.6.3. I downloaded and installed openarchive 1.0.5, and immediately had the same problem that others were having "??title??" & etc.

Just for the record, to fix that issue:

o Rename your download of open archive from "archive-1.0.5.jar" to "archive.jar"

o Upload the jar file

The problem comes up when you attempt to upload the jar file with the version number attached to it.

However, I am still left with the inability to search via the openfire admin interface.

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Thu, 12 Mar 2009 16:02:04 GMT

install and start ver. 1.0.5

search messages in base - all work

try to use from "jabber archive web reader" - http://bepointbe.be/jabwebhist/index.php (port 5222 open to internet)

succsesful login (Connection established) , try "Config"\"Browse" -

The server has returned one error. Maybe the server doesn't support archiving

<service-unavailable/>

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Thu, 18 Feb 2010 12:40:59 GMT

Has anyone created a oracle sql script yet?

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Thu, 08 Jul 2010 20:12:24 GMT

Hi, Could you please tell me how scalable this plugin will be?.If i have around 20000 connections to my XMPP server, ll this plugin could store all the messages?

RE: Open Archive: Server side message archive with support for XEP-0136.

communityadmin@igniterealtime.org — Thu, 01 Dec 2011 11:18:35 GMT

Hi,

Can any one tell me how can we implement XEP-0136 at client hand.

In simple way any one can post the code for "XEP-0136 compliant Jabber clients" implementation.

Thanks,

Sumeet Guha.