Revision: 4377
Author:   [email protected]
Date:     Fri Oct  7 08:05:41 2011
Log:      Edited wiki page Configuration_Mysql through web user interface.
http://code.google.com/p/openmeetings/source/detail?r=4377

Modified:
 /wiki/Configuration_Mysql.wiki

=======================================
--- /wiki/Configuration_Mysql.wiki      Fri Oct  7 08:05:14 2011
+++ /wiki/Configuration_Mysql.wiki      Fri Oct  7 08:05:41 2011
@@ -3,7 +3,14 @@

There is a MySQL sample config: mysql_persistance.xml that ships with every release of !OpenMeetings.

-=== steps todo ==
+== 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!
+
+=== Steps todo ==
   # Rename
$red5/webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistance.xml<br/>to<br/>$red5/webapps/openmeetings/WEB-INF/classes/META-INF/persistance.xml

@@ -13,10 +20,3 @@
<property name="openjpa.ConnectionProperties" value="DriverClassName=com.mysql.jdbc.Driver, Url=jdbc:mysql://$DB_HOST:3306/openmeetings?autoReconnect=true&amp;useUnicode=true&amp;createDatabaseIfNotExist=true&amp;characterEncoding=utf-8&amp;connectionCollation=utf8_general_ci&amp;cachePrepStmts=true&amp;cacheCallableStatements=true&amp;cacheServerConfiguration=true&amp;useLocalSessionState=true&amp;elideSetAutoCommits=true&amp;alwaysSendSetIsolation=false&amp;enableQueryTimeouts=false&amp;prepStmtCacheSize=3000&amp;prepStmtCacheSqlLimit=1000, MaxActive=100, MaxWait=10000, TestOnBorrow=true, poolPreparedStatements=true, Username=$USER_NAME, Password=$USER_PASS"/>

      }}}
-
-== 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!

--
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.

Reply via email to