Re: Cpanel
Randy Syring <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
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: [email protected] [mailto:[email protected]] 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 <[email protected]> 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: [email protected] >> [mailto:[email protected]] 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 <[email protected]>: >>> 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 >>> [email protected] >>> http://lists.ibiblio.org/mailman/listinfo/freetds >> _______________________________________________ >> FreeTDS mailing list >> [email protected] >> http://lists.ibiblio.org/mailman/listinfo/freetds >> _______________________________________________ >> FreeTDS mailing list >> [email protected] >> http://lists.ibiblio.org/mailman/listinfo/freetds > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds >