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.... Sent from the Dovecot mailing list archive at Nabble.com.