Re: [DAViCal-general] Merry Christmas and a Happy New DAViCal

[Andrew M. <an...@mo...>]

On Tue, 2009-12-29 at 11:08 +0100, Matthias Fechner wrote:
> Hi Andrew,
> 
> Am 24.12.2009 13:13, schrieb Andrew McMillan:
> > After somewhat longer than I'd hoped, I have packages of DAViCal 0.9.8
> > now available.
> 
> I installed the new version now on my FreeBSD machine, but if I execute 
> the update-davical-database I get the following message:
> 
> The database is version 8.1 currently at revision 1.2.4.
> Applying patch 1.2.5.sql ... succeeded.
> Applying patch 1.2.6.sql ... succeeded.
> Applying patch 1.2.7.sql ... succeeded.
> Successfully applied 3 patches.
> Supported locales updated.
> Updated view: dav_principal.sql applied.
> CalDAV functions updated.
> RRULE functions updated.
> DBD::Pg::db do failed: ERROR:  role "davical_app" does not exist at 
> ./update-davical-database line 400, <PERMS> line 20.

...

> ./update-davical-database line 400, <PERMS> line 56.
> Database permissions updated.
> 
> Is that a problem or can I ignore it?

It is likely to be a problem.  Did you originally create the database
with some very old version of DAViCal which used the 'general' database
user rather than the newer releases which use 'davical_app'?

There are some options you can use for update-davical-database which
will change that over, or you can use the --appuser and --owner options
to set appropriate names when you run the update script.

The --appuser parameter should be the name that the application uses to
connect to the database, and the --owner parameter should be the name
for the DBA user which will own the database structure and tables.

See the wiki page about update-davical-database for more information.

Cheers,
					Andrew.

------------------------------------------------------------------------
andrew (AT) morphoss (DOT) com                            +64(272)DEBIAN
    I have not seen high-discipline processes succeed in commercial
                     settings. - Alistair Cockburn

------------------------------------------------------------------------