Key mismatch about mole HOT 8 OPEN

Hi @mdcclxv,

The key mismatch error happens when the ssh client does not find the right entry on $HOME/.ssh/knownhosts.

Can you check if your knownhosts file have multiple entries for REMOTE_MYSQL_IP?

from mole.

No no, you got that wrong, the REMOTE_MYSQL_IP is the destination of the tunnel, the key is used for authorizing on the Linux box when connecting via SSH. I have no entries for that in knownhosts. And no duplicates for the REMOTE_LINUX_BOX_IP. If that was the case then PuTTY and PhpStorm should be failing too.

from mole.

No no, you got that wrong, the REMOTE_MYSQL_IP is the destination of the tunnel, the key is used for authorizing on the Linux box when connecting via SSH.

My bad, I meant multiple entries for REMOTE_LINUX_BOX.

from mole.

You replied while I was editing the previous answer :)
No duplicates for the REMOTE_LINUX_BOX_IP, I checked. If that was the case then PuTTY and PhpStorm should be failing too.

from mole.

You replied while I was editing the previous answer :)
No duplicates for the REMOTE_LINUX_BOX_IP, I checked. If that was the case then PuTTY and PhpStorm should be failing too.

But did you find an entry for it?

Can you try with --insecure, which makes mole to ignore the host key validation?

from mole.

Yes, there is one entry. I tried with --insecure, this is what I got:
connection to the ssh server is established bind: An attempt was made to access a socket in a way forbidden by its access permissions

I also tried with the CMD window running as Administrator, same error.

from mole.

Nevermind, my local copy of MySQL 5.7 was listening on 0.0.0.0:3306 although I configured it to only listen on 10.1.1.11. It seems that I hit a bug in MySQL. It's working with --insecure.

So, what's the next step? That --insecure option is making me uneasy, what's the risk?

from mole.

Hi @mdcclxv, are you still facing the same issue? We might have a problem with the library used to parse the known_hosts files not being able to understand old records. Would that be your case, having an old known_hosts entry?

I can update to the latest version but I have no way to validate it.

from mole.