Re: [otrs] OTRS on Linux with MSSQL
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 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:* otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] *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
> wrote:
>
> otrs communicate with mysql using perl-dbd-mysql module .
>
>
>
> No need of odbc driver.
>
>
>
> It should work without any hassle .
>
>
>
> Thanks,
>
> Yogesh
>
>
>
>
>
> *From:* otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] *On Behalf Of
> *Russell McConnachie
> *Sent:* Monday, June 22, 2009 9:35 PM
> *To:* otrs@otrs.org
> *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/
Re: [otrs] OTRS on Linux with MSSQL
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: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] 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 mailto:yogesh.de...@coreobjects.com>> wrote: otrs communicate with mysql using perl-dbd-mysql module . No need of odbc driver. It should work without any hassle . Thanks, Yogesh From: otrs-boun...@otrs.org<mailto:otrs-boun...@otrs.org> [mailto:otrs-boun...@otrs.org<mailto:otrs-boun...@otrs.org>] On Behalf Of Russell McConnachie Sent: Monday, June 22, 2009 9:35 PM To: otrs@otrs.org<mailto:otrs@otrs.org> 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/
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 wrote: > otrs communicate with mysql using perl-dbd-mysql module . > > > > No need of odbc driver. > > > > It should work without any hassle . > > > > Thanks, > > Yogesh > > > > > > *From:* otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] *On Behalf Of > *Russell McConnachie > *Sent:* Monday, June 22, 2009 9:35 PM > *To:* otrs@otrs.org > *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/
Re: [otrs] OTRS on Linux with MSSQL
otrs communicate with mysql using perl-dbd-mysql module . No need of odbc driver. It should work without any hassle . Thanks, Yogesh From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Russell McConnachie Sent: Monday, June 22, 2009 9:35 PM To: otrs@otrs.org 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] 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/
