Results 1 to 10 of 11

Thread: Where Zimbra tags are stored?

Hybrid View

  1. #1
    Join Date
    Apr 2013
    Posts
    33
    Rep Power
    0

    Default Where Zimbra tags are stored?

    Hello,

    I need to create the same tag (name, color) for all users of some group.
    For current session this can be done via CreateTagRequest SOAP request.

    Most probably I have to develop server side extension (for SOAP service).

    But I can't find where those tags are located? (mysql/ldap)

  2. #2
    Join Date
    Jan 2009
    Posts
    369
    Rep Power
    6

    Default

    Quote Originally Posted by a1ex View Post
    Hello,

    I need to create the same tag (name, color) for all users of some group.
    For current session this can be done via CreateTagRequest SOAP request.

    Most probably I have to develop server side extension (for SOAP service).

    But I can't find where those tags are located? (mysql/ldap)
    In MySql database.

  3. #3
    Join Date
    Apr 2013
    Posts
    33
    Rep Power
    0

    Default

    Really? Where exactly?

  4. #4
    Join Date
    May 2013
    Location
    California
    Posts
    27
    Rep Power
    2

    Default Location of tags

    Not sure what your experience is with mysql, so I apologize if this is too detailed. (But it will help others in the future, so it's all good. ) I'll assume you at least know how to get into mysql in the Zimbra CLI.

    Each mailbox group has its own set of tags. Here's what I did to see the tags for my group, 40.

    Code:
    > show databases;
    > use mboxgroup40;
    > show tables;
    > show columns from tag;
    > select * from tag;
    (If you know SQL, you know some of these steps are not necessary, but they are instructive for people who aren't familiar with databases.)

    HTH,
    Kathy A.

    <edit>
    I just realized you may have already created the tags themselves, and are wanting to know where they are kept for individual mail items. If so, that's in the tagged_item table in the mboxgroupxx database.
    </edit>

  5. #5
    Join Date
    Apr 2013
    Posts
    33
    Rep Power
    0

    Default

    Fortunately I have some experience with mysql.

    Yes, I have created my custom tags and want to know where they are located.

    I'm logged in as zimbra user.

    I can see mboxgroupXXX databases, but non of them contains "tag*" table

    mysql> show tables;
    +-----------------------+
    | Tables_in_mboxgroup11 |
    +-----------------------+
    | appointment |
    | appointment_dumpster |
    | data_source_item |
    | imap_folder |
    | imap_message |
    | mail_item |
    | mail_item_dumpster |
    | open_conversation |
    | pop3_message |
    | revision |
    | revision_dumpster |
    | tombstone |
    +-----------------------+
    12 rows in set (0.00 sec)

    Do I need different account with proper privileges to see that and probably other tables?

    P.S. I'm using ZCS Network Edition 7.2.2.

  6. #6
    Join Date
    May 2013
    Location
    California
    Posts
    27
    Rep Power
    2

    Default

    Here's mine:
    mysql> show tables;
    +-----------------------+
    | Tables_in_mboxgroup40 |
    +-----------------------+
    | appointment |
    | appointment_dumpster |
    | data_source_item |
    | imap_folder |
    | imap_message |
    | mail_item |
    | mail_item_dumpster |
    | open_conversation |
    | pop3_message |
    | revision |
    | revision_dumpster |
    | tag |
    | tagged_item |
    | tombstone |
    +-----------------------+
    14 rows in set (0.00 sec)

    I'm using 8.0.0...

Similar Threads

  1. Emails recovery from stored location (Zimbra Desktop)
    By mefani in forum General Questions
    Replies: 0
    Last Post: 04-07-2012, 03:17 PM
  2. Emails recovery from stored location (Zimbra Desktop)
    By mefani in forum Installation Help
    Replies: 0
    Last Post: 04-07-2012, 03:17 PM
  3. What is stored in Zimbra Backup and not???
    By mnbvmnbv in forum Administrators
    Replies: 0
    Last Post: 05-09-2011, 04:38 AM
  4. [SOLVED] Invalid PIN: Where in BES or Zimbra are PINs stored?
    By dpmchris in forum Zimbra Connector for BlackBerry
    Replies: 2
    Last Post: 10-12-2009, 02:23 PM
  5. where are the tags stored?
    By eleith in forum Developers
    Replies: 1
    Last Post: 10-21-2008, 11:28 AM

Tags for this Thread

Posting Permissions

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