FreeTDS Development Group

[Randy Syring <rsyring AT gmail.com>]

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