Here is mine default_pass_scheme = MD5-CRYPT
# passdb query to retrieve the password. It can return fields: password_query = SELECT CONCAT( pw_name ,'@', pw_domain ) AS user, \ pw_passwd AS password, \ pw_dir as userdb_home, \ 89 AS userdb_uid, \ 89 AS userdb_gid \ FROM vpopmail vp \ LEFT JOIN aliasdomains ad ON ad.alias = '%d' \ WHERE ( vp.pw_domain = ad.domain OR vp.pw_domain = '%d') AND ( vp.pw_name = '%n' ) #password_query = SELECT CONCAT(pw_name, '@', '%d') AS user, \ # pw_passwd AS password, \ # pw_dir as userdb_home, \ # 89 AS userdb_uid, \ # 89 AS userdb_gid \ # FROM `vpopmail` \ # WHERE pw_name = '%n' AND pw_domain = '%d' # userdb query to retrieve the user information. It can return fields: # (Thanks to Arturo Blanco for his hints concerning vpopmail limits) user_query = \ SELECT pw_dir AS home, \ 89 AS uid, \ 89 AS gid \ FROM vpopmail \ WHERE pw_name = '%n' AND pw_domain = '%d' \ AND ('%a'!='995' or !(pw_gid & 2)) \ AND ('%r'!='[WEBMAIL-IP]' or !(pw_gid & 4)) \ AND ('%r'='[WEBMAIL-IP]' or '%a'!='993' or !(pw_gid & 8)) # [WEBMAIL-IP] is the IP of your webmail web server. # I'm assuming that the imap connection is only on port 993 and the pop3 connection is on port 955. # Adjust to your needs # # logically this means: # SELECT user # WHEN POP is not disabled for that user connecting on port 995 (995 is the pop3s port allowed from remote in my configuration) # AND WHEN webmail access is not disabled for that user when connecting from [WEBMAIL-IP] # AND WHEN IMAP is not disabled for that user connecting on port 993 (993 is the imaps port allowed from remote # in my configuration) unless his remote ip the one belonging to the webmail # Query to get a list of all usernames. iterate_query = SELECT CONCAT(pw_name,'@',pw_domain) AS username FROM `vpopmail` Here is my dovecot.conf part protocol imap { imap_client_workarounds = "delay-newmail" mail_plugins = $mail_plugins imap_quota mail_max_userip_connections = 150 } protocol pop3 { pop3_client_workarounds = outlook-no-nuls oe-ns-eoh pop3_fast_size_lookups = yes pop3_lock_session = yes mail_max_userip_connections = 50 # pop3_uidl_format = UID%u-%v } plugin { quota = maildir:ignore=Trash quota_rule = ?:storage=0 } passdb { driver = sql args = /etc/dovecot/dovecot-sql.conf.ext } userdb { driver = sql args = /etc/dovecot/dovecot-sql.conf.ext } service stats { # unix_listener stats-reader { # group = # mode = 0666 # user = # } unix_listener stats-writer { group = dovecot mode = 0666 #user = } } !include local.conf > On Jan 28, 2024, at 19:33, Peter Peterse <pe...@peterse-uithuizen.com> wrote: > > Hello, > > Remo, thanks fot the fast answer. I've changed the file > /etc/dovecot/dovecot.conf back to how it was after the script qt_install. > > Dovecot logs now: > > Jan 28 18:24:28 auth-worker(63869): Warning: sqlpool(mysql): Query failed, > retrying: Table 'vpopmail.vpopmail' doesn't exist > Jan 28 18:24:28 auth-worker(63869): Error: conn unix:auth-worker > (pid=63867,uid=97): auth-worker<1>: sql(pe...@example.com,::1 > <mailto:pe...@example.com,::1>,<cKTBowUQ0KYAAAAAAAAAAAAAAAAAAAAB>): Password > query failed: Table 'vpopmail.vpopmail' doesn't exist > > In the file dovecot-sql.conf.ext the credentials are correct and the database > vpopmail exists but there is no table vpopmail created, so probebly this is > the problem. Where is this table created? > > Regards, > > Peter Peterse > > On 28-1-2024 18:52, Remo Mattei wrote: >> >> It’s now sql not vpopmail >> >> -- >> Sent from iPhone >> >> On domenica, gen 28, 2024 at 18:41, Peter Peterse >> <pe...@peterse-uithuizen.com <mailto:pe...@peterse-uithuizen.com>> wrote: >> Hello list, >> >> I'm trying to migrate from CentOS 7 to AlmaLinux 9.3. I'm using the >> steps from: >> >> http://qtp.qmailtoaster.com/#rhel9 >> >> and >> >> http://www.qmailtoaster.com/migrate.html >> >> In this process I've changed the database passwords in the files: >> >> /home/vpopmail/etc/vpopmail.mysql >> /etc/roundcubemail/config.inc.php >> /etc/dovecot/dovecot-sql.conf.ext >> /etc/dspam.conf >> >> After starting the mailserver and logging in with roundcube the logs >> from dovecot says: >> >> Jan 28 17:29:53 master: Info: Dovecot v2.3.16 (7e2e900c1a) starting up >> for imap, pop3 (core dumps disabled) >> Jan 28 17:30:15 auth: Fatal: Unknown passdb driver 'vpopmail' >> Jan 28 17:30:15 master: Error: service(auth): command startup failed, >> throttling for 2.000 secs >> >> Does anyone knows what I've missed? >> >> Thanks for the help. >> >> Peter Peterse >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com >> <mailto:qmailtoaster-list-unsubscr...@qmailtoaster.com> >> For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com >> <mailto:qmailtoaster-list-h...@qmailtoaster.com> >>