Backup restore error

hazem · May 24, 2021, 5:16am

Hello,
I am running PrivacyIdea 3.5.2 on Ubuntu 20.04.1 LTS and i have been testing the backup and restore functionality. I did the backup as root and included the encryption keys.
root@test:~# pi-manage backup create -e
Output:
tar: Removing leading /' from member names tar: Removing leading /’ from hard link targets

When i attempt to restore, i get the below error.
root@test:~# pi-manage backup restore filename.tgz
Output:
Also restoring encryption key ‘enckey’
Restoring to /etc/privacyidea/pi.cfg with data from /var/lib/privacyidea/backup/dbdump-20210524-0912.sql
Restoring database.
mysql: [ERROR] unknown variable ‘no-tablespaces=True’.

Any idea why the restore is failing? I also tried restarting the services before and after but same result.

cornelinux · May 24, 2021, 10:15pm

This is a known issue that is resolved in the current master and will be shipped with 3.6.

github.com/privacyidea/privacyidea

restore breaks with pi-manage

opened 07:02AM - 19 May 21 UTC

closed 08:34AM - 19 May 21 UTC

cornelinux

Type: Bug

When you want to restore a backup using pi-manage you will run into the error: … ~~~~ mysql: [ERROR] unknown variable 'no-tablespaces=True'. ~~~~ This is due to the change introduced in #2454. The `no-tablespaces` parameter is not valid for *all* mysql client tools. We can fix this by changing in `pi-manage` the creation of the mysql client config: ~~~~python def _write_mysql_defaults(filename, username, password): """ Write the defaults_file for mysql commands :param filename: THe name of the file :param username: The username to connect to the database :param password: The password to connect to the database :return: """ with open(filename, "w") as f: f.write("""[client] user={0!s} password={1!s} [mysqldump] no-tablespaces=True""".format(username, password)) ~~~~ Having an explicit section for mysqldump ensures, that the no-tablespaces is only used for `mysqldump` but not for `mysql`.

You can simply look into the tgz backup file and restore manually.

hazem · May 26, 2021, 10:01am

Thank you, It worked!