Ubuntu 7.04 + SASL Auth + MySQL

[nablaodel]

My problem is that I cannot authenticate through SASL against a MySQL database via Postfix to send mail SMTP(S). I have been trying to figure this out for over a week and have read many of the other posts without finding a solution. A couple days ago I started over with a fresh install.

I have installed Feisty Fawn server i386. I used Falko's "The Perfect Setup - Ubuntu Feisty Fawn" guide @ http://www.howtoforge.com/perfect_setup_ubuntu704 up until the point where the SSH server is installed.

Then I switched over to Falko's "Virtual Users And Domains With Postfix, Courier And MySQL (Ubuntu 6.10 Edgy Eft)" and I believed I followed everything in that guide to the 'T'. I have tested every part of the server and the only issue I have is that I cannot send mail (unless I use the command line).

The issue I have is most related to section http://www.howtoforge.com/virtual_postfix_mysql_quota_courier_ubuntu_edgy_p3

/etc/default/saslauthd, /etc/pam.d/smtp, /etc/postfix/sasl/smtpd.conf all seem to be correct (exact copies except my server info). I've tried numerous little changes and restarts/reloads. But nothing seems to work. Before I started changing things I made a backup of each file. I have reverted to those backups and done a system restart.

This is what /var/log/mail.log looks like after I try to send something via Thunderbird:
May 12 07:56:09 MY_SERVER postfix/master[5678]: reload configuration /etc/postfix
May 12 07:56:16 MY_SERVER postfix/smtpd[7776]: connect from REMOTE_COMPUTER_NAME[IPADDRESS]
May 12 07:56:19 MY_SERVER postfix/smtpd[7776]: warning: SASL authentication failure: cannot connect to saslauthd server: No such fi
le or directory
May 12 07:56:19 MY_SERVER postfix/smtpd[7776]: warning: SASL authentication failure: Password verification failed
May 12 07:56:19 MY_SERVER postfix/smtpd[7776]: warning: REMOTE_COMPUTER_NAME[IPADDRESS]: SASL PLAIN authentication f
ailed: generic failure
May 12 07:56:20 MY_SERVER postfix/smtpd[7776]: warning: SASL authentication failure: cannot connect to saslauthd server: No such fi
le or directory
May 12 07:56:20 MY_SERVER postfix/smtpd[7776]: warning: REMOTE_COMPUTER_NAME[IPADDRESS]: SASL LOGIN authentication f
ailed: generic failure
May 12 07:56:21 MY_SERVER postfix/smtpd[7776]: disconnect from REMOTE_COMPUTER_NAME[IPADDRESS]
I did look at the log after turning on verbose logging. Since that didn't seem to shed any light on my issue I won't bother posting that unless someone would like me to.

ps aux | grep saslauthd outputs:
root 7666 0.0 0.1 6464 748 ? Ss 07:05 0:00 /usr/sbin/saslauthd -a pam
root 7667 0.0 0.0 6464 480 ? S 07:05 0:00 /usr/sbin/saslauthd -a pam
root 7668 0.0 0.0 6464 464 ? S 07:05 0:00 /usr/sbin/saslauthd -a pam
root 7671 0.0 0.0 6464 464 ? S 07:05 0:00 /usr/sbin/saslauthd -a pam
root 7672 0.0 0.0 6464 464 ? S 07:05 0:00 /usr/sbin/saslauthd -a pam
ewg 7795 0.0 0.1 2880 748 pts/0 R+ 08:19 0:00 grep saslauthd

Since this has turned into a long post I will not display main.cf or master.cf unless someone thinks that would be helpful.

Let me know if you have any ideas. Thanks you very much!

[nablaodel]

WOW!!! I feel so stupid yet happy!

After posting howtoforge listed similar threads and I had not read this one:
http://www.howtoforge.com/forums/showthread.php?t=12608

In /etc/default/saslauthd, commenting out
PARAMS="-m /var/spool/postfix/var/run/saslauthd -r"
and adding
OPTIONS="-c -m /var/spool/postfix/var/run/saslauthd -r"

Solved everything!

[Aurora]

I had the same problem with saslauthd being unable to login for sending emails. I resolved it by editing the /etc/postfix/sasl/smtpd.conf file:

Change:
sql_select: select password from users where email = '%u'

To:
sql_select: SELECT password FROM users WHERE email = '%u'

Seems inconsequential, but it worked.