Mailing List Archive: 0.9.8.4: Update error

Hi Andrew,

Running the update-davical-database script result in the errors
displayed below:

DBD::Pg::db do failed: ERROR: permission denied for relation principal
at ./update-davical-database line 400, <PERMS> line 34. DBD::Pg::db do
failed: ERROR: permission denied for relation sync_tokens
at ./update-davical-database line 400, <PERMS> line 36. DBD::Pg::db do
failed: ERROR: permission denied for relation sync_changes
at ./update-davical-database line 400, <PERMS> line 37. DBD::Pg::db do
failed: ERROR: permission denied for relation grants
at ./update-davical-database line 400, <PERMS> line 38. DBD::Pg::db do
failed: ERROR: permission denied for relation dav_principal
at ./update-davical-database line 400, <PERMS> line 39. DBD::Pg::db do
failed: ERROR: permission denied for sequence
sync_tokens_sync_token_seq at ./update-davical-database line 400,
<PERMS> line 48. Database permissions updated.

--
Hilsen/Regards
Michael Rasmussen

Get my public GnuPG keys:
michael <at> rasmussen <dot> cc
http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xD3C9A00E
mir <at> datanom <dot> net
http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xE501F51C
mir <at> miras <dot> org
http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xE3E80917
--------------------------------------------------------------
FORTUNE PROVIDES QUESTIONS FOR THE GREAT ANSWERS: #31
A: Chicken Teriyaki.
Q: What is the name of the world's oldest kamikaze pilot?
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: not available
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100309/68ff9282/attachment.pgp>
-------------- next part --------------

On Tue, 2010-03-09 at 02:28 +0100, Michael Rasmussen wrote:
> Hi Andrew,
>
> Running the update-davical-database script result in the errors
> displayed below:
>
> DBD::Pg::db do failed: ERROR: permission denied for relation principal
> at ./update-davical-database line 400, <PERMS> line 34. DBD::Pg::db do
> failed: ERROR: permission denied for relation sync_tokens
> at ./update-davical-database line 400, <PERMS> line 36. DBD::Pg::db do
> failed: ERROR: permission denied for relation sync_changes
> at ./update-davical-database line 400, <PERMS> line 37. DBD::Pg::db do
> failed: ERROR: permission denied for relation grants
> at ./update-davical-database line 400, <PERMS> line 38. DBD::Pg::db do
> failed: ERROR: permission denied for relation dav_principal
> at ./update-davical-database line 400, <PERMS> line 39. DBD::Pg::db do
> failed: ERROR: permission denied for sequence
> sync_tokens_sync_token_seq at ./update-davical-database line 400,
> <PERMS> line 48. Database permissions updated.

Hi Michael,

Typically this means that you are running update-davical-database with
the wrong database user set.

If you connect to your davical database and do a '\d' command to list
the tables, what user is the 'Owner'? Pass that username to
update-davical-database as an argument to the --dbuser option, or set it
in the configuration file and forget it for the future :-)

Cheers,
Andrew.

------------------------------------------------------------------------
http://andrew.mcmillan.net.nz/ Porirua, New Zealand
Twitter: _karora Phone: +64(272)DEBIAN
Be different: conform.
------------------------------------------------------------------------

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20100309/ac0c785a/attachment.pgp>
-------------- next part --------------