Lost All users

Moderator: crythias

Post Reply
nobble
Znuny newbie
Posts: 4
Joined: 28 Sep 2010, 16:44
Znuny Version: 2

Lost All users

Post by nobble »

Our otrs that was previously connected to our Windows active directory, has now been migrated to a new domain.

This means that all users have been lost.

It has been reconnected to the new domain, but no user can now login.

I was wondering if there was a way to recreate the rootuser to be able to log in and at least recreate the old users and then reassign via some liberal use of sql the active tickets to these new userids.

the existing user table is blank.....


can anyone help?
otrs 2.4.5

MSSQL 2005, Windows Server 2003
crythias
Moderator
Posts: 10169
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Lost All users

Post by crythias »

Is there no way to talk to your original active directory (Because that's essentially what "held" your database/logins?)
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
crythias
Moderator
Posts: 10169
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Lost All users

Post by crythias »

I think the biggest question is regarding the email addresses of your users. Did you change the email address of your users?
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
nobble
Znuny newbie
Posts: 4
Joined: 28 Sep 2010, 16:44
Znuny Version: 2

Re: Lost All users

Post by nobble »

users emails haven't changed, just the AD
otrs 2.4.5

MSSQL 2005, Windows Server 2003
crythias
Moderator
Posts: 10169
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Lost All users

Post by crythias »

So ... can you talk to the new AD?
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
nobble
Znuny newbie
Posts: 4
Joined: 28 Sep 2010, 16:44
Znuny Version: 2

Re: Lost All users

Post by nobble »

yes, but in what way do you mean?
otrs 2.4.5

MSSQL 2005, Windows Server 2003
crythias
Moderator
Posts: 10169
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Lost All users

Post by crythias »

If OTRS can use, more or less, the same connection to the new AD, as long as the user map is the same, I don't know that this should be a problem, unless you're using different CustomerKey or something.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
nobble
Znuny newbie
Posts: 4
Joined: 28 Sep 2010, 16:44
Znuny Version: 2

Re: Lost All users

Post by nobble »

ok i'll have a look.. thanks for the pointers..
otrs 2.4.5

MSSQL 2005, Windows Server 2003
Post Reply