On Jan 13, 3:39 pm, Jeff Hammel <[email protected]> wrote: > 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
I've been curious for a while why Trac doesn't use an internal user ID. - jevans
-- 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.
