Originally Posted by CSsab
Hi .. I have mine working with a different dovecot.conf and sql but yours looks better researched so I'd like to try it.
What is your "/etc/dovecot/dovecot-sql.conf.ext" please.
Thanks in advance.
Well, dovecot-sql.conf, is basicallly the same as with 1.2, I just added it and it worked like a charm, check it out.
# If you wish to avoid two SQL lookups (passdb + userdb), you can use
# userdb prefetch instead of userdb sql in dovecot.conf. In that case you'll
# also have to return userdb fields in password_query prefixed with "userdb_"
# string. For example:
#password_query = SELECT userid as user, password, home as userdb_home, uid as userdb_uid, gid as userdb_gid FROM users WHERE userid = '%u'
driver = mysql
connect = host=db.dghvoip.com dbname=dbispconfig user=ispconfig password=xxxxxxxxxxxxxxxx
default_pass_scheme = CRYPT
password_query = SELECT password FROM mail_user WHERE login = '%u' AND disable%Ls = 'n'
# user_query = SELECT email AS user, maildir AS home, CONCAT('*:storage=', quota , 'B') AS quota_rule FROM mail_user WHERE login = '%u' AND disable%Ls = 'n'
user_query = SELECT email as user, maildir as home, CONCAT('maildir:', maildir, '/Maildir') as mail, uid, gid, CONCAT('*:storage=', quota, 'B') AS quota_rule, CONCAT(maildir, '/.sieve') as sieve FROM mail_user WHERE email = '%u' AND disable%Ls = 'n'
It's the same as the one Dovecot creates; though I haven't been able to diagnose a problem in which postfix or dovecot reports that it can't find auth, though for school stuff I can't dig much into it now but I'' keep y'all posted.
Thanks for your reply.