ok thanks.
But what is the correct syntax for connect in db to set in sasl_password
?
how should i write it?
now i try to follow your suggest of the first mail...
-------- Messaggio originale --------
Oggetto: [pfx] Re: MySQL error from not all the receiver
Data: 2023-03-11 16:26
Mittente: Gerald Galster via Postfix-users <postfix-users@postfix.org>
Destinatario: Postfix users <postfix-users@postfix.org>
Rispondi a: Gerald Galster <list+post...@gcore.biz>
i think the problem is "sasl-password" authentication file.
No, your problem is related to mysql which is a database (daemon),
that is accessed via sockets, not a file.
[...]
query = SELECT password FROM mailbox WHERE username = '%s' AND active =
'1'
and then "postmap" command.
it's correct ?
No, "query = SELECT password ..." is a database / SQL query, that
has nothing to do with plain files.
Postfix talks to mysql directly, there is no postmap involved.
Postmap is used when converting plain files to e.g. indexed formats
like hash/btree/lmdb/cdb. Those can be seen as database files but
unlike mysql there is no server process running in the background.
Therefore they are accessed in a different way, not via sockets.
In my first mail I gave hints where to spot mysql problems.
Best regards,
Gerald
_______________________________________________
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
