[freetds] PHP4.3.8 & freetds v0.62.4 but: mssql_connect(): Write to
Ingo Klein
klein at zentraldata.de
Mon Dec 20 11:14:15 EST 2004
Salute !
Thank You for helping, freddy77!
> Did you use php from command line or using Apache? apache work using a
> different user so your ~/.freetds.conf won't be read.
Yes, the freetds.conf was only for root.
But now other problem occurs:
> We don't recommend to use TDS version 4.2 (if you don't have mssql
> 6.x...), see UserGuide on site.
(I've tyed it with 4.2 and 7.0: the same problem;
all the other (mssql)server-connection on another webserver run with 4.2 fine)
Problem:
$dbproc = mssql_pconnect("hemera","test","test")or
die('Error:'.mssql_get_last_message());
results in:
Error:Changed database context to 'master'.
And my log-file (there was the same problem) sayed now: see below.
It seems that "Change database" is the last action there
the end of log is:
17:07:35.555679 UNIMPLEMENTED dbsetopt(option = 7)
And I can'nt establish the connection correctly.
Tanks a lot for helping (in advance)!
Also denne, bis denne, viel Spasz noch, Ingo Klein.
----------------------------------------------
Starting log file for FreeTDS 0.62.4
on 2004-12-20 17:07:35 with debug level 99.
names for ISO-8859-1: ISO-8859-1
names for UTF-8: UTF-8
names for UCS-2LE: UCS-2LE
names for UCS-2BE: UCS-2BE
iconv to convert client-side data to the "ISO-8859-1" character set
17:07:35.479040 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
17:07:35.479080 Connecting to 1.1.1.215 port 1433, TDS 4.2.
Sending packet @ 17:07:35.479584
0000 02 00 02 00 00 00 00 00-67 64 69 34 31 00 00 00 |........ gdi41...|
0010 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0020 00 00 00 00 00 00 05 74-65 73 74 00 00 00 00 00 |.......t est.....|
0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0040 00 00 00 00 00 04 74 65-73 74 00 00 00 00 00 00 |......te st......|
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 38-37 36 00 00 00 00 00 00 |.....378 76......|
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 02 00 |........ ........|
0090 00 00 00 00 50 48 50 20-34 2e 30 00 00 00 00 00 |....PHP 4.0.....|
00a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00b0 00 00 07 68 65 6d 65 72-61 00 00 00 00 00 00 00 |...hemer a.......|
00c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00d0 00 06 74 65 73 74 00 00-00 00 00 00 00 00 00 00 |..test.. ........|
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 04 04 02 00 00 44 42-2d 4c 69 62 72 61 72 79 |......DB -Library|
01e0 0a 00 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...... ........|
Sending packet @ 17:07:35.479859
0000 02 01 00 4c 00 00 00 00-00 00 00 00 00 00 0a 00 |...L.... ........|
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 34 30 39 |........ .....409|
0040 36 00 00 04 00 00 00 00-00 00 00 00 |6....... ....|
17:07:35.479933 tds_process_login_tokens()
Received header @ 17:07:35.555162
0000 04 01 00 9a 00 00 00 00- |........|
Received packet @ 17:07:35.555199
0000 e3 0f 00 01 06 6d 61 73-74 65 72 06 6d 61 73 74 |ã....mas ter.mast|
0010 65 72 ab 37 00 45 16 00-00 02 00 25 00 43 68 61 |er«7.E.. ...%.Cha|
0020 6e 67 65 64 20 64 61 74-61 62 61 73 65 20 63 6f |nged dat abase co|
0030 6e 74 65 78 74 20 74 6f-20 27 6d 61 73 74 65 72 |ntext to 'master|
0040 27 2e 06 48 45 4d 45 52-41 00 00 00 e3 09 00 03 |'..HEMER A...ã...|
0050 05 69 73 6f 5f 31 01 00-ad 20 00 01 04 02 00 00 |.iso_1.. ......|
0060 16 4d 69 63 72 6f 73 6f-66 74 20 53 51 4c 20 53 |.Microso ft SQL S|
0070 65 72 76 65 72 00 00 5f-07 00 ff e3 0b 00 04 04 |erver.._ ..ÿã....|
0080 34 30 39 36 04 34 30 39-36 fd 00 00 00 00 00 00 |4096.409 6ý......|
0090 00 00 - |..|
17:07:35.555293 looking for login token, got e3(ENVCHANGE)
17:07:35.555344 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 6 from wire to give 6 to client.
tds_get_string: reading 6 from wire to give 6 to client.
17:07:35.555378 looking for login token, got ab(INFO)
17:07:35.555390 tds_process_default_tokens() marker is ab(INFO)
tds_get_string: reading 37 from wire to give 37 to client.
tds_get_string: reading 6 from wire to give 6 to client.
17:07:35.555438 looking for login token, got e3(ENVCHANGE)
17:07:35.555451 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 5 from wire to give 5 to client.
tds_get_string: reading 1 from wire to give 1 to client.
17:07:35.555518 looking for login token, got ad(LOGINACK)
tds_get_string: reading 22 from wire to give 22 to client.
17:07:35.555540 looking for login token, got e3(ENVCHANGE)
17:07:35.555552 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 4 from wire to give 4 to client.
tds_get_string: reading 4 from wire to give 4 to client.
17:07:35.555577 increasing block size from 4096 to 4096
17:07:35.555599 looking for login token, got fd(DONE)
17:07:35.555612 tds_process_default_tokens() marker is fd(DONE)
17:07:35.555625 tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
17:07:35.555639 tds_process_end() state set to TDS_IDLE
17:07:35.555649 leaving tds_process_login_tokens() returning 1
17:07:35.555679 UNIMPLEMENTED dbsetopt(option = 7)
More information about the FreeTDS
mailing list