FreeTDS Development Group

[Samuel Luxford-Watts <slwatts AT winckworths.co.uk>]

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