AW: [SOGo] Database-error with Activesync
Good to hear that it now works for you. In the meantime I managed to reproduce the problem. As fare I can say it only occurs on FreeBSD. I noticed several WARNINGS about "singleStoreMode" while SoObjects/SOGo/SOGoCacheGCSObject.m is compiled. The problem doesn't occur with following patch: diff --git a/SoObjects/SOGo/SOGoCacheGCSObject.m b/SoObjects/SOGo/SOGoCacheGCSObject.m index 603917128..ab7df44e0 100644 --- a/SoObjects/SOGo/SOGoCacheGCSObject.m +++ b/SoObjects/SOGo/SOGoCacheGCSObject.m @@ -22,6 +22,7 @@ #import #import #import +#import #import #import #import Regards Thomas -Ursprüngliche Nachricht- Von: users-requ...@sogo.nu Im Auftrag von Hanns Mattes Gesendet: Samstag, 15. Jänner 2022 18:22 An: users@sogo.nu Betreff: Re: [SOGo] Database-error with Activesync "Thomas Fuehrer" (t...@aon.at) schrieb: >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. It seems so, I'll drop a note to the maintainer of the port. >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. Added the manually - and everything is working. I owe You a beer, if You're the next time in the Frankfurt area. Thanks Hanns -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Database-error with Activesync
"Thomas Fuehrer" (t...@aon.at) schrieb: >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. It seems so, I'll drop a note to the maintainer of the port. >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. Added the manually - and everything is working. I owe You a beer, if You're the next time in the Frankfurt area. Thanks Hanns -- users@sogo.nu https://inverse.ca/sogo/lists
AW: [SOGo] Database-error with Activesync
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 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 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 ' 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: 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
Re: [SOGo] Database-error with Activesync
Hi, Thomas,
Am 14.01.22 um 07:46 schrieb "Thomas Fuehrer" (t...@aon.at):
Hi Hanns,
can you please set SOGoEASDebugEnabled=true, reproduce the error and
provide sogo.log?
/var/log7sogo/sogo.log:
Jan 14 11:33:00 sogod [43211]: <0x0x80481c2d8[SOGoCache]> Cache cleanup
interval set every 300.00 seconds
Jan 14 11:33:00 sogod [43211]: <0x0x80481c2d8[SOGoCache]> Using host(s)
'localhost' as server(s)
Jan 14 11:33:00 sogod [43211]: 94.79.154.202 "OPTIONS /SOGo HTTP/1.1"
302 0/0 0.025 - - -
Jan 14 11:33:21 sogod [43211]: 94.79.154.202 "OPTIONS
/SOGo/Microsoft-Server-ActiveSync HTTP/1.1" 200 0/0 0.097 - - -
Jan 14 11:33:21 sogod [43211]: <0x0x80477dc48[SOGoActiveSyncDispatcher]>
EAS - request for device NineA3A7E5B16682:
"http://www.microsoft.com/;>
0
Jan 14 11:33:21 sogod [43211]:
<0x805376088[SOGoCacheGCSObject]:NineA3A7E5B16682> an exception occurred
when executing query 'SELECT * FROM
sogo_cache_folder_hanns_A_hanauix_D_de WHERE c_path =
'/NineA3A7E5B16682' AND c_uid = 'ha...@hanauix.de''
Jan 14 11:33:21 sogod [43211]:
<0x805376088[SOGoCacheGCSObject]:NineA3A7E5B16682> exception is
' NAME:ExecutionFailed REASON:Unknown
column 'c_uid' in 'where clause''
Jan 14 11:33:21 sogod [43211]: [WARN]
<0x0x804a0ecc8[SOGoWebDAVAclManager]> entry '{DAV:}write' already exists
in DAV permissions table
Jan 14 11:33:21 sogod [43211]: [WARN]
<0x0x804a0ecc8[SOGoWebDAVAclManager]> entry '{DAV:}write-properties'
already exists in DAV permissions table
Jan 14 11:33:21 sogod [43211]: [WARN]
<0x0x804a0ecc8[SOGoWebDAVAclManager]> entry '{DAV:}write-content'
already exists in DAV permissions table
Jan 14 11:33:22 sogod [43211]:
<0x805376408[SOGoCacheGCSObject]:NineA3A7E5B16682+folder75a80116e6c192545830654d370e>
an exception occurred when executing query 'SELECT * FROM
sogo_cache_folder_hanns_A_hanauix_D_de WHERE c_path =
'/NineA3A7E5B16682+folder75a80116e6c192545830654d370e' AND c_uid =
'ha...@hanauix.de''
Jan 14 11:33:22 sogod [43211]:
<0x805376408[SOGoCacheGCSObject]:NineA3A7E5B16682+folder75a80116e6c192545830654d370e>
exception is ' NAME:ExecutionFailed
REASON:Unknown column 'c_uid' in 'where clause''
Jan 14 11:33:22 sogod [43211]: [ERROR]
<0x805376408[SOGoCacheGCSObject]:NineA3A7E5B16682+folder75a80116e6c192545830654d370e>
could not insert/update record for record
'/NineA3A7E5B16682+folder75a80116e6c192545830654d370e' in
sogo_cache_folder_hanns_A_hanauix_D_de:
NAME:ExecutionFailed REASON:Unknown column 'c_uid' in 'field list'
Jan 14 11:33:22 sogod [43211]:
<0x805376608[SOGoCacheGCSObject]:NineA3A7E5B16682+folderJunk> an
exception occurred when executing query 'SELECT * FROM
sogo_cache_folder_hanns_A_hanauix_D_de WHERE c_path =
'/NineA3A7E5B16682+folderJunk' AND c_uid = 'ha...@hanauix.de''
Jan 14 11:33:22 sogod [43211]:
<0x805376608[SOGoCacheGCSObject]:NineA3A7E5B16682+folderJunk> exception
is ' NAME:ExecutionFailed REASON:Unknown
column 'c_uid' in 'where clause''
Jan 14 11:33:22 sogod [43211]: [ERROR]
<0x805376608[SOGoCacheGCSObject]:NineA3A7E5B16682+folderJunk> could not
insert/update record for record '/NineA3A7E5B16682+folderJunk' in
sogo_cache_folder_hanns_A_hanauix_D_de:
NAME:ExecutionFailed REASON:Unknown column 'c_uid' in 'field list'
Jan 14 11:33:22 sogod [43211]:
<0x805376688[SOGoCacheGCSObject]:NineA3A7E5B16682+folderPublic> an
exception occurred when executing query 'SELECT * FROM
sogo_cache_folder_hanns_A_hanauix_D_de WHERE c_path =
'/NineA3A7E5B16682+folderPublic' AND c_uid = 'ha...@hanauix.de''
Jan 14 11:33:22 sogod [43211]:
<0x805376688[SOGoCacheGCSObject]:NineA3A7E5B16682+folderPublic>
exception is ' NAME:ExecutionFailed
REASON:Unknown column 'c_uid' in 'where clause''
Jan 14 11:33:22 sogod [43211]: [ERROR]
<0x805376688[SOGoCacheGCSObject]:NineA3A7E5B16682+folderPublic> could
not insert/update record for record '/NineA3A7E5B16682+folderPublic' in
sogo_cache_folder_hanns_A_hanauix_D_de:
NAME:ExecutionFailed REASON:Unknown column 'c_uid' in 'field list'
Jan 14 11:33:22 sogod [43211]:
<0x805376788[SOGoCacheGCSObject]:NineA3A7E5B16682+folder3102040732e392545664654d370e>
an exception occurred when executing query 'SELECT * FROM
sogo_cache_folder_hanns_A_hanauix_D_de WHERE c_path =
'/NineA3A7E5B16682+folder3102040732e392545664654d370e' AND c_uid =
'ha...@hanauix.de''
Jan 14 11:33:22 sogod [43211]:
<0x805376788[SOGoCacheGCSObject]:NineA3A7E5B16682+folder3102040732e392545664654d370e>
exception is ' NAME:ExecutionFailed
REASON:Unknown column 'c_uid' in 'where clause''
Jan 14 11:33:22 sogod [43211]: [ERROR]
<0x805376788[SOGoCacheGCSObject]:NineA3A7E5B16682+folder3102040732e392545664654d370e>
could not insert/update record for record
'/NineA3A7E5B16682+folder3102040732e392545664654d370e' in
sogo_cache_folder_hanns_A_hanauix_D_de:
NAME:ExecutionFailed REASON:Unknown column 'c_uid' in 'field list'
Jan 14 11:33:22 sogod [43211]:
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 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 ' 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: 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
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 ' 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: NAME:ExecutionFailed REASON:Unknown column 'c_uid' in 'field list' Any idea? Regards Hanns -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Database-error with Activesync
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: Jan 08 10:01:55 sogod [54350]: [ERROR] <0x805630b88[SOGoCacheGCSObject]:4E696E65414130423332413136354136> could not insert/update record for record '/4E696E65414130423332413136354136' in sogo_cache_folder_hanns_A_hanauix_D_de: NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x8056151e8[PostgreSQL72Channel]: connection=<0x0x804a53908[PGConnection]: connection=0x0x804785400>>): ERROR: column "c_uid" of relation "sogo_cache_folder_hanns_a_hanauix_d_de" does not exist LINE 1: ...ERT INTO sogo_cache_folder_hanns_A_hanauix_D_de (c_uid, c_p... ^ Jan 08 10:01:55 sogod [54350]: <0x8054e9088[SOGoCacheGCSObject]:4E696E65414130423332413136354136> an exception occurred when executing query 'SELECT * FROM sogo_cache_folder_hanns_A_hanauix_D_de WHERE c_path = '/4E696E65414130423332413136354136' AND c_uid = 'ha...@hanauix.de'' Jan 08 10:01:55 sogod [54350]: <0x8054e9088[SOGoCacheGCSObject]:4E696E65414130423332413136354136> exception is ' NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x8056151e8[PostgreSQL72Channel]: connection=<0x0x804a53908[PGConnection]: connection=0x0x804785400>>): ERROR: column "c_uid" does not exist LINE 1: ... c_path = '/4E696E65414130423332413136354136' AND c_uid = 'h... Looking at phpPgAdmin, I see the table sogo_cache_folder_hanns_A_hanauix_D_de and indeed, there is no column c_uid. Any help appreciated. Regards Hanns -- users@sogo.nu https://inverse.ca/sogo/lists
