From 1b3449f24cd2ce5ec99602ef6d4286d8159e427f Mon Sep 17 00:00:00 2001 From: Elijah Saxon Date: Wed, 1 Jun 2005 22:44:04 +0000 Subject: [PATCH] mysql --defaults-file stuff. --- backupninja | 8 ++--- changelog | 6 ++-- etc/backup.d/example.mysql | 37 +++++++++++-------- handlers/mysql | 74 +++++++++++++++++++++++++++----------- 4 files changed, 83 insertions(+), 42 deletions(-) diff --git a/backupninja b/backupninja index a105a5b..70c6640 100755 --- a/backupninja +++ b/backupninja @@ -3,7 +3,7 @@ # B A C K U P N I N J A /()/ # `\| # -# Copyright (C) 2004 riseup.net -- property is theft. +# Copyright (C) 2004-05 riseup.net -- property is theft. # # This program is free software; you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by @@ -429,7 +429,7 @@ getconf RSYNC /usr/bin/rsync getconf vservers no getconf VSERVERINFO /usr/sbin/vserver-info getconf VSERVER /usr/sbin/vserver -getconf VROOTDIR `$VSERVERINFO info SYSINFO |grep vserver-Rootdir | awk '{print $2}'` +getconf VROOTDIR `if [ -f "$VSERVERINFO" ]; then $VSERVERINFO info SYSINFO |grep vserver-Rootdir | awk '{print $2}'; fi` if [ ! -d "$configdirectory" ]; then echo "Configuration directory '$configdirectory' not found." @@ -443,8 +443,8 @@ if [ "$UID" != "0" ]; then exit 1 fi -if [ "$VSERVERS" = "yes" -a ! -d $VROOTDIR ]; then - echo "vservers option set in config, but $VROOTDIR is not a directory!" +if [ "$vservers" == "yes" -a ! -d "$VROOTDIR" ]; then + echo "vservers option set in config, but $VROOTDIR is not a directory!" fatal "vservers option set in config, but $VROOTDIR is not a directory!" fi diff --git a/changelog b/changelog index c3f9dca..78f67a8 100644 --- a/changelog +++ b/changelog @@ -17,9 +17,9 @@ version 0.x -- xxxxxxxxxxxxx added "bandwidthlimit" option example.dup example config file for duplicity handler added trac (http://trac.edgewall.com/) environment handler (thanks Charles Lepple!) - added configfile option to mysql handler (thanks bonniot!) - uses /etc/mysql/debian.cnf by default - now, an empty /etc/backup.d/01.mysql file is all you need + added configfile option to mysql handler + the default is /etc/mysql/debian.cnf. with this, + sqldump doesn't need dbusername. (hotcopy still does). version 0.5 -- April 12 2005 rdiff handler works when remote sshd has a banner diff --git a/etc/backup.d/example.mysql b/etc/backup.d/example.mysql index 4be2428..e0559fe 100644 --- a/etc/backup.d/example.mysql +++ b/etc/backup.d/example.mysql @@ -1,24 +1,31 @@ -## backupninja mysql config file ## +### backupninja mysql config file ### -dbhost = localhost databases = all backupdir = /var/backups/mysql -hotcopy = yes -sqldump = no +hotcopy = no +sqldump = yes compress = yes -## authentication ## +### authentication ### -configfile = /etc/mysql/debian.cnf - -# or... -# dbusername = -# dbpassword = - -# or... -# user = root +# three authentication methods: +# +# 1. setting the user, so that /home/user/.my.cnf is used. +# user = some-unix-user +# +# 2. specifying the mysql dbuser and dbpassword, +# which generates a temporary .my.cnf in /root/.my.cnf +# dbusername = +# dbpassword = +# +# 3. specify which config file to use with configfile +# (this option does not work with hotcopy) +# configfile = /etc/mysql/debian.cnf +# +# if user and dbusername are not specified, the default is to use +# /etc/mysql/debian.cnf for configfile. -## notes ## +### all options ### # configfile = < path/to/file > (default = /etc/mysql/debian.cnf) # The config file is passed to mysql with --defaults-file. @@ -50,7 +57,7 @@ configfile = /etc/mysql/debian.cnf # where to dump the backups. hotcopy backups will be in a subdirectory 'hotcopy' and # sqldump backups will be in a subdirectory 'sqldump' # -# hotcopy = < yes | no > (default = yes) +# hotcopy = < yes | no > (default = no) # make a backup of the actual database binary files using mysqlhotcopy. # # sqldump = < yes | no > (default = no) diff --git a/handlers/mysql b/handlers/mysql index 8283ba4..13dd62f 100644 --- a/handlers/mysql +++ b/handlers/mysql @@ -3,17 +3,28 @@ # getconf backupdir /var/backups/mysql -getconf configfile /etc/mysql/debian.cnf getconf databases all -getconf compress yes -getconf dbusername -getconf dbpassword getconf dbhost localhost -getconf hotcopy yes +getconf hotcopy no getconf sqldump no -getconf user root +getconf compress yes getconf vsname +# authentication: +getconf user +getconf dbusername +getconf dbpassword +getconf configfile /etc/mysql/debian.cnf + +if [ "$user" == "" ]; then + userset=false; + user=root; +else + userset=true; + userhome=`grep "^$user:" /etc/passwd | awk -F: '{print $6}'` + [ -f $userhome/.my.cnf ] || fatal "Can't find config file in $userhome/.my.cnf" +fi + # If vservers are configured, decide if the handler should # use them or if it should just operate on the host @@ -51,17 +62,33 @@ else [ "$hotcopy" == "no" -o -d $hotdir ] || mkdir -p $hotdir fi +####################################################################### +## AUTHENTICATION + +# +# one of three authentication methods: +# 1. setting the user, so that /home/user/.my.cnf is used. +# 2. specifying the user and password in the handler config, +# which generates a temporary .my.cnf in /root/.my.cnf +# 3. specify the config file with --defaults-file +# (this option DOESN'T WORK WITH MYSQLHOTCOPY) +# + # create .my.cnf # only if dbusername and dbpassword specified. -# we create a tmp file because we don't want to have to +# we create a tmp file because we don't want to # specify the password on the command line. defaultsfile="" if [ "$dbusername" != "" -a "$dbpassword" != "" ]; then - mycnf="/tmp/backupninja.$$.my.cnf" + home=`grep '^root:' /etc/passwd | awk -F: '{print $6}'` + [ -d $home ] || fatal "Can't find root's home directory ($home)." + mycnf="$home/.my.cnf" if [ -f $mycnf ]; then - debug "rm $mycnf" - rm $mycnf + # rename temporarily + tmpcnf="$home/my.cnf.disable" + debug "mv $mycnf $tmpcnf" + mv $mycnf $tmpcnf fi oldmask=`umask` umask 077 @@ -80,21 +107,22 @@ user=$dbusername password=$dbpassword EOF umask $oldmask - defaultsfile="--defaults-file $mycnf" -else - # otherwise, use $configfile - defaultsfile="--defaults-file $configfile" + defaultsfile="--defaults-file=$mycnf" +elif [ "$userset" == "false" ]; then + # if user is set, don't use $configfile + defaultsfile="--defaults-file=$configfile" fi +####################################################################### ## HOT COPY if [ "$hotcopy" == "yes" ]; then if [ "$databases" == "all" ]; then if [ $usevserver ] then - execstr="$VSERVER $vsname exec $MYSQLHOTCOPY $defaultsfile --quiet --allowold --regexp /.\*/./.\*/ $hotdir" + execstr="$VSERVER $vsname exec $MYSQLHOTCOPY --quiet --allowold --regexp /.\*/./.\*/ $hotdir" else - execstr="$MYSQLHOTCOPY $defaultsfile --quiet --allowold --regexp /.\*/./.\*/ $hotdir" + execstr="$MYSQLHOTCOPY --quiet --allowold --regexp /.\*/./.\*/ $hotdir" fi debug "su $user -c '$execstr'" if [ ! $test ]; then @@ -112,9 +140,9 @@ if [ "$hotcopy" == "yes" ]; then for db in $databases; do if [ $usevserver ] then - execstr="$VSERVER $vsname exec $MYSQLHOTCOPY $defaultsfile --allowold $db $hotdir" + execstr="$VSERVER $vsname exec $MYSQLHOTCOPY --allowold $db $hotdir" else - execstr="$MYSQLHOTCOPY $defaultsfile --allowold $db $hotdir" + execstr="$MYSQLHOTCOPY --allowold $db $hotdir" fi debug "su $user -c '$execstr'" if [ ! $test ]; then @@ -131,7 +159,8 @@ if [ "$hotcopy" == "yes" ]; then done fi fi - + +########################################################################## ## SQL DUMP if [ "$sqldump" == "yes" ]; then @@ -172,9 +201,14 @@ if [ "$sqldump" == "yes" ]; then fi # clean up tmp config file -if [ -f "$mycnf" ]; then +if [ "$dbusername" != "" ]; then + ## clean up tmp config file debug "rm $mycnf" rm $mycnf + if [ -f "$tmpcnf" ]; then + debug "mv $tmpcnf $mycnf" + mv $tmpcnf $mycnf + fi fi return 0 -- 2.30.2