• Article Type: General
• Product: Aleph
• Product Version: 16.02

Description:
We are looking at ways to exchange information between Aleph and External system and one way we are considering is with perl dbi -- I see from US PRB 13584 that this is not part of Aleph Installation, but it looks like it can be installed, can someone install this for me on Alfred, or give me the instructions to do it myself?

Resolution:
[From Greg I:]
Even though it is not our responsibility to manage mysql , I have spent some time with it and unfortunately ran into compilation problem whicnh may be related to mysql server setup in your system

alfred-a16(1) >>perl Makefile.PL PREFIX=/exlibris/aleph/a16_1/product/perl-5.8.2 --cflags="-I/opt/csw/include/mysql -D_FORTEC_"
I will use the following settings for compiling and testing:

cflags (Users choice) = -I/opt/csw/include/mysql -D_FORTEC_
libs (mysql_config) = -L/opt/csw/lib -L/opt/csw/lib/mysql -lmysqlclient -lz -lposix4 -lc -lgen -lsocket -lnsl -lm -L/opt/csw/lib -lssl -lcrypto
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 1
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testuser (default ) =

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.

Checking if your kit is complete... Looks good

Using DBI 1.37 installed in /exlibris/aleph/a16_1/product/perl-5.8.2/lib/site_perl/5.8.2/sun4-solaris/auto/DBI
Writing Makefile for DBD::mysql
alfred-a16(1) >>make
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/Mysql.pm blib/lib/Mysql.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
gcc -c -I/exlibris/aleph/a16_1/product/perl-5.8.2/lib/site_perl/5.8.2/sun4-solaris/auto/DBI -I/opt/csw/include/mysql -D_FORTEC_ -DDBD_MYSQL_WITH_SSL -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"2.9003\" -DXS_VERSION=\"2.9003\" -fPIC "-I/exlibris/aleph/a16_1/product/perl-5.8.2/lib/5.8.2/sun4-solaris/CORE" dbdimp.c
/exlibris/aleph/a16_1/product/bin/perl -p -e "s/~DRIVER~/mysql/g" < /exlibris/aleph/a16_1/product/perl-5.8.2/lib/site_perl/5.8.2/sun4-solaris/auto/DBI/Driver.xs
t > mysql.xsi
/exlibris/aleph/a16_1/product/bin/perl /exlibris/aleph/a16_1/product/perl-5.8.2/lib/5.8.2/ExtUtils/xsubpp -typemap /exlibris/aleph/a16_1/product/perl-5.8.2/lib/5.8.2/ExtUtils/typemap mysql.xs > mysql.xsc && mv mysql.xsc mysql.c
Warning: duplicate function definition 'do' detected in mysql.xs, line 192
Warning: duplicate function definition 'rows' detected in mysql.xs, line 290
gcc -c -I/exlibris/aleph/a16_1/product/perl-5.8.2/lib/site_perl/5.8.2/sun4-solaris/auto/DBI -I/opt/csw/include/mysql -D_FORTEC_ -DDBD_MYSQL_WITH_SSL -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"2.9003\" -DXS_VERSION=\"2.9003\" -fPIC "-I/exlibris/aleph/a16_1/product/perl-5.8.2/lib/5.8.2/sun4-solaris/CORE" mysql.c
mysql.xs: In function `XS_DBD__mysql__dr__admin_internal':
mysql.xs:100: too few arguments to function `mysql_shutdown'
make: *** [mysql.o] Error 1
alfred-a16(1) >>

I would suggest your OS guys to take over from here.
The working directory was this

/exlibris/aleph/a16_1/product_source/source/DBD-mysql-2.9003

• Article last edited: 10/8/2013