(As I mentioned in my original report, I used the exact same configuration in the last public release of Sequel Pro 1.1.2 on my other Mac, and it worked. I was using "SSL" incorrectly when I meant that I was using public/private key authentication via SSH. (I was hoping moving to Sequel Pro test builds would fix everything. I still successfully use the last official release, Sequel Pro 1.1.2, on the old Mac, but I have given up on 1.1.2 on Mojave due to operating system changes. This is my first attempt using a test build.I have tried setting the MySQL Host (in the Sequel Pro config window) to the hostname (yielding the info above), the public IP address (same problem), and 127.0.0.1 ("MySQL said: SSL connection error: Server doesn't support SSL").The settings in ~/.ssh/config that are applied are: ServerAliveInterval (250), ServerAliveCountMax (2), HostName, User, Port, IdentityFile.There is no passphrase required for the SSL SSH key.The exact same Sequel Pro configuration works on my old Mac, running El Capitan (OS 10.11.6).The remote server configuration (SSH, MySQL) is correct because I can connect using mysql-shell (command line) via the aforementioned SSH tunnel.My SSL authentication works because I can use it to manually create an SSH tunnel from the command line.(placeholders inserted for hostname/IP, username, etc) WHAT I ALREADY KNOW Here's what I get when I click "Show Detail": debug_details.txt MySQL said: Lost connection to MySQL server at 'reading initial communication packet', system error: 0 "SHOW DETAIL" You may also want to check the port is correct and that you have the necessary privileges.Ĭhecking the error detail will show the SSH debug log which may provide more details. Please ensure that your MySQL host is set up to allow TCP/IP connections (no -skip-networking) and is configured to allow connections from the host you are tunnelling via. Unable to connect to host HOSTNAME because the port connection via SSH was refused. I have tried to be as thorough as possible in providing details about the problem, the config details, etc., all provided below. I'm trying to connect to a remote MySQL database via SSH tunnel using SSL public/private key authentication.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |