[SOLVED] Lost user email

[bibo]

Hi all,

I had hardware problem. My mysql didn´t start and I saw in logfile that
my database was corrupted. I read the Mysql Crash Recovery Wiki (Mysql Crash Recovery - Zimbra :: Wiki) and
I could recover my database.

But one of my users have lost all email since nov 15 to now and she don´t receive new emails.

I would like to know how I can fix this.
My Zimbra verion is 5.0.19.

Best regards,
Bibo

[veronica]

What error does it give while recovering mysql ? Do you have backups available with you ?

[bibo]

Hi Veronica,

I have received many errors like this bellow with differents page number.

091130 16:11:24 InnoDB: Error: page 304 log sequence number 0 467750856
InnoDB: is in the future! Current system log sequence number 0 915381.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: MySQL :: MySQL 5.0 Reference Manual :: 13.2.6.2 Forcing InnoDB Recovery
InnoDB: for more information.

Maybe I have a old backup. Can the old backup help me?

Best regards,
Bibo

Originally Posted by veronica

What error does it give while recovering mysql ? Do you have backups available with you ?

[veronica]

use last full backup to restore the mail. Then incremental backups and finally redologs. Make sure to restore to some other account name first say restore_user or else you will loose current mails. Then lmtpinject lost mails to the account

[bibo]

Hi Veronica,

I couldn´t find this command. I am using the Open Source Edition.
When the user that lost email try to send a new email she received
an network error. Clicking the button "Show Details" we have this message.

method: SendMsgRequest
msg: system failure: writing open conversation association for hash Lm+bDViFtgEPkWd4dEVhf1U6c18
code; service.FAILURE
detail: soap:Receiver
trace: btpool0-32:1259765442615:b22da6bf1e362955
request: Body {
...
}

Best regards,
Bibo

Originally Posted by veronica

use last full backup to restore the mail. Then incremental backups and finally redologs. Make sure to restore to some other account name first say restore_user or else you will loose current mails. Then lmtpinject lost mails to the account

[bibo]

Hi,

I found the /opt/zimbra/bin/zmlmtpinject command.
I discovered for this user that the mboxgroup is 10.

My procedure to find mboxgroup.

1) Get the user ID of the account in question.
su - zimbra
zmprov ga <account>@domain.com zimbraId

1) Login to mysql on the zimbra host
mysql

2) Change to zimbra database
use zimbra;

3) Find the group ID for the account
select group_id from mailbox where account_id="<zimbraId>";

How do I use zmlmtpinject command?

Best regards,
Bibo

[phoenix]

Originally Posted by bibo

How do I use zmlmtpinject command?

For use examples please search the forums and wiki for the word 'zmlmtpinject' or even:

zmlmtpinject --help

[bibo]

Hi,

I don´t understand how zmlmtpinject command will help in my problem.

My problem is one user has lost email since nov 15 to now. I think that all emails are stored, but they aren´t index. She can´t send email too.

How to force to zimbra verify all email stored and reindex them.
I tried reindex button in the GUI Admin for her but it didn´t work.

best regards,
Bibo

[ArcaneMagus]

You could try exporting the account using zmmailbox, renaming it, creating a new account with the old name, and importing the account. This should fix the issues of not being able to receive mail. Then use zmlmtpinject to add any missing messages that are in the store, but don't show up in the account to the account.

[bibo]

Hi,

I tried to inject one message by zmlmtpinject command and it worked.
I used this command bellow.

$ zmlmtpinject -r user@domain.com -s \
user-old@domain.com /opt/zimbra/store/0/10/msg/11/45325-52305.msg

But this user has many folders. If I use the command bellow all the messages will be in the inbox folder? or the command will create all the folders?

$ zmlmtpinject -r user@domain.com -s user-old@domain.com \
-d /opt/zimbra/store/0/10

Best regards,
Bibo