Skip to Content.
Sympa Menu

freetds - Re: RH6.1, Apache 1.3.9, PHP 3.0.14, FreeTDS 0.50, MS SQL Server 7.0 - Help!

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT umcc.ais.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: RH6.1, Apache 1.3.9, PHP 3.0.14, FreeTDS 0.50, MS SQL Server 7.0 - Help!
  • Date: Wed, 26 Jan 2000 19:19:55 -0500 (EST)



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
>
>





Archive powered by MHonArc 2.6.24.

Top of Page