How to install Funambol-SugarCRM Connector and possible problems that you might face when doing that.

Installing Funambol-SugarCRM connector

1. Download SugarCRM connector here.

2. Unzip the downloaded package file and place the s4j file in the directory

*INSTALLATION DIR*/Funambol/ds-server/modules

3. Modify the "install.properties" file by adding "funambol-sugarcrm-connector.x.y.z" to the modules comma separated list in the last lines of the file

4. Run the install-modules script which can be found from

*INSTALLATION DIR*/bin/

Do as the script prompts and rebuild database by selecting "y" when prompted

5. To complete installation you have to set the SugarCRM server URL to file that can be found from

*INSTALLATION DIR*/config/com/funambol/server/security/SugarcrmOfficer.xml

Add URL to Property called sugarURL and it should be in form http://your-url/sugar

6. Start Funambol administrator tool and double click on "Server Settings", in the "Engine" section change the "Officer" to "SugarcrmOfficer.xml". Then Save the configuration.

7. Now you can test your SugarCRM connectivity with Funambols Java Demo Client

Possible problems you might face and some hits that might help you to solve them

-Wrong calendar and contact name URI either in device or in Funambol-Sugar connector settings

SOLUTION: Double check all URIs and make sure every device uses same ones

-Symbian S60 sync app doesn't allow you to define URIs

PROBLEMS: Cannot sync to Sugar because it uses predefined Contacts and Calendar

SOLUTION: No solution yet

-Error Code 506 in Server or HTTP 408 Timeout error in clients

FINDINGS: Most likely cause for these two errors is that you are running Sugar that is encapsulated inside Elastix install. As a default Sugar doesn't have SSL enabled, but Sugar that comes with Elastix install has SSL enabled which might show up as following error messages:

1) Error sending the request: Server returned HTTP response code 408...

2) Error creation ContactManager [Error connecting SugarCRM]...

3) javax.net.ssl.SSLHandshakeException: ... PKIX path building failed...

4) Unable to find valid certification path to requested target

So far looks like all the above error messages are related to SSL being enabled as default in Elastix installed SugarCRM. You can make sure that the fault isn't in something else fairly easily by running "tcpdump" or some other packet capturing program and see that first Funambol handshakes with SugarCRM server using port 80 (http) and then switches to port 443 (https) and after that there are no packets transmitted which shows up as HTTP 408 timeout as client app.

SOLUTION: Possible solution to fix this is to disable SSL from Apache so that SugarCRM site is accessed using regular http. This might do the trick but we haven't tested it yet. We'll update the results once we have been able to test this throughly. Currently there is no official fix available for Funambol-SugarCRM Connector that corrects the SSL handling issue. There's no information available about this issue anywhere in SugarCRM forums or other resources.

*UPDATE* Other possible solution to fix this is to give address to SugarCRM in form of https://user:pass@domain/sugar instead of the regular http://domain/sugar. Testing results will come once the tests have been completed.