libmysqlclient >= 5.5.3, compatibilty with MariaDB

Are you using mysqlnd (in php.ini)? The check has maybe only been tested against that since that's what it seems to check first, and then does a generic fallback check for the number 5.5.3.

Yes, I am.

php -i | grep mysqlnd shows

mysqlnd => enabled

Version => mysqlnd 5.0.12-dev

Is it possible your web server and command line are using different versions of php or separate php.ini's? Some hosting is set up that way. The check isn't about mariadb specifically it's about the client library that php is using.

Are you able to put in a debug line in this file just before line 924 to see what it thinks $version is? https://github.com/civicrm/civicrm-core/blob/5.15.1/CRM/Utils/Check/Component/Env.php#L923

Something like this would display it along with the other messages:

$messages[] = new CRM_Utils_Check_Message(
          __FUNCTION__ . 'mysqlnd',
          "Version is $version",
          ts('PHP MySQL Driver (mysqlnd)'),
          \Psr\Log\LogLevel::WARNING,
          'fa-server'
        );

Entered the statement, output:

In php info, this is the configure command (generated by DirectAdmin's Custombuild)

'./configure' '--prefix=/usr/local/php73' '--program-suffix=73' '--enable-fpm' '--with-fpm-systemd' '--with-config-file-scan-dir=/usr/local/php73/lib/php.conf.d' '--with-curl' '--with-gd' '--with-gettext' '--with-jpeg-dir=/usr/local/lib' '--with-freetype-dir=/usr/local/lib' '--with-libxml-dir=/usr/local/lib' '--with-kerberos' '--with-openssl' '--with-mhash' '--with-mysql-sock=/var/lib/mysql/mysql.sock' '--with-mysqli=mysqlnd' '--with-pcre-regex=/usr/local' '--with-pdo-mysql=mysqlnd' '--with-pear' '--with-png-dir=/usr/local/lib' '--with-sodium=/usr/local' '--with-webp-dir=/usr/local/lib' '--with-xsl' '--with-zlib' '--enable-zip' '--without-libzip' '--with-iconv=/usr/local' '--enable-bcmath' '--enable-calendar' '--enable-exif' '--enable-ftp' '--enable-sockets' '--enable-soap' '--enable-mbstring' '--with-icu-dir=/usr/local/icu' '--enable-intl'

@mfb ping

added triaged type:request labels

added sig:bug label

I also have this error in my CIVICRM installation

Additional .ini files parsed => /etc/php/7.3/cli/conf.d/10-mysqlnd.ini,
Client API library version => mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $
mysqlnd
mysqlnd => enabled
Version => mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $
Loaded plugins => mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_sha256_password
mysqlnd statistics =>
Client API version => mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $

and I also have mariadb 10...

apt search ^mariadb|grep installed

WARNING: apt does not have a stable CLI interface. Use with caution in scripts.

libmariadb3/unknown,now 1:10.4.6+maria~stretch amd64 [installed,automatic]
mariadb-client/unknown,now 1:10.4.6+maria~stretch all [installed]
mariadb-client-10.4/unknown,now 1:10.4.6+maria~stretch amd64 [installed,automatic]
mariadb-client-core-10.4/unknown,now 1:10.4.6+maria~stretch amd64 [installed,automatic]
mariadb-common/unknown,now 1:10.4.6+maria~stretch all [installed]
mariadb-server/unknown,now 1:10.4.6+maria~stretch all [installed]
mariadb-server-10.4/unknown,now 1:10.4.6+maria~stretch amd64 [installed,automatic]
mariadb-server-core-10.4/unknown,now 1:10.4.6+maria~stretch amd64 [installed,automatic]
mysql-common/unknown,now 1:10.4.6+maria~stretch all [installed,automatic]

To echo what @DaveD said, this message suggests that the php used by your webserver was not compiled with mysqlnd, because if "mysqlnd" is found in the version then the warning re: "libmysqlclient" should not be printed. To verify this, please check php info for your webserver (php fpm or apache module, not php cli).

See above.

Interesting. Sorry silly question but the line you added was after line 923 and before line 924? Or was it before line 923? If it's before line 923 that would explain a blank $version.

No problem, but I checked that.

Hmmmm

I adjusted the code to not include the parameter:

Then I get this:

The PHP documentation claims that mysqli_get_client_info() has a parameter (the connection), however according to the example on the same page - https://secure.php.net/manual/en/mysqli.get-client-info.php#refsect1-mysqli.get-client-info-examples - there is no parameter.

Likewise according to ReflectionFunction it has no parameters:

<?php
var_dump((new ReflectionFunction('mysqli_get_client_info'))->getNumberOfRequiredParameters());
var_dump((new ReflectionFunction('mysqli_get_client_info'))->getNumberOfParameters());

So I think we could remove the parameter.

Isn't it easier to use the mysqli_get_client_version() function? Then there would not be a need to do a lot of string operations.

But we are also trying to get which library is in use - mysqlnd or libmysqlclient.

Right, sorry for that.

PR @ https://github.com/civicrm/civicrm-core/pull/14864 may resolve this.

Thanks @mfb and @edvanleeuwen for reporting/investigating.

@edvanleeuwen and @jodumont it would be great if you could test the PR @ https://github.com/civicrm/civicrm-core/pull/14864 since I never actually reproduced this issue myself.

This PR tested and confirmed working on two Drupal 8 + CiviCRM 15.5.1 setups (both were previously exhibiting the issue, the PR resolved it, i.e. it no longer shows the warning).

Thanks heaps @AlanDixon I'll merge - but I guess we should target the 5.16 rc not master

mentioned in commit 09dd2e5c

mentioned in commit e479ac61

closed via commit 09dd2e5c

closed via commit e479ac61

mentioned in commit cca33fb0

libmysqlclient >= 5.5.3, compatibilty with MariaDB

Child items ...

Activity