Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18

Thread: I did it again. . .

  1. #11
    KevinH's Avatar
    KevinH is offline Expert Member
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,789
    Rep Power
    18

    Default

    What are the permission and owner of this file?

    /opt/zimbra/store/0/2/msg/0/2713-5793.msg (Permission denied)

    Did you try the fixperms.sh script?
    Looking for new beta users -> Co-Founder of Acompli. Previously worked at Zimbra (and Yahoo! & VMware) since 2005.

  2. #12
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

    Ya, I noticed it was a permissions issue while you were posting

    If i run it as zimbra, it says operation not permitted, and if it run it as root, it kicks me back to the prompt.

    I think that's i'll edit the script, and run it forcefully

  3. #13
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default Wahoo!!!

    Wow, it sure has been a 24 hours, eh?

    mmmk, Kevin I owe you one man

    the fixperms script explictly skips the message store:
    Code:
    # NOT /opt/zimbra/store, /opt/zimbra/backup takes forever
    chown -R zimbra:zimbra /opt/zimbra/a* /opt/zimbra/[c-ot-z]* /opt/zimbra/s[a-su-z]* /opt/zimbra/perdition-1.17
    So, I added:
    chown -R zimbra:zimbra /opt/zimbra/st*

    So is this something perpahs we should just leave alone, or create a standalone script?

    Just wonderin.

    EDIT: How to I force the messages in the queue to be delivered?
    Last edited by jholder; 03-25-2006 at 10:42 AM.

  4. #14
    KevinH's Avatar
    KevinH is offline Expert Member
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,789
    Rep Power
    18

    Default

    su - zimbra
    postqueue -f


    I think the script is fine. Very rare that you need to change the store and backup dirs.
    Looking for new beta users -> Co-Founder of Acompli. Previously worked at Zimbra (and Yahoo! & VMware) since 2005.

  5. #15
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

    Thanks!

    I think I learned some very very important lessons today.

  6. #16
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default SQL Table reference

    Hi,
    So as you may remember, I had this near catastrophe, but I restored from a backup.

    I still have the old Zimbra folder with the message store. Is there a way for me to figure out who's messages are in what folder?

    Example: I have a teacher who needs some old e-mails, but I'm not even sure where to start.

    Thanks!

    jh

  7. #17
    KevinH's Avatar
    KevinH is offline Expert Member
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,789
    Rep Power
    18

    Default

    So the mail you have in the "old Zimbra folder" are not part of the active system? Not sure I understand. The mail msg's themselves have the full mime msg, but to figure out the folder you'd need to have the matching MySQL data.
    Looking for new beta users -> Co-Founder of Acompli. Previously worked at Zimbra (and Yahoo! & VMware) since 2005.

  8. #18
    bobby is offline Zimbra Employee
    Join Date
    Nov 2005
    Posts
    518
    Rep Power
    10

    Default

    do you have the original /opt/zimbra/db/?

    you can find the mailbox id in mysql like this:

    use zimbra;
    select * from mailbox where comment like '%EMAIL-ADDRESS-FRAGMENT%';


    then the messages are in /opt/zimbra/store/0/ID/

    where ID is the mailbox id found from mysql, and 0 is actually ID << 12 (i.e. 0 if ID < 4096).

    if you don't have the original mysql dbs you could grep the email address out of store/ though it might take a while

    grep -r 'for <EMAIL-ADDRESS>' ~/store/

Page 2 of 2 FirstFirst 12

Thread Information

Users Browsing this Thread

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

Posting Permissions

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