Hello.

I'm having this exact same problem, and my setup is only slightly different:

- Debian Squeeze
- standard SOGo 2.0.4b install from Inverse debian repo
- PostgreSQL 8.4
- Funambol 10.0.3 from bundle, hacked (symlinked) to use Debian's postgresql-jdbc3-8.4.jar and json_simple-1.1.jar
- sogo-card sync source
- Officer set to SOGoOfficer.xml
- SOGo authenticating users in LDAP (which then does so against Kerberos via SASL) - Testing with the built-in SyncML client on a Nokia Asha 303. (FWIW, Software version is V14.87 RM-763.)

Here's the log conversation on initial sync from the phone:

When Funambol.sogo does this: [sogo-card] getAllSyncItemKeys()
postgresql.log shows this:
ERROR:  relation "null_quick" does not exist at character 20
STATEMENT:  SELECT c_name FROM null_quick WHERE c_component = 'vcard'

When Funambol.sogo is doing "getSyncItemKeysFromTwin", postgres shows:
ERROR:  syntax error at or near "null" at character 39
STATEMENT:  SELECT c_cn, c_mail, c_o, c_name FROM null

When Funambol.sogo tries "getSyncItemFromId( { keyValue: 7 } )", I get:
ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT:  SELECT c_name FROM null_quick WHERE c_name = $1

And finally, when Funambol.sogo shows:
[sogo-card] Parsed contact: com.funambol.common.pim.contact.Contact@1dd1ed2
[sogo-card] c_name: 7

...postgres shows:
ERROR:  syntax error at or near "null" at character 13
STATEMENT: INSERT INTO null (c_name, c_content, c_creationdate, c_lastmodified, c_version) VALUES ($1,$2,$3,$4,$5)


So my first question is what table name should it be trying to use instead of "null" or "null_quick"?

Sincerely,
Sean M. Pappalardo
Sr. Networks Engineer
Renegade Technologies
[email protected]
Office: (630) 631-6188
http://www.renegadetech.com

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature

Reply via email to