RE: [exim] Using Full Email Address for Cyrus LMTP Deliver

Top Page
Delete this message
Reply to this message
Author: Andrew Johnson
Date:  
To: 'Mark Nipper', 'Andre Nicholson'
CC: exim-users
Subject: RE: [exim] Using Full Email Address for Cyrus LMTP Deliver
I used to do this for virtual domains...

imapd.conf
configdirectory: /var/lib/imap
partition-default: /u1/cyrus
admins: cyradm
sievedir: /var/lib/imap/sieve
sendmail: /usr/sbin/sendmail
allowplaintext: yes
hashimapspool: false
reject8bit: no
unixhierarchysep: false
sasl_pwcheck_method: saslauthd
sasl_mech_list: PLAIN
tls_cert_file: /usr/share/ssl/certs/cyrus-imapd.pem
tls_key_file: /usr/share/ssl/certs/cyrus-imapd.pem
autocreatequota: 1000000
virtdomains: userid
username_tolower: 1
allowanonymouslogin: no

# Following included just to get rid of stupid log messages
sasl_sql_engine: mysql
sasl_sql_hostnames: localhost
sasl_sql_user: xxxxxx
sasl_sql_passwd: xxxxxx
sasl_sql_database: system
sasl_sql_select: select password from users where user_name = '%u'

saslauthd
# Directory in which to place saslauthd's listening socket, pid file, and so
# on. This directory must already exist.
SOCKETDIR=/var/run/saslauthd

# Mechanism to use when checking passwords. Run "saslauthd -v" to get a
list
# of which mechanism your installation was compiled to use.
MECH=pam

# Additional flags to pass to saslauthd on the command line. See
saslauthd(8)
# for the list of accepted flags.
FLAGS=-r

Then I setup pam to use mysql database...

#%PAM-1.0
#auth       required     /lib/security/pam_stack.so service=system-auth
#account    required     /lib/security/pam_stack.so service=system-auth



auth sufficient pam_mysql.so user=xxxxxx passwd=xxxxxx host=localhost
db=system table=users usercolumn=user_email passwdcolumn=user_password
crypt=1 sqllog=N

account required pam_mysql.so user=xxxxxx passwd=xxxxxx host=localhost
db=system table=users usercolumn=user_email passwdcolumn=user_password
crypt=1 sqllog=N


Then I just had exim deliver right to it via lmtp without escaping the @

However, this was 9 months ago, and I since decided to dump cyrus completely
and use courier with SQL backend. I find it much nicer to use, and more
memory efficient on busy machines as exim writes natively to maildir format
and saves all the extra delivery processes / cyrus database overheads.

-Andy-

> -----Original Message-----
> From: Mark Nipper [mailto:nipsy@bitgnome.net]
> Sent: 12 August 2005 04:08
> To: Andre Nicholson
> Cc: exim-users@???
> Subject: Re: [exim] Using Full Email Address for Cyrus LMTP Deliver
>
> On 11 Aug 2005, Andre Nicholson wrote:
> > The only problem is that I have too many accounts in Cyrus. This
> > approach would require rather large alias files (and per
> domain also),
> > searching the files for every SMTP delivery, and the added
> overhead of
> > maintaining the files for every account.
>
>     I actually prefer the flexibility of this approach.
> However, I can see how it could cause issues with extremely 
> large domains since I don't think Exim caches these lookups 
> (allowing me to never issue restarts whenever I update these 
> files, a feature I very much enjoy).

>
>     Maybe someone else can provide an equivalent 
> replacement using one of the database back-ends?  Seems like 
> it would be simple enough to use file backed databases, a 
> real SQL database or maybe even LDAP to achieve the 
> performance required to make this approach feasible with 
> extremely populated domains.

>
> -- 
> Mark Nipper                                                e-contacts:
> 4475 Carter Creek Parkway                           nipsy@???
> Apartment 724                               http://nipsy.bitgnome.net/
> Bryan, Texas, 77802-4481           AIM/Yahoo: texasnipsy ICQ: 66971617
> (979)575-3193                                      MSN: nipsy@???

>
> -----BEGIN GEEK CODE BLOCK-----
> Version: 3.1
> GG/IT d- s++:+ a- C++$ UBL++++$ P--->+++ L+++$ !E---
> W++(--) N+ o K++ w(---) O++ M V(--) PS+++(+) PE(--)
> Y+ PGP t+ 5 X R tv b+++@ DI+(++) D+ G e h r++ y+(**)
> ------END GEEK CODE BLOCK------
>
> ---begin random quote of the moment---
> "Never underestimate the bandwidth of a station wagon filled
> with magtape, or a 747 filled with CD-ROMs."
> -- from the Jargon File's definition of sneakernet ----end
> random quote of the moment----
>
>
>