Revision: 4371
Author: [email protected]
Date: Fri Oct 7 08:03:17 2011
Log: Edited wiki page Configuration_Mysql through web user interface.
http://code.google.com/p/openmeetings/source/detail?r=4371
Modified:
/wiki/Configuration_Mysql.wiki
=======================================
--- /wiki/Configuration_Mysql.wiki Tue Oct 4 13:46:06 2011
+++ /wiki/Configuration_Mysql.wiki Fri Oct 7 08:03:17 2011
@@ -3,4 +3,20 @@
There is a MySQL sample config: mysql_persistance.xml that ships with
every release of !OpenMeetings.
-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!
+TODO:
+ # Rename
+$red5/webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistance.xml
+to
+$red5/webapps/openmeetings/WEB-INF/classes/META-INF/persistance.xml
+
+ # Prepare Database Settings - go to
openmeetings_version_no_xx/webapps/openmeetings/WEB-INF/classes/META-INF/persistance.xml
+ * MySQL-Database-Users: Alter following config values in
`persistance.xml` $DB_HOST $USER_NAME $USER_PASS with your values
+ {{{
+<property name="openjpa.ConnectionProperties"
value="DriverClassName=com.mysql.jdbc.Driver,
Url=jdbc:mysql://$DB_HOST:3306/openmeetings?autoReconnect=true&useUnicode=true&createDatabaseIfNotExist=true&characterEncoding=utf-8&connectionCollation=utf8_general_ci&cachePrepStmts=true&cacheCallableStatements=true&cacheServerConfiguration=true&useLocalSessionState=true&elideSetAutoCommits=true&alwaysSendSetIsolation=false&enableQueryTimeouts=false&prepStmtCacheSize=3000&prepStmtCacheSqlLimit=1000,
MaxActive=100, MaxWait=10000, TestOnBorrow=true,
poolPreparedStatements=true, Username=$USER_NAME, Password=$USER_PASS"/>
+
+ }}}
+
+ * 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!
--
You received this message because you are subscribed to the Google Groups
"OpenMeetings developers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/openmeetings-dev?hl=en.
