[freetds] php mssql_connect() without section name in freetds.conf

Muresanu A.V. (Andrei Valentin) andrei.muresanu at ing.ro
Fri Feb 5 11:49:14 EST 2016


Doesn't work. It's the same as not mentioning the port at all. Tries on port 4000 instead:

20009: "Unable to connect: Adaptive Server is unavailable or does not exist"

log.c:196:Starting log file for FreeTDS 0.91
        on 2016-02-05 18:46:24 with debug flags 0x4fff.
iconv.c:330:tds_iconv_open(0x2b9bfd0, UTF-8)
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 "UTF-8"
iconv.c:351:preparing iconv for "UTF-8" <-> "UCS-2LE" conversion
iconv.c:391:preparing iconv for "ISO-8859-1" <-> "UCS-2LE" conversion
iconv.c:394:tds_iconv_open: done
net.c:205:Connecting to 10.98.97.95 port 4000 (TDS version 7.1)
net.c:270:tds_open_socket: connect(2) returned "Operation now in progress"
net.c:316:tds_open_socket() failed
util.c:331:tdserror(0x2a89fa0, 0x2b9bfd0, 20009, 115)
dblib.c:7906:dbperror(0x2b9b5f0, 20009, 115)
dblib.c:7958:20009: "Unable to connect: Adaptive Server is unavailable or does not exist"
dblib.c:7979:"Unable to connect: Adaptive Server is unavailable or does not exist", 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:1424:dbclose(0x2b9b5f0)
dblib.c:258:dblib_del_connection(0x7fe324a6b1a0, 0x2b9bfd0)
mem.c:615:tds_free_all_results()
dblib.c:305:dblib_release_tds_ctx(1)
dblib.c:5859:dbfreebuf(0x2b9b5f0)
dblib.c:724:dbloginfree(0x2b9b020)
dblib.c:1493:dbexit(void)
dblib.c:305:dblib_release_tds_ctx(1)

-----Original Message-----
From: FreeTDS [mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of jezekj at centrum.cz
Sent: Friday, February 05, 2016 6:19 PM
To: FreeTDS Development Group
Subject: Re: [freetds] php mssql_connect() without section name in freetds.conf

Not sure, but in old Sybase times port has been delimited by space. i.e. "10.98.97.96 62220". Maybe I'm totally wrong here, but give it a try.

JJ

5. února 2016 10:27:12 CET, "Muresanu A.V. (Andrei Valentin)" <andrei.muresanu at ing.ro> napsal:
>Hi,
>
>anybody have any idea with the following ?
>
>Does not work, gives 'Unknown host machine name'. Even with tds version 
>= 7.0... 7.1, 8, etc..:
>
>$link = mssql_connect("10.98.97.96:62220", 'user', 'pass');
>
>Works because there is a section in freetds.conf named 'dasdswh':
>
>$link = mssql_connect('dasdswh', 'user', 'pass');
>
>$ php -v
>PHP 5.5.21 (cli) (built: Jun 10 2015 05:26:44) Copyright (c) 1997-2014 
>The PHP Group Zend Engine v2.5.0, Copyright (c) 1998-2014 Zend 
>Technologies with Zend OPcache v7.0.4-dev, Copyright (c) 1999-2014, by 
>Zend Technologies
>
>Trace log:
>
>16:55:35.585240 15567 (log.c:196):Starting log file for FreeTDS 0.91
>        on 2016-02-04 16:55:35 with debug flags 0xffff.
>16:55:35.585295 15567 (iconv.c:330):tds_iconv_open(0x2569f10, UTF-8)
>16:55:35.585508 15567 (iconv.c:187):local name for ISO-8859-1 is
>ISO-8859-1
>16:55:35.585528 15567 (iconv.c:187):local name for UTF-8 is UTF-8
>16:55:35.585542 15567 (iconv.c:187):local name for UCS-2LE is UCS-2LE
>16:55:35.585560 15567 (iconv.c:187):local name for UCS-2BE is UCS-2BE
>16:55:35.585578 15567 (iconv.c:349):setting up conversions for client 
>charset "UTF-8"
>16:55:35.585590 15567 (iconv.c:351):preparing iconv for "UTF-8" <-> 
>"UCS-2LE" conversion
>16:55:35.585610 15567 (iconv.c:391):preparing iconv for "ISO-8859-1"
><-> "UCS-2LE" conversion
>16:55:35.585635 15567 (iconv.c:394):tds_iconv_open: done
>16:55:35.585647 15567 (util.c:331):tdserror(0x245d490, 0x2569f10, 
>20013, 0)
>16:55:35.585666 15567 (dblib.c:7906):dbperror(0x2569530, 20013, 0)
>16:55:35.585681 15567 (dblib.c:7958):20013: "Unknown host machine name"
>16:55:35.585717 15567 (dblib.c:7979):"Unknown host machine name", 
>client returns 2 (INT_CANCEL)
>16:55:35.585734 15567 (util.c:361):tdserror: client library returned
>TDS_INT_CANCEL(2)
>16:55:35.585751 15567 (util.c:384):tdserror: returning
>TDS_INT_CANCEL(2)
>16:55:35.585766 15567 (login.c:417):IP address pointer is empty
>16:55:35.585776 15567 (login.c:419):Server 10.98.97.96:62220 not found!
>16:55:35.585795 15567 (dblib.c:1424):dbclose(0x2569530)
>16:55:35.585815 15567
>(dblib.c:258):dblib_del_connection(0x7f78f16cd800, 0x2569f10)
>16:55:35.585862 15567 (mem.c:615):tds_free_all_results()
>16:55:35.585890 15567 (dblib.c:305):dblib_release_tds_ctx(1)
>16:55:35.585909 15567 (dblib.c:5859):dbfreebuf(0x2569530)
>16:55:35.592809 15567 (dblib.c:724):dbloginfree(0x2569510)
>16:55:35.594342 15567 (dblib.c:1493):dbexit(void)
>16:55:35.594378 15567 (dblib.c:305):dblib_release_tds_ctx(1)
>
>----------------------------------------------------------------
>ATTENTION:
>The information in this e-mail is confidential and only meant for the 
>intended recipient. If you are not the intended recipient , don't use 
>or disclose it in anyway. Please let the sender know and delete the 
>message immediately.
>-----------------------------------------------------------------------
>-------------------------------
>
>
>_______________________________________________
>FreeTDS mailing list
>FreeTDS at lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds

--
Odesláno z mého telefonu s Androidem pomocí pošty K-9 Mail. Omluvte prosím moji stručnost.
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

------------------------------------------------------------------------------------------------------
ATTENTION:
The information in this e-mail is confidential and only meant for the intended recipient. If you are not the intended recipient , don't use or disclose it in anyway. Please let the sender know and delete the message immediately.
------------------------------------------------------------------------------------------------------



More information about the FreeTDS mailing list