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.
_______________________________________________
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/
