unable to select mysql server in zabbix-frontend-php

[Jean-Max Reymond]

I install three packages:

% dpkg -l | grep -i zabbix
ii zabbix-agent 1:2.4.6+dfsg-1 amd64 network monitoring solution - agent
ii zabbix-frontend-php 1:2.4.6+dfsg-1 all network monitoring solution - PHP front-end
ii zabbix-server-mysql 1:2.4.6+dfsg-1 amd64 network monitoring solution - server (using MySQL)

when I start to configure the zabbix server, the screen "Configure the DB connection" only provides one choice: Postgres

ProblemType: Bug
DistroRelease: Ubuntu 15.10
Package: zabbix-frontend-php 1:2.4.6+dfsg-1
ProcVersionSignature: Ubuntu 4.2.0-35.40-generic 4.2.8-ckt5
Uname: Linux 4.2.0-35-generic x86_64
ApportVersion: 2.19.1-0ubuntu5
Architecture: amd64
CurrentDesktop: Unity
Date: Tue Apr 12 15:58:26 2016
InstallationDate: Installed on 2016-01-31 (71 days ago)
InstallationMedia: Ubuntu 15.10 "Wily Werewolf" - Release amd64 (20151021)
PackageArchitecture: all
SourcePackage: zabbix
UpgradeStatus: No upgrade log present (probably fresh install)

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[Nick (kg6nmp)]

This affected me too, the mysqli extension for PHP was missing. Once that was installed (php5-mysql) it worked. I guess zabbix-frontend-php needs to detect if you are using mysql or postgres, install support for both, or have a different package for both just like zabbix-server does.

[Nish Aravamudan (nacc)]

I was just discussing this on IRC. There is not a good way to deal with this (aiui), as the dependency that needs to be expressed is a runtime configuration one. That is, zabbix-frontend-php correctly depends (in 16.04+) on (php-pgsql | php-mysql | php-sqlite3). But there is not a way for zabbix-frontend-php itself to know which of those are needed locally, and the default is to use the first alternative (php-pgsql in this case). If you know you want a different configuration, you would `apt install zabbix-frontend-php php-mysql`.