Hi I am using and existing oracle DB as a customer backend, and I have it working fine from the admin area, but am having trouble with customer auth. I noticed Tobias mentioned the customer auth module, I do have this set up as far as I can tell. Tobias also mentioned "OTRS needs to sync user information to its local database and needs the config for it" , does this mean that when a customer is found in the backend, and a ticket is added, that the customer information is also stored in the local DB. My config file follows Regards Steve package Kernel::Config; sub Load { my $Self = shift; # DatabaseHost # (The database host.) $Self->{'DatabaseHost'} = 'localhost'; # Database # (The database name.) $Self->{'Database'} = 'xxxx'; # DatabaseUser # (The database user.) $Self->{'DatabaseUser'} = 'xxxx'; # DatabasePw # (The password of database user. You also can use bin/CryptPassword.pl # for crypted passwords.) $Self->{'DatabasePw'} = 'xxxxxx'; # DatabaseDSN # (The database DSN for MySQL ==> more: "man DBD::mysql") $Self->{DatabaseDSN} = "DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};"; # (The database DSN for PostgreSQL ==> more: "man DBD::Pg") # if you want to use a local socket connection # $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};"; # if you want to use a tcpip connection # $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};host=$Self->{DatabaseHost};"; # ---------------------------------------------------- # # fs root directory # ---------------------------------------------------- # $Self->{Home} = '/opt/otrs'; # ---------------------------------------------------- # # insert your own config settings "here" # # config settings taken from Kernel/Config/Defaults.pm # # ---------------------------------------------------- # # $Self->{SessionUseCookie} = 0; # $Self->{'CheckMXRecord'} = 1; # CustomerUser # (customer user database backend and settings) $ENV{ORACLE_HOME} = '/home/oracle'; $Self->{CustomerUser} = { Name => 'Registered Customers', Module => 'Kernel::System::CustomerUser::DB', Params => { # if you want to use an external database, add the # required settings DSN => 'DBI:Oracle:sid=info;host=xxxxxx.bookingcenter.com;port=1521;', # DSN => 'DBI:mysql:database=customerdb;host=customerdbhost', User => 'xxxxxx', Password => 'xxxxxx', Table => 'customer_user', }, # customer uniq id CustomerKey => 'id', # customer # CustomerID => 'customer_id', # CustomerValid => 'valid_id', CustomerUserListFields => ['first_name', 'last_name', 'email'], CustomerUserSearchFields => ['customer_id', 'last_name', 'email'], 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.', }, }, }; $Self->{'Customer::AuthModule::DB::DSN'} = "DBI:Oracle:sid=info;host=xxxxx.bookingcenter.com;port=1521;"; $Self->{'Customer::AuthModule::DB::User'} = "xxxxxx"; $Self->{'Customer::AuthModule::DB::Password'} = "xxxxxx"; # ---------------------------------------------------- # # ---------------------------------------------------- # # data inserted by installer # # ---------------------------------------------------- # # $DIBI$ $Self->{'SystemID'} = 10; $Self->{'SecureMode'} = 1; $Self->{'Organization'} = 'BookingCenter LLC'; $Self->{'LogModule::LogFile'} = '/tmp/otrs.log'; $Self->{'LogModule'} = 'Kernel::System::Log::SysLog'; $Self->{'FQDN'} = 'otrs.bookingcenter.com'; $Self->{'DefaultLanguage'} = 'en'; $Self->{'DefaultCharset'} = 'iso-8859-1'; $Self->{'AdminEmail'} = 'admin@bookingcenter.com'; -- ----------------------------------------- BookingCenter.com http://www.bookingcenter.com the Internet way to manage and sell your property's inventory. US Office (707) 874-3922 - tel (718) 228-5959 - fax United Kingdom Office Tel 020 8133 7393