On Sun, Jul 19, 2009 at 10:08:51AM +0100, Enrico Zini wrote:
> > - all_packages_distrelcomparch (which was a hack) was replaced by two
> > different tables (for Debian and Ubuntu) and a
> > all_packages_distrelcomparch view.
>
> It looks like some permission is missing:
>
> dde@merkel:/srv/dde.debian.net/home/dde$ ./testdde
> Exception caught loading plugin <module 'udd' from './plugins/udd.py'>: skipping plugin
> Exception details:
> Traceback (most recent call last):
> File "/org/dde.debian.net/home/dde/dde/__init__.py", line 40, in buildTree
> for pdata in p.init(conf = config, tree = forest):
> File "./plugins/udd.py", line 485, in init
> top.register(DistroTree("dist", db))
> File "./plugins/udd.py", line 66, in __init__
> c.execute("select distribution,release,component,architecture from all_packages_distrelcomparch")
> ProgrammingError: permission denied for relation all_packages_distrelcomparch
>
> I don't know much about postgresql permissions to go and fix it right
> away, but after breakfast I may go and have a stab at it with some help
> from #debian-qa.
I should have fixed it. For reference:
udd=> \z all_packages_distrelcomparch
Access privileges
Schema | Name | Type | Access privileges | Column access privileges
--------+------------------------------+------+-------------------+--------------------------
public | all_packages_distrelcomparch | view | |
(1 row)
udd=> grant select on all_packages_distrelcomparch to public;
GRANT
udd=> \z all_packages_distrelcomparch
Access privileges
Schema | Name | Type | Access privileges | Column access privileges
--------+------------------------------+------+-------------------+--------------------------
public | all_packages_distrelcomparch | view | udd=arwdDxt/udd |
: =r/udd
(1 row)
udd=> \z all_packages
Access privileges
Schema | Name | Type | Access privileges | Column access privileges
--------+--------------+------+-------------------+--------------------------
public | all_packages | view | udd=arwdDxt/udd |
: =r/udd
(1 row)
Now all_packages_distrelcomparch should have the same permissions as
all_packages and dde works again.
Ciao,
Enrico
--
GPG key: 4096R/E7AD5568 2009-05-08 Enrico Zini <enrico@enricozini.org>
Attachment:
signature.asc
Description: Digital signature