[otrs] Customer database

[teebot at gsmserver.com]

Would you be so king to help me
This is very important. I can not decide whether to use or not  OTRS in 
my support branch
this is extreamly important to make OTRS customer be able to authoraze 
from my database

thx
> 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.
>