dovecot MasterUser

Discussion in 'Installation/Configuration' started by quickfox, Oct 25, 2012.

  1. quickfox

    quickfox New Member

    Hi guys,

    Trying to follow this: http://wiki.dovecot.org/Authentication/MasterUsers

    To let me set up a master user so that I can migrate all mail away from ISPConfig for one domain.

    I made a new boolean field on the mail_user table called "master_user". I set this to '1' for all desired users.

    Here is a snippet from my dovecot.conf & then the 2 sql queries I am using.

    Code:
    auth_master_user_separator=*                                                                                                                                                    
    auth default {                                                                                                                                                                  
      mechanisms = plain login                                                                                                                                                      
                                                                                                                                                                                    
      # SQL database <doc/wiki/AuthDatabase.SQL.txt>                                                                                                                                
      passdb sql {                                                                                                                                                                  
        # Path for SQL configuration file                                                                                                                                           
        args = /etc/dovecot/dovecot-sql-master.conf                                                                                                                                 
            master = yes                                                                                                                                                            
            pass = yes                                                                                                                                                              
      }                                                                                                                                                                             
                                                                                                                                                                                    
      passdb sql {                                                                                                                                                                  
        args = /etc/dovecot/dovecot-sql.conf                                                                                                                                        
      }
    userdb prefetch {                                                                                                                                                             
      }                                                                                                                                                                             
                                                                                                                                                                                    
      userdb sql {                                                                                                                                                                  
        args = /etc/dovecot/dovecot-sql.conf                                                                                                                                        
      }
    Here is my dovecot-sql-master.conf (without the mysql detail)

    Code:
    default_pass_scheme = CRYPT                                                                                                                                                     
    password_query = SELECT login as user, 'masterPassword' as password FROM mail_user WHERE login = '%u' AND master_user = true
    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'
    
    Here is my dovecot-sql.conf

    Code:
    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('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'
    
    I still can't auth via telnet when I try the following:

    1 login [email protected]*[email protected] masterPassword

    Can anyone tell me what I am doing incorrectly?
     
  2. quickfox

    quickfox New Member

    After posting this, I see one problem - which is ofc my sql-master password query is returning, user & password.

    I've updated this....testing.
     
  3. quickfox

    quickfox New Member

  4. till

    till Super Moderator Staff Member ISPConfig Developer

    ISPConfig uses standard maildir format like most other Linux mail servers, so you can just copy over the maildirs to your new server without the need of a master user.
     
  5. quickfox

    quickfox New Member

    Hi till,

    Sorry - been away for a few days. Thanks for the reply!

    We are moving to a non maildir setup though - so it would be great to use imapsync.

    Can you offer any tips here?

    Thx,

    quick
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    Have you considered to set the same password for all users of that domain temporarily in the ispconfig mysql database for the migration?
     

Share This Page