jump to navigation

Installation Notes for Openfire July 28, 2009

Posted by Robert Harder in Uncategorized.

Following Google’s release of a reference implementation of the Wave protocol in Java form, I thought I’d give it a try, but installing Openfire, the XMPP-based backend, turned out to be the biggest challenge. Using the default installation, I could not log in to the admin console page. Many other people seem to have this same problem, and I could not find a solution online. I found the problem or rather, a workaround.

Short identification of the problem:

  1. The setup script did not save my admin password.
  2. The login script will not accept the default password admin, probably because it’s too short.

Short solution:

  1. Manually change the admin password in the database to something longer like admin! (but hopefully a stronger password than that).

I had tried all kinds of database settings during this ordeal, and at the end I was using SQLite (JDBC driver here), so I just edited the .sqlite3 file with the sqlite3 command line program to fix the password:

sudo sqlite3 /usr/local/openfire/embedded-db/openfire.sqlite3 “UPDATE ofUser SET plainPassword=’admin!’ WHERE username=’admin'”

Problem solved.


1. Rod - February 29, 2012

SQL error: no such table: ofUser


2. Hugh - August 1, 2012

Should be “of User” with the space..

3. Hugh - August 1, 2012

Robert, can you give more detail as to how you were able to use the sqlite driver?

4. Hugh - August 1, 2012

Nevermind, got it. Put the sqlite jdbc driver into the /lib folder, and have “org.sqlite.JDBC” as the connection type and “jdbc:sqlite:test.db” as the url

5. Incaltaminte Primii Pasi - October 21, 2014

bookmarked!!, І really like youг blog!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: