I successfully insalled otrs 2.4.7.
Now I'm trying to configure a customer data backend using ms sql.
I'm able to lookup all my customers using the menu point customers.
But the customers arent able to login and i'm not able to choose a customer for a new ticket.
After the popup windows closed the page starts loading and ends up after 3 min and an internal server error.
The log is conatining the following lines:
Code: Select all
[Sun Aug 22 15:19:40 2010][Debug][Kernel::System::CustomerUser::DB::CustomerUserDataGet][449] DB.pm->Prepare (2/1282483180) SQL: 'SELECT name1, name2, kdnr1, solpasswort, email, kdnr1, telefon, telefax, strasse, plz, ort, land, kdnr1, kdnr1 FROM kunde WHERE LOWER(kdnr1) = LOWER('14061')'
[Sun Aug 22 15:19:40 2010][Debug][Kernel::System::CustomerUser::Preferences::DB::GetPreferences][81] DB.pm->Prepare (3/1282483180) SQL: 'SELECT preferences_key, preferences_value FROM customer_preferences WHERE user_id = ?'
[Sun Aug 22 15:19:40 2010][Debug][Kernel::System::CustomerUser::DB::CustomerUserDataGet][449] DB.pm->Prepare (3/1282483180) SQL: 'SELECT name1, name2, kdnr1, solpasswort, email, kdnr1, telefon, telefax, strasse, plz, ort, land, kdnr1, kdnr1 FROM kunde WHERE LOWER(kdnr1) = LOWER('22064')'
[Sun Aug 22 15:19:40 2010][Debug][Kernel::System::CustomerUser::Preferences::DB::GetPreferences][81] DB.pm->Prepare (4/1282483180) SQL: 'SELECT preferences_key, preferences_value FROM customer_preferences WHERE user_id = ?'
[Sun Aug 22 15:19:40 2010][Debug][Kernel::System::CustomerUser::DB::CustomerUserDataGet][449] DB.pm->Prepare (4/1282483180) SQL: 'SELECT name1, name2, kdnr1, solpasswort, email, kdnr1, telefon, telefax, strasse, plz, ort, land, kdnr1, kdnr1 FROM kunde WHERE LOWER(kdnr1) = LOWER('28055')'
[Sun Aug 22 15:19:40 2010][Debug][Kernel::System::CustomerUser::Preferences::DB::GetPreferences][81] DB.pm->Prepare (5/1282483180) SQL: 'SELECT preferences_key, preferences_value FROM customer_preferences WHERE user_id = ?'
Now thats my config. Maybe i missed some thing:
Code: Select all
#Kundendatenbank-Anbindung Servatum
$Self->{'Customer::AuthModule'} = 'Kernel::System::CustomerAuth::DB';
$Self->{'Customer::AuthModule::DB::Type'} = 'mssql';
$Self->{'Customer::AuthModule::DB::DSN'} = "DBI:ODBC:driver={SQL Server};Server=10.X.X.X,1433;database=servatum;uid=sa;pwd=password;";
$Self->{'Customer::AuthModule::DB::Table'} = 'kunde';
$Self->{'Customer::AuthModule::DB::CustomerKey'} = 'kdnr1';
$Self->{'Customer::AuthModule::DB::CustomerPassword'} = 'solpasswort';
$Self->{'Customer::AuthModule::DB::CryptType'} = 'plain';
# CustomerUser
# (customer user database backend and settings)
$Self->{CustomerUser} = {
Name => 'Servatum',
Module => 'Kernel::System::CustomerUser::DB',
Params => {
# if you want to use an external database, add the
# required settings
DSN => 'DBI:ODBC:driver={SQL Server};Server=10.X.X.X,1433;database=servatum;uid=sa;pwd=password;',
Type => 'mssql',
Table => 'kunde',
SourceCharset => 'iso-8859-1',
DestCharset => 'utf-8',
},
# customer uniq id
CustomerKey => 'kdnr1',
# customer #
CustomerID => 'kdnr1',
CustomerUserListFields => ['name1', 'name2', 'telefon'],
CustomerUserSearchFields => ['kdnr1', 'name1', 'name2', 'telefon','email'],
CustomerUserSearchPrefix => '',
CustomerUserSearchSuffix => '*',
CustomerUserSearchListLimit =>50,
CustomerUserPostMasterSearchFields => ['email'],
CustomerUserNameFields => ['andrede','name1','name2'],
CustomerUserEmailUniqCheck => 0,
# # show not own tickets in customer panel, CompanyTickets
# CustomerUserExcludePrimaryCustomerID => 0,
# # generate auto logins
AutoLoginCreation => 1,
# AutoLoginCreationPrefix => 'auto',
# # admin can change customer preferences
AdminSetPreferences => 1,
# # cache time to life in sec. - cache any database queris
CacheTTL => 0,
# # 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', 'name1', 1, 1, 'var', '', 0 ],
[ 'UserLastname', 'Lastname', 'name2', 1, 1, 'var', '', 0 ],
[ 'UserLogin', 'Username', 'kdnr1', 1, 1, 'var', '', 0 ],
[ 'UserPassword', 'Password', 'solpasswort', 1, 0, 'var', '', 0 ],
[ 'UserEmail', 'Email', 'email', 2, 0, 'var', '',0],
# [ 'UserEmail', 'Email', 'email', 1, 1, 'var', '$Env{"CGIHandle"}?Action=AgentTicketCompose&ResponseID=1&TicketID=$Data{"TicketID"}&ArticleID=$Data{"ArticleID"}', 0 ],
[ 'UserCustomerID', 'CustomerID', 'kdnr1', 1, 1, 'var', '', 0 ],
[ 'UserPhone', 'Phone', 'telefon', 1, 0, 'var', '', 0 ],
[ 'UserFax', 'Fax', 'telefax', 1, 0, 'var', '', 0 ],
[ 'UserStreet', 'Street', 'strasse', 1, 0, 'var', '', 0 ],
[ 'UserZip', 'Zip', 'plz', 1, 0, 'var', '', 0 ],
[ 'UserCity', 'City', 'ort', 1, 0, 'var', '', 0 ],
[ 'UserCountry', 'Country', 'land', 1, 0, 'var', '', 0 ],
[ 'ValidID', 'Valid', 'kdnr1', 0, 1, 'int', '', 0 ],
],
# default selections
Selections => {
UserSalutation => {
'1' => 'Herr',
'2' => 'Frau',
},
},
};
Does anyone have a idea?
thanks so mutch
thomas