Ignite Realtime: Openfire 3.4.5 has been released ...

Up to Discussions in Openfire Support

28 Replies Last post: Feb 25, 2008 11:33 AM by Ole Rühaak

Daniel Henninger

2,933 posts since
Aug 10, 2005

Currently Being Moderated

Feb 7, 2008 2:30 PM

Openfire 3.4.5 has been released

We are pleased to announce the release of Openfire 3.4.5! This release includes a brand new database connection pool implementation, which handles database outages in a much smoother manner. It also includes some admin interface robustness improvements and a small memory leak fix. You can view the full change log here.

The SparkWeb client included in the Enterprise edition has been updated too. A wealth of bug fixes and improvements have been made, including support for configuration of MUC rooms, MUC room search support, and autologin improvements. You can use the SparkWeb client from here.

Download Openfire from here.

Download Openfire Enterprise from here.

Download Connection Manager from here

Enjoy!

Openfire Team

Tags: openfire, release, update

Michael83

3 posts since
Feb 9, 2008

Currently Being Moderated

Feb 9, 2008 7:56 AM

in response to: Daniel Henninger

Re: Openfire 3.4.5 has been released

Hi,

i just updated from 3.4.4 and I have a small problem: The version shown in the admin panel is still 3.4.4. I never had that problem before and I just followed the steps in the upgrade guide in the documentation. Is this a problem with my installation or is there's something wrong in the download package?

Thanks!

Michael

Report Abuse

wroot

3,293 posts since
Jan 24, 2005

Currently Being Moderated

Feb 10, 2008 7:56 AM

in response to: Michael83

Re: Openfire 3.4.5 has been released

Well, it shows 3.4.5 for me in Admin Console. Either with tar.gz or exe installation.

Report Abuse

Gaston Dombiak

3,771 posts since
Sep 26, 2001

Currently Being Moderated

Feb 10, 2008 11:22 AM

in response to: Michael83

Re: Openfire 3.4.5 has been released

Hey Michael,

What do you see in the info.log? If you see there 3.4.5 but 3.4.4 in the admin console then your browser is caching an old page. To force a refresh press Shift-F5. Otherwise, for some reason the lib/openfire.jar file was not replaced with the new one.

Regards,

-- Gato

Report Abuse

Michael83

3 posts since
Feb 9, 2008

Currently Being Moderated

Feb 10, 2008 11:31 AM

in response to: Daniel Henninger

Re: Openfire 3.4.5 has been released

The info.log shows this line:

"2008.02.09 14:40:42 Openfire 3.4.5 09.02.2008 14:40:42"

But on the entry page of the admin panel version 3.4.4 is shown and there's the message that a new version is available. I'm using the tar.gz package and I followed the steps in the dokumentation: http://www.igniterealtime.org/builds/openfire/docs/latest/documentation/upgrade- guide.html

I updated several times before without any problems.

Thanks,

Michael

Report Abuse

Daniel Henninger

2,933 posts since
Aug 10, 2005

Currently Being Moderated

Feb 10, 2008 12:06 PM

in response to: Michael83

Re: Openfire 3.4.5 has been released

Do you have enterprise? If so have you also upgraded the enterprise plugin to 3.4.5?

I can't imagine why you'd be seeing 3.4.4 though. =/ Unless the old one is still running somewhere? Make sure there's no lingering java processes from the old version. (or restart the server entirely if that's easier)

Report Abuse

Michael83

3 posts since
Feb 9, 2008

Currently Being Moderated

Feb 10, 2008 12:21 PM

in response to: Daniel Henninger

Re: Openfire 3.4.5 has been released

No, I'm running the GPL version. I already restarted the server but the problem still exists. I deleted the entire folder of the former version it's really weired.

Report Abuse

Aleksandr

2 posts since
Feb 11, 2008

Currently Being Moderated

Feb 11, 2008 5:52 AM

in response to: Daniel Henninger

Re: Openfire 3.4.5 has been released

with openfire 3.4.5 GPL ver. i have a problem connecting (or creating a fresh new) to Oracle DB. with openfire 3.4.4 it's OK.

Database and Version:

Oracle

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production

With the Partitioning, OLAP and Data Mining options

JDBC Driver:

Oracle JDBC driver

JDBC Driver Version:

10.2.0.3.0

va Version:	1.6.0_04 Sun Microsystems Inc. -- Java HotSpot(TM) Server VM
Appserver:	jetty-6.1.x
OS / Hardware:	Linux / i386

error.log is attached.

thanks for help.

Attachments:

error.log (9.8 K)

Report Abuse

Andrew

4 posts since
Feb 11, 2008

Currently Being Moderated

Feb 11, 2008 7:12 AM

in response to: Aleksandr

Re: Openfire 3.4.5 has been released

I am have the exact same issue with Oracle on the mac, tried several Oracle JDBC driver versions.

Java HotSpot(TM) Client VM (build 1.5.0_13-121, mixed mode, sharing)

Not attaching a log, as it matches azagzin's log file almost verbatim.

Help...

Report Abuse

Andrew

4 posts since
Feb 11, 2008

Currently Being Moderated

Feb 11, 2008 9:06 AM

in response to: Andrew

Re: Openfire 3.4.5 has been released

putting openfire in debug nets:

2008.02.11 10:03:58 Proxool statistics legend: "s - r (a/t/o)" > s=served, r=refused (only shown if non-zero), a=active, t=total, o=offline (being tested)

2008.02.11 10:03:58 000000 (01/01/00) - Connection #1 created on demand = ACTIVE

2008.02.11 10:03:58 A connection failed the validation test with error: java.sql.SQLException: ORA-00923: FROM keyword not found where expected

Seems that there is an issue with whatever SQL is being used to TEST the connection.

Report Abuse

Daniel Henninger

2,933 posts since
Aug 10, 2005

Currently Being Moderated

Feb 11, 2008 9:30 AM

in response to: Andrew

Re: Openfire 3.4.5 has been released

You're kidding me, ORACLE can't do a SELECT 1?

I swear...

Ok, for now, you can get around this by editing openfire.xml .. look for:

com.mysql.jdbc.Driver jdbc:mysql://localhost:3306/wildfire_db XXX XXX 5 15 0.5 and add the two lines below, testBeforeUse and testAfterUse (setting them to false) com.mysql.jdbc.Driver jdbc:mysql://localhost:3306/wildfire_db XXX XXX 5 15 0.5 false false Alternatively, if you know of the quickest operation you can come up with that you can perform under oracle without it throwing a hissy fit to test the connection ... instead of adding testBeforeUse and testAfterUse, you can add whatever the sql is]]>.

It baffles me that Oracle won't allow that....

Report Abuse

Andrew

4 posts since
Feb 11, 2008

Currently Being Moderated

Feb 11, 2008 9:34 AM

in response to: Daniel Henninger

Re: Openfire 3.4.5 has been released

that did it, i ended up using "select * from dual" for testSQL.

thanks for the help.

Report Abuse

Daniel Henninger

2,933 posts since
Aug 10, 2005

Currently Being Moderated

Feb 11, 2008 9:37 AM

in response to: Andrew

Re: Openfire 3.4.5 has been released

Awesome!

From dual? What's that?

Report Abuse

Daniel Henninger

2,933 posts since
Aug 10, 2005

Currently Being Moderated

Feb 11, 2008 9:38 AM

in response to: Daniel Henninger

Re: Openfire 3.4.5 has been released

Ah, a dummy table. MySQL seems to have it too. I wonder if all of the others have it?

Report Abuse

Andrew

4 posts since
Feb 11, 2008

Currently Being Moderated

Feb 11, 2008 9:41 AM

in response to: Daniel Henninger

Re: Openfire 3.4.5 has been released

actually, one could do a select 1 from dual as well.

DUAL is a table which is created by oracle along with the data dictionary. It consists of exactly one column whose name is dummy and one record. The value of that record is X. The owner of dual is SYS but dual can be accessed by every user. As dual contains exactly one row (unless someone fiddled with it), it is guaranteed to return exactly one row in select statements. Therefor, dual is the prefered table to select a pseudo column (such as sysdate

select sysdate from dual).

above paraphrased from:

http://www.adp-gmbh.ch/ora/misc/dual.html

Report Abuse

Daniel Henninger

2,933 posts since
Aug 10, 2005

Currently Being Moderated

Feb 11, 2008 9:47 AM

in response to: Andrew

Re: Openfire 3.4.5 has been released

Unfortunately, it appears it is also not standard. =/ MySQL has it, SQL Server, Sybase, and some others don't. Arg.

Report Abuse

Michael Fabianski

7 posts since
Dec 1, 2003

Currently Being Moderated

Feb 11, 2008 10:10 AM

in response to: Daniel Henninger

Re: Openfire 3.4.5 has been released

I encountered the same problem with Oracle and was about to post my findings here - shame I didn't wait till tomorrow to perform the upgrade!

I added <testSQL>SELECT 1 FROM DUAL</testSQL> to the defaultProvider configuration.

Report Abuse

Daniel Henninger

2,933 posts since
Aug 10, 2005

Currently Being Moderated

Feb 11, 2008 10:43 AM

in response to: Michael Fabianski

Re: Openfire 3.4.5 has been released

I don't suppose I could ask if we have folk using and whether you had success with 3.4.5:

1. SQL Server (Microsoft's server)

2. Sybase

3. Postgres

4. IBM's DB2

Just for my own comfort, I'd like to hear someone give a thumbs up to each of these. From the research I just did, the rest -should- be fine. (IE, Oracle is the only one that doesn't like a SELECT without a FROM)

Report Abuse

Ole Rühaak

5 posts since
Feb 21, 2008

Currently Being Moderated

Feb 21, 2008 7:01 AM

in response to: Daniel Henninger

Re: Openfire 3.4.5 has been released

Nope - same trouble with DB2 9. Tried updating an Openfire 3.3.3 to 3.4.5.

I've spent some hours trying to make the update run. A little bit more testing before getting the release out would have been nice ...

I will try the workaround mentioned above. Hope it'll to the trick.

Report Abuse

Daniel Henninger

2,933 posts since
Aug 10, 2005

Currently Being Moderated

Feb 21, 2008 8:43 AM

in response to: Ole Rühaak

Re: Openfire 3.4.5 has been released

Let us know if it works so we can make the appropriate adjustment.

Report Abuse

Ole Rühaak

5 posts since
Feb 21, 2008

Currently Being Moderated

Feb 21, 2008 9:35 AM

in response to: Daniel Henninger

Re: Openfire 3.4.5 has been released