Line 28: |
Line 28: |
| | | |
| == Download MySQL component == | | == Download MySQL component == |
− | Funambol by installation defaults to use the Hypersonic DB engine. | + | Funambol by installation defaults to use the Hypersonic DB engine, but SOGO requires the use of MySQL. |
| | | |
− | Goto http://dev.mysql.com/downloads/connector/j/5.0.html to download the JDBC driver for MySQL. | + | Goto http://dev.mysql.com/downloads/connector/j/5.0.html to download the JDBC driver for MySQL. The current version is '''mysql-connector-java-5.0.8.zip'''. Download it to '''/opt'''. |
− | | |
− | See the '''/opt/Funambol/ds-server/install.properties''' file for details and to change to the MySQL connector.
| |
| | | |
| + | cd /opt |
| unzip mysql-connector-java-5.0.8.zip | | unzip mysql-connector-java-5.0.8.zip |
| mkdir -p /opt/Funambol/tools/mysql/lib | | mkdir -p /opt/Funambol/tools/mysql/lib |
| cp mysql-connector-java-5.0.8/mysql-connector-java-5.0.8-bin.jar /opt/Funambol/tools/mysql/lib | | cp mysql-connector-java-5.0.8/mysql-connector-java-5.0.8-bin.jar /opt/Funambol/tools/mysql/lib |
| rm -rf mysql-connector-java-5.0.8 | | rm -rf mysql-connector-java-5.0.8 |
| + | |
| + | Edit the '''/opt/Funambol/ds-server/install.properties''' file to change the Funambol DB connector to MySQL. |
| + | |
| + | vim /opt/Funambol/ds-server/install.properties |
| + | |
| + | Comment out the existing jdbc driver for Hypersonic and add: |
| + | |
| + | # MySQL |
| + | # ===== |
| + | jdbc.classpath=../tools/mysql/lib/mysql-connector-java-5.0.8-bin.jar |
| + | jdbc.driver=com.mysql.jdbc.Driver |
| + | jdbc.url=jdbc:mysql://localhost/funambol?characterEncoding=UTF-8 |
| + | jdbc.user=funambol |
| + | jdbc.password=funambol |
| | | |
| == Download Apache Commons components == | | == Download Apache Commons components == |