Re: Userdb lookup problems

[Aki Tuomi via dovecot]

 
     On 15/02/2025 18:29 EET Ken Wright via dovecot <dovecot@dovecot.org>
     wrote:
      
      
     On Sat, 2025-02-15 at 17:53 +0200, Aki Tuomi wrote:
               On 15/02/2025 17:39 EET Ken Wright via dovecot
               <dovecot@dovecot.org> wrote:
                
                
               On Sat, 2025-02-15 at 08:59 +0200, Timo Sirainen
               wrote:
                    On 15. Feb 2025, at 0.06, Ken Wright
                    via dovecot
                    <dovecot@dovecot.org> wrote:
                     
                     
                    These need to be converted to the new
                    syntax.
                     
               Is this correct?
                
               passdb sql {
                 query = SELECT username AS username, domain,
               password FROM
               mailbox
               WHERE username = '%{user | username}' AND domain
               = '%{user |
               domain}'
               AND active= '1'
                 }
               userdb sql {
                 query = SELECT maildir, 2000 AS uid, 2000 AS
               gid FROM mailbox
               WHERE
               username = '%{user | username}' AND domain = '%
               {user | domain}' AND
               active= '1'
                 # For using doveadm -A:
                 iterate_query = SELECT username AS username,
               domain FROM mailbox
                
          Like mentioned already on some thread, returning maildir is
          not
          right, check
          https://doc.dovecot.org/2.4.0/core/config/mailbox/
          mail_location.html 
          and return mail_path instead.
     Okay, I changed maildir to mail_path, but I still can't log in.
      
     I'm sorry, but I think I need to see the fix spelled out. I'm an
     idiot.
      
     Ken
      
 
Did you check logs for details? If there is not much, try
 
log_debug=category=auth
mail_debug=yes
 
Aki
_______________________________________________
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org