Topic: Issue with signature and preferences of mailboxes
==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.2.1 MARIADB edition.
- Deployed with iRedMail Easy or the downloadable installer? downloadable installer
- Linux/BSD distribution name and version: CentOS Linux release 8.2.2004 (Core)
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? iRedAdmin-Pro 4.3 (MySQL)
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
Hello, we need to know why the preferences of our mailboxes are being cleaned. Via mysql yesterday we checked 2 mailboxes that have a signature whiel worked fine:
SELECT CHAR_LENGTH(c_defaults) FROM sogo_user_profile WHERE c_uid='user@correopremium.com';
721320
SELECT CHAR_LENGTH(c_defaults) FROM sogo_user_profile WHERE c_uid='sharon.castillo@cuentasyservicios.com.co';
45568
But today, all the configuration of the mailbox disappeared:
SELECT CHAR_LENGTH(c_defaults) FROM sogo_user_profile WHERE c_uid='user@correopremium.com';
2
SELECT CHAR_LENGTH(c_defaults) FROM sogo_user_profile WHERE c_uid='sharon.castillo@cuentasyservicios.com.co';
2
Only show:
SELECT c_defaults FROM sogo_user_profile WHERE c_uid='user@correopremium.com';
{}
We think that the issue can be generated in a cron, by example:
2020-07-16 04:03:45 cron_backup_sogo 127.0.0.1 SOGo data. size: 18M (original: 75M)
What can be the cause of this issue?
The table sogo_user_profile structure is:
| Field | Type | Null | Key | Default | Extra |
| c_uid | varchar(255) | NO | PRI | NULL | |
| c_defaults | mediumtext | YES | | NULL | |
| c_settings | text | YES | | NULL | |
Additionally, can help us to verify if the signature can have two or more images? Some users say that dont allow save a signature with 2 images
Many thanks
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.