FreeTDS Development Group

[Chris <ccortner AT cvol.net>]

I'm using the latest snapshot of freetds. Here is the output of the
configuration log. Also I set TDSDUMP="" to get a log from the apache
module. 

2002-11-14 14:32:40.101919 Attempting to read conf files.
2002-11-14 14:32:40.102182 ...$FREETDSCONF not set.  Trying $HOME.
2002-11-14 14:32:40.102538 Found conf file
'/usr/local/freetds/etc/freetds.conf' (default). Reading section
'0-ecpc-2'.
2002-11-14 14:32:40.102619 Looking for section global.
2002-11-14 14:32:40.102737 ... Found section global.
2002-11-14 14:32:40.102779 Got a match.
2002-11-14 14:32:40.102814 option = 'tds version' value = '4.2'.
2002-11-14 14:32:40.102863 option = 'initial block size' value = '512'.
2002-11-14 14:32:40.102903 option = 'swap broken dates' value = 'no'.
2002-11-14 14:32:40.102935 no is a 'no/off/false'.
2002-11-14 14:32:40.102969 option = 'swap broken money' value = 'no'.
2002-11-14 14:32:40.102999 no is a 'no/off/false'.
2002-11-14 14:32:40.103032 option = 'try server login' value = 'no'.
2002-11-14 14:32:40.103062 no is a 'no/off/false'.
2002-11-14 14:32:40.103094 option = 'try domain login' value = 'yes'.
2002-11-14 14:32:40.103124 yes is a 'yes/on/true'.
2002-11-14 14:32:40.103156 option = 'nt domain' value = 'ECPC2000'.
2002-11-14 14:32:40.103195 option = 'cross domain login' value = 'no'.
2002-11-14 14:32:40.103226 no is a 'no/off/false'.
2002-11-14 14:32:40.103262 option = 'dump file' value =
'/usr/local/freetds/freetds.log'.
2002-11-14 14:32:40.103299 option = 'debug level' value = '10'.
2002-11-14 14:32:40.103375 option = 'text size' value = '64512'.
2002-11-14 14:32:40.103413 ... Found section 0-ecpc-2.
2002-11-14 14:32:40.103463 ... Found section jdbc.
2002-11-14 14:32:40.103527 Looking for section 0-ecpc-2.
2002-11-14 14:32:40.103598 ... Found section global.
2002-11-14 14:32:40.103690 ... Found section 0-ecpc-2.
2002-11-14 14:32:40.103720 Got a match.
2002-11-14 14:32:40.103750 option = 'host' value = '192.58.100.17'.
2002-11-14 14:32:40.103781 Found host entry 192.58.100.17.
2002-11-14 14:32:40.106133 IP addr is 192.58.100.17.
2002-11-14 14:32:40.106328 option = 'port' value = '1433'.
2002-11-14 14:32:40.106372 option = 'tds version' value = '7.0'.
2002-11-14 14:32:40.106410 option = 'dump file append' value = 'yes'.
2002-11-14 14:32:40.106443 yes is a 'yes/on/true'.
pid: 26520:2002-11-14 14:32:40.106489 ... Found section jdbc.
pid: 26520:2002-11-14 14:32:40.106556 ...Success.
pid: 26520:2002-11-14 14:32:40.106666 Setting 'dump_file' to
'/tmp/freetds.log.26520' from $TDSDUMP.

Also here are tails of the logs from:

The cli version of php which worked

pid: 26697:2002-11-14 14:38:15.956176 inside tds_willconvert() 108 47 1
pid: 26697:2002-11-14 14:38:15.956325 dbdatlen() type = 108
pid: 26697:2002-11-14 14:38:15.956460 leaving dbdatlen() returning 35
pid: 26697:2002-11-14 14:38:15.956607 inside dbconvert() srctype = 108
desttype = 47
pid: 26697:2002-11-14 14:38:15.956754 inside dbconvert() calling
tds_convert
pid: 26697:2002-11-14 14:38:15.957030 inside dbconvert() outputting 8
bytes character data destlen = -1
pid: 26697:2002-11-14 14:38:15.957216 dbdatlen() type = 111
pid: 26697:2002-11-14 14:38:15.957356 leaving dbdatlen() returning 0
pid: 26697:2002-11-14 14:38:15.957501 dbdatlen() type = 38
pid: 26697:2002-11-14 14:38:15.957638 leaving dbdatlen() returning 0
pid: 26697:2002-11-14 14:38:15.957778 dbdatlen() type = 111
pid: 26697:2002-11-14 14:38:15.957916 leaving dbdatlen() returning 8
pid: 26697:2002-11-14 14:38:15.958057 inside tds_willconvert()
pid: 26697:2002-11-14 14:38:15.958216 inside tds_willconvert() 61 47 1
pid: 26697:2002-11-14 14:38:15.958365 dbdatlen() type = 111
pid: 26697:2002-11-14 14:38:15.958500 leaving dbdatlen() returning 8
pid: 26697:2002-11-14 14:38:15.958644 inside dbconvert() srctype = 61
desttype = 47
pid: 26697:2002-11-14 14:38:15.958819 inside dbconvert() calling
tds_convert
pid: 26697:2002-11-14 14:38:15.959000 inside dbconvert() outputting 19
bytes character data destlen = -1
pid: 26697:2002-11-14 14:38:15.959170 dbdatlen() type = 38
pid: 26697:2002-11-14 14:38:15.959305 leaving dbdatlen() returning 0
pid: 26697:2002-11-14 14:38:15.959449 dbdatlen() type = 39
pid: 26697:2002-11-14 14:38:15.959585 leaving dbdatlen() returning 0
pid: 26697:2002-11-14 14:38:15.959727 dbdatlen() type = 39
pid: 26697:2002-11-14 14:38:15.959860 leaving dbdatlen() returning 0
pid: 26697:2002-11-14 14:38:15.960002 dbdatlen() type = 39
pid: 26697:2002-11-14 14:38:15.960132 leaving dbdatlen() returning 0
pid: 26697:2002-11-14 14:38:15.960272 inside dbnextrow()
pid: 26697:2002-11-14 14:38:15.960410 processing row tokens.  marker is 
fd
pid: 26697:2002-11-14 14:38:15.960561 inside tds_process_end()
more_results = 0, was_cancelled = 0
pid: 26697:2002-11-14 14:38:15.960721 leaving dbnextrow() returning -2


and a tail from the module version run

pid: 26520:2002-11-14 14:32:40.204776 inside tds_willconvert() 108 47 1
pid: 26520:2002-11-14 14:32:40.204913 dbdatlen() type = 108
pid: 26520:2002-11-14 14:32:40.205026 leaving dbdatlen() returning 35
pid: 26520:2002-11-14 14:32:40.205138 inside dbconvert() srctype = 108
desttype = 47
pid: 26520:2002-11-14 14:32:40.205254 inside dbconvert() calling
tds_convert
pid: 26520:2002-11-14 14:32:40.205415 inside dbconvert() outputting 8
bytes character data destlen = -1
pid: 26520:2002-11-14 14:32:40.205530 dbdatlen() type = 111
pid: 26520:2002-11-14 14:32:40.205624 leaving dbdatlen() returning 0
pid: 26520:2002-11-14 14:32:40.205724 dbdatlen() type = 38
pid: 26520:2002-11-14 14:32:40.205820 leaving dbdatlen() returning 0
----no entries after the previous line =----


On Thu, 2002-11-14 at 14:11, Lowden, James K wrote:
> > From: Chris [mailto:ccortner AT cvol.net]
> > Sent: November 14, 2002 2:33 PM
> > 
> > This happens whether I am using dtlib or odbc, I have not tried ctlib.
> > The version of php I am using is the latest stable 4.3 build, but I
> > tried 4.2.3 as well. When the Apache php module fails there is no
> > information appended to the freetds dump. php is crashing on the first
> > database function it encounters.
> 
> Chris, 
> 
> A simple problem could be that the TDS version is not right when run under
> apache's control.  Set TDSDUMCPCONFIG and have a look.  If that does expose
> anything, please post it here.  
> 
> Also, what version of FreeTDS are you using?  The release should work with
> db-lib (or ct-lib) but if we do find a bug you'll probably have to use a
> snapshot.  
> 
> --jkl
> 
> 
> 
> 
> 
> 
> > 
> > On Wed, 2002-11-13 at 13:43, Frediano Ziglio wrote:
> > > Il mer, 2002-11-13 alle 18:34, Chris ha scritto:
> > > > Any idea why the command line version of php would be 
> > able to do database
> > > > queries with freetds, but the apache module version 
> > causes a segfault with
> > > > this error message in the apache error log.
> > > > 
> > > > [Wed Nov 13 10:50:54 2002] [notice] child pid 2431 exit signal
> > > > Segmentation fault (11)
> > > > 
> > > > This happens with the odbc and sybase functions. The php 
> > module seems to
> > > > work fine when not using database procedures.
> > > > 
> > > > I asked in a php forum and was told that its a freeTDS 
> > problem, which I'm
> > > > not so sure of, so Im asking here as well. If anything I 
> > figure maybe
> > > > someone is reading this who has gotten freetds working 
> > with apache who can
> > > > help me.
> > > > 
> > > > Thanks alot
> > > > 
> > > > Chris - support AT cvol.net
> > > > 
> > > Hi Chris!
> > > 
> > > I have no idea many idea. 
> > > What version of FreeTDS are you using?
> > > What operating system and version?
> > > What FreeTDS library are you using? Ctlib, dblib or odbc ?
> > > Can you reproduce the problem? So you should send a log of 
> > FreeTDS, the
> > > code that produce given error..
> > > 
> > > Who do you use db procedure?
> > > 
> > > bye
> > >  freddy77
> > > 
> > > 
> > > 
> > > ---
> > > You are currently subscribed to freetds as: [ccortner AT cvol.net]
> > > To unsubscribe, forward this message to 
> > $subst('Email.Unsub')
> > > ---
> > > [This E-mail scanned for viruses by Declude Virus]
> > > 
> > > 
> > > 
> > 
> > 
> > ---
> > [This E-mail scanned for viruses by Declude Virus]
> > 
> > 
> > ---
> > You are currently subscribed to freetds as: [LowdenJK AT bernstein.com]
> > To unsubscribe, forward this message to 
> > $subst('Email.Unsub')
> > 
> 
> 
> The information contained in this transmission may contain privileged and
> confidential information and is intended only for the use of the person(s)
> named above.  If you are not the intended recipient, or an employee or agent
> responsible for delivering this message to the intended recipient, any
> review, dissemination, distribution or duplication of this communication is
> strictly prohibited. If you are not the intended recipient, please contact
> the sender immediately by reply e-mail and destroy all copies of the
> original message. Please note that we do not accept account orders and/or
> instructions by e-mail, and therefore will not be responsible for carrying
> out such orders and/or instructions.
> 
> 
> 
> ---
> You are currently subscribed to freetds as: [ccortner AT cvol.net]
> To unsubscribe, forward this message to $subst('Email.Unsub')
> ---
> [This E-mail scanned for viruses by Declude Virus]
> 
> 


---
[This E-mail scanned for viruses by Declude Virus]