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: > > > > d...@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 | lu...@lucas-nussbaum.net http://www.lucas-nussbaum.net/ | | jabber: lu...@nussbaum.fr GPG: 1024D/023B3F4F | -- To UNSUBSCRIBE, email to debian-qa-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org