I am writing a zimlet that will allow users to retract a sent email as long as it has not been read by any of the recipients. Basically, it takes information about a sent message that is drag and dropped onto the zimlet, and uses the subject, date, and metadata for a mysql query to find out if it has been read by anyone. If it has not then the option to retract the email is given. This works great on a single server installation of zimbra.
My problem is trying to adapt it to a multi-server setup. We have 1 LDAP server, 1 MTA server, and 3 mailbox servers. From what I can tell, I would need to query the mysql databases on each of the 3 mailbox servers to get an accurate count since (i believe) each mailbox server has unique mailbox groups. I guess what i ultimately need to know is how, say a user uses this zimlet and their account is on mailbox server 1, how to connect to the mysql databases on servers 2 and 3. It seems like you can only connect to it using localhost:7306. Any help provided is greatly appreciated!