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-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 ?

André

asked 07 Dec '11, 12:40

ASchild's gravatar image

ASchild
777222740
accept rate: 14%


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é

permanent link

answered 07 Dec '11, 12:57

ASchild's gravatar image

ASchild
777222740
accept rate: 14%

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

permanent link

answered 01 May '12, 20:09

Mark's gravatar image

Mark
2265917
accept rate: 25%

edited 01 May '12, 20:10

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

Thanks

(02 May '12, 12:17) ASchild
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×61
×47

question asked: 07 Dec '11, 12:40

question was seen: 1,806 times

last updated: 02 May '12, 12:17