otrs[2.4.8,3.0.0]+mssql = SessionID invalid! Need user data

[j4c3k]

hi.

im try to install otrs. i want to use mssql 2005 as backend.

my Config.pm:

Code: Select all

$Self->{'DatabaseHost'} = 'XXX';
$Self->{'Database'} = 'OTRS3_TEST';
$Self->{'DatabaseUser'} = 'otrs';
$Self->{'DatabasePw'} = 'XXX';
$Self->{DatabaseDSN} = "DBI:Sybase:$Self->{Database}";
$Self->{'Database::Type'} = 'mssql';

$Self->{DatabaseUserTable} = 'users';
$Self->{DatabaseUserTableUserID} = 'id';
$Self->{DatabaseUserTableUserPW} = 'pw';
$Self->{DatabaseUserTableUser} = 'login';

when in try to login im get: 'SessionID invalid! Need user data!'

when im use mysql 5.0 as backend i don't have this problem.

sorry for my english.

--
Best regards.
Jacek.

[Mike_B]

Hi Jacek,

You're using the Sybase driver for the MS-SQL database. MS SQL Server was forked off of Sybase code at some point, so it's similar, but that happened around 15 years ago, and the databases have evolved since.
You can get away with using the Sybase driver to connect to a remote MS-SQL database for your customer backend, but not for running the complete OTRS system on it. And trust me, I've tried...

The problem is that LONG character fields are not supported by the Sybase driver. So you can do SOME stuff but not all.

If you want to run MS-SQL with OTRS you'd need to use DBD::ODBC. This means also that it's slower than MySQL or PostgreSQL or Oracle because of the difference between ODBC and direct database connections.

--
Mike.

[FlavioB]

hi.

when in try to login im get: 'SessionID invalid! Need user data!'

when im use mysql 5.0 as backend i don't have this problem.

sorry for my english.

--
Best regards.
Jacek.

Jacek, did you manage to get it working?
I've seen in your config, that there are quotes missing, at "$Self->{DatabaseDSN} = "DBI:Sybase:$Self->{Database}";" there should be quotes around DatabaseDSN, or am I wrong?

Thanks for giving some feedback, and I'd also like to ask if you could post your ODBC configuration files.

Kind regards,
F.