PHP Module for OSx

[VolkerBarth]

Hi, I've been a long time user of SQL Anywhere, and I've just downloaded the latest for OSx. Everything is great, but after some searching around, I realized there was no pre-compiled version of the PHP module for OSx, although it is mentioned on the website for version 12. I've tried to compile & install it myself, but was not successful.

Is it possible a downloadable PHP module could be made available for OSx ?

Mac OSx 10.6.7 PHP 5.3.4

[VolkerBarth]

You may have a look at this question.

From that it seems that there's no binary download for Mac OS X but you can build one yourself.

[Former Member]

There are currently no plans to maintain a downloadable binary version of the PHP driver for Mac OS X. Maintaining these binary downloads would require engineering and QA effort that we would like to be able to justify with significant demand from customers.

If you have trouble compiling the module, please post details about your specific problem and we'll do our best to help you.

[Former Member]

Ok thank you, i do understand. I have successfully compiled php, including sqlanywhere, no compile errors, and i did a "sudo make install" also with no errors, but when i restart apache, its still running the old version of PHP. I think the new version is being installed in /usr/local/bin, instead of /usr/bin This is my best guess.

Any suggestions would be appreciated.

tom.

[Former Member]

So you are compiling the SQL Anywhere module into PHP? Okay. Once you have it compiled, you will need to update the PHP module that's installed in Apache.

This may vary depending on your system. I found this blog post that might be helpful:

http://www.phpied.com/installing-php-and-apache-on-mac-osx-that-was-pretty-easy/

[Former Member]

The alternative method is to leave the current PHP installation in place. You can compile the SQL Anywhere module as an extension:

$ cd <sqlanywhere module source directory>
$ phpize
$ make
$ make install

Once that's done, the module will be installed in your PHP extensions directory. You must also add an entry to your php.ini to load the module. Then it will be done.

[Former Member]

Finally, you alternative worked, thank you! I have apache on my mac that is aware of sqlanywhere. I still have a problem on OSx that i previously had on Linux. The SQLAnywhere client version indicates this: "The SQLAnywhere client libraries could not be loaded. Please ensure that libdbcapi.so can be found in your LD_LIBRARY_PATH environment variable."

To solve this on Linux, (fedora) I had to create the following file: /etc/sysconfig/httpd In this file i put "source /Applications/SQLAnywhere12/System/bin64/sa_config.sh" I believe apache reads this file when starting up, and knows where the client libraries are.

I have no idea where, or what file to modify on OSx so apache will load the SQLAnywere client libraries.

Suggestions would be greatly appreciated once again!

tom.

[MarkCulp]

Tom: FYI, note that I have been converting your responses (which have been answers) to comments. Rather than adding an answer when responding to a person's comment please use the "reply" button (the little box with arrow pointing up-and-right) which appears under each comment ... unless you are actually adding an answer to your original question. Thanks.

[Former Member]

Ok, thanks Mark.