Bug #95138 | Execl add-in will not connect, just spins. | ||
---|---|---|---|
Submitted: | 25 Apr 2019 23:07 | Modified: | 24 May 2019 21:06 |
Reporter: | Glenn Giordano | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL for Windows: MySQL for Excel | Severity: | S1 (Critical) |
Version: | 1.3.7 | OS: | Windows (10 Pro, Ver. 1803, Bld. 17134.648) |
Assigned to: | CPU Architecture: | x86 | |
Tags: | 92566, add-in, Connection, execl, remote host |
[25 Apr 2019 23:07]
Glenn Giordano
[23 May 2019 14:16]
MySQL Verification Team
Thank you for the bug report. I couldn't repeat connecting in local network with an Ubuntu 19.04 Linux against a 8.0.16 server.
[24 May 2019 19:57]
Glenn Giordano
Thanks Miguel, I guess that's no surprise... ;) In a desperate shotgun move today, I shutdown the server, cleared the default-authentication-plugin=mysql_native_password from the config. Restarted. Deleted the connection and the user. Shut down again. Placed default-authentication-plugin=mysql_native_password back in the config. Restarted. Recreated the user and the connection. And Poof. It works. No idea what / why was the actual cause. There was no real indication that this was an issue (i.e. no warnings or logs about authentication). No idea how it broke for sure. Only thing that comes to mind is on the latest DB server update did something to the user table for the password hash. Simply deleting and re adding the user did not fix it. I had to do all the steps above. Not sure I could, or want to reproduce the initial problem, but maybe some of what I have observed will give you a clue where the trigger was. In any case, this one is in the history books for me. Regards, G^2
[24 May 2019 21:06]
MySQL Verification Team
Thank you for the feedback.