2 Replies Last post: Aug 14, 2006 8:48 AM by jitendra chit  
Vito   3 posts since
Jul 19, 2006
Currently Being Moderated

Jul 21, 2006 4:14 AM

How to connect with MySqlDB?

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!

LG KeyContributor 4,984 posts since
Dec 13, 2005
Currently Being Moderated
Jul 21, 2006 2:08 PM in response to: Vito
Re: How to connect with MySqlDB?

Hi,

 

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

Where do you need more specific help?

 

LG

jitendra chit Bronze 49 posts since
Jun 19, 2006
Currently Being Moderated
Aug 14, 2006 8:48 AM in response to: Vito
Re: How to connect with MySqlDB?

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 databaseName

(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 datebaseName;

Windows: type wildfire_mysql.sql | mysql databaseName;

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:

 

 

 

      
  • driver: com.mysql.jdbc.Driver
  •   
  • 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

 

 

More Like This

  • Retrieving data ...