On Tue, Jan 12, 2010 at 1:24 PM, Danny Sauer <[email protected]> wrote: > I had an authentication system "issue" which resulted in some users > logging in and creating tickets, etc with capital letters. As a > result, I need to run through the database and change all the > usernames to lowercase so things will be related properly. I don't > know SQLite very well, though I'm familiar with SQL in general so this > seems doable. But I looked at the database schema, and the username's > all over the place. :) So: > > 1) In the short term, does someone already have a query written up > that I can execute which will fix this problem? If someone already > has something that works, it'd save me a minor hassle. > > 2) For a long-term solution: can I set something at the database level > or with a plugin that will force usernames to be stored only as > lowercase? >
In `trac.ini` [trac] ignore_auth_case : Whether login names should be converted to lower case (since 0.9). -- Regards, Olemis. Blog ES: http://simelo-es.blogspot.com/ Blog EN: http://simelo-en.blogspot.com/ Featured article: hgtv design star application Direct Download :. FileChaos.com .: - http://feedproxy.google.com/~r/TracGViz-full/~3/o-eDMK37aWg/hgtv-design-star-application.html
-- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
