[horde] Changing UserNames

[Rob]

On 7/10/2006, "Rob" <horde.lists.horde.org at rosenfeld.to> wrote:

>Rearranged
>
>>>-----Original Message-----
>>>From: Rob [mailto:horde.lists.horde.org at rosenfeld.to]
>>>Sent: July 9, 2006 14:13
>>>To: horde at lists.horde.org
>>>Subject: [horde] Changing UserNames
>>>
>>>I'm migrating my hode installation to a new host.  My existing setup
>>>uses IMP IMAP for authentication.  Unfortunately, on the new host, some
>>>user IMAP logins must change.  I've noticed that throughout the horde
>>>databases, username is used as a key.  Is there a way I can accomplish
>>>this username change without losing all the data keyed by username?
>
>On 7/10/2006, "Marc-Antoine Zizka" <mazizka at wantedtech.com> wrote:
>
>>What backend do you use for preferences? In any case, you'll probably have
>>to do the work manually. If you use an SQL database, then that shouldn't be
>>too hard, assuming all the username changes are consistent. You should be
>>able to write an SQL script for it.
>>
>
>I do use a SQL backend and can see that I can run a bunch of UPDATE
>statements.  Is there a way to know what columns could possibly contain
>a username for changing?  Or do I just brute force browse through every
>column of every table and see what it seems to hold?


I'm not sure this approach is really a good idea.  Not only do usernames
appear as keys (e.g., horde_datatree_attributes.attribute_key), but also
in some free form fields where I don't know how important it is (e.g.,
horde_datatree_attributes.attribute_value).

Has anyone ever attempted this successfully?