Postfix - Relay - authentificatin in Mysql

PopFR1

5/19/24, 3:55 PM

I tryed to manage with a postfix server, my goal is that :

When 1 special user ([email protected]) try to send mail, it will use routing (using a relay server is OK) but I don't understand how to send authentification to the relay server to be authorized to send mail. I do that on my main.cf file :

relay_domains =
$mydestination
proxy:mysql:/etc/postfix/mysql/relay_domains.cf

relay_recipient_maps =
    mysql:/etc/postfix/mysql/relay_recipient_maps.cf

The first point is OK : I see that mail use relay specified into my mysql table to send mail The second point has an issue : I think user/passsword are not send to relay so my mail is refused on it. The file /etc/postfix/mysql/relay_recipient_maps.cf content is :

hosts       = 127.0.0.1:3306
user        = BDD_USER
password    = BDD_PASS
dbname      = BDD_DBNAME
query       = SELECT authentification FROM domain WHERE domain='%s' LIMIT 1

And in MySQL, "authentification" field contain user:password for relay authentification inplain text

Regards and have a good day !

1 + 0

smtp

postfix

relay

Score:0

Server

Hawshemi

5/20/24, 4:46 PM

To authenticate with the relay server in Postfix, you need to configure the smtp_sasl_auth_enable parameter in your main.cf file.

Open your main.cf configuration file for Postfix.
Add or modify the following parameters:

smtp_sasl_auth_enable = yes
smtp_sasl_password_maps = hash:/etc/postfix/sasl_passwd
smtp_sasl_security_options = noanonymous

Create a sasl_passwd file and specify the relay server's hostname or IP address, along with the authentication credentials:

relay.example.com    username:password

Generate the hash map file from the sasl_passwd file:

sudo postmap /etc/postfix/sasl_passwd

Set the correct permissions for the sasl_passwd.db file:

sudo chown root:root /etc/postfix/sasl_passwd.db
sudo chmod 0600 /etc/postfix/sasl_passwd.db

Restart the postfix:

sudo service postfix restart

By configuring the smtp_sasl_auth_enable parameter and providing the authentication details in the sasl_passwd file, Postfix will use those credentials to authenticate with the relay server when sending emails.

+ 3

PopFR1

5/21/24, 12:37 PM

Hi, thanks for your reply. I tryed to use Mysql for that so I need to use `smtp_sasl_password_maps = mysql:/etc/postfix/sasl_passwd` ? But when I do that, it seems that the auth data are not used anymore ?!

Hawshemi

5/23/24, 6:27 AM

@PopFR1 1. `sudo apt-get install postfix-mysql` 2. Create a file like /etc/postfix/mysql_relay_passwords.cf with MySQL connection and query details. 3. In `main.cf`, set `smtp_sasl_auth_enable = yes` and `smtp_sasl_password_maps = mysql:/etc/postfix/mysql_relay_passwords.cf`.

PopFR1

5/23/24, 8:03 AM

I already doing that but it seems that doesn't work - And if I trace Mysql traffic, idon't see the use of my query so probably mistake on my query - i will investigate

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: Postfix - Relay - authentificatin in Mysql

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.