This Question is Answered

1 "correct" answer available (10 pts) 1 "helpful" answer available (5 pts)
31 Replies Last post: May 12, 2008 1:38 PM by Todd Getz  
Todd Getz KeyContributor 2,181 posts since
Apr 2, 2007
Currently Being Moderated

Jan 22, 2008 8:10 AM

Open Archive + Openfire on Windows = non-threaded logs

When I view the logs in Open Archive the messages are disjointed. I only see half of the conversation at a time. See the attached images for examples and config.

Attachments:
karride Bronze 3 posts since
Jan 23, 2008
Currently Being Moderated
Jan 23, 2008 9:44 AM in response to: Todd Getz
Re: Open Archive + Openfire on Windows = non-threaded logs

 

I've got the same thing on a Linux server (Fedora 7).

 

 

Strange thing is some conversations are threaded like they are supposed to be, and others are not.

 

 

Tim Davis Bronze 34 posts since
Feb 1, 2008
Currently Being Moderated
Feb 8, 2008 12:03 PM in response to: Todd Getz
Re: Open Archive + Openfire on Windows = non-threaded logs

I have the same issue as well...it seems to log the first conversation of the day just fine, but then the rest are seperated by the user name and not conversation. And when I try to rebuild the index it fails....every time.

Huffmaster Bronze 4 posts since
Feb 11, 2008
Currently Being Moderated
Feb 11, 2008 5:31 AM in response to: Todd Getz
Re: Open Archive + Openfire on Windows = non-threaded logs

 

Same thing here on MSSQL.

 

 

When SELECTing the conersation elements to be displayed from the archive when searching, it looks like the program SELECTs them by CONVERSATIONID which changes depending on the direction of the conversation. Therefore only half of the conversation is visible. If the CONVERSATIONID remained the same for the conversation then this wouldn't be a problem.

 

 

I have manually changed the values in the SQL db to reflect what should be happening i.e. the CONVERSATIONID remaining the same, and it all works splendidly.

 

 

Can anyone see in the code why the program changes the CONVERSTIONID even for the same converation?

 

 

Stefan Reuter KeyContributor 287 posts since
Aug 3, 2005
Currently Being Moderated
Feb 17, 2008 9:02 PM in response to: Huffmaster
Re: Open Archive + Openfire on Windows = non-threaded logs

Are there any simple steps to reproduce this issue?

karride Bronze 3 posts since
Jan 23, 2008
Currently Being Moderated
Feb 18, 2008 8:49 AM in response to: Todd Getz
Re: Open Archive + Openfire on Windows = non-threaded logs

 

Here is my openfire config if it helps any.

 

 

Attachments:
Huffmaster Bronze 4 posts since
Feb 11, 2008
Currently Being Moderated
Feb 18, 2008 9:13 AM in response to: Todd Getz
Re: Open Archive + Openfire on Windows = non-threaded logs

 

Agree that it is easily replicated.

 

 

 

 

What do we do to get the developers attention?

 

 

 

 

I looked at this product, but due to the archive issue, have moved onto SoapBox which seems to work out of the box. I do prefer Openfire, but without proper archiving cannot even consider deploying it.

 

 

 

 

Stefan Reuter KeyContributor 287 posts since
Aug 3, 2005
Currently Being Moderated
Feb 18, 2008 10:02 PM in response to: Huffmaster
Re: Open Archive + Openfire on Windows = non-threaded logs

I do understand that this issue really bugs you and that it's easy for you to reproduce.

Having just checked my conversations of the last week revealed no single case of the problem though. I've chatted with local users, with remote xmpp user and with users on ICQ - in each case it just works

 

You certainly have my attention but without being able to reproduce the issue it's hard to solve it.

 

=Stefan

Huffmaster Bronze 4 posts since
Feb 11, 2008
Currently Being Moderated
Feb 19, 2008 7:50 AM in response to: Todd Getz
Re: Open Archive + Openfire on Windows = non-threaded logs

Hi mtstravel - yes we are using active directory, does this make a difference?

karride Bronze 3 posts since
Jan 23, 2008
Currently Being Moderated
Feb 19, 2008 8:21 AM in response to: Todd Getz
Re: Open Archive + Openfire on Windows = non-threaded logs

 

Active Directory based LDAP here as well.

 

 

Stefan Reuter KeyContributor 287 posts since
Aug 3, 2005
Currently Being Moderated
Feb 19, 2008 4:07 PM in response to: Todd Getz
Re: Open Archive + Openfire on Windows = non-threaded logs

I am running with OpenLDAP

Huffmaster Bronze 4 posts since
Feb 11, 2008
Currently Being Moderated
Feb 19, 2008 7:49 AM in response to: Stefan Reuter
Re: Open Archive + Openfire on Windows = non-threaded logs

Hi Stefan - aren't these other guys in this thread having the same problem as me? 

Stefan Reuter KeyContributor 287 posts since
Aug 3, 2005
Currently Being Moderated
Feb 19, 2008 4:08 PM in response to: Huffmaster
Re: Open Archive + Openfire on Windows = non-threaded logs

Yes I think so - maybe I am the only one where it actually works

Tim Davis Bronze 34 posts since
Feb 1, 2008
Currently Being Moderated
Feb 19, 2008 5:39 PM in response to: Stefan Reuter
Re: Open Archive + Openfire on Windows = non-threaded logs

Mine will work from time to time, but not for every conversation. With mine it almost seems like when someone closes the chat window it won't string the conversation, but from what my IT guys are telling me, they keep the conversation open. I checked the logs for the past week and it seems to be half and half, so I can't point it at one thing.

 

SRT did you elect to use OpenFire's integrated sql db or using an external?

For mine, I chose to use the default intergrated db and not sure if this has anything to do with it.

Stefan Reuter KeyContributor 287 posts since
Aug 3, 2005
Currently Being Moderated
Feb 26, 2008 9:54 AM in response to: Todd Getz
Re: Open Archive + Openfire on Windows = non-threaded logs

Openfire 3.4.5

Ubuntu 7.10 amd64

Sun JDK 6u04

MySQL 5.0.45

Users are in LDAP (OpenLDAP 2.3.35)

 

Plugin Settings (only archive.enabled is set):

  archive.enabled = true

 

settings.xml:

 


<?xml version="1.0" encoding="UTF-8"?>

<jive>
  <adminConsole>
    <port>9090</port>
    <securePort>9099</securePort>
  </adminConsole>
  <admin>
    <authorizedUsernames>xxx,yyy</authorizedUsernames>
    <!-- Comma-delimitted list of bare JIDs. The JIDs may belong to local
         or remote users. -->
    <!-- <authorizedJIDs></authorizedJIDs> -->
  </admin>
  <locale>en</locale>
  <!-- Network settings. By default, Wildfire will bind to all network interfaces.
      Alternatively, you can specify a specific network interfaces that the server
      will listen on. For example, 127.0.0.1. This setting is generally only useful
       on multi-homed servers. -->
  <network>
    <interface>10.xxx</interface>
  </network>
  <ldap>
    <host>127.0.0.1</host>
    <port>389</port>
    <usernameField>jidUid</usernameField>
    <nameField>cn</nameField>
    <emailField>mail</emailField>
    <baseDN>xxx</baseDN>
    <adminDN>uid=openfire,ou=xxx</adminDN>
    <adminPassword>xxx</adminPassword>
  </ldap>
  <provider>
    <user>
      <className>org.jivesoftware.openfire.ldap.LdapUserProvider</className>
    </user>
    <auth>
      <className>org.jivesoftware.openfire.ldap.LdapAuthProvider</className>
    </auth>
  </provider>
  <connectionProvider>
    <className>org.jivesoftware.database.DefaultConnectionProvider</className>
  </connectionProvider>
  <database>
    <defaultProvider>
      <driver>com.mysql.jdbc.Driver</driver>
      <serverURL>jdbc:mysql://localhost:3306/openfire?autoReconnect=true&amp;useUnico de=true&amp;characterEncoding=utf8</serverURL>
      <username>openfire</username>
      <password>xxx</password>
      <minConnections>5</minConnections>
      <maxConnections>15</maxConnections>
      <connectionTimeout>1.0</connectionTimeout>
    </defaultProvider>
  </database>
  <setup>true</setup>
  <log>
    <debug>
      <enabled>true</enabled>
    </debug>
  </log>
</jive>

 

Attachments: