postfixadmin and mysqli

I just don’t know exact step I’ve done when I see this error message when I try to access postfixadmin :

DEBUG INFORMATION:
MySQL 4.1 functions not available!
database_type = ‘mysqli’ in config.inc.php, are you using a different database?

Please check the documentation and website for more information.

The email server already run for almost 8 months, maybe latest upgrade to mysql 5.0.51a make that issue happened.

I try to see mysqli support from phpinfo(), I see no mysqli module found 🙁

mysql 5.0.51a

Maybe I just deinstall php5-mysqli support :

mail# pkg_info | grep mysql
mysql-client-5.0.51a Multithreaded SQL database (client)
mysql-server-5.0.51a Multithreaded SQL database (server)
p5-DBD-mysql-4.006  MySQL driver for the Perl5 Database Interface (DBI)
php5-mysql-5.2.5_1  The mysql shared extension for php
php5-mysqli-5.2.5_1 The mysqli shared extension for php

Wrong, I still see php5-mysqli-5.2.5_1 but not exist in phpinfo() output.

or maybe I just remove the support from extensions :

mail# cd /usr/local/etc/php
mail# ls
extensions.ini
mail# cat extensions.ini | grep mysqli
extension=mysqli.so

No, I still see tthe extension.

last option : reinstall the module

mail# cd /usr/ports/databases/php5-mysqli
mail# make deinstall
===>  Deinstalling for databases/php5-mysqli
===>   Deinstalling php5-mysqli-5.2.5_1
pkg_delete: package ‘php5-mysqli-5.2.5_1’ is required by these other packages
and may not be deinstalled (but I’ll delete it anyway):
php5-extensions-1.1
postfixadmin-2.1.0_7
mail#
mail# make clean
===>  Cleaning for php5-mysqli-5.2.5_1
mail# make install

mail# apachectl graceful

try to view again from phpinfo() output :

mysqli-5051a.png

Great to see you again buddy 🙂

Welcome back mysqli 😉