Percona XtraDB Cluster - HA scalable solution for MySQL

need authentication setting for xtrabackup sst

Reported by Jamaludin Ahmad on 2012-04-15
12
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona XtraDB Cluster
Medium
Unassigned

Bug Description

I'm not really sure whether this is my fault, missing documentation, or a real bug. but i can't seem to found setting for xtrabackup_sst authentication.

I use percona-xtradb-cluster 5.5 from percona's debian repository. Initially, I am having the exact same error as the original report on bug #975794. sst.err gave me "xtrabackup-2.0: This does not look like a tar archive", except i have datadir on my config.

so i check innobackup.backup.log on donor. and there it is this message:

120415 07:14:42 innobackupex: Starting mysql with options: --unbuffered --
120415 07:14:42 innobackupex: Connected to database with mysql child process (pid=8541)
innobackupex: Error: mysql child process has died: ERROR 1045 (28000): Access denied for user 'mysql'@'localhost' (using password: NO)

It seems xtrabackup sst invoke innobackupex using mysql user without any auth seting. Is there some way to change this? changing wsrep_sst_auth doesn't help (and your doc says it's not necessary).

Currently the only solution I know is to manually edit wsrep_sst_xtrabackup to include user/password flags, and risk got wiped on upgrade. or create mysql@localhost user without password. Would be nicer if there is something better.

Vadim Tkachenko (vadim-tk) wrote :

This this a valid request. I need to figure out how to pass authentication to the script.

Changed in percona-xtradb-cluster:
status: New → Confirmed
importance: Undecided → Medium
Jamaludin Ahmad (j-ahmad) wrote :

this is what i currently have. wsrep_sst_auth is mandatory.

--- wsrep_sst_xtrabackup.orig 2012-04-19 05:35:16.666746103 +0700
+++ wsrep_sst_xtrabackup 2012-04-19 05:34:35.142957756 +0700
@@ -48,7 +48,7 @@

 ROLE=$1
 ADDR=$2
-AUTH=$3
+AUTH=(${3//:/ })
 DATA=$4
 CONF=$5

@@ -73,7 +73,7 @@
         sleep 3 # allow time to start nc

- innobackupex --galera-info --tmpdir=$TMPDIR --stream=tar $TMPDIR 2> $DATA/innobackup.backup.log | nc $REMOTEIP $NC_PORT
+ innobackupex --galera-info --user=${AUTH[0]} --password=${AUTH[1]} --tmpdir=$TMPDIR --stream=tar $TMPDIR 2> $DATA/innobackup.backup.log | nc $REMOTEIP $NC_PORT

         if check_pid $XTRABACKUP_PID
         then

Changed in percona-xtradb-cluster:
status: Confirmed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers