Skip to Content.
Sympa Menu

freetds - Re: [freetds] Cpanel

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Simon Jones <Simon AT saq.net>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Cpanel
  • Date: Tue, 17 Jul 2012 10:21:52 +0000

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)
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




Archive powered by MHonArc 2.6.24.

Top of Page