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!