Cannot configure mySql database for Openfire

Hello Folks,

When I try to configure the database, I keep getting this error message although mySql database is configure and the schema is installed.

Please help.

Database Settings - Standard Connection


a JDBC driver and connection properties to connect to your database. If

you need more information about this process please see the database

documentation distributed with Openfire.

Note: Database scripts for most popular databases are included in the server distribution at /resources/database.

The Openfire database schema does not appear to be installed. Follow the installation guide to fix this error.

var data = new Array();

data[0] = new Array(‘MySQL’,‘com.mysql.jdbc.Driver’,‘jdbc:mysql://[host-name]:3306/[database- name]’);

data[1] = new Array(‘Oracle’,‘oracle.jdbc.driver.OracleDriver’,‘jdbc:oracle:thin:@[host-name] :1521:[SID]’);

data[2] = new Array(‘Microsoft SQLServer’,‘net.sourceforge.jtds.jdbc.Driver’,‘jdbc:jtds:sqlserver://[host-name ]/[database-name];appName=jive’);

data[3] = new Array(‘PostgreSQL’,‘org.postgresql.Driver’,‘jdbc:postgresql://[host-name]:5432/ [database-name]’);

data[4] = new Array(‘IBM DB2’,‘’,‘jdbc:db2://[host]:50000/[database-name]’);

function populate(i) {




var submitted = false;

function checkSubmit() {

if (!submitted) {

submitted = true;

return true;


return false;


Database Driver Presets:

Pick Database…


• Oracle

• Microsoft SQLServer

• PostgreSQL


JDBC Driver Class:

Database URL:



Minimum Connections:

Maximum Connections:

Connection Timeout:


Note, it might take between 30-60 seconds to connect to your database.

Did you create a MySQL user and grant permissions to the Openfire DB?

Can you provide a screenshot of the setup config screen in openfire where you enter the db info with your info entered?

Can you provide a screenshot of the MySQL config via mysql administrator?