Schlagwörter: 

Ansicht von 3 Antwort-Themen
  • Autor
    Beiträge
    • #14938
      Gonçalo Faria
      Teilnehmer

        Hi,

        I am trying to do something as simple as creating a backup on a main host, move it to secondary host with otobo fresh installed and restore the backup from the main host, trying to make a DR strategy basically.

        When i try to restore with otobo running i have this error message:

        ERROR: Already existing tables in this database. A empty database is required for restore!

        When it try to restore with otobo stopped i have this message:

        DBI connect(‘database=otobo;host=db’,’otobo’,…) failed: Unknown MySQL server host ‘db’ (-3) at /opt/otobo_install/local/lib/perl5/DBIx/Connector.pm line 31.
        ERROR: OTOBO-restore.pl-08 Perl: 5.36.0 OS: linux Time: Mon Mar 20 16:23:38 2023

        Message: Unknown MySQL server host ‘db’ (-3)

        Traceback (1):
        Module: Kernel::System::DB::Prepare Line: 775
        Module: /opt/otobo/scripts/restore.pl Line: 179

        Can’t call method “fetchrow_array” on an undefined value at /opt/otobo/Kernel/System/DB.pm line 860.

        From the second message i assume it’s supposed to have it running, but should i wipe the DB before restoring?
        ps: i am following this guide https://doc.otobo.org/manual/installation/10.1/en/content/backup-restore.html

        Thank you very much,
        Best,
        Gf

      • #14943
        marcel-graf
        Teilnehmer

          hello Gonçalo ,

          I only used the backup and restore on a docker based installation.

          Here I had to set the same database password for the new installation.

          ———————————————————–

          mysql -u root -p
          Enter password: db password

          SET PASSWORD FOR ‘otobo’ = PASSWORD(‘the old One’);

          FLUSH PRIVILEGES;

          ———————————————————–

          and i think you must drop the DB

          ———————————————————–

          DROP DATABASE otobo;

          CREATE DATABASE otobo CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

          GRANT ALL PRIVILEGES ON otobo.* TO ‘otobo’@’%’;

          ———————————————————–

          Greetings,

          Marcel

           

           

        • #14953
          Gonçalo Faria
          Teilnehmer

            Thank you for the answer,

            I managed to install the database, but i couln’t login with the root@localhost account from the original DB.
            I will try to do a fresh install with a root@localhost password equal to the original DB, to check if i can see the data restored.

            Thank you for the answer.

            Best,
            Gf

          • #14960
            Stefan Abel
            Moderator

              Hello,

              If you don’t know the root@localhost password, you can always reset it with the bin/otobo.Console.pl

              Cheers,
              Stefan

          Ansicht von 3 Antwort-Themen
          • Du musst angemeldet sein, um auf dieses Thema antworten zu können.