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 <[email protected]> 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 > <[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] _______________________________________________ dovecot mailing list -- [email protected] To unsubscribe send an email to [email protected]
