-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512
On 2015-11-02 03:45, martin f krafft wrote:
> Package: vmm
> Version: 0.6.2-1
> Severity: normal
> Tags: upstream
>
> THe example create-tables.pgsql script creates the service_set table
> with column 'managesieve', but the code assumes it's called 'sieve':
>
> root@ambassador:/etc/postgresql/9.4/main# vmm da pantsfullofunix.net
> Traceback (most recent call last):
> File "/usr/sbin/vmm", line 18, in <module>
> sys.exit(run(sys.argv))
> File "/usr/lib/python2.7/dist-packages/VirtualMailManager/cli/main.p
y", line 58, in run
> cmd_func(run_ctx)
> File "/usr/lib/python2.7/dist-packages/VirtualMailManager/cli/subcom
mands.py", line 254, in domain_add
> ctx.hdlr.domain_add(ctx.args[2].lower())
> File "/usr/lib/python2.7/dist-packages/VirtualMailManager/handler.py
", line 450, in domain_add
> smtp=self._cfg.dget('domain.smtp')))
> File "/usr/lib/python2.7/dist-packages/VirtualMailManager/serviceset
.py", line 81, in __init__
> self._load_by_services()
> File "/usr/lib/python2.7/dist-packages/VirtualMailManager/serviceset
.py", line 114, in _load_by_services
> dbc.execute(sql)
> psycopg2.ProgrammingError: column "sieve" does not exist
> LINE 1: ...ELECT ssid FROM service_set WHERE pop3 = TRUE AND sieve = T
R...
> ...
Hi Martin,
I guess you have a recent version of Dovecot (>= v2.0.0 or at least
>=v1.2.beta2). So you have to use the file
`create_tables-dovecot-1.2.x.pgsql' in order to create the tables.
,--[ INSTALL (77-80) ]--
| # either import the database structure for Dovecot v1.0.x/v1.1.x
| \i vmm-y.x.z/pgsql/create_tables.pgsql
| # or import the database structure for Dovecot v1.2.x/v2.x
| \i vmm-x.y.z/pgsql/create_tables-dovecot-1.2.x.pgsql
`--
You can use the `pgsql/dovecot_update_v1.2+.pgsql' file, in order to
upgrade the database layout for Dovecot v1.2.y/v2.x.y
The reason for the error above is the version check in
,--[ VirtualMailManager/serviceset.py (63-66) ]--
| if cfg_dget('misc.dovecot_version') < 0x10200b02:
| self._sieve_col = 'managesieve'
| else:
| self._sieve_col = 'sieve'
`--
Regards,
Pascal
- --
Ubuntu is an ancient African word meaning “I can’t install Debian.”
-- unknown
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2
iQGcBAEBCgAGBQJWN8esAAoJEIgLCU7FETn+W6oL/iVvmywOBwjU0oDPbAbWds+e
V0wtdVHXR4Zpvzke3qyZm6DW+Uxw/ZLPaoFcWspFQce7dshaYbM2M/kMWbA0e1N4
J25E6YpL0/zv8K1xSSCZ7Q0VnO/sO5/zQmhplJWS5QlxpadHZdArfe1lT2rwBtDI
4K3D/vwvCPvtVfKRnmhge+zphb9y3gnENnSgo8v0LvNgp/JnlsVBO1bs476qwt76
j+2aBK1qA07ZFYRDbp/FEOOWMQKlyzrP07vb11nri6hAv0gISMd9Cy8ne4h+/4DC
roiiaTs2Akx6T2tken7WUGb+z8J64C21rA1ZJB3BOvmDMEDKwbLCs29DsDn/xFHu
dWblLxzI2MwLwBxAc4PyjPP9vAo9igzd4xQqAjrwfNe2aBfOQej9rWWHdIKI99iL
QiVuAvBxMVpHURPYB5k2SXSJbSKTCbXz4gFB8EL65zY71ZVe4Mk7wzdiG1C+RlxM
v/Zj3ZJeno/aw8R2KgbaXVdUDs13LZIMuLoPRmKg3A==
=0AF9
-----END PGP SIGNATURE-----
