[Web-cyradm] FQUN SOLVED: (almost)

[Phil Meyer]

Here are the salient parts:
/etc/pam.d/[pop|pop3|imap|sieve] as previously described.

/etc/imapd.conf and /etc/imapd-local.conf need to contain:
...
unixhierarchysep: yes
defaultdomain: xmail.epliant.com
virtdomains: on
createonpost: yes
...
main.cf differs from the Howto now:
*** main.cf     2006-05-12 11:14:33.000000000 -0600
--- main.cf-howto       2006-05-12 11:13:55.000000000 -0600
***************
*** 156,162 ****
  # See also below, section "REJECTING MAIL FOR UNKNOWN LOCAL USERS".
  #
  ##Change by Kai 5.9.06
! mydestination = xmail.epliant.com, localhost, xmail
  #mydestination = $myhostname, localhost.$mydomain, localhost
  #mydestination = $myhostname, localhost.$mydomain, localhost, $mydomain
  #mydestination = $myhostname, localhost.$mydomain, localhost, $mydomain,
--- 156,162 ----
  # See also below, section "REJECTING MAIL FOR UNKNOWN LOCAL USERS".
  #
  ##Change by Kai 5.9.06
! mydestination = xmail.epliant.com, localhost, xmail, 
mysql:/etc/postfix/mysql-mydestination.cf
  #mydestination = $myhostname, localhost.$mydomain, localhost
  #mydestination = $myhostname, localhost.$mydomain, localhost, $mydomain
  #mydestination = $myhostname, localhost.$mydomain, localhost, $mydomain,
***************
*** 460,467 ****
  # non-UNIX accounts with "User unknown in local recipient table".
  #
  ##Change by Kai 5.9.06
! #mailbox_transport = cyrus
! mailbox_transport = lmtp:unix:/var/lib/imap/socket/lmtp

  # If using the cyrus-imapd IMAP server deliver local mail to the IMAP
  # server using LMTP (Local Mail Transport Protocol), this is prefered
--- 460,467 ----
  # non-UNIX accounts with "User unknown in local recipient table".
  #
  ##Change by Kai 5.9.06
! mailbox_transport = cyrus
! #mailbox_transport = lmtp:unix:/var/lib/imap/socket/lmtp

  # If using the cyrus-imapd IMAP server deliver local mail to the IMAP
  # server using LMTP (Local Mail Transport Protocol), this is prefered
***************
*** 675,684 ****
  readme_directory = /usr/share/doc/postfix-2.2.8/README_FILES

  ##Added by Kai 5.9.06
- virtual_mailbox_domains = mysql:/etc/postfix/mysql-mydestination.cf
- virtual_mailbox_base = /
  virtual_alias_maps = mysql:/etc/postfix/mysql-virtual.cf
- virtual_transport = lmtp:unix:/var/lib/imap/socket/lmtp
  sender_canonical_maps = mysql:/etc/postfix/mysql-canonical.cf

  smtpd_sasl_auth_enable = yes
--- 675,681 ----

The big issues are:  transport, virtual_transport, and mydestination
By moving the allowed domains down to virtual_domains instead, we get 
the FQUN
sent to cyrus.  However, if we use the imap server it thinks all mail is 
local.  So that is why we changed transports to lmtp.

The next minor change involves the user name returned.  To fix that, we 
needed to modify mysql-virtual.cf.

*** mysql-virtual.cf    2006-05-11 23:21:56.000000000 -0600
--- mysql-virtual.cf-4487       2006-05-11 16:11:49.000000000 -0600
***************
*** 15,20 ****
  table = virtual

  #
! select_field = alias
  where_field = alias
  additional_conditions = and status = '1'
--- 15,20 ----
  table = virtual

  #
! select_field = dest
  where_field = alias
  additional_conditions = and status = '1'

Basically return alias instead of dest.  This makes the mail virtual, 
and therefore we needed to set a virtual_mailbox_base directory in the 
main.cf.

That fixes it.  All works with ONE (so far) exception.
When using this server as my smtp host from a remote location it does 
not authenticate.
I am quite sure its the sql we just modified above, but I am not certain 
yet, and I don't have a solution yet.  So I am calling it 90% done. :)