Front End PHP Database Support Fail

[fokkre]

Hello and please excuse my inexperience with getting this going.

I have a FreeBSD 10 / Apache 2.4 / PHP 5.5 and Zabbix 2.2 server & agent.

I have it to the point I can get to the front end PHP page and all checks pass except 1

PHP databases support | off | Fail |

my phpinfo (); tells me that MySQL support is enabled. I have spent the last 4 hours of my work day searching everything I can attempt to find online and have not come up with anything that can point me in the direction of where to look or what to change/test to get it pass this check.

If you have time to help I really appreciate your responses

[ingus.vilnis]

Hello and welcome!

Please check if you have the "php5-mysql" module installed.
(https://www.zabbix.com/forum/archive...hp/t-6890.html)

Best Regards,
Ingus

[fokkre]

Hello,

Yes I have that one installed. Here is my list of PHP pkg's

http://imgur.com/PVJb5RN

well since the screen shot is probably broken here they are

apache24-2.4.10
mysql51-client-5.1.72
mysql51-server-5.1.72
mod_php55-5.5.14
php55-bcmath-5.5.14
php55-ctype-5.5.24
php55-dom-5.5.14
php55-gd-5.5.14
php55-mbstring-5.5.14
php55-mysql-5.5.14
php55-session-5.5.14
php55-sockets-5.5.14
php55-xml-5.5.14
php55-xmlreader-5.5.14
php55-xmlwriter-5.5.14

[fokkre]

New Build

Update,

I rebuilt from scratch the following setup. All installed from ports after doing a portsnap fetch extract update. Although after all i am still failing at the front end check screen. Everything checks out as OK except the PHP database support option. Please direct me as i am yours to mold, and i am really stuck since phpinfo() says MySQL is enabled.

FreeBSD 10 - Apache24 - PHP5.4 - MySQL 5.5 - Zabbix 2.2 Server

Here are a few screen shots



I also was going to try php-pdo? maybe and I am going into work now to check on if "extension=mysqli.so" is uncommented in my php.ini file. I'll update when I get it checked.

[fokkre]

Ok, I installed php-pdo with no change in results. I have checked and my php.ini does not have any mention of =mysql.so, although i found in etc/php a "extensions.ini" file and it has both the =mysql.so and =pdo.so listed.

Is there any more suggestions on what I can check or look into? Or should i scrap the freeBSD and go with some flavor of linux?

[ingus.vilnis]

Hi,

I am out of ideas what can be wrong in your case. Maybe some other forum readers could possibly give some valuable pointers.

I have never installed Zabbix on FreeBSD. I know it is technically supported and can be done, but if you would like to have more simple and widespread solution, you could go for Ubuntu (my personal fav.) or CentOS and install Zabbix from packages.

But as I said before, maybe don't hurry scrapping your setup. There could be just some tiny detail missing, just we don't see it yet.

Best Regards,
Ingus

[tchjts1]

This is a longshot, but see if there is a php-devel package and install it.

(Edit) I just looked through my install notes. Check to see if you have mysql-devel installed also.

[fokkre]

The Fix!

As I was looking around for a fix, somewhere past page XX on said search engines I was directed to the PHP.net website and now I feel dumb for not doing my research. Here is the answer. I installed php5-mysqli and am on my way, thank you now I don't have to try and figure out nagios

http://php.net/manual/en/migration51.databases.php

In PHP 4, MySQL 3 support was built-in. With the release of PHP 5.0 there were two MySQL extensions, named 'mysql' and 'mysqli', which were designed to support MySQL < 4.1 and MySQL 4.1 and up, respectively. With the introduction of PDO, which provides a very fast interface to all the database APIs supported by PHP, the PDO_MYSQL driver can support any of the current versions (MySQL 3, 4 or 5) in PHP code written for PDO, depending on the MySQL library version used during compilation. The older MySQL extensions remain in place for reasons of back compatibility, but are not enabled by default.