[SOLVED] Making directory and moving files into it using Expect

trickydba · 12-16-2016, 02:05 PM

I tried several times using Expect to make a directory so I can move files into it but it keeps giving an error. Here is my code:

send "mkdir /export/home/eric/audits/\r"

This is the error I get: send: spawn id exp4 not open
while executing

I know Expect is not secure but this is the option I chose. When I try to create a folder in a bash script(using Oracle EDQ) it doesn't work either. My code in the script is:

mkdir /export/home/eric/audits/

I'm lost. PREFER to do this using Expect

trickydba · 12-16-2016, 02:07 PM

Correction using Expect:

send "mkdir //export/home/eric/reports/\r"

michaelk · 12-16-2016, 05:47 PM

FYI although it does not affect anything you do not need to use a a double forward slash (//) in your commands.

trickydba · 12-23-2016, 02:47 PM

When I try this Im getting an error, even in command line:

scp "${current_folder}" eric@hostname:/export/home/eric

I get this error after giving my password:

20161223: not a regular file

Im actually trying to copy/move a whole folder to a different location(from linux to win shared folder)

michaelk · 12-23-2016, 03:01 PM

You need to use the -r (recursive option). See scp man pages for more info...

trickydba · 12-23-2016, 03:11 PM

The 'current_folder' variable is set up as such:

current_folder="$(date +%m%d%Y)"

I'm trying to make the folder created look like this - 12232016
But it's still coming up like this - 20161223

What am I doing wrong?

michaelk · 12-23-2016, 03:17 PM

We can not tell without seeing your script. As suggested in a previous thread its actually easier to search/list using Ymd then mdy format

trickydba · 12-23-2016, 03:22 PM

I provided the script to the date variable above. The full script is:

scp "${current_folder}" eric@hostname:/export/home/eric

current_folder="$(date +%m%d%Y)"

When this script is ran,, it is already in the folder where the current dated folder exists

trickydba · 12-23-2016, 03:28 PM

Stoopid me, I was changing the wrong script. I code above works.

trickydba · 12-23-2016, 03:44 PM

I tried this code with no results:

current_folder="$(date +%m%d%Y)"

scp -r "${current_folder}" eric@hostname:/export/home/eric

michaelk · 12-23-2016, 03:48 PM

How is the script run with respect to the path environment and the location of current_folder?

trickydba · 12-23-2016, 03:51 PM

The script would be ran using Expect. The folder the script is running in is export/home/eric/reports/. Which is where the folder 12232016 resides.
The location of the destination folder is in Windows (export/home/eric/reports/destinationfolder/

I hope this answers your question

trickydba · 12-23-2016, 03:53 PM

Does the command 'sftp' recognize variables?

trickydba · 12-23-2016, 03:55 PM

Believe me I tried the easiest way(keys) but that is waaaay too confusing and this whole process is working WITH keys in a PowerShell script. I love Linux which is better and figured I could this this without having to go through setting up keys cause it's already been done in Windows

trickydba · 12-23-2016, 04:02 PM

Im having to move this folder manually using FileZilla. I wonder if 'sftp' should be the way to go? If so, it would have to recognize variables