changed ip addr/zmmailboxdctl not running

[pwhite76]

my appologies, fatigued:

zimbra@mail2:~$ host `hostname`
Host mail2 not found: 2(SERVFAIL)

that looks like a problem...that can't be from just changing the mx records...

[phoenix]

This command is incorrect:

z

imbra@mail2:~$ host 'mail2.leetackle.com'
mail2.leetackle.com has address 174.141.0.158

you should have entered the command as I asked for it and using backticks (the key to the left of the number '1'), like this:

host `hostname`  <-- use the word hostname don't replace it with your actual hostname.

OK, do you host your own DNS servers? If you do, are these DNS servers behind a firewall? I ask this because I'm getting an appalling response when I check your domain. Go to these sites and run a DNS check against your domain name:

Quick Check - Pingability.com
Cricket Liu’s DNS Advisor

[pwhite76]

I had to manually reinject all the emails with zmlmtpinject, but I cannot retrieve the contacts via soap:

zimbra@mail2:~$ zmmailbox
mbox> aa
usage:

  adminAuthenticate(aa)        [opts] {admin-name} {admin-password}
    -u/--url                url to connect to

mbox> adminAuthenticate -u https://mail2.leetackle.com admin@leetackle.com ********
ERROR: zclient.IO_ERROR (invoke cannot determine soap protocol in reply: 
HTTP ERROR: 404
NOT_FOUND
RequestURI=/service/admin/soap/
Powered by jetty://
, server: mail2.leetackle.com) (cause: com.zimbra.common.soap.SoapParseException cannot determine soap protocol in reply: 
HTTP ERROR: 404
NOT_FOUND
RequestURI=/service/admin/soap/
Powered by jetty://
)
mbox>

Is there any way to retrieve the contacts from the mysql database? I have been climbing all over the miscellaneous databases/tables for 2 days now...
All the other posts cover using zmmailbox to export the contacts, but I have no other choice...
The other mysql posts say not to do it with mysql, but I have no other choice at this point...

[pwhite76]

found it in the metadata field of the mail_item table of the mboxgroup#
now I know why its so much better to use soap/zmcontrol