hiya
su - zimbra; mysql: will give you the main indexing sql database. su - zimbra; logmysql: will give you the logging db. if you're getting that socket error clearly something has gone wrong! what does this give:?
ps -ef |grep mysql |grep /opt/zimbra/logger |