Tidy up the user-table!

RT Users
1

Hello!

we have a problem with the user table. Most of the users
have several entries in the db in the form

loginname1@host1.domain
loginname1@host2.domain
realname1@domain

only the third one is the correct one. Now i utilize a canoncial map
from postfix for the job but my question is how can
I clean up the db.
I can get all the Principals for the different user-entries, but where
should I update the references?

Tickets.Creator?
Tickets.Owner?
ACL?
Groups?
GroupMember?

And is there any way to delete users? I have several thousand spam
users in the table. A perl snippet to delete identified spam user and
the related information would be great.

regards

sven

2

Hello!

we have a problem with the user table. Most of the users
have several entries in the db in the form

loginname1@host1.domain
loginname1@host2.domain
realname1@domain

only the third one is the correct one. Now i utilize a canoncial map
from postfix for the job but my question is how can
I clean up the db.
I can get all the Principals for the different user-entries, but where
should I update the references?

Tickets.Creator?
Tickets.Owner?
ACL?
Groups?
GroupMember?

And is there any way to delete users? I have several thousand spam
users in the table. A perl snippet to delete identified spam user and
the related information would be great.
I write RTx-Shredder for this(distribution is on the CPAN). I’ve got
some reports about problems when delete users. I’ll fix them in 0.03
and this release would be suitable for your needs.

If you have RT play ground you can try 0.02_02 dev release and see if
it meets your requirments.

regards

sven

The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com

Best regards, Ruslan.

3

Hi!

we have a problem with the user table. Most of the users
have several entries in the db in the form

loginname1@host1.domain
loginname1@host2.domain
realname1@domain

only the third one is the correct one. Now i utilize a canoncial map
from postfix for the job but my question is how can
I clean up the db.
I can get all the Principals for the different user-entries, but where
should I update the references?

Tickets.Creator?
Tickets.Owner?
ACL?
Groups?
GroupMember?
Can anybody confirm this?

And is there any way to delete users? I have several thousand spam
users in the table. A perl snippet to delete identified spam user and
the related information would be great.
I write RTx-Shredder for this(distribution is on the CPAN). I’ve got
some reports about problems when delete users. I’ll fix them in 0.03
and this release would be suitable for your needs.

If you have RT play ground you can try 0.02_02 dev release and see if
it meets your requirments.
the problem is that I still use 3.0 and in the docu you wrote that
the version is only for 3.4. Indeed we want to update soon, but
my idea was to first clean the database a little bit, which seems
to be not as easy as I thought.

So in the end I’m missing an rt_db_repair_tool
to get all the tables right :frowning:

regards