[otrs] re: Customer user backend on MSSQL

Simone Girlanda Mon, 30 Jan 2006 06:37:52 -0800

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)

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

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)

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

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, <PRODUC
T> line 4.
Subroutine oldping redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 216, <PRO
DUCT> line 4.
Subroutine get_info redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 257, <PR
ODUCT> line 4.
Subroutine do redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 270, <PRODUCT>
line 4.
Subroutine ExecDirect redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 298, <
PRODUCT> line 4.
Subroutine GetInfo redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 309, <PRO
DUCT> line 4.
Subroutine GetStatistics redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 318
, <PRODUCT> line 4.
Subroutine GetForeignKeys redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 33
0, <PRODUCT> line 4.
Subroutine GetPrimaryKeys redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 34
2, <PRODUCT> line 4.
Subroutine GetSpecialColumns redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line
354, <PRODUCT> line 4.
Subroutine GetTypeInfo redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 362,
<PRODUCT> line 4.
Subroutine type_info_all redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 371
, <PRODUCT> line 4.
Subroutine ColAttributes redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 389
, <PRODUCT> line 4.
Subroutine cancel redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 397, <PROD
UCT> line 4.
Subroutine DBD::ODBC::dr::disconnect_all redefined at C:/OTRS/Perl/site/lib/DBD/
ODBC.pm line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::dr::discon_all_ redefined at C:/OTRS/Perl/site/lib/DBD/ODB
C.pm line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::db::_login redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm
line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::db::selectall_arrayref redefined at C:/OTRS/Perl/site/lib/
DBD/ODBC.pm line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::db::selectrow_array redefined at C:/OTRS/Perl/site/lib/DBD
/ODBC.pm line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::db::selectrow_arrayref redefined at C:/OTRS/Perl/site/lib/
DBD/ODBC.pm line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::db::commit redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm
line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::db::rollback redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.p
m line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::db::disconnect redefined at C:/OTRS/Perl/site/lib/DBD/ODBC
.pm line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::db::STORE redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm l
ine 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::db::FETCH redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm l
ine 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::db::DESTROY redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm
line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::st::_prepare redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.p
m line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::st::rows redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm li
ne 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::st::bind_param redefined at C:/OTRS/Perl/site/lib/DBD/ODBC
.pm line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::st::bind_param_inout redefined at C:/OTRS/Perl/site/lib/DB
D/ODBC.pm line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::st::execute redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm
line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::st::fetchrow_arrayref redefined at C:/OTRS/Perl/site/lib/D
BD/ODBC.pm line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::st::fetch redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm l
ine 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::st::fetchrow_array redefined at C:/OTRS/Perl/site/lib/DBD/
ODBC.pm line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::st::fetchrow redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.p
m line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::st::fetchall_arrayref redefined at C:/OTRS/Perl/site/lib/D
BD/ODBC.pm line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::st::finish redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm
line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::st::blob_read redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.
pm line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::st::STORE redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm l
ine 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::st::FETCH redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm l
ine 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::st::FETCH_attrib redefined at C:/OTRS/Perl/site/lib/DBD/OD
BC.pm line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::st::DESTROY redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm
line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::st::_ColAttributes redefined at C:/OTRS/Perl/site/lib/DBD/
ODBC.pm line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::st::_Cancel redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm
line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::st::_tables redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm
line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::st::_primary_keys redefined at C:/OTRS/Perl/site/lib/DBD/O
DBC.pm line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::st::DescribeCol redefined at C:/OTRS/Perl/site/lib/DBD/ODB
C.pm line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::db::_ExecDirect redefined at C:/OTRS/Perl/site/lib/DBD/ODB
C.pm line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::db::_columns redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.p
m line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::db::_GetInfo redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.p
m line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::db::_GetTypeInfo redefined at C:/OTRS/Perl/site/lib/DBD/OD
BC.pm line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::db::_GetStatistics redefined at C:/OTRS/Perl/site/lib/DBD/
ODBC.pm line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::db::_GetPrimaryKeys redefined at C:/OTRS/Perl/site/lib/DBD
/ODBC.pm line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::db::_GetSpecialColumns redefined at C:/OTRS/Perl/site/lib/
DBD/ODBC.pm line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::db::_GetForeignKeys redefined at C:/OTRS/Perl/site/lib/DBD
/ODBC.pm line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::db::GetFunctions redefined at C:/OTRS/Perl/site/lib/DBD/OD
BC.pm line 27, <PRODUCT> line 4.
Subroutine DBD::ODBC::dr::data_sources redefined at C:/OTRS/Perl/site/lib/DBD/OD
BC.pm line 27, <PRODUCT> line 4.

<<attachment: winmail.dat>>

_______________________________________________
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/

[otrs] re: Customer user backend on MSSQL

Reply via email to