Installation through Azure Hybrid Connection

This forum is for issues with installing Joomla! 3.x on IIS webservers.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Post Reply
Skarsburning
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Fri Dec 08, 2017 9:04 pm

Installation through Azure Hybrid Connection

Post by Skarsburning » Thu Nov 29, 2018 7:27 am

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?

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 25944
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

Re: Installation through Azure Hybrid Connection

Post by Per Yngve Berg » Thu Nov 29, 2018 8:00 am

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

Skarsburning
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Fri Dec 08, 2017 9:04 pm

Re: Installation through Azure Hybrid Connection

Post by Skarsburning » Thu Nov 29, 2018 12:11 pm

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

User avatar
AMurray
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4869
Joined: Sat Feb 13, 2010 7:35 am
Location: Australia

Re: Installation through Azure Hybrid Connection

Post by AMurray » Fri Nov 30, 2018 8:22 am

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.
Regards,
--------------------------------------------------------------
A Murray
Millennium Falcon - it's the ship that made the Kessel run in less than 12 parsecs! The fastest hunk of junk in the galaxy.


Post Reply

Return to “Joomla! 3.x on IIS webserver”