PHP + suPHP under Linux ?

[Former Member]

Hello,

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-libra...) 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 ?

André

[Former Member · Accepted solution]

After some more searching I have finaly found this answer:

https://lists.marsching.com/pipermail/suphp/2008-April/001772.html

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

André

[former_SQLA_member1694905]

For an alternative to setting LD_LIBRARY_PATH, see SQLAnywhere 12 on Ubuntu 11.10 linux, nginx & php

[Former Member]

Nice solution, just add it to the global /etc/ld.so.cache.d/

Thanks