FreeTDS Development Group

[Brian Bruns <camber AT umcc.ais.org>]

Hmmm.. seems to work with Sybase...php is such a pita to debug.  can you
send a full script demonstrating this.  Also set the TDSDUMP variable to
get a log of this (this may be tricky with apache, I'd see if you can make
it happen with a cgi (command line) version of PHP)

Brian

On Wed, 26 Jan 2000, Matthew Haas wrote:

> 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.
> 
> 
> ---
> You are currently subscribed to freetds as: camber AT ais.org
> To unsubscribe, forward this message to 
> leave-freetds-12294M AT franklin.oit.unc.edu
> 
>