
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