Starting with OpenVBX 1.1 the install process detects wether a server is running a version of MySQL that is compatible with the MySQLi Driver and will enable MySQLi in those cases. Most of the niceties for using MySQLi are behind the scenes and mostly interesting to geeky types. Most of all, though, it gets your server using a database driver that is under active development and that will get improvements and bug fixes as your host keeps your server up to date. In some cases, depending upon your server configuration, you might also enjoy a slight boost in server response speed.
Unfortunately OpenVBX does not do any detection or make any changes to this setting during the Upgrade process, so if you’re running OpenVBX 1.1 or newer and performed and upgrade from a version pior to OpenVBX 1.1, and if your MySQL server version is greater than 4.1.13 for MySQL 4 or greater than 5.0.7 for MySQL 5 you should update your database config file to enable MySQLi.
If you don’t know what version of MySQL your server is running you can check your “Settings > About” page, under the Server Info section you can find the MySQL version that you’re running. Here you can also check the “Database Configuration” line. If that line starts with
mysqli then you’re already in business. You’re done! If you’re running an older version of OpenVBX that doesn’t list the MySQL version you can check your hosting providers control panel to see which version of MySQL they provide.
Now, If you’re not already running the MySQLi driver and your MySQL server meets the requirements, log in to your web-server via FTP or SSH and navigate to
[web-root]/OpenVBX/config/. There you’ll find a file named
database.php. In this file there’s a line like:
$db['default']['dbdriver'] = 'mysql';
If yours already says
mysqli then you’re done! If not, change it to
mysqli and save the file. Now when you use OpenVBX you’ll be using the newer MySQLi library.