It seems i found the problem.

With Hash file it works fine!

With MySQL DB, I found out Postfix not read encrypt password.

Effectively in my db, password field is encrypted.


although I don't understand why it sends it to Gmail...


suggest ?

Thanks



Il 11/03/23 13:46, antonino.dimauro--- via Postfix-users ha scritto:
Hi to all,

this is my first Postfix configuration.
I create virtual users in a mariadb database.
I implemented TLS security.
Until now, i used an external smarthost to send mail to external destinations.
It's works fine!

Now i implemented DKIM with OpenDKIM, add DMARC record and improve SPF record, but (and here I don't understand why?) some times, for not all of address, my mail remaining in queue.

In the log when it happens, i can see this:

- postfix/smtp[313760]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2)

- postfix/smtp[313760]: warning: mysql:/etc/postfix/mysql_virtual_alias_maps.cf lookup error for "mail.any_external_domain.it"

- postfix/smtp[313760]: warning: 839744C0210: smtp_sasl_password_maps lookup error

smtp_sasl_password_maps is configured with a connection parameter to db connection and a simply select query.

I think, if i mistake some configuration, the mails never send, why some time yes and sometimes not ?


if i send an internal mail, it's always works fine !
if i send a mail in my private gmail, it's always works fine !
if i use external smarthost, this mail is always sent regularly.

what can i check?
is the problem the server configuration or the SPF record?


Very very thanks to all...

Regards.

Antonio
_______________________________________________
Postfix-users mailing list -- postfix-users@postfix.org
To unsubscribe send an email to postfix-users-le...@postfix.org


_______________________________________________
Postfix-users mailing list -- postfix-users@postfix.org
To unsubscribe send an email to postfix-users-le...@postfix.org

Reply via email to