Re: Convert sqlite configuration from 2.3 to 2.4

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]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

1. mailto:dovecot@dovecot.org
2. mailto:dovecot@dovecot.org
3. mailto:dovecot-leave@dovecot.org