user accounts not existing after backup/restore
Moderator: crythias
user accounts not existing after backup/restore
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
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
Re: user accounts not existing after backup/restore
also tried putting in new users into that table and they weren't recognized by otrs either
-
- 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
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
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
Re: user accounts not existing after backup/restore
thanks for the reply, but i can't find any log with the authentication
-
- 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
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.
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
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
Re: user accounts not existing after backup/restore
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")
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")
Re: user accounts not existing after backup/restore
otrs 2.24 and mysql 5.0
-
- 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
Basically, you're looking for:
$Self->{'AuthModule'} = 'Kernel::System::Auth::DB';
http://doc.otrs.org/2.4/en/html/x1872.h ... h-backends
$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
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
-
- 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
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
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
Re: user accounts not existing after backup/restore
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