1 (edited by alexandercolhost 2020-07-16 23:21:03)

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.

2

Re: Issue with signature and preferences of mailboxes

alexandercolhost wrote:

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)

I don't think so.
This "cron_backup_sogo" info is generated by the backup script /var/vmail/backup/backup_sogo.sh, it simply backups data, no modification.

Was there any changes to SOGO packages? e.g. upgraded? or other manual changes?