dovecot - Apr 2017 - Cutting down on sql connections

Hello,

I'm running dovecot 2.29 on a freebsd 10.3 system. I'm trying to cut
down queries to my database and tried to do a userdb static and
prefetch. I modified the password query to pull in userdb_quota and
got an error that that was not valid. Is this behavior normal?

Apr 13 17:22:15 hostname dovecot: master: Dovecot v2.2.29 (13ebc01)
starting up for imap, sieve
Apr 13 17:22:24 hostname dovecot: imap-login: Login:
user=<username at example.com>, method=PLAIN, rip=127.0.0.1,
lip=127.0.0.1, mpid=66452, secured, session=<TYjM6xJNnqp/AAAB>
Apr 13 17:22:24 hostname dovecot: imap(username at example.com): Logged
out in=102 out=3020
Apr 13 17:22:24 hostname dovecot: imap-login: Login:
user=<username at example.com>, method=PLAIN, rip=127.0.0.1,
lip=127.0.0.1, mpid=68924, secured, session=<4xDQ6xJNht1/AAAB>
Apr 13 17:22:24 hostname dovecot: imap(username

Thanks.
Dave.

On 04/13/2017 07:33 PM, David Mehler wrote:
> Hello,
>
> I'm running dovecot 2.29 on a freebsd 10.3 system. I'm trying to
cut
> down queries to my database and tried to do a userdb static and
> prefetch. I modified the password query to pull in userdb_quota and
> got an error that that was not valid. Is this behavior normal?
>
> Apr 13 17:22:15 hostname dovecot: master: Dovecot v2.2.29 (13ebc01)
> starting up for imap, sieve
> Apr 13 17:22:24 hostname dovecot: imap-login: Login:
> user=<username at example.com>, method=PLAIN, rip=127.0.0.1,
> lip=127.0.0.1, mpid=66452, secured, session=<TYjM6xJNnqp/AAAB>
> Apr 13 17:22:24 hostname dovecot: imap(username at example.com): Logged
> out in=102 out=3020
> Apr 13 17:22:24 hostname dovecot: imap-login: Login:
> user=<username at example.com>, method=PLAIN, rip=127.0.0.1,
> lip=127.0.0.1, mpid=68924, secured, session=<4xDQ6xJNht1/AAAB>
> Apr 13 17:22:24 hostname dovecot: imap(username
Change to use the mysql socket:

driver = mysql
connect = host=/var/lib/mysql/mysql.sock dbname=postfix user=postfix 
password=Postfix_Database_Password