Return to Jive Software

Skip navigation
Up to Discussions in Support
6,168 Views 28 Replies Last post: Oct 2, 2008 8:16 AM by todd.west RSS
jehandy Novice
jehandy
31 posts since
Feb 12, 2008
Currently Being Moderated

Sep 12, 2008 8:26 AM

OpenFire shows Clearspace error when trying to browse groups

We have had Clearspace and OpenFire running just fine together for a few months.  Yesterday updated OpenFire to the 3.6.0 version and now we can't see any groups or contacts in the Spark client.  I tried reverting to the previous version of OF and restoring the CS database to a prior time and we're still no good.  I am at a loss.

 

Although I can use the OF console to veiw all of the users, I get an error when trying to view the group information.  Looks like this:

 

HTTP ERROR: 500

Unexpected error

RequestURI=/group-summary.jsp

Caused by:

java.lang.UnsupportedOperationException: Unexpected error
     at org.jivesoftware.openfire.clearspace.ClearspaceGroupProvider.getGroupCount(ClearspaceGroupProvider.java:67)
     at org.jivesoftware.openfire.group.GroupManager.getGroupCount(GroupManager.java:338)
     at org.jivesoftware.openfire.admin.group_002dsummary_jsp._jspService(group_002dsummary_jsp.java:79)
     at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
     at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
     at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093)
     at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)
     at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)
     at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
     at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:66)
     at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
     at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:42)
     at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
     at org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:70)
     at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
     at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:99)
     at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
     at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
     at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
     at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
     at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726)
     at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
     at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:206)
     at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
     at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
     at org.mortbay.jetty.Server.handle(Server.java:324)
     at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
     at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:829)
     at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:514)
     at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
     at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
     at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
     at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:488)
Caused by: org.jivesoftware.openfire.clearspace.ConnectionException: Web service not found in Clearspace.
     at org.jivesoftware.openfire.clearspace.ClearspaceManager.executeRequest(ClearspaceManager.java:889)
     at org.jivesoftware.openfire.clearspace.ClearspaceManager.executeRequest(ClearspaceManager.java:810)
     at org.jivesoftware.openfire.clearspace.ClearspaceGroupProvider.getGroupCount(ClearspaceGroupProvider.java:63)
     ... 33 more

Caused by:

org.jivesoftware.openfire.clearspace.ConnectionException: Web service not found in Clearspace.
     at org.jivesoftware.openfire.clearspace.ClearspaceManager.executeRequest(ClearspaceManager.java:889)
     at org.jivesoftware.openfire.clearspace.ClearspaceManager.executeRequest(ClearspaceManager.java:810)
     at org.jivesoftware.openfire.clearspace.ClearspaceGroupProvider.getGroupCount(ClearspaceGroupProvider.java:63)
     at org.jivesoftware.openfire.group.GroupManager.getGroupCount(GroupManager.java:338)
     at org.jivesoftware.openfire.admin.group_002dsummary_jsp._jspService(group_002dsummary_jsp.java:79)
     at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
     at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
     at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093)
     at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)
     at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)
     at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
     at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:66)
     at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
     at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:42)
     at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
     at org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:70)
     at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
     at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:99)
     at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
     at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
     at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
     at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
     at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726)
     at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
     at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:206)
     at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
     at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
     at org.mortbay.jetty.Server.handle(Server.java:324)
     at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
     at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:829)
     at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:514)
     at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
     at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
     at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
     at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:488)

Powered by Jetty://

 

Web services ARE enabled in CS

 

 

Any ideas?

 

Clearspace 2.0.2

Openfire 3.6.0

MSSQL 2005

Tags: issue, clearspace_community, 2.0.1
jehandy Novice
jehandy
31 posts since
Feb 12, 2008
Currently Being Moderated
Sep 12, 2008 11:25 AM in response to: jehandy
Re: OpenFire shows Clearspace error when trying to browse groups

FYI:

 

I get a similar error when I try to look at the properties.  I can look at the list of users, just not an individual user's properties.

jehandy Novice
jehandy
31 posts since
Feb 12, 2008
Currently Being Moderated
Sep 12, 2008 12:17 PM in response to: jehandy
Re: OpenFire shows Clearspace error when trying to browse groups

Screenshot per request.

 

Feel dumb forgetting to mention this.  Earlier today, the Overview page was showing as connected but the Connections page was showing not connected as it is now.  Currently, however they are bow saying not connected.  I know I cut and pasted the right link and shared secret.

Attachments:
todd.west Jive Employee
todd.west
15,926 posts since
Jul 14, 2008
Currently Being Moderated
Sep 12, 2008 12:03 PM in response to: jehandy
Re: OpenFire shows Clearspace error when trying to browse groups

Hi,

 

Would you please post a screenshot of your Clearspace Admin Console -> Real-Time -> Connection tab? I was not able to replicate this issue using the same setup as you. Since the logs are saying that Webservices are disabled it probably means that it can't connect to your Clearspace instance since you said it was enabled. Thanks.

 

-Todd

jehandy Novice
jehandy
31 posts since
Feb 12, 2008
Currently Being Moderated
Sep 12, 2008 1:30 PM in response to: Todd West
Re: OpenFire shows Clearspace error when trying to browse groups

One other little detail I've noticed.  When I am in the Clearspacfe Integration section of the OpenFire console and hit the Test Connection button it tests out ok.

todd.west Jive Employee
todd.west
15,926 posts since
Jul 14, 2008
Currently Being Moderated
Sep 12, 2008 2:36 PM in response to: jehandy
Re: OpenFire shows Clearspace error when trying to browse groups

Hi,

 

So just to clarify this is what we have so far and could you please fill in/follow instructions listed below:

 

  • Clearspace Admin Console -> Real-time Tab
    • Shows as not connected
    • Create a temp shared secret and use it: 12345
    • Paste Clearspace URL: here
  • Openfire Admin Console -> Clearspace Integration
    • Shows as not connected
    • Test works fine
    • Create a temp shared secret and use it: 12345
    • Paste Clearspace URL: here]

 

 

Just want to make sure I have all the facts straight. If I can get your exact setup I will try to duplicate this. Also, would you please post your Clearspace logs from the <jiveHome>/logs/ folder as well as the Openfire logs from the <openfireHome>/logs/ folder? Thanks.

 

-Todd

jehandy Novice
jehandy
31 posts since
Feb 12, 2008
Currently Being Moderated
Sep 13, 2008 12:55 PM in response to: Todd West
Re: OpenFire shows Clearspace error when trying to browse groups
  • Clearspace Admin Console -> Real-time Tab
  • Openfire Admin Console -> Clearspace Integration
    • Attachments:
    todd.west Jive Employee
    todd.west
    15,926 posts since
    Jul 14, 2008
    Currently Being Moderated
    Sep 15, 2008 8:40 AM in response to: jehandy
    Re: OpenFire shows Clearspace error when trying to browse groups

    Hi Jack,

     

    With the settings you have given me, as well as the logs I am at a loss. From what I see, everything should be working. Would you please show me a screenshot of your webservices settings in your Clearspace instance. I tried making a simple webservices to connect to your instance but it was telling me that webservices are disabled as well. Thanks.

     

    -Todd

    jehandy Novice
    jehandy
    31 posts since
    Feb 12, 2008
    Currently Being Moderated
    Sep 15, 2008 9:26 AM in response to: Todd West
    Re: OpenFire shows Clearspace error when trying to browse groups

    Try it again.  Our firewall wouldn't have allowed you to do this prior to now.

    todd.west Jive Employee
    todd.west
    15,926 posts since
    Jul 14, 2008
    Currently Being Moderated
    Sep 15, 2008 9:31 AM in response to: jehandy
    Re: OpenFire shows Clearspace error when trying to browse groups

    Hi Jack,

     

    Hmm, you are right that looks good now. It's weird because if I set up an openfire instance I am able to set your URL and I get a "Success" message when I test it. Are you able to log into the Openfire admin console using your Clearspace credentials? Are there only certain features that don't work?

     

    Would you please post the logs from your <jiveHome>/logs/ folder and your <openfireHome>/logs/ folder? The logs I recieved earlier appeared to only be from tomcat, having these logs might shed some more light on the situation. Thanks.

     

    -Todd

    jehandy Novice
    jehandy
    31 posts since
    Feb 12, 2008
    Currently Being Moderated
    Sep 15, 2008 9:55 AM in response to: Todd West
    Re: OpenFire shows Clearspace error when trying to browse groups

    The authentication piece has always seemed to work whether using the latest version of OpenFire or the previous one.

     

    The users will display under both 3.5.2 and 3.6.0a, but in 3.6.0a I get a Java error if I try to look at the properties for an individual user.  The groups will not display under 3.6.0 at all but will with limited function ion 3.5.2.

    Attachments:
    todd.west Jive Employee
    todd.west
    15,926 posts since
    Jul 14, 2008
    Currently Being Moderated
    Sep 15, 2008 10:23 AM in response to: jehandy
    Re: OpenFire shows Clearspace error when trying to browse groups

    Hi Jack,

     

    I just spoke with our resident openfire expert here and It appears that this issue is more simple than I was expecting. Openfire 3.6.0a is only designed to work with Clearspace 2.5 integration and not 2.0.x (what you are running). So basically, if you need to upgrade Openfire you will also want to move to 2.5 as well. Hopefully this clears a few things up. Thanks Jack.

     

    -Todd

    jehandy Novice
    jehandy
    31 posts since
    Feb 12, 2008
    Currently Being Moderated
    Sep 15, 2008 10:31 AM in response to: Todd West
    Re: OpenFire shows Clearspace error when trying to browse groups

    Yes and no.  Clearspace still doesn't work with the older version of Spark either

    (http://www.jivesoftware.com/community/thread/32190)

     

    Is it possible that the process of trying to use the 3.6.0 version altered the database in Clearspace?

    todd.west Jive Employee
    todd.west
    15,926 posts since
    Jul 14, 2008
    Currently Being Moderated
    Sep 15, 2008 10:35 AM in response to: jehandy
    Re: OpenFire shows Clearspace error when trying to browse groups

    Hi Jack,

     

    I assume that you mean that Clearspace doesn't work with the older version of Openfire, not spark? Have you tried creating a fresh installation of Clearspace and Openfire to ensure that this is not a network setup issue? If fresh installs still do not work, then there may be another network related issue here causing Clearspace and Openfire to miscommunicate.

     

    I don't think that using the 3.6.0 version would have altered the database in Clearspace. Thanks.

     

    -Todd

    jehandy Novice
    jehandy
    31 posts since
    Feb 12, 2008
    Currently Being Moderated
    Sep 15, 2008 11:16 AM in response to: Todd West
    Re: OpenFire shows Clearspace error when trying to browse groups

    I floated the idea about the db being altered only because everything was working with an earlier version of OpenFire... after that attemtp fail, going back to the previous version isn't working either which throws the problem back towards CS...

    todd.west Jive Employee
    todd.west
    15,926 posts since
    Jul 14, 2008
    Currently Being Moderated
    Sep 15, 2008 11:24 AM in response to: jehandy
    Re: OpenFire shows Clearspace error when trying to browse groups

    Hmm, I see. Well I am not aware of Openfire making any changes to Clearspace but I guess it is a possibility. I can't think of what would be causing a problem like this that would be related to the database. If you revert back to 3.5,does it show "Connected" or are you still getting the same problem?

     

    Would it be possible to post the logs after trying Clearspace with Openfire 3.5? This should show any possible database problems (hopefully). Thanks.

     

    -Todd

    todd.west Jive Employee
    todd.west
    15,926 posts since
    Jul 14, 2008
    Currently Being Moderated
    Sep 15, 2008 2:32 PM in response to: Todd West
    Re: OpenFire shows Clearspace error when trying to browse groups

    Hi Jack,

     

    Quick question for you. By chance are you using LDAP in your Clearspace instance? I have found a bug which might apply to your situation (fixed in 2.0.6 and 2.5):

     

    (CS-4028): OF could not connect to CS when CS uses LDAP

     

     

    Thanks.

     

    -Todd

    jehandy Novice
    jehandy
    31 posts since
    Feb 12, 2008
    Currently Being Moderated
    Sep 15, 2008 4:40 PM in response to: Todd West
    Re: OpenFire shows Clearspace error when trying to browse groups

    Nope, no LDAP

    todd.west Jive Employee
    todd.west
    15,926 posts since
    Jul 14, 2008
    Currently Being Moderated
    Sep 15, 2008 4:42 PM in response to: jehandy
    Re: OpenFire shows Clearspace error when trying to browse groups

    Hi Jack,

     

    That is very strange, I am still not able to reproduce this issue locally and I have not heard of this problem before. Did you get a chance to try a vanilla CS 2.5 and Openfire 3.6.0 instance to ensure that the problem is with your instance and not something else? Thanks.

     

    -Todd

    jehandy Novice
    jehandy
    31 posts since
    Feb 12, 2008
    Currently Being Moderated
    Sep 22, 2008 8:28 AM in response to: jehandy
    Re: OpenFire shows Clearspace error when trying to browse groups

    I scrapped the previous configuration and upgraded to the latest 2.5.1 for CS and OF 3.6.0. I can connect to the chat server fine now but I still don't see any of the groups I've shared or any other connected users.  I can search for and find users and then chat with them but the list never populates.

     

    Suggestions?

    todd.west Jive Employee
    todd.west
    15,926 posts since
    Jul 14, 2008
    Currently Being Moderated
    Sep 22, 2008 5:12 PM in response to: jehandy
    Re: OpenFire shows Clearspace error when trying to browse groups

    Hi Jack,

     

    I just tested this locally with my instance of 2.5.1 and OF 3.6.0a and everything seemed to work great. Would you please take me through some of the steps you took to create a group and then connect. I am a little bit confused about exactly what isn't working here. Thanks!

     

    -Todd

    jehandy Novice
    jehandy
    31 posts since
    Feb 12, 2008
    Currently Being Moderated
    Sep 23, 2008 5:30 AM in response to: Todd West
    Re: OpenFire shows Clearspace error when trying to browse groups

    Ok,

     

    I have a working install of Clearspace 2.5.1 with about 60 users and a couple of groups.  I created the groups in Clearspace in the usual way using the admin site. Click on the People tab, click on Create Group, give it a name and a description.  Add users and an admin.  That's it.

     

    Now when I go over to OpenFire, there are no groups visible at all.  The users are there and I can even create new users.  If I try to create a group it says:

     

    "Not allowed: the group account system is read-only."

     

    From the Spark client I cannot see any users or groups.  If I add an existing user I can see them, but the rest I cannot.

    todd.west Jive Employee
    todd.west
    15,926 posts since
    Jul 14, 2008
    Currently Being Moderated
    Sep 23, 2008 3:04 PM in response to: jehandy
    Re: OpenFire shows Clearspace error when trying to browse groups

    Hi Jack,

     

    The groups that are shown in Openfire are not the groups that you are referring to, they actually refer to the new Social Groups feature in 2.5. Thanks.

     

    -Todd

    jehandy Novice
    jehandy
    31 posts since
    Feb 12, 2008
    Currently Being Moderated
    Sep 23, 2008 5:34 PM in response to: Todd West
    Re: OpenFire shows Clearspace error when trying to browse groups
    Attachments:
    jehandy Novice
    jehandy
    31 posts since
    Feb 12, 2008
    Currently Being Moderated
    Sep 23, 2008 5:35 PM in response to: Todd West
    Re: OpenFire shows Clearspace error when trying to browse groups

    OK, so that still doesn't solve my problem.. unless there's something I am missing.

    todd.west Jive Employee
    todd.west
    15,926 posts since
    Jul 14, 2008
    Currently Being Moderated
    Sep 23, 2008 5:37 PM in response to: jehandy
    Re: OpenFire shows Clearspace error when trying to browse groups

    Hi Jack,

     

    What problem are you still seeing? If you create a new social group and have users join then this group will show up in Openfire. It seems to take an Openfire restart for this occur but it should work, I tested it locally and it works fine. Thanks.

     

    -Todd

    jehandy Novice
    jehandy
    31 posts since
    Feb 12, 2008
    Currently Being Moderated
    Sep 23, 2008 5:43 PM in response to: Todd West
    Re: OpenFire shows Clearspace error when trying to browse groups

    So this means that I can't create groups and assign users and have the groups pre-populated?

    todd.west Jive Employee
    todd.west
    15,926 posts since
    Jul 14, 2008
    Currently Being Moderated
    Sep 23, 2008 9:09 PM in response to: jehandy
    Re: OpenFire shows Clearspace error when trying to browse groups

    I believe that's correct. After talking with one of the guys in core about openfire/clearspace integration it turns out that they decided to have the integration work with Social Groups for 2.5 instead of the original Clearspace groups. Thanks.

     

    -Todd

    todd.west Jive Employee
    todd.west
    15,926 posts since
    Jul 14, 2008
    Currently Being Moderated
    Oct 2, 2008 8:16 AM in response to: Todd West
    Re: OpenFire shows Clearspace error when trying to browse groups

    Hi Jack,

     

    I just wanted to confirm that I was able to answer any questions you had regarding this issue. Hope to hear from you soon. Thanks.

     

    -Todd

    More Like This

    • Retrieving data ...

    Bookmarked By (0)

    To better serve our customers we have included functionality to automatically follow up on a case after it has been idle for more than 5 days, and then auto close after an additional 3 days of inactivity. Choose No to acknowledge that this case will remain idle for longer than 5 days.
    Making cases public allows other customers to learn from the solution of the case. It can also be used to gain feedback from others in the community. Ask our Support Engineers for more info, but we encourage you to make your cases public.