Re: Dbmail 3.2.0 error from automigrations

Am 28.08.2014 08:09, schrieb Thomas Raschbacher:
> Hi.
> 
> 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?
> 
> Regards,
>   Thomas R

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 ?

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.

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.)

Regards,
  Thomas R