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
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
