Ignite Realtime: Openfire 3.6.0 has been released!

Jonas

110 posts since
Oct 19, 2006

Currently Being Moderated

Aug 27, 2008 1:12 AM (in response to Daniel Henninger)

Re: Openfire 3.6.0 has been released!

Thanks guys and girls! I'll give it a go in the afternoon...

Links are broken though...theres a "community" that does not belong in there (The readable one works though )

Report Abuse
Like (0)

michelbugeja

17 posts since
Nov 24, 2006

Currently Being Moderated

Aug 27, 2008 1:48 AM (in response to Daniel Henninger)

Re: Openfire 3.6.0 has been released!

This is great news, and it looks like a lot of work have been done.

I installed it and the upgrade was really smooth.

However I am encountering some issues:

1) Profile Settings show my LDAP configuration but when I click on Edit Base DN and Administrator DN are not properly retrieved from the databse.

2) Client management is not loading in Admin Interface

2008.08.27 10:27:34 [org.jivesoftware.openfire.container.PluginServlet.service(PluginServlet.java:9 9)]
javax.servlet.ServletException: java.lang.NoSuchMethodError: org.jivesoftware.openfire.XMPPServer.getMultiUserChatServer()Lorg/jivesoftware/ openfire/muc/MultiUserChatServer;

3) Statistics is not loading in Admin Interface

2008.08.27 10:28:18 [org.jivesoftware.openfire.container.PluginServlet.service(PluginServlet.java:9 9)]
java.lang.ArrayIndexOutOfBoundsException: 0

I will let you know if I encouter any other issue.

Keep it up and well done.

Report Abuse
Like (0)

Coolcat
797 posts since
Mar 19, 2007

Currently Being Moderated

Aug 27, 2008 3:15 AM (in response to michelbugeja)
Re: Openfire 3.6.0 has been released!

Sounds great

Questions/Issues:
1. All links in the "Where Do I Get It?"-section (Blog post) are dead.
2. You mention some API changes in 3.6.0. What about a special section in changelog where all API changes are listed. This would help plugin developers as me a lot.
3. Does upgrading Openfire automatically move settings from openfire.xml to database?

Report Abuse

Like (0)
- Jonas
  110 posts since
  Oct 19, 2006
  
  Currently Being Moderated
  
  Aug 27, 2008 3:38 AM (in response to Coolcat)
  Re: Openfire 3.6.0 has been released!
  
  @ Coolcat to No.3:
  
  Yes it does, but you might have to be careful (See below)
  
  ...and sorry for the doublepost...I have too many PCs
  
  Report Abuse
  
  Like (0)
- Daniel Henninger
  2,972 posts since
  Aug 10, 2005
  
  Currently Being Moderated
  
  Aug 27, 2008 7:25 AM (in response to Coolcat)
  Re: Openfire 3.6.0 has been released!
  
  Coolcat wrote:
  
  Sounds great
  
  Questions/Issues:
  1. All links in the "Where Do I Get It?"-section (Blog post) are dead.
  2. You mention some API changes in 3.6.0. What about a special section in changelog where all API changes are listed. This would help plugin developers as me a lot.
  3. Does upgrading Openfire automatically move settings from openfire.xml to database?
  1. ARG! And it looks like I can't fix them. =( (they keep getting put back)
  2. I intend to post something in the openfire developers forum about it actually =) just got too tired. an API changes section in the changelog might not be a bad idea though. I'll think about that.
  3. Yup! (or at least all of the settings that should be moved)
  
  Report Abuse
  
  Like (0)
Jonas
110 posts since
Oct 19, 2006

Currently Being Moderated

Aug 27, 2008 5:13 AM (in response to michelbugeja)
Re: Openfire 3.6.0 has been released!

2 Bugs, 1 critical (or dumbness?).

My Openfire authenticates with an Active Directory that is not on the same server.

When I install the Update, the /etc/openfire.xml gets updated accordingly and the Admin-Logins get transferred to the database (found them in ofProperty -> admin.authorizedJIDs, is that correct?)

Login is not possible anymore.

The transferred value gets modified.
My old entry was "username" the new one in the DB reads "username@jabberserver" this probably wont work, as my AD wont understand that username.

However changing that value back to just "username" or to "username@FQDN" (Or even "username\40FQDN") doesnt let me back into my Admin Interface. Login with a normal Jabber-Client doesnt work as well so I checked the LDAP Log and found, what I will attach in a minute (from the other PC). The AcceptSecurityContextError leads me to the guess that some special characters are misinterpretated wrong when read? I don't know. I didn't change anything and my Openfire Live-System still works as expected (3.5.1). The entries in my database all look very well (MySQL 5.0.51a)

More Harmless:

Login to Admin Backend:

If the Username contains an "@" and you login with a wrong Password, the @ gets escaped to /40.
If you do it wrong again the \ gets escaped with \c5 and so on and so on...
@ -> \40 -> \5c40 -> \5c5c40

Question:

Why is there a property called ldap.debugEnabled and one called ldap.ldapDebugEnabled ?

---------------------------------------------------

javax.naming.AuthenticationException: [LDAP: error code 49 - 80090308: LdapErr: DSID-0C090334, comment: AcceptSecurityContext error, data 525, vece^@]
         at com.sun.jndi.ldap.LdapCtx.mapErrorCode(LdapCtx.java:3005)
         at com.sun.jndi.ldap.LdapCtx.processReturnCode(LdapCtx.java:2951)
         at com.sun.jndi.ldap.LdapCtx.processReturnCode(LdapCtx.java:2753)
         at com.sun.jndi.ldap.LdapCtx.connect(LdapCtx.java:2667)
         at com.sun.jndi.ldap.LdapCtx.<init>(LdapCtx.java:287)
         at com.sun.jndi.ldap.LdapCtxFactory.getUsingURL(LdapCtxFactory.java:175)
         at com.sun.jndi.ldap.LdapCtxFactory.getUsingURLs(LdapCtxFactory.java:193)
         at com.sun.jndi.ldap.LdapCtxFactory.getLdapCtxInstance(LdapCtxFactory.java:136)
         at com.sun.jndi.ldap.LdapCtxFactory.getInitialContext(LdapCtxFactory.java:66)
         at javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:667)
         at javax.naming.InitialContext.getDefaultInitCtx(InitialContext.java:288)
         at javax.naming.InitialContext.init(InitialContext.java:223)
         at javax.naming.ldap.InitialLdapContext.<init>(InitialLdapContext.java:134)
         at org.jivesoftware.openfire.ldap.LdapManager.getContext(LdapManager.java:485)
         at org.jivesoftware.openfire.ldap.LdapManager.findGroupDN(LdapManager.java:833)
         at org.jivesoftware.openfire.ldap.LdapManager.findGroupDN(LdapManager.java:787)
         at org.jivesoftware.openfire.ldap.LdapGroupProvider.getGroup(LdapGroupProvider.jav a:83)
         at org.jivesoftware.openfire.group.GroupManager.getGroup(GroupManager.java:278)
         at org.jivesoftware.openfire.group.GroupManager.getGroup(GroupManager.java:257)
         at org.jivesoftware.openfire.group.GroupCollection$UserIterator.getNextElement(Gro upCollection.java:103)
         at org.jivesoftware.openfire.group.GroupCollection$UserIterator.hasNext(GroupColle ction.java:66)
         at org.jivesoftware.openfire.group.GroupManager$4.run(GroupManager.java:185)
         at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
         at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
         at java.util.concurrent.FutureTask.run(FutureTask.java:138)
         at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java: 885)
         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
         at java.lang.Thread.run(Thread.java:619)

Report Abuse

Like (0)
- Daniel Henninger
  2,972 posts since
  Aug 10, 2005
  
  Currently Being Moderated
  
  Aug 27, 2008 7:31 AM (in response to Jonas)
  Re: Openfire 3.6.0 has been released!
  
  You actually should leave it as whatever@whatever, as that's the "official format of the JIDs" now. If the @whatever matches that of the server, then a simple username will work. (ie, don't have to enter the @) If I recall correctly, error code 49 means nothing more than "couldn't log in". I'm perplexed as to why it's not working all of a sudden. I tested this against our dev active directory server. I don't actually know why there are two ldap debug properties off the top of my head. That's rather bizarre! Have you looked at the code at all to see where they are used? As for the login page thing, I've noted it to be fixed. =) The inability to log in thing is... well lemme look and response to your other post before commenting more on that.
  No.2 wrote:
  
  2 Bugs, 1 critical (or dumbness?).
  
  My Openfire authenticates with an Active Directory that is not on the same server.
  
  When I install the Update, the /etc/openfire.xml gets updated accordingly and the Admin-Logins get transferred to the database (found them in ofProperty -> admin.authorizedJIDs, is that correct?)
  
  Login is not possible anymore.
  
  The transferred value gets modified.
  My old entry was "username" the new one in the DB reads "username@jabberserver" this probably wont work, as my AD wont understand that username.
  
  However changing that value back to just "username" or to "username@FQDN" (Or even "username\40FQDN") doesnt let me back into my Admin Interface. Login with a normal Jabber-Client doesnt work as well so I checked the LDAP Log and found, what I will attach in a minute (from the other PC). The AcceptSecurityContextError leads me to the guess that some special characters are misinterpretated wrong when read? I don't know. I didn't change anything and my Openfire Live-System still works as expected (3.5.1). The entries in my database all look very well (MySQL 5.0.51a)
  
  More Harmless:
  
  Login to Admin Backend:
  
  If the Username contains an "@" and you login with a wrong Password, the @ gets escaped to /40.
  If you do it wrong again the \ gets escaped with \c5 and so on and so on...
  @ -> \40 -> \5c40 -> \5c5c40
  
  Question:
  
  Why is there a property called ldap.debugEnabled and one called ldap.ldapDebugEnabled ?
  
  ---------------------------------------------------
  
  javax.naming.AuthenticationException: [LDAP: error code 49 - 80090308: LdapErr: DSID-0C090334, comment: AcceptSecurityContext error, data 525, vece^@]
           at com.sun.jndi.ldap.LdapCtx.mapErrorCode(LdapCtx.java:3005)
           at com.sun.jndi.ldap.LdapCtx.processReturnCode(LdapCtx.java:2951)
           at com.sun.jndi.ldap.LdapCtx.processReturnCode(LdapCtx.java:2753)
           at com.sun.jndi.ldap.LdapCtx.connect(LdapCtx.java:2667)
           at com.sun.jndi.ldap.LdapCtx.<init>(LdapCtx.java:287)
           at com.sun.jndi.ldap.LdapCtxFactory.getUsingURL(LdapCtxFactory.java:175)
           at com.sun.jndi.ldap.LdapCtxFactory.getUsingURLs(LdapCtxFactory.java:193)
           at com.sun.jndi.ldap.LdapCtxFactory.getLdapCtxInstance(LdapCtxFactory.java:136)
           at com.sun.jndi.ldap.LdapCtxFactory.getInitialContext(LdapCtxFactory.java:66)
           at javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:667)
           at javax.naming.InitialContext.getDefaultInitCtx(InitialContext.java:288)
           at javax.naming.InitialContext.init(InitialContext.java:223)
           at javax.naming.ldap.InitialLdapContext.<init>(InitialLdapContext.java:134)
           at org.jivesoftware.openfire.ldap.LdapManager.getContext(LdapManager.java:485)
           at org.jivesoftware.openfire.ldap.LdapManager.findGroupDN(LdapManager.java:833)
           at org.jivesoftware.openfire.ldap.LdapManager.findGroupDN(LdapManager.java:787)
           at org.jivesoftware.openfire.ldap.LdapGroupProvider.getGroup(LdapGroupProvider.jav a:83)
           at org.jivesoftware.openfire.group.GroupManager.getGroup(GroupManager.java:278)
           at org.jivesoftware.openfire.group.GroupManager.getGroup(GroupManager.java:257)
           at org.jivesoftware.openfire.group.GroupCollection$UserIterator.getNextElement(Gro upCollection.java:103)
           at org.jivesoftware.openfire.group.GroupCollection$UserIterator.hasNext(GroupColle ction.java:66)
           at org.jivesoftware.openfire.group.GroupManager$4.run(GroupManager.java:185)
           at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
           at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
           at java.util.concurrent.FutureTask.run(FutureTask.java:138)
           at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java: 885)
           at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
           at java.lang.Thread.run(Thread.java:619)
  
  Report Abuse
  
  Like (0)
  - Jonas
    110 posts since
    Oct 19, 2006
    
    Currently Being Moderated
    
    Aug 27, 2008 9:46 AM (in response to Daniel Henninger)
    Re: Openfire 3.6.0 has been released!
    
    With the hint of "Setting setup to false" and do the setup again I got a bit further at least with my troubleshooting:
    
    I can't complete the Setup of LDAP anymore. Testing gives me an error, so cleary there lies the problem. However the setup is identivally to my 3.5.1 (I double and tripple checked), where it works. The AD is the same as well. My logfiles are empty even though I enabled the Debug to System.out when I click "Test". (Where would that log be? in /var/log/openfire/* together with the other openfire logs?)
    
    If I proceed one further and test it there I get the same error I posted before in my error.log. My Admin CN contains a Space. Is it possible that somewhere this is misinterpretated in 3.6.0? (its cn=User Jabber,ou=....) I'll check with wireshark tomorrow what it sends as my workday is long over now
    
    >I don't actually know why there are two ldap debug properties off the top of my head. That's rather bizarre! Have you looked at the code at all to see where they are used?
    
    No I haven't looked into the source...I'm no programmer, so this probably wont help unless it blinks and beeps at the right place
    
    EDIT:
    
    Just seen the more recent posts:
    
    "Try setting: ldap.encloseDNs to false"
    
    solved my LDAP Issue to a certain kind. it now does accept my client Logins still no admin backend access though.
    
    If I rerun Setup now, I don't get the "dc=" anymore someone else mentioned in this thread. I get the values I entered in the DB before. However clicking "Test" still does not work (Why the Login of the clients DOES work is something I can't really explain but I'm quite long at work now so I might have missed something... *yawn*). Adding an Administrator Account does not work as well. So I am stuck here again.
    
    Report Abuse
    
    Like (0)
- sixthring
  3,799 posts since
  Apr 2, 2007
  
  Currently Being Moderated
  
  Aug 27, 2008 7:35 AM (in response to Jonas)
  Re: Openfire 3.6.0 has been released!
  
  Stop the openfire server, edit your openfire.xml file sot that the setup tag read <setup>false</setup>. Then start the server and and go to the admin page and restep through teh setup again. This fixed my issue with invalid admin logins.
  
  Report Abuse
  
  Like (0)
Daniel Henninger
2,972 posts since
Aug 10, 2005

Currently Being Moderated

Aug 27, 2008 7:23 AM (in response to michelbugeja)
Re: Openfire 3.6.0 has been released!

Ug, this editor is making me mad at the moment. How do you do "broken into pieces comments"? Anyway ---
1. What do you mean not properly retrieved? What are you seeing instead?
2. That sounds like the client control plugin needs to be upgraded. Or... you are using Enterprise which is no longer available. (i just noticed that that wasn't mentioned in the blog post =/ ) There will not be an enterprise plugin for 3.6.0, everyone using it should switch to the separated plugins (monitoring, clientControl, fastpath, clustering).
3. Same as #2, it sounds like you either need to upgrade the monitoring plugin, or if you have enterprise, ditch it and switch to the separate plugins.

I apologize for not making the "enterprise is gone" clear in my original posts.
michelbugeja wrote:

This is great news, and it looks like a lot of work have been done.

I installed it and the upgrade was really smooth.

However I am encountering some issues:

1) Profile Settings show my LDAP configuration but when I click on Edit Base DN and Administrator DN are not properly retrieved from the databse.
2) Client management is not loading in Admin Interface
2008.08.27 10:27:34 [org.jivesoftware.openfire.container.PluginServlet.service(PluginServlet.java:9 9)]
javax.servlet.ServletException: java.lang.NoSuchMethodError: org.jivesoftware.openfire.XMPPServer.getMultiUserChatServer()Lorg/jivesoftware/ openfire/muc/MultiUserChatServer;
3) Statistics is not loading in Admin Interface
2008.08.27 10:28:18 [org.jivesoftware.openfire.container.PluginServlet.service(PluginServlet.java:9 9)]
java.lang.ArrayIndexOutOfBoundsException: 0

I will let you know if I encouter any other issue.

Keep it up and well done.

Report Abuse

Like (0)
- michelbugeja
  17 posts since
  Nov 24, 2006
  
  Currently Being Moderated
  
  Aug 27, 2008 8:20 AM (in response to Daniel Henninger)
  Re: Openfire 3.6.0 has been released!
  
  Hi Daniel,
  
  thanks for your reply, the installation works fine on my environment (CentOS-mysql5) upgrading from of352, however I am not sure that after installing the rpm the previous demon was actually stopped as I had to reboot the machine prior to work properly as the log file was showing that a nuymber of ports were still in use.
  
  After that, the only issues where those expained in my previous comment:
  
  i.e. Profile settings Base DN and Administrator DN only showing "CN=" or "DN="
  
  The enterprise plugin was previously removed and all plugins were updated to the latest ones, however I am still encountering the issues described below, I also tried to remove both jars and directory for the plugins that are producing errors and re-install thourgh administration site, but problem still occurs.
  
  Is there any other way to investigate the issue further? maybe there is some problems with the database? I need your help here.
  
  Report Abuse
  
  Like (0)
  - Daniel Henninger
    2,972 posts since
    Aug 10, 2005
    
    Currently Being Moderated
    
    Aug 27, 2008 8:57 AM (in response to michelbugeja)
    Re: Openfire 3.6.0 has been released!
    
    michelbugeja wrote:
    
    Hi Daniel,
    
    thanks for your reply, the installation works fine on my environment (CentOS-mysql5) upgrading from of352, however I am not sure that after installing the rpm the previous demon was actually stopped as I had to reboot the machine prior to work properly as the log file was showing that a nuymber of ports were still in use.
    
    After that, the only issues where those expained in my previous comment:
    
    i.e. Profile settings Base DN and Administrator DN only showing "CN=" or "DN="
    
    The enterprise plugin was previously removed and all plugins were updated to the latest ones, however I am still encountering the issues described below, I also tried to remove both jars and directory for the plugins that are producing errors and re-install thourgh administration site, but problem still occurs.
    
    Is there any other way to investigate the issue further? maybe there is some problems with the database? I need your help here.
    
    Hrm. Do you have some time to join the group chat today and ask me in person? Might need to work through it real time. Did you happen to rerun setup? (Todd suggested that earlier in this thread)
    
    Report Abuse
    
    Like (0)

NAPS Account

2 posts since
Aug 27, 2008

Currently Being Moderated

Aug 27, 2008 3:52 AM (in response to Daniel Henninger)

Re: Openfire 3.6.0 has been released!

I tried to do the rpm -Uvh of the package, the install completed fine, but the server refused to start. It was unable to make the required changes to the database :-

[snipped as this was a *lot* of errors]

2008.08.27 10:56:03 [org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:37 9)] SchemaManager: Failed to execute SQL:
ALTER TABLE mucRoom ADD COLUMN serviceID BIGINT NOT NULL BEFORE roomID;
2008.08.27 10:56:03 [org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:269)]
java.sql.SQLException: Column constraints are not acceptable in statement [ ALTER TABLE mucRoom ADD COLUMN serviceID BIGINT NOT NULL ]
        at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
        at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
        at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
        at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
        at $java.sql.Wrapper$$EnhancerByProxool$$1849176a.execute(<generated>)
        at org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:374 )
        at org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:266)
        at org.jivesoftware.database.SchemaManager.checkOpenfireSchema(SchemaManager.java: 71)
        at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectio nManager.java:498)
        at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:79)
        at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:335)
        at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:73)
        at org.jivesoftware.util.JiveProperties$JivePropertyHolder.<clinit>(JiveProperties .java:40)
        at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:52)
        at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:532)
        at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:298)
        at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:415)
        at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:161)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at java.lang.Class.newInstance0(Unknown Source)
        at java.lang.Class.newInstance(Unknown Source)
        at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106)
        at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)
2008.08.27 10:56:03 [org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:346)]
java.sql.SQLException: Table not found in statement [SELECT name, propValue FROM ofProperty]
        at org.hsqldb.jdbc.Util.throwError(Unknown Source)
        at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
        at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.logicalcobwebs.proxool.WrappedConnection.invoke(WrappedConnection.java:162)
        at org.logicalcobwebs.proxool.WrappedConnection.intercept(WrappedConnection.java:8 7)
        at $java.sql.Wrapper$$EnhancerByProxool$$bdca003f.prepareStatement(<generated>)
        at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:336)
        at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:73)
        at org.jivesoftware.util.JiveProperties$JivePropertyHolder.<clinit>(JiveProperties .java:40)
        at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:52)
        at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:532)
        at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:298)
        at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:415)
        at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:161)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at java.lang.Class.newInstance0(Unknown Source)
        at java.lang.Class.newInstance(Unknown Source)
        at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106)
        at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)

Report Abuse
Like (0)

Daniel Henninger
2,972 posts since
Aug 10, 2005

Currently Being Moderated

Aug 27, 2008 7:32 AM (in response to NAPS Account)
Re: Openfire 3.6.0 has been released!

No.2, Oh that was your other post. Hrm. Well actually, I'm more concerned about this:
java.sql.SQLException: Table not found in statement [SELECT name, propValue FROM ofProperty]
It's not founding ofProperty??? That might be causing a cascading weird issue.
Did that table not get renamed in your db?

Report Abuse

Like (0)
Daniel Henninger
2,972 posts since
Aug 10, 2005

Currently Being Moderated

Aug 27, 2008 7:34 AM (in response to NAPS Account)
Re: Openfire 3.6.0 has been released!

Good lord. What DB is this? Looks like the upgrade script flat out failed. Whatever database it is seems to be mad about ... I'm thinking NOT NULL. (in other words it refuses to allow adding a new column that can't have NULLs in it, a fairly common issue) The only db I ran across that seemed to have that problem I fixed that in so I'm highly interested to know what db this is!
cwipapps wrote:

I tried to do the rpm -Uvh of the package, the install completed fine, but the server refused to start. It was unable to make the required changes to the database :-

[snipped as this was a *lot* of errors]

2008.08.27 10:56:03 [org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:37 9)] SchemaManager: Failed to execute SQL:
ALTER TABLE mucRoom ADD COLUMN serviceID BIGINT NOT NULL BEFORE roomID;
2008.08.27 10:56:03 [org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:269)]
java.sql.SQLException: Column constraints are not acceptable in statement [ ALTER TABLE mucRoom ADD COLUMN serviceID BIGINT NOT NULL ]
        at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
        at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
        at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
        at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
        at $java.sql.Wrapper$$EnhancerByProxool$$1849176a.execute(<generated>)
        at org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:374 )
        at org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:266)
        at org.jivesoftware.database.SchemaManager.checkOpenfireSchema(SchemaManager.java: 71)
        at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectio nManager.java:498)
        at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:79)
        at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:335)
        at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:73)
        at org.jivesoftware.util.JiveProperties$JivePropertyHolder.<clinit>(JiveProperties .java:40)
        at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:52)
        at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:532)
        at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:298)
        at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:415)
        at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:161)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at java.lang.Class.newInstance0(Unknown Source)
        at java.lang.Class.newInstance(Unknown Source)
        at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106)
        at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)
2008.08.27 10:56:03 [org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:346)]
java.sql.SQLException: Table not found in statement [SELECT name, propValue FROM ofProperty]
        at org.hsqldb.jdbc.Util.throwError(Unknown Source)
        at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
        at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.logicalcobwebs.proxool.WrappedConnection.invoke(WrappedConnection.java:162)
        at org.logicalcobwebs.proxool.WrappedConnection.intercept(WrappedConnection.java:8 7)
        at $java.sql.Wrapper$$EnhancerByProxool$$bdca003f.prepareStatement(<generated>)
        at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:336)
        at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:73)
        at org.jivesoftware.util.JiveProperties$JivePropertyHolder.<clinit>(JiveProperties .java:40)
        at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:52)
        at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:532)
        at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:298)
        at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:415)
        at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:161)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at java.lang.Class.newInstance0(Unknown Source)
        at java.lang.Class.newInstance(Unknown Source)
        at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106)
        at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)

Report Abuse

Like (0)
- NAPS Account
  2 posts since
  Aug 27, 2008
  
  Currently Being Moderated
  
  Aug 27, 2008 9:11 AM (in response to Daniel Henninger)
  Re: Openfire 3.6.0 has been released!
  
  It's the standard built in database.. there are only about 4 of use use the system, so it seemed overkill installing anything else. This is why I'm surprised it didn't work. It couldn't upgrade a database that it had installed.
  
  Report Abuse
  
  Like (0)
- herodes
  38 posts since
  Mar 27, 2008
  
  Currently Being Moderated
  
  Aug 28, 2008 6:25 AM (in response to Daniel Henninger)
  Re: Openfire 3.6.0 has been released!
  
  I've got the same error.
  
  whats the solution for it?
  
  bevore it was openfire 3.5.2
  used embedded db
  suse linux
  
  2008.08.26 13:46:04 [org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:37 9)] SchemaManager: Failed to execute SQL:
  ALTER TABLE mucRoom ADD COLUMN serviceID BIGINT NOT NULL BEFORE roomID;
  2008.08.26 13:46:04 [org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:269)]
  java.sql.SQLException: Column constraints are not acceptable in statement [ ALTER TABLE mucRoom ADD COLUMN serviceID BIGINT NOT NULL ]
          at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
          at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
          at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
          at java.lang.reflect.Method.invoke(Unknown Source)
          at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
          at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
          at $java.sql.Statement$$EnhancerByProxool$$7e7f0f8d.execute(<generated>)
          at org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:374 )
          at org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:266)
          at org.jivesoftware.database.SchemaManager.checkOpenfireSchema(SchemaManager.java: 71)
          at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectio nManager.java:498)
          at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:79)
          at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:335)
          at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:73)
          at org.jivesoftware.util.JiveProperties$JivePropertyHolder.<clinit>(JiveProperties .java:40)
          at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:52)
          at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:532)
          at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:298)
          at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:415)
          at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:161)
          at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
          at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
          at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
          at java.lang.reflect.Constructor.newInstance(Unknown Source)
          at java.lang.Class.newInstance0(Unknown Source)
          at java.lang.Class.newInstance(Unknown Source)
          at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106)
          at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)
  2008.08.26 13:46:04 [org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:346)]
  java.sql.SQLException: Table not found in statement [SELECT name, propValue FROM ofProperty]
          at org.hsqldb.jdbc.Util.throwError(Unknown Source)
          at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
          at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
          at java.lang.reflect.Method.invoke(Unknown Source)
          at org.logicalcobwebs.proxool.WrappedConnection.invoke(WrappedConnection.java:162)
          at org.logicalcobwebs.proxool.WrappedConnection.intercept(WrappedConnection.java:8 7)
          at $java.sql.Wrapper$$EnhancerByProxool$$c0770dfa.prepareStatement(<generated>)
          at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:336)
          at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:73)
          at org.jivesoftware.util.JiveProperties$JivePropertyHolder.<clinit>(JiveProperties .java:40)
          at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:52)
          at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:532)
          at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:298)
          at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:415)
          at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:161)
          at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
          at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
          at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
          at java.lang.reflect.Constructor.newInstance(Unknown Source)
          at java.lang.Class.newInstance0(Unknown Source)
          at java.lang.Class.newInstance(Unknown Source)
          at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106)
          at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)
  2008.08.26 13:46:04 [org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:709)] Database could not be accessed
  java.sql.SQLException: Table not found in statement [SELECT count(*) FROM ofID]
          at org.hsqldb.jdbc.Util.throwError(Unknown Source)
          at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
          at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
          at java.lang.reflect.Method.invoke(Unknown Source)
          at org.logicalcobwebs.proxool.WrappedConnection.invoke(WrappedConnection.java:162)
          at org.logicalcobwebs.proxool.WrappedConnection.intercept(WrappedConnection.java:8 7)
          at $java.sql.Wrapper$$EnhancerByProxool$$c0770dfa.prepareStatement(<generated>)
          at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:699)
          at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:427)
          at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:161)
          at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
          at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
          at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
          at java.lang.reflect.Constructor.newInstance(Unknown Source)
          at java.lang.Class.newInstance0(Unknown Source)
          at java.lang.Class.newInstance(Unknown Source)
          at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106)
          at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)
  2008.08.26 13:46:04 [org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:457)]
  java.lang.IllegalArgumentException: java.sql.SQLException: Table not found in statement [SELECT count(*) FROM ofID]
          at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:710)
          at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:427)
          at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:161)
          at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
          at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
          at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
          at java.lang.reflect.Constructor.newInstance(Unknown Source)
          at java.lang.Class.newInstance0(Unknown Source)
          at java.lang.Class.newInstance(Unknown Source)
          at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106)
          at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)
  Caused by: java.sql.SQLException: Table not found in statement [SELECT count(*) FROM ofID]
          at org.hsqldb.jdbc.Util.throwError(Unknown Source)
          at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
          at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
          at java.lang.reflect.Method.invoke(Unknown Source)
          at org.logicalcobwebs.proxool.WrappedConnection.invoke(WrappedConnection.java:162)
          at org.logicalcobwebs.proxool.WrappedConnection.intercept(WrappedConnection.java:8 7)
          at $java.sql.Wrapper$$EnhancerByProxool$$c0770dfa.prepareStatement(<generated>)
          at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:699)
          ... 10 more
  
  Report Abuse
  
  Like (0)

jan

3 posts since
Aug 27, 2008

Currently Being Moderated

Aug 27, 2008 4:09 AM (in response to Daniel Henninger)

Re: Openfire 3.6.0 has been released!

Hi

I have a installation of 3.5.2. How do I upgrade my data to the new database format of 3.6.0? I see the db tables changed from a jive "prefix" to "of" prefix. Is there any migration script around or is it a DIY task?

Regards

Jan

Report Abuse
Like (0)

jan
3 posts since
Aug 27, 2008

Currently Being Moderated

Aug 27, 2008 4:40 AM (in response to jan)
Re: Openfire 3.6.0 has been released!

OK it was easy, just make a dbdump of your database and rename the tables and re-import it.

Regards

Jan

Report Abuse

Like (0)
- Sebastian Clarke
  8 posts since
  Dec 4, 2007
  
  Currently Being Moderated
  
  Aug 27, 2008 7:35 AM (in response to jan)
  Re: Openfire 3.6.0 has been released!
  
  serfonteinj wrote:
  
  OK it was easy, just make a dbdump of your database and rename the tables and re-import it.
  
  Regards
  
  Jan
  can anyone confirm that the only changes to the DB between these versions is that the jive* tables names are changed to of* - if this is the only difference then yeah, shouldn't be too hard to dump these out then inject them back in.
  
  Cheers,
  
  Seb
  
  Report Abuse
  
  Like (0)
  - Daniel Henninger
    2,972 posts since
    Aug 10, 2005
    
    Currently Being Moderated
    
    Aug 27, 2008 7:38 AM (in response to Sebastian Clarke)
    Re: Openfire 3.6.0 has been released!
    
    That is not the -only- changes. Some indexes were renamed (wouldn't be a problem unless a future upgrade script needs to change something) Plus there were a couple of other db updates beyond just renaming tables.
    seb_llgc wrote:
    
    serfonteinj wrote:
    
    OK it was easy, just make a dbdump of your database and rename the tables and re-import it.
    
    Regards
    
    Jan
    can anyone confirm that the only changes to the DB between these versions is that the jive* tables names are changed to of* - if this is the only difference then yeah, shouldn't be too hard to dump these out then inject them back in.
    
    Cheers,
    
    Seb
    
    Report Abuse
    
    Like (0)
- Daniel Henninger
  2,972 posts since
  Aug 10, 2005
  
  Currently Being Moderated
  
  Aug 27, 2008 7:54 AM (in response to jan)
  Re: Openfire 3.6.0 has been released!
  
  serfonteinj wrote:
  
  OK it was easy, just make a dbdump of your database and rename the tables and re-import it.
  
  Regards
  
  Jan
  That's not all that changed. (there are a couple of other db upgrade scripts that need to be run) Plus some indexes changed names, which could cause problems in the future if those indexes are ever adjusted via automatic update. If you just renamed the tables, when you start up Openfire 3.6.0 it's going to get "very angry" because it's going to think it hasn't upgraded yet and try to rename tables.
  
  Report Abuse
  
  Like (0)
Coolcat
797 posts since
Mar 19, 2007

Currently Being Moderated

Aug 27, 2008 4:42 AM (in response to jan)
Re: Openfire 3.6.0 has been released!

@jan:
Is there any migration script around
Normally Openfire does such updates automatically. But you see, there are some problems reported in this thread. You should do a database backup before and, if possible, test it on an identical test system.

@all people with database problems:
It is always helpful, if you say which database you are using.

Report Abuse

Like (0)
- Coolcat
  797 posts since
  Mar 19, 2007
  
  Currently Being Moderated
  
  Aug 27, 2008 4:47 AM (in response to Coolcat)
  Re: Openfire 3.6.0 has been released!
  
  @Sebastian Clarke:
  Is there a fix for this in the pipeline?
  You can always apply the database update script manually. Scripts are located in ..../resources/database/upgrade
  Find the correct update script and execute it by hand, step by step.
  
  Report Abuse
  
  Like (0)
  - Daniel Henninger
    2,972 posts since
    Aug 10, 2005
    
    Currently Being Moderated
    
    Aug 27, 2008 7:16 AM (in response to Coolcat)
    Re: Openfire 3.6.0 has been released!
    
    Bah! Stupid links not working! What's worse is there doesn't appear to be anything I can do about it. (trying to change it doesn't work)
    
    As for the other questions and comments here, let me finish waking up, cull together everything that's brought up here, and see what answers I can bring. I'll be in the weekly chat today "as usual", so please feel free to join. I'll try to be there early and late if I can as well since this was a pretty big release and looks like there's a lot of questions.
    
    A couple of things off the top of my head, make sure you upgrade the plugins I mentioned in the blog post, and I know that Open Archive breaks horribly. (in fact it somehow manages to break other plugins in the process =/) In general, make sure you are running all the latest versions of your plugins.
    
    Report Abuse
    
    Like (0)
- Daniel Henninger
  2,972 posts since
  Aug 10, 2005
  
  Currently Being Moderated
  
  Aug 27, 2008 7:17 AM (in response to Coolcat)
  Re: Openfire 3.6.0 has been released!
  
  And also it is -always- a good idea to back up your database (and openfire home) before going through an upgrade. =) I know I know, I don't always do it either, but it's always recommended.
  
  Report Abuse
  
  Like (0)

Sebastian Clarke

8 posts since
Dec 4, 2007

Currently Being Moderated

Aug 27, 2008 4:35 AM (in response to Daniel Henninger)

Re: Openfire 3.6.0 has been released!

Hey,

I have the same problem as above. The upgrade/install using the RPM worked fine but it was unable to make the neccasary modifications to the database. After the upgrade I get this in my error logs

12:25:50 [org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:37 9)] SchemaManager: Fail
ed to execute SQL:
ALTER TABLE jiveRoster ADD INDEX jiveRoster_jid_idx (jid);
2008.08.27 12:25:50 [org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:269)]
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: BLOB/TEXT column 'jid' used in key specification without a key length

I have seen similar referenced in other posts, it seems that the schema requires some modification. I have tried to make these mods (specifying a length for jid) but it falls down as my database already has the tables it is trying to create, and I do not wish to drop the whole database and reapply the schema. Is there a fix for this in the pipeline? After the failure to apply this schema, subsequent openfire startups leave me with errors complaining about missing tables, speficically ofID. I have tried downgrading again to my previous version but that does not work now either, any help with this would be greatly appreciated.

Cheers,

Sebastian Clarke

Report Abuse
Like (0)

Daniel Henninger
2,972 posts since
Aug 10, 2005

Currently Being Moderated

Aug 27, 2008 7:37 AM (in response to Sebastian Clarke)
Re: Openfire 3.6.0 has been released!

Hrm. This is MySQL! What the crap? I'm betting that was a failing in script 14 --- what version of Openfire were you upgrading from? Looks like this script is missing the ... well you can edit (or manually run) the script and replace jid wth jid(1024) and that should do it.
seb_llgc wrote:

Hey,

I have the same problem as above. The upgrade/install using the RPM worked fine but it was unable to make the neccasary modifications to the database. After the upgrade I get this in my error logs

12:25:50 [org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:37 9)] SchemaManager: Fail
ed to execute SQL:
ALTER TABLE jiveRoster ADD INDEX jiveRoster_jid_idx (jid);
2008.08.27 12:25:50 [org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:269)]
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: BLOB/TEXT column 'jid' used in key specification without a key length

I have seen similar referenced in other posts, it seems that the schema requires some modification. I have tried to make these mods (specifying a length for jid) but it falls down as my database already has the tables it is trying to create, and I do not wish to drop the whole database and reapply the schema. Is there a fix for this in the pipeline? After the failure to apply this schema, subsequent openfire startups leave me with errors complaining about missing tables, speficically ofID. I have tried downgrading again to my previous version but that does not work now either, any help with this would be greatly appreciated.

Cheers,

Sebastian Clarke

Report Abuse

Like (0)
- Sebastian Clarke
  8 posts since
  Dec 4, 2007
  
  Currently Being Moderated
  
  Aug 27, 2008 7:47 AM (in response to Daniel Henninger)
  Re: Openfire 3.6.0 has been released!
  
  jadestorm wrote:
  
  Hrm. This is MySQL! What the crap? I'm betting that was a failing in script 14 --- what version of Openfire were you upgrading from? Looks like this script is missing the ... well you can edit (or manually run) the script and replace jid wth jid(1024) and that should do it.
  
  I was upgrading from 3.5.2-1 I think. I did try editing the script, but it wont run because I already have the tables its trying to add in my database, it looks like my only choice is to manually run it line by line, changing it where neccessary, and not running the lines that would replace tables I already have.
  
  Seb
  
  Report Abuse
  
  Like (0)
  - Daniel Henninger
    2,972 posts since
    Aug 10, 2005
    
    Currently Being Moderated
    
    Aug 27, 2008 7:56 AM (in response to Sebastian Clarke)
    Re: Openfire 3.6.0 has been released!
    
    seb_llgc wrote:
    
    jadestorm wrote:
    
    Hrm. This is MySQL! What the crap? I'm betting that was a failing in script 14 --- what version of Openfire were you upgrading from? Looks like this script is missing the ... well you can edit (or manually run) the script and replace jid wth jid(1024) and that should do it.
    
    I was upgrading from 3.5.2-1 I think. I did try editing the script, but it wont run because I already have the tables its trying to add in my database, it looks like my only choice is to manually run it line by line, changing it where neccessary, and not running the lines that would replace tables I already have.
    
    Seb
    
    Yes unfortunately some of the tables will exist since it partially completed. =/ Hrm. Unless you've already completed the upgrade procedure, can you share with me what's in your ofVersion table (or jiveVersion if it hasn't been renamed yet)
    
    Report Abuse
    
    Like (0)
    - Sebastian Clarke
      8 posts since
      Dec 4, 2007
      
      Currently Being Moderated
      
      Aug 27, 2008 8:10 AM (in response to Daniel Henninger)
      Re: Openfire 3.6.0 has been released!
      
      jadestorm wrote:
      
      Yes unfortunately some of the tables will exist since it partially completed. =/ Hrm. Unless you've already completed the upgrade procedure, can you share with me what's in your ofVersion table (or jiveVersion if it hasn't been renamed yet)
      It says 13, and its jiveVersion like all my tables. I have downgraded, and it still doesnt work, so I tried to mod the mysql script to put in TEXT lengths where required, but when I run the upgrade again this is overridden and I get the same problems. It simply seems to be that the sql changes bomb out after hitting this jid error, and no changes are made at all to my database, then on subsequent runs, obviously all the tables are named wrong.
      
      Seb
      
      Report Abuse
      
      Like (0)
      - Daniel Henninger
        2,972 posts since
        Aug 10, 2005
        
        Currently Being Moderated
        
        Aug 27, 2008 8:55 AM (in response to Sebastian Clarke)
        Re: Openfire 3.6.0 has been released!
        
        seb_llgc wrote:
        
        jadestorm wrote:
        
        Yes unfortunately some of the tables will exist since it partially completed. =/ Hrm. Unless you've already completed the upgrade procedure, can you share with me what's in your ofVersion table (or jiveVersion if it hasn't been renamed yet)
        It says 13, and its jiveVersion like all my tables. I have downgraded, and it still doesnt work, so I tried to mod the mysql script to put in TEXT lengths where required, but when I run the upgrade again this is overridden and I get the same problems. It simply seems to be that the sql changes bomb out after hitting this jid error, and no changes are made at all to my database, then on subsequent runs, obviously all the tables are named wrong.
        
        Seb
        13?? What version of Openfire did you say you were at again? (before upgrading)
        
        Report Abuse
        
        Like (0)
        
        Sebastian Clarke
        8 posts since
        Dec 4, 2007
        
        Currently Being Moderated
        
        Aug 27, 2008 9:03 AM (in response to Daniel Henninger)
        Re: Openfire 3.6.0 has been released!
        
        I thought it was 3.5.2-1
        
        Seb
        
        Report Abuse
        
        Like (0)
        
        Shane Rimmer
        12 posts since
        Mar 1, 2007
        
        Currently Being Moderated
        
        Aug 27, 2008 1:09 PM (in response to Sebastian Clarke)
        Re: Openfire 3.6.0 has been released!
        
        I responded in the wrong thread
        
        Report Abuse
        
        Like (0)

Daniel Henninger

2,972 posts since
Aug 10, 2005

Currently Being Moderated

Aug 27, 2008 7:57 AM (in response to Daniel Henninger)

Re: Openfire 3.6.0 has been released!

Is anyone actually having success with the new release? I upgraded 4 different servers with different starting versions, different things installed, etc and they all went smoothly so I'm a little unhinged to see so many issues creeping up.

Report Abuse
Like (0)

David Thor
23 posts since
Apr 16, 2007

Currently Being Moderated

Aug 27, 2008 8:13 AM (in response to Daniel Henninger)
Re: Openfire 3.6.0 has been released!

We have tried the upgrade on three different servers... all running 3.5.2 with auth against Active directory and DB of MSFT SQL. ALl have failed during the install on database schema error when trying to upgrade from 16 to 20

A restore has sucessfully put things back together

Report Abuse

Like (0)
- Daniel Henninger
  2,972 posts since
  Aug 10, 2005
  
  Currently Being Moderated
  
  Aug 27, 2008 8:56 AM (in response to David Thor)
  Re: Openfire 3.6.0 has been released!
  
  dthor wrote:
  
  We have tried the upgrade on three different servers... all running 3.5.2 with auth against Active directory and DB of MSFT SQL. ALl have failed during the install on database schema error when trying to upgrade from 16 to 20
  
  A restore has sucessfully put things back together
  What specifically are you seeing as the database schema error? I don't have the slightest idea what MSFT SQL is btw.
  
  Report Abuse
  
  Like (0)

Martin Stein

3 posts since
Aug 27, 2008

Currently Being Moderated

Aug 27, 2008 8:13 AM (in response to Daniel Henninger)

Re: Openfire 3.6.0 has been released!

Well, I'm looking for the Mac-version but can't download it from the downloads-page. It also shows there as 0MB.

Report Abuse
Like (0)

Daniel Henninger
2,972 posts since
Aug 10, 2005

Currently Being Moderated

Aug 27, 2008 8:52 AM (in response to Martin Stein)
Re: Openfire 3.6.0 has been released!

excomedia wrote:

Well, I'm looking for the Mac-version but can't download it from the downloads-page. It also shows there as 0MB.
Sorry about that, named it wrong, mac version is up there now.

Report Abuse

Like (0)

Zwooiq

2 posts since
Aug 27, 2008

Currently Being Moderated

Aug 27, 2008 8:28 AM (in response to Daniel Henninger)

Re: Openfire 3.6.0 has been released!

LDAP DN values quote wrapping doesn't work when one of its RDN's contains one char only.

LdapManager.java:

dnPattern = Pattern.compile("([^\\\\]=)([^\"].*?[^\\\\])(,|$)");

Wrong user DN wrapping:

uid=user,ou=Users,dc=a,dc=example,dc=com => uid="user",ou="Users",dc="a,dc=example",dc="com"

Result: it's impossible to setup Openfire with LDAP authentication because it doesn't see the users in LDAP:

2008.08.27 15:25:34 [org.jivesoftware.admin.LdapUserTester.getAttributes(LdapUserTester.java:183)]
javax.naming.NameNotFoundException: [LDAP: error code 32 - No Such Object]; remaining name 'uid="user",ou="Users",dc="a,dc=example",dc="com"'
        at com.sun.jndi.ldap.LdapCtx.mapErrorCode(Unknown Source)
        at com.sun.jndi.ldap.LdapCtx.processReturnCode(Unknown Source)
        at com.sun.jndi.ldap.LdapCtx.processReturnCode(Unknown Source)
        at com.sun.jndi.ldap.LdapCtx.c_getAttributes(Unknown Source)
        at com.sun.jndi.toolkit.ctx.ComponentDirContext.p_getAttributes(Unknown Source)
        at com.sun.jndi.toolkit.ctx.PartialCompositeDirContext.getAttributes(Unknown Source)
        at com.sun.jndi.toolkit.ctx.PartialCompositeDirContext.getAttributes(Unknown Source)
        at javax.naming.directory.InitialDirContext.getAttributes(Unknown Source)
        at org.jivesoftware.admin.LdapUserTester.getAttributes(LdapUserTester.java:160)
        at org.jivesoftware.openfire.admin.setup.setup_002dldap_002duser_005ftest_jsp._jsp Service(setup_002dldap_002duser_005ftest_jsp.java:97)
        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.ja va:1093)
        at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:39)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)
        at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:66)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)
        at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingF ilter.java:42)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)
        at org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:70)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)
        at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:99)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va: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(ContextHandlerCollect ion.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.j ava: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)

Report Abuse
Like (0)

Daniel Henninger
2,972 posts since
Aug 10, 2005

Currently Being Moderated

Aug 27, 2008 9:01 AM (in response to Zwooiq)
Re: Openfire 3.6.0 has been released!

Zwooiq wrote:

LDAP DN values quote wrapping doesn't work when one of its RDN's contains one char only.

LdapManager.java:

dnPattern = Pattern.compile("([^\\\\]=)([^\"].*?[^\\\\])(,|$)");

Wrong user DN wrapping:

uid=user,ou=Users,dc=a,dc=example,dc=com => uid="user",ou="Users",dc="a,dc=example",dc="com"

Result: it's impossible to setup Openfire with LDAP authentication because it doesn't see the users in LDAP:

2008.08.27 15:25:34 [org.jivesoftware.admin.LdapUserTester.getAttributes(LdapUserTester.java:183)]
javax.naming.NameNotFoundException: [LDAP: error code 32 - No Such Object]; remaining name 'uid="user",ou="Users",dc="a,dc=example",dc="com"'
        at com.sun.jndi.ldap.LdapCtx.mapErrorCode(Unknown Source)
        at com.sun.jndi.ldap.LdapCtx.processReturnCode(Unknown Source)
        at com.sun.jndi.ldap.LdapCtx.processReturnCode(Unknown Source)
        at com.sun.jndi.ldap.LdapCtx.c_getAttributes(Unknown Source)
        at com.sun.jndi.toolkit.ctx.ComponentDirContext.p_getAttributes(Unknown Source)
        at com.sun.jndi.toolkit.ctx.PartialCompositeDirContext.getAttributes(Unknown Source)
        at com.sun.jndi.toolkit.ctx.PartialCompositeDirContext.getAttributes(Unknown Source)
        at javax.naming.directory.InitialDirContext.getAttributes(Unknown Source)
        at org.jivesoftware.admin.LdapUserTester.getAttributes(LdapUserTester.java:160)
        at org.jivesoftware.openfire.admin.setup.setup_002dldap_002duser_005ftest_jsp._jsp Service(setup_002dldap_002duser_005ftest_jsp.java:97)
        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.ja va:1093)
        at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:39)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)
        at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:66)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)
        at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingF ilter.java:42)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)
        at org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:70)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)
        at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:99)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va: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(ContextHandlerCollect ion.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.j ava: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)
Ack what the crap? Try setting: ldap.encloseDNs   to false
Lets see if that gets you running.

Report Abuse

Like (0)
- Zwooiq
  2 posts since
  Aug 27, 2008
  
  Currently Being Moderated
  
  Aug 28, 2008 4:02 AM (in response to Daniel Henninger)
  Re: Openfire 3.6.0 has been released!
  
  Just wanted to say that 3.5.2 doesn't have this problem, I suppose regexp pattern has been changed in 3.6.0
  
  With "ldap.encloseDNs=false" it continues to wrap the DN by quotes but not the BaseDN part, so the result is
  
  uid="user",ou="Users",dc="a,dc=company",dc=example,dc=com
  
  I've solved my problem by replacing regexp pattern in LdapManager.java:
  
  258c258
  < dnPattern = Pattern.compile("([^\\\\]=)([^\"].*?[^\\\\])(,|$)");
  ---
  > dnPattern = Pattern.compile("([^\\\\]=)([^\"]*?)(,|$)");
  
  Now I see the users in LDAP and can log in.
  
  Report Abuse
  
  Like (0)
  - Daniel Henninger
    2,972 posts since
    Aug 10, 2005
    
    Currently Being Moderated
    
    Aug 28, 2008 7:51 AM (in response to Zwooiq)
    Re: Openfire 3.6.0 has been released!
    
    I fixed it, though slightly differently, in trunk, Will be fixed in 3.6.0a. Good find though! I'm a little dismayed that it's wrapping the DN even though you set it to false though. =/
    IZwooiq wrote:
    
    Just wanted to say that 3.5.2 doesn't have this problem, I suppose regexp pattern has been changed in 3.6.0
    
    With "ldap.encloseDNs=false" it continues to wrap the DN by quotes but not the BaseDN part, so the result is
    
    uid="user",ou="Users",dc="a,dc=company",dc=example,dc=com
    
    I've solved my problem by replacing regexp pattern in LdapManager.java:
    
    258c258
    < dnPattern = Pattern.compile("([^\\\\]=)([^\"].*?[^\\\\])(,|$)");
    ---
    > dnPattern = Pattern.compile("([^\\\\]=)([^\"]*?)(,|$)");
    
    Now I see the users in LDAP and can log in.
    
    Report Abuse
    
    Like (0)

Shane Rimmer

12 posts since
Mar 1, 2007

Currently Being Moderated

Aug 27, 2008 8:42 AM (in response to Daniel Henninger)

Re: Openfire 3.6.0 has been released!

Unfortunately, I cannot get this version working at all. If anyone has a link I can follow to obtain a copy of 3.5.3, I'd appreciate it.

After encountering issues updating the database, I performed a clean install. AD works and allows users to log into the system. Unfortunately, after about 10 minutes, everyone starts appearing as offline.

Report Abuse
Like (0)

David Thor
23 posts since
Apr 16, 2007

Currently Being Moderated

Aug 27, 2008 8:44 AM (in response to Shane Rimmer)
Re: Openfire 3.6.0 has been released!

Tried the same thing. A clean install sets up ok but noone is able to invite other contacts and eventually all users go offline

Report Abuse

Like (0)
Daniel Henninger
2,972 posts since
Aug 10, 2005

Currently Being Moderated

Aug 27, 2008 9:02 AM (in response to Shane Rimmer)
Re: Openfire 3.6.0 has been released!

srimmer wrote:

Unfortunately, I cannot get this version working at all. If anyone has a link I can follow to obtain a copy of 3.5.3, I'd appreciate it.

After encountering issues updating the database, I performed a clean install. AD works and allows users to log into the system. Unfortunately, after about 10 minutes, everyone starts appearing as offline.
3.5.3 was never released, 3.5.2 was out. Unfortunately I don't know what link would work to download it. However someone else in this thread ought to know.

Do you see anything in your logs after 10 minutes when everything starts appearing as offline? I've never heard of that!

Report Abuse

Like (0)
- Shane Rimmer
  12 posts since
  Mar 1, 2007
  
  Currently Being Moderated
  
  Aug 27, 2008 9:09 AM (in response to Daniel Henninger)
  Re: Openfire 3.6.0 has been released!
  
  It was 3.5.2. Sorry, it's been a long morning
  
  Sent from my iPhone
  
  On Aug 27, 2008, at 12:03 PM, "jadestorm" <webmaster@jivesoftware.com
  
  Report Abuse
  
  Like (0)
  - Joshua Weigner
    21 posts since
    Mar 7, 2007
    
    Currently Being Moderated
    
    Aug 27, 2008 9:15 AM (in response to Shane Rimmer)
    Re: Openfire 3.6.0 has been released!
    
    Here it is:
    http://www.igniterealtime.org/downloadServlet?filename=openfire/openfire_3_5_2.e xe
    
    I'm with you, I give up on this version for now.
    
    Report Abuse
    
    Like (0)
- Shane Rimmer
  12 posts since
  Mar 1, 2007
  
  Currently Being Moderated
  
  Aug 27, 2008 10:05 AM (in response to Daniel Henninger)
  Re: Openfire 3.6.0 has been released!
  
  I started seeing messages in the info log like the following:
  
  2008.08.27 11:29:36 Packet sent to unreachable address
  <iq type="get" to="srimmer@esi-intwebserve/spark" id="mir_43" from="jchambers@esi-intwebserve/Miranda">
  <query xmlns="jabber:iq:version"/>
  </iq>
  2008.08.27 11:29:36 Packet sent to unreachable address
  <iq type="get" to="srimmer@esi-intwebserve/spark" id="mir_44" from="jchambers@esi-intwebserve/Miranda">
  <query xmlns="http://jabber.org/protocol/disco#info"/>
  </iq>
  
  and this kind of stuff in my error log (WebEOC Administrator is an account on our system. I tried disabling it the user list.)
  
  2008.08.27 12:57:46 [org.jivesoftware.openfire.handler.PresenceUpdateHandler.process(PresenceUpdate Handler.java:164)
  ] Internal server error. Triggered by packet:
  <presence id="Tjqrw-29" from="srimmer@esi-intwebserve/spark">
  <status>Online</status>
  <priority>1</priority>
  <x xmlns="vcard-temp:x:update">
      <photo>477f393a195006d16c90594f40936bd5d5afb238</photo>
  </x>
  <x xmlns="jabber:x:avatar">
      <hash>477f393a195006d16c90594f40936bd5d5afb238</hash>
  </x>
  </presence>
  java.lang.IllegalArgumentException: Illegal JID: WebEOC Administrator@esi-intwebserve
      at org.xmpp.packet.JID.init(JID.java:395)
      at org.xmpp.packet.JID.<init>(JID.java:230)
      at org.xmpp.packet.Packet.setTo(Packet.java:163)
      at org.jivesoftware.openfire.roster.Roster.broadcastPresence(Roster.java:599)
      at org.jivesoftware.openfire.handler.PresenceUpdateHandler.broadcastUpdate(Presenc eUpdateHandler.java:283)
      at org.jivesoftware.openfire.handler.PresenceUpdateHandler.process(PresenceUpdateH andler.java:124)
      at org.jivesoftware.openfire.handler.PresenceUpdateHandler.process(PresenceUpdateH andler.java:112)
      at org.jivesoftware.openfire.handler.PresenceUpdateHandler.process(PresenceUpdateH andler.java:176)
      at org.jivesoftware.openfire.PresenceRouter.handle(PresenceRouter.java:134)
      at org.jivesoftware.openfire.PresenceRouter.route(PresenceRouter.java:70)
      at org.jivesoftware.openfire.spi.PacketRouterImpl.route(PacketRouterImpl.java:76)
      at org.jivesoftware.openfire.net.StanzaHandler.processPresence(StanzaHandler.java: 329)
      at org.jivesoftware.openfire.net.ClientStanzaHandler.processPresence(ClientStanzaH andler.java:85)
      at org.jivesoftware.openfire.net.StanzaHandler.process(StanzaHandler.java:253)
      at org.jivesoftware.openfire.net.StanzaHandler.process(StanzaHandler.java:175)
      at org.jivesoftware.openfire.nio.ConnectionHandler.messageReceived(ConnectionHandl er.java:133)
      at org.apache.mina.common.support.AbstractIoFilterChain$TailFilter.messageReceived (AbstractIoFilterChain.java:570)
      at org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageReceived(Ab stractIoFilterChain.java:299)
      at org.apache.mina.common.support.AbstractIoFilterChain.access$1100(AbstractIoFilt erChain.java:53)
      at org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.messageReceive d(AbstractIoFilterChain.java:648)
      at org.apache.mina.common.IoFilterAdapter.messageReceived(IoFilterAdapter.java:80)
      at org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageReceived(Ab stractIoFilterChain.java:299)
      at org.apache.mina.common.support.AbstractIoFilterChain.access$1100(AbstractIoFilt erChain.java:53)
      at org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.messageReceive d(AbstractIoFilterChain.java:648)
      at org.apache.mina.filter.codec.support.SimpleProtocolDecoderOutput.flush(SimplePr otocolDecoderOutput.java:58)
      at org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecF ilter.java:185)
      at org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageReceived(Ab stractIoFilterChain.java:299)
      at org.apache.mina.common.support.AbstractIoFilterChain.access$1100(AbstractIoFilt erChain.java:53)
      at org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.messageReceive d(AbstractIoFilterChain.java:648)
      at org.apache.mina.filter.executor.ExecutorFilter.processEvent(ExecutorFilter.java :239)
      at org.apache.mina.filter.executor.ExecutorFilter$ProcessEventsRunnable.run(Execut orFilter.java:283)
      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      at org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:51)
      at java.lang.Thread.run(Unknown Source)
  Caused by: org.jivesoftware.stringprep.StringprepException: Contains prohibited code points.
      at org.jivesoftware.stringprep.Stringprep.nodeprep(Stringprep.java:120)
      at org.xmpp.packet.JID.init(JID.java:350)
      ... 34 more
  
  This is from the log file from one of my Spark clients:
  Aug 27, 2008 10:15:33 AM org.jivesoftware.spark.util.log.Log error
  SEVERE:
  not-acceptable(406)
      at org.jivesoftware.smack.Roster.removeEntry(Roster.java:293)
      at org.jivesoftware.spark.ui.ContactList$19$2.run(ContactList.java:1554)
      at java.awt.event.InvocationEvent.dispatch(Unknown Source)
      at java.awt.EventQueue.dispatchEvent(Unknown Source)
      at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
      at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
      at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
      at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
      at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
      at java.awt.EventDispatchThread.run(Unknown Source)
  
  Report Abuse
  
  Like (0)

GrK

52 posts since
Jul 11, 2008

Currently Being Moderated

Aug 27, 2008 9:08 AM (in response to Daniel Henninger)

Re: Openfire 3.6.0 has been released!

Cool It seems to work correctly.

Fastpath ok, monitoring ok, LDAP ok.

Does anyone knows if the SIP plugin works correctly ? It can't make it works

______________________________

Sorry, the SIP phone plugin seems to work

Does the LDAP works really ? I'm unable to connect a client to my OpenFire server ...

Report Abuse
Like (0)

Maxime
61 posts since
Jul 25, 2007

Currently Being Moderated

Aug 27, 2008 11:43 AM (in response to GrK)
Re: Openfire 3.6.0 has been released!

LDAP works here.

Report Abuse

Like (0)

Joshua Weigner

21 posts since
Mar 7, 2007

Currently Being Moderated

Aug 27, 2008 9:12 AM (in response to Daniel Henninger)

Re: Openfire 3.6.0 has been released!

I gave up after the database failing to upgrade, and then reading these posts. I'll think i'll hold out for 3.6.1 since this one seems to have not been tested thoroughly enough. That's what I get for always wanting to upgrade to the latest thing right away....one of these days i'll learn my lesson

P.S. If anyone does have a link to the latest 3.5 version that would be great, as I'm running 3.5.0 right now and having some issues with that (everyone getting kicked off, requiring the service to be restarted). That's why I tried upgrading to 3.6.0 in the first place.

P.P.S

http://www.igniterealtime.org/downloadServlet?filename=openfire/openfire_3_5_2.e xe

Report Abuse
Like (0)

Daryl Herzmann
1,086 posts since
Mar 12, 2005

Currently Being Moderated

Aug 27, 2008 12:14 PM (in response to Joshua Weigner)
Re: Openfire 3.6.0 has been released!

re users getting kicked off, try setting xmpp.client.idle to -1 for your server settings on the admin console.

http://www.igniterealtime.org/community/thread/33728

daryl

Report Abuse

Like (0)

Maxime

61 posts since
Jul 25, 2007

Currently Being Moderated

Aug 27, 2008 11:48 AM (in response to Daniel Henninger)

Re: Openfire 3.6.0 has been released!

I've seen this feature : Hybrid auth provider

http://www.igniterealtime.org/issues/browse/ ~~JM-405~~

But how I can use it ?

Thx.

Report Abuse
Like (0)

Daniel Henninger
2,972 posts since
Aug 10, 2005

Currently Being Moderated

Aug 27, 2008 12:02 PM (in response to Maxime)
Re: Openfire 3.6.0 has been released!

Maxime81 wrote:

I've seen this feature : Hybrid auth provider
http://www.igniterealtime.org/issues/browse/ ~~JM-405~~

But how I can use it ?

Thx.
I'm sorry, would oyu mind posting another thread for this? I'd help you right now but I'm fighting fires with 3.6.0 =/ Don't want it to get lost in the flurry of messages.

All, please see: http://www.igniterealtime.org/community/message/177972#177972

Report Abuse

Like (0)

mabastos

1 posts since
Oct 20, 2008

Currently Being Moderated

Oct 21, 2008 9:44 AM (in response to Daniel Henninger)

Re: Openfire 3.6.0 has been released!

Solution:

1 - Edit openfire.xml. <setup>false</setup>

2 - chmod 777 /opt/openfire/conf/openfire.xml

Report Abuse
Like (0)

Aug 26, 2008 10:14 PM

Openfire 3.6.0 has been released!

Actions

More Like This

Bookmarked By (0)