How to install nd_mysqli PHP driver?

Operating System & Version
CentOS 7.9
cPanel & WHM Version
WHM v94.0.8

martin MHC

Well-Known Member
Sep 14, 2016
214
35
28
UK
cPanel Access Level
Root Administrator
Background:

PHP function get_result(); does not work. I find that I have this issue: get_result() Doesn't Work even mysqlnd is enabled

I find from PHP.net here: PHP: mysqli_stmt::get_result - Manual

That:

" To prevent others from hours of screaming trying to figure out why this does not work when you have the native driver enabled. It is because you need to make sure you enable both native drives mysqlnd and nd_mysqli on your server if you wish to use this functionality. "

Now, I have been digging and digging and I can not find where or how I am meant to load the specific "nd_mysqli" driver.

1) I have searched the drive for a nd_mysqli.so file and found one in the cpanel area but this doesn't load when mentioned in the PHP.ini extensions list. Also there are NO OTHER DRIVERS in the PHP extensions list so I think this is the wrong way of resolving this.

2) I have search the Easy Apache 4 but found absolutely no mysqli based extensions to install or load at any point.

current PHP does not have this driver and so the function ->get_result doesn't load and this is a critical issue as PHP 7.4.18 has now broken our entire DB interface classes.

How do I view the list of installed MySQLi drivers on WHM (terminal or whatever) and then how do I download and install the required nd_mysqli driver ?

THanks
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
5,447
697
313
cPanel Access Level
Root Administrator
Hey there! The nd_mysqli package is specifically available through CloudLinux, but isn't included with the standard EasyApache tools provided by cPanel. Is it possible you migrated from a CloudLinux system and used to have this package in the past?
 

martin MHC

Well-Known Member
Sep 14, 2016
214
35
28
UK
cPanel Access Level
Root Administrator
Hey there! The nd_mysqli package is specifically available through CloudLinux, but isn't included with the standard EasyApache tools provided by cPanel. Is it possible you migrated from a CloudLinux system and used to have this package in the past?
Hi Rex, thanks for your feedback, this is unexpected. I don't know if nd_mysqli has been on the system before but we've always been on WHM systems, and understood from others that the package was previously available via EasyApache(3) --> Exhaustive Listing.

Anyhow, as for the issue, we are developing a workaround (that does not involve PHP mysqli_stmt::get_result) for our issue and so this post/thread can actually probably be deleted.

Thanks,
 
  • Like
Reactions: cPRex