Openfire Installation Issue - Can't Login to admin panel

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.

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, ...

Change the NULL to your password. Then restart your OpenFire server.

Openfire Admin Login How to change Openfire's admin login when using Windows Vista and an embedded database:

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

   INSERT INTO OFUSER VALUES('admin',NULL,'', 'Administrator','admin','0','0')

   to

   INSERT INTO OFUSER VALUES('admin','',NULL, 'Administrator','admin','0','0')

4. Save the file, exit the editor

5. Restart Openfire

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 update && apt-get dist-upgrade

mkdir /home/kpwadmin/openfire-install

mkdir /home/kpwadmin/virtualmin-install

cd /home/kpwadimn/virtualmin-install

apt-get install sun-java6-jre

Installation

Download the latest .deb package from openfire.org. We will use the 3.6.2 version of Openfire in this article.

cd /home/oacadmin/openfire-install

wget http://www.igniterealtime.org/downloadServlet?filename=openfire/openfire_3.6.2_all.deb

Install the openfire_3.6.2_all.deb using dpkg

dpkg -i openfire_3.6.2_all.deb

Create a MySQL database for Openfire

Launch firefox and go to serverip/phpmyadmin (example: 72.11.123.59/phpmyadmin), login to phpmyadmin as root.

click privileges

add a new user

Username: openfire

Host: local

Password: "something secure"

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...

http://blog.taragana.com/index.php/archive/how-to-recover-openfire-admin-password/

however this is not programming related....

If its on Ubuntu 16.04, then try to use "openfire_3.9.3_all" debian package instead of latest "openfire_4.1.0_all". Latest package is buggy during your installation process of filling new password details. That problem is not solved. Better to use previous version. Its work fine.

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.

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 [email protected], 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:

1. Reset or add the admin info in the ofproperty table:

   DELETE FROM OFPROPERTY WHERE NAME='admin.authorizedJIDs';
   INSERT INTO OFPROPERTY VALUES('admin.authorizedJIDs','admin@example-com,[email protected]');
   

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

2. Or add another admin to the conf.xml.

   <admin>
       <authorizedJIDs>[email protected], [email protected]</authorizedJIDs>
   </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.]

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

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','[email protected]','0','0')

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