powered by Jive Software

Openfire 4.0.3 wrong id or pass

Openfire application I installed for the first time. I select the default profile option in the settings section.

Then follows a note on the curren account password of the admin section = "If this is a new installation , the current password will be ‘admin’ " as well as the current password instead of ‘admin’ I wrote.

I also e- mail new password and filled parts and I pressed the button contiune. It gave such an error =“There were errors when updating the admin account. Please see below.” ->Please enter the correct current password.

Please help me!

I have the same problem and do not know how to fix it

If you are using DB server’s Config below

  • Using MySQL 5.1 (or later) or Mariadb 10.1 (or later)

  • Charset set to** Utf8mb4 on INNODB**

You can happen to error in the DBscript file during Openfire Setting.

You must modify the script file (file location openfire / resources / database / openfie_mysql.sql) as shown below.

For more information, please refer to MySQL, Mariadb barracuda file format information.

CREATE TABLE ofMucService (

serviceID BIGINT (20) NOT NULL,

subdomain VARCHAR (255) NOT NULL,

description VARCHAR (255) DEFAULT NULL,

isHidden TINYINT (4) DEFAULT NULL,

PRIMARY KEY (subdomain),

UNIQUE KEY ofMucService_serviceid_idx (serviceID)

) ENGINE = INNODB DEFAULT CHARSET = utf8mb4** ROW_FORMAT = DYNAMIC;**

If the same error occurs,

Run the script below, and please continue the installation.

Entry for admin user

INSERT INTO ofUser (username, plainPassword, name, email, creationDate, modificationDate)

VALUES ( 'admin', 'admin', 'Administrator', 'admin@example.com', '0', '0');

Entry for default conference service

INSERT INTO ofMucService (serviceID, subdomain, isHidden) VALUES (1, ‘conference’, 0); INSERT INTO

ofUser (username, plainPassword, name, email, creationDate, modificationDate)

VALUES ( 'admin', 'admin', 'Administrator', 'admin@example.com', '0', '0');

Entry for default conference service

INSERT INTO ofMucService (serviceID, subdomain, isHidden) VALUES (1, ‘conference’, 0);