Solved

PostFix + MySQL, SMTP Auth Doesn't work??

Posted on 2004-08-10
5
517 Views
Last Modified: 2008-02-26
I have PostFix, Courier, Squirrel, MySQL installed, everything is running great except SMTP Authentication.  My webmail works, people can send email to me, i can send anywhere in the organization, and i can send from squirrel mail to any outside client.  However, using Outlook or any other 3rd party desktop mail client, i get SMTP Relay denied error messages and such when sending through the account, even if i have "My SMTP Server requires authentication" checked.  I'm using Gentoo with all the latest packages above.

Thanks,
Nick
0
Comment
Question by:NickUA
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 1

Author Comment

by:NickUA
ID: 11762983
So i guess my question is how do i get Postfix to use the mysql username/password table to authenticate so i can send email?

Thanks.
0
 
LVL 22

Expert Comment

by:pjedmond
ID: 11765586
I'm tempted to say that SMTP authentication is not the problem. The problem is that your configuration is setup to act as a relay for certain email addresses only. Probably the only addresses that it is accepting is from a domain such as test.com or if default is secure, then it will not relay anything until you configure the domains that the setup is supposed to support correctly.

Also, another possibility is that relaying is allowed from the localhost (as squirrelmail is working, and I suppose that it is running on the same server), therefore perhaps Postfix is only accepting emails from localhost and needs to be configured to accept from a few more ips?

Look at the mynetworks_style, and mynetworks entries in the /etc/postfix.conf file.

HTH:)
0
 
LVL 7

Accepted Solution

by:
troopern earned 500 total points
ID: 11766200
I use Cyrus-SASL2 for my server.
in postfix.cfg Add:

smtpd_sasl_auth_enable = yes
smtpd_sasl2_auth_enable = yes
smtpd_sasl_security_options = noanonymous
broken_sasl_auth_clients = yes
smtpd_sasl_local_domain =

my /etc/sasl/smtpd.conf:

#pwcheck_method: saslauthd
sasl_pwcheck_method: auxprop
sasl_auxprop_plugin: sql
sql_engine: mysql
mysql_user: username
mysql_passwd: pwd
mysql_hostnames: localhost
mysql_database: database
mysql_statement: SELECT clear FROM user WHERE email = '%u@%r'
mysql_verbose: yes



0
 
LVL 7

Expert Comment

by:troopern
ID: 11766207
More questions, or if my help is too strict.. just ask =)
0
 
LVL 12

Expert Comment

by:mburdick
ID: 11769013
You will need to add SASL2 to your configuration, and reconfigure Postfix to use it. Then, you will need to put your users in the MySQL database, and assign passwords. I have done this on a few different systems running on SuSE, but the premise is the same...

Did you biuld your own install of Postfix, or are you using a pre-compiled distribution?
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Linux Mailserver setup & redundancy 2 124
Upgraded from Debian 7 to 8.7 and got black screen 20 125
Can't connect to FTP 18 161
Nee dhelp identifying the OS and how to access 7 93
I am a long time windows user and for me it is normal to have spaces in directory and file names. Changing to Linux I found myself frustrated when I moved my windows data over to my new Linux computer. The problem occurs when at the command line.…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question