MariaDB and Zabbix

[az86]

After upgrade from MySQL to MariaDB I got a lot of errrors:

Headers and client library minor version mismatch

can you help me please?

[walterheck]

We need a bit more information then that:

1) what version of which distribution are you running?
2) Where are you seeing these errors?
3) is this on the same machine as mariadb is running?

any other relevant info that helps us get an idea of your problem would be nice

good luck!

[nicola]

Error mysql_connect: Headers and client library minor version mismatch

I am experiencing the same problem.

The mysql_connect function at line 77 of includes/db.inc.php is triggering the following error:

Headers and client library minor version mismatch

The problem lies with the fact that Zabbix is using a deprecated mysql connector, as already reported here:

https://support.zabbix.com/browse/ZBX-6020

and should upgrade to use mysqli or PDO.

I am using:

- CentOS 6.3 2.6.32-279.19.1.el6.x86_64 #1 SMP Wed Dec 19 07:05:20 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux
- php x86_64 5.3.3 14.el6_3
- MariaDB-server x86_64 5.5.29 1
- zabbix20-web-mysql noarch 2.0.4 3.el6

Possible solutions are listed at:

https://kb.askmonty.org/en/installation-issues-with-php5/

1. Switch to using the mysqlnd driver in PHP (Recommended solution).

Unfortunately the latest php version (5.3.3.) available for CentOS 6.3 do not include this driver. So this is not a viable solution, unless installing not official repositories and custom PHP versions.

2. Run with a lower error reporting level:

$err_level = error_reporting(0);
$conn = mysql_connect('params');
error_reporting($err_level);

Suppressing errors doesn't seems a very elegant solution, especially because it requires to patch the Zabbix code. In any case, is there any simple way to suppress this error without patching the Zabbix code?

3. Recompile PHP with the MariaDB client libraries.

Since I am using this on production systems, I prefer to use the standard packages.


Note that this warning makes very difficult to use the web interface, so I hope you can find a quick solution.