No Code Attached Yet Information Required
avatar kamzar1
kamzar1
8 Sep 2021

J 4.0.2 Installation
php 7.4 / php7.4-fpm MariaDB 10.6.4

When starting the installation on https://joomla.my.domain/installation/index.php
At step DB, it shows "A Database error occurred" with no further elaboration:

dberror

This says browser console (Brave, chromium based):

dberror_console

Starting the installation over in http://domain solves the problem.

avatar kamzar1 kamzar1 - open - 8 Sep 2021
avatar joomla-cms-bot joomla-cms-bot - change - 8 Sep 2021
Labels Added: No Code Attached Yet
avatar joomla-cms-bot joomla-cms-bot - labeled - 8 Sep 2021
avatar PhilETaylor
PhilETaylor - comment - 8 Sep 2021

I cannot replicate this, starting an install on https:// urls results with all ajax calls being made over https://

Screenshot 2021-09-08 at 10 06 18

Can you give more information about your web hosting solution please?

Are you using Siteground or CloudFlare?

avatar kamzar1
kamzar1 - comment - 8 Sep 2021

Sure, you are right. It might be causing the issue in this case.
Traffic to Instance routed by HAProxy SSL offload.
That can be the issue! Instance get http requests, where HAProxy as middleware already had offloaded the ssl.

avatar PhilETaylor
PhilETaylor - comment - 8 Sep 2021

Joomla has never supported installation behind a terminated ssl connection. I have worked considerably on these issues in Joomla core.

However, once installed, you can then correctly configure Joomla to work behind a terminated ssl connection easily, with setting the force SSL setting and the new Behind Proxy settings.

avatar kamzar1
kamzar1 - comment - 8 Sep 2021

Thanks.
How to achieve this?

"However, once installed, you can then correctly configure Joomla to work behind a terminated ssl connection easily, with setting the force SSL setting and the new Behind Proxy settings

."

avatar PhilETaylor
PhilETaylor - comment - 8 Sep 2021

Just like you said:

Starting the installation over in http://domain solves the problem.

avatar PhilETaylor
PhilETaylor - comment - 8 Sep 2021

Please leave this issue open, because it should be simple for Joomla (me probably) to improve this so that it is possible in the future to install Joomla behind a ssl terminated load balancer

avatar kamzar1
kamzar1 - comment - 8 Sep 2021

That I got, but afterwards in normal operation modus, how to configure it for behind terminated ssl?
To get all links and HTTPRequests in https, despite having the http request.

avatar PhilETaylor
PhilETaylor - comment - 8 Sep 2021

Like I said:

However, once installed, you can then correctly configure Joomla to work behind a terminated ssl connection easily, with setting the force SSL setting and the new Behind Proxy settings.

Both these settings are in the Joomla Global Config.

avatar richard67
richard67 - comment - 12 Sep 2021

@kamzar1 Let us known if the above information helped you and if so, close this issue. Thanks in advance.

avatar Quy Quy - change - 12 Sep 2021
Labels Added: Information Required
avatar Quy Quy - labeled - 12 Sep 2021
avatar kamzar1 kamzar1 - close - 13 Sep 2021
avatar kamzar1
kamzar1 - comment - 13 Sep 2021

Information was helpful and issue solved.

avatar kamzar1 kamzar1 - change - 13 Sep 2021
Status New Closed
Closed_Date 0000-00-00 00:00:00 2021-09-13 13:00:13
Closed_By kamzar1
avatar richard67
richard67 - comment - 13 Sep 2021

@kamzar1 Thanks for reporting back.

avatar kamzar1 kamzar1 - change - 22 Nov 2021
Status Closed New
Closed_Date 2021-09-13 13:00:13
Closed_By kamzar1
avatar kamzar1 kamzar1 - reopen - 22 Nov 2021
avatar richard67
richard67 - comment - 22 Nov 2021

@kamzar1 Why reopened this?

avatar kamzar1
kamzar1 - comment - 22 Nov 2021

Problem was:
Behind an haproxy ssl off load
Installing Joomla in https://domain/installation has thrown a Database error.
Switching to http://domain during installation has solved the problem and after installation page has worked normal in https://domain.
I had similar issue with another application and these two steps helped:

  1. HA Proxy config:
    http-request set-header X-Forwarded-Proto https if { ssl_fc }

  2. Application:
    if ($_SERVER['HTTP_X_FORWARDED_PROTO'] == 'https') $_SERVER['HTTPS'] = 'on';

Perhaps a similar approach will help here as well?

avatar PhilETaylor
PhilETaylor - comment - 22 Nov 2021

Please close this and start a new issue for the new problem

avatar kamzar1 kamzar1 - change - 22 Nov 2021
Status New Closed
Closed_Date 0000-00-00 00:00:00 2021-11-22 06:41:58
Closed_By kamzar1
avatar kamzar1 kamzar1 - close - 22 Nov 2021
avatar kamzar1
kamzar1 - comment - 22 Nov 2021

Not a new problem, just a suggestion.
Closing anyway.

Add a Comment

Login with GitHub to post a comment