db icon indicating copy to clipboard operation
db copied to clipboard

Nuke fails to connect to SSH remote MySQL?

Open kevzettler opened this issue 5 years ago • 1 comments

I have a remote environment prod I can save and load to correctly

$ db load prod d1b79e59d484a512552a6cc0587ff287ec2d427901dd8d494a6b32fe
mysql: [Warning] Using a password on the command line interface can be insecure.
[prod] Loaded snapshot d1b79e59d484a512552a6cc0587ff287ec2d427901dd8d494a6b32fe

However when I try the nuke command it fails to connect. Also looks like its trying to use the local loopback ip 127.0.0.1 ?

kevs-mbp:radcade kevzettler$ db nuke prod
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
mysqldump: Got error: 2003: Can't connect to MySQL server on '127.0.0.1' (61) when trying to connect
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
[prod] Nuked gamezill_fsew4a23A

kevzettler avatar Jul 23 '20 20:07 kevzettler

This appears to be because there is no nuke ssh connector in https://github.com/infostreams/db/tree/master/bin/drivers/mysql/connectors/ssh

kevzettler avatar Jul 23 '20 21:07 kevzettler