thr3ads.net - dovecot - [Dovecot] How do I configure sendmail to accept emails for dovecot when dovecot has sql auth/user db. [Aug 2007]

If this information is useful, please help other people find it:
Share via:

Yossie Silverman

2007-Aug-01 18:19 UTC

[Dovecot] How do I configure sendmail to accept emails for dovecot when dovecot has sql auth/user db.

Included below are my config files: sendmail.mc, dovecot.m4,  
dovecot.conf, dovecot-sql.conf.  Whenever I try to send email into  
this system, it rejects it with user does not exist, however, the  
user does exist as far as dovecot (imap) is concerned, it is in the  
database.

THANKS - Yossie

# for i in /etc/dovecot/dovecot.conf /etc/dovecot/dovecot-sql.conf / 
usr/share/sendmail-cf/mailer/dovecot.m4 /etc/mail/sendmail.mc; do  
echo "FILE: $i"; echo ===; echo ""; egrep -v '^
*(#|$)' $i; echo "";
echo ""; done


FILE: /etc/dovecot/dovecot.conf
==
listen = [::]
disable_plaintext_auth = no
ssl_disable = yes
ssl_cert_file = /etc/ssl/dovecot/server.pem
ssl_key_file = /etc/ssl/dovecot/server.key
mail_location = maildir:~/.maildir
namespace private {
     separator = .
     inbox = yes
     hidden = no
}
namespace private {
     separator = .
     prefix = INBOX.
     inbox = no
     hidden = yes
}
first_valid_uid = 0
protocol imap {
}
protocol pop3 {
}
protocol lda {
   postmaster_address = postmaster at example.com
   main_plugin_dir = /usr/lib/dovecot/lda
   mail_plugins = cmusieve quota
}
auth default {
   mechanisms = plain
   passdb sql {
     args = /etc/dovecot/dovecot-sql.conf
   }
   userdb sql {
     args = /etc/dovecot/dovecot-sql.conf
   }
   user = root
   socket listen {
     master {
       path = /var/run/dovecot/auth-master
       mode = 0666
     }
     client {
       path = /var/run/dovecot/auth-client
       mode = 0666
     }
   }
}
dict {
}
plugin {
}


FILE: /etc/dovecot/dovecot-sql.conf
==
driver = mysql
connect = host=localhost dbname=dovecot user=root
default_pass_scheme = PLAIN
password_query = SELECT userPassword as password, user, concat("/var/ 
spool/dovecot/",substr(user,1,1),"/user/",user) as userdb_home,
97 as
userdb_uid, 97 as userdb_gid FROM authdb WHERE user = '%n' and  
userPassword = '%w'
user_query = SELECT concat("/var/spool/imap/",substr(user,1,1),"/
user/",user) as home, 97 as uid, 97 as gid FROM authdb WHERE user =
'%n'


FILE: /usr/share/sendmail-cf/mailer/dovecot.m4
==
Mdovecot,   P=/usr/libexec/dovecot/deliver, F=DFMPhnu9,
             S=EnvFromSMTP/HdrFromSMTP, R=EnvToSMTP/HdrFromSMTP,
             T=DNS/RFC822/X-Unix,
             A=deliver -d $u


FILE: /etc/mail/sendmail.mc
==
divert(-1)
dnl This is the macro config file used to generate the /etc/sendmail.cf
dnl file. If you modify the file you will have to regenerate the
dnl /etc/sendmail.cf by running this macro config through the m4
dnl preprocessor:
dnl
dnl        m4 /etc/mail/sendmail.mc > /etc/mail/sendmail.cf
dnl
dnl You will need to have the sendmail-cf package installed for this to
dnl work.
include(`/usr/share/sendmail-cf/m4/cf.m4')dnl
define(`confDEF_USER_ID',``mail:mail'')dnl
OSTYPE(`linux')dnl
undefine(`UUCP_RELAY')dnl
undefine(`BITNET_RELAY')dnl
define(`confALIAS_WAIT', `30')dnl
define(`confTO_CONNECT', `1m')dnl
define(`confTRY_NULL_MX_LIST',true)dnl
define(`confDONT_PROBE_INTERFACES',true)dnl
define(`PROCMAIL_MAILER_PATH',`/usr/bin/procmail')dnl
dnl define delivery mode: interactive, background, or queued
dnl define(`confDELIVERY_MODE', `i')
MASQUERADE_AS(`ford.qa.laszlosystems.com')dnl
FEATURE(`limited_masquerade')dnl
FEATURE(`masquerade_envelope')dnl
FEATURE(`smrsh',`/usr/sbin/smrsh')dnl
FEATURE(mailertable)dnl
dnl virtusertable: redirect incoming mail to virtual domain to  
particular user or domain
FEATURE(`virtusertable',`hash -o /etc/mail/virtusertable')dnl
dnl genericstable: rewrite sender address for outgoing mail
FEATURE(genericstable)dnl
FEATURE(always_add_domain)dnl
FEATURE(redirect)dnl
FEATURE(use_cw_file)dnl
FEATURE(local_procmail)dnl
FEATURE(`access_db')dnl
FEATURE(`blacklist_recipients')dnl
FEATURE(`relay_based_on_MX')dnl
dnl FEATURE(dnsbl, `blackholes.mail-abuse.org', `Rejected - see   
http://www.mail-abuse.org/rbl/')dnl
dnl FEATURE(dnsbl, `dialups.mail-abuse.org', `Dialup - see http:// 
www.mail-abuse.org/dul/')dnl
dnl FEATURE(dnsbl, `relays.mail-abuse.org', `Open spam relay - see  
http://www.mail-abuse.org/rss/')dnl
FEATURE(`delay_checks')dnl
FEATURE(`stickyhost')dnl
dnl SASL Configuration
dnl extract from http://www.sendmail.org/~ca/email/auth.html
dnl
dnl Next two lines are for SMTP Authentication
TRUST_AUTH_MECH(`LOGIN PLAIN')dnl
define(`confAUTH_MECHANISMS', `LOGIN PLAIN')dnl
dnl
dnl Next line stops sendmail from allowing auth without encryption
define(`confAUTH_OPTIONS', `Apy')dnl
dnl
dnl STARTTLS configuration
dnl extract from http://www.sendmail.org/~ca/email/starttls.html
dnl
define(`CERT_DIR', `/etc/ssl/sendmail')dnl
define(`confCACERT_PATH', `CERT_DIR')dnl
define(`confCACERT', `CERT_DIR/CAcert.pem')dnl
define(`confSERVER_CERT', `CERT_DIR/MYcert.pem')dnl
define(`confSERVER_KEY', `CERT_DIR/MYkey.pem')dnl
define(`confCLIENT_CERT', `CERT_DIR/MYcert.pem')dnl
define(`confCLIENT_KEY', `CERT_DIR/MYkey.pem')dnl
dnl
dnl Uncomment next lines to hide identity of mail serve
define(`confPRIVACY_FLAGS',`goaway,restrictqrun,restrictmailq')dnl
dnl define(`confSMTP_LOGIN_MSG', `$j server ready at $b')dnl
MAILER(smtp)dnl
MAILER(procmail)dnl
MAILER(dovecot)dnl


ford dovecot #

Steffen Kaiser

2007-Aug-06 13:33 UTC

head link

[Dovecot] How do I configure sendmail to accept emails for dovecot when dovecot has sql auth/user db.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wed, 1 Aug 2007, Yossie Silverman wrote:
> Included below are my config files: sendmail.mc, dovecot.m4, dovecot.conf, 
> dovecot-sql.conf.  Whenever I try to send email into this system, it
rejects
> it with user does not exist, however, the user does exist as far as dovecot
> (imap) is concerned, it is in the database.
> passdb sql {
>   args = /etc/dovecot/dovecot-sql.conf
> }
SQL-based (aka virtual) users
> dnl SASL Configuration
> dnl extract from http://www.sendmail.org/~ca/email/auth.html
Read the page you've quoted:
"Installation
Cyrus SASL"

There is no mention of Dovecot SASL.

======
You need to re-design your virtual user setup, e.g. use LDAP in 
combination with PAM.

Or, perhaps, patch in SQL support: http://blue-labs.org/software/sm-pgsql/
There is/was http://sourceforge.net/projects/sendmail-sql/.

Or, perhaps, make a Dovecot-SASL-patch for sendmail.

I'm using real users, so I don't know the functionality of those
patches.
If you search the Internet for sendmail+dovecot+sasl you'll see either no 
replies or "use postfix". There is a SASL-Patch for postfix.

Bye,

- -- 
Steffen Kaiser
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iQEVAwUBRrcjJy9SORjhbDpvAQIDEAf/RLRXXeQkQ7DIfHxrPZfBIxfSyoPHAohj
hqjSHoMqV+R+/8ZTl2QMXHbUaVseQcSKEjxtGb8Wve/6lWBpRgZ/KbqqUPkAbd5+
xXqwH2d9XHhqfViYzMeTyyvhDmxFPcQHK6Ru36c8pUKGu+49ZJ35M9E8HLmaUuPc
dFc4TUGixiGLXBHmShexmERbJFpLmv9sDhVOvo62ghSdTRHTQ/luCaM6rZrgR08F
nt95sw7DXrr/XDRF5N3eO/+bZvHBwWLDQhi4/g5V7F5O2mPFTO83WWVOeWPathLZ
cvGNml3ClaqXPb2MadcdA/PDRjgF4kIFl5BMxSgOIIdCAla9+vQpOw==b8Hl
-----END PGP SIGNATURE-----

Possibly Parallel Threads

Search for more apparently analagous threads

dovecot - Aug 2007 - How do I configure sendmail to accept emails for dovecot when dovecot has sql auth/user db.

[Dovecot] How do I configure sendmail to accept emails for dovecot when dovecot has sql auth/user db.

[Dovecot] How do I configure sendmail to accept emails for dovecot when dovecot has sql auth/user db.

Possibly Parallel Threads