Exception: Authentication to host <myhost> for user <myuser> using method mysql_native_password failed with message: Reading from the stream has failed
Posted by: Avi Vainshtein
Date: December 11, 2018 04:24AM

Greetings,

We have a domestic .Net application running at Windows hosts and working with a Centos host with 5.7.19 MySQL DB.
The .Net Connector is 6.8.3.

Occasionally, in various hours of a day, and not every day, the application logs the
"Exception: Authentication to host <myhost> for user <myuser> using method mysql_native_password failed with message: Reading from the stream has failed" messages.

Full message stack is below.

What could be the reason and how to resolve/avoid/workaround the problem ?

Best regards and looking forward the community assistance
Avi Vainshtein

========================
FailedToSaveTibcoCallRecord(Failed to save the Tibco call record.) Connection Settings: defaultTibcoConnection Message Settings: OrderDetailesDataBatch Message: Failed to save the Tibco call record. Exception: Authentication to host &apos;<myhost>&apos; for user &apos;<myuser>&apos; using method &apos;mysql_native_password&apos; failed with message: Reading from the stream has failed. MySql.Data at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.AuthenticationFailed(Exception ex) at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket() at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset) at MySql.Data.MySqlClient.NativeDriver.Authenticate(String authMethod, Boolean reset) at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.Driver.Open() at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() at MySql.Data.MySqlClient.MySqlPool.GetConnection() at MySql.Data.MySqlClient.MySqlConnection.Open() at Cm.TibcoCore.TibcoUtils.CreateConnection(IDatabaseOperator dbOperator, Boolean open) in D:\TfsBuilds\CM\CmProd1\3\s\CM\Cm.TibcoCore\TibcoUtils.cs:line 545 at Cm.TibcoCore.Persistency.PersistencyDataRecord.Save(TibcoPersistencyManagerSettings persistencyManagerSettings, AdditionalColumn[] additionalColumns, IDatabaseOperator dbOperator, Boolean force) in D:\TfsBuilds\CM\CmProd1\3\s\CM\Cm.TibcoCore\Persistency\PersistencyDataRecord.cs:line 414 at Cm.TibcoCore.Persistency.TibcoPersistencyManager.SaveCallRecord(TibcoCallRecord record, TibcoMessageExtractedField[] additionalFields, Exception[] extractedRequestFieldsExceptions, Exception[] extractedResponseFieldsExceptions) in D:\TfsBuilds\CM\CmProd1\3\s\CM\Cm.TibcoCore\Persistency\TibcoPersistencyManager.cs:line 391 at Cm.TibcoCore.Listener.TibcoListenerHandlerBase.HandleMessage(TibcoListenerHandlerArgs args) in D:\TfsBuilds\CM\CmProd1\3\s\CM\Cm.TibcoCore\Listener\TibcoListenerHandlerBase.cs:line 437 0x80004005 Reading from the stream has failed. MySql.Data at MySql.Data.MySqlClient.MySqlStream.LoadPacket() at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket() 0x80004005 Attempted to read past the end of the stream. MySql.Data at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count) at MySql.Data.MySqlClient.MySqlStream.LoadPacket() 0x80070026 Request XML: 500000005 GMJ161 NBI 208 1 Y 828673060 1 Y Response XML: 500000005 GMJ161 NBI 208 0 3 3 No find orders

Options: ReplyQuote


Subject
Written By
Posted
Exception: Authentication to host <myhost> for user <myuser> using method mysql_native_password failed with message: Reading from the stream has failed
December 11, 2018 04:24AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.