[otrs] Customer database

[teebot at gsmserver.com]

Vladimir Doisan пишет:
> It is, but it will require you to write a custom module IIRC.
> Take a look at the Chapter 9 "Using External Backends" in the OTRS Admin
> manual.
>
>   
First of all, i have tryed to add to my Config.pm strings like this

    $Self->{'Customer::AuthModule'} = 'Kernel::System::CustomerAuth::DB';
    $Self->{'Customer::AuthModule::DB::Table'} = 'tbl_users';
    $Self->{'Customer::AuthModule::DB::CustomerKey'} = 'user_login';
    $Self->{'Customer::AuthModule::DB::CustomerPassword'} = 'user_password';
    $Self->{'Customer::AuthModule::DB::DSN'} = "DBI:mysql:database=MyDBase;host=my_host";
    $Self->{'Customer::AuthModule::DB::User'} = "some_user";
    $Self->{'Customer::AuthModule::DB::Password'} = "some_password";

My user table has follwing structure

 describe tbl_users;
+-----------------+----------------------------------------------------------------------------------+------+-----+---------------+-------+
| Field           | Type                                                                             | Null | Key | Default       | Extra |
+-----------------+----------------------------------------------------------------------------------+------+-----+---------------+-------+
| user_id         | varchar(100)                                                                     |      | PRI |               |       |
| user_sex        | varchar(10)                                                                      | YES  |     | NULL          |       |
| user_login      | varchar(100)                                                                     | YES  | MUL | NULL          |       |
| user_password   | varchar(100)                                                                     | YES  |     | NULL          |       |
| user_email      | varchar(100)                                                                     | YES  |     | NULL          |       |
| user_first_name | varchar(100)                                                                     | YES  |     | NULL          |       |
| user_last_name  | varchar(100)                                                                     | YES  |     | NULL          |       |
| user_address1   | varchar(100)                                                                     | YES  |     | NULL          |       |
| user_address2   | varchar(100)                                                                     | YES  |     | NULL          |       |
| user_city       | varchar(100)                                                                     | YES  |     | NULL          |       |
| user_state      | varchar(100)                                                                     | YES  |     | NULL          |       |
| user_country    | varchar(100)                                                                     | YES  |     | NULL          |       |
| user_phone      | varchar(100)                                                                     | YES  |     | NULL          |       |
| user_zip        | varchar(10)                                                                      | YES  |     | NULL          |       |
| user_fax        | varchar(100)                                                                     | YES  |     | NULL          |       |
| active          | char(1)                                                                          | YES  |     | NULL          |       |
| manually        | char(1)                                                                          | YES  |     | NULL          |       |
| user_company    | varchar(200)                                                                     | YES  |     | NULL          |       |
| serial_clip     | varchar(9)                                                                       | YES  |     | NULL          |       |
| serial_item     | char(2)                                                                          | YES  |     | NULL          |       |
| site            | enum('gsmserver.com','gsmserver.com.ua','gsmserver.es','gsmserver.ru','dealers') |      | PRI | gsmserver.com |       |
| referer         | text                                                                             | YES  |     | NULL          |       |
| icq             | varchar(100)                                                                     | YES  |     | NULL          |       |
| msn             | varchar(100)                                                                     | YES  |     | NULL          |       |
| aim             | varchar(100)                                                                     | YES  |     | NULL          |       |
| yahoo           | varchar(100)                                                                     | YES  |     | NULL          |       |
| skype           | varchar(100)                                                                     | YES  |     | NULL          |       |
| from            | varchar(250)                                                                     | YES  |     | NULL          |       |
| disc_card       | varchar(250)                                                                     | YES  |     | NULL          |       |
| activation_date | varchar(10)                                                                      | YES  |     | NULL          |       |
| tax_id          | varchar(100)                                                                     | YES  |     | NULL          |       |
+-----------------+----------------------------------------------------------------------------------+------+-----+---------------+-------+
31 rows in set (0.00 sec)



Loginig into customer fails becouse "Panic! No User data".
Log file contains login OK record.


> Your DBA could also write an export script fairly easily to export data
> from your existing database to the OTRS' "customer_user" native table,
> but this is not real time.
>