NAME
INSTALL - How to install and configure DBD::MaxDB version 7.7.5 BUILD 000-000-000-000
SYNOPSIS
perl Makefile.PL [options]
make
make test
make install
DESCRIPTION
This documentation describes how you install the DBD::MaxDB, the Perl DBI driver for the MaxDB database.
COPYRIGHT
Copyright 2000-2007 by SAP AG
This program is free software; you can redistribute it and/or modify it under the terms of either the Artistic License, as specified in the Perl README file or the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
IF YOU HAVE PROBLEMS:
This module is maintained and supported on a web forum,
<https://forums.sdn.sap.com/forum.jspa?forumID=90&start=0>
Please send comments and bug-reports to this list. Please include the output of perl -v [-V], the version of the MaxDB database, the version of the MaxDB SQLDBC-SDK, the version of DBI, and details about your platform in your bug report.
Additionally you might try the dbi-user mailing list for questions about DBI and its modules in general.
HOW TO GET THE LATEST VERSION:
Use the following URL to look for new versions of this module:
<http://search.cpan.org/~maxdb>
PREREQUISITES
Before installing the driver make sure that you have the following prerequisites available.
Perl
Build, test and install Perl 5 (at least 5.6.1). It is very
important to TEST it and INSTALL it!
DBI Build, test and install DBI (at least 1.21). Since DBD::MaxDB is a
DBI driver, you need DBI. It is available at:
C compiler
A C compiler is required, since currently you can only install from
source. Maybe a binary version will be available in future releases.
Make sure, that the C compiler you use is the same C compiler that
was used for compiling Perl! Otherwise you will almost definitely
encounter problems because of differences in the underlying C
runtime libraries.
MaxDB SQLDBC-SDK
The DBD::MaxDB driver needs to link with MaxDB's common database
interface SQLDBC which is not included in this distribution. You
need at least the version 7.6.00.19. But you should use a newer
version of SQLDBC from release 7.6.00. For details about SQLDBC see:
<http://maxdb.sap.com/documentation/>
You can download the SQLDBC software development kit from the MySQL
homepage at:
<https://www.sdn.sap.com/irj/sdn/maxdb>
There are different ways to install the SQLDBC software
development kit.
Install using SDBINST
You need to download and unpack the MaxDB standard installation
package (maxdb-all-<os>-[32 or
64]bit-<arch>-<version>_<build>.<tgz>)
Go to the directory into which you unpacked the installation
package. Enter the following commands:
./SDBINST -package Base
./SDBINST -package "Database Connectivity"
The Base package is required for SQLDBC SDK. If you have already
installed it, you can skip the first command.
Install from tarball
Download the latest version of the SQLDBC SDK from the MaxDB
homepage or the ftp server. Choose the SQLDBC package that
matches your operating system architecture.
Platform Package name
Microsoft Windows (x86) maxdb-sqldbc-win-32bit-i386-7_7_05_00.zip
Microsoft Windows (IA64) maxdb-sqldbc-win-64bit-ia64-7_7_05_00.zip
Linux (x86) maxdb-sqldbc-linux-32bit-i386-7_7_05_00.zip
Linux (IA64) maxdb-sqldbc-linux-64bit-ia64-7_7_05_00.zip
IBM AIX 5 (PowerPC, 64-bit) maxdb-sqldbc-aix5-64bit-ppc-7_7_05_00.zip
HP-UX (HPPA, 64-bit) maxdb-sqldbc-hpux-64bit-hppa-7_7_05_00.zip
Sun Solaris (Sparc, 64-bit) maxdb-sqldbc-sun-64bit-sparc-7_7_05_00.zip
Tru64 (Alpha, 64-bit) maxdb-sqldbc-tru64-64bit-alpha-7_7_05_00.zip
Unpack the tarball to a local directory of your choice with the
following command:
tar xvzf maxdb-all-<os>-32|64bit-<arch>-<version>_<build>
MaxDB database server
Of course you will need a MaxDB database instance. The DBD::MaxDB
driver supports all available versions of MaxDB (SAP DB) at least
7.3. The MaxDB software and documentation can be found at:
<https://www.sdn.sap.com/irj/sdn/maxdb>
INSTALLATION
By default Makefile.PL uses the MaxDB global configuration file (/etc/opt/sdb) on Unix/Linux platforms or the registry (requires Win32API::Registry) on Windows platforms for retrieving the location of "SQLDBC-SDK".
If the location of "SQLDBC-SDK" cannot be found or if you want to control it yourself, define the environment variables "SQLDBCSDK" or set the option "-o <path>" when calling " perl Makefile.PL "
Since the tests will connect to a live database, you need to set the following environment variables for the tests to run:
DBI_DSN=dbi:MaxDB:<host>/<dbname>
DBI_USER=<username>
DBI_PASS=<password>
E.g. Definition of the parameter url for a connection to the database TST on the computer REMOTESERVER " dbi:MaxDB:REMOTESERVER/TST "
Now you are ready, to make and install DBD::MaxDB. The final steps are:
Note that you should execute steps 1 to 3 as a normal user, not as root!
TESTING
You need to set the following environment variables for the tests to
DBI_DSN=dbi:MaxDB:<host>/<dbname> DBI_USER=<username> DBI_PASS=<password>
Execute the command:
"make test" or "make test TEST_VERBOSE=1"
to run the test suite. Running the test suite should not show any errors.
Since DBD::MaxDB uses the shared library "libSQLDBC_C.so" ("libSQLDBC_C.dll" on windows), you have to ensure that this library can be found by the operating system. On windows you should add the "libSQLDBC_C.dll" to you "PATH" environment variable. On Unix/Linux you will normally add the path of "libSQLDBC_C.[so|sl]" to the environment variable "LD_LIBRARY_PATH".