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
Specify
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’,‘com.ibm.db2.jcc.DB2Driver’,‘jdbc:db2://[host]:50000/[database-name]’);
function populate(i) {
document.dbform.driver.value=data[i][1];
document.dbform.serverURL.value=data[i][2];
}
var submitted = false;
function checkSubmit() {
if (!submitted) {
submitted = true;
return true;
}
return false;
}
Database Driver Presets:
Pick Database…
• MySQL
• Oracle
• Microsoft SQLServer
• PostgreSQL
• IBM DB2
JDBC Driver Class:
Database URL:
Username:
Password:
Minimum Connections:
Maximum Connections:
Connection Timeout:
Days
Note, it might take between 30-60 seconds to connect to your database.