Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Where Zimbra tags are stored?

  1. #1
    a1ex is offline Active Member
    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
    dalmate is offline Elite Member
    Join Date
    Jan 2009
    Posts
    359
    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
    a1ex is offline Active Member
    Join Date
    Apr 2013
    Posts
    33
    Rep Power
    0

    Default

    Really? Where exactly?

  4. #4
    kapplebaum is offline Active Member
    Join Date
    May 2013
    Location
    California
    Posts
    27
    Rep Power
    1

    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
    a1ex is offline Active Member
    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
    kapplebaum is offline Active Member
    Join Date
    May 2013
    Location
    California
    Posts
    27
    Rep Power
    1

    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...

  7. #7
    a1ex is offline Active Member
    Join Date
    Apr 2013
    Posts
    33
    Rep Power
    0

    Default

    Well, obviously I need to wait for somebody having 7.2.2.

    Anyway, kapplebaum, thank you very much!

  8. #8
    kapplebaum is offline Active Member
    Join Date
    May 2013
    Location
    California
    Posts
    27
    Rep Power
    1

    Default

    While you're waiting, you might take a look at the data in mail_item for grins. Looking at the tables you have, that's the place I'd think to store it if I was writing the code.

  9. #9
    ccelis5215 is offline Elite Member
    Join Date
    Jun 2011
    Location
    Caracas Venezuela
    Posts
    443
    Rep Power
    3

    Default

    Quote Originally Posted by kapplebaum View Post
    While you're waiting, you might take a look at the data in mail_item for grins. Looking at the tables you have, that's the place I'd think to store it if I was writing the code.
    Of course, you're right.

    As OP said, he's using SOAP. Maybe he has to revisit the API.

    ccelis

  10. #10
    a1ex is offline Active Member
    Join Date
    Apr 2013
    Posts
    33
    Rep Power
    0

    Default

    Just checked tags in mail_item (and mail_item_dumpster) tables of all mboxgroup* dbs and found just numbers like 1,16 ... Probably they show number of tags, not tags themselves as I expected strings like "TAG_1", "NEW" ... which I can see in "tags" panel in UI.

    I tried to find related source code here
    https://github.com/Zimbra-Community/zimbra-sources

    to clarify where SOAP service puts them but was able to find request/response message classes only
    https://github.com/Zimbra-Community/...agRequest.java
    https://github.com/Zimbra-Community/...gResponse.java

    Could somebody point me to right source code part/docs please?

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Emails recovery from stored location (Zimbra Desktop)
    By mefani in forum General Questions
    Replies: 0
    Last Post: 04-07-2012, 02:17 PM
  2. Emails recovery from stored location (Zimbra Desktop)
    By mefani in forum Installation Help
    Replies: 0
    Last Post: 04-07-2012, 02:17 PM
  3. What is stored in Zimbra Backup and not???
    By mnbvmnbv in forum Administrators
    Replies: 0
    Last Post: 05-09-2011, 03: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, 01:23 PM
  5. where are the tags stored?
    By eleith in forum Developers
    Replies: 1
    Last Post: 10-21-2008, 10: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
  •