Re: Trouble with MYSQL/SMTP-AUTH

I have installed Courier into the system and I have pop3/imap working
correctly with a maildir format. My issue only seems to be outgoing
authentication. What I see when I tail my mysql.log is :

Connect postfixuser@localhost on postfixdb
Init DB postfixdb
Query SELECT password FROM mailbox WHERE email='username'
Quit

However, my mail client is setup with the entire username@domain.com.
My /etc/postfix/sasl/smtpd.conf file looks like this :

pwcheck_method: saslauthd
mech_list: PLAIN LOGIN

and my main.cf is setup like this:
append_dot_mydomain = no
biff = no
myorigin = /etc/mailname
relayhost =
mynetworks = 127.0.0.0/8 10.1.100.173
mailbox_command =
mailbox_size_limit = 0
recipient_delimiter = +
virtual_alias_maps = mysql:/etc/postfix/mysql-virtual-alias-maps.cf
virtual_alias_domains =
virtual_gid_maps = static:999
virtual_mailbox_base = /var/spool/mail/virtual
virtual_mailbox_domains =
mysql:/etc/postfix/mysql-virtual-domains-maps.cf
virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual-mailbox-maps.cf
virtual_mailbox_limit = 51200000
virtual_minimum_uid = 999
virtual_transport = virtual
virtual_uid_maps = static:999

smtpd_sasl_auth_enable = yes
smtpd_sasl_local_domain = $myhostname
broken_sasl_auth_clients = yes
smtpd_recipient_restrictions = permit_sasl_authenticated
permit_mynetworks check_relay_domains

Please let me know if you see something obviously wrong with this.

Thanks,
Aric

On Wed, 2004-07-07 at 07:52, cron@odi.com.br wrote:
> I had the same problem whem using imap and pop that comes with Fedora Cora 1
> and Red Hat 9, so i instaled Corier IMAP and had no more problens.
>
>
> ----- Original Message -----
> From: "Aric Morgan" <amorgan@texasbytes.net>
> To: <postfix-users@postfix.org>
> Sent: Tuesday, July 06, 2004 6:04 PM
> Subject: Trouble with MYSQL/SMTP-AUTH
>
>
> > I have just finished installing Debian's Postfix 2.1.3-1 and I have
> > setup sasl authentication to work through a MySQL back end. When
> > authenticating with just a username through the /etc/shadow file
> > everything works just fine. I then tried authenticating from a full
> > email address through the MySQL table and got constant failures. When I
> > tailed my mysql log file I see that the MUA is passing only the username
> > and not username@domain.com. I tried from 4 different MUA's to get this
> > to work. I am curious if anyone has experienced the same issue and what
> > you were able to resolve with it.
> >
> > Thanks,
> > Aric
> >
> >
>