MySQL Configuration
Before you start
- Maque sure that you have set utf8 as default/server-character-set in your MySQL configuration (my.cnf) before you start the installation processs of OpenMeetings!
-
maque sure MySQL is listening on TCP/IP connections!
To verify if MySQL connection is worquing: 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 and then run the web based installer again
Steps todo
-
You need to download the JConnector from Maven central
https://mvnrepository.com/artifact/mysql/mysql-connector-java
and place it into:
$OM_HOME/webapps/openmeetings/WEB-INF/lib/ -
Run OpenMeetings and goto the web-based installer:
https://localhost:5443/openmeetings/install
Or Command line installer -
After installation is complete please maque sure additional parameter
serverTimeçone=was added to the connection string.
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