Hello again!
Now I am trying to backup some MySQL databases via
this plugin -
https://github.com/bareos/bareos-contrib/tree/master/fd-plugins/mysql-python
I have changed my conf files as described in wiki, but still have got no luck:
# tail -n 11 /etc/bareos/bareos-dir.d/filesets.conf
FileSet{
Name = "mysql-all-sbox"
Include {
Plugin =
"python:module_path=/usr/lib64/bareos/plugins:module_name=bareos-fd-mysql:mysqlhost=sbox-mysql.alx:mysqluser=backup:dumpotions=--skip-drop-table
--skip-add-locks --triggers --routines --events --flush-logs
--single-transaction:db=delirium_tremens_sub"
Options {
signature = MD5
compression = lz4
}
}
}
#
in bareos-dir.conf:
# MySQL backup via bpipe
JobDefs {
Name = "backup-mysql-db"
Type = Backup
Level = Incremental
FileSet = "mysql-all-sbox"
Schedule = "WeeklyCycle"
Storage = backup-dev-02
Messages = Standard
Pool = Incremental
Priority = 10
Write Bootstrap = "/var/lib/bareos/%c.bsr"
Full Backup Pool = Full
Differential Backup Pool = Differential
Incremental Backup Pool = Incremental
}
JobDefs {
Name = "restore-mysql-db"
Type = Restore
FileSet = "mysql-all-sbox"
Storage = backup-dev-02
Where = /tmp/bareos
Messages = Standard
Pool = Incremental
}
and jobs:
# cat /etc/bareos/bareos-dir.d/sbox-mysql-db.conf
Client {
Name = sbox-mysql-db
Address = sbox-mysql.alx
Password = "b+uWgGf0fPnUazdzdChaLQx3ZeYRRdEQGSlK5awU0v+6"
File Retention = 62 days # 62 days
Job Retention = 2 months # two months
AutoPrune = yes # Prune expired Jobs/Files
}
Job {
Name = "sbox-mysql-db-backup"
Client = "sbox-mysql-db"
JobDefs = "backup-mysql-db"
}
Job {
Name = "sbox-mysql-db-restore"
Client = "sbox-mysql-db"
JobDefs = "backup-mysql-db"
}
#
and I got this:
16-Sep 11:55 alx-msk-backup-01.alx JobId 1441: No prior Full backup Job record
found.
16-Sep 11:55 alx-msk-backup-01.alx JobId 1441: No prior or suitable Full backup
found in catalog. Doing FULL backup.
16-Sep 11:55 alx-msk-backup-01.alx JobId 1441: Start Backup JobId 1441,
Job=sbox-mysql-db-backup.2016-09-16_11.55.34_15
16-Sep 11:55 alx-msk-backup-01.alx JobId 1441: Using Device "backup-dev-02" to
write.
16-Sep 11:55 sbox-mysql.alx JobId 1441: Fatal error: ImportError: No module
named bareos-fd-mysql.py
16-Sep 11:55 sbox-mysql.alx JobId 1441: Fatal error: Failed to authenticate
Storage daemon.
16-Sep 11:55 alx-msk-backup-01.alx JobId 1441: Fatal error: Bad response to
Storage command: wanted 2000 OK storage
, got 2902 Bad storage
but, all necessary packages have been installed:
# rpm -qa | grep bareos | sort
bareos-15.2.2-37.1.el7.x86_64
bareos-bconsole-15.2.2-37.1.el7.x86_64
bareos-client-15.2.2-37.1.el7.x86_64
bareos-common-15.2.2-37.1.el7.x86_64
bareos-contrib-filedaemon-python-plugin-mysql-14.2.0.git.1452702859-4.1.el7.x86_64
bareos-database-common-15.2.2-37.1.el7.x86_64
bareos-database-mysql-15.2.2-37.1.el7.x86_64
bareos-database-postgresql-15.2.2-37.1.el7.x86_64
bareos-database-tools-15.2.2-37.1.el7.x86_64
bareos-director-15.2.2-37.1.el7.x86_64
bareos-director-python-plugin-15.2.2-37.1.el7.x86_64
bareos-filedaemon-15.2.2-37.1.el7.x86_64
bareos-filedaemon-ldap-python-plugin-15.2.2-37.1.el7.x86_64
bareos-filedaemon-python-plugin-15.2.2-37.1.el7.x86_64
bareos-storage-15.2.2-37.1.el7.x86_64
bareos-storage-python-plugin-15.2.2-37.1.el7.x86_64
bareos-tools-15.2.2-37.1.el7.x86_64
bareos-webui-15.2.2-41.1.el7.noarch
python-bareos-0.3.1472811641.9c22f56-39.1.el7.x86_64
#
# ls -lahi /usr/lib64/bareos/plugins/ | grep python
3936902 -rwxr-xr-x 1 root root 20K Dec 5 2015 python-dir.so
3932301 -rwxr-xr-x 1 root root 56K Dec 5 2015 python-fd.so
3936912 -rwxr-xr-x 1 root root 20K Dec 5 2015 python-sd.so
# ls -lahi /usr/lib64/bareos/plugins/ | grep -i mysql
3936917 -rwxr-xr-x 1 root root 8.5K Jan 15 2016 BareosFdMySQLclass.py
3936919 -rw-r--r-- 2 root root 6.0K Jan 15 2016 BareosFdMySQLclass.pyc
3936919 -rw-r--r-- 2 root root 6.0K Jan 15 2016 BareosFdMySQLclass.pyo
3936918 -rw-r--r-- 1 root root 1.1K Jan 15 2016 bareos-fd-mysql.py
3936920 -rw-r--r-- 2 root root 648 Jan 15 2016 bareos-fd-mysql.pyc
3936920 -rw-r--r-- 2 root root 648 Jan 15 2016 bareos-fd-mysql.pyo
#
--
You received this message because you are subscribed to the Google Groups
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
For more options, visit https://groups.google.com/d/optout.
