Jump to content
c41n

Prestashop 1.7 Azure MySQL installation.

Recommended Posts

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

844603237_CapturadePantalla2020-06-15ala(s)13_06_59.thumb.png.619eee9979e5f7c743ec8627e3d55374.png

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

344464810_CapturadePantalla2020-06-15ala(s)13_28_26.thumb.png.c90b2915069013ec07602a46eca2a9ce.png

What I'm doing wrong ?

For advanced, thanks for you help.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Hi musicmaster, thanks for you replay.

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

1609097683_CapturadePantalla2020-06-15ala(s)15_13_26.thumb.png.f589affda265aadbb674cacbf1033a06.png

And the error is :

933091253_CapturadePantalla2020-06-15ala(s)15_15_22.thumb.png.341b6f59d78bcb2ac2f7ddf7f3ce4e78.png

Do you have any idea how I can solve it?

Thanks.

Share this post


Link to post
Share on other sites
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: 

728163205_CapturadePantalla2020-06-15ala(s)15_30_35.thumb.png.5f57d02bd2ade1d5951802b570155412.png

And the PHP code works

image.png.a7121bcd3983d9dd0b8a36cd4582743e.png

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?

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More