Hi!
I'm working on a configurable authentification for a customer user
database located on another server/database. It already seems to work,
but there's one little question:
In "Kernel/System/Auth/DB.pm" - "sub Auth" you can find the following
SQL statement:
my $SQL = "SELECT $Self->{UserTableUserPW}, $Self->{UserTableUserID} ".
" FROM ".
" $Self->{UserTable} ".
" WHERE ".
" valid_id in ( ${\(join ', ', $Self->{DBObject}->GetValidIDs())}
) ".
" AND ".
" $Self->{UserTableUser} = '$User'";
In "Kernel/System/CustomerAuth/DB.pm" - "sub Auth" you find the
counterpart with "hardcoded table & column names":
my $SQL = "SELECT pw, login ".
" FROM ".
" customer_user ".
" WHERE ".
" valid_id in ( ${\(join ', ', $Self->{DBObject}->GetValidIDs())}
) ".
" AND ".
" login = '$User'";
So, here is my question: why do you use "UserTableUserID" in the first
select statement and "login" in the other? I think the select statements
should be equal?
Regards,
Christian
_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
