I do have a vpopmail you can import it from your old box but normally the script creates that for you. At least it does on rocky 9.
Remo -- Sent from iPhone > On domenica, gen 28, 2024 at 20:06, Peter Peterse > <pe...@peterse-uithuizen.com (mailto:pe...@peterse-uithuizen.com)> wrote: > > Hi Remo, > > > That part looks just like mine. It comes from: > https://raw.githubusercontent.com/qmtoaster/scripts/master/dovecot-sql.conf.ext > > > Do you have a table vpopmail? I don't and also don't understand where it > should be created. > > > Peter > > > > > > > On 28-1-2024 19:57, Remo Mattei wrote: > > 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> > > > (mailto: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) > > > > > > >
