Red Hat Bugzilla – Bug 479148
Connection problem with openssl
Last modified: 2009-01-21 16:33:47 EST
Description of problem:
In Fedora 10, freetds in in version 0.82 and compiled with openssl. I'm trying to connect to an SQL Server 2005 with tsql and perl with DBD-Sybase without success with this version.
[l223045@eqdw3padm001 Download]$ tsql -S CLINF001INFRA1 -U unixteam
locale is "en_US.UTF-8"
locale charset is "UTF-8"
10Msg 20003, Level 6, State -1, Server OpenClient, Line -1
Adaptive Server connection timed out
Msg 20002, Level 9, State -1, Server OpenClient, Line -1
Adaptive Server connection failed
There was a problem connecting to the server
With the version 0.64, everything is fine. I have made son research on Google and found http://lists.ibiblio.org/pipermail/freetds/2008q1/023030.html
I have recompiled the source with gnutls and now, tsql and perl works fine.
Maybe the RPM need to be rebuilt with gnutls instead of openssl. I will test that solution and see if its works
Version-Release number of selected component (if applicable):
Steps to Reproduce:
unable to connect
What about the rest of that discussion:
in other words, maybe just change a bit in config files?
sorry, I have forgotten to say that I have tried with encryption set to request, required, off without success.
With the source of freetds compiled against gnutls, I'm able to connect to the sql server with the default settings of encryption (off) and when setting to request or required.
I'm downloading the src rpm of freetds to rebuild it against freetds and see if that works or not
I have just finished to rebuild the RPM of FreeTDS, changing --with-openssl by --with-gnutls and everything is working fine with every value of encryption
My configuration file
# $Id: freetds.conf,v 1.12 2007/12/25 06:02:36 jklowden Exp $
# This file is installed by FreeTDS if no file by the same
# name is found in the installation directory.
# For information about the layout of this file and its settings,
# see the freetds.conf manpage "man freetds.conf".
# Global settings are overridden by those in a database
# server specific section
# TDS protocol version
tds version = 8.0
# Whether to write a TDSDUMP file for diagnostic purposes
# (setting this to /tmp is insecure on a multi-user system)
; dump file = /tmp/freetds.log
; debug flags = 0xffff
# Command and connection timeouts
; timeout = 10
; connect timeout = 10
# If you get out-of-memory errors, it may mean that your client
# is trying to allocate a huge buffer for a TEXT field.
# Try setting 'text size' to a more reasonable limit
text size = 64512
host = clinf001infra1
port = 1454
tds version = 8.0
freetds-0.82-3.fc10 has been submitted as an update for Fedora 10.
freetds-0.82-3.fc10 has been pushed to the Fedora 10 testing repository. If problems still persist, please make note of it in this bug report.
If you want to test the update, you can install it with
su -c 'yum --enablerepo=updates-testing update freetds'. You can provide feedback for this update here: http://admin.fedoraproject.org/updates/F10/FEDORA-2009-0497
freetds-0.82-3.fc10 has been pushed to the Fedora 10 stable repository. If problems still persist, please make note of it in this bug report.