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

[Greg Wooledge]

On Fri, Mar 29, 2024 at 11:49:06AM +0100, Bernard wrote:
> Hi to Everyone,
> 
> The text quoted below has already been sent to the list, 2-3 days ago,
> someone had replied to it (but the message has been lost, I no longer see it
> on the list. I had replied again, which reply disappeared too.)
> So, I want to say again that the errors shown in the text below (S instead
> of $, ` inst of ') are not errors that I made in the php script, which
> scripts I write using old vi (vim). This was due to the fact that some parts
> of my messages here were typed using LibreOffice and parts were copy/pasted
> here.

That was something you wrote in a private reply to me, not to the list.

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

[Bernard]

Hi to Everyone,

The text quoted below has already been sent to the list, 2-3 days ago, 
someone had replied to it (but the message has been lost, I no longer 
see it on the list. I had replied again, which reply disappeared too.)
So, I want to say again that the errors shown in the text below (S 
instead of $, ` inst of ') are not errors that I made in the php script, 
which scripts I write using old vi (vim). This was due to the fact that 
some parts of my messages here were typed using LibreOffice and parts 
were copy/pasted here.


So, my actual concern still is that I can't get a php 7.4 script to call 
for a value entry, as I did years ago with older version.

 $nom = S_GET [‘nom’] ;
>
> no longer operates with php 7.4. This code is simply ignored. S_REQUEST,
> $_POST do not work either.
I spent hours searching for a way to get php to ask for an entry, but I 
didn't find anything.


On 28/03/2024 10:33, Bernard wrote:
Yes, this list (exactly the same here) shows that mysqli.so is loaded. 
In any case, as said before, this function does operate as I have checked.


But I've found more problems, concerning $_REQUEST, $_GET...

The old way that I used 11 yrs ago no longer works :

$nom = S_GET [‘nom’] ;

no longer operates with php 7.4. This code is simply ignored. S_REQUEST, 
$_POST do not work either.


Could someone show me how I should write these few lines dating 2010… 
(worked at least till 2013), which code is now ignored by php 7.4 with 
no explanations since I don’t have debugging function active. This 
example code comes from Kevin Yanks' s book dating 2010 :




These lines are now ignored by php 7.4

In any case, I’ve checked my php.ini (which I sent here a few days ago), 
and it seems to say that cookies are activated as well as $_REQUEST and 
other concerned functions.


On 26/03/2024 10:38, Bernard wrote:

ls -Al /usr/lib/php/20190902

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

[Greg Wooledge]

On Thu, Mar 28, 2024 at 10:36:01AM +0100, Bernard wrote:
> But I've found more problems, concerning $_REQUEST, $_GET...
> 
> The old way that I used 11 yrs ago no longer works :
> 
> $nom = S_GET [‘nom’] ;
> 
> no longer operates with php 7.4. This code is simply ignored. S_REQUEST,
> $_POST do not work either.

You mentioned $_GET and then you wrote S_GET.

You also have Unicode curly quote marks there, not ASCII apostrophes.

It's impossible for us to tell whether your PHP code is actually broken,
or whether you *retyped* it with errors for your email.

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

[Bernard]

Yes, this list (exactly the same here) shows that mysqli.so is loaded. 
In any case, as said before, this function does operate as I have checked.


But I've found more problems, concerning $_REQUEST, $_GET...

The old way that I used 11 yrs ago no longer works :

$nom = S_GET [‘nom’] ;

no longer operates with php 7.4. This code is simply ignored. S_REQUEST, 
$_POST do not work either.


Could someone show me how I should write these few lines dating 2010… 
(worked at least till 2013), which code is now ignored by php 7.4 with 
no explanations since I don’t have debugging function active. This 
example code comes from Kevin Yanks' s book dating 2010 :




These lines are now ignored by php 7.4

In any case, I’ve checked my php.ini (which I sent here a few days ago), 
and it seems to say that cookies are activated as well as $_REQUEST and 
other concerned functions.


On 26/03/2024 10:38, Bernard wrote:

ls -Al /usr/lib/php/20190902

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

[Jeffrey Walton]

On Tue, Mar 26, 2024 at 1:17 PM Marco Moock  wrote:
>
> Am 26.03.2024 um 10:33:59 Uhr schrieb Bernard:
>
> > I have the two // in the displayed error messages. However the file
> > is where it should be, without double //
>
> The this seems to be a bug because if it searches for //file it will
> definitely not find it.
> Can you use strace to verify that?

Also see .

Jeff

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

[David Wright]

On Tue 26 Mar 2024 at 09:43:37 (-0400), Cindy Sue Causey wrote:
> On Tue, Mar 26, 2024 at 6:04 AM Bernard  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.

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

[Marco Moock]

Am 26.03.2024 um 10:33:59 Uhr schrieb Bernard:

> I have the two // in the displayed error messages. However the file
> is where it should be, without double //

The this seems to be a bug because if it searches for //file it will
definitely not find it.
Can you use strace to verify that?

-- 
Gruß
Marco

Send unsolicited bulk mail to 1711445639mu...@cartoonies.org

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

[Cindy Sue Causey]

On Tue, Mar 26, 2024 at 6:04 AM Bernard  wrote:
>
> I have progressed a little in my trials.
>
> mysqli.so still shows the previously described problems, and I thought that 
> this was responsible of the fact that mysqli functions were apparently 
> discarded in the test programs I wrote.
>
> I discovered that this was due to errors I made in the php program. The 
> errors in the script being corrected, mysqli_connect, mysqli_select_db, 
> mysqli_query... now do operate... despite the errors concerning mysqli.so 
> that I discovered when running the tests which are proposed by 'baeldung.com'
>
> "
>
> $ 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.

Cindy :)

-- 
Cindy-Sue Causey
Talking Rock, Pickens County, Georgia, USA
* runs with birdseed *

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

[Bernard]

I have progressed a little in my trials.

mysqli.so still shows the previously described problems, and I thought 
that this was responsible of the fact that mysqli functions were 
apparently discarded in the test programs I wrote.


I discovered that this was due to errors I made in the php program. The 
errors in the script being corrected, mysqli_connect, mysqli_select_db, 
mysqli_query... now do operate... despite the errors concerning 
mysqli.so that I discovered when running the tests which are proposed by 
'baeldung.com'


"

|$ 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

"

On 24/03/2024 19:51, Bernard wrote:


Hi to Everyone !

*PHP Warning: PHP Startup: Unable to load dynamic library 
'//usr/lib/php/20190902/mysqli.so' * *However, the file is there... 
not human readable as expected* *and mysqli_connect doesn't operate.*


*Thanks in advance for your help*
*Bernard*

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

[Bernard]

ls -Al /usr/lib/php/20190902
total 7732
-rw-r--r-- 1 root root   34920  9 juin   2023 calendar.so
-rw-r--r-- 1 root root   14440  9 juin   2023 ctype.so
-rw-r--r-- 1 root root   92264  9 juin   2023 exif.so
-rw-r--r-- 1 root root  161896  9 juin   2023 ffi.so
-rw-r--r-- 1 root root 5744752  9 juin   2023 fileinfo.so
-rw-r--r-- 1 root root   67688  9 juin   2023 ftp.so
-rw-r--r-- 1 root root   14440  9 juin   2023 gettext.so
-rw-r--r-- 1 root root   51304  9 juin   2023 iconv.so
-rw-r--r-- 1 root root   47208  9 juin   2023 json.so
-rw-r--r-- 1 root root  145512  9 juin   2023 mysqli.so
-rw-r--r-- 1 root root  255832  9 juin   2023 mysqlnd.so
-rw-r--r-- 1 root root  551440  9 juin   2023 opcache.so
-rw-r--r-- 1 root root   34920  9 juin   2023 pdo_mysql.so
-rw-r--r-- 1 root root  112744  9 juin   2023 pdo.so
-rw-r--r-- 1 root root  280680  9 juin   2023 phar.so
-rw-r--r-- 1 root root   39016  9 juin   2023 posix.so
-rw-r--r-- 1 root root   34920  9 juin   2023 readline.so
-rw-r--r-- 1 root root   14440  9 juin   2023 shmop.so
-rw-r--r-- 1 root root   96360  9 juin   2023 sockets.so
-rw-r--r-- 1 root root   22632  9 juin   2023 sysvmsg.so
-rw-r--r-- 1 root root   14440  9 juin   2023 sysvsem.so
-rw-r--r-- 1 root root   14440  9 juin   2023 sysvshm.so
-rw-r--r-- 1 root root   26728  9 juin   2023 tokenizer.so

On 24/03/2024 23:04, Jeffrey Walton wrote:

ls -Al
/usr/lib/php/20190902

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

[Bernard]

On 24/03/2024 20:02, Marco Moock wrote:

Am Sun, 24 Mar 2024 19:51:05 +0100
schrieb Bernard :


'//usr/lib/php/20190902/mysqli.so'

Is that really the path in the message?
The 2 // must not be there.


I have the two // in the displayed error messages. However the file is 
where it should be, without double //

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

[Jeffrey Walton]

On Sun, Mar 24, 2024 at 5:57 PM Bernard  wrote:
>
> Hi to Everyone !
>
> PHP Warning: PHP Startup: Unable to load dynamic library 
> '//usr/lib/php/20190902/mysqli.so' However, the file is there... not human 
> readable as expected and mysqli_connect doesn't operate.

Please provide the output of `ls -Al /usr/lib/php` and `ls -Al
/usr/lib/php/20190902`. If you are running SeLinux, then use `ls -AlZ`
instead.

Also state what user your web server runs under.

You may need to show your php.ini.

Jeff

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

[Geert Stappers]

On Sun, Mar 24, 2024 at 07:51:05PM +0100, Bernard wrote:
> *PHP Warning: PHP Startup: Unable to load dynamic library
> '//usr/lib/php/20190902/mysqli.so'

|$ apt-file search mysqli.so
|php8.2-mysql: /usr/lib/php/20220829/mysqli.so
|$


So on my system, trixie, I would do `sudo apt install php8.2-mysql`
and try again.


Groeten
Geert Stappers
-- 
Silence is hard to parse

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

[Marco Moock]

Am Sun, 24 Mar 2024 19:51:05 +0100
schrieb Bernard :

> '//usr/lib/php/20190902/mysqli.so'

Is that really the path in the message?
The 2 // must not be there.