Fresh install 3.9.25 hanging during install Topic is solved

[3tdk]

I'm really hoping someone can shed some advice on this topic. I'm trying to make a fresh install 3.9.25.

I can unpack the files to the server location and they are correctly served. Connection to the database has been checked by the installer. On the "finalisation" page of the installer all the pre-installation check items are marked as "yes", except write access to configuration.php which it says I can manually copy later.

On clicking "install" the progress bar starts moving (and the animated joomla logo) but the process hangs every time at "Creating configuration file". It looks like all the correct tables are created in the SQL DB.

I have the following php.ini settings:

Code: Select all

memory_limit - 256MB
upload_max_filesize -  30M
post_max_size - 30M
max_execution_time:  3000

I'm struggling with the lack of feedback on what's causing the problem - can anyone steer me how to debug this installation issue any further?

There are no errors reported in /var/log/php-fpm/www-error.log (except the ones from the FPA tool)

(I can make a clean install on my live web host so I'm happy with the installation process)

Thank you so much for any steering.

Here is the FPA data from as far as the installation seems to get:

[09-Apr-2021 19:59:35 UTC] PHP Warning: simplexml_load_file(): I/O warning : failed to load external entity "https://update.joomla.org/core/list.xml" in /var/www/html/fpa-en.php on line 3106

Joomla! Instance :: Joomla! 3.9.25-Stable (Amani) 02-March-2021
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Not Found

Host Configuration :: OS: Linux | OS Version: 4.18.0-240.el8.x86_64 | Technology: x86_64 | Web Server: Apache/2.4.37 (centos) | Encoding: gzip, deflate | System TMP Writable: Yes | Free Disk Space : 5.55 GiB |

PHP Configuration :: Version: 7.2.24 | PHP API: fpm-fcgi | Session Path Writable: Yes | Display Errors: | Error Reporting: 22527 | Log Errors To: /var/log/php-fpm/www-error.log | Last Known Error: 09th April 2021 20:25:12. | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 30M | Max. POST Size: 30M | Max. Input Time: 60 | Max. Execution Time: 3000 | Memory Limit: 256M

Database Configuration :: Database Credentials incomplete or not available Nothing to display.
Missing credentials detected: Connection Type missing | Database Name missing |MySQL Host missing | Table Prefix missing | Database Username missing | Database Password missing |User Privileges : Unknown

PHP Extensions :: Core (7.2.24) | date (7.2.24) | libxml (7.2.24) | openssl (7.2.24) | pcre (7.2.24) | zlib (7.2.24) | filter (7.2.24) | hash (1.0) | Reflection (7.2.24) | SPL (7.2.24) | session (7.2.24) | standard (7.2.24) | cgi-fcgi () | bz2 (7.2.24) | calendar (7.2.24) | ctype (7.2.24) | curl (7.2.24) | dom (20031129) | mbstring (7.2.24) | fileinfo (1.0.5) | ftp (7.2.24) | gd (7.2.24) | gettext (7.2.24) | iconv (7.2.24) | intl (1.1.0) | json (1.6.0) | ldap (7.2.24) | exif (7.2.24) | mysqlnd (mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $) | PDO (7.2.24) | Phar (2.0.2) | SimpleXML (7.2.24) | soap (7.2.24) | sockets (7.2.24) | sqlite3 (7.2.24) | tokenizer (7.2.24) | xml (7.2.24) | xmlwriter (7.2.24) | xsl (7.2.24) | mysqli (7.2.24) | pdo_mysql (7.2.24) | pdo_sqlite (7.2.24) | wddx (7.2.24) | xmlreader (7.2.24) | xmlrpc (7.2.24) | zip (1.15.3) | Zend OPcache (7.2.24) | Zend Engine (3.2.0) |
Potential Missing Extensions ::

Switch User Environment :: PHP CGI: No | Server SU: No | PHP SU: No | Potential Ownership Issues: Yes

Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (---) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) | administrator/logs/ (755) |

Elevated Permissions (First 10) ::

Components :: Site ::
Core :: com_mailto (3.0.0) ? | com_wrapper (3.0.0) ? |
3rd Party::

Components :: Admin ::
Core :: com_plugins (3.0.0) ? | com_postinstall (3.2.0) ? | com_modules (3.0.0) ? | com_associations (3.7.0) ? | com_cpanel (3.0.0) ? | com_messages (3.0.0) ? | com_config (3.0.0) ? | com_admin (3.0.0) ? | com_finder (3.0.0) ? | com_ajax (3.2.0) ? | com_media (3.0.0) ? | com_redirect (3.0.0) ? | com_banners (3.0.0) ? | com_cache (3.0.0) ? | com_fields (3.7.0) ? | com_users (3.0.0) ? | com_content (3.0.0) ? | com_actionlogs (3.9.0) ? | com_contenthistory (3.2.0) ? | com_joomlaupdate (3.6.2) ? | com_languages (3.0.0) ? | com_templates (3.0.0) ? | com_checkin (3.0.0) ? | com_search (3.0.0) ? | com_installer (3.0.0) ? | com_privacy (3.9.0) ? | com_tags (3.1.0) ? | com_categories (3.0.0) ? | com_newsfeeds (3.0.0) ? | com_menus (3.0.0) ? | com_login (3.0.0) ? |
3rd Party::

Modules :: Site ::
Core :: mod_whosonline (3.0.0) ? | mod_wrapper (3.0.0) ? | mod_feed (3.0.0) ? | mod_articles_latest (3.0.0) ? | mod_random_image (3.0.0) ? | mod_footer (3.0.0) ? | mod_search (3.0.0) ? | mod_custom (3.0.0) ? | mod_articles_popular (3.0.0) ? | mod_articles_categories (3.0.0) ? | mod_breadcrumbs (3.0.0) ? | mod_users_latest (3.0.0) ? | mod_stats (3.0.0) ? | mod_login (3.0.0) ? | mod_syndicate (3.0.0) ? | mod_tags_popular (3.1.0) ? | mod_articles_news (3.0.0) ? | mod_related_items (3.0.0) ? | mod_tags_similar (3.1.0) ? | mod_languages (3.5.0) ? | mod_banners (3.0.0) ? | mod_articles_archive (3.0.0) ? | mod_menu (3.0.0) ? | mod_articles_category (3.0.0) ? | mod_finder (3.0.0) ? |
3rd Party::

Modules :: Admin ::
Core :: mod_submenu (3.0.0) ? | mod_toolbar (3.0.0) ? | mod_feed (3.0.0) ? | mod_version (3.0.0) ? | mod_quickicon (3.0.0) ? | mod_logged (3.0.0) ? | mod_status (3.0.0) ? | mod_title (3.0.0) ? | mod_custom (3.0.0) ? | mod_latest (3.0.0) ? | mod_privacy_dashboard (3.9.0) ? | mod_login (3.0.0) ? | mod_latestactions (3.9.0) ? | mod_multilangstatus (3.0.0) ? | mod_stats_admin (3.0.0) ? | mod_sampledata (3.8.0) ? | mod_menu (3.0.0) ? | mod_popular (3.0.0) ? |
3rd Party::

Libraries ::
Core ::
3rd Party::

Plugins ::
Core :: plg_privacy_message (3.9.0) ? | plg_privacy_user (3.9.0) ? | plg_privacy_consents (3.9.0) ? | plg_privacy_actionlogs (3.9.0) ? | plg_privacy_content (3.9.0) ? | plg_quickicon_extensionupdate (3.0.0) ? | plg_quickicon_privacycheck (3.9.0) ? | plg_quickicon_phpversioncheck (3.7.0) ? | plg_quickicon_joomlaupdate (3.0.0) ? | plg_user_terms (3.9.0) ? | plg_user_contactcreator (3.0.0) ? | plg_user_profile (3.0.0) ? | plg_user_joomla (3.0.0) ? | plg_installer_packageinstaller (3.6.0) ? | PLG_INSTALLER_FOLDERINSTALLER (3.6.0) ? | PLG_INSTALLER_URLINSTALLER (3.6.0) ? | plg_fields_checkboxes (3.7.0) ? | plg_fields_imagelist (3.7.0) ? | plg_fields_repeatable (3.9.0) ? | plg_fields_integer (3.7.0) ? | plg_fields_usergrouplist (3.7.0) ? | plg_fields_text (3.7.0) ? | plg_fields_user (3.7.0) ? | plg_fields_textarea (3.7.0) ? | plg_fields_color (3.7.0) ? | plg_fields_editor (3.7.0) ? | plg_fields_url (3.7.0) ? | plg_fields_calendar (3.7.0) ? | plg_fields_radio (3.7.0) ? | plg_fields_sql (3.7.0) ? | plg_fields_list (3.7.0) ? | plg_fields_media (3.7.0) ? | plg_extension_joomla (3.0.0) ? | plg_search_categories (3.0.0) ? | plg_search_contacts (3.0.0) ? | plg_search_tags (3.0.0) ? | plg_search_newsfeeds (3.0.0) ? | plg_search_content (3.0.0) ? | plg_authentication_ldap (3.0.0) ? | plg_authentication_cookie (3.0.0) ? | plg_authentication_gmail (3.0.0) ? | plg_authentication_joomla (3.0.0) ? | plg_editors-xtd_menu (3.7.0) ? | plg_editors-xtd_pagebreak (3.0.0) ? | plg_editors-xtd_image (3.0.0) ? | plg_editors-xtd_fields (3.7.0) ? | plg_editors-xtd_module (3.5.0) ? | plg_editors-xtd_article (3.0.0) ? | plg_editors-xtd_readmore (3.0.0) ? | plg_finder_categories (3.0.0) ? | plg_finder_contacts (3.0.0) ? | plg_finder_tags (3.0.0) ? | plg_finder_newsfeeds (3.0.0) ? | plg_finder_content (3.0.0) ? | plg_content_pagenavigation (3.0.0) ? | plg_content_confirmconsent (3.9.0) ? | plg_content_pagebreak (3.0.0) ? | plg_content_fields (3.7.0) ? | plg_content_vote (3.0.0) ? | plg_content_finder (3.0.0) ? | plg_content_loadmodule (3.0.0) ? | plg_content_emailcloak (3.0.0) ? | plg_content_joomla (3.0.0) ? | PLG_ACTIONLOG_JOOMLA (3.9.0) ? | plg_captcha_recaptcha (3.4.0) ? | plg_captcha_recaptcha_invisible (3.8) ? | plg_system_updatenotification (3.5.0) ? | plg_system_remember (3.0.0) ? | plg_system_log (3.0.0) ? | plg_system_redirect (3.0.0) ? | plg_system_p3p (3.0.0) ? | plg_system_sessiongc (3.8.6) ? | plg_system_sef (3.0.0) ? | plg_system_fields (3.7.0) ? | plg_system_privacyconsent (3.9.0) ? | plg_system_languagecode (3.0.0) ? | plg_system_cache (3.0.0) ? | plg_system_highlight (3.0.0) ? | plg_system_logrotation (3.9.0) ? | plg_system_debug (3.0.0) ? | plg_system_languagefilter (3.0.0) ? | PLG_SYSTEM_ACTIONLOGS (3.9.0) ? | plg_system_stats (3.5.0) ? | plg_system_logout (3.0.0) ? | plg_twofactorauth_totp (3.2.0) ? | plg_twofactorauth_yubikey (3.2.0) ? |
3rd Party:: plg_editors_codemirror (5.56.0) ? | plg_editors_tinymce (4.5.12) ? |

Templates :: Site :: beez3 (3.1.0) ? | protostar (1.0) ? |
Templates :: Admin :: hathor (3.0.0) ? | isis (1.0) ? |

[AMurray]

I can't see anything wrong with your environment from the FPA provided (lot of information missing, of course, due to no Joomla installed).

Before starting the install make sure the file (folder) permissions are all "write" permissions (on Linux/Unix that's CHMOD 755, or equivalent for other O/S's.

One stand-out item I would mention, is you're using PHP 7.2 which is obsolete (as of January 2021); I would update to PHP 7.3 at minimum or 7.4 (recommended).

configuration.php shouldn't have write access; it should be CHMOD 444. That file is created during the Joomla installation but since the installation has failed, that file is not present (according to the FPA report).

[3tdk]

Thanks @AMurray.

Permissions issues seem to be all sorted now (I can secure down for production but since this is a development system I'm happy the permissions are no longer a challenge)

This server is a virtual CentOS running on a synology NAS, so it isn't the fastest but I'm sure it is up to the job. During creation of the database tables there is a lot of drive activity and then everything just stops and the web UI hangs; is there likely to be some other timeout at play (say if the SQL DB was being particularly slow?)

Any further way to debug what's going on?

[09-Apr-2021 20:25:12 UTC] PHP Warning: simplexml_load_file(): I/O warning : failed to load external entity "https://update.joomla.org/core/list.xml" in /var/www/html/fpa-en.php on line 3106

Joomla! Instance :: Joomla! 3.9.25-Stable (Amani) 02-March-2021
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Not Found

Host Configuration :: OS: Linux | OS Version: 4.18.0-240.22.1.el8_3.x86_64 | Technology: x86_64 | Web Server: Apache/2.4.37 (centos) | Encoding: gzip, deflate | System TMP Writable: Yes | Free Disk Space : 5.56 GiB |

PHP Configuration :: Version: 7.2.24 | PHP API: fpm-fcgi | Session Path Writable: Yes | Display Errors: | Error Reporting: 22527 | Log Errors To: /var/log/php-fpm/www-error.log | Last Known Error: 09th April 2021 20:25:12. | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 30M | Max. POST Size: 30M | Max. Input Time: 120 | Max. Execution Time: 3000 | Memory Limit: 512M

Database Configuration :: Database Credentials incomplete or not available Nothing to display.
Missing credentials detected: Connection Type missing | Database Name missing |MySQL Host missing | Table Prefix missing | Database Username missing | Database Password missing |User Privileges : Unknown

PHP Extensions :: Core (7.2.24) | date (7.2.24) | libxml (7.2.24) | openssl (7.2.24) | pcre (7.2.24) | zlib (7.2.24) | filter (7.2.24) | hash (1.0) | Reflection (7.2.24) | SPL (7.2.24) | session (7.2.24) | standard (7.2.24) | cgi-fcgi () | bz2 (7.2.24) | calendar (7.2.24) | ctype (7.2.24) | curl (7.2.24) | dom (20031129) | mbstring (7.2.24) | fileinfo (1.0.5) | ftp (7.2.24) | gd (7.2.24) | gettext (7.2.24) | iconv (7.2.24) | intl (1.1.0) | json (1.6.0) | ldap (7.2.24) | exif (7.2.24) | mysqlnd (mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $) | PDO (7.2.24) | Phar (2.0.2) | SimpleXML (7.2.24) | soap (7.2.24) | sockets (7.2.24) | sqlite3 (7.2.24) | tokenizer (7.2.24) | xml (7.2.24) | xmlwriter (7.2.24) | xsl (7.2.24) | mysqli (7.2.24) | pdo_mysql (7.2.24) | pdo_sqlite (7.2.24) | wddx (7.2.24) | xmlreader (7.2.24) | xmlrpc (7.2.24) | zip (1.15.3) | Zend OPcache (7.2.24) | Zend Engine (3.2.0) |
Potential Missing Extensions ::

Switch User Environment :: PHP CGI: No | Server SU: No | PHP SU: No | Potential Ownership Issues: No

Core Folders :: images/ (775) | components/ (775) | modules/ (775) | plugins/ (775) | language/ (775) | templates/ (775) | cache/ (775) | logs/ (---) | tmp/ (775) | administrator/components/ (775) | administrator/modules/ (775) | administrator/language/ (775) | administrator/templates/ (775) | administrator/logs/ (775) |

Elevated Permissions (First 10) :: administrator/ (775) | administrator/language/ (775) | administrator/language/en-GB/ (775) | administrator/language/overrides/ (775) | administrator/templates/ (775) | administrator/templates/hathor/ (775) | administrator/templates/hathor/language/ (775) | administrator/templates/hathor/language/en-GB/ (775) | administrator/templates/hathor/less/ (775) | phpinfo/ (775) |

Components :: Site ::
Core :: com_mailto (3.0.0) ? | com_wrapper (3.0.0) ? |
3rd Party::

Components :: Admin ::
Core :: com_plugins (3.0.0) ? | com_postinstall (3.2.0) ? | com_modules (3.0.0) ? | com_associations (3.7.0) ? | com_cpanel (3.0.0) ? | com_messages (3.0.0) ? | com_config (3.0.0) ? | com_admin (3.0.0) ? | com_finder (3.0.0) ? | com_ajax (3.2.0) ? | com_media (3.0.0) ? | com_redirect (3.0.0) ? | com_banners (3.0.0) ? | com_cache (3.0.0) ? | com_fields (3.7.0) ? | com_users (3.0.0) ? | com_content (3.0.0) ? | com_actionlogs (3.9.0) ? | com_contenthistory (3.2.0) ? | com_joomlaupdate (3.6.2) ? | com_languages (3.0.0) ? | com_templates (3.0.0) ? | com_checkin (3.0.0) ? | com_search (3.0.0) ? | com_installer (3.0.0) ? | com_privacy (3.9.0) ? | com_tags (3.1.0) ? | com_categories (3.0.0) ? | com_newsfeeds (3.0.0) ? | com_menus (3.0.0) ? | com_login (3.0.0) ? |
3rd Party::

Modules :: Site ::
Core :: mod_whosonline (3.0.0) ? | mod_wrapper (3.0.0) ? | mod_feed (3.0.0) ? | mod_articles_latest (3.0.0) ? | mod_random_image (3.0.0) ? | mod_footer (3.0.0) ? | mod_search (3.0.0) ? | mod_custom (3.0.0) ? | mod_articles_popular (3.0.0) ? | mod_articles_categories (3.0.0) ? | mod_breadcrumbs (3.0.0) ? | mod_users_latest (3.0.0) ? | mod_stats (3.0.0) ? | mod_login (3.0.0) ? | mod_syndicate (3.0.0) ? | mod_tags_popular (3.1.0) ? | mod_articles_news (3.0.0) ? | mod_related_items (3.0.0) ? | mod_tags_similar (3.1.0) ? | mod_languages (3.5.0) ? | mod_banners (3.0.0) ? | mod_articles_archive (3.0.0) ? | mod_menu (3.0.0) ? | mod_articles_category (3.0.0) ? | mod_finder (3.0.0) ? |
3rd Party::

Modules :: Admin ::
Core :: mod_submenu (3.0.0) ? | mod_toolbar (3.0.0) ? | mod_feed (3.0.0) ? | mod_version (3.0.0) ? | mod_quickicon (3.0.0) ? | mod_logged (3.0.0) ? | mod_status (3.0.0) ? | mod_title (3.0.0) ? | mod_custom (3.0.0) ? | mod_latest (3.0.0) ? | mod_privacy_dashboard (3.9.0) ? | mod_login (3.0.0) ? | mod_latestactions (3.9.0) ? | mod_multilangstatus (3.0.0) ? | mod_stats_admin (3.0.0) ? | mod_sampledata (3.8.0) ? | mod_menu (3.0.0) ? | mod_popular (3.0.0) ? |
3rd Party::

Libraries ::
Core ::
3rd Party::

Plugins ::
Core :: plg_privacy_message (3.9.0) ? | plg_privacy_user (3.9.0) ? | plg_privacy_consents (3.9.0) ? | plg_privacy_actionlogs (3.9.0) ? | plg_privacy_content (3.9.0) ? | plg_quickicon_extensionupdate (3.0.0) ? | plg_quickicon_privacycheck (3.9.0) ? | plg_quickicon_phpversioncheck (3.7.0) ? | plg_quickicon_joomlaupdate (3.0.0) ? | plg_user_terms (3.9.0) ? | plg_user_contactcreator (3.0.0) ? | plg_user_profile (3.0.0) ? | plg_user_joomla (3.0.0) ? | plg_installer_packageinstaller (3.6.0) ? | PLG_INSTALLER_FOLDERINSTALLER (3.6.0) ? | PLG_INSTALLER_URLINSTALLER (3.6.0) ? | plg_fields_checkboxes (3.7.0) ? | plg_fields_imagelist (3.7.0) ? | plg_fields_repeatable (3.9.0) ? | plg_fields_integer (3.7.0) ? | plg_fields_usergrouplist (3.7.0) ? | plg_fields_text (3.7.0) ? | plg_fields_user (3.7.0) ? | plg_fields_textarea (3.7.0) ? | plg_fields_color (3.7.0) ? | plg_fields_editor (3.7.0) ? | plg_fields_url (3.7.0) ? | plg_fields_calendar (3.7.0) ? | plg_fields_radio (3.7.0) ? | plg_fields_sql (3.7.0) ? | plg_fields_list (3.7.0) ? | plg_fields_media (3.7.0) ? | plg_extension_joomla (3.0.0) ? | plg_search_categories (3.0.0) ? | plg_search_contacts (3.0.0) ? | plg_search_tags (3.0.0) ? | plg_search_newsfeeds (3.0.0) ? | plg_search_content (3.0.0) ? | plg_authentication_ldap (3.0.0) ? | plg_authentication_cookie (3.0.0) ? | plg_authentication_gmail (3.0.0) ? | plg_authentication_joomla (3.0.0) ? | plg_editors-xtd_menu (3.7.0) ? | plg_editors-xtd_pagebreak (3.0.0) ? | plg_editors-xtd_image (3.0.0) ? | plg_editors-xtd_fields (3.7.0) ? | plg_editors-xtd_module (3.5.0) ? | plg_editors-xtd_article (3.0.0) ? | plg_editors-xtd_readmore (3.0.0) ? | plg_finder_categories (3.0.0) ? | plg_finder_contacts (3.0.0) ? | plg_finder_tags (3.0.0) ? | plg_finder_newsfeeds (3.0.0) ? | plg_finder_content (3.0.0) ? | plg_content_pagenavigation (3.0.0) ? | plg_content_confirmconsent (3.9.0) ? | plg_content_pagebreak (3.0.0) ? | plg_content_fields (3.7.0) ? | plg_content_vote (3.0.0) ? | plg_content_finder (3.0.0) ? | plg_content_loadmodule (3.0.0) ? | plg_content_emailcloak (3.0.0) ? | plg_content_joomla (3.0.0) ? | PLG_ACTIONLOG_JOOMLA (3.9.0) ? | plg_captcha_recaptcha (3.4.0) ? | plg_captcha_recaptcha_invisible (3. ? | plg_system_updatenotification (3.5.0) ? | plg_system_remember (3.0.0) ? | plg_system_log (3.0.0) ? | plg_system_redirect (3.0.0) ? | plg_system_p3p (3.0.0) ? | plg_system_sessiongc (3.8.6) ? | plg_system_sef (3.0.0) ? | plg_system_fields (3.7.0) ? | plg_system_privacyconsent (3.9.0) ? | plg_system_languagecode (3.0.0) ? | plg_system_cache (3.0.0) ? | plg_system_highlight (3.0.0) ? | plg_system_logrotation (3.9.0) ? | plg_system_debug (3.0.0) ? | plg_system_languagefilter (3.0.0) ? | PLG_SYSTEM_ACTIONLOGS (3.9.0) ? | plg_system_stats (3.5.0) ? | plg_system_logout (3.0.0) ? | plg_twofactorauth_totp (3.2.0) ? | plg_twofactorauth_yubikey (3.2.0) ? |
3rd Party:: plg_editors_codemirror (5.56.0) ? | plg_editors_tinymce (4.5.12) ? |

Templates :: Site :: beez3 (3.1.0) ? | protostar (1.0) ? |
Templates :: Admin :: hathor (3.0.0) ? | isis (1.0) ? |

[abernyte]

Ah... Synology NAS!
The Synology listens on the wrong socket for a Joomla MySQL connection hence you will need to change the default.
Sign into Synology's DSM and go into webstation.
There go to Webstation > PHP Settings > CORE
Scroll down until you find MySQLi.default_socket. The value should be /run/mysqld/mysqld.sock
Change this manually to: /run/mysqld/mysqld10.sock
Hopefully you will now be good to install.

[Per Yngve Berg]

File permissions shall be 755 (not 775)

Check your PHP API: fpm-fcgi configuration. What Linux user is it running under? Create a separate user that is different from the web server (apache). The files shall be owned by this new user. This prevents cross contamination with the rest of the server if this site got hacked.

[3tdk]

Sign into Synology's DSM and go into webstation.

Thanks Abernyte. Actually I am running two systems on the same NAS

• First I attempted an install using the DSM set-up (synology packages for MariaDB, Apache, PHP, etc). I managed to get a database connection using "localhost:/run/mysqld/mysqld10.sock" in the joomla install, but I suffered the same hanging issue
• Second, I tried again by installing a CentOS virtual machine on the same NAS. This appears on my network as a completely new device and I don't think it shares any settings with the host NAS. In this case the database connection is to localhost. That is the install I am referring to here. Unfortunately I am seeing the same hanging issue.

There is a comment on this post viewtopic.php?t=972223 that the SQL access can be a bit "laggy" meaning that the database might not be up to date by the time the next query on it is run. That's why I moved to the virtual machine set-up - I had hoped this would get around whatever synology were doing in their own install. No such luck it seems, but I am trying to work out how to nail that down as the cause of the problem.

That post mentions using debug tools in the browser which can monitor for a 504 response on an AJAX call, but I was wondering if there is any logging available in the Joomla installer script which would give me a view from the other end of the story.

File permissions shall be 755 (not 775)

Thanks for that comment - I will look into that when I'm in production (I'm planning to completely reinstall the VM from scratch once I have worked out the key to this install problem)

[3tdk]

Fixed! Thank you for the help and motivation to continue.

I was suffering the same gateway timeout issue reported in this post viewtopic.php?t=972223. It stops after exactly 60 seconds.

This thread has the details of how someone else fixed it https://stackoverflow.com/questions/373 ... 60-seconds

To resolve, I had to

• Change the default socket timeout to 6000
• Add "Timeout 6000" to httpd.conf fixed it

The OP gives these instructions for CentOS 8 (I made the changes manually but you can see what they are doing)

Code: Select all

sed -i 's/default_socket_timeout = 60/default_socket_timeout = 6000/g' /etc/php.ini
sed -i 's/max_input_time = 60/max_input_time = 30000/g' /etc/php.ini
sed -i 's/max_execution_time = 30000/max_execution_time = 60000/g' /etc/php.ini
echo "Timeout 6000" >> /etc/httpd/conf/httpd.conf

c.f. the firefox debug tools screenshot attached. When it was resolved, that task took 187 seconds to complete on this server.

I'm not sure it would be possible to solve this on a raw synology install as access to httpd.conf is not easy.

Now to rebuild it all from scratch and undo all the hacking about I did during debug!

[abernyte]

Well done. Synology do not make it easy to alter the default profile and that looks like new twists and turns added by using Centos8 which I have not seen before.
I am now using QNAP instead so have little reason venture there. QNAP seems to play nicer!

[3tdk]

File permissions shall be 755 (not 775)

Check your PHP API: fpm-fcgi configuration. What Linux user is it running under? Create a separate user that is different from the web server (apache). The files shall be owned by this new user. This prevents cross contamination with the rest of the server if this site got hacked.

Just for full completeness, I now have this set up as a basic configuration by following the post at https://www.getpagespeed.com/server-set ... -should-be

When I did that, the webserver was serving normal html and php pages properly, including an installed joomla site... but when I accessed the joomla installer the server was reporting "Session did not start" errors and putting entries in the apache error logs. This was resolved by ensuring the entry for php_value[session.save_path] (at the bottom of the php-fpm.d site file) was set to a writeable folder. I set mine to a new "/var/www/session" location.

For write access to any folder on CentOS you also have to change the selinux settings so it doesn't try to overprotect things https://serverfault.com/questions/92915 ... ion-denied e.g.

Code: Select all

sudo chcon -Rv -t httpd_sys_rw_content_t /var/www/html
sudo chcon -Rv -t httpd_sys_rw_content_t /var/www/sessionl