Problem to run installer.php

Hi all,

Further to my previous posting

Now I have removed PHP 8.1.14 and installed PHP 7.4. But encountered other problems;

PHP config

Support for the PHP mysqli extension is required. Please contact your hosting provider or server administrator to enable the mysqli extension. The detection for this call uses the function_exists(‘mysqli_connect’) call.

Host Connection fail

I have spent 3~4 hours unable to fixed the problem

Please help. Thanks

Can you contact your hosting provider to ensure you have this PHP ext installed:
Support for the PHP?mysqli extension?is required. Please contact your hosting provider or server administrator to enable the mysqli extension

Hi,

Thanks for your advice. I’m administrator. Please advise how to do it? Thanks

I just installed LAMP server on Ubuntu 22.04. I don’t expect it is so difficult. In the past I installed LAMP server on Ubuntu 20.04 and then migrated Duplicator packages on it. It went through without problem.

Regards

Google “how to check if you have mysqli extension installed” There are plenty of highly detailed guides on the internet explaining this process.

Hi,

Thanks for your advice. I read that document before but unfortunately I can’t install php5-mysql

$ sudo apt-get update -y
$ sudo apt-get install -y php5-mysql
Reading package lists… Done
Building dependency tree… Done
Reading state information… Done
Package php5-mysql is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source

E: Package ‘php5-mysql’ has no installation candidate

I’m running Ubuntu 22.04 here. Please help. Thanks

Regards

This would be outside the scope of support we provide. I recommend visiting https://serverfault.com/ for assistance setting up your server.

Again. I sorted out the problem of mysql extension

It should run;

sudo apt-get install -y php5.6-mysql

But there is another problem;

Validation Fail
This installation will not be able to proceed until the archive and validation sections both pass. Please adjust your servers settings click validate buttom or contact your server administrator, hosting provider or visit the resources below for additional help.

Pls help how to solve this problem. Thanks

Can you send us a screenshot of the validation items not passing

Hi

Hi

Today PHP Mysqli (mysqli extension) problem comes back disregarding php5.6-mysql already installed

$ apt policy php5.6-mysql
php5.6-mysql:
Installed: 5.6.40-64+ubuntu22.04.1+deb.sury.org+1
Candidate: 5.6.40-64+ubuntu22.04.1+deb.sury.org+1
Version table:
*** 5.6.40-64+ubuntu22.04.1+deb.sury.org+1 500
500 https://ppa.launchpadcontent.net/ondrej/php/ubuntu jammy/main amd64 Packages
100 /var/lib/dpkg/status

Please refers to the URL of the screenshot attached

Regards

https://www.dropbox.com/s/oghnaif4wqezh8a/screenshot-1_30.jpg?dl=0

• This reply was modified 1 year, 10 months ago by satimis.
• This reply was modified 1 year, 10 months ago by satimis.

This means it can’t locate the mysqli extension. If you look at phpinfo(); can you confirm mysqli is installed and active. You should see something like https://d.pr/5KqiSL

On Terminal run;
$ php -i > php_info.txt

php_info.txt is 24.8 kB in size. How can I upload it here?

$ php -m | grep mysqli
No output. I suppose mysqli not installed yet

OK, that needs to be installed for it to work and you can confirm by looking at the phpinfo() Again I would consult https://serverfault.com/?for assistance setting up your serve.

Hi,

I couldn’t imagine that it is so difficult for me. Finally I solved the problem through difficulties, hard working and heavy searching on Internet.

Solution:-

1. sudo apt-get install php7.4-mysqli (install php7.4-mysqli)
2. MySql password limitation;
   8 characters (it is a must)
   Upper and lower scale characters
   Must consist a special character. First I used @ but fail and then changed it to #. It works

There is still a warning;
STATUS
character set and collation isn’t supported on current database. “Legacy Character set” and “Legacy Collation” will be replaced with default values.

(check) I have read and accept all terms & notices*
-> Next

Now the website is running on local server (my PC). The Duplicator packages are newly created and download from a live website running on Internet.

I have about 40 live sites running on Internet. All of them have cloned sites running on local servers. I have been running migration on Duplicator packages for long time,

My old local server is running Ubuntu 20.04. Now my new local server is running Ubuntu 22.04. That is the ONLY difference. I still have the old local server running.

I’ll continue cloning the rest live websites on my new server. Should I encounter new problem. I’ll come back.

Thanks

Regards

• This reply was modified 1 year, 10 months ago by satimis.

Thanks for posting the solution.

Hi,

Another funny thing here is;
On Ubuntu 20.04 it doesn’t require mysql extension to install the Duplicator packages.

$ php -v
PHP 7.4.3 (cli) (built: Nov 2 2022 09:53:44) ( NTS )
Copyright (c) The PHP Group
Zend Engine v3.4.0, Copyright (c) Zend Technologies
with Zend OPcache v7.4.3, Copyright (c), by Zend Technologies

$ apache2 -v
Server version: Apache/2.4.41 (Ubuntu)
Server built: 2022-06-14T13:30:55

Besides right from the beginning when I first migrated live site to clone site on local server (long time ago), I have to change the permalinks;

Live site, Permalinks;
Post name/Custom Structure

It can’t work on the cloned site on local server. I have to change the Permalinks to Plain. Otherwise I can’t change pages.

Up to now I can’t find out the cause.

Regards