PHP 4.0 Bug #6505: apache fails with php4 & freetds
| From: | vaughan at ucla dot edu | 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.