I am trying to get Openfire to install on an Ubuntu virtual machine, however upon completing the web based installer, I am unable to login to the admin panel.

So far I:

• Installed using stock options
• Added database and built the structure using supplied SQL file
• Completed web based installer

I am now trying to login using username: admin and my password, however I constantly get a wrong username/password error. There is a record generated in the MySQL database showing the admin user with an encrypted password, and changing to an unencoded password doesn't work. What is the problem here?

-

I had the same issue, little know and it seems undocumented bug. Try rebooting the server after the you do the install.

Worked for me.

-
+1 I also had this same exact error on Ubuntu, and couldn't figure out what I was doing wrong. Turns out that I wasn't restarting the service after installing and configuring Openfire. A reboot shouldn't really be needed on a linux machine unless you're doing a kernel upgrade. –  Cory Plastek Jul 13 '09 at 18:54
This "trick" also works on Windows. –  alves Jul 30 '09 at 15:16
what alves said. I'd been bugging around for some while now. Trying to set new usernames and passwords. Read this. Did a clean install. Restarted the server after install, and SHAZAM! works like a charm. –  peirix Sep 17 '09 at 13:32
Same problem/solution on Fedora. –  saturdayplace Oct 26 '09 at 20:13
Don't mean to bump an old thread, but I came across this because I had the same problem. I didn't need to reboot the actual server, just restart the service. This was with version 3.6.4-1, so I'm not sure if this has change throughout the versions. –  pferate Feb 4 '11 at 22:41

I had to manually set the password, the setup page didn't save it. Restarting the server didn't help.

If you are using the embedded db on Windows, this will be in embedded-db/openfire.script:

INSERT INTO OFUSER VALUES('admin',NULL, ...

-
This worked like a charm for me! –  David Apr 1 '10 at 20:38
This worked for me. –  Alconis Jan 30 '12 at 14:00
This worked for me too, and since I'm only using Openfire as a XMPP server for a "kata" I don't care about security issues with this technique. –  Håkon K. Olafsen Mar 30 '14 at 18:37

however this is not programming related....

-
I have been through these steps before, however it didn't seem to help. The issue persists even when installing a mysql DB or embedded –  Lobe Jun 21 '09 at 4:16

We install and deploy OpenFire on Ubuntu fairly regularly. Here is a PARTIAL quick cut/paste from our internal company Wiki. We also pre-install webmin and/or virtualmin on some servers just to make things easier later on:

Pre Install

sudo -s

apt-get install sun-java6-jre

Installation

Install the openfire_3.6.2_all.deb using dpkg

dpkg -i openfire_3.6.2_all.deb

Create a MySQL database for Openfire

click privileges

Host: local

Under the section titled "Database for user" click the radio button "create database with same name and grant all privileges"

click 'go'

Web Interface

Open another tab on firefox and go to serverip:9090 (example: 123.0.0.59:9090) to continue the install using the web interface.

select english

Etc, etc, etc.

Hope this helps...

-
Without phpMyadmin: mysql -u root -p; create database openfire; GRANT ALL PRIVILEGES ON openfire.* TO openfire@localhost IDENTIFIED BY 'password'; FLUSH PRIVILEGES –  pauska Jul 24 '09 at 9:15

1. Shut down Openfire
2. As the Windows Administrator, Edit

C:\Program Files (x86)\Openfire\embedded-db\openfire.script

3. Change the line that looks something like this

to

4. Save the file, exit the editor

5. Restart Openfire
-

I installed openfire.deb package to ubuntu server and had the same problem: couldn't even login for the first time as admin. I did the following: chmod o+rx /usr/share/openfire

Turned out that users didn't have permissions to even read the directory. I don't know if that's right thing to do, but now i can log in :)

-

Had the same issue with an install on Windows using the embedded database option. Uninstall, wipe directory, reinstall did not fix it. Only a reboot would cure it

-

-

Restarting didn't do it for me, Following the advice above, I manually edited the openfire.script too (I was using embedded database) and then I was able to login just fine (Ubuntu 9.10)

-

I logged in successfully with an LDAP-authentication-based setup with MySQL server. I logged in as "admin" with the supposedly updated password, which is still "admin". I hope this helps someone else who's probably pulling their hair out just like me.

-

I installed and de-installed several times on Windows XP Profesional SP3 machine using the embedded database of Openfire 3.6.4. Could not login to adminconsole. The last install I rebooted directly after install and lets me log in now :)

I hope this helps the frustrating feeling of not getting to login while you just set the password!! Strange bug, though.

-

My install on CentOS 5.3 gave the same results. I am unable to login as admin after the install.

I restarted both the HTTP and Openfire server. Login was granted after that.

[root@server ~]# service httpd restart
Stopping httpd: [  OK  ]
Starting httpd: [  OK  ]

[root@server ~]# service openfire restart
Shutting down openfire:
Starting openfire:

-

See this complete tutorial for installing Openfire with fixing common problems.

http://www.expertcore.org/viewtopic.php?f=74&t=1851

-

Using Openfire 3.7.1 on Windows the password for user admin was admin, too -- no matter what I entered during the setup wizard.

Thanks to this answer I found the line

INSERT INTO OFUSER VALUES('admin','admin',NULL,'Administrator','admin@example.com','0','0')


in the embedded-db/openfire.script file so it was easy to figure out.

-

It defaults to "admin" for user, and "admin" for password even if you supply one with embedded on windows (Just fyi).

-

Make sure you are logging in with just the username and not the whole email address you used to create the account (eg. if you setup admin@example.com, login with just admin).

If you have punctuation or special characters in your login password, that will cause a problem - but in the OP's question, you are using an account with a valid password.

According to the official docs:

DELETE FROM OFPROPERTY WHERE NAME='admin.authorizedJIDs';


If you are using the embedded database, then you can run these queries by editing embedded-db/openfire.script

<admin>


Based on this page though, I suspect that this setting has been renamed to <authorizedUsernames> instead of <authorizedJIDs>

3. You can also rerun setup, though in my experience, that hasn't always helped.

edit /conf/openfire.xml and change the <setup> tag to false

4. For completeness, others have answered above that you can edit the ofuser table. [Haven't had much luck with that myself].

Don't forget to stop and restart openfire after making changes, including running setup. [Yes, I know that's silly. Do it anyways if you want OpenFire to work.]

-

I know there are lots of answers, but I found my source of frustration after I had changed the hostname for the server in openfire. The fix to let me log in:

1. go to sql and open table ofProperty in your openfire database
2. change admin.authorizedJIDs from me@oldhostname to me@newhostname; separate each user by a comma
3. Stop Openfire, and then start it again-- it will load the admins in to memory

Uninstalling openfire likely does not remove the sql database, so your issue will persist. Alternatively you can create a new database and reinstall to the new database.

-