Hi,
you managed your customer to authenticate with your DB (chapter 9.3 of
Admin-Manual).
After authentication, your customer must be known within OTRS (chapter
9.2), what is currently not true in your installation. This is
complained with "Panic! No User data". So, you have to adapt 9.2. to
your DB.
Bye, Alex
[EMAIL PROTECTED] schrieb:
> 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/
