Comment # 7
on bug 1205162
from Eric Schirra
(In reply to Petr Gajdos from comment #6)
> (In reply to Eric Schirra from comment #5)
> > > The very same line (extension=mysqlnd) is present already in
> > > /etc/php7/conf.d/_mysqlnd.ini and in case I add it into
> > > /etc/php7/apache2/php.ini I could not get anything else than:
> >
> > Yes. I know that. But for some reason, it doesn't work.
>
> I guess we will have to find the reason then.
>
> > > PHP Warning: Module 'mysqlnd' already loaded in Unknown on line 0
> > > [Wed Jan 04 12:22:30.402842 2023] [mpm_prefork:notice] [pid 7666] AH00163:
> > > Apache/2.4.51 (Linux/SUSE) OpenSSL/1.1.1l PHP/7.4.33 configured -- resuming
> > > normal operations
> > > in error_log. So, could you please try to figure out why _mysqlnd.ini is not
> > > taken into account on your system? Could you try to inspect phpinfo() run
> > > trough apache sapi? Perhaps also php -m output (warnings/errors)?
>
> And what phpinfo() run trough apache sapi says on the system on which
> application does not run?
Again. The Systerm is one and runs multiple applications. This now several
years and several Leap version without problems. Only with the update from 15.3
to 15.4 the problems occurred. See also other messages on the web.
Some applications run, some do not.
See my example data.
Without my fix is see only:
mysqlnd
mysqlnd enabled
Version mysqlnd 7.4.33
Compression supported
core SSL supported
extended SSL supported
Command buffer size 4096
Read buffer size 32768
Read timeout 86400
Collecting statistics Yes
Collecting memory statistics No
Tracing n/a
Loaded plugins
mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_caching_sha2_password,auth_plugin_sha256_password
API Extensions pdo_mysql
PDO
PDO support enabled
PDO drivers mysql, pgsql, sqlite
pdo_mysql
PDO Driver for MySQL enabled
Client API version mysqlnd 7.4.33
Directive Local Value Master Value
pdo_mysql.default_socket /run/mysql/mysql.sock /run/mysql/mysql.sock
With my fix i see:
mysqli
MysqlI Support enabled
Client API library version mysqlnd 7.4.33
Active Persistent Links 0
Inactive Persistent Links 0
Active Links 0
Directive Local Value Master Value
mysqli.allow_local_infile Off Off
mysqli.allow_persistent Off Off
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket /run/mysql/mysql.sock /run/mysql/mysql.sock
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.max_persistent Unlimited Unlimited
mysqli.reconnect Off Off
mysqli.rollback_on_cached_plink Off Off
mysqlnd
mysqlnd enabled
Version mysqlnd 7.4.33
Compression supported
core SSL supported
extended SSL supported
Command buffer size 4096
Read buffer size 32768
Read timeout 86400
Collecting statistics Yes
Collecting memory statistics No
Tracing n/a
Loaded plugins
mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_caching_sha2_password,auth_plugin_sha256_password
API Extensions mysqli,pdo_mysql
PDO
PDO support enabled
PDO drivers mysql, pgsql, sqlite
pdo_mysql
PDO Driver for MySQL enabled
Client API version mysqlnd 7.4.33
Directive Local Value Master Value
pdo_mysql.default_socket /run/mysql/mysql.sock /run/mysql/mysql.sock
> > No error with php -m.
> > mysqlnd is shown.
> > Some application run, some not.
> > For some application it show "mysqli not found" in log.
> > Some other apps don't rise up an error.
> >
> > When i add in /etc/php7/apache2/php.ini:
> > extension=mysqlnd
>
> Which is superfluous in case /etc/php7/conf.d/_mysqlnd.ini is read and thus
> not justifiable in general.
Am I speaking or writing Chinese?
It's just not enough.
Definitely not!
Do not always just dismiss everything as if everyone else were stupid and had
no idea.
You can find more people with the same problem on the Internet. And if I
remember correctly, they were all with suse problems.