0001419: Mariadb plugin - problem with incremental backup

ID	Project	Category	View Status	Date Submitted	Last Update

0001419	bareos-core	General	public	2022-01-06 15:31	2022-01-27 11:51

Reporter	Tomasz_Filipek	Assigned To	bruno-at-bareos
Priority	normal	Severity	minor	Reproducibility	always
Status	closed	Resolution	fixed
Platform	Linux	OS	CentOS	OS Version	7
Product Version	21.0.0

Summary	0001419: Mariadb plugin - problem with incremental backup
Description	Hi, 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 Reproduce	Run incremental backup.
Tags	mariadb

bruno-at-bareos 2022-01-10 10:33 manager ~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 2022-01-24 15:53 manager ~0004485	Any news ?

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 2022-01-27 11:50 manager ~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 2022-01-27 11:51 manager ~0004489	Documentation is published

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