Convert sqlite configuration from 2.3 to 2.4

--===============1088628198786833109==
Content-Type: multipart/alternative;
	boundary="Apple-Mail=_9D1FA485-1A73-4217-8FAF-56503AD71F31"


--Apple-Mail=_9D1FA485-1A73-4217-8FAF-56503AD71F31
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8

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 =3D sqlite
connect =3D /var/mail/postfixadmin.db
default_pass_scheme =3D DES-CRYPT

password_query =3D \
  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 =3D '%u' AND active =3D '1'
user_query =3D \
  SELECT '/var/mail/%d/%n' as home, 'maildir:/var/mail/%n' as mail, \
  5000 AS uid, 5000 AS gid, printf('dirsize:storage=3D', quota) AS quota =
\
  FROM mailbox WHERE username =3D '%u' AND active =3D '1'

I tried the only converter, but it didn=E2=80=99t do any conversion. Any =
help appreciated.

Thanks and Regards,
Horst


--Apple-Mail=_9D1FA485-1A73-4217-8FAF-56503AD71F31
Content-Transfer-Encoding: base64
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"

ICAgSGksCiAgIEkgc3VjY2VzZnVsIGNvbnZlcnRlZCBhbGwgY29uZmlndXJhdGlvbnMgZnJvbSBk
b3ZlY290IDIuMyB0byAyLjQsIGV4Y2VwdAogICBmb3IgdGhlIHNxbGl0ZSBjb25maWd1cmF0aW9u
LiBJIGdvb2dsZWQgYW5kIGFsbCBjb25maWd1cmF0aW9uIGFyZSBmb3IKICAgbXlzcWwvbWFyaWFk
YiBhbmQgbm90IGZvciBzcWxpdGUuIFRoZSBzcWxpdGUgZGF0YWJhc2UgaXMgY3JlYXRlZCB3aXRo
CiAgIHBvc3RmaXhhZG1pbiBhbmQgbXkgY3VycmVudCBjb25maWd1cmF0aW9uIGZvciBkb3ZlY290
IDIuMwogICAoZG92ZWNvdC1zcWwuY29uZi5leHQpIGlzOgoKICAgZHJpdmVyID0gc3FsaXRlCgog
ICBjb25uZWN0ID0gL3Zhci9tYWlsL3Bvc3RmaXhhZG1pbi5kYgoKICAgZGVmYXVsdF9wYXNzX3Nj
aGVtZSA9IERFUy1DUllQVAoKICAgcGFzc3dvcmRfcXVlcnkgPSBcCgogICAgIFNFTEVDVCB1c2Vy
bmFtZSBhcyB1c2VyLCBwYXNzd29yZCwgJy92YXIvbWFpbC8lZC8lbicgYXMgdXNlcmRiX2hvbWUs
IFwKCiAgICAgJ21haWxkaXI6L3Zhci9tYWlsLyVuJyBhcyB1c2VyZGJfbWFpbCwgNTAwMCBhcyB1
c2VyZGJfdWlkLCA1MDAwIGFzCiAgIHVzZXJkYl9naWQgXAoKICAgICBGUk9NIG1haWxib3ggV0hF
UkUgdXNlcm5hbWUgPSAnJXUnIEFORCBhY3RpdmUgPSAnMScKCiAgIHVzZXJfcXVlcnkgPSBcCgog
ICAgIFNFTEVDVCAnL3Zhci9tYWlsLyVkLyVuJyBhcyBob21lLCAnbWFpbGRpcjovdmFyL21haWwv
JW4nIGFzIG1haWwsIFwKCiAgICAgNTAwMCBBUyB1aWQsIDUwMDAgQVMgZ2lkLCBwcmludGYoJ2Rp
cnNpemU6c3RvcmFnZT0nLCBxdW90YSkgQVMgcXVvdGEgXAoKICAgICBGUk9NIG1haWxib3ggV0hF
UkUgdXNlcm5hbWUgPSAnJXUnIEFORCBhY3RpdmUgPSAnMScKCiAgIEkgdHJpZWQgdGhlIG9ubHkg
Y29udmVydGVyLCBidXQgaXQgZGlkbid0IGRvIGFueSBjb252ZXJzaW9uLiBBbnkgaGVscAogICBh
cHByZWNpYXRlZC4KICAgVGhhbmtzIGFuZCBSZWdhcmRzLAogICBIb3JzdAo=

--Apple-Mail=_9D1FA485-1A73-4217-8FAF-56503AD71F31--

--===============1088628198786833109==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
dovecot mailing list -- [email protected]
To unsubscribe send an email to [email protected]

--===============1088628198786833109==--