for only 200 users, you are adding a lot of complexity with an SQL database and
no real benefits.
my suggestion for small systems, is to use dovecot with the Maildir format, and
to separate domains/virtual hosts as separate system users, thus email accounts
are stored as (for example the
about 200 users...
Il 13/03/23 13:33, mailmary--- via Postfix-users ha scritto:
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
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
wrote:
> It seems i found the
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---
On 13/03/2023 12.05, Scott Kitterman via Postfix-users wrote:
On Sunday, March 12, 2023 7:02:41 PM EDT Gerald Galster via Postfix-users
wrote:
...
My recommendation to the OP would be to reconsider what they are trying to
accomplish and what's the simplest way to do so. Through this thread I
On Sunday, March 12, 2023 7:02:41 PM EDT Gerald Galster via Postfix-users
wrote:
> > unfortunately I don't know this topic, but I'm really willing to study.
> > Please do you have any documentation on this?
> Sorry, I can't recommend an up to date howto. Perhaps other list members can
> help.
>
> unfortunately I don't know this topic, but I'm really willing to study.
> Please do you have any documentation on this?
Sorry, I can't recommend an up to date howto. Perhaps other list members can
help.
A lot of links at https://www.postfix.org/docs.html are outdated or do not
exist
On 13/03/2023 02.10, Antonino Di Mauro via Postfix-users wrote:
unfortunately I don't know this topic, but I'm really willing to study.
Please do you have any documentation on this?
https://dev.mysql.com/doc/refman/8.0/en/
I'm no expert on Postfix, but can talk about databases. To help with
i try to remove "smtp_sasl_password_maps" to main.cf but external mail
not send !
In the log file, i can see "fatal error smtp_sasl_password_maps".
I honestly don't know how to fix it...
Il 2023-03-12 13:26 Gerald Galster via Postfix-users ha scritto:
I have checked the commands you listed
unfortunately I don't know this topic, but I'm really willing to study.
Please do you have any documentation on this?
Messaggio originale
Oggetto: [pfx] Re: MySQL error from not all the receiver
Data: 2023-03-12 13:26
Mittente: Gerald Galster via Postfix-users
Destinatario
> I have checked the commands you listed in your first email, but I do not find
> any errors in the database, table, or MySQL service. Perhaps, as you say,
> this is not the correct path for the configuration.
Currently you are connecting via unix domain sockets.
Mysql usually listens to
> smtp_sasl_password_maps is configured with a connection parameter to db
> connection and a simply select query.
> [...]
> if i use external smarthost, this mail is always sent regularly.
I am also not sure what you want to achieve:
> 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...
Try to solve your problem step by step.
Currently you are at "Can't connect to local MySQL server".
In case your
> 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.
>
>
Il 2023-03-11 14:23 postfix--- via Postfix-users ha scritto:
some times, for not all of address, my mail remaining in queue
what can i check?
is the problem the server configuration or the SPF record?
Can't connect to local MySQL server through socket
'/run/mysqld/mysqld.sock'
The
some times, for not all of address, my mail remaining in queue
what can i check?
is the problem the server configuration or the SPF record?
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock'
The problem isn't SPF. The problem is postfix can't open the database
> - postfix/smtp[313760]: warning: connect to mysql server localhost: Can't
> connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2)
Have a look at your mysql logs (/var/log/mysql*, journalctl,
/var/lib/mysql/*.err).
MySQL may not be running, there may be corrupt tables
17 matches
Mail list logo
