SQL Anywhere for Linux - Perl or PHP with ASA

Author

Perl or PHP with ASA

Gary MacKay

2005-08-26, 9:23 am

I have one linux box running ASA only and another running the web site only. My Winbloze app runs on each of the workstations and obviously connects to the ASA box. I'm really struggling getting the web server to connect to it tho. Ideally I'd like to use
PHP but have spent way too many hours with no luck. I just tried to install the DBD::ASAny perl module and of course it failed also. I'm guessing I need to install some or all of ASA 8 to resolve this?

Should I:
1. Do a complete server install even tho I'll never run the server on the web box?

2. Do a complete server install, run it, use sync to keep it in line with the master box?

3. ????

- Gary

Greg Fenton

2005-08-27, 8:23 pm

Gary MacKay wrote:
> Ideally I'd like to use PHP but have spent way too
> many hours with no luck. I just tried to install the DBD::ASAny perl
> module and of course it failed also. I'm guessing I need to install some
> or all of ASA 8 to resolve this?
>

Both the DBD::ASAny Perl and the SQLAnywhere PHP drivers sit on top of
the SQLAnywhere client library "dblib". So you need to have the
SQLAnywhere client installed on any machine that you want to build and
to run the client on. You need to make sure that you set up the PATH
and LD_LIBRARY_PATH environment both before building and when running
(this is accomplished by sourcing the file $ASANY9/bin/asa_config.sh)

If you are still having problems building, please post back. When you
do, specify the kernel and glibc versions that you are using.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Gary MacKay

2005-08-29, 8:23 pm

Greg Fenton wrote:
> Gary MacKay wrote:
>
>
> Both the DBD::ASAny Perl and the SQLAnywhere PHP drivers sit on top of
> the SQLAnywhere client library "dblib". So you need to have the
> SQLAnywhere client installed on any machine that you want to build and
> to run the client on. You need to make sure that you set up the PATH
> and LD_LIBRARY_PATH environment both before building and when running
> (this is accomplished by sourcing the file $ASANY9/bin/asa_config.sh)
>
> If you are still having problems building, please post back. When you
> do, specify the kernel and glibc versions that you are using.
>
> greg.fenton

[root@web1 /]# cat /etc/redhat-release
Red Hat Linux release 9 (Shrike)
[root@web1 /]# uname -srv
Linux 2.4.20-31.9 #1 Tue Apr 13 18:04:23 EDT 2004

OK. I installed the complete sybase server on the web server and then tried to install DBD::ASAny but received these errors:

CPAN.pm: Going to build S/SM/SMIRNIOS/DBD-ASAny-1.13.tar.gz

Using DBI 1.48 (for perl 5.008006 on i686-linux) installed in /usr/lib/perl5/site_perl/5.8.6/i686-linux/auto/DBI/

Configuring DBD::ASAny ...
** Unable to find Adaptiver Server Anywhere installation

** Please set ASANY.
Running make test
Make had some problems, maybe interrupted? Won't test
Running make install
Make had some problems, maybe interrupted? Won't install

I made sure I had sourced the asa_config.sh file before going into perl by doing an "echo $ASANY" and it displayed the proper path to my ASA install.

- Gary

Greg Fenton

2005-08-29, 8:23 pm

Gary MacKay wrote:
>
> I made sure I had sourced the asa_config.sh file before going into perl
> by doing an "echo $ASANY" and it displayed the proper path to my ASA
> install.

How did you source the file?

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Gary MacKay

2005-08-30, 7:23 am

Greg Fenton wrote:
> Gary MacKay wrote:
>
>
>
> How did you source the file?
>
> greg.fenton

.. /opt/sybase/SYBSsa8/bin/asa_config.sh

then fired up perl with

perl -MCPAN -eshell

Before that I did the 'echo $ASANY' command and it displayed:
/opt/sybase/SYBSsa8

- Gary

Sponsored Links