PHP connection string for mysql db is false

[eiffel-fl]

Hi.

I found a bug in azure-cli where php connection string outputted is wrong.
Here is how to reproduce:

docker run -u $(id -u):$(id -g) -v ${HOME}:/home/az -e HOME=/home/az --rm -it mcr.microsoft.com/azure-cli:latest
az login --scope https://management.core.windows.net//.default
az mysql server show-connection-string -s "foo-mysql-server" -o json | jq .connectionStrings.php
"host=foo-mysql-server.mysql.database.azure.com port=3306 dbname={database} user={username}@fran92-mysql-server password={password}"

This string will not permit connection, also on Portal, the following is given:

$con=mysqli_init(); [mysqli_ssl_set($con, NULL, NULL, {ca-cert filename}, NULL, NULL);] mysqli_real_connect($con, "foo-mysql-server.mysql.database.azure.com", "username@foo-mysql-server.mysql.database.azure.com", {your_password}, {your_database}, 3306);

I will deal with this bug, I just opened this issue to remember about it because I do not know when I will exactly deal with it.

Best regards.

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @ambhatna, @savjani.

Issue Details

---

Hi.

I found a bug in azure-cli where php connection string outputted is wrong.
Here is how to reproduce:

docker run -u $(id -u):$(id -g) -v ${HOME}:/home/az -e HOME=/home/az --rm -it mcr.microsoft.com/azure-cli:latest
az login --scope https://management.core.windows.net//.default
az mysql server show-connection-string -s "foo-mysql-server" -o json | jq .connectionStrings.php
"host=foo-mysql-server.mysql.database.azure.com port=3306 dbname={database} user={username}@fran92-mysql-server password={password}"

This string will not permit connection, also on Portal, the following is given:

$con=mysqli_init(); [mysqli_ssl_set($con, NULL, NULL, {ca-cert filename}, NULL, NULL);] mysqli_real_connect($con, "foo-mysql-server.mysql.database.azure.com", "username@foo-mysql-server.mysql.database.azure.com", {your_password}, {your_database}, 3306);

I will deal with this bug, I just opened this issue to remember about it because I do not know when I will exactly deal with it.

Best regards.

Author:	eiffel-fl
Assignees:	-
Labels:	Service Attention, MySQL, customer-reported
Milestone:	-

[yonzhan]

route to service team

[savjani]

Adding @mksuni to help