Convert sqlite configuration from 2.3 to 2.4

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