[Dovecot] Dovecot error with MySQL

[Cesar]

Hi Jerry
can you or anybody help me please?

In addition to my previous post where I show the configurations (dovecot
postconf-n and-n) added more files that dovecot is using to contact the
MySQL server:

*dovecot.conf:*
protocols = imap pop3 lmtp
dict {
  quotadict = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext
}
!include conf.d/*.conf
!include_try /etc/dovecot/local.conf

*File /etc/docevot/conf.d/auth-sql.conf.ext:*
passdb {
  driver = sql
}
userdb {
  driver = prefetch
}
userdb {
  driver = sql
  args = /etc/dovecot/dovecot-sql.conf.ext
}

*dovecot-dict-sql.conf.ext:*
connect = host=localhost dbname=mail user=mail_admin
password=[mysql-passwd-Access]
map {
  pattern = priv/quota/storage
  table = quota2
  username_field = username
  value_field = bytes
}
map {
  pattern = priv/quota/messages
  table = quota2
  username_field = username
  value_field = messages
}
*dovecot-sql.conf.ext (number of lines is only for reference)*
(line 1:)driver = mysql
(line 2:)connect = host=localhost dbname=mail user=mail_admin
password=[mysql-passwd-Access]
(line 3:)default_pass_scheme = MD5
(line 4:)user_query = SELECT CONCAT('/var/mail/vhosts/', maildir) AS home,
5000 AS uid, 5000 AS gid, CONCAT('*:bytes=', quota) as quota_rule FROM
mailbox WHERE username = '%u' AND active='1'
(line 5:)password_query = SELECT username AS user, password,
CONCAT('/var/mail/vhosts/', maildir) AS userdb_home, 5000 AS userdb_uid,
5000 AS userdb_gid, CONCAT('*:bytes=', quota) as userdb_quota_rule FROM
mailbox WHERE username = '%u' AND active='1'

In the expectation of your reply I say goodbye.




-----
Best Regards
Cesar
--
View this message in context: http://dovecot.2317879.n4.nabble.com/Dovecot-error-with-MySQL-tp40765p40786.html
Sent from the Dovecot mailing list archive at Nabble.com.