Forum Discussion
Flujo de datos con ODBC con SSL
I understand that you're having trouble trying to configure a data flow through a standard gateway. The error "Access denied for user" indicates an authentication issue.
Try the following steps:
Verify user credentials. Make sure that user 'befesa_ro' has the appropriate permissions in the MySQL database.
Configure SSL on the gateway. You need to make sure that the SSL certificate is installed and properly configured on the machine running the gateway.
The connection string you provided appears to be incomplete in terms of SSL configuration. You'll need to add the necessary parameters to specify the location of the SSL certificate. Such as:
Driver={MySQL ODBC 8.1 Unicode Driver};Server=Helpdesk.befesa.com;Port=3306;Database=otrs;sslca={path_to_ca_certificate};sslcert={path_to_cert_certificate};sslkey={path_to_key_certificate};
Replace {path_to_ca_certificate}, {path_to_cert_certificate}, and {path_to_key_certificate} with the actual file path of your certificate.
Once the connection string is updated, try to test the connection through the standard gateway again.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Anonymous
First of all, thanks for you reply.
The user and password are correct because I use them in my computer and they work correctly, I have access to the database and I can work normally with Power BI Desktop, the problem is when I try to configure the ODBC connection in cloud, in the Power BI website, where I have published the pbix to share it with other people.
I have also used the sslca, sslcert and sslkey using local paths, for example, c:\users\"user"\Desktop\file.pem for each value, should I use a local path or how should I use this parameters? I tried to upload the 3 certificates to sharepoint and use the sharepoint link as path but it didn´t work.
Thanks.