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
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
