Hello. Is it possible to authorize customer from our database, not from "customer_user" native table?
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. 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. teebot@gsmserver.com wrote:
Hello.
Is it possible to authorize customer from our database, not from "customer_user" native table? _______________________________________________ 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/
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.
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.
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) teebot@gsmserver.com 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/
Provide me with following information, please. What type of password crypt method is in use? I decide to authorize customer from your database instead of adaptation of mine. It's hard for me to recognize crypt method by explorering table content I have noticed that password always prefixed with first 2 symbols from login/email. It seems to me it is not md5 or any other crypt methods that I know.
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 teebot@gsmserver.com 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/
participants (3)
-
Alexander Scholler -
teebot＠gsmserver.com -
Vladimir Doisan