FreeTDS Development Group

[Igor Korot <ikorot01 AT gmail.com>]

Hi,

On Tue, Jul 17, 2012 at 3:21 AM, Simon Jones <Simon AT saq.net> wrote:
> I almost have the service working.  In the freetds log I noticed the 
> connection was failing because freetds was trying to connect on port 4000, 
> I have specified the server address and port 1433 in freetds.conf but it 
> doesn't choose the correct port, but it does know the server IP address.  
> In the conn.php for the website I have specified the connection as 
> x.x.x.x:1433 this now connects on the correct port but there is something 
> going wrong with the handshake, could the version of freetds be 
> incompatible with SQL Server 2008?  Please see log file:
>
> root@test [/usr/local/etc]# cat  /tmp/freetds.log
> log.c:196:Starting log file for FreeTDS 0.91
>         on 2012-07-17 11:08:01 with debug flags 0x4fff.
> iconv.c:330:tds_iconv_open(0x12b67bd0, ISO-8859-1)
> iconv.c:187:local name for ISO-8859-1 is ISO-8859-1
> iconv.c:187:local name for UTF-8 is UTF-8
> iconv.c:187:local name for UCS-2LE is UCS-2LE
> iconv.c:187:local name for UCS-2BE is UCS-2BE
> iconv.c:349:setting up conversions for client charset "ISO-8859-1"
> iconv.c:351:preparing iconv for "ISO-8859-1" <-> "UCS-2LE" conversion
> iconv.c:391:preparing iconv for "ISO-8859-1" <-> "ISO-8859-1" conversion
> iconv.c:394:tds_iconv_open: done
> net.c:205:Connecting to 93.174.138.210 port 1433 (TDS version 5.0)

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
1. You send an IP address as a clear text.
2.TDS version 5.0 is not SQL Server 2008. Try 7.0.

Thank you.

> net.c:270:tds_open_socket: connect(2) returned "Operation now in progress"
> net.c:310:tds_open_socket() succeeded
> util.c:156:Changed query state from DEAD to IDLE
> net.c:741:Sending packet
> 0000 02 00 02 00 00 00 00 00-74 65 73 74 2e 73 61 71 |........ test.saq|
> 0010 2e 6e 65 74 00 00 00 00-00 00 00 00 00 00 00 00 |.net.... ........|
> 0020 00 00 00 00 00 00 0c 73-61 00 00 00 00 00 00 00 |.......s a.......|
> 0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
> 0040 00 00 00 00 00 02 4a 65-64 69 39 39 39 00 00 00 |......Je di999...|
> 0050 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
> 0060 00 00 00 00 07 31 36 30-30 34 00 00 00 00 00 00 |.....160 04......|
> 0070 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
> 0080 00 00 00 05 03 01 06 0a-09 01 00 00 00 00 00 00 |........ ........|
> 0090 00 00 00 00 50 48 50 20-35 00 00 00 00 00 00 00 |....PHP  5.......|
> 00a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
> 00b0 00 00 05 39 33 2e 31 37-34 2e 31 33 38 2e 32 31 |...93.17 4.138.21|
> 00c0 30 3a 31 34 33 33 00 00-00 00 00 00 00 00 00 00 |0:1433.. ........|
> 00d0 00 13 00 07 4a 65 64 69-39 39 39 00 00 00 00 00 |....Jedi 999.....|
> 00e0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
> 00f0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
> 0100 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
> 0110 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
> 0120 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
> 0130 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
> 0140 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
> 0150 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
> 0160 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
> 0170 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
> 0180 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
> 0190 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
> 01a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
> 01b0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
> 01c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
> 01d0 00 09 05 00 00 00 44 42-2d 4c 69 62 72 61 72 79 |......DB -Library|
> 01e0 0a 05 00 00 00 00 0d 11-75 73 5f 65 6e 67 6c 69 |........ us_engli|
> 01f0 73 68 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |sh...... ........|
>
> net.c:741:Sending packet
> 0000 02 01 00 61 00 00 00 00-00 00 00 00 00 00 0a 00 |...a.... ........|
> 0010 00 00 00 00 00 00 00 00-00 00 00 00 00 69 73 6f |........ .....iso|
> 0020 5f 31 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |_1...... ........|
> 0030 00 00 00 00 00 00 00 00-00 00 00 05 01 35 31 32 |........ .....512|
> 0040 00 00 00 03 00 00 00 00-e2 16 00 01 09 00 08 0e |........ ........|
> 0050 6d 7f ff ff ff fe 02 09-00 00 00 00 02 68 00 00 |m....... .....h..|
> 0060 00                     -                        |.|
>
> token.c:328:tds_process_login_tokens()
> util.c:331:tdserror(0x11cce540, 0x12b67bd0, 20017, 115)
> dblib.c:7929:dbperror(0x12b67070, 20017, 115)
> dblib.c:7981:20017: "Unexpected EOF from the server"
> dblib.c:8002:"Unexpected EOF from the server", client returns 2 (INT_CANCEL)
> util.c:361:tdserror: client library returned TDS_INT_CANCEL(2)
> util.c:384:tdserror: returning TDS_INT_CANCEL(2)
> util.c:156:Changed query state from IDLE to DEAD
> token.c:337:looking for login token, got  0()
> token.c:122:tds_process_default_tokens() marker is 0()
> token.c:125:leaving tds_process_default_tokens() connection dead
> login.c:466:login packet accepted
> util.c:331:tdserror(0x11cce540, 0x12b67bd0, 20002, 0)
> dblib.c:7929:dbperror(0x12b67070, 20002, 0)
> dblib.c:7981:20002: "Adaptive Server connection failed"
> dblib.c:8002:"Adaptive Server connection failed", client returns 2 
> (INT_CANCEL)
> util.c:361:tdserror: client library returned TDS_INT_CANCEL(2)
> util.c:384:tdserror: returning TDS_INT_CANCEL(2)
> dblib.c:1443:dbclose(0x12b67070)
> dblib.c:258:dblib_del_connection(0x2b8682d37620, 0x12b67bd0)
> mem.c:615:tds_free_all_results()
> dblib.c:305:dblib_release_tds_ctx(1)
> dblib.c:5882:dbfreebuf(0x12b67070)
> dblib.c:739:dbloginfree(0x12b26a70)
> dblib.c:3999:dbsettime(60)
> dblib.c:3999:dbsettime(60)
> dblib.c:1512:dbexit(void)
> dblib.c:305:dblib_release_tds_ctx(1)
>
> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org 
> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Frediano Ziglio
> Sent: 14 July 2012 12:16
> To: FreeTDS Development Group
> Subject: Re: [freetds] Cpanel
>
> You should "merge" info from our UserGuide and your information for cpanel.
>
> Frediano
>
> 2012/7/13 Simon Jones <Simon AT saq.net>:
>> I'm trying to configure freetds on a cpanel server, some documentation 
>> does exist but it's quite old now.  Does anyone have a newer howto?
>>
>> I have installed and configured freetds with the default settings but 
>> don't have /opt/freetds on my x64 system.
>>
>> Thanks.
>>
>> Simon
>>
>> _______________________________________________
>> FreeTDS mailing list
>> FreeTDS AT lists.ibiblio.org
>> http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds