Support

Site Restoration

#37302 Trying to import Joomla site via kickstart | Database Support = no

Posted in ‘Site restoration’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

PHP version
7.4.18
CMS Type
Joomla!
CMS Version
Joomla! 3.10.9
Backup Tool Version
Kickstart Core
Kickstart version
7.1.2

Latest post by nicholas on Monday, 20 June 2022 01:27 CDT

robertson33

Hello - I am trying to import my Joomla site from an akeeba backup, however when I get to the pre-install screen Database Support = No. How do I fix this?Β  Attatched is my PHP version.

I am running MySQL 5.7.34 and MAMP solution stack

Β 

nicholas
Akeeba Staff
Manager

Hm... there's something strange here. The phpinfo() page claims both mysqli and PDO MySQL are enabled on PHP 7.4.18. ANGIE, the restoration script, claims that mysqli is not enabled (by omission the initial check does not test for PDO MySQL, this is something I noticed and fixed four days ago).

There is only one reasonable way this can happen: the phpinfo page you sent me is not from the same version of PHP you are using to restore the site. MAMP does support using different versions of PHP per site, each PHP version has its own configuration.

Let's try something.

If you go to the next page, do you see any options in the drop-down menu? If so, don't worry, continue the restoration. Also rest assured that future versions of the restoration script will display the correct database support status in the main page as I am changing it to use the common detection code used in the Restore Database page to populate the dropdown.

If you see no options in the drop-down I would say the problem is that you are restoring to a different version of PHP, one which does not have either mysqli or PDO MySQL enabled. In this case I'd like to kindly request that you tell me which version of MAMP Pro you are using. My wife is on a recent if not the latest version of MAMP Pro and we observed no problems like that β€” we currently work in the same office, she runs a website studio, she restores sites all the time as part of the site development process and I can't deny her priority support for obvious reasons :)

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

robertson33

Hi - clicking next page i do see drop down options, see attached. I am able to restore my database afterall...

However, I am having issues with my CMS (Joomla) stopping connections to MySQL randomly with no obvious error so I figured something may still not be right in my PHP config.

I'm running MAMP v6.6.2 for ARM M1.

nicholas
Akeeba Staff
Manager

The database support does check for mysqli which I see in the dropdown list. I am not sure what is going on there. In any case I am not going to spend time on it as four days ago I changed how that check works. It will now be using the same checks used to show the dropdown of available database types. So that would work on your server.

> However, I am having issues with my CMS (Joomla) stopping connections to MySQL randomly with no obvious error so I figured something may still not be right in my PHP config.

It's not your site's configuration. That's MAMP. I've noticed that for whatever reason the MySQL server they supply seems to randomly crash. Restarting the database server through MAMP's interface fixes it.

I don't have this problem using MySQL 8.0.28 installed through Homebrew on my M1 Mac mini so it's definitely something about the MAMP-supplied binaries.

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

robertson33

Hi there - thanks for confirming this. Are you using MySQL 8 with MAMP in this case or standalone with macOS Apache?

nicholas
Akeeba Staff
Manager

Standalone. I gave up on MAMP years ago because it'd take forever to include new PHP versions, adding PECL extensions (especially SSH2 which I need for testing our software's SFTP features) was complicated and I disagreed on many performance settings.

For the past several years I install MySQL, Apache and PHP through Homebrew. I have documented my setup in my blog: Custom Apache and PHP server on macOS, the definitive 2019 edition     

Obviously with an M1 Mac the Homebrew installation is in /opt/homebrew instead of /usr/local so that part of all instructions needs to be changed. Also, the article being old was using PHP 5.6, 7.2 and 7.3. My current setup uses 7.4, 8.0 and 8.1 with 8.1 being the default. If we need to test against older PHP versions I either use my Linux box (I have PHP 5.6 to 8.1 inclusive over there) or Docker containers on my Intel MacBook Pro. To be honest, last I had to test with anything older than 7.4 was over a year ago so there's that.

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

robertson33

Hi there! Thanks for sharing this - I will give it a try :)

Let me ask you - any suggestions for how to troublehshoot MySQL crashing for the MAMP devs? When MySQL does crash, it does not generate any kind of logs (Apache/MySQL/PHP). MySQL process (mysqld) is still running in activity monitor and I can connect as localhost/root but I don't see my DB connections trying to browse my sites. Sites just continually spin. My non-db sites running Apache are all fine during this.

robertson33

Also, can't seem to find any reference to mysqld in system logs (console macOS)

nicholas
Akeeba Staff
Manager

Technically, MySQL has not crashed, it has become unresponsive. Until it crashes there will be no log dump. Even so, there's no use for it as I don't think they are using a debug build.

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!