On 27/09/2016 11:07, Bene wrote:
On 27/09/2016 10:38, [email protected] wrote:
Hi Bene.
Am 27.09.2016 um 09:36 schrieb Bene<[email protected]>:
Previously when we worked with customers authenticating vs. the OTRS
DB, the customer user list contained
all the customers in the database. We changed Config.pm to allow the
customers to also authenticate
vs. the AD, and inserted a 2nd authentication method vs the OTRS DB.
However, the Customer User administration only shows those customers
from the AD, not the customer user
from the OTRS DB.
How can I included both in the list?
You missed some information in your mail:
* what is your OTRS version?
* please provide a (anonymized) extract from your config that contains
the configuration for both: DB and AD connection.
By default both should sources should be available via
AdminCustomerUser interface.
Best wishes,
Jan Dreyer
Hello Jan,
off course, I use OTRS 5.0.12.
I have succeeded in getting the OTRS database users listed in Customer
User Administration. However, I encounter 2 errors.
1. When I want to update the password from a database user, I get this
error in the system logs
ERROR: duplicate key value violates unique constraint
"customer_user_login"DETAIL: Key (login)=(general) already exists.,
SQL: 'UPDATE customer_user SET title = ?, first_name = ?, last_name = ?,
login = ?, email = ?, customer_id = ?, phone = ?,
fax = ?, mobile = ?, street = ?, zip = ?, city = ?, country = ?,
comments = ?, valid_id = ?,
change_time = '2016-09-27 10:44:00' , change_by = ? WHERE
LOWER(customer_id) = LOWER(?)'
The user does not exist in AD, only in the database. If I change the
password of another database user, it does work.
No idea why this fails. The error seems weird at first because I'm
trying to update an existing customer.
The error is syslog is "Need UserID!". Syslog says this:
OTRS-CGI-91[8810]:
[Error][Kernel::System::CustomerUser::SetPreferences][Line:560]: Need
UserID!
2. In the system log, I see this error when I go to the Customer User list:
[Error][Kernel::System::CustomerUser::LDAP::CustomerUserDataGet][Line:771]:
Bad filter
Could this be because the LDAP search is first, before the database
entries?
Excerpt of my Config.pm
...
<snip>
Hi,
I changed this line to get it working:
$Self->{'Customer::AuthModule1::DB::CryptType1'} = 'crypt';
To this:
$Self->{'Customer::AuthModule::DB::CryptType1'} = 'crypt';
And used 'login' instead of 'customer_id' as CustomerKey.
$Self->{CustomerUser} = {
...
# customer unique id
CustomerKey => 'login',
I need to test further but it seems to work, and no errors seem to appear.
Regards,
Bene
---
Dit e-mailbericht is gecontroleerd op virussen met Avast antivirussoftware.
https://www.avast.com/antivirus
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
