FreeTDS Development Group

["Thompson, Bill D (London)" <bill_d_thompson AT ml.com>]

OK this tells us two things:

1) we are looking in freetds.conf file in /etc/freetds/freetds.conf - is
this correct ?

2) when you go through PHP etc. (as opposed to using tsql ) we are not
trying to connect to server STJAMES, but server SYBASE !
    I assume this is being set somewhere external to freetds.
    We don't find server SYBASE anywhere in the freetds.conf, and never make
a connection....


Bill

> -----Original Message-----
> From: Samuel Luxford-Watts [SMTP:slwatts AT winckworths.co.uk]
> Sent: 09 September 2003 13:44
> To:   'FreeTDS Development Group'
> Subject:      RE: [freetds] mssql_connect fails using PHP4.3.3,
> freetds-0.61.2
> 
> Ok - the outputs are below - hope it helps!
> 
> Thanks
> 
> Sam
> 
> /tmp/freetds.log:
> Starting log file for FreeTDS 0.61.2 with debug level 99.
> 2003-09-08 22:51:24.695138 iconv will convert client-side data to the ""
> charact
> er set
> 2003-09-08 22:51:24.695183 IP address pointer is NULL
> 2003-09-08 22:51:24.695197 Server SYBASE not found!
> 
> /tmp/freetdsconfig.log
> linux:/etc/freetds # more /tmp/freetdsconf.log 
> Starting log file for FreeTDS 0.61.2 with debug level 99.
> 2003-09-08 22:51:24.684026 Attempting to read conf files.
> 2003-09-08 22:51:24.684055 ...$FREETDSCONF not set.  Trying $HOME.
> 2003-09-08 22:51:24.684777 Found conf file '/etc/freetds/freetds.conf'
> (default)
> . Reading section 'SYBASE'.
> 2003-09-08 22:51:24.684825 Looking for section global.
> 2003-09-08 22:51:24.684920 ... Found section global.
> 2003-09-08 22:51:24.684936 Got a match.
> 2003-09-08 22:51:24.684950 option = 'tds version' value = '7.0'.
> 2003-09-08 22:51:24.684967 option = 'swap broken dates' value = 'no'.
> 2003-09-08 22:51:24.684980 no is a 'no/off/false'.
> 2003-09-08 22:51:24.684995 option = 'swap broken money' value = 'no'.
> 2003-09-08 22:51:24.685008 no is a 'no/off/false'.
> 2003-09-08 22:51:24.685023 option = 'try server login' value = 'yes'.
> 2003-09-08 22:51:24.685037 yes is a 'yes/on/true'.
> 2003-09-08 22:51:24.685051 option = 'try domain login' value = 'no'.
> 2003-09-08 22:51:24.685064 no is a 'no/off/false'.
> 2003-09-08 22:51:24.685079 option = 'nt domain' value = 'wwp-s'.
> 2003-09-08 22:51:24.685095 option = 'cross domain login' value = 'no'.
> 2003-09-08 22:51:24.685108 no is a 'no/off/false'.
> 2003-09-08 22:51:24.685123 option = 'dump file' value =
> '/tmp/freetds.log'.
> 2003-09-08 22:51:24.685139 option = 'debug level' value = '10'.
> 2003-09-08 22:51:24.685157 option = 'text size' value = '64512'.
> 2003-09-08 22:51:24.685174 ... Found section jdbc.
> 2003-09-08 22:51:24.685191 ... Found section jdbc_42.
> 2003-09-08 22:51:24.685208 ... Found section mypool.
> 2003-09-08 22:51:24.685225 ... Found section stjames.
> 2003-09-08 22:51:24.685361 Looking for section sybase.
> 2003-09-08 22:51:24.685400 ... Found section global.
> 2003-09-08 22:51:24.685429 ... Found section jdbc.
> 2003-09-08 22:51:24.685446 ... Found section jdbc_42.
> 2003-09-08 22:51:24.685463 ... Found section mypool.
> 2003-09-08 22:51:24.685479 ... Found section stjames.
> 2003-09-08 22:51:24.685501 ...'SYBASE' not found.
> 2003-09-08 22:51:24.685558 Failed in reading conf file.  Trying interface
> files.
> 2003-09-08 22:51:24.685577 Looking for server....
> 2003-09-08 22:51:24.685948 Looking for server in
> /var/lib/nobody/.interfaces.
> 2003-09-08 22:51:24.685977 Searching interfaces file
> //var/lib/nobody/.interface
> s.
> 2003-09-08 22:51:24.686012 Couldn't open /var/lib/nobody/.interfaces.
> 2003-09-08 22:51:24.686028 Looking for server in /etc/freetds/interfaces.
> 2003-09-08 22:51:24.686042 Searching interfaces file
> /etc/freetds/interfaces.
> 2003-09-08 22:51:24.686064 Couldn't open /etc/freetds/interfaces.
> 2003-09-08 22:51:24.686078 Setting 'tmp_port' to 4000 as a guess.
> 2003-09-08 22:51:24.694632 Setting 'dump_file' to '/tmp/freetds.log' from
> $TDSDU
> MP.
> 
> -----Original Message-----
> From: Thompson, Bill D (London) [mailto:bill_d_thompson AT ml.com] 
> Sent: 09 September 2003 13:28
> To: 'FreeTDS Development Group'
> Subject: RE: [freetds] mssql_connect fails using PHP4.3.3, freetds-0.61.2
> 
> 
> Hi Samuel,
> 
> Lets see what's going on in a bit more detail.
> 
> First step might be to see what's going on behind the scenes with the
> freetds config.
> 
> If you set environment variable TDSDUMPCONFIG to point to a file
> (different
> from the TDSDUMP file) then we should be able to see how freetds is
> resolving your request to connect to your server. 
> 
> Try that and post the output.
> 
> 
> --------------
> Winckworth Sherwood Solicitors and Parliamentary Agents 
> DX 148400 WESTMINSTER 5 : 35 Great Peter Street, London SW1P 3LR
> Telephone 020 7593 5000 Fax 020 7593 5099
> 
> Do something amazing! 
> The firm is supporting a charitable bike ride through Vietnam and needs
> your help. For further information please visit
> http://www.vietnambikeride.org
> 
> -Confidentiality- 
> This email message and any attachments are confidential; they may be
> subject to legal professional privilege and are intended for the named
> recipient only. If you are not the named recipient, please return the
> message and enclosures immediately and delete them from your system.
> 
> -Caution- 
> Before advice received only by email (whether by attachment or otherwise)
> may be relied on, the authenticity of the communication must be verified
> by means independent of email.
> 
> -Regulation- 
> The firm is regulated by the Law Society. 
> 
> -Partners- 
> A list of partners is available for inspection at each office of the firm
> and on the firm's website at http://www.winckworths.co.uk
>  
> 
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds