Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

Drako3090

Problem connecting MySQL database with the On-premises Data Gateway

Submitted by on ‎08-24-2018 01:53 PM

vHi. I'm trying to connect a MySQL database with the On-premises Data Gateway, but I can't. I have the following error:

 

Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Show details

Troubleshoot connection problems
 
This is the only database I can not connect to the gateway. I can connect to it without any problem from the Power BI Desktop, and I'm using the same credentials por the PBIService with the gateway, but I still get the same error, no matter what. I uptaded my gateway to the last version to avoid some problems, but it still the same.
 
I'm forgeting the most important fact: The database was already connected, and it worked well the last six months without problems, but today it started with this issue and I don't know how to fix it. Please help.
 
Thank you
 
Rodrigo Vega
Status: Needs Info
See more ideas labeled with:
4 Comments (4 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎08-27-2018 02:25 AM

Hi @Drako3090,

 

What's the detail information when you click Show details? 

 

Best Regards,
Qiuyun Yu 

v-qiuyu-msft
Community Support
Community Support
‎08-27-2018 02:25 AM
Status changed to: Needs Info
 
Drako3090
Regular Visitor
‎08-27-2018 03:42 AM

Hi @v-qiuyu-msft

 

Literally? Nothing, the link has "app.powerbi.com" as destiny, there is not information when I click it, and the other link on the "Troubleshooting connecton problem" has an error 404...

Drako3090
Regular Visitor
‎08-27-2018 05:38 AM

@v-qiuyu-msft

 

The link started to provide an error code. I will post now:

 

Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details

Activity ID:ca6ab753-f958-4bca-902c-98110c21499c
Request ID:a9e93a3a-c373-6d8b-a4cf-e769b2ba786b
Cluster URI:https://wabi-south-central-us-redirect.analysis.windows.net
Status code:400
Error Code:DMTS_PublishDatasourceToClusterErrorCode
Time:Mon Aug 27 2018 09:35:04 GMT-0300 (hora de verano de Chile)
Version:13.0.6430.141
Conexiones BI:Cannot connect to the mashup data source. See error details for more information.
Underlying error code:-2147467259
Underlying error message:MySQL: Host '192.168.0.151' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
DM_ErrorDetailNameCode_UnderlyingHResult:-2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind:MySql
Microsoft.Data.Mashup.ValueError.DataSourcePath:192.168.0.29;asteriskcdrdb
Microsoft.Data.Mashup.ValueError.ErrorCode:-2147467259
Microsoft.Data.Mashup.ValueError.Message:Host '192.168.0.151' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
Microsoft.Data.Mashup.ValueError.Reason:DataSource.Error
Idea Statuses