The error message that I receive is: Could not connect the SSH tunnel. Authentication error opening SSH tunnel: Authentication error, unhandled exception caught in tunnel manager, please refer to logs for details.
When I check the log file, the same error message is repeated with no more details which is quite unhelpful.
That being said, I think the issue the error shows the problem is connecting via ssh and not the mysql login details.
I have tried using both the IP address with port number (:22) and the domain with port number. I have also tried using the preferred ssh port number (:2222) with both of these details.
I am also using the default username and password (vagrant) and have added these credentials to the vagrantfile (using config.ssh.username and config.ssh.password) along with the private key held within the trellis installation as the ssh key file.
However, none of these solutions have worked so far. I am able to ssh into the VM using the command vagrant ssh via git bash, but I would like to be able to connect vai mysql workbench if possible.
Any help regarding this issue would be greatly appreciated.
ah sorry, I meant vagrant as well. This was a default option in an earlier version of trellis. I neglected to mention that I also tried with the username vagrant, without a password and with the private key but this also returned the same error.
I added the change from @swalkinshaw and re-provisioned the VM and I also tried the solution from @fullyint and re-provisioned the VM but unfortunately these solutions did not solve the issue and the error message still states:
Could not connect the SSH tunnel. Authentication error opening SSH tunnel: Authentication error, unhandled exception caught in tunnel manager, please refer to logs for details.
is there any other information that would help to diagnose this issue?
Sorry, I figured this out about two weeks ago and I forgot to update this ticket. I found out this is to do with a flaw in mysql workbench 6.3. Even though when you open the application and check for updates it states that you are on the latest version when really you are not. Go to the workbench website, and update to the latest version.
The reason why it fails is to with an open ssh compatibility flaw between vagrant and the open ssh protocols that mysql workbench provides. Upgrade to the latest version and it should solve your issue, very loosely the background of the connection panel was dark blue in the old version and it should be white in the newer version