I can´t connect for MySQL

Openfire Openfire Support
1

Erorr mesages

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

I have Windows XP and MySQL ver 3.23.47-nt

I have set Jive mesenger

JDBC Driver Class: com.mysql.jdbc.Driver

Database URL: jdbc:mysql://127.0.0.1:3306/jive

I haven´t where mistake??

2

I guess you missed the step to create the database structure.

Look at http://www.jivesoftware.org/builds/messenger/docs/latest/documentation/database. html#mysql - at point 3.

Just my guess,

Ben

3

I have create database. I don´t now how to import messenger_mysql.sql to database?? This command type messenger_mysql.sql | mysql doesnt go…My english is horrible

4

Since I usually prefer GUI rather than command lines…what I use for managing the database is url=http://dev.mysql.com/downloads/other/mysqlcc.htmlMySQL Control Center[/url].

Follow these steps for importing/running the creation script:

  1. Download and install the tool from the link above

  2. Start the application

  3. Create a new database named “messenger” (you can skip this step if you already done this)

  4. Double click on the new database (it will turn green)

  5. Click on the “SQL” button and open the messenger_mysql.sql file

  6. Execute the file

Let me know how it goes.

Regards,

– Gato