Customer user Backend

Moderator: crythias

Post Reply
steeman
OTRS newbie
Posts: 45
Joined: 22 May 2013, 11:35
OTRS Version?: 3.3.2
Real Name: Philip Steeman
Company: VIVES

Customer user Backend

Post by steeman » 07 Jun 2018, 13:46

I tried to use a mysql backend for the Customer User Backend (OTRS 6.0.7).
It doens't work as it should do (LDAP is OK)

I get those errors:
Unknown column 'create_time' in 'field list', SQL: 'SELECT givenName, sn, sAMAccountName, mail, sAMAccountName, create_time, create_by, change_time, change_by, sAMAccountName FROM info WHERE LOWER(sAMAccountName) = LOWER(?) LIMIT 1'

and

Need User!

Can someone give me a hint?

My Config

$Self->{CustomerUser} = {
Name => 'Database Gegevens',
Module => 'Kernel::System::CustomerUser::DB',
Params => {
DSN => 'DBI:mysql:database=philip2;host=localhost',
User => 'root',
Password => 'xxxxxxx,
Table => 'info',
CaseSensitive => 0,
},
# customer uniq id
CustomerKey => 'sAMAccountName',
# customer #
CustomerID => 'sAMAccountName',
CustomerUserListFields => ['sAMAccountName', 'cn', 'sn', 'givenName', 'mail',],
CustomerUserSearchFields => ['cn', 'sn', 'givenName', 'mail', 'sAMAccountName'],
CustomerUserSearchPrefix => '',
CustomerUserSearchSuffix => '*',
CustomerUserSearchListLimit => 250,
CustomerUserPostMasterSearchFields => ['mail'],
CustomerUserNameFields => ['sn', 'givenName'],
# show now own tickets in customer panel, CompanyTickets
CustomerUserExcludePrimaryCustomerID => 0,
# admin can't change customer preferences
AdminSetPreferences => 0,
ReadOnly => 1,
Map => [
# note: Login, Email and CustomerID needed!
# var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link, readonly
[ 'UserFirstname', 'Firstname', 'givenName', 1, 1, 'var', '', 0 ],
[ 'UserLastname', 'Lastname', 'sn', 1, 1, 'var', '', 0 ],
[ 'UserLogin', 'Username', 'sAMAccountName', 1, 1, 'var', '', 0 ],
[ 'UserEmail', 'Email', 'mail', 1, 1, 'var', '', 0 ],
[ 'UserCustomerID', 'CustomerID', 'sAMAccountName', 0, 1, 'var', '', 0 ],
],
};

steeman
OTRS newbie
Posts: 45
Joined: 22 May 2013, 11:35
OTRS Version?: 3.3.2
Real Name: Philip Steeman
Company: VIVES

Re: Customer user Backend

Post by steeman » 07 Jun 2018, 14:28

Found it.

Added

ForeignDB => 1,

Post Reply