FreeTDS Development Group

[Gabriel Ricard <gabe AT imaxsales.net>]

Greetings Folks,

I am having a bit of a problem with FreeTDS 0.52 & PHP 4.0.6 on MacOS X.

I have compiled FreeTDS 0.52 successfully. With my configuration for our 
MS SQL 6.x server, the 'make check'  tests pass 3 out of 6 (the first 
three pass). I know that it can connect to my DB server.

I have installed FreeTDS in /usr/local/freetds/. When I built PHP, I 
specified --with-sybase_ct=/usr/local/freetds on the configure command. 
When I go to use either sybase_connect() or mssql_connect(), Apache dies.

I investigated the problem by building PHP as a CGI binary and running 
the script from the command line through gdb. This is the output that 
followed:

[hancock:~] root# gdb /usr/local/bin/php
GNU gdb 5.0-20001113 (Apple version gdb-186.1) (Sun Feb 18 01:18:32 GMT 
2001) (UI_OUT)
Copyright 2000 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you 
are
welcome to change it and/or distribute copies of it under certain 
conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB.  Type "show warranty" for 
details.
This GDB was configured as "powerpc-apple-macos10".
Reading symbols for shared libraries ... done
(gdb) run
Starting program: /usr/local/bin/php
[Switching to thread 1 (process 12126 thread 0x1903)]
<?
mssql_connect("MYDB", "MYUSERNAME", "MYPASSWORD");
?>

Program received signal EXC_BAD_ACCESS, Could not access memory.
0x70026ea4 in inet_aton ()
(gdb) bt
#0  0x70026ea4 in inet_aton ()
#1  0x7002b8d4 in inet_addr ()
#2  0x000d3ab8 in tds_connect (login=0x3b2f70) at login.c:153
#3  0x000cd03c in ct_connect (con=0x3b2f40, servername=0x3b2dcc "MYDB", 
snamelen=2) at ct.c:298
#4  0x0009b7b0 in php_sybase_do_connect_internal (sybase=0x3b2f1c, 
host=0x3b2dcc "MYDB", user=0x3b2e6c "MYUSERNAME", passwd=0x3b2eac 
"MYPASSWORD") at php_sybase_ct.c:415
#5  0x0009be64 in php_sybase_do_connect (ht=3878684, 
return_value=0x3b2ecc, this_ptr=0x200, return_value_used=0, 
persistent=27) at php_sybase_ct.c:622
#6  0x0009c038 in php_if_sybase_connect (ht=3, return_value=0x3b2ecc, 
this_ptr=0x0, return_value_used=0) at php_sybase_ct.c:668
#7  0x0002c3e0 in execute (op_array=0x3b1d3c) at ./zend_execute.c:1504
#8  0x00005680 in zend_execute_scripts (type=0, file_count=3) at 
zend.c:752
#9  0x0000ea60 in php_execute_script (primary_file=0xbffffcb8) at 
main.c:1206
#10 0x00002c48 in main (argc=1, argv=0xbffffddc) at cgi_main.c:718
#11 0x00001c28 in _start ()
#12 0x00001a68 in start ()
#13 0x00000000 in ?? ()
(gdb)


So, for some odd reason, when I run the 'make check' tests, they can 
read in the configuration file, and connect to the appropriate hostname 
(in this case I am providing it an IP address). I have run tcpdump to 
ensure that the 'make check' tests actually have connected to the 
database, and they have. The logs from the test connections in /tmp are 
accurate also. I know it can connect to the server, but for some reason, 
when I try to connect using the FreeTDS library in PHP, it doesn't work.

Is there something I have configured wrong in PHP? I have tried setting 
the environment variable SYBASE=/usr/local/freetds, and that does not 
help either, I get the same effect. It seems almost as if it is not 
pulling the IP address from the config file, and thus is passing garbage 
to inet_addr() in tds_connect() in src/tds/login.c. I have spent a lot 
of time trying to figure out what is going on, but I just don't know how 
to fix this on my own.

Does anyone have any ideas on why it's not working from PHP?

 (please respond to me, and not just the mailing list address as I am 
not on the mailing list)

Thank you very much,
Gabriel Ricard