Method:API Q&A

Re: Exception Caught: user 'root' using method 'mysql_native_password' failed ... attempted to read past end of stream

Method_Audisho — Fri, 24 Mar 2017 19:19:09 GMT

Hi furrywombat,

Yes, this includes the non-standard API server that you use as well.

Cheers,
Audisho

Re: Exception Caught: user 'root' using method 'mysql_native_password' failed ... attempted to read past end of stream

furrywombat — Fri, 24 Mar 2017 19:11:42 GMT

Outstanding. Very quickly, though -- the API that we are connecting to, as I mentioned, is not the standard API. If you would please confirm that our stuff has been re-pointed as well. And I will monitor for any additional errors coming through.

Re: Exception Caught: user 'root' using method 'mysql_native_password' failed ... attempted to read past end of stream

Method_Audisho — Fri, 24 Mar 2017 19:06:14 GMT

Hi furrywombat,

We had a hardware outage on Amazon Tuesday night and as a result, we had to point some of our services, such as the API, to another environment. We believe this may be what's causing this error.

We've just switched these services to point back to our main production environment which is now functioning correctly. Please monitor and post back if you're still receiving these errors moving forward.

Cheers,
Audisho

Re: Exception Caught: user 'root' using method 'mysql_native_password' failed ... attempted to read past end of stream

furrywombat — Fri, 24 Mar 2017 16:54:40 GMT

Two more of these errors since my initial post. One desktop sync request at 8:35am this morning, and a failed select at 11:51am.

Any idea what's going on here, please? Nothing has changed on our side.

Exception Caught: user 'root' using method 'mysql_native_password' failed ... attempted to read past end of stream

furrywombat — Fri, 24 Mar 2017 13:06:18 GMT

We've been getting this particular error periodically, ever since the recent reconfiguration of the API server. This particular case is an interesting one as well, as we do have a unique API server configuration which you may reference internally.

The error is not specific to any type of query, and has been returned now for both select, and desktop sync requests. Started off on 3/21 as a large number of internal server error exceptions. Those were primarily for insert statements, but also came up for a few select & desktop sync requests. Now, this is the primary error I'm getting, which started on 3/22, early afternoon:

Exception Caught: Server was unable to process request. ---> Authentication to host 'REDACTED*' for user 'root' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ---> Reading from the stream has failed. ---> Attempted to read past the end of the stream.

*Please contact me directly for any redacted info.

Would very much like to know why we are receiving these errors, and what is being done to resolve.