MySQL Configuration

Before you start

  • Make sure that you have set utf8 as default/server-character-set in your MySQL configuration (my.cnf) before you start the installation process of OpenMeetings!
  • make sure MySQL is listening on TCP/IP connections!
    To verify if MySQL connection is working: OpenMeetings will automatically create all tables in the database and all tables should have utf8 as encoding/collation!
  • If you encounter issues, you can drop the db again and delete the file $red5/webapps/openmeetings/conf/install.xml and then run the web based installer again

Steps todo

  • You need to download the JConnector from mysql http://www.mysql.com/downloads/connector/j/ and place it into: $red5/webapps/openmeetings/WEB-INF/lib/
  • Rename:
    $red5/webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistence.xml
    to
    $red5/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
  • Prepare Database Settings - go to openmeetings_version_no_xx/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
    Alter config values in persistence.xml DB_HOST USER_NAME USER_PASS with your values
  • Run red5-service and goto the web-based installer: http://localhost:5080/openmeetings/install

MySQL Sample Configuration

There is a sample configuration for MySQL that ships with every release in:
/webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistence.xml