View Issue Details

IDProjectCategoryView StatusLast Update
0001419bareos-coreGeneralpublic2022-01-27 11:51
ReporterTomasz_Filipek Assigned Tobruno-at-bareos  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
PlatformLinuxOSCentOSOS Version7
Product Version21.0.0 
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.
bruno-at-bareos

bruno-at-bareos

2022-01-24 15:53

developer   ~0004485

Any news ?
Tomasz_Filipek

Tomasz_Filipek

2022-01-27 11:33

reporter   ~0004486

At the time of writing, there was nothing in the documentation about the mariadb plugin, so I did it without .my.cnf. Now everything is ok.
bruno-at-bareos

bruno-at-bareos

2022-01-27 11:50

developer   ~0004488

Yeah the merge of the documentation took much time than expected.
It is now available, and we your confirmation I will close this issue.
bruno-at-bareos

bruno-at-bareos

2022-01-27 11:51

developer   ~0004489

Documentation is published

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
2022-01-24 15:53 bruno-at-bareos Note Added: 0004485
2022-01-27 11:33 Tomasz_Filipek Note Added: 0004486
2022-01-27 11:50 bruno-at-bareos Note Added: 0004488
2022-01-27 11:51 bruno-at-bareos Status assigned => closed
2022-01-27 11:51 bruno-at-bareos Resolution open => fixed
2022-01-27 11:51 bruno-at-bareos Note Added: 0004489