Home > Uncategorized > Installation Notes for Openfire

Installation Notes for Openfire

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.

Categories: Uncategorized Tags:
  1. Rod
    February 29th, 2012 at 06:44 | #1

    SQL error: no such table: ofUser

    ;(

  2. Hugh
    August 1st, 2012 at 10:02 | #2

    Should be “of User” with the space..

  3. Hugh
    August 1st, 2012 at 10:04 | #3

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

  4. Hugh
    August 1st, 2012 at 10:17 | #4

    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. October 21st, 2014 at 21:28 | #5

    bookmarked!!, І really like youг blog!

  1. No trackbacks yet.