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'} = '[EMAIL PROTECTED]';
--
-----------------------------------------
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
_______________________________________________
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 or consulting for your OTRS system?
=> http://www.otrs.com/
