Hi,
put this to converter and choose dovecot-sql.co f.ext
The result goes inside
passdb users {
}
(or whatever you call it)
Aki
On 23/06/2026 03:22 EEST Horst B Simon via dovecot
<[1][email protected]> wrote:
Hi,
I succesful converted all configurations from dovecot 2.3 to 2.4, except
for the sqlite configuration. I googled and all configuration are for
mysql/mariadb and not for sqlite. The sqlite database is created with
postfixadmin and my current configuration for dovecot 2.3
(dovecot-sql.conf.ext) is:
driver = sqlite
connect = /var/mail/postfixadmin.db
default_pass_scheme = DES-CRYPT
password_query = \
SELECT username as user, password, '/var/mail/%d/%n' as userdb_home, \
'maildir:/var/mail/%n' as userdb_mail, 5000 as userdb_uid, 5000 as
userdb_gid \
FROM mailbox WHERE username = '%u' AND active = '1'
user_query = \
SELECT '/var/mail/%d/%n' as home, 'maildir:/var/mail/%n' as mail, \
5000 AS uid, 5000 AS gid, printf('dirsize:storage=', quota) AS quota \
FROM mailbox WHERE username = '%u' AND active = '1'
I tried the only converter, but it didn't do any conversion. Any help
appreciated.
Thanks and Regards,
Horst
Hi,
I succesful converted all configurations from dovecot 2.3 to 2.4, except
for the sqlite configuration. I googled and all configuration are for
mysql/mariadb and not for sqlite. The sqlite database is created with
postfixadmin and my current configuration for dovecot 2.3
(dovecot-sql.conf.ext) is:
driver = sqlite
connect = /var/mail/postfixadmin.db
default_pass_scheme = DES-CRYPT
password_query = \
SELECT username as user, password, '/var/mail/%d/%n' as userdb_home, \
'maildir:/var/mail/%n' as userdb_mail, 5000 as userdb_uid, 5000 as
userdb_gid \
FROM mailbox WHERE username = '%u' AND active = '1'
user_query = \
SELECT '/var/mail/%d/%n' as home, 'maildir:/var/mail/%n' as mail, \
5000 AS uid, 5000 AS gid, printf('dirsize:storage=', quota) AS quota \
FROM mailbox WHERE username = '%u' AND active = '1'
I tried the only converter, but it didn't do any conversion. Any help
appreciated.
Thanks and Regards,
Horst
_______________________________________________
dovecot mailing list -- [2][email protected]
To unsubscribe send an email to [3][email protected]
References
Visible links
1. mailto:[email protected]
2. mailto:[email protected]
3. mailto:[email protected]
_______________________________________________
dovecot mailing list -- [email protected]
To unsubscribe send an email to [email protected]
