FreeTDS Development Group

["Matthew Haas" <matthewh AT wds.org>]

I'm pretty much a linux newbie and am very pleased with myself to get this 
far but I seem to be stuck. As far as I can see everything is in place and 
correctly configured but certain queries are causing segmentation faults. 
Can anyone suggest a solution to this problem or a way of getting more 
information on the cause?

I've got everything to compile and can successfully make queries like:
<?php
    $db=sybase_connect("XXXXXXX", "xx", "xxxxxx");
    $q=sybase_query("select * from mytable", $db);
.
.
etc.

however some queries, like the following, cause a segmentation fault:
<?php
    $db=sybase_connect("XXXXXXX", "xx", "xxxxxx");
    $q=sybase_query("create table mytable (c1 integer, c2 varchar(50))"; 
$db);
.
.
etc.

The table is created but no page is returned from Apache and the error_log 
shows the seg fault.

Here's the log I made of the installation process:

.
.

6. Issue these commands to compile the source:
./configure --with-tdsver=4.2
make
make install

7. Edit the /usr/local/freetds/interfaces file so that it reads:
XXXXXXX
query tcp ether voyager 1433
master tcp ether voyager 1433

8. Download the source distribution of PHP 3 ..

9. Remove the existing PHP 3 RPM and shutdown apache ..

10. Change directory to the newly uncompressed PHP directory ..

11. Issue these commands to compile the source:
./configure –with-apxs=/usr/sbin/apxs –with-sybase=/usr/local/freetds
make
make install

12. Update the Apache configuration file, /etc/httpd/conf/httpd.conf by 
uncommenting (remove the leading #) the following lines:
LoadModule php3_module  libexec/libphp3.so
AddModule mod_php3.c
AddType application/x-httpd-php3 .php3
AddType application/x-httpd-php3-source .phps

13. Add the following lines to /etc/rc.d/init.d/httpd3:
SYBASE=/usr/local/freetds
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$SYBASE/lib
export SYBASE LD_LIBRARY_PATH

14. Restart Apache ..

Thanks Mat.