After 3.4.1 upgrade, users get "Invalid username or password."

Openfire Openfire Support
1

I did the upgrade from 3.3.1 to 3.4.1 based on the installation doc, and now users cannot log on. The install guide stated to stop the service, copy the directory, and run the install - all of which I did. I am running the enterprise version, and upgraded via the web console.

Thank you,

Steven

2

Hi Steven,

did the database upgrade succeed? Do you see errors in the log files?

LG

3

The install doc didn’t nention anything about the sql server upgrade - can you get that info to me?

4

Hi,

Openfire should update the database all by itself, the scripts are in the openfire/resources/database/upgrade/13 directory.

If you run “select * from jiveversion;” within your database it should return “openfire 13” and probably some more lines like “enterprise 10”.

LG

5

This is the result:

Enterprise 7

Gateway 4

Openfire 13

6

This is what is my log:

at org.jrobin.core.RrdDb.(Unknown Source)

at

com.jivesoftware.openfire.enterprise.stats.StatsEngine$SampleTask.run(St

atsEngine.java:323)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown

Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

2007.11.30 08:57:15

[com.jivesoftware.openfire.enterprise.stats.RrdSqlBackend.exists(RrdSqlB

ackend.java:190)

] Error while accessing information in database: java.sql.SQLException:

Invalid object name ‘entRRDs’.

2007.11.30 08:57:15

[com.jivesoftware.openfire.enterprise.stats.StatsEngine$SampleTask.run(S

tatsEngine.java:359)

] Error sampling for statistic muc_incoming

java.io.FileNotFoundException: Could not open muc_traffic

at org.jrobin.core.RrdDb.(Unknown Source)

at

com.jivesoftware.openfire.enterprise.stats.StatsEngine$SampleTask.run(St

atsEngine.java:323)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown

Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

7

Hi,

I think that you need to update your Enterprise Plugin to get rid of the RRD errors but this will likely not help with the login problem.

LG

8

I too am seeing this problem although it seems to go away after I reboot. After a few hours/days up it seems to occur again. I am also running the IM gateways, are you?

I believe this is because I am also seeing “java.lang.OutOfMemoryError: unable to create new native thread” in the error log. I am assuming this is the problem. I am running 3.3.3 though, so i dont think this is a 3.4.1 issue only.

9

So, I found the issue. After seeing the reoccurring attempt to upgrade the DB, it dawned on me that the upgrade never took on the DB side. The openfire user was set as a “user” in SQL, with no DBO rights. Changed to DBO, but the issue was not corrected. Gave it some SQL server-side rights temporarily, and then the changes were successful. Logins are normal now, and it seems that all functionality has returned. Cool.

Thanks for the posts!!