database-reports icon indicating copy to clipboard operation
database-reports copied to clipboard

Update reports using toolserver.namespace table for labs setup

Open legoktm opened this issue 11 years ago • 0 comments

Labs has the same table, but named toolserverdb_p.namespace.

Except when I tried using it in reports/general/blankpages.py, I got:

$ ~/bin/dbreps -r general.blankpages -s commonswiki
Traceback (most recent call last):
  File "/data/project/dbreps/bin/dbreps", line 80, in <module>
    for row in r.get_table_rows(conn):
  File "/data/project/dbreps/.local/lib/python2.7/site-packages/reports/general/blankpages.py", line 51, in get_table_rows
    ''', (self.site, ))
  File "cursor.pyx", line 120, in oursql.Cursor.execute (oursqlx/oursql.c:16822)
  File "cursor.pyx", line 111, in oursql.Cursor.execute (oursqlx/oursql.c:16693)
  File "statement.pyx", line 157, in oursql._Statement.prepare (oursqlx/oursql.c:8458)
  File "statement.pyx", line 127, in oursql._Statement._raise_error (oursqlx/oursql.c:8082)
oursql.PermissionsError: (1142, "SELECT command denied to user 'p50380g50440'@'10.68.16.7' for table 'namespace'", None)

Any ideas @scfc ?

legoktm avatar Oct 04 '14 09:10 legoktm