
Hi all, I've been trying to connect the OTRS authentication system with my users database. I've added to the file Kernel/Config.pm the following code, changing the values to feet my database config but I still can't login. # --------------------------------------------------- # # # # Start of config options!!! # # CustomerUser stuff # # # # --------------------------------------------------- # # CustomerUser # (customer user database backend and settings) $Self->{CustomerUser} = { Name => 'Database Backend', Module => 'Kernel::System::CustomerUser::DB', Params => { # if you want to use an external database, add the # required settings # DSN => 'DBI:odbc:yourdsn', # DSN => 'DBI:mysql:database=customerdb;host=customerdbhost', # User => '', # Password => '', Table => 'customer_user', }, # customer uniq id CustomerKey => 'login', # customer # CustomerID => 'customer_id', CustomerValid => 'valid_id', CustomerUserListFields => ['first_name', 'last_name', 'email'], # CustomerUserListFields => ['login', 'first_name', 'last_name', 'customer_id', 'email'], CustomerUserSearchFields => ['login', 'last_name', 'customer_id'], CustomerUserSearchPrefix => '', CustomerUserSearchSuffix => '*', CustomerUserSearchListLimit => 250, CustomerUserPostMasterSearchFields => ['email'], CustomerUserNameFields => ['salutation', 'first_name', 'last_name'], CustomerUserEmailUniqCheck => 1, # # show now own tickets in customer panel, CompanyTickets # CustomerUserExcludePrimaryCustomerID => 0, # # generate auto logins # AutoLoginCreation => 0, # AutoLoginCreationPrefix => 'auto', # # admin can change customer preferences # AdminSetPreferences => 1, # # just a read only source # ReadOnly => 1, Map => [ # note: Login, Email and CustomerID needed! # var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link, readonly [ 'UserSalutation', 'Salutation', 'salutation', 1, 0, 'var', '', 0 ], [ 'UserFirstname', 'Firstname', 'first_name', 1, 1, 'var', '', 0 ], [ 'UserLastname', 'Lastname', 'last_name', 1, 1, 'var', '', 0 ], [ 'UserLogin', 'Username', 'login', 1, 1, 'var', '', 0 ], [ 'UserPassword', 'Password', 'pw', 0, 1, 'var', '', 0 ], [ 'UserEmail', 'Email', 'email', 0, 1, 'var', '', 0 ], # [ 'UserEmail', 'Email', 'email', 1, 1, 'var', '$Env{"CGIHandle"}?Action=AgentTicketCompose&ResponseID=1&TicketID=$Data{"TicketID"}&ArticleID=$Data{"ArticleID"}', 0 ], [ 'UserCustomerID', 'CustomerID', 'customer_id', 0, 1, 'var', '', 0 ], # [ 'UserCustomerIDs', 'CustomerIDs', 'customer_ids', 1, 0, 'var', '', 0 ], [ 'UserComment', 'Comment', 'comments', 1, 0, 'var', '', 0 ], [ 'ValidID', 'Valid', 'valid_id', 0, 1, 'int', '', 0 ], ], # default selections Selections => { # UserSalutation => { # 'Mr.' => 'Mr.', # 'Mrs.' => 'Mrs.', # }, }, }; ################################################################## If I ask for a new password and enter a user (email) from my database, it will generate and store in the DB a new password, and then send it to me correctly, so I don't understand what can be going on. I also don't know where to see logs for debugging this kind of things. I'll have to say that I'm not an expert but getting through the customization needed. The template system is also great and very flexible. Thanks everybody very much in advance for your help and this great soft!!! -- Bruno

Hi Bruno, Bruno Sarlo schrieb:
Hi all,
I've been trying to connect the OTRS authentication system with my users database.
I've added to the file Kernel/Config.pm the following code, changing the values to feet my database config but I still can't login.
# --------------------------------------------------- # # # # Start of config options!!! # # CustomerUser stuff # # # # --------------------------------------------------- #
# CustomerUser # (customer user database backend and settings) $Self->{CustomerUser} = {
You just customized the configuration of customer-information-database. You also need to cutomize the customer-authentication-section, all parameters below $Self->{'Customer::AuthModule'} See the doc for details. Bye, Alex

Thanks Alex!
I got it working, I didn't got the user creation working though, as I
didn't understand yet how to map the values required to the database
(creation_date and other dates). But this don't worries me as I will
make the account creation through other front-end.
I also have a new problem and will mail it in another thread.
Thanks again! This software is really made in a super powerful way,
very modular, extensible, adaptable and... GPL!!!
On 12/15/06, Alexander Scholler
Hi Bruno,
Bruno Sarlo schrieb:
Hi all,
I've been trying to connect the OTRS authentication system with my users database.
I've added to the file Kernel/Config.pm the following code, changing the values to feet my database config but I still can't login.
# --------------------------------------------------- # # # # Start of config options!!! # # CustomerUser stuff # # # # --------------------------------------------------- #
# CustomerUser # (customer user database backend and settings) $Self->{CustomerUser} = {
You just customized the configuration of customer-information-database. You also need to cutomize the customer-authentication-section, all parameters below $Self->{'Customer::AuthModule'}
See the doc for details.
Bye, Alex _______________________________________________ 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/
-- Bruno
participants (2)
-
Alexander Scholler
-
Bruno Sarlo