Trellis provision not finding my db_user anymore

[pandabrand]

Hey all,

I’m having this issue where trellis provision development isn’t finding my db_user. When I run that It fails with this:

Access denied for user ‘’@‘localhost’ (using password: NO)

However, I can run trellis db open --app=sequel-ace development cms.pleinairarchive.com and it knows what the user and pass are. I can’t figure out where this is missing for trellis. Under Bedrock I have a .env file with the correct vars and I’ve added a

env:
    db_user: cms_pleinairarchive_com

development/wordpress_sites.yml, so I don’t know where else this should be?

[pandabrand]

So, I tried troubleshooting this by running

ansible-playbook deploy.yml -vvvv -e “site=cms.pleinairarchive.com env=development”

and now got this error instead

Failed to connect to the host via ssh: OpenSSH_9.9p2, LibreSSL 3.3.6
debug1: Reading configuration data /Users/frederickwells/.ssh/config
debug1: Reading configuration data /etc/ssh/ssh_config
debug1: /etc/ssh/ssh_config line 21: include /etc/ssh/ssh_config.d/* matched no files
debug1: /etc/ssh/ssh_config line 54: Applying options for *
debug2: resolve_canonicalize: hostname 192.168.56.5 is address
debug3: expanded UserKnownHostsFile '~/.ssh/known_hosts' -> '/Users/frederickwells/.ssh/known_hosts'
debug3: expanded UserKnownHostsFile '~/.ssh/known_hosts2' -> '/Users/frederickwells/.ssh/known_hosts2'
debug1: Authenticator provider $SSH_SK_PROVIDER did not resolve; disabling
debug1: auto-mux: Trying existing master at '/Users/frederickwells/.ansible/cp/3656dab03e'
debug1: Control socket \"/Users/frederickwells/.ansible/cp/3656dab03e\" does not exist
debug3: channel_clear_timeouts: clearing
debug3: ssh_connect_direct: entering
debug1: Connecting to 192.168.56.5 [192.168.56.5] port 22.
debug3: set_sock_tos: set socket 3 IP_TOS 0x48
debug2: fd 3 setting O_NONBLOCK
debug1: connect to address 192.168.56.5 port 22: Operation timed out
ssh: connect to host 192.168.56.5 port 22: Operation timed out

I don’t know where to go with this

[Tetrahedrax]

Is this the same project that you upgraded here?

Best possible way to update a very old trellis install

I have an old trellis install from around 2020? Back when I was on an Intel Mac. Fast forward to now and I’m on an Apple Silicon mac and need to futz with this again. I’ve tried just updating some vagrant config from this post to no avail. I only can find this one regarding updating trellis which is also quite old? Is that still the best option? Anyone have any suggestions to bring this ancient one back to life?

Also, what do you mean with “anymore”? When did it last work? Before the upgrade?

[pandabrand]

Yes, still working on this install. I did successfully update trellis and it was working. I then went to bedrock and update the packages in composer there. This is where things stopped working for me. Sorry, that would have been helpful info.

[Tetrahedrax]

Best guess is that you’ve accidentally overwritten a config file somewhere.

Check out how db_user is set in a standard Trellis project. You can find it in:

application.php
helpers.yml ← I’m willing to bet that this is the one you’ve missed something in
main.yml
database.yml (probably not relevant in your case though)

Basically, you’re not supposed to sit and edit .env yourself. That’s handled either through a config, or through the vault.

[pandabrand]

Ok, going the path of least resistance and just rebuilding from scratch. I’ve gotten way farther in reviving this doing that.

[Tetrahedrax]

Could be worth the time spent, indeed. As someone that’s currently turning a Sage 10 Bedrock site into a Sage 11 Radicle site, it’s really not as time consuming or difficult as I’d expected it to be.

Good luck with the rebuilding!