Installation through Azure Hybrid Connection

[Skarsburning]

Hi everyone,

With the increased popularity of the PaaS Azure App Services platform, i want to give it a try in all possible ways. Everything works, except for when trying to install Joomla (3.91) through a Hybrid Connection. Now, please don't ask me why i would choose this, there are valid reasons to use Joomla over a Hybrid Connection. However, i can't seem to make it work. I have experience in running SQL dependent ASP.Net simple apps through a Hybrid Connection and they work fine but not Wordpress/Joomla.

So let me give you an idea of the setup:

1. I have a Web App in Azure App Services. Simple Web App with no additional options

2. I have a VM with MySQL listening on 3306 with a bind-address = 0.0.0.0
SQL Instance - https://prnt.sc/lodmch

3. I have a Hybrid Connection working between the Web App and the VM, confirmed by tcpping from the Web App to the VM, through the Hybrid Connection endpoint
Tcpping - https://prnt.sc/lodmts

4. I load the wwwrooot of the Web App with the Joomla files and i browse to it. The Installation page opens and i start defining my db connection
Here is how - https://prnt.sc/lodnwr

The endpoint defined in my Hybrid Connection is "iis-2016" on port 3306. I've tried many different ways playing with the "Host Name" and what to have in there. Well, actually there aren't many things i can try really ... I tried iis-2016, iis-2016:3306 .... no idea what else to try. There must be a way to make this work.

I placed a db-connect-test.php, script which tries a simple db connection. I try my usual db connection entries and when i execute i get

Connection failed: The server requested authentication method unknown to the client

Any ideas?

[Per Yngve Berg]

Mod. Note: Relocated the topic to the Installation on IIS servers. This forum is for Apache on Linux.

[Skarsburning]

Hey everyone,

I partially resolved it. I will say why partially.

I turned on php errors to get more visibility on what the problem is and saw that the server rejects the authentication method [caching_sha2_password]

I read that MySQL 8.0.4 has changed the default authentication to caching_sha2_password.

https://mysqlserverteam.com/mysql-8-0-4 ... _password/

I tried switching (no sql expert obviously) to mysql_native_password but i broke my MySql server so much that i actually uninstalled it (was dev anyway) and installed 5.7 which worked like a charm right away after the installation. I just created a new database for the web app and then tried to install

https://prnt.sc/lohlmj

so yes - seems like Joomla over Hybrid Connection does work but it needs fine tuning if you are running the 8xx versions. I will give a try to run it on the newest version by tweaking the authentication issue

[AMurray]

Joomla is not guaranteed to work with MySQL 8.x, although its system requirements doesn't say that, it still recommends 5.5.x or there abouts - but to MySQL 8.x is a big version jump.