If you are using DB server’s Config below
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);