On Tue, Jan 12, 2010 at 10:24:13AM -0800, Danny Sauer 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? > > Thanks much. > --Danny
I, for one, would be very grateful for a solution to migrate user names. We're hoping to move from .htpasswd to LDAP-based auth. Problem is....different user names! So while changing the auth is trivial, there's a *ton* of data (in all sorts of tables, etc) that are username dependent. I'm not sure, in general, how to intelligently do this in a RDB where lots of plugins make their own tables, but any pointers towards this end would be appreciated. Jeff > -- > 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. > >
-- 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.
