Users

[igorstephano]

Hi,!!

I've created a user but I want to know where in the database it is saved.
Which table is containing the user's information.

Regards.

Igor

[drhughes]

1. Fetch the user's mailbox ID. zmprov getMailboxInfo user@somedomain
2. Concatenate the group ID with the term "mboxgroup" to get the user's database.
3. mysql mboxgroup{gropuID}
4. select * from mail_item where mailbox_id={mailbox ID}

[igorstephano]

Can you explaim me more, how I must do the step 2 and 3?
Please

[drhughes]

ls /opt/zimbra/db/data
Your user information is in one of those DBs. Use step 1 to find out which one.

What is your ultimate goal? I find the zmprov and the zmmailbox tool will handle just about anything you want to do.

Example: zmprov ga user@doamin