Re: Dbmail 3.2.0 error from automigrations

Am 28.08.2014 um 08:31 schrieb Thomas Raschbacher:
> Am 28.08.2014 08:09, schrieb Thomas Raschbacher:
>> I was just going to add 3.2.0 to the gentoo portage tree, but when
>> testing i got this error in my syslog:
>>
>> dbmail/imap4d[15315]: Error:[db] check_upgrade_step(+920): SQLException:
>> FEHLER:  Relation »dbmail_upgrade_steps« existiert nicht
>> LINE 1: SELECT 1=1 FROM dbmail_upgrade_steps WHERE from_version = $1...
>>
>> Looks like the contents of
>> /usr/share/doc/dbmail-3.2.0/sql/postgresql/upgrades/32001.psql.bz2 did
>> not get applied to the db.
>>
>> I thought this was going to be applied automatically?
>>
> I think I just noticed what is the problem:
> By default in gentoo all text files in /usr/share/doc/<package-name> are
> ..bz2
> Could it be that dbmail loads the sql migration scripts from there and
> expects "${DOCDIR}/sql/postgresql/upgrades/" to contain the files
> 32001.psql ?

Uhm that could explain why it not worked as i pulled HEAD instead
of 3.1 snapshot some time ago

> If this is the case it is probably also of interest to other packagers
> to keep this definitely intact (and not skip the doc/ tree or something)
> 
> @Paul: I would appreciate if you could confirm this for me before I
> commit this to the official tree.

me too, after recovering from building up an inbound spamfilter
i will give 3.2 some love on my virtual testserver

> Also I wonder if it is a good idea to put sql scripts that the server
> processes need in /usr/share/doc . Wouldn't /usr/share/dbmail be the
> better choice here (also from a FHS point of view) since /usr/share/doc
> is intended for documentation -- manual sql migrations fit well in there
> of course imho. (Just a suggestion of course I will go by what you
> decide is best Paul.)

agreed!

especially on server setups it is not uncommon to have "tsflags=nodocs"
on readhat systems to prevent install docs and manpages on every server
in a cloud infrastructure and have them only on the admin server

_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iEYEARECAAYFAlP/F7UACgkQhmBjz394AnlCEgCeNmYXZYOqOGFwvU1RVsF9W7q9
bBwAnjIRILRTW/HR970NUGWhBjyAVMqV
=1aHq
-----END PGP SIGNATURE-----