Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Passing a MySql password from bash script
Top Forums Shell Programming and Scripting Passing a MySql password from bash script Post 302374575 by codenjanod on Wednesday 25th of November 2009 02:32:59 AM
Old 11-25-2009
Passing a MySql password from bash script
Hi all,

I am running this script on Mandrakelinux release 10.1, 2.6.8.1-12mdksmp #1 SMP
I have also installed 'expect' separately.

I have created an Rsync script, but before any Rsync command does run, a MySql dump must be done first, and I am battling a bit to pass the MySql password from the bash script.

This is what my script looks like:
Code:
#!/bin/bash

VAULT='backupserver'
RSYNC=`which rsync`
DATE=$(date +%Y-%m-%d.%H:%M)
LOG="/tmp/MySql-$DATE.log"
MYSQLDUMP='/usr/local/mysql/bin/mysqldump'
BACKUPDIR='/Data/Mysql_Backups'
PASS='/root/.credentials'

backup () {
    VAR=$(expect -c "
        spawn "$MYSQLDUMP -u root -p database_1 $BACKUPDIR/backup.sql"
        expect \"password:\"
        send \"$PASS\r\"
        expect \"\\\\$\"
    ")
    echo "==============="
    echo "$VAR" 

        $RSYNC -e ssh -avl --delete --stats --progress $BACKUPDIR/backup.sql    root@$VAULT:/vault2/Backups/MySql    >> $LOG
        rm -rf $BACKUPDIR/backup.sql
}

backup

The output I get when running the script is:
Quote:
expect: invalid option -- u
usage: expect [-div] [-c cmds] [[-f] cmdfile] [args]
===============
spawn /usr/local/mysql/bin/mysqldump
rsync: link_stat "/Data/Mysql_Backups/backup.sql" failed: No such file or directory (2)
rsync error: some files could not be transferred (code 23) at main.c(692)
Thanks for the help.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

passing variable from bash to perl from bash script

Hi All, I need to pass a variable to perl script from bash script, where in perl i am using if condition. Here is the cmd what i am using in perl FROM_DATE="06/05/2008" TO_DATE="07/05/2008" "perl -ne ' print if ( $_ >="$FROM_DATE" && $_ <= "$TO_DATE" ) ' filename" filename has... (10 Replies)
Discussion started by: arsidh
10 Replies

2. Shell Programming and Scripting

passing password in shell script

Hi, Anybody help to write a shell script as below requirement. script stops some costomized application services. 1. first it will stop apache as root 2. then it will switch to my application user and stop app service. Note: passing password is required to stop app service as app... (1 Reply)
Discussion started by: manojbarot1
1 Replies

3. Shell Programming and Scripting

ssh - passing password in shell script

I have a requirement, I need to run a command at remote system using a ssh. Is there any way we can pass the username and password in shell script to the ssh command as we did it in one of the shell script for FTP. ftp -n $i <<!EOF >> user Username $PASSWD cd /home/scripts ... (5 Replies)
Discussion started by: Muktesh
5 Replies

4. Shell Programming and Scripting

Passing a variable from shell script to mysql query?

I heard this was possible but from my research I haven't been able to figure it out yet. Seems it should be simple enough. Basically from a high level view I'm trying to accomplish... . $X='grep foo blah.log' then 'mysql command SELECT foo FROM bar WHERE ' . $X or something like that. ... (2 Replies)
Discussion started by: kero
2 Replies

5. Shell Programming and Scripting

passing database password to isql command in shell script

Hi, I need to connect to DB through my shell script. but I dont want to hardcode my db password in the script. Is there a way to do it? Thanks ---------- Post updated at 07:42 PM ---------- Previous update was at 04:54 PM ---------- :(Guys..please help me with this:( (1 Reply)
Discussion started by: agrawal.prachi
1 Replies

6. Shell Programming and Scripting

Passing password in script for ssh connection - no except

Used the script posted on forum - unix.com/shell-programming-scripting/21597-script-change-passwords-same-user-multiple-servers.html but the last question posted on this seems to be still unanswered, tried different things with no success, can someone help giving an way to pass the password via... (5 Replies)
Discussion started by: sapadmin
5 Replies

7. Shell Programming and Scripting

Passing Password to SSH without using expect in a Script

How can I pass password in SSH command without using expect in a shell program. I don't have expect installed on my Solaris server. #!/bin/bash ssh user@hotname (how to supply pass in script?:wall:) Experts please help its very urgent. Shrawan Kumar Sahu (4 Replies)
Discussion started by: ss135r
4 Replies

8. Shell Programming and Scripting

Passing password for ssh in Script

I want to do following 2 commands via script: 1) eval `ssh-agent`2) ssh-add /export/home/sufuser/.ssh/id_rsa When asked for passphrase enter "passwordpassword1234 but whenever I run the script it stucks after "ssh-add /export/home/sufuser/.ssh/id_rsa" command and asks fro... (4 Replies)
Discussion started by: yogeshpawar
4 Replies

9. Shell Programming and Scripting

Make a password protected bash script resist/refuse “bash -x” when the password is given

I want to give my long scripts to customer. The customer must not be able to read the scripts even if he has the password. The following command locks and unlocks the script but the set +x is simply ignored. The code: read -p 'Script: ' S && C=$S.crypt H='eval "$((dd if=$0 bs=1 skip=//|gpg... (7 Replies)
Discussion started by: frad
7 Replies

10. Shell Programming and Scripting

Expect script not passing password / commands ??

Newbie here. My goal is to have the expect script log into the Ubuntu 18.04 server and run two commands (lsb_release -a and ip addr) and eventually pipe the output/results to a file. For now, I would be happy to get this one command or two to run successfully. How to fix this? #!/usr/bin/expect ... (3 Replies)
Discussion started by: jacob600
3 Replies

LEARN ABOUT DEBIAN

bup-on

bup-on(1)						      General Commands Manual							 bup-on(1)

NAME

       bup-on - run a bup server locally and client remotely

SYNOPSIS

       bup on <hostname> index ...

       bup on <hostname> save ...

       bup on <hostname> split ...

DESCRIPTION

       bup on  runs  the given bup command on the given host using ssh.  It runs a bup server on the local machine, so that commands like bup save
       on the remote machine can back up to the local machine.	(You don't need to provide a --remote option to bup save  in  order  for  this	to
       work.)

       See bup-index(1), bup-save(1), and so on for details of how each subcommand works.

       This  'reverse  mode'  operation  is  useful when the machine being backed up isn't supposed to be able to ssh into the backup server.  For
       example, your backup server can be hidden behind a one-way firewall on a private or dynamic IP address; using an ssh key, it can be  autho-
       rized  to  ssh  into  each  of your important machines.	After connecting to each destination machine, it initiates a backup, receiving the
       resulting data and storing in its local repository.

       For example, if you run several virtual private Linux machines on a remote hosting provider, you could back them up to a local  (much  less
       expensive) computer in your basement.

EXAMPLES

	      # First index the files on the remote server

	      $ bup on myserver index -vux /etc
	      bup server: reading from stdin.
	      Indexing: 2465, done.
	      bup: merging indexes (186668/186668), done.
	      bup server: done

	      # Now save the files from the remote server to the
	      # local $BUP_DIR

	      $ bup on myserver save -n myserver-backup /etc
	      bup server: reading from stdin.
	      bup server: command: 'list-indexes'
	      PackIdxList: using 7 indexes.
	      Saving: 100.00% (241/241k, 648/648 files), done.
	      bup server: received 55 objects.
	      Indexing objects: 100% (55/55), done.
	      bup server: command: 'quit'
	      bup server: done

	      # Now we can look at the resulting repo on the local
	      # machine

	      $ bup ftp 'cat /myserver-backup/latest/etc/passwd'
	      root:x:0:0:root:/root:/bin/bash
	      daemon:x:1:1:daemon:/usr/sbin:/bin/sh
	      bin:x:2:2:bin:/bin:/bin/sh
	      sys:x:3:3:sys:/dev:/bin/sh
	      sync:x:4:65534:sync:/bin:/bin/sync
	      ...

SEE ALSO

       bup-index(1), bup-save(1), bup-split(1)

BUP

       Part of the bup(1) suite.

AUTHORS

       Avery Pennarun <apenwarr@gmail.com>.

Bup unknown-																 bup-on(1)
All times are GMT -4. The time now is 04:39 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy