Line 241: |
Line 241: |
| This process creates entries in the funambol database as well as creating a couple of XML configuration files. To allow the SOGo database password to be inserted into these XML files, they are setup below as SME template files. | | This process creates entries in the funambol database as well as creating a couple of XML configuration files. To allow the SOGo database password to be inserted into these XML files, they are setup below as SME template files. |
| | | |
− | Until we work out how to add the database settings directly into the funambol database, use the funambol-admin tool to create the sync sources as described in the SOGo documentation. Then create and expand the template files as described below to overwrite the XML files with the SOGo database password included.
| + | The commands below inserts the required entries into the funambol database. Then create and expand the template files as described below to complete the configuration. |
| | | |
− | The SQL required is:
| + | Create a temporary SQL file: |
| + | |
| + | vim sogo-sync-source-insert.sql |
| + | |
| + | and insert: |
| | | |
| INSERT INTO `fnbl_sync_source` (`uri`, `config`, `name`, `sourcetype`) VALUES | | INSERT INTO `fnbl_sync_source` (`uri`, `config`, `name`, `sourcetype`) VALUES |
Line 249: |
Line 253: |
| ('sogo-card', 'sogo/sogo/sogo/sogo-card.xml', 'sogo-card', 'sogo'), | | ('sogo-card', 'sogo/sogo/sogo/sogo-card.xml', 'sogo-card', 'sogo'), |
| ('sogo-todo', 'sogo/sogo/sogo/sogo-todo.xml', 'sogo-todo', 'sogo'); | | ('sogo-todo', 'sogo/sogo/sogo/sogo-todo.xml', 'sogo-todo', 'sogo'); |
| + | |
| + | save the file and then insert the SQL into the funambol database: |
| + | |
| + | mysql funambol --user=funambol --password=yourpassword < sogo-sync-source-insert.sql |
| | | |
| === Configuring the Calendar Sync connection === | | === Configuring the Calendar Sync connection === |