Hi Marcus

I have the same problem.

The user names appear in lots of tables in the database. These fields hold
the actual user name strings not just foreign keys into the
session_attribute table where user names and email addresses are stored. So
if you change a user name you have to find all the occurrences of the user
name in the database and change it there too.

I have written a piece of SQL to do this, and because I have quite a few
users to change, I wrote a python script to generate the SQL for all the
user names in a text file (with each line having the old user name and the
new user name for one user).

The other part of the problem I had was to change the user names in the
Apache digest file I use for authentication. I wrote another python script
to change these. This uses the same text file as input as the first python
script described above.

I can let you have copies of these if you like BUT all of these scripts are
untested as I haven't got to the point when I want to make the changes. So
you might prefer not to use the scripts or to wait until I have tested them,
probably in a week or two.

Cheers

Steve McCusker

PS I am using Trac 0.10.4
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.488 / Virus Database: 269.13.32/1033 - Release Date: 27/09/2007
11:06


--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to