Yes I found it.
https://raw.githubusercontent.com/qmtoaster/scripts/master/convpop
wget https://raw.githubusercontent.com/qmtoaster/scripts/master/convpop
chmod a+x convpop
./convpop
Now the table vpopmail will be created and after as start/stop of
qmailtoaster I can login into roundcube.
Thanks for your help.
Regards,
Peter Peterse
On 28-1-2024 20:06, Peter Peterse 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> 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,<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> 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
For additional commands, e-mail:
qmailtoaster-list-h...@qmailtoaster.com