My installation of OTRS is not recognising users in my back end database. I haven't got a clue about how to go about debugging this any advice would be appreciated.
Kernel/Config.pm
Code: Select all
$Self->{CustomerUser} = {
Name => 'Database Backend',
Module => 'Kernel::System::CustomerUser::DB',
Params => {
DSN => 'DBI:mysql:database=drupal;host=localhost',
User => 'testuser',
Password => 'testpassword',
Table => 'users',
},
CustomerKey => 'name',
CustomerID => 'uid',
CustomerUserListFields => ['name', 'mail'],
CustomerUserSearchFields => ['name', 'mail'],
CustomerUserSearchPrefix => '',
CustomerUserSearchSuffix => '*',
CustomerUserSearchListLimit => 250,
CustomerUserPostMasterSearchFields => ['mail'],
CustomerUserNameFields => ['name','mail'],
CustomerUserEmailUniqCheck => 1,
Map => [
[ 'UserEmail', 'Email', 'mail', 0, 1, 'var', '', 0 ],
['UserCustomerID', 'CustomerID', 'uid', 0, 1, 'var', '', 0 ],
[ 'UserPassword', 'Password', 'pass', 0, 1, 'var', '', 0 ],
['UserLogin', 'Username', 'name', 1, 1, 'var', '', 0 ],
],
};
Code: Select all
+------------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+------------------+------+-----+---------+----------------+
| uid | int(10) unsigned | NO | PRI | NULL | auto_increment |
| name | varchar(60) | NO | UNI | | |
| pass | varchar(32) | NO | | | |
| mail | varchar(64) | YES | MUL | | |
| mode | tinyint(4) | NO | | 0 | |
| sort | tinyint(4) | YES | | 0 | |
| threshold | tinyint(4) | YES | | 0 | |
| theme | varchar(255) | NO | | | |
| signature | varchar(255) | NO | | | |
| signature_format | smallint(6) | NO | | 0 | |
| created | int(11) | NO | MUL | 0 | |
| access | int(11) | NO | MUL | 0 | |
| login | int(11) | NO | | 0 | |
| status | tinyint(4) | NO | | 0 | |
| timezone | varchar(8) | YES | | NULL | |
| language | varchar(12) | NO | | | |
| picture | varchar(255) | NO | | | |
| init | varchar(64) | YES | | | |
| data | longtext | YES | | NULL | |
+------------------+------------------+------+-----+---------+----------------+