I'm currently using DBMail in standalone mode, and my Postfix domain and recipient maps are as follows:
main.cf: mydestination = $myhostname, localhost.localdomain, localhost, mysql:/etc/postfix/sql-domains.cf local_recipient_maps = mysql:/etc/postfix/sql-recipients.cf proxy:unix:passwd.byname $alias_maps sql-domains.cf: query = SELECT DISTINCT SUBSTRING_INDEX(dbmail_aliases.alias,'@',-1) FROM dbmail_aliases WHERE dbmail_aliases.alias LIKE '%...@%%' AND SUBSTRING_INDEX(dbmail_aliases.alias,'@',-1) = '%s' UNION SELECT DISTINCT SUBSTRING_INDEX(dbmail_users.userid,'@',-1) FROM dbmail_users WHERE userid NOT LIKE '__%%' AND SUBSTRING_INDEX(dbmail_users.userid,'@',-1) = '%s'; sql-recipients.cf: query = SELECT alias FROM dbmail_aliases WHERE alias='%s' UNION SELECT userid FROM dbmail_users WHERE userid='%s'; How does this need to change when migrating to LDAP? Since the main address is now in LDAP, I presume that so will be any aliases, whereas before the aliases were in the dbmail database. Am I understanding this correctly or will this end up being duplicated in the database my dbmail? What will end up needing to be looked up from the DB and what will end up needing to be looked up from LDAP? Thanks. Gordan _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
