Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: [SOLVED] Lost user email

  1. #1
    bibo is offline Senior Member
    Join Date
    Jul 2007
    Location
    Brazil
    Posts
    55
    Rep Power
    8

    Exclamation [SOLVED] Lost user email

    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

  2. #2
    veronica is offline Outstanding Member
    Join Date
    Jun 2008
    Posts
    594
    Rep Power
    8

    Default

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

  3. #3
    bibo is offline Senior Member
    Join Date
    Jul 2007
    Location
    Brazil
    Posts
    55
    Rep Power
    8

    Default

    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


    Quote Originally Posted by veronica View Post
    What error does it give while recovering mysql ? Do you have backups available with you ?

  4. #4
    veronica is offline Outstanding Member
    Join Date
    Jun 2008
    Posts
    594
    Rep Power
    8

    Default

    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

  5. #5
    bibo is offline Senior Member
    Join Date
    Jul 2007
    Location
    Brazil
    Posts
    55
    Rep Power
    8

    Default

    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

    Quote Originally Posted by veronica View Post
    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

  6. #6
    bibo is offline Senior Member
    Join Date
    Jul 2007
    Location
    Brazil
    Posts
    55
    Rep Power
    8

    Default

    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

  7. #7
    phoenix is online now Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,505
    Rep Power
    57

    Default

    Quote Originally Posted by bibo View Post
    How do I use zmlmtpinject command?
    For use examples please search the forums and wiki for the word 'zmlmtpinject' or even:

    Code:
    zmlmtpinject --help
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  8. #8
    bibo is offline Senior Member
    Join Date
    Jul 2007
    Location
    Brazil
    Posts
    55
    Rep Power
    8

    Default

    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

  9. #9
    ArcaneMagus's Avatar
    ArcaneMagus is offline Moderator
    Join Date
    Feb 2007
    Location
    Portland, OR
    Posts
    1,147
    Rep Power
    10

    Default

    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.

  10. #10
    bibo is offline Senior Member
    Join Date
    Jul 2007
    Location
    Brazil
    Posts
    55
    Rep Power
    8

    Default

    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

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] mailboxmanager does not start
    By jrefl5 in forum Administrators
    Replies: 18
    Last Post: 01-30-2012, 11:40 PM
  2. User ID & EMAIL ADDRESS
    By adeelarifbhatti in forum Administrators
    Replies: 1
    Last Post: 03-15-2009, 02:58 AM
  3. Replies: 2
    Last Post: 02-12-2008, 11:55 AM
  4. need advice on configuring zimbra to work with fax server
    By pheonix1t in forum Administrators
    Replies: 0
    Last Post: 07-11-2007, 07:46 PM
  5. Post instsallation problems
    By Assaf in forum Installation
    Replies: 14
    Last Post: 01-29-2007, 11:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •