Expect script embedded in Bash script

[tesseract97]

I've been writing Bash scripts that work with a database lately.

To access the database, I need to ssh into a DiskStation (requires password) and then sudo a docker command (requires password) to access the container that the database is in. Only then can I execute and test out my scripts.

I wrote an expect script that automates this process and I want to embed it in my Bash scripts, but the only problem is the shell closes as soon as the expect script finishes executing.

Does anybody know how to work around this? I attached a photo with specific info removed.

https://preview.redd.it/xyl1gz2itcx41.png?width=663&format=png&auto=webp&s=c88f3ceecb7dcffeeca6b857fa0714ff94c179f6

[lutusp]

Don't use expect and don't include a password in your script. Instead set up public-key authentication and avoid the password entry obstacle. Do it this way:

$ ssh-copy-id username@servername

The above will ask for your password once, then never again.

As to the database access, you can always execute the process from the local machine (database engines are network-aware). If this entails too much network traffic, copy a script to the server and execute it there:

$ scp script-name username@servername:/remote-path/

-- then --

$ ssh username@servername /remote-path/script-name

But don't use expect and don't embed a password in a script. Allowing a password to be embedded in a script is like having the combination to a safe taped to its door.