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 Thanks Regards Nicolas Version-Release number of selected component (if applicable): 0.82 How reproducible: Steps to Reproduce: 1. 2. 3. Actual results: unable to connect Expected results: Connection successfull Additional info:
What about the rest of that discussion: http://lists.ibiblio.org/pipermail/freetds/2008q1/023031.html in other words, maybe just change a bit in config files?
Hi, 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 Thanks Regards Nicolas
Hi, 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 [global] # 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 [CLINF001INFRA1] host = clinf001infra1 port = 1454 tds version = 8.0 Nicolas
freetds-0.82-3.fc10 has been submitted as an update for Fedora 10. http://admin.fedoraproject.org/updates/freetds-0.82-3.fc10
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.