Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Please need help ASAP. Cant connect already two weeks, and project already started
I need to connect to MySQL (on supplier side). Connector installed (two months ago alreadry used this server). But in new project security team makes changes for security server.
So now i have:
login and password from My SQL Server
login and password from database (which i need) in this server
Port which i need to use.
But all of isn't work. And i get this error
What i can do?
https://bugs.mysql.com/bug.php?id=75917
http://www.voidcn.com/article/p-phfoefri-bpr.html
https://stackoverflow.com/questions/26652833/reading-from-the-stream-has-failed-mysqlexception
There is a lot of information out there about bugs with this so may be an issue with your version of MySQL
thanks for link, I have log file, but i dont understand all of this.
Actauly, if the srever has two step autentification, but i use only one. Maybe i need sql command which i need use firstly password from server&
Hi @answeriver ,
I couldn't find anything in the log file.
I do not know the two step authentication, can you describe it further?
do you use SSL certificates?
https://community.powerbi.com/t5/Power-Query/How-to-connect-to-a-datasource-with-SSL/m-p/671941
@mwegener yes. Below
bjectCacheSessions/Data/CacheStats/Size {"Start":"2020-04-22T02:24:48.9996114Z","Action":"ObjectCacheSessions/Data/CacheStats/Size","entryCount":"1","totalSize":"24","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0001336"}
ObjectCacheSessions/Data/CacheStats/Access {"Start":"2020-04-22T02:24:49.0001835Z","Action":"ObjectCacheSessions/Data/CacheStats/Access","hits":"0","requests":"1","hitrate":"0","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0000342"}
SimpleDocumentEvaluator/GetResult/Compile {"Start":"2020-04-22T02:24:49.1038888Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","HostProcessId":"21224","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"00aa24eb-61a3-464e-948c-c44b78276353","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.4145351"}
SimpleDocumentEvaluator/GetResult/Evaluate {"Start":"2020-04-22T02:24:49.5184469Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","HostProcessId":"21224","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"00aa24eb-61a3-464e-948c-c44b78276353","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.1349693"}
Engine/IO/Db/MySQL/Connection/Open {"Start":"2020-04-22T02:24:49.9025998Z","Action":"Engine/IO/Db/MySQL/Connection/Open","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"252fae01-4daf-411d-b633-457b8a276d6c","Exception":"Exception:\r\nExceptionType: MySql.Data.MySqlClient.MySqlException, MySql.Data, Version=8.0.18.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d\r\nMessage: Reading from the stream has failed.\r\nStackTrace:\n at MySql.Data.MySqlClient.MySqlStream.LoadPacket()\r\n at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n at MySql.Data.MySqlClient.NativeDriver.Open()\r\n at MySql.Data.MySqlClient.Driver.Open()\r\n at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)\r\n at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()\r\n at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()\r\n at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()\r\n at MySql.Data.MySqlClient.MySqlPool.GetConnection()\r\n at MySql.Data.MySqlClient.MySqlConnection.Open()\r\n at Microsoft.Mashup.Engine1.Library.Common.TracingDbConnection.<Open>b__3_0(IHostTrace trace)\r\n at Microsoft.Mashup.Engine1.Library.Common.Tracer.<>c__DisplayClass19_0.<TracePerformance>b__0(IHostTrace trace)\r\n at Microsoft.Mashup.Engine1.Library.Common.Tracer.TracePerformance[T](String method, Func`2 func)\r\n\r\nInnerException\r\nException:\r\nExceptionType: System.IO.EndOfStreamException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: Attempted to read past the end of the stream.\r\nStackTrace:\n at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)\r\n at MySql.Data.MySqlClient.MySqlStream.LoadPacket()\r\n\r\n\r\n\r\n\r\n","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"00aa24eb-61a3-464e-948c-c44b78276353","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:01:00.0062782"}
Engine/IO/Db/MySQL/Connection/Dispose {"Start":"2020-04-22T02:25:49.9379593Z","Action":"Engine/IO/Db/MySQL/Connection/Dispose","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"252fae01-4daf-411d-b633-457b8a276d6c","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"00aa24eb-61a3-464e-948c-c44b78276353","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0002775"}
Engine/IO/Db/MySQL/Connection/Dispose {"Start":"2020-04-22T02:25:49.9382607Z","Action":"Engine/IO/Db/MySQL/Connection/Dispose","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"252fae01-4daf-411d-b633-457b8a276d6c","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"00aa24eb-61a3-464e-948c-c44b78276353","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0000062"}
Engine/IO/Db/MySQL/Connection/Open {"Start":"2020-04-22T02:25:49.9741917Z","Action":"Engine/IO/Db/MySQL/Connection/Open","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"bf238437-7d29-4f5f-b517-ea805096cecf","Exception":"Exception:\r\nExceptionType: MySql.Data.MySqlClient.MySqlException, MySql.Data, Version=8.0.18.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d\r\nMessage: Reading from the stream has failed.\r\nStackTrace:\n at MySql.Data.MySqlClient.MySqlStream.LoadPacket()\r\n at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n at MySql.Data.MySqlClient.NativeDriver.Open()\r\n at MySql.Data.MySqlClient.Driver.Open()\r\n at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)\r\n at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()\r\n at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()\r\n at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()\r\n at MySql.Data.MySqlClient.MySqlPool.GetConnection()\r\n at MySql.Data.MySqlClient.MySqlConnection.Open()\r\n at Microsoft.Mashup.Engine1.Library.Common.TracingDbConnection.<Open>b__3_0(IHostTrace trace)\r\n at Microsoft.Mashup.Engine1.Library.Common.Tracer.<>c__DisplayClass19_0.<TracePerformance>b__0(IHostTrace trace)\r\n at Microsoft.Mashup.Engine1.Library.Common.Tracer.TracePerformance[T](String method, Func`2 func)\r\n\r\nInnerException\r\nException:\r\nExceptionType: System.IO.EndOfStreamException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: Attempted to read past the end of the stream.\r\nStackTrace:\n at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)\r\n at MySql.Data.MySqlClient.MySqlStream.LoadPacket()\r\n\r\n\r\n\r\n\r\n","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"00aa24eb-61a3-464e-948c-c44b78276353","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:59.9248355"}
Engine/IO/Db/MySQL/Connection/Dispose {"Start":"2020-04-22T02:26:49.8995732Z","Action":"Engine/IO/Db/MySQL/Connection/Dispose","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"bf238437-7d29-4f5f-b517-ea805096cecf","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"00aa24eb-61a3-464e-948c-c44b78276353","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0000339"}
Engine/IO/Db/MySQL/Connection/Dispose {"Start":"2020-04-22T02:26:49.8996452Z","Action":"Engine/IO/Db/MySQL/Connection/Dispose","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"bf238437-7d29-4f5f-b517-ea805096cecf","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"00aa24eb-61a3-464e-948c-c44b78276353","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0000141"}
SimpleDocumentEvaluator/GetResult<IPreviewValueSource> {"Start":"2020-04-22T02:24:49.1016097Z","Action":"SimpleDocumentEvaluator/GetResult<IPreviewValueSource>","HostProcessId":"21224","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"00aa24eb-61a3-464e-948c-c44b78276353","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:02:00.7904630"}
FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2020-04-22T02:24:49.0253167Z","Action":"FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"21224","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"00aa24eb-61a3-464e-948c-c44b78276353","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.6298648"}
SimpleDocumentEvaluator/GetResult/Compile {"Start":"2020-04-22T03:23:42.5786061Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","HostProcessId":"21224","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"6abedb33-6872-47b3-bfc2-04d63cc8e9e4","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0114522"}
SimpleDocumentEvaluator/GetResult/Evaluate {"Start":"2020-04-22T03:23:42.5903285Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","HostProcessId":"21224","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"6abedb33-6872-47b3-bfc2-04d63cc8e9e4","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0001891"}
Engine/IO/Db/MySQL/Connection/Open {"Start":"2020-04-22T03:23:42.5933473Z","Action":"Engine/IO/Db/MySQL/Connection/Open","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"008566b0-f686-42e8-850d-30abbb06bfa2","Exception":"Exception:\r\nExceptionType: MySql.Data.MySqlClient.MySqlException, MySql.Data, Version=8.0.18.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d\r\nMessage: Reading from the stream has failed.\r\nStackTrace:\n at MySql.Data.MySqlClient.MySqlStream.LoadPacket()\r\n at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n at MySql.Data.MySqlClient.NativeDriver.Open()\r\n at MySql.Data.MySqlClient.Driver.Open()\r\n at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)\r\n at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()\r\n at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()\r\n at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()\r\n at MySql.Data.MySqlClient.MySqlPool.GetConnection()\r\n at MySql.Data.MySqlClient.MySqlConnection.Open()\r\n at Microsoft.Mashup.Engine1.Library.Common.TracingDbConnection.<Open>b__3_0(IHostTrace trace)\r\n at Microsoft.Mashup.Engine1.Library.Common.Tracer.<>c__DisplayClass19_0.<TracePerformance>b__0(IHostTrace trace)\r\n at Microsoft.Mashup.Engine1.Library.Common.Tracer.TracePerformance[T](String method, Func`2 func)\r\n\r\nInnerException\r\nException:\r\nExceptionType: System.IO.EndOfStreamException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: Attempted to read past the end of the stream.\r\nStackTrace:\n at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)\r\n at MySql.Data.MySqlClient.MySqlStream.LoadPacket()\r\n\r\n\r\n\r\n\r\n","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"6abedb33-6872-47b3-bfc2-04d63cc8e9e4","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:59.9123595"}
Engine/IO/Db/MySQL/Connection/Dispose {"Start":"2020-04-22T03:24:42.5059085Z","Action":"Engine/IO/Db/MySQL/Connection/Dispose","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"008566b0-f686-42e8-850d-30abbb06bfa2","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"6abedb33-6872-47b3-bfc2-04d63cc8e9e4","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0000142"}
Engine/IO/Db/MySQL/Connection/Dispose {"Start":"2020-04-22T03:24:42.5059301Z","Action":"Engine/IO/Db/MySQL/Connection/Dispose","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"008566b0-f686-42e8-850d-30abbb06bfa2","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"6abedb33-6872-47b3-bfc2-04d63cc8e9e4","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0000108"}
Engine/IO/Db/MySQL/Connection/Open {"Start":"2020-04-22T03:24:42.5066378Z","Action":"Engine/IO/Db/MySQL/Connection/Open","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"8d0a0cab-7894-4e25-9b37-f2a603bb9391","Exception":"Exception:\r\nExceptionType: MySql.Data.MySqlClient.MySqlException, MySql.Data, Version=8.0.18.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d\r\nMessage: Reading from the stream has failed.\r\nStackTrace:\n at MySql.Data.MySqlClient.MySqlStream.LoadPacket()\r\n at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n at MySql.Data.MySqlClient.NativeDriver.Open()\r\n at MySql.Data.MySqlClient.Driver.Open()\r\n at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)\r\n at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()\r\n at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()\r\n at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()\r\n at MySql.Data.MySqlClient.MySqlPool.GetConnection()\r\n at MySql.Data.MySqlClient.MySqlConnection.Open()\r\n at Microsoft.Mashup.Engine1.Library.Common.TracingDbConnection.<Open>b__3_0(IHostTrace trace)\r\n at Microsoft.Mashup.Engine1.Library.Common.Tracer.<>c__DisplayClass19_0.<TracePerformance>b__0(IHostTrace trace)\r\n at Microsoft.Mashup.Engine1.Library.Common.Tracer.TracePerformance[T](String method, Func`2 func)\r\n\r\nInnerException\r\nException:\r\nExceptionType: System.IO.EndOfStreamException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: Attempted to read past the end of the stream.\r\nStackTrace:\n at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)\r\n at MySql.Data.MySqlClient.MySqlStream.LoadPacket()\r\n\r\n\r\n\r\n\r\n","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"6abedb33-6872-47b3-bfc2-04d63cc8e9e4","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:59.9998182"}
Engine/IO/Db/MySQL/Connection/Dispose {"Start":"2020-04-22T03:25:42.5068040Z","Action":"Engine/IO/Db/MySQL/Connection/Dispose","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"8d0a0cab-7894-4e25-9b37-f2a603bb9391","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"6abedb33-6872-47b3-bfc2-04d63cc8e9e4","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0000491"}
Engine/IO/Db/MySQL/Connection/Dispose {"Start":"2020-04-22T03:25:42.5068746Z","Action":"Engine/IO/Db/MySQL/Connection/Dispose","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"8d0a0cab-7894-4e25-9b37-f2a603bb9391","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"6abedb33-6872-47b3-bfc2-04d63cc8e9e4","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0000139"}
SimpleDocumentEvaluator/GetResult<IPreviewValueSource> {"Start":"2020-04-22T03:23:42.5785933Z","Action":"SimpleDocumentEvaluator/GetResult<IPreviewValueSource>","HostProcessId":"21224","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"6abedb33-6872-47b3-bfc2-04d63cc8e9e4","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:01:59.9285806"}
FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {"Start":"2020-04-22T03:23:42.5781114Z","Action":"FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"21224","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"6abedb33-6872-47b3-bfc2-04d63cc8e9e4","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0124273"}
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |