1 Topic by orlovnv

  • orlovnv
  • Member
  • Offline
  • Registered: 2018-01-16
  • Posts: 13

Topic: iOS active sync error

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.7.1 MARIADB edition.
- Deployed with iRedMail Easy or the downloadable installer? downloadable installer
- Linux/BSD distribution name and version: Debian 12
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx):Nginx
- Manage mail accounts with iRedAdmin-Pro? no
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
active sync work if I open mail app or 1-2 minutes after that, then I have an error
[ERROR] <0x0x5e84db0d9c50[WOHttpTransaction]> client disconnected during delivery of response for <WORequest[0x0x5e84dabe2190]: method=POST uri=/SOGo/Microsoft-Server-ActiveSync?User=orlov@orenadvocat.ru&DeviceId=BOJR2Q68M57T9E1FRSA7T02B24&DeviceType=iPhone&Cmd=Ping app=SOGo rqKey=Microsoft-Server-ActiveSync rqPath=(null)> (len=13): the socket was shutdown

some times I have that errors
Nov 16 06:36:21 sogod [15176]: [ERROR] <0x0x5e84da7bda00[SQLSource]> could not run SQL 'SELECT c_name FROM users WHERE ((UPPER(c_o) LIKE UPPER('%or%')) OR (UPPER(c_cn) LIKE UPPER('%or%')) OR (UPPER(mail) LIKE UPPER('%or%')) OR (UPPER(c_l) LIKE UPPER('%or%')) OR (UPPER(c_telephonenumber) LIKE UPPER('%or%'))) AND (domain = 'orenadvocat.ru')': <MySQL4Exception: 0x5e84da9e4b70> NAME:ExecutionFailed REASON:Unknown column 'c_o' in 'where clause'
Nov 16 06:36:21 sogod [15176]: [ERROR] <0x0x5e84da7bda00[SQLSource]> failed to acquire channel for URL: mysql://sogo:QEUVpNhV8uLE0XLbUkyk71En9KCsh7hx@127.0.0.1:3306/sogo/users

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by orlovnv

  • orlovnv
  • Member
  • Offline
  • Registered: 2018-01-16
  • Posts: 13

Re: iOS active sync error

anybody can answer me?

3 Reply by Pavel Zhe

  • Pavel Zhe
  • Member
  • Offline
  • Registered: 2023-12-12
  • Posts: 40

Re: iOS active sync error

orlovnv wrote:

anybody can answer me?

You can write about sogo-related issue to users@sogo.nu (SOGo maillist)

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,121

Re: iOS active sync error

orlovnv wrote:

Nov 16 06:36:21 sogod [15176]: [ERROR] <0x0x5e84da7bda00[SQLSource]> could not run SQL 'SELECT c_name FROM users WHERE ((UPPER(c_o) LIKE UPPER('%or%')) OR (UPPER(c_cn) LIKE UPPER('%or%')) OR (UPPER(mail) LIKE UPPER('%or%')) OR (UPPER(c_l) LIKE UPPER('%or%')) OR (UPPER(c_telephonenumber) LIKE UPPER('%or%'))) AND (domain = 'orenadvocat.ru')': <MySQL4Exception: 0x5e84da9e4b70> NAME:ExecutionFailed REASON:Unknown column 'c_o' in 'where clause'

Which SOGo version are you running?
There's no "c_o" column in "users" table.

5 Reply by orlovnv

  • orlovnv
  • Member
  • Offline
  • Registered: 2018-01-16
  • Posts: 13

Re: iOS active sync error

I use latest version which goes wit 1.7.1 iredmail

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,121

Re: iOS active sync error

orlovnv wrote:

some times I have that errors
Nov 16 06:36:21 sogod [15176]: [ERROR] <0x0x5e84da7bda00[SQLSource]> could not run SQL 'SELECT c_name FROM users WHERE ((UPPER(c_o) LIKE UPPER('%or%')) OR (UPPER(c_cn) LIKE UPPER('%or%')) OR (UPPER(mail) LIKE UPPER('%or%')) OR (UPPER(c_l) LIKE UPPER('%or%')) OR (UPPER(c_telephonenumber) LIKE UPPER('%or%'))) AND (domain = 'orenadvocat.ru')': <MySQL4Exception: 0x5e84da9e4b70> NAME:ExecutionFailed REASON:Unknown column 'c_o' in 'where clause'

How can i reproduce this error?

7 Reply by orlovnv

  • orlovnv
  • Member
  • Offline
  • Registered: 2018-01-16
  • Posts: 13

Re: iOS active sync error

after reboot this error gone, but still there is first error and activesync failed

grep 'ERROR' /var/log/sogo/sogo.log
Nov 21 06:15:11 sogod [37794]: [ERROR] <0x0x63301588d8b0[WOHttpTransaction]> client disconnected during delivery of response for <WORequest[0x0x633015556570]: method=POST uri=/SOGo/Microsoft-Server-ActiveSync?User=cisar@advocatorb.ru&DeviceId=BOJR2Q68M57T9E1FRSA7T02B24&DeviceType=iPhone&Cmd=Ping app=SOGo rqKey=Microsoft-Server-ActiveSync rqPath=(null)> (len=13): the socket was shutdown
Nov 21 06:15:19 sogod [37369]: [ERROR] <0x0x63301582ad10[WOHttpTransaction]> client disconnected during delivery of response for <WORequest[0x0x633015556570]: method=POST uri=/SOGo/Microsoft-Server-ActiveSync?User=orlov@orenadvocat.ru&DeviceId=BOJR2Q68M57T9E1FRSA7T02B24&DeviceType=iPhone&Cmd=Ping app=SOGo rqKey=Microsoft-Server-ActiveSync rqPath=(null)> (len=13): the socket was shutdown
Nov 21 06:17:27 sogod [475]: [ERROR] <0x6330157a1080[SOGoAppointmentFolder]:personal> DAV property '{urn:ietf:params:xml:ns:caldav}schedule-tag' has no matching SQL field, response could be incomplete
Nov 21 06:17:27 sogod [475]: [ERROR] <0x6330157a1080[SOGoAppointmentFolder]:personal> DAV property '{http://calendarserver.org/ns/}created-by' has no matching SQL field, response could be incomplete
Nov 21 06:17:27 sogod [475]: [ERROR] <0x6330157a1080[SOGoAppointmentFolder]:personal> DAV property '{http://calendarserver.org/ns/}updated-by' has no matching SQL field, response could be incomplete
Nov 21 06:30:56 sogod [39309]: [ERROR] <0x0x6330156404f0[WOHttpTransaction]> client disconnected during delivery of response for <WORequest[0x0x6330159c24a0]: method=POST uri=/SOGo/Microsoft-Server-ActiveSync?User=cisar@advocatorb.ru&DeviceId=BOJR2Q68M57T9E1FRSA7T02B24&DeviceType=iPhone&Cmd=Ping app=SOGo rqKey=Microsoft-Server-ActiveSync rqPath=(null)> (len=13): the socket was shutdown
Nov 21 06:31:26 sogod [470]: [ERROR] <0x0x633015d36e50[WOHttpTransaction]> client disconnected during delivery of response for <WORequest[0x0x633016535ea0]: method=POST uri=/SOGo/Microsoft-Server-ActiveSync?User=orlov@advocatorb.ru&DeviceId=BOJR2Q68M57T9E1FRSA7T02B24&DeviceType=iPhone&Cmd=Ping app=SOGo rqKey=Microsoft-Server-ActiveSync rqPath=(null)> (len=13): the socket was shutdown
Nov 21 06:31:27 sogod [39310]: [ERROR] <0x0x6330156c47f0[WOHttpTransaction]> client disconnected during delivery of response for <WORequest[0x0x633015697ae0]: method=POST uri=/SOGo/Microsoft-Server-ActiveSync?User=orlov@orenadvocat.ru&DeviceId=BOJR2Q68M57T9E1FRSA7T02B24&DeviceType=iPhone&Cmd=Ping app=SOGo rqKey=Microsoft-Server-ActiveSync rqPath=(null)> (len=13): the socket was shutdown

8 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,121

Re: iOS active sync error

orlovnv wrote:

Nov 21 06:17:27 sogod [475]: [ERROR] <0x6330157a1080[SOGoAppointmentFolder]:personal> DAV property '{http://calendarserver.org/ns/}created-by' has no matching SQL field, response could be incomplete

I didn't see similar error before. Did you migrate SOGo SQL database from an old iRedMail server (or other server)?