database-reports
database-reports copied to clipboard
Update reports using toolserver.namespace table for labs setup
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 ?