Hi, I have no explanation why this problem occurs. Since I have no access to a FreeBSD env I cannot test whether the problem is FreeBSD specific. I tested with Debain and CentOS and EAS works without OCSCacheFolderURL, OCSAclURL and OCSStoreURL.
So, I recommend to convert to the 9 table schema. It was introduced with SOGo 3.0 and has several benefits. There is an excellent description of the required steps here: https://docs.iredmail.org/upgrade.sogo.combined.sql.tables.html For a new environment you just have to set OCSCacheFolderURL, OCSAclURL and OCSStoreURL as described int the installation guide. Regards Thomas -----Ursprüngliche Nachricht----- Von: users-requ...@sogo.nu <users-requ...@sogo.nu> Im Auftrag von "Thomas Fuehrer" Gesendet: Freitag, 14. Jänner 2022 07:47 An: users@sogo.nu Betreff: AW: [SOGo] Database-error with Activesync Hi Hanns, can you please set SOGoEASDebugEnabled=true, reproduce the error and provide sogo.log? My understanding is that the column c_uid only exists in sogo_cache_folder (without username sugfix) in a 9 table model database schema. Do you have any of these parameters set? OCSCacheFolderURL, OCSAclURL , OCSStoreURL Regards Thomas -----Ursprüngliche Nachricht----- Von: users-requ...@sogo.nu <users-requ...@sogo.nu> Im Auftrag von Hanns Mattes Gesendet: Montag, 10. Jänner 2022 17:56 An: users@sogo.nu Betreff: Re: [SOGo] Database-error with Activesync Hi, Am 09.01.22 um 11:14 schrieb Hanns Mattes (hannsmat...@googlemail.com): > Hello, > > I've setup sogo 5.4.0 on a server running FreeBSD 13.0 und PSQL, web > access, caldav and carddav are working fine. But trying to access an > account via activesync is failing: > [...] (I forgot to mention, that I'm using LDAP-Authentication.) similar results with mysql: Jan 10 17:45:24 sogod [66817]: <0x805167a88[SOGoCacheGCSObject]:4E696E65413341374535423136363832> an exception occurred when executing query 'SELECT * FROM sogo_cache_folder_hanns_A_hanauix_D_de WHERE c_path = '/4E696E65413341374535423136363832' AND c_uid = 'ha...@hanauix.de'' Jan 10 17:45:24 sogod [66817]: <0x805167a88[SOGoCacheGCSObject]:4E696E65413341374535423136363832> exception is '<MySQL4Exception: 0x8049b2358> NAME:ExecutionFailed REASON:Unknown column 'c_uid' in 'where clause'' Jan 10 17:45:24 sogod [66817]: [ERROR] <0x805167a88[SOGoCacheGCSObject]:4E696E65413341374535423136363832> could not insert/update record for record '/4E696E65413341374535423136363832' in sogo_cache_folder_hanns_A_hanauix_D_de: <MySQL4Exception: 0x804a0bea8> NAME:ExecutionFailed REASON:Unknown column 'c_uid' in 'field list' Any idea? Regards Hanns -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists= -- users@sogo.nu https://inverse.ca/sogo/lists