"UserTableUserID" same as "login" in authentification modules?

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

On Tuesday, October 21, 2003 4:42 PM
Christian Junk
In "Kernel/System/Auth/DB.pm" - "sub Auth" you can find the following SQL statement:
In "Kernel/System/CustomerAuth/DB.pm" - "sub Auth" you find the counterpart with "hardcoded table & column names":
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?
They shouldn't, as the latter refers to the Customer Backend only, whereas the former is applicable when authenticating users (agents). hth, Robert Kehl

Robert Kehl wrote:
On Tuesday, October 21, 2003 4:42 PM Christian Junk
wrote: In "Kernel/System/Auth/DB.pm" - "sub Auth" you can find the following SQL statement:
In "Kernel/System/CustomerAuth/DB.pm" - "sub Auth" you find the counterpart with "hardcoded table & column names":
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?
They shouldn't, as the latter refers to the Customer Backend only, whereas the former is applicable when authenticating users (agents).
hth,
Robert Kehl
Hi, Robert! Thank you for your quick answer. I hope I don't tax anyone's patience with all my questions ;) Regards Christian

On Wednesday, October 22, 2003 9:03 AM
Christian Junk
Hi, Robert!
Thank you for your quick answer. I hope I don't tax anyone's patience with all my questions ;)
No, absolutely not - you're welcome! That's what our lists are for: asking questions and expecting answers. Feel yourself comfortable, have a seat, a drink, a thought and then: Ask. Something. Something useful in the best case. :-)
Regards Christian
Robert
participants (2)
-
Christian Junk
-
Robert Kehl