On Fri, Apr 01, 2005 at 04:00:16AM -0500, M. J. [Mike] O'Brien wrote: > Ryan, you should dig out INSTALL.postfix file from the > tarball. ... > 4. Postfix can also interface directly with MySQL or > PostgreSQL to check ... > user = <username> > password = <password> > hosts = <dbhost> > dbname = <dbname> > table = dbmail_aliases > select_field = alias > where_field = alias .... > local_recipient_maps = mysql:/etc/postfix/sql-recipients.cf
does it work? especially if one using dbmail-lmtpd, as postfix smtpd would only use bare username (i.e doesn't use full email address as a lookup key). on the other hand, postfix lmtp client would send full email address of the recipient into dbmail-lmtp (i.e RCPT TO:<[EMAIL PROTECTED]>). for example: to accept adi at postpi.com, local_recipient_maps would lookup 'adi', but, lmtp client would send adi at postpi.com to lmtpd in RCPT TO. if one use full email address as alias (or userid), local_recipient_maps would fail (i.e mail get rejected as user unknown by postfix). if one store bare user part as alias (or userid), because postfix lmtp client send full email address on RCPT TO, the mail would get rejected by dbmail-lmtpd. A nice solution would be dbmail2 has an equivalent of postfix's mydestination (or tell postfix lmtp client to send bare username in RCPT TO). Regards, P.Y. Adi Prasaja
