Re: Convert sqlite configuration from 2.3 to 2.4

24 Jun 2026

      Thanks,
It works was my bad, didn’t see the file name selection, now all ok
Horst
...
On 23 Jun 2026, at 16:53, Aki Tuomi via dovecot <dovecot@dovecot.org> wrote:
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
&lt;[1]dovecot@dovecot.org> 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]dovecot@dovecot.org
To unsubscribe send an email to [3]dovecot-leave@dovecot.org
References
Visible links

mailto:dovecot@dovecot.org
mailto:dovecot@dovecot.org
mailto:dovecot-leave@dovecot.org

dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-leave@dovecot.org