PHP 4.0 Bug #6505: apache fails with php4 & freetds

From: Date: Sat, 02 Sep 2000 19:32:11 +0000
Subject: PHP 4.0 Bug #6505: apache fails with php4 & freetds
Groups: php.dev 
Request: Send a blank email to php-dev+get-31677@lists.php.net to get a copy of this message
From: vaughan@ucla.edu Operating system: Debian 2.2.16 PHP version: 4.0 Latest CVS (02/09/2000) PHP Bug Type: Sybase-ct (ctlib) related Bug description: apache fails with php4 & freetds I am trying to compile using freetds to eventually access an MS SQL server. for freetds (v.0.5) ./configure --prefix=/usr/local/freetds/ --enable-msdblib --with-tdsver=4.2 for php 4 (latest CVS 2/9/2000) ./configure --with-apxs --with-mysql --enable-track-vars --with-config-file-path=/etc/php4/apache --with-sybase=/usr/local/freetds export SYBASE=/usr/local/freetds export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$SYBASE\lib I edited the /usr/local/freetds/interfaces file to set up the MS SQL server address. I fixed httpd.conf to have the sybase interfaces file be /usr/local/freetds/interfaces when I stop apache and run apachectl configtest I get the following output Syntax error on line 108 of /etc/apache/httpd.conf: Cannot load /usr/lib/apache/1.3/libphp4.so into server: /usr/lib/apache/1.3/libphp4.so: undefined symbol: DBSETLCHARSET Brian Bruns, the author of freetds, suggested a library problem and attempting to fix it by exporting the SYBASE and LD_LIBRARY_PATH variables. But this does not work. The only place in the source that I can find DBSETLCHARSET is in file ext/sybase/php_sybase_db.c at line 354: DBSETLCHARSET(sybase.login,charset); but I don't know enough about programming to figure out what sybase.login and charset are needed here, or even to know if this is the offending line. thanks for any help you can give me. I have been trying for a long time to find a reliable way to send queries from PHP to a Microsoft SQL server that resides on another machine and to which I only have read access.

« previous php.dev (#31677) next »