SOLVED-Konfiguration Customer-Front-End:Panic! No UserData!

Hilfe zu Znuny Problemen aller Art
Forum rules
Locked
tommac
Znuny newbie
Posts: 10
Joined: 29 Jul 2009, 16:10
Znuny Version: 2.3.4

SOLVED-Konfiguration Customer-Front-End:Panic! No UserData!

Post by tommac »

Trotzt erfolgreicher Authentifizierung ggü. unserem AD

Code: Select all

Thu Mar 25 13:02:47 2010  	notice  	OTRS-CGI-80  	CustomerUser: ttxxxx (CN=Thoma XXXXX,OU=AfOuI,DC=ads,DC=xxxxx,DC=de) authentification ok (REMOTE_ADDR: 172.18.64.4).
scheitert der Login im Customer-Front-End:

Code: Select all

Panic! No UserData!!!
Es sind zwei Kundendatenbanken angeschlossen:

Code: Select all

    $Self->{CustomerUser} = {
        Name => 'zentrale Kunden-DB (RO)',
        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 => 'mitarbeiter',
        },
        # customer uniq id
        CustomerKey => 'C_EMAILKONTONAME',
        # customer #
        CustomerID => 'C_AMTSCHL',
        CustomerValid => 'valid_id',
        CustomerUserListFields => ['C_FNAME', 'C_VNAME', 'C_EMAILKONTONAME', 'C_AMTSCHL', 'C_EMAILADRESSE'],
#        CustomerUserListFields => ['login', 'first_name', 'last_name', 'customer_id', 'email'],
        CustomerUserSearchFields => ['C_EMAILKONTONAME', 'C_VNAME', 'C_FNAME', 'C_EMAILADRESSE', 'C_AMTSCHL', 'ITK'],
        CustomerUserSearchPrefix => '*',
        CustomerUserSearchSuffix => '*',
        CustomerUserSearchListLimit => 250,
        CustomerUserPostMasterSearchFields => ['C_EMAILADRESSE'],
        CustomerUserNameFields => ['C_VNAME', 'C_FNAME'],
        CustomerUserEmailUniqCheck => 1,
        # show now own tickets in customer panel, CompanyTickets
        CustomerUserExcludePrimaryCustomerID => 1,
        # generate auto logins
        AutoLoginCreation => 0,
        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 => 60,
        # 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',  'C_VNAME',  1, 1, 'var', '', 0 ],
            [ 'UserLastname',   'Lastname',   'C_FNAME',   1, 1, 'var', '$Env{"CGIHandle"}?Action=AgentAugsburg&Telsuche=$Data{"UserLastname"} $Data{"UserFirstname"}', 0 ],
            [ 'UserLogin',      'Username',   'C_EMAILKONTONAME',       1, 1, 'var', '', 0 ],
##_            [ 'UserPassword',   'Password',   'pw',          0, 1, 'var', '', 0 ],
##_ Mail-Adresse nicht anzeigen da diese bereits als UserLogin angezeigt wird
            [ 'UserEmail',      'Email',      'C_EMAILADRESSE',       1, 1, 'var', '', 0 ],
#            [ 'UserEmail',      'Email', 'C_EMAILADRESSE',           1, 1, 'var', '$Env{"CGIHandle"}?Action=AgentTicketCompose&ResponseID=1&TicketID=$Data{"TicketID"}&ArticleID=$Data{"ArticleID"}', 0 ],
##_            [ 'UserMailbox',    'Mailbox',    'C_EMAILKONTONAME', 1, 0, 'var', '', 0 ],
            [ 'UserCustomerID', 'CustomerID', 'C_AMTSCHL', 1, 1, 'var', '', 0 ],
            [ 'UserCustomerIDs', 'CustomerIDs', 'ITK', 1, 0, 'var', '', 0 ],
            [ 'UserPhone',      'Phone',      'C_TEL', 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.',
#            },
        },
    };
##_ 2-te Kunden-DB fuer nicht zentral verwaltete Kunden => diese DB ist beschreibbar
    $Self->{CustomerUser1} = {
        Name => 'Kunden-DB (RW)',
        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 => 'mitarbeiter2',
        },
        # customer uniq id
        CustomerKey => 'C_EMAILKONTONAME',
        # customer #
        CustomerID => 'C_AMTSCHL',
        CustomerValid => 'valid_id',
        CustomerUserListFields => ['C_FNAME', 'C_VNAME', 'C_EMAILADRESSE'],
#        CustomerUserListFields => ['login', 'first_name', 'last_name', 'customer_id', 'email'],
        CustomerUserSearchFields => ['C_VNAME', 'C_FNAME', 'C_EMAILADRESSE', 'C_AMTSCHL', 'ITK'],
        CustomerUserSearchPrefix => '*',
        CustomerUserSearchSuffix => '*',
        CustomerUserSearchListLimit => 250,
        CustomerUserPostMasterSearchFields => ['C_EMAILADRESSE'],
        CustomerUserNameFields => ['C_VNAME', 'C_FNAME'],
        CustomerUserEmailUniqCheck => 0,
        # show now own tickets in customer panel, CompanyTickets
        CustomerUserExcludePrimaryCustomerID => 1,
        # generate auto logins
        AutoLoginCreation => 1,
        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 => 60,
        # just a read only source
        ReadOnly => 0,
        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',  'C_VNAME',  1, 1, 'var', '', 0 ],
            [ 'UserLastname',   'Lastname',   'C_FNAME',   1, 1, 'var', '$Env{"CGIHandle"}?Action=AgentAugsburg&Telsuche=$Data{"UserLastname"} $Data{"UserFirstname"}', 0 ],
            [ 'UserLogin',      'Username',   'C_EMAILKONTONAME',       1, 1, 'var', '', 0 ],
##_            [ 'UserPassword',   'Password',   'pw',          0, 1, 'var', '', 0 ],
##_ Mail-Adresse nicht anzeigen da diese bereits als UserLogin angezeigt wird
            [ 'UserEmail',      'Email',      'C_EMAILADRESSE',       1, 1, 'var', '', 0 ],
#            [ 'UserEmail',      'Email', 'C_EMAILADRESSE',           1, 1, 'var', '$Env{"CGIHandle"}?Action=AgentTicketCompose&ResponseID=1&TicketID=$Data{"TicketID"}&ArticleID=$Data{"ArticleID"}', 0 ],
            [ 'UserCustomerID', 'CustomerID', 'C_AMTSCHL', 1, 1, 'var', '', 0 ],
            [ 'UserCustomerIDs', 'CustomerIDs', 'ITK', 1, 0, 'var', '', 0 ],
            [ 'UserPhone',      'Phone',      'C_TEL', 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.',
#            },
        },
    };
Ich bin mittlerweile sämtliche Dokumentationen, FAQs und Google-Suchstrings durch. Wer kann mir sagen, an was es hakt?
Last edited by tommac on 29 Mar 2010, 15:39, edited 1 time in total.
Top
tommac
Znuny newbie
Posts: 10
Joined: 29 Jul 2009, 16:10
Znuny Version: 2.3.4

Konfiguration Customer-Front-End: Panic! No UserData!!!

Post by tommac »

SOLVED!!!

Das Lösung meines Problems ist eigentlich so einfach, dass ich mich fast nicht traue diese zu posten :oops: :oops: :oops:

Meine Loginversuche auf dem Customer-Front-End schlugen deshalb fehl, weil es mich schlicht und ergreifend nicht in der "mitarbeiter"-Tabelle gegeben hat; ich habe erst nach positiver Rückmeldung eines Kollegen bemerkt, dass unser Testsystem in einer eigenen Instanz gehalten wird, ich stattdessen aber immer mit der mitarbeiter-Tabelle im Produktivsystem per MySQL Query Browser getestet habe...

Nach Anpassung der Config.pm im Produktivsystem hat der Login im Customer-Web-Frontend nun auch mit meinem Account funktioniert. Halleluja!!!
Zu meiner Verteidigung muss ich sagen, dass ich das OTRS erst vor einem halben Jahr von meinem/meinen Vorgänger(n) übernommen habe.
OTRS 2.3.4 unter SUSE Linux, Mysql sowie LDAP/ADS Anbindung
Top
Locked

Return to “Hilfe”