Prestashop 1.7 Azure MySQL installation.

[c41n]

Hi everyone,

I'v trying to install Prestashop 1.7 on CentOS 8 with php-fpm and Azure MySQL (database as a service). However, when I a fill fields with Azure MySQL login information in formulary and I test connection, I get the next error

My database already exist on server and login from my web server is ok

What I'm doing wrong ?

For advanced, thanks for you help.

[musicmaster]

Did you try with a simple php file whether you can connect with those values using mysqli_connect()?

[c41n]

Hi musicmaster, thanks for you replay.

I've tried with the next script from official Azure documentation:

And the error is :

Do you have any idea how I can solve it?

Thanks.

[c41n]

Ok, I'v found a workaround from Azure official documentation using SSL connection:

https://docs.microsoft.com/en-us/azure/mysql/howto-configure-ssl

I've modify the code like this: 

And the PHP code works

My question now is .... how I can use this workaround with Prestashop ? .... any Idea ?

[musicmaster]

11 hours ago, c41n said:

Ok, I'v found a workaround from Azure official documentation using SSL connection:

https://docs.microsoft.com/en-us/azure/mysql/howto-configure-ssl

I've modify the code like this: 

And the PHP code works

My question now is .... how I can use this workaround with Prestashop ? .... any Idea ?

And what happens when you run this script - without mysqli_ssl_set - as a https program?

[c41n]

Quote

And what happens when you run this script - without mysqli_ssl_set - as a https program?

Show "Failed to connect to Mysql" 

Sorry for long delay to response.

Reading Azure MySQL documentation, the correct way to implement Prestashop with Azure MySQL databases is using Service endpoints (to local VM communication inside vNet subnet), InnoDB driver and disabling SSL security.

I hope this information is useful with this type of implementations.