Once logged in as admin user I can query the ldap tree without difficulty. But customer users cannot login???? What am I missing? User record not being created at first login? If so how do I correct this? -- Jefferson K Davis Technology and Information Systems Manager Standard School District 1200 North Chester Ave Bakersfield, CA 93308 661.392.2110 ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.
Hi, On 2.4.3 the very same problem, new users are not being added to the <otrsdb>.users Table. Setup (and LDAP Sync) has worked like a charm before upgrading! I am not yet sure where to start fixing this, actually i think its a "bug" in Kernel/System/User/Preferences/DB.pm caused by the "new" bind Notations when handling dbobject ORM. before upgrading Kernel/System/User/Preferences/DB.pm (around #80): # insert new data if (!$Self->{DBObject}->Do( SQL => "INSERT INTO $Self->{PreferencesTable} ($Self->{PreferencesTableUserID}, ". " $Self->{PreferencesTableKey}, $Self->{PreferencesTableValue}) " . " VALUES ($Param{UserID}, '$Param{Key}', '$Param{Value}')", )) { $Self->{LogObject}->Log( Priority => 'error', Message => "Can't insert new $Self->{PreferencesTable}!", ); return; } after upgrading Kernel/System/User/Preferences/DB.pm (around #80) # insert new data return $Self->{DBObject}->Do( SQL => "INSERT INTO $Self->{PreferencesTable} ($Self->{PreferencesTableUserID}, " . " $Self->{PreferencesTableKey}, $Self->{PreferencesTableValue}) " . " VALUES (?, ?, ?)", Bind => [ \$Param{UserID}, \$Param{Key}, \$Param{Value} ], ); is that the correct place to start, and if so, should we replace all "Bind"s throughout the system or is there a (perl)package missing ? cheers, ffe Jefferson Davis schrieb:
Once logged in as admin user I can query the ldap tree without difficulty.
But customer users cannot login????
What am I missing?
User record not being created at first login? If so how do I correct this?
Some more Details: Without having applied any Changes if you create to User via the Admin Interface it's been written correctly to the Database (<otrsdb>.users) and the new User is able to login. Where to apply the fix in order to get the usual behaviour - when i user try's to login there's been written a new entity to <otrsdb>.users automatically ? As mentioned earlier, no Changes have been made to UserSyncLDAPMap, the behaviour worked like a charm before upgrading. cheers, ffe Franz Esberger schrieb:
Hi,
On 2.4.3 the very same problem, new users are not being added to the <otrsdb>.users Table.
Setup (and LDAP Sync) has worked like a charm before upgrading!
I am not yet sure where to start fixing this, actually i think its a "bug" in Kernel/System/User/Preferences/DB.pm caused by the "new" bind Notations when handling dbobject ORM.
before upgrading Kernel/System/User/Preferences/DB.pm (around #80):
# insert new data if (!$Self->{DBObject}->Do( SQL => "INSERT INTO $Self->{PreferencesTable} ($Self->{PreferencesTableUserID}, ". " $Self->{PreferencesTableKey}, $Self->{PreferencesTableValue}) " . " VALUES ($Param{UserID}, '$Param{Key}', '$Param{Value}')", )) { $Self->{LogObject}->Log( Priority => 'error', Message => "Can't insert new $Self->{PreferencesTable}!", ); return; }
after upgrading Kernel/System/User/Preferences/DB.pm (around #80)
# insert new data return $Self->{DBObject}->Do( SQL => "INSERT INTO $Self->{PreferencesTable} ($Self->{PreferencesTableUserID}, " . " $Self->{PreferencesTableKey}, $Self->{PreferencesTableValue}) " . " VALUES (?, ?, ?)", Bind => [ \$Param{UserID}, \$Param{Key}, \$Param{Value} ], );
is that the correct place to start, and if so, should we replace all "Bind"s throughout the system or is there a (perl)package missing ?
cheers, ffe
Jefferson Davis schrieb:
Once logged in as admin user I can query the ldap tree without difficulty.
But customer users cannot login????
What am I missing?
User record not being created at first login? If so how do I correct this?
participants (2)
-
Franz Esberger -
Jefferson Davis