[Dovecot] mysql log entry
I'm sure this is a really newbie question, but I notice in /var/log/mail.log that there are between 3 and 15 of the following log entries every day for the last five days, which is far back as my logs go--what do they mean?
Apr xx hh:mm:ss mail dovecot[109]: auth-worker(default): mysql: Connected to localhost (postfix)
Is it dovecot connecting to mysql for password or user info? If so, wouldn't it be more frequent? I've got 20 users with some connecting from outside many times per day.
Thanks, -Terry
On Tue, 2010-04-13 at 16:24 -0700, Terry Barnum wrote:
I'm sure this is a really newbie question, but I notice in /var/log/mail.log that there are between 3 and 15 of the following log entries every day for the last five days, which is far back as my logs go--what do they mean?
Apr xx hh:mm:ss mail dovecot[109]: auth-worker(default): mysql: Connected to localhost (postfix)
Is it dovecot connecting to mysql for password or user info? If so, wouldn't it be more frequent? I've got 20 users with some connecting from outside many times per day.
Dovecot uses persistent connections to MySQL. Above probably means that a new auth-worker process was created and it connected to MySQL. Auth-worker processes also die away automatically after idling for a while. If your server had more traffic, the worker processes wouldn't die and so new worker processes wouldn't be created either, and you wouldn't get those messages.
On Apr 16, 2010, at 4:09 AM, Timo Sirainen wrote:
On Tue, 2010-04-13 at 16:24 -0700, Terry Barnum wrote:
I'm sure this is a really newbie question, but I notice in /var/log/mail.log that there are between 3 and 15 of the following log entries every day for the last five days, which is far back as my logs go--what do they mean?
Apr xx hh:mm:ss mail dovecot[109]: auth-worker(default): mysql: Connected to localhost (postfix)
Is it dovecot connecting to mysql for password or user info? If so, wouldn't it be more frequent? I've got 20 users with some connecting from outside many times per day.
Dovecot uses persistent connections to MySQL. Above probably means that a new auth-worker process was created and it connected to MySQL. Auth-worker processes also die away automatically after idling for a while. If your server had more traffic, the worker processes wouldn't die and so new worker processes wouldn't be created either, and you wouldn't get those messages.
Thank you very much Timo. It's what I hoped was going on but as a new dovecot user it's quite reassuring to hear it from the actual, real life auth(oritative)-worker!
-Terry
participants (2)
-
Terry Barnum
-
Timo Sirainen