question

JPP-5001 avatar image
0 Votes"
JPP-5001 asked OuryBa-MSFT commented

Use of CONNECT ENGINE

Hello,

I want to use the "connect engine" from an external machine to an azure database.
The problem is with the connexion URL as the Microsoft "user" to connect to the Azure PAAS already contains an "@" which is (in other worlds) the user/host separator ...
Format of standard URL : mysql://user:password@host/database_name/table_name
as the "user" contains already an "@" on a MariaDB PAAS the URL is stated as "Syntax error" by Mariadb on the external server ....
Is there a solution to solve that problem.

Regards

azure-database-mariadb
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

2 Answers

GeethaThatipatri-MSFT avatar image
0 Votes"
GeethaThatipatri-MSFT answered

Hi @JPP-5001 Please check in escaping the special character from the username
https://docs.microfocus.com/OMi/10.62/Content/OMi/ExtGuide/ExtApps/URL_encoding.htm
I found something from the StackOverflow Probably this might help.

Regards
Geetha

5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OuryBa-MSFT avatar image
0 Votes"
OuryBa-MSFT answered OuryBa-MSFT commented

@JPP-5001 Thank you for posting your query. From my understanding you are trying to use a connect engine from an external machine to an azure database.

The best way to resolve this would be to use a proxy layer like MaxScale or ProxySQL in the middle as Azure DB for MariaDB requires username in the form username@servername. You can also refer to this blog for more details. Please note that the blog is written for MySQL, but it applies to MariaDB as well
Why is username@servername required to connect to Azure Database for MySQL? - Microsoft Tech Community

Please let us know if that is helpful

Regards,
Oury

· 1
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OuryBa-MSFT avatar image OuryBa-MSFT ·

@JPP-5001 Wanted to check if the above answer was helpful. Please let us know if you have additional queries regarding the above issue.

Regards,
Oury

0 Votes 0 ·