[Dovecot] mysql log entry

[Terry Barnum]

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