Anyone know if there's a way to debug this call

sudo -u ubuntu meltano config target-postgres set postgres_host $db_host

I am executing this via bash upon an LXD container .. using a tool called Juju. if I ssh into the LXD container and run this command manually with the IP Address .. as the ubuntu user.. it works but my bash script via juju doesn't seem to affect the

meltano.yml

at all.. causing me to be unable to easily update the ip address of the postgresql. I can work around this using

sed

in bash.. but wondered if this is possibly something that can be fixed? Edit: I'll try adding

--log-level=debug

and see if it reveals anything useful Here's what it looks like when I manually SSH into the image and do it myself (and I can see it does indeed update the yml)

ubuntu@juju-2dd159-160:~/meltano_proj_repo$ meltano --log-level=debug config target-postgres set postgres_host MY_NEW_IP
[2021-09-04 15:39:36,680] [2186|MainThread|root] [DEBUG] Creating engine <meltano.core.project.Project object at 0x7ffa5a74fdc0>@sqlite:////home/ubuntu/meltano_proj_repo/.meltano/meltano.db
[2021-09-04 15:39:36,725] [2186|MainThread|urllib3.connectionpool] [DEBUG] Starting new HTTPS connection (1): <http://www.meltano.com:443|www.meltano.com:443>
[2021-09-04 15:39:37,295] [2186|MainThread|urllib3.connectionpool] [DEBUG] <https://www.meltano.com:443> "GET /discovery.yml HTTP/1.1" 200 115895
Loader 'target-postgres' setting 'postgres_host' was set in `meltano.yml`: 'MY_NEW_IP'

@emcp Would it be an option to use an environment variable instead?

sed

likely will be easier.. but for the password I know I must set that as an environment variable. I will test this idea.. the issue is, Juju utilizes bash hooks in a way that.. basically you have different states.. so I will have to test if say.. in the hook which relates meltano to my database.. if I set the environment variable there.. does it persist when I say.. go back to the start.. does it get picked up by meltano or do I have to reboot etc.. Thanks as always Douwe