Hi there… I’m having difficulty restoring from a created backup. The situation is we have the .tgz file which was created on a server (which recently failed with a RAID issue). I have built a new 20.04 ubuntu server (previous server was 18.04) and intalled the latest PrivacyIdea package 3.6 (previously was 3.5.1). I have copied the tgz file to the server and ran the “pi-manage backup restore” command but get the following output.
Also restoring enreyption key ‘enckey’
Restoring to /etc/privacyidea/pi.cfg with data from /var/lib/privacyidea/backup/dbdump-2021-233-1127.sql
ERROR 1045 (28000): Access denied for user ‘pi’@’‘localhost’ (using password: YES)
The restore partially works (for example the rlm_perl.ini file restores successfully) but i am no longer able to access the web server etc.
I feel like i am probably missing something obvious but have tried giving “everyone” full permissions to the tgz file and that hasn’t worked.
Could it be a problem restoring a 3.5.1 to a 3.6?
The backup was created with no encryption key and the .tgz file looks good to me, there is a sizeable .sql dump in there and all the config files.
Thanks in advance