Results 1 to 5 of 5

Thread: [SOLVED] Messages (.msg) exist in the store, but don't show up in web UI

  1. #1
    MaffooClock's Avatar
    MaffooClock is offline Active Member
    Join Date
    Jan 2009
    Location
    Texas
    Posts
    36
    Rep Power
    6

    Default [SOLVED] Messages (.msg) exist in the store, but don't show up in web UI

    I've had to restore from backup. I had a server-only backup from this past Sunday (once per week) and then I had a message store backup from earlier today (once per day). I was able to get everything restored and running, but users are complaining that mail is missing from the past 5 days. My own account is missing mail as well, so this is is an accurate problem.

    As a test, I searched through the message store for subjects with "Daily mail report for Oct 2?", and three results came back (one each for this past Tuesday, Wednesday, and Thursday). I was also able to search the message store for other mail I received during the past few days. The point: the messages do exist. However, in the web UI, none past the Sunday server backup are being displayed.

    By the way, I even re-ran the installer thinking that when I am prompted to verify integrity, that might help things (not sure if there's a command I can use to do that manually, which is kind of what I am asking for). So, even after a re-install, no dice.

    Since this is OSE, I am left to fend for myself with backups (so it comes as no surprise that I didn't do it right). So I'm guessing that there is an inconsistency with the message store and the data store? Or what? How do I get Zimbra to realize that there are orphaned messages in the message store?
    Last edited by MaffooClock; 10-23-2009 at 03:08 PM.

  2. #2
    MaffooClock's Avatar
    MaffooClock is offline Active Member
    Join Date
    Jan 2009
    Location
    Texas
    Posts
    36
    Rep Power
    6

    Default

    This reply contained helpful information:

    Recover data from store folders

    Looks like either `zmmailbox addMessage` or `zmlmtpinject` is what I seek. If anyone has any advice, though, I'd appreciate it. (Particularly, if there's a way to run these commands only on .msg files within a certain age.)

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

    Default

    You might try some tricks with `find -ctime` to find the files you are looking for. -mtime might be another option.

    For future reference... the mailstore is only part of a users backup, which is why with FOSS you basically have to keep a full copy of /opt/zimbra for every backup you want to take.

  4. #4
    MaffooClock's Avatar
    MaffooClock is offline Active Member
    Join Date
    Jan 2009
    Location
    Texas
    Posts
    36
    Rep Power
    6

    Default

    Okay, I've hacked together a solution that resolves my problem:

    I grep'd for messages with a range of Date: fields
    Code:
    grep "^Date: [a-zA-Z]*, 2[0123] Oct 2009" */* -l > list.txt
    This gave me all message from the 20th through the 23rd, which is what I wanted.

    Then, I use the following script to pump each of those files found into a folder named "Recovery" in the user's mailbox:
    Code:
    #!/bin/sh
    for i in `cat list.txt`
    do
            /opt/zimbra/bin/zmmailbox -z -m user@domain.tld addMessage /Recovery /opt/zimbra/store/0/<user's zimbra id>/msg/$i
    done
    I ran this script for each user that wanted all messages re-added to their mailbox. I'm sure the script could have been modified to include the grep, get the user's zimbra ID and account name, clean up, and repeat this for each leaf within store/0/<zimbra id> ,but I had to slap something together so I could get the job done quickly.

    I hope my experience helps someone else.

  5. #5
    MaffooClock's Avatar
    MaffooClock is offline Active Member
    Join Date
    Jan 2009
    Location
    Texas
    Posts
    36
    Rep Power
    6

    Default

    Quote Originally Posted by ArcaneMagus View Post
    ...with FOSS you basically have to keep a full copy of /opt/zimbra for every backup you want to take.
    Thank you for the tip -- I guarantee that's what I will do from now on.

    For what it's worth: I am using a backup script (zimbackup.sh) by Marcus Uddenhed from www.swedcore.net, which has options for different types of backups. Perhaps he's not aware that creating backups of only the message store isn't necessarily a good option. This is a good script, but after what I just went through, it looks like the only reliable backup with this script is by using the "full" option.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 05-28-2008, 04:18 AM
  2. Web interface will not show up
    By jjovah in forum Administrators
    Replies: 1
    Last Post: 11-15-2006, 07:51 PM
  3. Can't send messages through Web Interface
    By rvanscherpe in forum Installation
    Replies: 4
    Last Post: 08-03-2006, 10:04 AM
  4. Comments and wishes for web interface
    By PNE in forum Administrators
    Replies: 2
    Last Post: 04-12-2006, 08:48 AM
  5. Web client freezes on trying to open messages
    By billybofh in forum Administrators
    Replies: 9
    Last Post: 04-05-2006, 05:45 PM

Posting Permissions

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