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 · Accepted solution]

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.

Now you need to ensure that the Apache process can find the SQL Anywhere client libraries.

What you need is the lib64 directory of your SQL Anywhere installation to be included in the DYLD_LIBRARY_PATH environment variable (LD_LIBRARY_PATH on Linux).

If you are using the "Web Sharing" option from your System Settings, you should be able to set this in /System/Library/LaunchDaemons/org.apache.httpd.plist

Add a tag something like:

<key>EnvironmentVariables</key>
<dict>
        <key>DYLD_LIBRARY_PATH</key>
        <string>/Applications/SQLAnywhere12/System/lib64</string>
</dict>

This should go at the same depth as the other key tags.

If you are using another Apache installation, you will have to find the equivalent configuration file for your installation.

Note, too, that it is vital that the path you include (lib64 or lib32) refers to the same pointer size as the Apache process that's running.

[Former Member · Accepted solution]

Problem Solved! Thanks for the prompt support!! These few helpful hints would be a great thing to publish on your website for future reference on compiling and installing the PHP module, OSx & Unix.

[Former Member · Accepted solution]

I'm glad you got it going. I've summarized the two most important comments as an answer. If you agree that the above steps solved your problem, then go ahead and mark the answer as accepted. Otherwise, let me know what I've missed.

[VolkerBarth · Accepted solution]

Well, I'd say this discussion here is already part of the published documentation to SQL Anywhere, PHP and Mac OS X by the very nature of this Q&A site...

Of course, this doesn't mean that particular documents (or DCX) could not be improved:)

[Former Member · Accepted solution]

I will make a note to get a Mac OS X example posted somewhere. The reason I summarized the comments that led to an answer was so that it would be documented here on this forum. You are right, though. A more official documentation source would be nice.

[Former Member · Accepted solution]

Up to this point, when i encounter such a problem, I always go to the website first for documentation and examples. So for myself, had there been a detailed & complete example with reasonable documentation for this case, it would have saved me a lot of time. That seems logical for things that aren't justified or driven by customer demands. In any case, I'm very happy to have the problem solved, very happy with the product, and appreciate the support found here.

[Former Member · Accepted solution]

FWIW, Mohammed is going to add a README to the source distribution that will include build instructions and a few specific examples for configuring Apache. This is the easiest thing for us to distribute and keep up to date. PHP is a moving target, whereas our docs and white-papers tend to be more static. Also, if you are looking for how to build and install the module, you will already have the source code.