Topic: Sogo webmail login not working - "cannot write record"
==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.5
- Deployed with iRedMail Easy or the downloadable installer? not sure
- Linux/BSD distribution name and version: Ubuntu 20.04
- 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.
====
I'm not sure how long this has been a problem as most of us using this server access our email through IMAP.
I tried to log in to Sogo webmail today and got an "Unhandled error response" message.
The sogo logs on the server register a successful login but then are unable to write that login to the database. Here are the relevant log entries:
Mar 09 09:35:27 sogod [4949]: SOGoRootPage successful login from '[IP address]' for user '[user@server]' - expire = -1 grace = -1
Mar 09 09:35:27 sogod [4949]: [ERROR] <0x0x55cb49da6270[GCSSessionsFolder]> -[GCSSessionsFolder writeRecordForEntryWithID:value:creationDate:lastSeenDate:]: cannot write record: <MySQL4Exception: 0x55cb4a2cbde0> NAME:ExecutionFailed REASON:Data too long for column 'c_value' at row 1
Any idea how I can address this? Thanks.
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.