question: Using basti connect CLI non-interactively

[corinja]

Hello.

I am trying to use basti to create a shell script running in my CICD pipeline which will init, connect, run a SQL script against a database, and then cleanup.

When I run a basti connect command the CLI ends up in interactive mode, so I can't then run my SQL.

Is there a way around this?

Example:

basti init --aws-region xx-xxx-x --rds-instance my-rds-id --bastion-subnet my-public-subnet-id

echo "Sleeping 2 minutes for AWS resources to propagate"
sleep 2m

basti connect --aws-region xx-xxx-x  --rds-instance my-rds-id --local-port xxxx

# Run the npm command
echo "Running SQL $FILE_NAME:"

In this example, after the basti connect ... line the CLI is in interactive mode so it doesn't reach the subsequent command (I've just left the next statement in to illustrate my point, not included the actual SQL script).

[corinja]

I wonder if maybe it's possible using a basti configuration file, but I can't seem to get that to work. Getting the error

❌ Error resolving connection from configuration file. No configuration file found

After running the command:

basti connect database-pr

With a file named .basti.yml in the same directory as the script I am running.

EDIT: No, I got this to work but it still goes into interactive mode.

[BohdanPetryshyn]

Hi @corinja! What you are experiencing is not due to the interactive mode but due to the fact that basti connect is by design a long-running process that listens to a port on your machine. To unblock the shell script after Basti has successfully established connection, please, use the example provided in the documentation that runs Basti in a detached mode and leverages the wait-on utility to wait for the connection.

From docs:

To continue executing the script after the connection is established, you can use Basti in conjunction with the wait-on utility and the & shell operator:

basti connect --rds-instance your-instance-id --local-port your-port &
wait-on tcp:localhost:your-port

Thank you for your question! I'll transform it to a discussion so that other people can use this solution.

[corinja]

Ah, a bit embarrasing for me that I failed to spot that documentation! Thanks a lot @BohdanPetryshyn , I appreciate your time.