General discussion on installation and configuration of SOGo

Text archives Help


[SOGo] Funambol connector mysql error


Chronological Thread 
  • From: < >
  • To:
  • Subject: [SOGo] Funambol connector mysql error
  • Date: Mon, 6 Dec 2010 20:24:35 -0500 (EST)

Hi,

I use SOGo for about one year. It's a great piece of software. Thanks to all
developers.

A few day's ago I've moved to a new server and so reinstall SOGo with the
latest version 1.3.4 on CentOS 5.5. All works fine.

I haven't used sychronization via Funambol yet. Because I have a Nokia E71
mobile I want to use Funambol with the Funambol SOGo Connector.

- Standard installation of Funambol 8.7 describe in the 'Funambol Installation
and Administration Guide Version 8.7'.
- Installation of Funambol SOGo Connector v1.0.8 describe in the 'SOGo
Installation Guide 1.3.4'.
- Use of mysql-connector-java-5.1.13-bin.jar
- Use of json_simple-1.1.jar

- Use the shipped sync tool of Nokia E71. (No use of the Funambol Symbol
tool).

Sync on the mobile finish without any error. But there are problems on the
server side.

The Funambol Users, Devices, Pricipals are auto-created correct (SOGoOfficer).

But in $FUNAMBOL_HOME/logs/ds-server/ds-server.log are many error messages
like
this:

[2010-12-06 21:33:34,205] [funambol.sogo] [ERROR]
[E3A6C7D60C77B83EDC48189F30E35628] [xxx.xxx.xxx.xxx] [IMEI:xxxxxxxxxxxxxxx]

[sogo-card] Exception during getSyncItemFromId():
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'sogo.null_quick' doesn't exist

[2010-12-06 21:33:34,206] [funambol.sogo] [ERROR]
[E3A6C7D60C77B83EDC48189F30E35628] [xxx.xxx.xxx.xxx] [IMEI: xxxxxxxxxxxxxxx]

[sogo-card] Exception occured in addvCardSyncItem:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error
in
your SQL syntax; check the manual that corresponds to your MySQL server
version
for the right syntax to use near 'null (c_name, c_content, c_creationdate,
c_lastmodified, c_version) VALUES ('186' at line 1

I've take a look on the sogo mysql database. I think the table name should be
'sogo.sogorene00102bc39e7_quick' instead 'sogo.null_quick'.

Any ideas?
Could you help me please?

Rene


  • [SOGo] Funambol connector mysql error, rene, 12/06/2010

Archive powered by MHonArc 2.6.16.

Top of page