2 Replies Latest reply on Oct 25, 2016 12:49 AM by cirius

    Openfire 4.0.3 wrong id or pass

    Ahmet

      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!

        • Re: Openfire 4.0.3 wrong id or pass
          Benjamin Ng

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

          • Re: Openfire 4.0.3 wrong id or pass
            cirius

            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);