PostgreSQL Datenbank wird nicht eingebunden

Hilfe zu Znuny Problemen aller Art
Locked
saitae
Znuny newbie
Posts: 2
Joined: 21 Apr 2010, 19:57
Znuny Version: 2.2.7

PostgreSQL Datenbank wird nicht eingebunden

Post by saitae »

Hallo zusammen,

ich habe in der Config.pm folgendes stehen:

Code: Select all

    $Self->{CustomerUser} = {
        Name => 'Database Backend2',
        Module => 'Kernel::System::CustomerUser::DB',
        Params => {
            # if you want to use an external database, add the
            # required settings
#            DSN => 'DBI:odbc:yourdsn',
            DSN => 'DBI:Pg:dbname=k0000-2;host=localhost',
            User => 'k0000',
            Password => '******',
            Table => 'customer',
        },
        # customer uniq id
        CustomerKey => 'customernumber',
        # customer #
        CustomerID => 'customernumber',
#        CustomerValid => 'valid_id',
        CustomerUserListFields => ['customernumber', 'name', 'contact', 'email'],
#        CustomerUserListFields => ['login', 'first_name', 'last_name', 'customer_id', 'email'],
        CustomerUserSearchFields => ['name', 'customernumber', 'contact'],
        CustomerUserSearchPrefix => '*',
        CustomerUserSearchSuffix => '*',
        CustomerUserSearchListLimit => 250,
        CustomerUserPostMasterSearchFields => ['email'],
        CustomerUserNameFields => ['name'],
        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 => [
            # 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 ],
            [ 'UserName',   'Name',   'name',   1, 1, 'var', '', 0 ],
            [ 'UserLogin',      'Username',   'customernumber',       1, 1, 'var', '', 0 ],
#            [ 'UserPassword',   'Password',   'pw',          0, 0, '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', 'customernumber', 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 ],
            [ 'UserPhone',        'Phone',       'phone',        1, 0, 'var', '', 0 ],
            [ 'UserFax',          'Fax',         'fax',          1, 0, 'var', '', 0 ],
#            [ 'UserMobile',       'Mobile',      'mobile',       1, 0, 'var', '', 0 ],
            [ 'UserStreet',       'Street',      'street',       1, 0, 'var', '', 0 ],
            [ 'UserZip',          'Zip',         'zipcode',          1, 0, 'var', '', 0 ],
            [ 'UserCity',         'City',        'city',         1, 0, 'var', '', 0 ],
            [ 'UserCountry',      'Country',     'country',      1, 0, 'var', '', 0 ],
        ],
        # default selections
        Selections => {
            UserSalutation => {
                'Mr.' => 'Herr',
                'Mrs.' => 'Frau',
            },
        },
    };
Leider passiert nun einfach nichts, keine Fehlermeldungen in der Syslog oder im Backend. Auch erscheint bei der Kundenoberfläche bei Quelle/Source immer nur "Database Backend". Gebe ich als Suche * ein, erscheint nur ein Kunde aus der OTRS DB den ich zum testen angelegt hatte.

Wer hat einen Tipp für mich?


Grüße!
"Produktiv": OTRS: 2.2.7
OS: Debian
Apache2/MySQL 5
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

PostgreSQL Datenbank wird nicht eingebunden

Post by jojo »

Apache restart?

Und bitte noch die Signatur ausfüllen!
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
saitae
Znuny newbie
Posts: 2
Joined: 21 Apr 2010, 19:57
Znuny Version: 2.2.7

PostgreSQL Datenbank wird nicht eingebunden

Post by saitae »

Das wars!!!!!111 Vielen Dank!

Ein bisschen zu einfach :D
"Produktiv": OTRS: 2.2.7
OS: Debian
Apache2/MySQL 5
Locked