I wish I could help you, but I am just starting to evaluate OTRS myself
and do not know it intimately. I'll try to research the problem over the
weekend or on my lunch break
Any 1 has any ideas?
(there is also commercial support - if user auth is the ONLY problem -
it's worth paying someone to fix it)
[EMAIL PROTECTED] wrote:
> 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.
>>
>
> _______________________________________________
> OTRS mailing list: otrs - Webpage: http://otrs.org/
> Archive: http://lists.otrs.org/pipermail/otrs
> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
> Support orr consulting for your OTRS system?
> => http://www.otrs.com/
>
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support orr consulting for your OTRS system?
=> http://www.otrs.com/
