OpenVBX and MySQLi

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.

One Comment

  1. patrick
    Posted July 30, 2012 at 8:26 pm | Permalink

    How do I update the From name in the system generated emails. Not the from email address but when you receive an email, your inbox shows a first and last name of the sender. The out of the box welcome email reads from [OpenVBX] Welcome aboard as the first and last name. Can you point me in the right direction to change this to something that matches our brand? Thanks

Post a Comment

Your email is never shared. Required fields are marked *