Нужно забирать пользователей(кастомеров) из своей базы + базы MSSQL. Делаю в конфиге :
Код: Выделить всё
#---------------------------------MS_SQL Customer database backend--------------------------------------------#
# CustomerUser
# (customer user database backend and settings)
$Self->{CustomerUser1} = {
Type => 'mssql',
Name => 'MS_SQL Database Backend',
Module => 'Kernel::System::CustomerUser::DB',
Params => {
# if you want to use an external database, add the
# required settings
DSN => 'DBI:odbc:MS_OTRS',
User => 'otrs_user',
Password => '**********',
Table => 'Customer_ContactTT',
# if your frontend is unicode and the charset of your
# customer database server is iso-8859-1, use these options.
SourceCharset => 'cp1251',
DestCharset => 'utf-8',
# CaseSensitive will control if the SQL statements need LOWER()
# function calls to work case insensitively. Setting this to
# 1 will improve performance dramatically on large databases.
CaseSensitive => 0,
},
# customer unique id
CustomerKey => 'id',
# customer #
CustomerID => 'id',
CustomerValid => 'valid_id',
CustomerUserListFields => [ 'first_name', 'last_name', 'email' ],
CustomerUserSearchFields => [ 'login', 'first_name', 'last_name', 'customer_id' ],
CustomerUserSearchPrefix => '*',
CustomerUserSearchSuffix => '*',
CustomerUserSearchListLimit => 250,
CustomerUserPostMasterSearchFields => ['email'],
CustomerUserNameFields => [ 'title', 'first_name', 'last_name' ],
CustomerUserEmailUniqCheck => 0,
};
#End of MS_SQL Customer database backend#
Код: Выделить всё
# isql MS_OTRS otrs_user ******
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> select count(*) from Customer_ContactTT;
+------------+
| |
+------------+
| 3528 |
+------------+
SQLRowCount returns 1
1 rows fetched
SQL>
Код: Выделить всё
ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: linux Time: Wed Jun 27 17:27:11 2012
Message: Unknown database type! Set option Database::Type in Kernel/Config.pm to (mysql|postgresql|oracle|db2|mssql).