Message: 2 Date: Tue, 31 Jan 2006 07:18:05 +0100 From: Alexander Scholler Subject: Re: [otrs] R: re: Customer user backend on MSSQL To: "User questions and discussions about OTRS.org" Message-ID: <43DF011D.2010000@augsburg.de> Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Hi Simone,

...

ODBC connection to microsoft SQL Server works, but I got some problem with OTRS:

1. OTRS look for a table named VALID in my user database (I create a table cloning the one present in the OTRS database)

I think OTRS doesn't look for a -table- called VALID but for a -column- called VALID. This boolean field indicates whether the customer read from the table is valid.

I checked SQL istructions with SQL Profiler to track all operation and OTRS is looking for a table called VALID I have to create it in my SAP database.

...

2. OTRS use a SQL syntax that is not compatible with SQL Server (directive LIMIT), I changed OTRS source to avoid the use of this directive

I don't know whether LIMIT is a sql-standard-syntax or MySQL-specific. But you can use the corresponding MS-SQL-statement especially because your description sound like you have much customers.

ok

...

3. now I'm able to use my SAP BO user table, but I'm not able to give access to customer users to OTRS web site (customer.pl)

You have to differ between infos about the customers and authentication of the customers - see doc and mail archive for that. Regard $Self->{'Customer::AuthModule'}. E.g. you can use your ADS for authentication.

Ok, I solved also this topic

...

4. ODBC give many message (but it work):

Solve 1 and 4, perhaps these messages then disappear. You also can post the relevant parts of your OTRS-configuration.

...

Subroutine driver redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 34, <PRODU CT> line 4. Subroutine CLONE redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 54, <PRODUC T> line 4. Subroutine connect redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 62, <PROD UCT> line 4. Subroutine prepare redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 89, <PROD UCT> line 4. Subroutine column_info redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 107, <PRODUCT> line 4. Subroutine columns redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 123, <PRO DUCT> line 4. Subroutine table_info redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 140, < PRODUCT> line 4. Subroutine primary_key_info redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 164, <PRODUCT> line 4. Subroutine foreign_key_info redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 178, <PRODUCT> line 4. Subroutine ping redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 194,