Wenn jemand intresse hat hier mal eine Config in der 3 Datenbanken verwendet werden.
Code: Select all
# --
# Kernel/Config.pm - Config file for OTRS kernel
# Copyright (C) 2001-2010 xxx, http://otrs.org/
# --
# $Id: Config.pm.dist,v 1.23 2010/01/13 22:25:00 martin Exp $
# --
# This software comes with ABSOLUTELY NO WARRANTY. For details, see
# the enclosed file COPYING for license information (AGPL). If you
# did not receive this file, see http://www.gnu.org/licenses/agpl.txt.
# --
# Note:
#
# -->> OTRS does have a lot of config settings. For more settings
# (Notifications, Ticket::ViewAccelerator, Ticket::NumberGenerator,
# LDAP, PostMaster, Session, Preferences, ...) see
# Kernel/Config/Defaults.pm and copy your wanted lines into "this"
# config file. This file will not be changed on update!
#
# --
package Kernel::Config;
sub Load {
my $Self = shift;
# ---------------------------------------------------- #
# ---------------------------------------------------- #
# #
# Start of your own config options!!! #
# #
# ---------------------------------------------------- #
# ---------------------------------------------------- #
# ---------------------------------------------------- #
# database settings #
# ---------------------------------------------------- #
# DatabaseHost
# (The database host.)
$Self->{'DatabaseHost'} = 'localhost';
# Database
# (The database name.)
$Self->{'Database'} = 'otrs';
# DatabaseUser
# (The database user.)
$Self->{'DatabaseUser'} = 'otrs';
# DatabasePw
# (The password of database user. You also can use bin/otrs.CryptPassword.pl
# for crypted passwords.)
$Self->{'DatabasePw'} = '5p7ca9!';
# 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} = 'C:/PROGRA~1/OTRS/OTRS';
# ---------------------------------------------------- #
# insert your own config settings "here" #
# config settings taken from Kernel/Config/Defaults.pm #
# ---------------------------------------------------- #
# $Self->{SessionUseCookie} = 0;
# $Self->{CheckMXRecord} = 0;
# ---------------------------------------------------- #
# ---------------------------------------------------- #
# data inserted by installer #
# ---------------------------------------------------- #
$Self->{LogModule} = 'Kernel::System::Log::File';
$Self->{LogModule::LogFile} = 'C:/PROGRA~1/OTRS/OTRS/var/log/otrs.log';
# $DIBI$
$Self->{'DefaultCharset'} = 'utf-8';
#-----------------OWN---Config---von----Rene---------------------#
$Self->{CustomerUser1} = {
Name => 'STT_VPN',
Module => 'Kernel::System::CustomerUser::DB',
Params => {
## if you want to use an external database, add the
## required settings
## DSN => 'DBI:odbc:yourdsn',
SourceCharset => 'utf-8',
DestCharset => 'utf-8',
DSN => 'DBI:Pg:dbname=vpndb;host=xxxxxx',
User => 'vpn',
Password => xxxx,
Table => '"ap_und_kunden"',
},
## customer uniq id
CustomerKey => '"Kundenname"',
## customer #
CustomerID => 'UserCustomerID',
## CustomerValid => 'valid_id',
CustomerUserExcludePrimaryCustomerID => 0,
CustomerUserListFields => ['"Vorname"','"Nachname"','"E_Mail"'],
## CustomerUserListFields => ['login', 'first_name', 'last_name', 'customer_id', 'email','"Telefonnummer'"],
CustomerUserSearchFields => ['"Vorname"','"Nachname"','"E_Mail"','"Telefonnummer"','"Kundenname"'],
CustomerUserSearchPrefix => '*',
CustomerUserSearchSuffix => '*',
CustomerUserSearchListLimit => 250,
CustomerUserPostMasterSearchFields => ['"E_Mail"'],
CustomerUserNameFields => ['"Vorname"','"Nachname"','"Kundenname"'],
CustomerUserEmailUniqCheck => 1,
## # show now own tickets in customer panel, CompanyTickets
## CustomerUserExcludePrimaryCustomerID => 0,
## # generate auto logins
AutoLoginCreation => 0,
## # generate auto login prefix
## AutoLoginCreationPrefix => 'auto',
## # admin can change customer preferences
AdminSetPreferences => 0,
## # use customer company support (reference to company, See CustomerCompany settings)
## CustomerCompanySupport => 1,
## # cache time to life in sec. - cache any database queris
## CacheTTL => 0,
## # just a read only source
ReadOnly => 1,
Map => [
## [ 'UserSalutation', 'Salutation', '"Anrede"', 1, 0,'var', '', 0 ],
[ 'UserFirstname', 'Firstname', '"Vorname"', 1, 1,'var', '', 0 ],
[ 'UserLastname', 'Lastname', '"Nachname"', 1, 1,'var', '', 0 ],
[ 'UserLogin', 'Username', '"Kundenname"', 1, 1,'var', '', 0 ],
[ 'UserEmail', 'Email', '"E_Mail"', 1, 1,'var', '', 0 ],
[ 'UserCustomerID', 'CustomerID', '"Kundenname"', 1, 1,'var', '', 0 ],
[ 'UserPhone', 'Phone', '"Telefonnummer"', 1, 0,'var', '', 0 ],
[ 'Firma', 'Firma', '"Kundenname"', 1, 1, 'var', '', 0 ],
['Portal User', 'Portal User', '"Portal_User"', 1, 0, 'var', '', 0 ],
[ 'UserCustomerIDs', 'CustomerIDs', '"Centron_Kundennummer"', 1, 0, 'var', '', 0 ],
##[ 'UserMobile', 'Mobile', 'mobile', 1, 0,'var', '', 0 ],
[ 'UserStreet', 'Street', '"Strasse"', 1, 0, 'var', '', 0 ],
[ 'UserCity', 'City', '"Ort"', 1, 0, 'var', '', 0 ],
[ 'UserZip', 'Zip', '"PLZ"', 1, 0, 'var', '', 0 ],
##[ 'UserAddress', 'Address', 'postaladdress', 1, 0,'var', '', 0 ],
##[ 'UserComment', 'Comment', 'description', 1, 0,'var', '', 0 ],
],
## default selections
Selections => {
UserSalutation => {
'Mr.' => 'Herr',
'Mrs.' => 'Frau',
},
},
};
#---------------------------------Centron--------------------------------------#
#$Self->{'DefaultCharset'} = 'iso-8859-1';
$Self->{"Database::Type"} = 'mssql';
$Self->{CustomerUser2} = {
Name => 'Centron',
Module => 'Kernel::System::CustomerUser::DB',
Params => {
# if you want to use an external database, add the required settings
DSN => 'DBI:ODBC:OTRS',
SourceCharset => 'iso-8859',
DestCharset => 'utf-8',
#Die => 1,
User => 'centron',
Password => xxxxx,
Table => '"Export Ansprechpartner Test"',
},
# customer unique id
CustomerKey => '"Ansprech"',
# customer #
CustomerID => '"Firma"',
# CustomerValid => '1',
CustomerUserListFields => ['AnsprechVorname', 'Ansprech','Firma'],
CustomerUserSearchFields => ['AnsprechVorname', 'Ansprech','Firma'],
CustomerUserSearchPrefix => '*',
CustomerUserSearchSuffix => '*',
CustomerUserSearchListLimit => 250,
CustomerUserPostMasterSearchFields => ['Email1'],
CustomerUserNameFields => ['AnsprechVorname','Ansprech','Firma'],
CustomerUserEmailUniqCheck => 1,
# # show not own tickets in customer panel, CompanyTickets
# CustomerUserExcludePrimaryCustomerID => 0,
# # generate auto logins
AutoLoginCreation => 0,
# AutoLoginCreationPrefix => 'auto',
# # admin can change customer preferences
AdminSetPreferences => 0,
# # cache time to live in sec. - cache any database queries
# CacheTTL => 0,
# # 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, http-link-target
# [ 'UserTitle', 'Title', 'title', 1, 0, 'var', '', 0 ],
[ 'UserFirstname', 'Vorname', 'AnsprechVorname', 1, 0, 'var', '', 0 ],
[ 'UserLastname', 'Nachname', 'Ansprech', 1, 0, 'var', '', 0 ],
[ 'UserEmail', 'E-Mail', 'Email1', 1, 0, 'var', '', 0 ],
[ 'UserCustomerID', 'CustomerID', 'Firma', 0, 1,'var', '', 0 ],
[ 'UserPassword', 'Password', 'Ansprech', 1, 0, 'var', '', 0 ],
[ 'UserLogin', 'Login', 'Ansprech', 1, 0, 'var', '', 0 ],
[ 'Firma', 'Firma', 'Firma', 1, 0, 'var', '', 0 ],
# [ 'UserCustomerIDs', 'CustomerIDs', 'customer_ids', 1, 0, 'var', '', 0 ],
[ 'UserPhone', 'Phone', 'Tel1', 1, 0, 'var', '', 0 ],
[ 'UserFax', 'Fax', 'Fax1', 1, 0, 'var', '', 0 ],
# [ 'UserMobile', 'Mobile', 'mobile', 1, 0, 'var', '', 0 ],
# [ 'UserStreet', 'Street', 'street', 1, 0, 'var', '', 0 ],
# [ 'UserZip', 'Zip', 'zip', 1, 0, 'var', '', 0 ],
# [ 'UserCity', 'City', 'city', 1, 0, 'var', '', 0 ],
# [ 'UserCountry', 'Country', 'country', 1, 0, 'var', '', 0 ],
# [ 'UserComment', 'Firma', '"Firma"', 1, 0, 'var', '', 0 ],
# [ 'ValidID', 'Valid', 'valid_id', 0, 1, 'int', '', 0 ],
],
# default selections
Selections => {
UserTitle => {
'Mr.' => 'Mr.',
'Mrs.' => 'Mrs.',
},
},
};
# ---------------------------------------------------- #
# ---------------------------------------------------- #
# #
# End of your own config options!!! #
# #
# ---------------------------------------------------- #
# ---------------------------------------------------- #
}
# ---------------------------------------------------- #
# needed system stuff (don't edit this) #
# ---------------------------------------------------- #
use strict;
use warnings;
use vars qw(@ISA $VERSION);
$VERSION = qw($Revision: 1.23 $)[1];
use Kernel::Config::Defaults;
push (@ISA, 'Kernel::Config::Defaults');
# -----------------------------------------------------#
1;
Und deaktiviere den MYSQL (nicht MSSQL) Dienst, sonst geht da auch nichts.