Skip to Content.
Sympa Menu

freetds - AW: AW: AW: AW: [freetds] connect problem to mssql 7.0

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Roland Bole" <roland.bole AT gmx.at>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: AW: AW: AW: AW: [freetds] connect problem to mssql 7.0
  • Date: Sat, 20 Dec 2003 15:50:23 +0100


> I have also established connections, see netstat -ap according to the PID
>
> ------------
> tcp 0 0 xxx.xxx.xxx.xxx:34061 elbefs01:1433
> ESTABLISHED 18597/httpd
> tcp 0 0 xxx.xxx.xxx.xxx:www 81-223-154-70.dyna:4529
> ESTABLISHED 18597/httpd
> ------------
>

Good! Also note that connection is ESTABLISHED so nobody close it.

> Why mssql_pconnect returns false ????
>
...
>
> Mysql_pconnect have to connect, because: I can see it in the freetds.log
>
> --
> iconv to convert client-side data to the "ISO-8859-1" character set
> 07:36:57.763837 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
> 07:36:57.763998 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
> 07:36:57.764078 Connecting to xxx.xxx.xxx.xxx port 1433, TDS 7.0.
> ---
> There is no error
>

>>Well this part of log tell me that FreeTDS tried to connect... Perhaps
>>some more lines can help me more...

This the full output

----------------------------------------
Starting log file for FreeTDS 0.62.dev.20031218
on 2003-12-20 09:55:04 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
09:55:04.102590 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
09:55:04.102753 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
09:55:04.102830 Connecting to 192.168.1.13 port 1433, TDS 7.0.
09:55:04.107303 tds_put_string converting 3 bytes of "xxx"
09:55:04.107402 tds_put_string wrote 6 bytes
09:55:04.107454 tds_put_string converting 11 bytes of "xxx"
09:55:04.107509 tds_put_string wrote 22 bytes
09:55:04.107565 tds_put_string converting 7 bytes of "PHP 4.0"
09:55:04.107621 tds_put_string wrote 14 bytes
09:55:04.107668 tds_put_string converting 12 bytes of "xxx.xxx.xxx.xxx"
09:55:04.107722 tds_put_string wrote 24 bytes
09:55:04.107769 tds_put_string converting 10 bytes of "DB-Library"
09:55:04.107822 tds_put_string wrote 20 bytes
09:55:04.107870 tds_put_string converting 10 bytes of "us_english"
09:55:04.107923 tds_put_string wrote 20 bytes
09:55:04.107970 tds_put_string wrote 0 bytes
09:55:04.108074 tds_process_login_tokens()
Received header @ 09:55:04.109762
0000 04 01 01 9c 00 00 00 00- |........|


Received packet @ 09:55:04.109871
0000 e3 17 00 01 04 45 00 4c-00 42 00 45 00 06 6d 00 |.....E.L .B.E..m.|
0010 61 00 73 00 74 00 65 00-72 00 ab 66 00 45 16 00 |a.s.t.e. r..f.E..|
0020 00 02 00 25 00 44 00 61-00 74 00 65 00 6e 00 62 |...%.D.a .t.e.n.b|
0030 00 61 00 6e 00 6b 00 6b-00 6f 00 6e 00 74 00 65 |.a.n.k.k .o.n.t.e|
0040 00 78 00 74 00 20 00 61-00 75 00 66 00 20 00 27 |.x.t. .a .u.f. .'|
0050 00 45 00 4c 00 42 00 45-00 27 00 20 00 67 00 65 |.E.L.B.E .'. .g.e|
0060 00 e4 00 6e 00 64 00 65-00 72 00 74 00 2e 00 08 |...n.d.e .r.t....|
0070 45 00 4c 00 42 00 45 00-46 00 53 00 30 00 31 00 |E.L.B.E. F.S.0.1.|
0080 00 00 00 e3 17 00 02 0a-75 00 73 00 5f 00 65 00 |........ u.s._.e.|
0090 6e 00 67 00 6c 00 69 00-73 00 68 00 00 ab 6a 00 |n.g.l.i. s.h...j.|
00a0 47 16 00 00 01 00 27 00-43 00 68 00 61 00 6e 00 |G.....'. C.h.a.n.|
00b0 67 00 65 00 64 00 20 00-6c 00 61 00 6e 00 67 00 |g.e.d. . l.a.n.g.|
00c0 75 00 61 00 67 00 65 00-20 00 73 00 65 00 74 00 |u.a.g.e. .s.e.t.|
00d0 74 00 69 00 6e 00 67 00-20 00 74 00 6f 00 20 00 |t.i.n.g. .t.o. .|
00e0 75 00 73 00 5f 00 65 00-6e 00 67 00 6c 00 69 00 |u.s._.e. n.g.l.i.|
00f0 73 00 68 00 2e 00 08 45-00 4c 00 42 00 45 00 46 |s.h....E .L.B.E.F|
0100 00 53 00 30 00 31 00 00-00 00 e3 0f 00 03 05 69 |.S.0.1.. .......i|
0110 00 73 00 6f 00 5f 00 31-00 01 00 00 e3 0b 00 05 |.s.o._.1 ........|
0120 04 31 00 30 00 33 00 33-00 00 e3 0f 00 06 06 31 |.1.0.3.3 .......1|
0130 00 39 00 36 00 36 00 30-00 39 00 00 ad 36 00 01 |.9.6.6.0 .9...6..|
0140 07 00 00 00 16 4d 00 69-00 63 00 72 00 6f 00 73 |.....M.i .c.r.o.s|
0150 00 6f 00 66 00 74 00 20-00 53 00 51 00 4c 00 20 |.o.f.t. .S.Q.L. |
0160 00 53 00 65 00 72 00 76-00 65 00 72 00 00 00 00 |.S.e.r.v .e.r....|
0170 00 07 00 02 bb e3 13 00-04 04 34 00 30 00 39 00 |........ ..4.0.9.|
0180 36 00 04 34 00 30 00 39-00 36 00 fd 00 00 00 00 |6..4.0.9 .6......|
0190 00 00 00 00 - |....|


09:55:04.110788 looking for login token, got e3(ENVCHANGE)
09:55:04.110845 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 8 from wire to give 4 to client.
tds_get_string: reading 12 from wire to give 6 to client.
09:55:04.111009 looking for login token, got ab(INFO)
09:55:04.111060 tds_process_default_tokens() marker is ab(INFO)
tds_get_string: reading 74 from wire to give 37 to client.
tds_get_string: reading 16 from wire to give 8 to client.
09:55:04.111218 looking for login token, got e3(ENVCHANGE)
09:55:04.111272 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 20 from wire to give 10 to client.
09:55:04.111369 looking for login token, got ab(INFO)
09:55:04.111420 tds_process_default_tokens() marker is ab(INFO)
tds_get_string: reading 78 from wire to give 39 to client.
tds_get_string: reading 16 from wire to give 8 to client.
09:55:04.111649 looking for login token, got e3(ENVCHANGE)
09:55:04.111705 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 10 from wire to give 5 to client.
tds_get_string: reading 2 from wire to give 1 to client.
09:55:04.111900 looking for login token, got e3(ENVCHANGE)
09:55:04.111956 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 8 from wire to give 4 to client.
09:55:04.112051 looking for login token, got e3(ENVCHANGE)
09:55:04.112103 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 12 from wire to give 6 to client.
09:55:04.112197 looking for login token, got ad(LOGINACK)
tds_get_string: reading 44 from wire to give 22 to client.
09:55:04.112293 looking for login token, got e3(ENVCHANGE)
09:55:04.112344 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 8 from wire to give 4 to client.
tds_get_string: reading 8 from wire to give 4 to client.
09:55:04.112476 increasing block size from 4096 to 4096
09:55:04.112559 looking for login token, got fd(DONE)
09:55:04.112615 tds_process_default_tokens() marker is fd(DONE)
09:55:04.112666 tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
09:55:04.112721 tds_process_end() state set to TDS_IDLE
09:55:04.112768 leaving tds_process_login_tokens() returning 1
09:55:04.112837 tds_put_string converting 19 bytes of "set textsize 64512 "
09:55:04.112894 tds_put_string wrote 38 bytes
Sending packet @ 09:55:04.112945
0000 01 01 00 2e 00 00 01 00-73 00 65 00 74 00 20 00 |........ s.e.t. .|
0010 74 00 65 00 78 00 74 00-73 00 69 00 7a 00 65 00 |t.e.x.t. s.i.z.e.|
0020 20 00 36 00 34 00 35 00-31 00 32 00 20 00 | .6.4.5. 1.2. .|


Received header @ 09:55:04.114631
0000 04 01 00 11 00 00 00 00- |........|


Received packet @ 09:55:04.114737
0000 fd 00 00 be 00 00 00 00-00 |........ .|


09:55:04.114813 processing result tokens. marker is fd(DONE)
09:55:04.114863 tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
09:55:04.114918 tds_process_end() state set to TDS_IDLE
09:55:04.114965 tds_process_result_tokens() state is COMPLETED
09:55:04.115068 UNIMPLEMENTED dbsetopt(option = 7)
-------------------------------------

>>Is written IP right ??

Yes




> And also php last function: mssql_get_last_message()
> Give me the following message:
>
> Changed language setting to us_english.
>
> So there must be a connect ???? Is this right????
>

It seems so, sql server return this message AFTER connection...

> BUT PHP can not make a "true" connection, because mysql_pconnect returns
> false.
>
> Tsgl can connect successfully and I can also make some sql queries.
>

>>I think you mean tsql here...


Yes



> $db_conn = mssql_pconnect ($sql_host,$sql_user,$sql_pass) or
> die ("Could not connect to database: ".mssql_get_last_message());
>
> $sql_host,$sql_user,$sql_pass have the right values like I use in tsgl,
> that´s OK,
>
> The question is: why php can not return true, if there is a connect (see
> freetds.log)
>
> The only error which is reported is during the ececution of the query with
> tsgl:
> -----------
> ZUM ZAUCHNERWIRT
> ZUPAN PATRICIA
> Msg 2403, Level 16, State 0, Server OpenClient, Line 0
> WARNING! Some character(s) could not be converted into client's character
> set. Unconverted bytes were changed to question marks ('?').
> Z?RICH KOSMOS
> ------------------
>

>> This is NOT an error !!
Yes, but if I have some Ö Ä and so an I got ?




>
> what can I do ?????
>

>>I don't know...

New installation of the debian box on Monday.



>freddy77


Roland

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds







Archive powered by MHonArc 2.6.24.

Top of Page