Hi Florent,
Florent Guiliani schrieb:
> If you configure an external backend strangely OTRS 2.0.4 will make
> request on other tables
> than the only customer one.
>
> I've got a PostgresSQL database where OTRS is installed.
> My Customers are in an Oracle database so I've changed
> $Self->{CustomerUser} in Config.pm
> to override the internal default one.
>
> While searching and displaying current customers is OK, creating failed
> with:
>
> Software error:
>
> Can't call method "fetchrow_array" on an undefined value at
> /home/otrs//Kernel/System/DB.pm line 477.
> [...]
> In fact OTRS try to select valid table in Oracle not in PostgresQL where
> the table is located.
>
> Where is the catch ?
> [...]
> $Self->{CustomerUser} = {
> Name => 'BDD_GESCAR',
> Module => 'Kernel::System::CustomerUser::DB',
> Params => {
> DSN => 'DBI:Oracle:sid=perorcl;host=192.100.0.11;port=1521;',
> User => '********',
> Password => '**********',
> Table => 'otrs_customer',
> },
> CustomerKey => 'login',
> CustomerID => 'customer_id',
> CustomerValid => 'valid_id',
> [...]
> [ 'ValidID', 'Validité', 'valid_id', 0, 1,
> 'int', '', 0 ],
> ],
> [...]
You need to disable this CustomerValid and ValidID by adding a # at the
front of the line. Then you don't use the valid table.
Martin
((otrs)) :: OTRS GmbH :: Europaring 4 :: D - 94315 Straubing
Fon: +49 (0) 9421 1862 760 :: Fax: +49 (0) 9421 1862 769
http://www.otrs.com/ :: Communication with success!
_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
