Re: Debian 11 PHP 7.4 – Mysql 8 - Can’t get Mysqli_connect to work

[David Wright <deblis@lionunicorn.co.uk>]

On Tue 26 Mar 2024 at 09:43:37 (-0400), Cindy Sue Causey wrote:
> On Tue, Mar 26, 2024 at 6:04 AM Bernard <bdebreil@free.fr> wrote:
[ … ]
> > $ php -m | grep mysqli
> >
> > "If the MySQLi extension is enabled, we’ll see mysqli in the output. Otherwise, the output will be empty."
> >
> > php -m grep mysqli
> >
> > PHP Warning:  PHP Startup: Unable to load dynamic library '//usr/lib/php/20190902/mysqli.so' (tried: //usr/lib/php/20190902/mysqli.so (//usr/lib/php/20190902/mysqli.so: undefined symbol: mysqlnd_global_stats), /usr/lib/php/20190902///usr/lib/php/20190902/mysqli.so.so (/usr/lib/php/20190902///usr/lib/php/20190902/mysqli.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
> > PHP Warning:  PHP Startup: Unable to load dynamic library 'mysqli' (tried: /usr/lib/php/20190902/mysqli (/usr/lib/php/20190902/mysqli: cannot open shared object file: No such file or directory), /usr/lib/php/20190902/mysqli.so (/usr/lib/php/20190902/mysqli.so: undefined symbol: mysqlnd_global_stats)) in Unknown on line 0
> > mysqli
> 
> Just observing out loud: What's generating that double slash, i.e. "//usr,"
> in the start of the message? That seems like a possible show stopper.

At a glance, the first warning looks like it might be the
unsophisticated concatenation and substitution of paths,
without regard for either leading and trailing delimiters
or filename extensions:

  null plus /usr/lib/php/20190902/mysqli.so

  /usr/lib/php/20190902/ plus /usr/lib/php/20190902/mysqli.so plus .so
                              -------------------------------
                substitution ↗

The second warning looks more significant, but mysqli is outside my
area of knowledge. Nonetheless, "mysqli" was seen in the last line,
though without any context: grep might be helped along by -A and -B.

Cheers,
David.