[stable/2024.1] Fix CLI issues (#1578)

This is an automated cherry-pick of #1575
/assign mnaser
diff --git a/images/python-openstackclient/Dockerfile b/images/python-openstackclient/Dockerfile
index d5944d4..b200229 100644
--- a/images/python-openstackclient/Dockerfile
+++ b/images/python-openstackclient/Dockerfile
@@ -22,3 +22,11 @@
 
 FROM registry.atmosphere.dev/library/python-base:${RELEASE}
 COPY --from=build --link /var/lib/openstack /var/lib/openstack
+
+# NOTE(mnaser): The Magnum client relies on the SHELL environment variable
+#               to determine the shell to use.
+ENV SHELL=/bin/bash
+
+# NOTE(mnaser): When we call this container, we mount the current directory
+#               into `/opt` and then we can call `openstack` commands.
+WORKDIR /opt