[Bug 1205162] PHP mysqli not load from web after upgrade
https://bugzilla.suse.com/show_bug.cgi?id=1205162 https://bugzilla.suse.com/show_bug.cgi?id=1205162#c7 --- Comment #7 from Eric Schirra <ecsos@schirra.net> --- (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. -- You are receiving this mail because: You are on the CC list for the bug.
participants (1)
-
bugzilla_noreply@suse.com