I have successfully installed ODBC, connected to the customer backend database on a SQL server also on EC2, and can see, search for, and enter tickets for customers via the agent panels. Zoming in on a customer does not display the password; instead we get an empty input field.
What I cannot do is log in using Customer.pl -- every enter with known good passwords comes back with an invalid User ID or Password.
I have done a SQL Server Profiler, and have verified that OTRS asks for the customer row and gets one back from the database. I have verified that the Config.pm entries for Customer password point to the correct column. I am missing something simple and I cannot see it. I am hopeful that someone on this board will respond.
Here is the Config.pm Excerpt:
Code: Select all
$Self->{CustomerUser} = {
Name => 'PFCustomer Datasource',
Module => 'Kernel::System::CustomerUser::DB',
Params => {
# if you want to use an external database, add the required settings
DSN => 'DBI:ODBC:mssqlcustomer',
User => '[redacted]',
Password => '[redacted]',
Table => 'V_MYMBFS_PERSON',
CaseSensitive => 1,
},
# customer unique id
CustomerKey => 'sPemail',
CustomerPw => 'sPPassword',
# customer #
CustomerID => 'sPEmail',
CustomerValid => 'valid_id',
CustomerUserListFields => [ 'sPFirstName', 'sPLastName', 'sPEmail' ],
CustomerUserSearchFields => [ 'sPemail', 'sPLastName', 'sPFirstName' ],
CustomerUserSearchPrefix => '',
CustomerUserSearchSuffix => '%',
CustomerUserSearchListLimit => 250,
CustomerUserPostMasterSearchFields => [ 'sPemail' ],
CustomerUserNameFields => [ 'sPFirstName', 'sPLastName' ],
CustomerUserEmailUniqCheck => 1,
# just a read only source
ReadOnly => 1,
Map => [
# note: Login, Email and CustomerID needed!
# var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link, readonly, http-link-target
[ 'UserFirstname', 'Firstname', 'SPFirstName', 1, 1, 'var', '', 0 ],
[ 'UserLastname', 'Lastname', 'sPLastName', 1, 1, 'var', '', 0 ],
[ 'UserLogin', 'Username', 'sPEmail', 1, 1, 'var', '', 0 ],
[ 'UserPassword', 'Password', 'sPPassword', 1, 1, 'var', '', 0 ],
[ 'UserEmail', 'Email', 'sPEmail', 1, 1, 'var', '', 0 ],
[ 'UserCustomerID', 'MyMBFS Key', 'iPID', 1, 1, 'var', '', 0 ],
[ 'UserPhone', 'Phone', 'sPPhone1', 1, 0, 'var', '', 0 ],
[ 'UserFax', 'Fax', 'sPPhone2', 1, 0, 'var', '', 0 ],
[ 'UserStreet', 'Street', 'sPAddr1', 1, 0, 'var', '', 0 ],
[ 'UserZip', 'Zip', 'sPZipPostal', 1, 0, 'var', '', 0 ],
[ 'UserCity', 'City', 'sPCity', 1, 0, 'var', '', 0 ],
[ 'UserCountry', 'Country', 'sPCountry', 1, 0, 'var', '', 0 ],
[ 'UserComment', 'Comment', 'sPReferrer', 1, 0, 'var', '', 0 ],
[ 'ValidID', 'Valid', 'valid_id', 0, 1, 'int', '', 0 ],
],
};
Does anyone know the answer?
Thanks
John.