Skip to main content
ExLibris
  • Subscribe by RSS
    • Back
    Aleph
    Ex Libris Knowledge Center

    Perl DBI; mysql

    1. Last updated
    2. Save as PDF
    • 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