Message: 2
Date: Tue, 31 Jan 2006 07:18:05 +0100
From: Alexander Scholler <[EMAIL PROTECTED]>
Subject: Re: [otrs] R: re: Customer user backend on MSSQL
To: "User questions and discussions about OTRS.org" <[email protected]>
Message-ID: <[EMAIL PROTECTED]>
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,
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support oder Consulting für Ihr OTRS System?
=> http://www.otrs.de/
