Re: [otrs] Postgres as CustomerBackend

30 Oct 2003

      Hi Matthias,

On Thu, Oct 30, 2003 at 11:29:50AM +0100, Matthias Krey wrote:
...
I have successfully have the external mySQL
DB of phprojekt (www.phprojekt.com) to OTRS for
use as customer backend
I wonder if the same is possible for the PostgreSQL DB?
It is not needed for authentication, only Customer search
e.g in PhoneView
Of course! .-)

You can use a PostgreSQL, SAPDB, MSSQL, ODBC, ... you just need a perl 
DBI/DBD driver.

The Kernel/Config.pm should look like this:
[...]
    $Self->{CustomerUser} = {
        Module => 'Kernel::System::CustomerUser::DB',
        Params => {
            # if you want to use an external database, add the
            # required settings
            DSN => 'DBI:odbc:yourdsn',
            User => 'user',
            Password => 'pass',
            Table => 'customer_user',
        },
        # customer uniq id
        CustomerKey => 'login',
[...]
...
best regards,
matthias
Martin

--
Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/
--
Old programmers never die. They just branch to a new address.