Unable to use $USER in default query in config for user names with non ascii letters

[jan.gorski@…]

If user name contains some UTF characters (e.g. UTFęąó) and default query uses $USER, error is displayed in default query for this user:

Oops...

Trac detected an internal error:

UnicodeEncodeError: 'ascii' codec can't encode characters in position 24-26: ordinal not in range(128)

Might be related to #6318, but after reading that ticket I am not sure.

[Christian Boos]

Well, #6318 shows that non-ascii characters for user names is not supported, so using them nevertheless exposes to lots of trouble, like risking to get non-UTF8 data in your database.

Which database backend are you using, btw?

[jan.gorski@…]

$ sqlite3 —version 3.5.9 $ file trac.db trac.db: SQLite 3.x database

It is quite intersting. It does not depend on DB. There is no ticket for this user in db, and if I enter query manually, then it works, e.g.

​http://wros124x/test/query?status=accepted&status=assigned&status=blocked&status=new&status=reopened&order=priority&col=id&col=summary&col=status&col=type&col=milestone&col=component&owner=UTF%C4%85%C4%99%C3%B3

Works correctly, and is direct equivalent of default query set in trac.ini:

default_query = status!=closed&owner=$USER

[jan.gorski@…]

PS. I am able to log in. Error shows up after loggin in.

[Christian Boos]

The problem described here must be derived from #6318 (i.e. the fact that non-ascii user names are not supported in the first place).

Regarding comment:3, the login might work by chance, if the authentication information happen to be stored with the same encoding as the encoded login name, but as soon as we try to make use of this name in the rest of Trac, we have encoding issues.