out of curiosity, why do you want to use an SQL database? Do you have more than 1,000,000 email accounts?
I don't really see any benefit by using SQL for small to medium sized systems. On Mon, 13 Mar 2023 13:26:47 +0100 Antonino Di Mauro via Postfix-users <postfix-users@postfix.org> wrote: > 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 _______________________________________________ Postfix-users mailing list -- postfix-users@postfix.org To unsubscribe send an email to postfix-users-le...@postfix.org
