Problem with /etc/postfix/ispcp/mailboxes almost empty

[waweiwi]

Hi All,

I have ispCP system running for a year but before 2 days, there is a strange case where after any email addition or deletion the /etc/postfix/ispcp/mailboxes deleted all emails and just putted a few lines not more.

Is this related to strange records in the databse ispcp specially in the field mail_users or related to anything else?

How to debug it?

Please advise

BR

[joximu]

I don't know why this happesn.

But just be sure to have a copy of the original file:

make a copy of the latest backup file which contains a full
/etc/ispcp/postfix/working/mailboxes

The backups are in /var/www/ispcp/backups/config-backup....

You may copy the backup to /etc/ispcp/postfix/working/ and with the next change of mail accounts the file should be base for modifications...

/J

[waweiwi]

Hi,

but after any modification to any existing domain the file return to an empty file but with a few email account that read partially from db.

BR

[joximu]

hm - then there is something broken.
Maybe in the database.

/J

[waweiwi]

yes, I agree with you....

But how to know where is it exactly?

or

What is the steps that the engine follow when adding or deleting emails? is it just read mail_users field from the db and drop it in the file?

I start thinking to delete raw by raw in the mail_users field and watch if this will change the case!!!

BR

[joximu]

Normally it happens this way:

the working copy is taken (/etc/ispcp/postfix/working/mailboxes)
depending on command:
mail add: a new line is added
mail change: the line is searched and deleted and then the new line added
mail delete: the line is searched and deleted
the new file is written to the working copy (see above) and the system (etc/postfix/ispcp/mailboxes) and postmap is run....

So, the mail_users table must be really ugly...
check all the rows where status is not "ok".

/J

[waweiwi]

all the stats there are ok!!!!!!!

[joximu]

So, I'd enable debugging and have a look at the ispcp logfiles...

/J