Configuration:
Windows 2008 R2
IIS7
ActivePerl
SQL Server 2008 R2
Fresh install
Version 3.0.11
After a fresh install of OTRS I can't login using root@localhost root or root with password root.
I tried changing the password using otrs.setpassword script to password123
As a side note, the instance is servername\instance and there is db connectivity through data connections and checked with the dbcheck script.
I can see the user root in the otrs database
Here's a copy of the config.pm
And here's a copy of the otrs log:package Kernel::Config;
sub Load {
my $Self = shift;
# ---------------------------------------------------- #
# ---------------------------------------------------- #
# #
# Start of your own config options!!! #
# #
# ---------------------------------------------------- #
# ---------------------------------------------------- #
# ---------------------------------------------------- #
# database settings #
# ---------------------------------------------------- #
# DatabaseHost
# (The database host.)
$Self->{DatabaseHost} = 'localhost\instance';
# Database
# (The database name.)
$Self->{Database} = 'otrs';
# DatabaseUser
# (The database user.)
$Self->{DatabaseUser} = 'otrs';
# DatabasePw
# (The password of database user. You also can use bin/otrs.CryptPassword.pl
# for crypted passwords.)
$Self->{DatabasePw} = 'password';
# DatabaseDSN
# (The database DSN for MySQL ==> more: "man DBD::mysql")
# $Self->{DatabaseDSN} = "DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};";
# (The database DSN for PostgreSQL ==> more: "man DBD::Pg")
# if you want to use a local socket connection
# $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};";
# if you want to use a tcpip connection
# $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};host=$Self->{DatabaseHost};";
$Self->{'DatabaseDSN'} = "DBI:ODBC:driver={SQL Server};Server=$Self->{DatabaseHost},1433;database=$Self->{Database}";
$Self->{'Database::Type'} = 'mssql';
# ---------------------------------------------------- #
# fs root directory
# ---------------------------------------------------- #
$Self->{Home} = 'c:/otrs';
# ---------------------------------------------------- #
# insert your own config settings "here" #
# config settings taken from Kernel/Config/Defaults.pm #
# ---------------------------------------------------- #
# $Self->{SessionUseCookie} = 0;
# $Self->{CheckMXRecord} = 0;
$Self->{'LogModule'} = 'Kernel::System::Log::File';
$Self->{'LogModule::LogFile'} = "$Self->{Home}/var/log/otrs.log";
# ---------------------------------------------------- #
# ---------------------------------------------------- #
# data inserted by installer #
# ---------------------------------------------------- #
# $DIBI$
# ---------------------------------------------------- #
# ---------------------------------------------------- #
# #
# End of your own config options!!! #
# #
# ---------------------------------------------------- #
# ---------------------------------------------------- #
}
# ---------------------------------------------------- #
# needed system stuff (don't edit this) #
# ---------------------------------------------------- #
use strict;
use warnings;
use vars qw(@ISA $VERSION);
$VERSION = qw($Revision: 1.23 $)[1];
use Kernel::Config::Defaults;
push (@ISA, 'Kernel::Config::Defaults');
# -----------------------------------------------------#
1;
Edit: Just a quick note, the login times out really really quickly. It doesn't actually seem like it's hitting the db.[Wed Jan 18 10:20:20 2012][Notice][Kernel::System::User::GetUserData] Panic! No UserData for user: 'root@localhost'!!!
[Wed Jan 18 10:20:20 2012][Error][Kernel::System::User::SetPassword][630] No such User!
[Wed Jan 18 10:20:33 2012][Notice][Kernel::System::User::SetPassword] User: 'root' changed password successfully!
[Wed Jan 18 13:21:24 2012][Notice][Kernel::System::User::GetUserData] Panic! No UserData for user: 'root@localhost'!!!
[Wed Jan 18 13:21:24 2012][Error][Kernel::System::User::SetPassword][630] No such User!
[Wed Jan 18 13:21:33 2012][Notice][Kernel::System::User::SetPassword] User: 'root' changed password successfully!
Edit2: Changed the title so it's less misleading. The root login works and is present in the users table. But it only works from a script. I don't get any logon events in otrs.log when I try from the browser.