Hi Nicolas,
Thanks for your reply.

As explained above, I installed the MariaDB-backup application following
the documentation as per install guide:

# yum install MariaDB-backup --enablerepo=packetfence

Given permission to the user 'pf' as per install guide:

[root@nac ~]# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 17462
Server version: 10.2.37-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

MariaDB [(none)]> GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO
'pf'@'localhost';
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> exit
Bye
[root@nac ~]#

And after that ran the maintenance script
"/usr/local/pf/addons/backup-and-maintenance.sh" to start the backup.

Here is the o/p from console and log:

[root@nac ~]# /usr/local/pf/addons/backup-and-maintenance.sh
/root/backup/ , folder already created.

tar: Removing leading `/' from member names
tar: Removing leading `/' from hard link targets
packetfence-files-dump have been created in  /root/backup/

packetfence-files-dump older than 7 days have been removed.

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
task bandwidth_maintenance_session finished
mariabackup was not successful.
Not a Galera cluster, nothing to reenable
[root@nac ~]#
[root@nac ~]#
[root@nac ~]# cat /usr/local/pf/logs/innobackup.log
[00] 2021-07-05 19:53:30 Connecting to MySQL server host: localhost, user:
, password: set, port: not set, socket: not set
[00] 2021-07-05 19:53:30 Failed to connect to MySQL server: Access denied
for user ''@'localhost' (using password: NO).
----- Backup started on 2021-07-06_00h30 -----
[00] 2021-07-06 00:30:30 Connecting to MySQL server host: localhost, user:
, password: set, port: not set, socket: not set
[00] 2021-07-06 00:30:30 Failed to connect to MySQL server: Access denied
for user ''@'localhost' (using password: NO).
----- Backup started on 2021-07-06_14h18 -----
[00] 2021-07-06 14:18:35 Connecting to MySQL server host: localhost, user:
, password: set, port: not set, socket: not set
[00] 2021-07-06 14:18:35 Failed to connect to MySQL server: Access denied
for user ''@'localhost' (using password: NO).
[root@nac ~]#

Thanks,
- Arun

On Tue, Jul 6, 2021 at 11:10 AM Quiniou-Briand, Nicolas <nquin...@akamai.com>
wrote:

> Hello Arun,
>
>
>
> How are you doing your backup with MariaDB-backup ?
>
> Please provide a Minimal, Complete and Verifiable example [1]
>
>
>
> [1] https://stackoverflow.com/help/minimal-reproducible-example
>
>
>
> *Nicolas Quiniou-Briand*
> *Product Support Engineer*
>
> *Office:* +33156696210
>
> Akamai Technologies
> 145 Broadway
> Cambridge, MA 02142
>
> Connect with Us:
>
> <https://community.akamai.com/>  <http://blogs.akamai.com/>
> <https://twitter.com/akamai>  <http://www.facebook.com/AkamaiTechnologies>
>   <http://www.linkedin.com/company/akamai-technologies>
> <http://www.youtube.com/user/akamaitechnologies?feature=results_main>
>
>
>
_______________________________________________
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users

Reply via email to