Re[8]: Sieve Filters with MySQL

2024-07-23 Thread Adam Miller via dovecot
Oh hell, that is clearly obvious now that I look at it that way, thank you. It was very late for me last night when I got to this part in my task list so I probably should have stopped but instead of kept drudging forward. Haha - Thank you again for the help, I appreciate it. As for the databa

Key metrics to monitor for dovecot at CloudWatch

2024-07-23 Thread Sivakumar Vadivel via dovecot
Hello Team, Configured dovecot mail server and SES will receive and forward to SNS topic. Lambda subscribed to the topic and it will receive the mail and write to the EFS volume. EFS volume mounted on both dovecot and lambda. Also enabled AWS Cloudwatch to monitor overall infra. I'm going to enab

Re: Re[6]: Sieve Filters with MySQL

2024-07-23 Thread Aki Tuomi via dovecot
Hi! Usually how the "isActive" stuff is done is bit different. fwiw i would do the schema differently, and have two tables table 1: CREATE TABLE sieve_name_id ( id INT, email VARCHAR(255), name VARCHAR(255), PRIMARY KEY(email, name) ) table 2 CREATE TABLE sieve_scripts ( id INT

Re[6]: Sieve Filters with MySQL

2024-07-23 Thread Adam Miller via dovecot
Is it possible to include extra fields? For example, the “isActive” and make sure it is true / 1? Thank you. -- Original Message -- From "Aki Tuomi via dovecot" To "Adam Miller" ; "Adam Miller via dovecot" Date 7/23/2024 4:44:30 AM Subject Re: Re[4]: Sieve Filters with MySQL You

Re[7]: Sieve Filters with MySQL

2024-07-23 Thread Adam Miller via dovecot
Okay, I enabled RDS query logging and was able to find the queries and get the issue fixed. The query being executed for the first map is: SELECT FROM WHERE name = 'default' AND email = ‘redacted' I was expecting the “name” value to be “priv/sieve/name/default” not just “default”. It would b

Re[6]: Sieve Filters with MySQL

2024-07-23 Thread Adam Miller via dovecot
I have read all of this documentation already and others. I have also used Google, StackOverflow and ChatGPT to get assistance but nothing has helped. I provided my configuration here as well but unfortunately, I still have the same problem. # doveadm dict get -u redacted proxy::sieve priv/sie

Re: Dovecot Stats Plugin

2024-07-23 Thread Marcel Schmidt via dovecot
Hi, we found the failure, it works now, we disabled the stats_writer_socket (i dunno why exactly, hopefully some legacy s***) thanks for your help Kind regards Marcel On 23.07.24 16:11, Marcel Schmidt via dovecot wrote: Hi, still no luck all duration    0   0   0   0 

Re: Dovecot Stats Plugin

2024-07-23 Thread Marcel Schmidt via dovecot
Hi, still no luck all duration    0   0   0   0   0.00 0   0.00    0 seems it has something todo with our setup, i cant think of anything else i will test in another testing environment Kind regards Marcel On 23.07.24 15:59, Aki Tuomi via dovecot wrote: event_e

Re: Dovecot Stats Plugin

2024-07-23 Thread Aki Tuomi via dovecot
event_exporter log { format = json format_args = time-rfc3339 transport = log } metric all { filter=event=* exporter=log } > On 23/07/2024 16:56 EEST Marcel Schmidt via dovecot > wrote: > > > Hi Aki, > > still no output, i think i have to dig more. > Is there any possibility to se

Re: Dovecot Stats Plugin

2024-07-23 Thread Marcel Schmidt via dovecot
Hi Aki, still no output, i think i have to dig more. Is there any possibility to see, what events my dovecot server is "logging"? We have a construct like proxy -> director -> storagenode i guess not every server in that construct has the same events, so I could just be unlucky. Kind regards, M

Re: Dovecot Stats Plugin

2024-07-23 Thread Aki Tuomi via dovecot
> On 23/07/2024 16:34 EEST Marcel Schmidt via dovecot > wrote: > > > Hi, > > i have the exact same problem, i configured everything as said in the > documentation, but the output is always 0 > > metric client_connections { >filter = event=client_connection_finished > } > > metric auth

Dovecot Stats Plugin

2024-07-23 Thread Marcel Schmidt via dovecot
Hi, i have the exact same problem, i configured everything as said in the documentation, but the output is always 0 metric client_connections { filter = event=client_connection_finished } metric auth_success { filter = (event=auth_request_finished AND success=yes) } metric mail_delivery {

Dovecot proxy/director/replicator upgrade path

2024-07-23 Thread Andrea Gabellini via dovecot
Hello, I manage a Dovecot installation version 2.3.4.1 with a pair of proxy/director in front and two backends that use the replicator plugin to synchronize emails between them. I would like to update all 4 machines and would like to understand if I can directly jump to the latest version 2.

Re: Seeking Guidance on Dovecot Configuration, Security, and Performance Optimization

2024-07-23 Thread Aki Tuomi via dovecot
> On 23/07/2024 15:04 EEST Selena Thomas via dovecot > wrote: > > > Hi everyone, > > I am setting up Dovecot for the first time and could use some guidance. I > have a couple of questions::- > > -Configuration Basics: What are the essential configuration files I need to > focus on for a

Seeking Guidance on Dovecot Configuration, Security, and Performance Optimization

2024-07-23 Thread Selena Thomas via dovecot
Hi everyone, I am setting up Dovecot for the first time and could use some guidance. I have a couple of questions::- -Configuration Basics: What are the essential configuration files I need to focus on for a basic setup: ?? -Security Best Practices: What steps should I take to ensure my Dovecot

Seeking Guidance on Dovecot Configuration, Security, and Performance Optimization

2024-07-23 Thread Selena Thomas via dovecot
Hi everyone, I am setting up Dovecot for the first time and could use some guidance. I have a couple of questions::- -Configuration Basics: What are the essential configuration files I need to focus on for a basic setup: ?? -Security Best Practices: What steps should I take to ensure my Dovecot

Seeking Guidance on Dovecot Configuration, Security, and Performance Optimization

2024-07-23 Thread Selena Thomas via dovecot
Hi everyone, I am setting up Dovecot for the first time and could use some guidance. I have a couple of questions::- -Configuration Basics: What are the essential configuration files I need to focus on for a basic setup: ?? -Security Best Practices: What steps should I take to ensure my Dovecot

Re: Re[4]: Sieve Filters with MySQL

2024-07-23 Thread Aki Tuomi via dovecot
You can try doveadm dict get -u adam proxy::sieve priv/sieve/name/default this should return id of the default script. doveadm dict get -u adam proxy::sieve priv/sieve/data/ should return the actual script. See https://doc.dovecot.org/configuration_manual/sieve/dict/ Aki > On 23/07/2024 14:

Re[4]: Sieve Filters with MySQL

2024-07-23 Thread Adam Miller via dovecot
Yes, I get that. What I would like to know is what are the queries that Dovecot / Sieve is executing so that I can better determine where the issue exists? Is there anyway to see them? Do you see an issue anywhere in my configuration files? Thank you. -- Original Message -- From "Aki

Re: Re[2]: Sieve Filters with MySQL

2024-07-23 Thread Aki Tuomi via dovecot
Jul 23 10:34:40 lmtp(redacted)<228576>: Debug: sieve: dict storage: script `default': Script `default' not found at path priv/sieve/name/default Aki > On 23/07/2024 13:52 EEST Adam Miller via dovecot wrote: > > > Yes, that is where I got the error from. Here’s more from the log file: > > J

Re[2]: Sieve Filters with MySQL

2024-07-23 Thread Adam Miller via dovecot
Yes, that is where I got the error from. Here’s more from the log file: Jul 23 10:34:40 lmtp(redacted)<228576>: Debug: sieve: Pigeonhole version 0.5.16 (09c29328) initializing Jul 23 10:34:40 lmtp(redacted)<228576>: Debug: sieve: include: sieve_global is not set; it is currently not possible to

Re: Sieve Filters with MySQL

2024-07-23 Thread Aki Tuomi via dovecot
Did you try with mail_debug=yes and log_debug=category=sieve Aki > On 23/07/2024 13:18 EEST Adam Miller via dovecot wrote: > > > Me again! I am trying to get sieve filters working with a MySQL backend > but same to be coming up short. Right now, the error I am getting > received is: >

Sieve Filters with MySQL

2024-07-23 Thread Adam Miller via dovecot
Me again! I am trying to get sieve filters working with a MySQL backend but same to be coming up short. Right now, the error I am getting received is: -- "User has no active script i

Re: auth-worker doesn't systematically log the IP

2024-07-23 Thread Yassine Chaouche via dovecot
Le 7/22/24 à 18:53, Aki Tuomi via dovecot a écrit : You would probably want to use the new event based system for these logs: event_exporter log { format = json format_args = time-rfc3339 transport = log } metric auth_failed { event=filter=auth_request_finished and not success=yes

Re: sieve mail date change

2024-07-23 Thread John Fawcett via dovecot
On 22/07/2024 21:03, Marc via dovecot wrote: I am a bit rookie with sieve. Some time ago I created a sieve pipe that would sometimes alter alter the subject and move a message to a different mailbox. Currently this results in that a date changes of this message while I don't see anything in t