I had the same error and here's how I fixed it on Debian 11 running Packetfence 12.2.
When running /usr/local/pf/addons/backup-and-maintenance.sh I got the error below, the files were created but there were either files or permissions missing from the export. Database backup will start Mariabackup is available. Will proceed using it for DB backup to avoid locking tables and easier recovery process. Not a Galera cluster, nothing to stop mariabackup was not successful. Not a Galera cluster, nothing to reenable If you look at /usr/local/pf/logs/innobackup.log you should see an error that looks like this [00] 2025-03-05 11:29:39 Error: missing required privilege RELOAD on *.* [00] 2025-03-05 11:29:39 Error: missing required privilege PROCESS on *.* Login as root to the local database and grant the permissions to the Packetfence database account. My database account is named pf and you will need to change the password used by that account. MariaDB [(none)]> grant reload on *.* to 'pf'@'localhost' identified by 'password'; MariaDB [(none)]> grant process on *.* to 'pf'@'localhost' identified by 'password'; MariaDB [(none)]> flush privileges; Nick Madunich IT System Administrator (509)359-4964 nmadunic...@ewu.edu<mailto:nmadunic...@ewu.edu> ________________________________ From: Arun Kangle via PacketFence-users <packetfence-users@lists.sourceforge.net> Sent: Saturday, October 26, 2024 8:35 AM To: packetfence-users@lists.sourceforge.net <packetfence-users@lists.sourceforge.net> Cc: Arun Kangle <akan...@gmail.com> Subject: [PacketFence-users] Error restoring database locally while preparing for 14.0 upgrade Hello All, Could any of you please help me to solve the below error? I am following the steps listed in upgrade guide to 14.0 with mariadb-backup installed root@aolicnac:~/backup/restore# /usr/bin/mariabackup --version /usr/bin/mariabackup based on MariaDB server 10.5.23-MariaDB debian-linux-gnu (x86_64) while executing the steps i am getting following error: root@aolicnac:~# gunzip /root/backup/packetfence-db-dump-innobackup-2024-10-26_20h27.xbstream.gz root@aolicnac:~# mkdir -p /root/backup/restore/ root@aolicnac:~# pushd /root/backup/restore/ ~/backup/restore ~ root@aolicnac:~/backup/restore# mv /root/backup/packetfence-db-dump-innobackup-2024-10-26_20h27.xbstream /root/backup/restore/. root@aolicnac:~/backup/restore# mbstream -x < packetfence-db-dump-innobackup-*.xbstream root@aolicnac:~/backup/restore# rm packetfence-db-dump-innobackup-*.xbstream root@aolicnac:~/backup/restore# mariabackup --prepare --target-dir=./ mariabackup based on MariaDB server 10.5.23-MariaDB debian-linux-gnu (x86_64) [00] 2024-10-26 20:57:13 cd to /root/backup/restore/ [00] 2024-10-26 20:57:13 open files limit requested 0, set to 1024 [00] FATAL ERROR: 2024-10-26 20:57:13 Can't open backup-my.cnf for reading root@aolicnac:~/backup/restore# Thanks in advance. - Arun
_______________________________________________ PacketFence-users mailing list PacketFence-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/packetfence-users
