Skip to Content.
Sympa Menu

freetds - 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: "Matthew Haas" <matthewh AT wds.org>
  • To: freetds
  • Subject: RH6.1, Apache 1.3.9, PHP 3.0.14, FreeTDS 0.50, MS SQL Server 7.0 - Help!
  • Date: Wed, 26 Jan 2000 7:24:31


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.





Archive powered by MHonArc 2.6.24.

Top of Page