How to connect with MySqlDB?

Openfire Openfire Dev
1

Hi everybody,

When we run the Database manager, how can we configurate it to connect the external Mysql database with wildfire sever?

thanks in advance!

2

Hi,

did you read http://www.jivesoftware.org/builds/wildfire/docs/latest/documentation/index.html ?

Where do you need more specific help?

LG

3

Hi Killer,
You need to setup the MySql database first means you have to create the database first, then u can continue with the setup.
Go through these steps:

  1. Make sure that you are using MySQL 4.1.18 or later (5.x recommended) ¹.
  2. Create a database for the Wildfire tables:
    ***mysqladmin create ***
    (note: “databaseName” can be something like ‘‘wildfire’’)
  3. Import the schema file from the resources/database directory of the installation folder:
    Unix/Linux: cat wildfire_mysql.sql | mysql ;
    Windows: type wildfire_mysql.sql | mysql ;
  4. Start the Wildfire setup tool, and use the appropriate JDBC connection settings.

Now go to the database manager setup
In the Wildfire setup tool, use the following values:

  • server: jdbc:mysql://[YOUR_HOST]/[DATABASE_NAME]

Read this for further info
http://www.jivesoftware.org/builds/wildfire/docs/latest/documentation/database.h tml#mysql