reports do not render any results after locale configuration and apache restart

[onurgu@…]

I made a modification to apache config file related to the trac virtual host which was setting the TracLocale option by:

PythonOption TracLocale "tr_TR.UTF-8"

Then I restarted apache by issuing:

# /etc/init.d/apache2 restart

Now the modification seems to be in effect but none of the reports work. i.e. ​https://mydomain/trac/projectname/report/1

But custom queries work but if they are in TracQuery syntax. i.e. query:?status=%21closed&order=priority&owner=username

I tried to create a new report with the exact SQL query of the "active tickets" report that comes with the installation.

When I change the log level to DEBUG and check the logs, I see

2008-10-01 10:36:17,017 Trac[perm] DEBUG: No policy allowed USERNAME performing TiCKET_VIEW on <Resource u'ticket:131'>

When I searched this trac for permissions I got ​http://trac.edgewall.org/ticket/7201

Is this bug related with this ticket?

And is there a workaround or solution?

I appreciate your help and be willing to support you by feeding you with logs or etc in the process

[onurgu@…]

UPDATE:

I have seen that I had skipped telling you that the complete log:

DEBUG: No policy allowed USERNAME performing TiCKET_VIEW on <Resource u'ticket:XX'>

Note that the permission name is somewhat weird. So I thought that it might be a problem with character set and trac might be flipping the characters up and down somewhere.

So I commented out the modification to apache2.conf and it came back to normal.

But now how could I reenable it without this problem?

I think it needs a patch.

[anonymous]

I added into the repository several bug alleviated practicum generalities.

[Remy Blank]

We need more information to find out what goes wrong:

• When you say that "none of the reports work", what is happening? Do you get a blank page? An error page? An empty result set?

• Are there any other relevant entries in your logs?

• Do you have any plugins installed? If yes, please try disabling them all, then re-add one at a time until the problem reappears. The last plugin added is probably the cause of the problem.

The string "TiCKET_VIEW" appears nowhere in the Trac sources, so I have no idea where this could come from.

[Christian Boos]

The string "TiCKET_VIEW" appears nowhere in the Trac sources, so I have no idea where this could come from.

This is most likely the same tr_TR locale bug as the one described in #6953, this time with upper():

>>> locale.setlocale(locale.LC_ALL, 'tr_TR')
'tr_TR'
>>> "ticket".upper()
'T\xddCKET'

However:

>>> u"ticket".upper()
u'TICKET'

So we might work around this specific problem this way:

trac/ticket/report.py

@@ -433 +433 @@
                 cell_groups.append(cell_group)
             resource = Resource(realm, row.get('id'))
             # FIXME: for now, we still need to hardcode the realm in the action
-            if resource.realm.upper()+'_VIEW' not in req.perm(resource):
+            if unicode(resource.realm).upper()+'_VIEW' not in req.perm(resource):
                 continue
             if email_cells:
                 for cell in email_cells:

But I'm sure there would be other issues left, so the best advice is still to not use the "tr_TR" locale.