Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: DBMail: users
Migration to LDAP with Postfix
 

Index | Next | Previous | View Flat


gordan at bobich

May 22, 2009, 5:56 AM


Views: 508
Permalink
Migration to LDAP with Postfix

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
DBmail[at]dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Subject User Time
Migration to LDAP with Postfix gordan at bobich May 22, 2009, 5:56 AM
    Re: Migration to LDAP with Postfix paul at nfg May 22, 2009, 8:27 AM
        Re: Migration to LDAP with Postfix gordan at bobich May 22, 2009, 8:54 AM

  Index | Next | Previous | View Flat
 
 


Interested in having your list archived? Contact lists@gossamer-threads.com
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.