Just to let everyone know - I found out how to get OTRS 2.4 working with SQL
Server. Unfortunately the FreeTDS driver does not seem to work - as it drops
the connection after each query. My Config.pm configuration file looks like
this:
Config.pm snippet:
$Self->{'CryptType'} = "plain";
$Self->{'AuthModule::DB::CryptType'} = "plain";
$Self->{'DB::Encode'} = 1;
# ---------------------------------------------------- #
# database settings #
# ---------------------------------------------------- #
# DatabaseHost
# (The database host.)
$Self->{'DatabaseHost'} = 'x.x.x.x';
$Self->{'Database'} = 'otrs';
$Self->{'DatabaseUser'} = 'otrs';
$Self->{'DatabasePw'} = 'otrs';
$Self->{"Database::Type"} = 'mssql';
$Self->{DatabaseDSN} = "DBI:ODBC:otrs";
$Self->{DatabaseUserTable} = 'users';
$Self->{DatabaseUserTableUserID} = 'id';
$Self->{DatabaseUserTableUserPW} = 'pw';
$Self->{DatabaseUserTableUser} = 'login';
/etc/odbc.ini snippet:
[otrs]
Driver = Easysoft ODBC-SQL Server
Description = SQL Server DSN created during installation
Server = 192.168.150.60
Port =
User = otrs
Password = otrs
Language =
Database = otrs
Logging = 0
LogFile =
QuotedId = Yes
AnsiNPW = Yes
Mars_Connection = No
Using the driver from easysoft (odbc-sqlserver-1.1.4-linux-x86-64.tar) with
unixODBC version 2.2.14.
Thanks for the help everyone.
On Mon, Jun 22, 2009 at 11:22, Yogesh Desai <[email protected]>wrote:
> Its my Bad … I have not tried with mssql .
>
>
>
> But you can still use DBI and DBD:ODBC to connect mssql.
>
>
>
> (
> http://www.easysoft.com/developer/languages/perl/sql_server_unix_tutorial.html)
>
>
>
> Thanks,
>
> Yogesh
>
>
>
>
>
> *From:* [email protected] [mailto:[email protected]] *On Behalf Of
> *Russell McConnachie
> *Sent:* Monday, June 22, 2009 10:04 PM
> *To:* User questions and discussions about OTRS.
> *Subject:* Re: [otrs] OTRS on Linux with MSSQL
>
>
>
> Hello Yogesh,
>
> I am actually trying to get it working with MSSQL (SQL Serve 2005), I've
> had it working with MySQL in the past but would much prefer to integrate it
> with our current database which contains all of our customer data instead of
> running into the problems which would arise having multiple databases.
>
> Thanks.
>
> On Mon, Jun 22, 2009 at 10:29, Yogesh Desai <[email protected]>
> wrote:
>
> otrs communicate with mysql using perl-dbd-mysql module .
>
>
>
> No need of odbc driver.
>
>
>
> It should work without any hassle .
>
>
>
> Thanks,
>
> Yogesh
>
>
>
>
>
> *From:* [email protected] [mailto:[email protected]] *On Behalf Of
> *Russell McConnachie
> *Sent:* Monday, June 22, 2009 9:35 PM
> *To:* [email protected]
> *Subject:* [otrs] OTRS on Linux with MSSQL
>
>
>
> Hello:
>
> Has anyone successfully implemented a deployment of OTRS 2.3.4 or 2.4 on a
> Linux based system using MSSQL as the database backend?
>
> Currently my environment is setup as follows:
>
> Perl 5.8.8 (with all required CPAN modules)
> FreeTDS 0.82 (TDS Version 8.0)
> UnixODBC 2.2.11
> OTRS 2.3.4 & OTRS 2.4.0
> Running under Apache 2.2 with mod_perl2.
>
> The problem I am running into is that the connection to my MSSQL database
> drops after each query. I am figuring that the FreeTDS or UnixODBC client is
> not keeping the connection persistent which is why the login to OTRS is
> failing.
>
> If anyone has some insight or has seen this problem before, I would
> appreciate to hear any suggestions.
>
> Thanks.
>
>
> ---------------------------------------------------------------------
> 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
>
> NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
> http://www.otrs.com/en/support/enterprise-subscription/
>
>
>
> ---------------------------------------------------------------------
> 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
>
> NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
> http://www.otrs.com/en/support/enterprise-subscription/
>
---------------------------------------------------------------------
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
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/