I try to get a sql anywhere connection under PHP with a apache2 server and suPHP installed. System: Debian Squeeze 64 Bit
When I just load the sqlanywhere.so (built from source (http://sqlanywhere-forum.sap.com/questions/4691/php-warning-php-startup-unable-to-load-dynamic-library) or downloaded the prebuilt one) then I receive this error:
The SQLAnywhere client libraries could not be loaded. Please ensure that libdbcapi.so can be found in your LD_LIBRARY_PATH environment variable.
I tried setting the LD_LIBARY_PATH in the start script of apache2 and olso fo apache2ctl, but this does not help. (Looks like suPHP is not passing it over...?)
When I copy over all /opt/sqlanywhere10/lib64 files to /usr/lib then I receive always a server error 500 (Premature end of script headers: phpinfo.php)
Any hints how to solve this ?
asked 07 Dec '11, 12:40
After some more searching I have finaly found this answer:
Looks like suPHP clears the LD_LIBRARY env var before starting the PHP interpreter. After applying the patch I can now connect to the database server
answered 07 Dec '11, 12:57