Re: some UDD schema changes
On 19/07/09 at 10:17 +0100, Enrico Zini wrote:
> 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.
Right, added to setup.sql and upgrade.sql too.
--
| Lucas Nussbaum
| lucas@lucas-nussbaum.net http://www.lucas-nussbaum.net/ |
| jabber: lucas@nussbaum.fr GPG: 1024D/023B3F4F |
Reply to: