[freetds] Problem accessing my DB using PHP 5.1.2

marc-olivier.meunier at bt.com marc-olivier.meunier at bt.com
Sun Feb 19 00:32:48 EST 2006


Thanks !!

You gave me the right hint ! It was a port problem...
Surprisingly it didn't change anything whether I set the port in the freetds.conf file or not... 
Anyway, I just changed the connection string to : blabla.xxxxxx.com:1433 ... And it's working :)

Thanks again !

--
Marc-Olivier Meunier
 

> -----Original Message-----
> From: freetds-bounces at lists.ibiblio.org 
> [mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of 
> ?????? ??????? ?????????
> Sent: samedi 18 février 2006 20:10
> To: FreeTDS Development Group
> Subject: Re: [freetds] Problem accessing my DB using PHP 5.1.2
> 
> yes, Mark, I have one...
> analyzing your log I have seen a strange port number (4000).
> ...
> Connecting to 193.149.115.38 port 4000, TDS 4.2.
> ...
> usually it is pointing to problem with wrong or misconfigured 
> freetds environment by several reasons:
> 1) actual php user cann't read freetds.conf. (unproper chown/chmod )
> 2) freetds library was compiled/configured with wrong path to 
> freetds.conf
> 3) freetds.conf has wrong parameters
> try to set FREETDSCONF and TDSCONFDUMP as mentioned in UG. 
> 
> Sincerely yours. 
> -------------------------------------------------------
> Vitaly Zverev, OCP DBA 8&8i
> Oracle E-Business Suite &
> Infiniband Linux Cluster Administrator
> Genesis Ltd., St.Petersburg, Russia
>  
> 
> 
> ________________________________
> 
> 	From: freetds-bounces at lists.ibiblio.org 
> [mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of 
> marc-olivier.meunier at bt.com
> 	Sent: Saturday, February 18, 2006 7:51 PM
> 	To: freetds at lists.ibiblio.org
> 	Subject: RE : [freetds] Problem accessing my DB using PHP 5.1.2
> 	
> 	
> 	thanks for your answer
> 	 
> 	i've tried that as well but it's not working...
> 	anyway i'm trying to migrate a new machine which was 
> using freetds and the former configuration did not use 
> MyServer2k... so it should work as well....
> 	 
> 	any other idea ???.... 
> 
> 		-------- Message d'origine-------- 
> 		De: freetds-bounces at lists.ibiblio.org de la 
> part de Зверев Виталий Борисович 
> 		Date: sam. 18/02/2006 11:38 
> 		À: FreeTDS Development Group 
> 		Cc: 
> 		Objet: Re: [freetds] Problem accessing my DB 
> using PHP 5.1.2
> 		
> 		
> 
> 		Hi Marc-Olivier Meunier,
> 		Perhaps php connect should be: $sql_id = 
> mssql_connect("MyServer2k","OIS","OIS");
> 		(look at reference in UG 
> http://www.freetds.org/userguide/freetdsconf.htm#FREETDSCONFPURPOSE)
> 		
> 		Sincerely yours.
> 		-------------------------------------------------------
> 		Vitaly Zverev, OCP DBA 8&8i
> 		Oracle E-Business Suite &
> 		Infiniband Linux Cluster Administrator
> 		Genesis Ltd., St.Petersburg, Russia
> 		
> 		
> 		
> 		> -----Original Message-----
> 		> From: freetds-bounces at lists.ibiblio.org
> 		> [mailto:freetds-bounces at lists.ibiblio.org] On 
> Behalf Of
> 		> marc-olivier.meunier at bt.com
> 		> Sent: Friday, February 17, 2006 8:54 PM
> 		> To: freetds at lists.ibiblio.org
> 		> Subject: [freetds] Problem accessing my DB 
> using PHP 5.1.2
> 		>
> 		> Hi,
> 		>
> 		> I've just compiled a brand new php 5.1.2 with 
> oracle, mysql
> 		> and freetds support but I cannot connect to 
> my SQL Server boxes...
> 		> I just get Warning telling this :
> 		> Warning: mssql_connect() 
> [function.mssql-connect]: Unable to
> 		> connect to
> 		> server: grishka.xxxxxxx.fr in
> 		> 
> /usr/local/www/gulussa/htdocs/OIS/inc/get_config.php on line 3
> 		>
> 		> I can connect easily with tsql and execute 
> sp_helpdb on my database...
> 		>
> 		> Here is the ./configure for compiling freetds 
> : ./configure
> 		> --prefix=/usr/local/freetds ...
> 		> Here is the ./configure for php : ./configure
> 		> 
> --with-oci8=instantclient,/usr/lib/oracle/10.2.0.1/client/lib/
> 		> --with-mysql=/usr/local/mysql --with-ldap --with-xml
> 		> --with-zlib --with-mssql=/usr/local/freetds
> 		> --enable-track-vars --with-gd --enable-sigchild
> 		> --with-apxs2=/opt/apache/apache_2.0.55/bin/apxs
> 		> --enable-soap --without-sqlite
> 		>
> 		> I've copied the file freetds.conf at /usr/local/etc/
> 		>
> 		> Here is the freetds.log :
> 		>
> 		> 18:19:40.541019 Starting log file for FreeTDS 0.63
> 		>         on 2006-02-17 18:19:40 with debug level 99.
> 		> 18:19:40.541344 names for ISO-8859-1: ISO-8859-1
> 		> 18:19:40.541372 names for UTF-8: UTF-8
> 		> 18:19:40.541390 names for UCS-2LE: UCS-2LE
> 		> 18:19:40.541406 names for UCS-2BE: UCS-2BE
> 		> 18:19:40.541433 iconv to convert client-side 
> data to the "ISO-8859-1"
> 		> character set
> 		> 18:19:40.541485 tds_iconv_info_init: converting
> 		> "ISO-8859-1"->"UCS-2LE"
> 		> 18:19:40.541526 Connecting to 193.149.115.38 
> port 4000, TDS 4.2.
> 		> 18:19:40.541779 Sending packet
> 		> 0000 02 00 02 00 00 00 00 00-67 75 6c 75 73 73 61 00
> 		> |........ gulussa.| 0010 00 00 00 00 00 00 00 
> 00-00 00 00 00
> 		> 00 00 00 00 |........ ........| 0020 00 00 00 
> 00 00 00 07
> 		> 4f-49 53 00 00 00 00 00 00 |.......O 
> IS......| 0030 00 00 00
> 		> 00 00 00 00 00-00 00 00 00 00 00 00 00 
> |........ ........|
> 		> 0040 00 00 00 00 00 03 4f 49-53 00 00 00 00 00 00 00
> 		> |......OI S.......| 0050 00 00 00 00 00 00 00 
> 00-00 00 00 00
> 		> 00 00 00 00 |........ ........| 0060 00 00 00 
> 00 03 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-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
> 		> 67 72 69 73 68-6b 61 2e 66 72 61 6e 63 
> |...grish ka.xxxxx|
> 		> 00c0 65 6e 65 74 2e 66 72 00-00 00 00 00 00 00 00 00
> 		> |xxxx.fr. ........| 00d0 00 14 4f 49 53 00 00 
> 00-00 00 00 00
> 		> 00 00 00 00 |..OIS... ........| 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 03 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...... ........|
> 		>
> 		> 18:19:40.542167 TDS: Write failed in tds_write_packet
> 		> Error: 111 (Connection refused)
> 		> 18:19:40.545733 tds_client_msg: #20006: 
> "Write to SQL Server failed.".
> 		> Connection state is now 0.
> 		> 18:19:40.545780 tds_process_login_tokens() 
> 18:19:40.545800
> 		> looking for login token, got  0()
> 		> 18:19:40.545825 tds_process_default_tokens() 
> marker is 0()
> 		> 18:19:40.545844 leaving 
> tds_process_default_tokens() connection dead
> 		> 18:19:40.545863 tds_client_msg: #20014: 
> "Login incorrect.". 
> 		> Connection state is now 4.
> 		> 18:19:40.545882 tds_free_all_results()
> 		> [root at gulussa tmp]#
> 		>
> 		> I've checked my connect string which looks ok... :
> 		>
> 		> $sql_id = 
> mssql_connect("grishka.xxxxxxx.fr","OIS","OIS");
> 		>
> 		> Here is my freetds.conf file :
> 		>
> 		> [global]
> 		>         # TDS protocol version
> 		>         tds version = 4.2
> 		>         dump file = /tmp/freetds.log
> 		>         debug level = 10
> 		>         text size = 64512
> 		>
> 		> [MyServer2k]
> 		>         host = grishka.xxxxxxxxx.fr
> 		>         port = 1433
> 		>         tds version = 8.0
> 		>
> 		> I've set mssql.textlimit and mssql.textsize 
> to 409600...
> 		>
> 		> Anything else to add ???
> 		>
> 		> Should I strace the process ????
> 		>
> 		> I'm getting crazy... :(
> 		>
> 		>
> 		>
> 		> --
> 		> Marc-Olivier Meunier
> 		> _______________________________________________
> 		> FreeTDS mailing list
> 		> FreeTDS at lists.ibiblio.org
> 		> http://lists.ibiblio.org/mailman/listinfo/freetds
> 		>
> 		_______________________________________________
> 		FreeTDS mailing list
> 		FreeTDS at lists.ibiblio.org
> 		http://lists.ibiblio.org/mailman/listinfo/freetds
> 		
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> 


More information about the FreeTDS mailing list