Skip to Content.
Sympa Menu

freetds - [freetds] Connection Errors...

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Rick D Conner" <Rick AT rickconner.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Connection Errors...
  • Date: Fri, 17 Jun 2005 16:01:51 -0400

Hello,



I have to ask for some help because I'm at the end of my rope with this.
First off, I'm restricted in that the web host has the "real" control over
the freetds configurations, but they will take "suggestions". We have had
this working in the past but because of some server load problems, we moved
to another server. Since they have installed freetds on it, it's obviously
not working.



We are on a unix box, running apache. if it's necessary I can get the ver
#'s .. And we are connecting to a remote mssql server running MsSql server
2000.



Here is a copy of the log files generated..



Here is a copy of the freetdsconfig.log file:

_____

15:33:45.274100 Starting log file for FreeTDS 0.63
on 2005-06-17 15:33:45 with debug level 99.
15:33:45.274197 Attempting to read conf files.
15:33:45.274227 Found conf file '/home/bwelch/.freetds.conf' (from
$FREETDSCONF). Reading section 'CALLCENTER'.
15:33:45.274247 Looking for section global.
15:33:45.274304 ... Found section global.
15:33:45.274324 Got a match.
15:33:45.274359 ... Found section jdbc.
15:33:45.274383 ... Found section jdbc_42.
15:33:45.274407 ... Found section mypool.
15:33:45.274430 ... Found section callcenter.
15:33:45.274455 ... Found section sybase.
15:33:45.274485 ... Found section sybase1.
15:33:45.274518 Looking for section CALLCENTER.
15:33:45.274555 ... Found section global.
15:33:45.274589 ... Found section jdbc.
15:33:45.274613 ... Found section jdbc_42.
15:33:45.274636 ... Found section mypool.
15:33:45.274659 ... Found section callcenter.
15:33:45.274678 Got a match.
15:33:45.274701 option = 'host' value = '66.208.184.170'.
15:33:45.274722 Found host entry 66.208.184.170.
15:33:45.274748 IP addr is 66.208.184.170.
15:33:45.274768 option = 'port' value = '1433'.
15:33:45.274795 option = 'tds version' value = '7.0'.
15:33:45.274817 option = 'dump file' value =
'/home/bwelch/public_html/test/tds.log.txt'.
15:33:45.274839 ... Found section sybase.
15:33:45.274868 ... Found section sybase1.
15:33:45.274893 ...Success.
15:33:45.274927 Setting 'tdsver' to 7.0 from $TDSVER.
15:33:45.274953 Setting 'dump_file' to
'/home/bwelch/www/test/freetds.log.txt' from $TDSDUMP.
15:33:45.274973 Setting 'port' to 1433 from $TDSPORT.
15:33:45.274995 Setting 'ip_addr' to 66.208.184.170 (66.208.184.170) from
$TDSHOST.

Here is a copy of the freetds.log file generated from the above requests:

_____

15:33:45.275073 Starting log file for FreeTDS 0.63
on 2005-06-17 15:33:45 with debug level 99.
15:33:45.275371 names for ISO-8859-1: ISO-8859-1
15:33:45.275395 names for UTF-8: UTF-8
15:33:45.275414 names for UCS-2LE: UCS-2LE
15:33:45.275433 names for UCS-2BE: UCS-2BE
15:33:45.275451 iconv to convert client-side data to the "ISO-8859-1"
character set
15:33:45.275506 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
15:33:45.275558 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
15:33:45.275589 Connecting to 66.208.184.170 port 1433, TDS 7.0.
15:33:45.330418 tds_put_string converting 21 bytes of
"server.e3-destiny.com"
15:33:45.330479 tds_put_string wrote 42 bytes
15:33:45.330494 tds_put_string converting 3 bytes of "web"
15:33:45.330507 tds_put_string wrote 6 bytes
15:33:45.330522 tds_put_string converting 10 bytes of "PHP 4.3.11"
15:33:45.330538 tds_put_string wrote 20 bytes
15:33:45.330551 tds_put_string converting 10 bytes of "CALLCENTER"
15:33:45.330564 tds_put_string wrote 20 bytes
15:33:45.330577 tds_put_string converting 10 bytes of "DB-Library"
15:33:45.330590 tds_put_string wrote 20 bytes
15:33:45.330603 tds_put_string converting 10 bytes of "us_english"
15:33:45.330616 tds_put_string wrote 20 bytes
15:33:45.330629 tds_put_string wrote 0 bytes
15:33:45.330746 tds_process_login_tokens()
15:38:45.787660 goodread: errno=104, "Connection reset by peer"
15:38:45.787717 tds_client_msg: #20004: "Read from SQL server failed.".
Connection state is now 0.
15:38:45.787753 looking for login token, got 0()
15:38:45.787771 tds_process_default_tokens() marker is 0()
15:38:45.787785 leaving tds_process_default_tokens() connection dead
15:38:45.787799 tds_client_msg: #20014: "Login incorrect.". Connection state
is now 4.
15:38:45.787812 tds_free_all_results()





If you notice on the freetds.log file, there is a 5 minute "pause" where the
connection is finally reset by the peer (mssql server I'm assuming). Now,
before you say the same thing that my host did, I HAVE checked the username
and password, and they are correct. I even setup a new account on the mssql
server and tried it to no avail..



Has anyone got a suggestion or solution or two for me??? Thanks in advance..

















<http://www.wedosites.com> WeDoSites.com

Professional Web Development, with a Personal Touch





Rick D. Conner
Developer

WeDoSites.com

<http://maps.yahoo.com/py/maps.py?Pyt=Tmap&addr=PO+Box+716&csz=Mineral+Wells
%2C+WV+26150-0716&country=us> PO Box 716
Mineral Wells, WV 26150-0716


<mailto:rick AT wedosites.com> rick AT wedosites.com
<http://www.wedosites.com> http://www.wedosites.com


tel:
mobile:

304-489-3027
304-488-8347





<https://www.plaxo.com/add_me?u=25770847061&v0=2075011&k0=636836807> Add me
to your address book...

<http://www.plaxo.com/signature> Want a signature like this?







Archive powered by MHonArc 2.6.24.

Top of Page