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:
This says browser console (Brave, chromium based):
Starting the installation over in http://domain solves the problem.
Labels |
Added:
No Code Attached Yet
|
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.
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.
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
."
Just like you said:
Starting the installation over in http://domain solves the problem.
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
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.
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.
Labels |
Added:
Information Required
|
Information was helpful and issue solved.
Status | New | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2021-09-13 13:00:13 |
Closed_By | ⇒ | kamzar1 |
Status | Closed | ⇒ | New |
Closed_Date | 2021-09-13 13:00:13 | ⇒ | |
Closed_By | kamzar1 | ⇒ |
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:
HA Proxy config:
http-request set-header X-Forwarded-Proto https if { ssl_fc }
Application:
if ($_SERVER['HTTP_X_FORWARDED_PROTO'] == 'https') $_SERVER['HTTPS'] = 'on';
Perhaps a similar approach will help here as well?
Please close this and start a new issue for the new problem
Status | New | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2021-11-22 06:41:58 |
Closed_By | ⇒ | kamzar1 |
Not a new problem, just a suggestion.
Closing anyway.
I cannot replicate this, starting an install on https:// urls results with all ajax calls being made over https://
Can you give more information about your web hosting solution please?
Are you using Siteground or CloudFlare?