I did it again. . .

[KevinH]

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?

[jholder]

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

[jholder]

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

mmmk, Kevin I owe you one man

the fixperms script explictly skips the message store:

# 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?

[KevinH]

su - zimbra
postqueue -f


I think the script is fine. Very rare that you need to change the store and backup dirs.

[jholder]

Thanks!

I think I learned some very very important lessons today.

[jholder]

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

[KevinH]

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.

[bobby]

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/