On Monday, April 19, 2004 10:36 PM
Deccico Adrian <[EMAIL PROTECTED]> wrote:
> If I want to read the customers table from another server what is the
> best option?
>
> 1. To move all the OTRS tables in the location of the other database
>
> 2. To keep both databases separated and only modify OTRS to read
> customers table of the other database.
>
> I think that the first is the best, but I don't know if I am wrong
> ("hacer l�o" as we tell it in Argentina)
2.
Leave the tables where they are, and set in Config.pm:
$Self->{CustomerUser} = {
Name => 'Database',
Module => 'Kernel::System::CustomerUser::DB',
Params => {
Table => 'customer_user',
# to use an external database
DSN => 'DBI:odbc:yourdsn',
DSN => 'DBI:mysql:database=customerdb;host=customerdbhost',
User => '', Password => '',
},
# [...] more settings follow
},
As long as you point OTRS to the outside, there's no need to destroy
those "sleeping" tables.
hth,
Robert Kehl
--
((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg
http://www.otrs.de/ :: Tel. +49 (0)6172 4832388
_______________________________________________
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
