Bug #74477 [NoF->Opn]: can not connect to sybase with pdo_dblib

Edit report at https://bugs.php.net/bug.php?id=74477&edit=1 ID: 74477 Updated by: requinix@php.net Reported by: fuzzywy at 163 dot com Summary: can not connect to sybase with pdo_dblib -Status: No Feedback +Status: Open Type: Bug Package: PDO DBlib Operating System: centos7 PHP Version: 7.1.4 Block user comment: N Private report: N Previous Comments: ------------------------------------------------------------------------ [2017-05-08 08:45:26] fuzzywy at 163 dot com I can't change the stat, while still need feedback ------------------------------------------------------------------------ [2017-05-07 04:22:37] php-bugs at lists dot php dot net No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Re-Opened". Thank you. ------------------------------------------------------------------------ [2017-05-02 02:11:39] fuzzywy at 163 dot com FYI, thanks! -------------------------------------------------- log.c:196:Starting log file for FreeTDS 0.91 on 2017-05-02 01:50:40 with debug flags 0x4fff. iconv.c:330:tds_iconv_open(0x329e160, 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" <-> "ISO-8859-1" conversion iconv.c:394:tds_iconv_open: done net.c:205:Connecting to 7.140.28.88 port 26401 (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-70 72 6f 6d 6f 74 65 2e |........ promote.| 0010 63 61 63 68 65 2d 64 6e-73 2e 6c 6f 63 61 6c 00 |cache-dn s.local.| 0020 00 00 00 00 00 00 17 64-63 62 6f 00 00 00 00 00 |.......d cbo.....| 0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........| 0040 00 00 00 00 00 04 64 63-62 6f 00 00 00 00 00 00 |......dc bo......| 0050 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........| 0060 00 00 00 00 04 33 37 35-33 00 00 00 00 00 00 00 |.....375 3.......| 0070 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........| 0080 00 00 00 04 03 01 06 0a-09 01 00 00 00 00 00 00 |........ ........| 0090 00 00 00 00 50 48 50 20-66 72 65 65 74 64 73 00 |....PHP freetds.| 00a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........| 00b0 00 00 0b 37 2e 31 34 30-2e 32 38 2e 38 38 3a 32 |...7.140 .28.88:2| 00c0 36 34 30 31 00 00 00 00-00 00 00 00 00 00 00 00 |6401.... ........| 00d0 00 11 00 04 64 63 62 6f-00 00 00 00 00 00 00 00 |....dcbo ........| 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 06 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 75 74 66 |........ .....utf| 0020 38 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |8....... ........| 0030 00 00 00 00 00 00 00 00-00 00 00 04 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() net.c:555:Received header 0000 04 01 00 59 00 00 00 00- |...Y....| net.c:609:Received packet 0000 04 01 00 59 00 00 00 00-e3 07 00 03 04 75 74 66 |...Y.... .....utf| 0010 38 00 e3 09 00 04 03 35-31 32 03 35 31 32 ad 16 |8......5 12.512..| 0020 00 05 05 00 00 00 0c 53-51 4c 20 41 6e 79 77 68 |.......S QL Anywh| 0030 65 72 65 10 00 00 00 e2-16 00 01 09 00 08 0e 61 |ere..... .......a| 0040 01 ff ff fe e6 02 09 07-fe 3f 9e e6 68 00 00 0a |........ .?..h...| 0050 fd 00 00 01 00 7c 89 19-00 |.....|.. .| token.c:337:looking for login token, got e3(ENVCHANGE) token.c:122:tds_process_default_tokens() marker is e3(ENVCHANGE) token.c:2493:server indicated charset change to "utf8" iconv.c:988:setting server single-byte charset to "UTF-8" dblib.c:327:db_env_chg(0x329e160, 3, , utf8) token.c:337:looking for login token, got e3(ENVCHANGE) token.c:122:tds_process_default_tokens() marker is e3(ENVCHANGE) token.c:2477:changing block size from 512 to 512 dblib.c:327:db_env_chg(0x329e160, 4, 512, 512) token.c:337:looking for login token, got ad(LOGINACK) token.c:373:server reports TDS version 5.0.0.0 token.c:375:Product name for 0x5000000 is unknown token.c:337:looking for login token, got e2(CAPABILITY) token.c:122:tds_process_default_tokens() marker is e2(CAPABILITY) token.c:337:looking for login token, got fd(DONE) token.c:122:tds_process_default_tokens() marker is fd(DONE) token.c:2339:tds_process_end: more_results = 0 was_cancelled = 0 error = 0 done_count_valid = 0 token.c:2355:tds_process_end() state set to TDS_IDLE token.c:2370: rows_affected = 1673596 token.c:438:tds_process_login_tokens() returning TDS_SUCCEED mem.c:615:tds_free_all_results() util.c:156:Changed query state from IDLE to QUERYING util.c:156:Changed query state from QUERYING to PENDING net.c:741:Sending packet 0000 0f 01 00 2c 00 00 00 00-21 1f 00 00 00 00 73 65 |...,.... !.....se| 0010 74 20 74 65 78 74 73 69-7a 65 20 36 34 35 31 32 |t textsi ze 64512| 0020 20 75 73 65 20 5b 64 77-68 64 62 5d | use [dw hdb]| token.c:540:tds_process_tokens(0x329e160, 0x7fff3db37d64, 0x7fff3db37d60, 0x100) util.c:156:Changed query state from PENDING to READING net.c:555:Received header 0000 04 01 00 63 00 00 00 00- |...c....| net.c:609:Received packet 0000 04 01 00 63 00 00 00 00-e5 4f 00 66 00 00 00 00 |...c.... .O.f....| 0010 0f 05 34 32 57 30 34 00-01 00 3a 00 53 51 4c 20 |..42W04. ..:.SQL | 0020 41 6e 79 77 68 65 72 65-20 45 72 72 6f 72 20 2d |Anywhere Error -| 0030 31 33 31 3a 20 53 79 6e-74 61 78 20 65 72 72 6f |131: Syn tax erro| 0040 72 20 6e 65 61 72 20 27-75 73 65 27 20 6f 6e 20 |r near ' use' on | 0050 6c 69 6e 65 20 31 00 00-00 00 fd 02 00 01 00 00 |line 1.. ........| 0060 00 00 00 - |...| token.c:555:processing result tokens. marker is e5(EED) token.c:122:tds_process_default_tokens() marker is e5(EED) token.c:2588:tds_process_msg() reading message 102 from server token.c:2661:tds_process_msg() calling client msg handler dbutil.c:85:_dblib_handle_info_message(0x32933f0, 0x329e160, 0x7fff3db37bb0) dbutil.c:86:msgno 102: "SQL Anywhere Error -131: Syntax error near 'use' on line 1" dblib.c:5780:dbgetuserdata(0x329d660) dblib.c:5780:dbgetuserdata(0x329d660) token.c:2674:tds_process_msg() returning TDS_SUCCEED token.c:555:processing result tokens. marker is fd(DONE) token.c:2339:tds_process_end: more_results = 0 was_cancelled = 0 error = 1 done_count_valid = 0 token.c:2355:tds_process_end() state set to TDS_IDLE util.c:156:Changed query state from READING to IDLE token.c:2370: rows_affected = 0 util.c:104:logic error: cannot change query state from IDLE to PENDING token.c:540:tds_process_tokens(0x329e160, 0x7fff3db37d64, 0x7fff3db37d60, 0x100) token.c:543:tds_process_tokens() state is COMPLETED dblib.c:1443:dbclose(0x329d660) dblib.c:258:dblib_del_connection(0x7ff3a4ad0660, 0x329e160) mem.c:615:tds_free_all_results() util.c:156:Changed query state from IDLE to DEAD dblib.c:305:dblib_release_tds_ctx(1) dblib.c:5882:dbfreebuf(0x329d660) dblib.c:739:dbloginfree(0x329d490) dblib.c:1512:dbexit(void) dblib.c:305:dblib_release_tds_ctx(1) ------------------------------------------------------------------------ [2017-04-28 17:29:11] adambaratz@php.net Are you familiar with TDSDUMP environment variable? http://www.freetds.org/userguide/logging.htm Try doing this for both PHP versions: TDSDUMP="freetds.log" php -r "new PDO('dblib:host=7.140.28.88:26401;dbname=dwhdb','dcbo','dcbo');" If you share both log files, I might be able to help debug. ------------------------------------------------------------------------ [2017-04-25 00:56:46] fuzzywy at 163 dot com I've been aware of the issue so i checked the source code in 5.5.15 (in which version my program works well). https://github.com/php/php-src/blob/PHP-5.5.15/ext/pdo_dblib/dblib_driver.c It's same as the code in 7.1.4 that there's a comment in version 5.0。 And i also test it in 7.0.x, change the global tds version in my freetds.conf to 4.2, both can not work。 ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=74477 -- Edit this bug report at https://bugs.php.net/bug.php?id=74477&edit=1