Skip to Content.
Sympa Menu

freetds - Re: [freetds] Cpanel

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Randy Syring <rsyring AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Cpanel
  • Date: Tue, 17 Jul 2012 14:47:01 -0400

Simon,

I'd highly suggest you start here:

http://www.freetds.org/userguide/

(Unfortunately, website seems to be down at the moment.)

Read it from start to finish. It will give you the context you need to understand the advice given.

I know reading the docs can be hard when you have a task to accomplish, but when I first started dealing with FreeTDS the userguide really helped me, once I took the time to read it.

---------------------------------------------
Randy Syring
Development & Executive Director
Level 12 Technologies <https://www.lev12.com/>
Direct: 502-276-0459
Office: 502-212-9913

Principled People, Technology that Works

On 07/17/2012 02:35 PM, Simon Jones wrote:
Thanks, where can I download 7? There's only 6.4 and then 8.x in the
download site. Also I removed freetds by make uninstall but there was still
a version on the server, I deleted the /usr/local/freetds dir tree then
./configure and make installed 8.4 but it doesn't recreate the installation
directories. Do I need to do something else?

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Igor Korot
Sent: 17 July 2012 18:37
To: FreeTDS Development Group
Subject: Re: [freetds] Cpanel

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 x.x.x.x 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
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 |...
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 |....
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
_______________________________________________
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