user accounts not existing after backup/restore

Moderator: crythias

Locked
jeff00z28
Znuny newbie
Posts: 11
Joined: 12 Aug 2010, 22:38
Znuny Version: 2.2

user accounts not existing after backup/restore

Post by jeff00z28 »

Need to transfer from one pc to another.

I tried the backup and restore scripts, and also tried just mysql dump and restore commands. I know the database is copied because i checked in phpmyadmin. I know some of the configurations restored, because some custom text and whatnot i added to the webpage transfered. I cannot log into otrs after transfering to another computer. I try putting in under lost your password to see what it would do and it says the user does not exist. In the system users table of the database, i see all of the users in there with their passwords which are encrypted. I really need this to work and have spend hours on it. I tried blanking out the passwords in phpmyadmin in that table and also putting in new ones in plain text but it didn't work. I made sure it was teh same versions of mysql which is 5.0. Really lost I dunno whether it is a mysql issue or otrs issue, but in the past a dump and restore transfers passwords. Thanks
jeff00z28
Znuny newbie
Posts: 11
Joined: 12 Aug 2010, 22:38
Znuny Version: 2.2

Re: user accounts not existing after backup/restore

Post by jeff00z28 »

also tried putting in new users into that table and they weren't recognized by otrs either
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: user accounts not existing after backup/restore

Post by crythias »

I'd like to suggest checking the otrs log and double-verifying that the auth method for agent(?) Login isn't a different server or unreachable.
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
jeff00z28
Znuny newbie
Posts: 11
Joined: 12 Aug 2010, 22:38
Znuny Version: 2.2

Re: user accounts not existing after backup/restore

Post by jeff00z28 »

thanks for the reply, but i can't find any log with the authentication
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: user accounts not existing after backup/restore

Post by crythias »

Please provide more information regarding your Authentication part of Config.pm. Make sure that it's valid and pointing to the proper server.

Please also provide more information about version and Operating System.
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
jeff00z28
Znuny newbie
Posts: 11
Joined: 12 Aug 2010, 22:38
Znuny Version: 2.2

Re: user accounts not existing after backup/restore

Post by jeff00z28 »

it came off of an ubuntu 8.04 machine and is going onto an ubuntu 9.04 machine
its the same on both computers. thanks

# DatabaseHost
# (The database host.)
$Self->{DatabaseHost} = $dbserver || 'localhost';
# Database
# (The database name.)
$Self->{Database} = $dbname || 'otrs';
# DatabaseUser
# (The database user.)
$Self->{DatabaseUser} = $dbuser || 'otrs';
# DatabasePw
# (The password of database user. You also can use bin/CryptPassword.pl
# for crypted passwords.)
$Self->{DatabasePw} = $dbpass;
# DatabaseDSN
# (The database DSN for MySQL ==> more: "man DBD::mysql")
jeff00z28
Znuny newbie
Posts: 11
Joined: 12 Aug 2010, 22:38
Znuny Version: 2.2

Re: user accounts not existing after backup/restore

Post by jeff00z28 »

otrs 2.24 and mysql 5.0
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: user accounts not existing after backup/restore

Post by crythias »

Basically, you're looking for:
$Self->{'AuthModule'} = 'Kernel::System::Auth::DB';

http://doc.otrs.org/2.4/en/html/x1872.h ... h-backends
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: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: user accounts not existing after backup/restore

Post by crythias »

you didn't change versions of otrs on dump and restore did you?
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
jeff00z28
Znuny newbie
Posts: 11
Joined: 12 Aug 2010, 22:38
Znuny Version: 2.2

Re: user accounts not existing after backup/restore

Post by jeff00z28 »

the old version is 2.2.4, i just checked and ubuntu now has 2.3.2. So they did change versions. I don't see that auth line in the file on either version
Locked