View Single Post
  #10  
Old 13th November 2011, 19:43
dgonzalezh dgonzalezh is offline
Junior Member
 
Join Date: Oct 2011
Posts: 4
Thanks: 0
Thanked 3 Times in 1 Post
Default

Quote:
Originally Posted by CSsab View Post
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.

Code:
# 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.
Reply With Quote