We had this problem as well, and we fixed it, we had to update the FreeTDS to the latest version or you could go with easysoft but the license is 1500$ Can, FreedTDS is free. I know your heartache so hope this helps, it’s worked flawless since. If you have any problems let me know.
We are using: OTRS 2.4.1 but had it working on beta 4 and 5 as well unixODBC FreeTDS for our ODBC driver Sql Server 2005 Here is the odbc.ini file we use [otrs] Driver = TDS SQL Server Description = OTRS User = otrs Password = [your password for the sql db you specified for the otrs login] Trace = Yes Database = otrs TraceFile = /tmp/sql.log ForceTrace = Yes Server = [your server address] Port = 1433 TDS Version = 8.0 Database = otrs Here is a snippet from my config file # DatabaseHost # (The database host.) $Self->{DatabaseHost} = '[IP or name to your Database]'; # Database # (The database name.) $Self->{Database} = 'otrs'; # DatabaseUser # (The database user.) $Self->{DatabaseUser} = 'otrs'; # DatabasePw # (The password of database user. You also can use bin/CryptPassword.pl # for crypted passwords.) $Self->{DatabasePw} = '[password to sql server for user otrs]'; # DatabaseDSN $Self->{"Database::Type"} = 'mssql'; $Self->{DatabaseDSN} = "DBI:ODBC:otrs"; $Self->{DatabaseUserTable} = 'users'; $Self->{DatabaseUserTableUserID} = 'id'; $Self->{DatabaseUserTableUserPW} = 'pw'; $Self->{DatabaseUserTableUser} = 'login'; # (The database DSN for PostgreSQL ==> more: "man DBD::Pg") # if you want to use a local socket connection # $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};"; # if you want to use a tcpip connection # $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};host=$Self->{DatabaseHost};"; From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Michiel Beijen Sent: Saturday, July 11, 2009 6:53 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Problems with ODBC and Ms SQL Hi Stefan, For a simple connection with MS-SQL from Linux you could use DBD::Sybase. Here's a sample configuration for a Customer Database on Windows / MS-SQL : # CustomerUser # (customer user database backend and settings) $Self->{CustomerUser} = { Name => 'Customer DB', Module => 'Kernel::System::CustomerUser::DB', Params => { DSN => 'DBI:Sybase:server=192.168.60.1', User => 'database_user', Password => 'password', Table => 'customer_user', }, # customer unique id CustomerKey => 'login', # customer # CustomerID => 'customer_id', CustomerValid => 'valid_id', CustomerUserListFields => ['first_name', 'last_name', 'email'], CustomerUserSearchFields => ['login', 'last_name', 'customer_id'], CustomerUserSearchPrefix => '', CustomerUserSearchSuffix => '*', CustomerUserSearchListLimit => 250, CustomerUserPostMasterSearchFields => ['email'], CustomerUserNameFields => ['salutation','first_name','last_name'], CustomerUserEmailUniqCheck => 1, Map => [ # note: Login, Email and CustomerID needed! # var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link, readonly [ 'UserSalutation', 'Salutation', 'salutation', 1, 0, 'var', '', 0 ], [ 'UserFirstname', 'Firstname', 'first_name', 1, 1, 'var', '', 0 ], [ 'UserLastname', 'Lastname', 'last_name', 1, 1, 'var', '', 0 ], [ 'UserLogin', 'Username', 'login', 1, 1, 'var', '', 0 ], [ 'UserPassword', 'Password', 'pw', 0, 1, 'var', '', 0 ], [ 'UserEmail', 'Email', 'email', 0, 1, 'var', '', 0 ], [ 'UserCustomerID', 'CustomerID', 'customer_id', 0, 1, 'var', '', 0 ], [ 'UserComment', 'Comment', 'comments', 1, 0, 'var', '', 0 ], [ 'ValidID', 'Valid', 'valid_id', 0, 1, 'int', '', 0 ], ], # default selections Selections => { UserSalutation => { 'Mr.' => 'Mr.', 'Mrs.' => 'Mrs.', }, }, }; Just install the package libdbd-sybase-perl and you're good to go! Kind regards, -- Michiel Beijen Software Consultant +31 6 - 457 42 418 Bee Free IT + http://beefreeit.nl On Thu, Jul 9, 2009 at 09:53, Stefan-Michael Guenther <otr...@in-put.de> wrote: Hi Afshar, >We are using OTRS in MS Windows platform with MS SQL database and have >not >any problem till now. What's your problem with MS SQL? just to make sure that we are talking about the same configuration: The OTRS is currently running on a debian server. Did you install OTRS on the windows machine, too? Stefan Hello, are there any members on this mailing list who store the OTRS agents in a MS SQL database? We have used different OTRS installations on Debian, SuSE, Redhat and Ubuntu but always get the same login error message which obviously has something to do with the DBD::ODBC module. It would be helpful if we could get the version numbers MS SQL, DBD::ODBC and OTRS of such a successful installation. Thanks in advance, Stefan-Michael G?nther --------------------------------------------------------------------- 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/