I just don’t know exact step I’ve done when I see this error message when I try to access postfixadmin :
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
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# cat extensions.ini | grep mysqli
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):
mail# make clean
===> Cleaning for php5-mysqli-5.2.5_1
mail# make install
mail# apachectl graceful
try to view again from phpinfo() output :
Great to see you again buddy
Welcome back mysqli 😉