Reports can't list mails due to limitation in Trac permission system

[anonymous]

We can create TracReports like this:

SELECT id, subject, fromheader, toheader, date
FROM mailarchive

But the rows link to tickets.

Trac documentation suggests using 'mailarchive' as _realm to fix this:

SELECT id, subject, fromheader, toheader, date,
       'mailarchive' as _realm
FROM mailarchive

But this does not work because there is a ​hardcoded check in Trac that's wrong for this plugin. It guesses that when realm is mailarchive, the appropriate permission is probably MAILARCHIVE_VIEW. But it is actually​ MAIL_ARCHIVE_VIEW.

[anonymous]

Problem also ​reported to Trac.