View Issue Details

IDProjectCategoryView StatusLast Update
0001419bareos-core[All Projects] Generalpublic2022-01-10 10:33
ReporterTomasz_FilipekAssigned Tobruno-at-bareos 
PrioritynormalSeverityminorReproducibilityalways
Status assignedResolutionopen 
PlatformLinuxOSCentOSOS Version7
Product Version21.0.0 
Fixed in Version 
Summary0001419: Mariadb plugin - problem with incremental backup
DescriptionHi,

I have problem with incremental backup on mariadb plugin.

Fatal error: python-fd-mod: Could not get LSN with command "echo 'SHOW ENGINE INNODB STATUS' | mysql -r | grep 'Log sequence number' | awk '{ print $4 }'", Error: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
05-Jan 22:00 ala-fd JobId 6167: Fatal error: filed/fd_plugins.cc:681 PluginSave: Command plugin "python:module_path=/usr/lib64/bareos/plugins:module_name=bareos-fd-mariabackup:dumpbinary=mariabackup:dumpoptions=--backup --stream=xbstream -h 127.0.0.1 -u USER -p PASSWORD" requested, but job>

Everything is fine with a full backup.

I think there may be a problem with incremetal backup not adding authorization options to the mysql command.
Steps To ReproduceRun incremental backup.
Tagsmariadb
bareos-master: impact
bareos-master: action
bareos-19.2: impact
bareos-19.2: action
bareos-18.2: impact
bareos-18.2: action
bareos-17.2: impact
bareos-17.2: action
bareos-16.2: impact
bareos-16.2: action
bareos-15.2: impact
bareos-15.2: action
bareos-14.2: impact
bareos-14.2: action
bareos-13.2: impact
bareos-13.2: action
bareos-12.4: impact
bareos-12.4: action

Activities

bruno-at-bareos

bruno-at-bareos

2022-01-10 10:33

developer   ~0004460

Maybe you're missing the mycnf plugin configuration ?

If you have a look at the documentation (which still need to be published)
the access to mysql (most of the time by root) need to be automated by using .my.cnf technics and so and should works.
https://download.bareos.org/bareos/experimental/CD/PR-1016/BareosMainReference/TasksAndConcepts/Plugins.html?highlight=mariadb#mariadb-mariabackup-plugin

So in your case as user root
echo 'SHOW ENGINE INNODB STATUS' | mysql -r command call should work without any errors.

Issue History

Date Modified Username Field Change
2022-01-06 15:31 Tomasz_Filipek New Issue
2022-01-06 15:31 Tomasz_Filipek Tag Attached: mariadb
2022-01-10 10:33 bruno-at-bareos Note Added: 0004460
2022-01-10 10:33 bruno-at-bareos Assigned To => bruno-at-bareos
2022-01-10 10:33 bruno-at-bareos Status new => assigned