Arch Linux

blackout

Member

Registered: 2014-05-21

Posts: 38

mysql-workbench ssh key auth connection not working

hey,

i upgraded the WB to 8+ and now the saved connections don't work anymore.

If i install the 5.6.10 version the connections are fine.

If i create a local ssh tunnel and connect to the server it works.

I know there was a lib change so maybe there was some breaking change.

On the server I have pure key authentication no PW.

Can someone check this?

thanks in advance

Last edited by blackout (2018-08-10 08:50:34)

blackout

Member

Registered: 2014-05-21

Posts: 38

Re: mysql-workbench ssh key auth connection not working

no one???

V1del

Forum Moderator

Registered: 2012-10-16

Posts: 25,435

Re: mysql-workbench ssh key auth connection not working

There should be a fix for this in community-testing however that is currently waiting on some other deps from testing before it can be pushed to the normal repos

jaylittle

Member

Registered: 2013-01-16

Posts: 47

Re: mysql-workbench ssh key auth connection not working

Yeah this bug hit me like a dump truck this morning as well.  I'm essentially locked out of almost everything.  What exactly happened here?

To be clear - my entire ssh key library appears to be not unlockable using the whatever gnome uses to manage unlocking ssh keys.

EDIT: So I managed to resolve my issue.  I have two arch linux PCs.  Both with the same private SSH keys.  Recently I changed the password on one of those private keys independently on each computer.  The password was setup exactly the same.  However it appears that I am unable to decrypt the private key on computer A whereas the private key on computer B is easily decrypted.  I was able to resolve this by copying over the private key file from B to A.

This may have been an issue for awhile as A doesn't get reboot very often but I did happen to reboot it late yesterday which would've forced the gnome keyring daemon to prompt me to unlock my ssh key once again.

Last edited by jaylittle (2018-08-25 11:52:55)

V1del

Forum Moderator

Registered: 2012-10-16

Posts: 25,435

Re: mysql-workbench ssh key auth connection not working

jaylittle very unlikely to be the same issue, this one is specifically about workbench, if you have another issue with other software, please open your own thread about it.

@blackout the version I was referring to is in community now, is it fixed?