perl DBD Informix install and test

首页 > 代码库 > perl DBD Informix install and test

perl DBD Informix install and test

2024-10-28 15:10:39 208人阅读

1.安装Informix_Client_SDK

1)root用户登录，添加informix home目录、组、用户

# mkdir -p /opt/informix

# groupadd informix

# useradd -G informix -d /opt/informix informix

# passwd informix

# chown informix -R /opt/informix

# chmod 775 -R /opt/informix

2）安装Informix_Client_SDK

informix用户复制Informix_Client_SDK_V3.50.FC5_Linux_x86_64_CZ4HFEN.tar到/opt/informix目录下

>tar xvf Informix_Client_SDK_V3.50.FC5_Linux_x86_64_CZ4HFEN.tar

/opt/informix目录新建文件.profile

> vi .profile

export INFORMIXDIR=/opt/informix

root用户安装

#cd /opt/informix

# ./installclientsdk

Initializing InstallShield Wizard........

Launching InstallShield Wizard........

-------------------------------------------------------------------------------

Welcome to the InstallShield Wizard for IBM Informix Client-SDK Version 3.50

The InstallShield Wizard will install IBM Informix Client-SDK Version 3.50 on

your computer.

To continue, choose Next.

IBM Informix Client-SDK Version 3.50

IBM Corporation

http://www.ibm.com

Press 1 for Next, 3 to Cancel or 4 to Redisplay [1] （回车）

-------------------------------------------------------------------------------

International Program License Agreement

Part 1 - General Terms

BY DOWNLOADING, INSTALLING, COPYING, ACCESSING, OR USING THE PROGRAM

YOU AGREE TO THE TERMS OF THIS AGREEMENT. IF YOU ARE ACCEPTING THESE

TERMS ON BEHALF OF ANOTHER PERSON OR A COMPANY OR OTHER LEGAL

ENTITY, YOU REPRESENT AND WARRANT THAT YOU HAVE FULL AUTHORITY TO

BIND THAT PERSON, COMPANY, OR LEGAL ENTITY TO THESE TERMS. IF YOU DO

NOT AGREE TO THESE TERMS,

- DO NOT DOWNLOAD, INSTALL, COPY, ACCESS, OR USE THE PROGRAM; AND

- PROMPTLY RETURN THE PROGRAM AND PROOF OF ENTITLEMENT TO THE PARTY

Press Enter to continue viewing the license agreement, or, Enter "1" to accept

the agreement, "2" to decline it or "99" to go back to the previous screen, "3"

Print.

1 （输入1，回车）

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1] （回车）

-------------------------------------------------------------------------------

IBM Informix Client-SDK Version 3.50 Install Location

Please specify a directory or press Enter to accept the default directory.

Directory Name: [/opt/informix] （回车）

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1] （回车）

-------------------------------------------------------------------------------

Choose the setup type that best suits your needs.

[X] 1 - Typical

The program will be installed with the suggested configuration.

Recommended for most users.

[ ] 2 - Custom

The program will be installed with the features you choose.

Recommended for advanced users.

To select an item enter its number, or 0 when you are finished: [0] 2（输入2，回车）

[ ] 1 - Typical

The program will be installed with the suggested configuration.

Recommended for most users.

[X] 2 - Custom

The program will be installed with the features you choose.

Recommended for advanced users.

To select an item enter its number, or 0 when you are finished: [0] （回车）

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1] （回车）

-------------------------------------------------------------------------------

Select the features for "IBM Informix Client-SDK Version 3.50" you would like

to install:

IBM Informix Client-SDK Version 3.50

To select/deselect a feature or to view its children, type its number:

1. [x] Client (installed)

2. [x] Messages (installed)

3. [x] Global Language Support (GLS) (installed)

Other options:

0. Continue installing

Enter command [0] （回车）

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1] （回车）

-------------------------------------------------------------------------------

IBM Informix Client-SDK Version 3.50 will be installed in the following

location:

/opt/informix

with the following features:

Client

Messages

Global Language Support (GLS)

for a total size:

95.1 MB

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

Installing IBM Informix Client-SDK Version 3.50. Please wait...

|-----------|-----------|-----------|------------|

0% 25% 50% 75% 100%

||||||||||||||||||||||||||||||||||||||||||||||||||

Creating uninstaller...

Performing GSKit installation for Linux ...

Branding Files ...

Installing directory .

Installing directory etc

Installing directory bin

Installing directory lib

Installing directory lib/client

Installing directory lib/client/csm

Installing directory lib/esql

Installing directory lib/dmi

Installing directory lib/c++

Installing directory lib/cli

Installing directory release

Installing directory release/en_us

Installing directory release/en_us/0333

Installing directory incl

Installing directory incl/esql

Installing directory incl/dmi

Installing directory incl/c++

Installing directory incl/cli

Installing directory demo

Installing directory demo/esqlc

Installing directory demo/c++

Installing directory demo/cli

Installing directory doc

Installing directory doc/gls_api

Installing directory doc/gls_api/en_us

Installing directory doc/gls_api/en_us/0333

Installing directory tmp

Installing directory gsk

Installing directory gsk/client

Installing directory gskit

Installing directory gsk

Installing directory gsk/client

IBM Informix Product: IBM INFORMIX-Client SDK

Installation Directory: /opt/informix

Performing root portion of installation of IBM INFORMIX-Client SDK...

Installation of IBM INFORMIX-Client SDK complete.

Installing directory etc

Installing directory gls

Installing directory gls/cm3

Installing directory gls/cv9

Installing directory gls/dll

Installing directory gls/etc

Installing directory gls/lc11

Installing directory gls/lc11/cs_cz

Installing directory gls/lc11/da_dk

Installing directory gls/lc11/de_at

Installing directory gls/lc11/de_ch

Installing directory gls/lc11/de_de

Installing directory gls/lc11/en_au

Installing directory gls/lc11/en_gb

Installing directory gls/lc11/en_us

Installing directory gls/lc11/es_es

Installing directory gls/lc11/fi_fi

Installing directory gls/lc11/fr_be

Installing directory gls/lc11/fr_ca

Installing directory gls/lc11/fr_ch

Installing directory gls/lc11/fr_fr

Installing directory gls/lc11/is_is

Installing directory gls/lc11/it_it

Installing directory gls/lc11/ja_jp

Installing directory gls/lc11/ko_kr

Installing directory gls/lc11/nl_be

Installing directory gls/lc11/nl_nl

Installing directory gls/lc11/no_no

Installing directory gls/lc11/os

Installing directory gls/lc11/pl_pl

Installing directory gls/lc11/pt_br

Installing directory gls/lc11/pt_pt

Installing directory gls/lc11/ru_ru

Installing directory gls/lc11/sk_sk

Installing directory gls/lc11/sv_se

Installing directory gls/lc11/th_th

Installing directory gls/lc11/zh_cn

Installing directory gls/lc11/zh_tw

IBM Informix Product: Gls

Installation Directory: /opt/informix

Performing root portion of installation of Gls...

Installation of Gls complete.

Installing directory etc

Installing directory msg

Installing directory msg/en_us

Installing directory msg/en_us/0333

IBM Informix Product: messages

Installation Directory: /opt/informix

Performing root portion of installation of messages...

Installation of messages complete.

-------------------------------------------------------------------------------

The InstallShield Wizard has successfully installed IBM Informix Client-SDK

Version 3.50. Choose Finish to exit the wizard.

Press 3 to Finish or 4 to Redisplay [3] （回车）

/opt/informix #

2.设置root环境变量

1)./etc/profile

# End of /etc/profile

export INFORMIXDIR=/opt/informix

export INFORMIXSERVER=ol_informix001(server_name)

export LD_LIBRARY_PATH=$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql

export PATH=$PATH:$INFORMIXDIR/bin

export DBI_DBNAME=stores_demo(database)

export DBD_INFORMIX_DATABASE=stores_demo(database)

export DBD_INFORMIX_USERNAME=informix(user)

export DBD_INFORMIX_PASSWORD=informix(name)

2).配置sqlhosts

# more /opt/informix/etc/sqlhosts

# ************************************************************************

# IBM INC.

# PROPRIETARY DATA

# Licensed Material - Property Of IBM

# "Restricted Materials of IBM"

# IBM Informix Client SDK

# Title: sqlhosts.demo

# Description:

# Default sqlhosts file for running demos.

#**************************************************************************

ol_informix001 onsoctcp 192.168.0.1 2008

3.安装Test-Pod

root用户登录编译

Test-Pod-1.48.tar.gz

4.编译Perl Informix DBD 模块

1）rpm 包需求

perl-5.10.0-64.47.8

perl-DBI-1.607-1.16

2）编译安装DBD-Informix

informix账户登录执行安装

> tar zxvf DBD-Informix-2013.0521.tar.gz

DBD-Informix-2013.0521/

DBD-Informix-2013.0521/Announce

DBD-Informix-2013.0521/bug-lvcnn.ec

DBD-Informix-2013.0521/bug-lvcnn.pl

DBD-Informix-2013.0521/BugReport

DBD-Informix-2013.0521/ChangeLog

DBD-Informix-2013.0521/DBD-Informix.jdc

DBD-Informix-2013.0521/DBD-Informix.msd

DBD-Informix-2013.0521/DBD-Informix.nmd

DBD-Informix-2013.0521/dbdattr.ec

DBD-Informix-2013.0521/dbdimp.ec

DBD-Informix-2013.0521/dbdimp.h

DBD-Informix-2013.0521/dbdixmap.h

DBD-Informix-2013.0521/debug.h

DBD-Informix-2013.0521/decfix.c

DBD-Informix-2013.0521/decsci.c

DBD-Informix-2013.0521/decsci.h

DBD-Informix-2013.0521/decsetexp.c

DBD-Informix-2013.0521/dumpesql.h

DBD-Informix-2013.0521/eprintf.c

DBD-Informix-2013.0521/esql5_00.h

DBD-Informix-2013.0521/esql7_20.h

DBD-Informix-2013.0521/esql_ius.h

DBD-Informix-2013.0521/esqlbasic.ec

DBD-Informix-2013.0521/esqlc.h

DBD-Informix-2013.0521/esqlc_v5.ec

DBD-Informix-2013.0521/esqlc_v6.ec

DBD-Informix-2013.0521/esqlcc

DBD-Informix-2013.0521/esqlcver.ec

DBD-Informix-2013.0521/esqlld

DBD-Informix-2013.0521/esqllib.h

DBD-Informix-2013.0521/esqlperl.h

DBD-Informix-2013.0521/esqlsed

DBD-Informix-2013.0521/esqltest.ec

DBD-Informix-2013.0521/esqltype.h

DBD-Informix-2013.0521/esqlutil.h

DBD-Informix-2013.0521/examples/

DBD-Informix-2013.0521/ifmxdec.h

DBD-Informix-2013.0521/inc/

DBD-Informix-2013.0521/Informix.h

DBD-Informix-2013.0521/Informix.pm

DBD-Informix-2013.0521/Informix.xs

DBD-Informix-2013.0521/InformixTechSupport

DBD-Informix-2013.0521/ItWorks

DBD-Informix-2013.0521/ixblob.ec

DBD-Informix-2013.0521/ixblob.h

DBD-Informix-2013.0521/jtypes.c

DBD-Informix-2013.0521/kludge.c

DBD-Informix-2013.0521/kludge.h

DBD-Informix-2013.0521/lib/

DBD-Informix-2013.0521/link.c

DBD-Informix-2013.0521/link.h

DBD-Informix-2013.0521/Makefile.PL

DBD-Informix-2013.0521/MANIFEST

DBD-Informix-2013.0521/META.yml

DBD-Informix-2013.0521/mknmd.sh

DBD-Informix-2013.0521/Notes/

DBD-Informix-2013.0521/odbctype.c

DBD-Informix-2013.0521/odbctype.h

DBD-Informix-2013.0521/prodverstamp.sh

DBD-Informix-2013.0521/README

DBD-Informix-2013.0521/Release.Checklist

DBD-Informix-2013.0521/sqltoken.c

DBD-Informix-2013.0521/sqltoken.h

DBD-Informix-2013.0521/sqltype.ec

DBD-Informix-2013.0521/t/

DBD-Informix-2013.0521/test.all.sh

DBD-Informix-2013.0521/test.c4gl.sh

DBD-Informix-2013.0521/test.one.sh

DBD-Informix-2013.0521/test.quiet.sh

DBD-Informix-2013.0521/test.run.sh

DBD-Informix-2013.0521/TODO

DBD-Informix-2013.0521/t/decgen.pl

DBD-Informix-2013.0521/t/dtgen.pl

DBD-Informix-2013.0521/t/t00basic.t

DBD-Informix-2013.0521/t/t01stproc.t

DBD-Informix-2013.0521/t/t02ixtype.t

DBD-Informix-2013.0521/t/t05dbase.t

DBD-Informix-2013.0521/t/t07dblist.t

DBD-Informix-2013.0521/t/t08fork.t

DBD-Informix-2013.0521/t/t09date.t

DBD-Informix-2013.0521/t/t10sqlca.t

DBD-Informix-2013.0521/t/t12bindval.t

DBD-Informix-2013.0521/t/t13bindref.t

DBD-Informix-2013.0521/t/t14bindcol.t

DBD-Informix-2013.0521/t/t15bindtyp.t

DBD-Informix-2013.0521/t/t20error.t

DBD-Informix-2013.0521/t/t21mconn.t

DBD-Informix-2013.0521/t/t22mconn.t

DBD-Informix-2013.0521/t/t23mconn.t

DBD-Informix-2013.0521/t/t24mcurs.t

DBD-Informix-2013.0521/t/t25dratt.t

DBD-Informix-2013.0521/t/t28dtlit.t

DBD-Informix-2013.0521/t/t29update.t

DBD-Informix-2013.0521/t/t30update.t

DBD-Informix-2013.0521/t/t31nulls.t

DBD-Informix-2013.0521/t/t32nulls.t

DBD-Informix-2013.0521/t/t33holdcurs.t

DBD-Informix-2013.0521/t/t35cursor.t

DBD-Informix-2013.0521/t/t40rows.t

DBD-Informix-2013.0521/t/t41txacoff.t

DBD-Informix-2013.0521/t/t42txacon.t

DBD-Informix-2013.0521/t/t43trans.t

DBD-Informix-2013.0521/t/t44txansi.t

DBD-Informix-2013.0521/t/t46chpblk.t

DBD-Informix-2013.0521/t/t50update.t

DBD-Informix-2013.0521/t/t51getinfo.t

DBD-Informix-2013.0521/t/t53types.t

DBD-Informix-2013.0521/t/t54native.t

DBD-Informix-2013.0521/t/t55mdata.t

DBD-Informix-2013.0521/t/t56tabinfo.t

DBD-Informix-2013.0521/t/t57tables.t

DBD-Informix-2013.0521/t/t58typeinfoall.t

DBD-Informix-2013.0521/t/t60unlog.t

DBD-Informix-2013.0521/t/t61varchar.t

DBD-Informix-2013.0521/t/t65updcur.t

DBD-Informix-2013.0521/t/t66insert.t

DBD-Informix-2013.0521/t/t72blob.t

DBD-Informix-2013.0521/t/t73blobupd.t

DBD-Informix-2013.0521/t/t74blob.t

DBD-Informix-2013.0521/t/t75blob.t

DBD-Informix-2013.0521/t/t76blob.t

DBD-Informix-2013.0521/t/t77varchar.t

DBD-Informix-2013.0521/t/t78varchar.t

DBD-Informix-2013.0521/t/t90ius.t

DBD-Informix-2013.0521/t/t91udts.t

DBD-Informix-2013.0521/t/t92rows.t

DBD-Informix-2013.0521/t/t93lvarchar.t

DBD-Informix-2013.0521/t/t94bool.t

DBD-Informix-2013.0521/t/t95int8.t

DBD-Informix-2013.0521/t/t98pod.t

DBD-Informix-2013.0521/t/t99clean.t

DBD-Informix-2013.0521/Notes/bug.reports

DBD-Informix-2013.0521/Notes/environment.variables

DBD-Informix-2013.0521/Notes/eprintf

DBD-Informix-2013.0521/Notes/FAQ

DBD-Informix-2013.0521/Notes/hpux

DBD-Informix-2013.0521/Notes/hpux-gcc-build.sh

DBD-Informix-2013.0521/Notes/linux

DBD-Informix-2013.0521/Notes/load.unload

DBD-Informix-2013.0521/Notes/nonroot.install

DBD-Informix-2013.0521/Notes/nt

DBD-Informix-2013.0521/Notes/olipcshm

DBD-Informix-2013.0521/Notes/static.build

DBD-Informix-2013.0521/Notes/web.servers

DBD-Informix-2013.0521/Notes/Working.Versions

DBD-Informix-2013.0521/lib/Bundle/

DBD-Informix-2013.0521/lib/DBD/

DBD-Informix-2013.0521/lib/DBD/Informix/

DBD-Informix-2013.0521/lib/DBD/Informix/Configure.pm

DBD-Informix-2013.0521/lib/DBD/Informix/GetInfo.pm

DBD-Informix-2013.0521/lib/DBD/Informix/Metadata.pm

DBD-Informix-2013.0521/lib/DBD/Informix/Summary.pm

DBD-Informix-2013.0521/lib/DBD/Informix/TechSupport.pm

DBD-Informix-2013.0521/lib/DBD/Informix/TestHarness.pm

DBD-Informix-2013.0521/lib/DBD/Informix/TypeInfo.pm

DBD-Informix-2013.0521/lib/Bundle/DBD/

DBD-Informix-2013.0521/lib/Bundle/DBD/Informix.pm

DBD-Informix-2013.0521/inc/ExtUtils/

DBD-Informix-2013.0521/inc/ExtUtils/AutoInstall.pm

DBD-Informix-2013.0521/examples/fetchscroll.pl

DBD-Informix-2013.0521/examples/fixin.pl

DBD-Informix-2013.0521/examples/README

DBD-Informix-2013.0521/examples/x01fetchall.pl

DBD-Informix-2013.0521/examples/x02fetchrow_array.pl

DBD-Informix-2013.0521/examples/x03fetchrow_arrayref.pl

DBD-Informix-2013.0521/examples/x04fetchrow_hashref.pl

DBD-Informix-2013.0521/examples/x05fetchall_arrayref.pl

DBD-Informix-2013.0521/examples/x06chopblanks.pl

DBD-Informix-2013.0521/examples/x07fetchrow_array.pl

DBD-Informix-2013.0521/examples/x10cgi_nodbi.pl

DBD-Informix-2013.0521/examples/x11cgi_nodbi.pl

DBD-Informix-2013.0521/examples/x12cgi_noform.pl

DBD-Informix-2013.0521/examples/x13cgi_noform.pl

DBD-Informix-2013.0521/examples/x14cgi_form.pl

DBD-Informix-2013.0521/examples/x15cgi_form.pl

> cd DBD-Informix-2013.0521/

> perl Makefile.PL

*** ExtUtils::AutoInstall version 0.63

*** Checking for dependencies...

[Core Features]

- DBI ...loaded. (1.607 >= 1.38)

[High Resolution Timing]

- Time::HiRes ...loaded. (1.9711)

[POD Format Testing]

- Test::Pod ...loaded. (1.48)

*** ExtUtils::AutoInstall configuration finished.

Configuring Informix Database Driver for Perl DBI Version 2013.0521 (2013-05-21) (aka DBD::Informix)

You are using DBI version 1.607 and Perl version 5.010000

Remember to actually read the README file!

Perl: /usr/bin/perl v5.010000 x86_64-linux-thread-multi dl_dlopen.xs

System: linux knorr 2.6.32 #1 smp 2010-04-12 12:31:11 +0200 x86_64 x86_64 x86_64 gnulinux

*** Ideally, you should upgrade to Perl version 5.016003 or later.

*** Ideally, you should upgrade to DBI version 1.627 or later.

Using INFORMIXDIR=/opt/informix and ESQL/C compiler esql

Using IBM Informix CSDK Version 3.50, IBM Informix-ESQL Version 3.50.FC5 from /opt/informix

Beware: DBD::Informix is not yet aware of all the new IUS data types.

Assert macro will be disabled!

lib/DBD/Informix/Defaults.pm written OK

esqlinfo.h written OK

Testing whether your Informix test environment will work...

ESQLTEST Program Running:

@(#)$Id: esqltest.ec,v 2008.1 2008/05/13 23:13:10 jleffler Exp $

$INFORMIXDIR is set to ‘/opt/informix‘.

$INFORMIXSERVER is set to ‘ol_informix1170‘.

$DBI_DBNAME set to ‘demo‘.

$DBD_INFORMIX_DATABASE set to ‘stores_demo‘.

$DBD_INFORMIX_DATABASE2 unset - defaulting to ‘stores_demo‘.

$DBD_INFORMIX_USERNAME is set to ‘informix‘.

$DBD_INFORMIX_USERNAME2 is unset - defaulting to ‘informix‘.

$DBD_INFORMIX_PASSWORD is set.

$DBD_INFORMIX_PASSWORD2 is unset - defaulting to $DBD_INFORMIX_PASSWORD.

Testing connection to stores_demo

CONNECT TO ‘stores_demo‘ with user info

Testing concurrent connection to stores_demo

CONNECT TO ‘stores_demo‘ with user info

Your Informix environment is (probably) OK

Checking if your kit is complete...

Looks good

Using DBI 1.607 (for perl 5.010000 on x86_64-linux-thread-multi) installed in /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI/

Writing Makefile for DBD::Informix

informix@WebReportServ:/home/informix-dbd/DBD-Informix-2013.0521> make

cp lib/DBD/Informix/Summary.pm blib/lib/DBD/Informix/Summary.pm

cp lib/DBD/Informix/TechSupport.pm blib/lib/DBD/Informix/TechSupport.pm

cp lib/DBD/Informix/GetInfo.pm blib/lib/DBD/Informix/GetInfo.pm

cp lib/Bundle/DBD/Informix.pm blib/lib/Bundle/DBD/Informix.pm

cp lib/DBD/Informix/Configure.pm blib/lib/DBD/Informix/Configure.pm

cp Informix.pm blib/lib/DBD/Informix.pm

cp lib/DBD/Informix/TestHarness.pm blib/lib/DBD/Informix/TestHarness.pm

cp lib/DBD/Informix/TypeInfo.pm blib/lib/DBD/Informix/TypeInfo.pm

cp lib/DBD/Informix/Defaults.pm blib/lib/DBD/Informix/Defaults.pm

cp lib/DBD/Informix/Metadata.pm blib/lib/DBD/Informix/Metadata.pm

/usr/bin/perl -p -e "s/~DRIVER~/Informix/g" /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI/Driver.xst > Informix.xsi

/usr/bin/perl /usr/lib/perl5/5.10.0/ExtUtils/xsubpp -typemap /usr/lib/perl5/5.10.0/ExtUtils/typemap Informix.xs > Informix.xsc && mv Informix.xsc Informix.c

cc -c -I/opt/informix/incl/esql -I/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DPERL_USE_SAFE_PUTENV -DDEBUGGING -fno-strict-aliasing -pipe -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fmessage-length=0 -O2 -Wall -D_FORTIFY_SOURCE=2 -fstack-protector -funwind-tables -fasynchronous-unwind-tables -g -Wall -pipe -DVERSION=\"2013.0521\" -DXS_VERSION=\"2013.0521\" -fPIC "-I/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/CORE" -DESQLC_VERSION=350 -DNDEBUG -DDO_NOT_USE_STDERR_H -DESQLC_IFX_LOC_T Informix.c

Informix.xsi: In function 鈥榅S_DBD__Informix__db_disconnect鈥

Informix.xsi:306: warning: format 鈥ld鈥expects type 鈥榣ong int鈥 but argument 2 has type 鈥業32鈥

Informix.xsi:306: warning: format 鈥ld鈥expects type 鈥榣ong int鈥 but argument 3 has type 鈥業32鈥

Informix.xsi: In function 鈥榅S_DBD__Informix__db_DESTROY鈥

Informix.xsi:352: warning: format 鈥ld鈥expects type 鈥榣ong int鈥 but argument 2 has type 鈥業32鈥

Informix.xsi:352: warning: format 鈥ld鈥expects type 鈥榣ong int鈥 but argument 3 has type 鈥業32鈥

Informix.xsi:380: warning: format 鈥ld鈥expects type 鈥榣ong int鈥 but argument 2 has type 鈥業32鈥

Informix.xsi:380: warning: format 鈥ld鈥expects type 鈥榣ong int鈥 but argument 3 has type 鈥業32鈥

Informix.xsi: In function 鈥榅S_DBD__Informix__st_finish鈥

Informix.xsi:675: warning: format 鈥ld鈥expects type 鈥榣ong int鈥 but argument 2 has type 鈥業32鈥

Informix.xsi:675: warning: format 鈥ld鈥expects type 鈥榣ong int鈥 but argument 3 has type 鈥業32鈥

Informix.xsi: In function 鈥榅S_DBD__Informix__st_DESTROY鈥

Informix.xsi:752: warning: format 鈥ld鈥expects type 鈥榣ong int鈥 but argument 2 has type 鈥業32鈥

Informix.xsi:752: warning: format 鈥ld鈥expects type 鈥榣ong int鈥 but argument 3 has type 鈥業32鈥

Informix.xsi:766: warning: format 鈥ld鈥expects type 鈥榣ong int鈥 but argument 2 has type 鈥業32鈥

Informix.xsi:766: warning: format 鈥ld鈥expects type 鈥榣ong int鈥 but argument 3 has type 鈥業32鈥

INFORMIXC="/usr/bin/perl esqlcc" ESQLCC="cc" esql -c -shared -I/opt/informix/incl/esql -I/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DPERL_USE_SAFE_PUTENV -DDEBUGGING -fno-strict-aliasing -pipe -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fmessage-length=0 -O2 -Wall -D_FORTIFY_SOURCE=2 -fstack-protector -funwind-tables -fasynchronous-unwind-tables -g -Wall -pipe -DVERSION=\"2013.0521\" -DXS_VERSION=\"2013.0521\" -fPIC -I/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/CORE -DESQLC_VERSION=350 -DNDEBUG -DDO_NOT_USE_STDERR_H -DESQLC_IFX_LOC_T dbdimp.ec

dbdimp.ec: In function 鈥榙bd_ix_db_connect鈥

dbdimp.ec:623: warning: format 鈥ld鈥expects type 鈥榣ong int鈥 but argument 2 has type 鈥業32鈥

dbdimp.ec:623: warning: format 鈥ld鈥expects type 鈥榣ong int鈥 but argument 3 has type 鈥業32鈥

dbdimp.ec: In function 鈥榙bd_ix_db_disconnect鈥

dbdimp.ec:909: warning: format 鈥ld鈥expects type 鈥榣ong int鈥 but argument 2 has type 鈥業32鈥

dbdimp.ec:909: warning: format 鈥ld鈥expects type 鈥榣ong int鈥 but argument 3 has type 鈥業32鈥

dbdimp.ec: In function 鈥榙bd_ix_st_finish鈥

dbdimp.ec:2201: warning: format 鈥ld鈥expects type 鈥榣ong int鈥 but argument 2 has type 鈥業32鈥

dbdimp.ec:2201: warning: format 鈥ld鈥expects type 鈥榣ong int鈥 but argument 3 has type 鈥業32鈥

dbdimp.ec: In function 鈥榙bd_ix_st_bind_type鈥

dbdimp.ec:3174: warning: format 鈥d鈥expects type 鈥榠nt鈥 but argument 2 has type 鈥業V鈥

rm -f dbdimp.c

rm -f dbdattr.c

rm -f sqltype.c

rm -f ixblob.c

rm -f esqlcver.c

rm -f esqlc_v6.c

Running Mkbootstrap for DBD::Informix ()

chmod 644 Informix.bs

rm -f blib/arch/auto/DBD/Informix/Informix.so

INFORMIXC=‘/usr/bin/perl esqlld‘ ESQLLD=‘cc -shared -L/usr/local/lib64‘ esql -shared -L/usr/local/lib64 Informix.o dbdimp.o dbdattr.o sqltoken.o sqltype.o ixblob.o odbctype.o kludge.o link.o esqlcver.o esqlc_v6.o -o blib/arch/auto/DBD/Informix/Informix.so \

chmod 755 blib/arch/auto/DBD/Informix/Informix.so

cp Informix.bs blib/arch/auto/DBD/Informix/Informix.bs

chmod 644 blib/arch/auto/DBD/Informix/Informix.bs

cp InformixTechSupport blib/script/InformixTechSupport

/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/InformixTechSupport

Manifying blib/man1/InformixTechSupport.1

Manifying blib/man3/DBD::Informix::TechSupport.3pm

Manifying blib/man3/DBD::Informix::Summary.3pm

Manifying blib/man3/DBD::Informix::Configure.3pm

Manifying blib/man3/DBD::Informix::TypeInfo.3pm

Manifying blib/man3/DBD::Informix::TestHarness.3pm

Manifying blib/man3/DBD::Informix::GetInfo.3pm

Manifying blib/man3/Bundle::DBD::Informix.3pm

Manifying blib/man3/DBD::Informix.3pm

Manifying blib/man3/DBD::Informix::Defaults.3pm

Manifying blib/man3/DBD::Informix::Metadata.3pm

> make test

PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, ‘blib/lib‘, ‘blib/arch‘)" t/t00basic.t t/t01stproc.t t/t02ixtype.t t/t05dbase.t t/t07dblist.t t/t08fork.t t/t09date.t t/t10sqlca.t t/t12bindval.t t/t13bindref.t t/t14bindcol.t t/t15bindtyp.t t/t20error.t t/t21mconn.t t/t22mconn.t t/t23mconn.t t/t24mcurs.t t/t25dratt.t t/t28dtlit.t t/t29update.t t/t30update.t t/t31nulls.t t/t32nulls.t t/t33holdcurs.t t/t35cursor.t t/t40rows.t t/t41txacoff.t t/t42txacon.t t/t43trans.t t/t44txansi.t t/t46chpblk.t t/t50update.t t/t51getinfo.t t/t53types.t t/t54native.t t/t55mdata.t t/t56tabinfo.t t/t57tables.t t/t58typeinfoall.t t/t60unlog.t t/t61varchar.t t/t65updcur.t t/t66insert.t t/t72blob.t t/t73blobupd.t t/t74blob.t t/t75blob.t t/t76blob.t t/t77varchar.t t/t78varchar.t t/t90ius.t t/t91udts.t t/t92rows.t t/t93lvarchar.t t/t94bool.t t/t95int8.t t/t98pod.t t/t99clean.t

t/t00basic.t ........ ok

t/t01stproc.t ....... ok

t/t02ixtype.t ....... ok

t/t05dbase.t ........ ok

t/t07dblist.t ....... skipped: DBI->data_sources(‘Informix‘) because of username/password

t/t08fork.t ......... ok

t/t09date.t ......... ok

t/t10sqlca.t ........ ok

t/t12bindval.t ...... ok

t/t13bindref.t ...... skipped: bind_param_inout not supported by DBD::Informix

t/t14bindcol.t ...... ok

t/t15bindtyp.t ...... ok

t/t20error.t ........ ok

t/t21mconn.t ........ ok

t/t22mconn.t ........ ok

t/t23mconn.t ........ ok

t/t24mcurs.t ........ ok

t/t25dratt.t ........ ok

t/t28dtlit.t ........ ok

t/t29update.t ....... ok

t/t30update.t ....... ok

t/t31nulls.t ........ ok

t/t32nulls.t ........ ok

t/t33holdcurs.t ..... ok

t/t35cursor.t ....... ok

t/t40rows.t ......... ok

t/t41txacoff.t ...... ok

t/t42txacon.t ....... ok

t/t43trans.t ........ ok

t/t44txansi.t ....... skipped: MODE ANSI test - database ‘stores_demo‘ is not MODE ANSI

t/t46chpblk.t ....... ok

t/t50update.t ....... skipped: MODE ANSI test - database ‘stores_demo‘ is not MODE ANSI

t/t51getinfo.t ...... ok

t/t53types.t ........ ok

t/t54native.t ....... ok

t/t55mdata.t ........ ok

t/t56tabinfo.t ...... ok

t/t57tables.t ....... ok

t/t58typeinfoall.t .. ok

t/t60unlog.t ........ ok

t/t61varchar.t ...... ok

t/t65updcur.t ....... ok

t/t66insert.t ....... ok

t/t72blob.t ......... ok

t/t73blobupd.t ...... ok

t/t74blob.t ......... ok

t/t75blob.t ......... ok

t/t76blob.t ......... ok

t/t77varchar.t ...... ok

t/t78varchar.t ...... DBD::Informix::st execute failed: SQL: -2: No such file or directory at t/t78varchar.t line 55.

!! Terminating Test !!

at /home/informix-dbd/DBD-Informix-2013.0521/blib/lib/DBD/Informix/TestHarness.pm line 309

DBD::Informix::TestHarness::stmt_fail() called at t/t78varchar.t line 55

t/t78varchar.t ...... Dubious, test returned 255 (wstat 65280, 0xff00)

Failed 3/5 subtests

t/t90ius.t .......... ok

t/t91udts.t ......... ok

t/t92rows.t ......... ok

t/t93lvarchar.t ..... ok

t/t94bool.t ......... ok

t/t95int8.t ......... ok

t/t98pod.t .......... ok

t/t99clean.t ........ ok

Test Summary Report

-------------------

t/t78varchar.t (Wstat: 65280 Tests: 3 Failed: 1)

Failed test: 3

Non-zero exit status: 255

Parse errors: Bad plan. You planned 5 tests but ran 3.

Files=58, Tests=848, 648 wallclock secs ( 0.87 usr 0.14 sys + 4.65 cusr 0.62 csys = 6.28 CPU)

Result: FAIL

Failed 1/58 test programs. 1/848 subtests failed.

make: *** [test_dynamic] Error 255

informix@WebReportServ:/home/informix-dbd/DBD-Informix-2013.0521> su -c "make install"

Password:

Files found in blib/arch: installing files in blib/lib into architecture dependent library tree

Installing /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/Informix/Informix.so

Installing /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/Informix/Informix.bs

Installing /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/Bundle/DBD/Informix.pm

Installing /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/DBD/Informix.pm

Installing /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/DBD/Informix/Summary.pm

Installing /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/DBD/Informix/Configure.pm

Installing /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/DBD/Informix/GetInfo.pm

Installing /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/DBD/Informix/Metadata.pm

Installing /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/DBD/Informix/TypeInfo.pm

Installing /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/DBD/Informix/Defaults.pm

Installing /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/DBD/Informix/TechSupport.pm

Installing /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/DBD/Informix/TestHarness.pm

Installing /usr/share/man/man1/InformixTechSupport.1

Installing /usr/share/man/man3/DBD::Informix::TypeInfo.3pm

Installing /usr/share/man/man3/DBD::Informix::Defaults.3pm

Installing /usr/share/man/man3/DBD::Informix::GetInfo.3pm

Installing /usr/share/man/man3/DBD::Informix::Configure.3pm

Installing /usr/share/man/man3/DBD::Informix::TechSupport.3pm

Installing /usr/share/man/man3/DBD::Informix::Metadata.3pm

Installing /usr/share/man/man3/DBD::Informix::TestHarness.3pm

Installing /usr/share/man/man3/DBD::Informix::Summary.3pm

Installing /usr/share/man/man3/DBD::Informix.3pm

Installing /usr/share/man/man3/Bundle::DBD::Informix.3pm

Installing /usr/bin/InformixTechSupport

Writing /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/Informix/.packlist

Appending installation info to /usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/perllocal.pod

5.测试脚本

1）.create table

# more testInfix_create.pl

use DBI;

printf("Create Table Sample DBD::Informix Program running.\n");

my($user)="informix";

my($passwd)="informix";

my($database)="stores_demo";

my($dbh) = DBI->connect("DBI:Informix:$database",$user,$passwd) or die;

my $prep = "create table table01(

id serial not null,

msg char (200)

)";

my($sth) = $dbh->prepare($prep) or die;

$sth->execute() or die;

$dbh->disconnect();

printf("\nCreate Table Sample Program over.\n\n");

2）.insert record

# more testInfix_insert.pl

use DBI;

printf("Insert Record Into Table Sample DBD::Informix Program running.\n");

my($user)="informix";

my($passwd)="informix";

my($database)="stores_demo";

my($dbh) = DBI->connect("DBI:Informix:$database",$user,$passwd) or die;

my $prep = "insert into table01(msg) values(‘event01‘)";

my($sth) = $dbh->prepare($prep) or die;

$sth->execute() or die;

$dbh->disconnect();

printf("\nInsert Record Into Table Sample Program over.\n\n");

3）.read records

# more testInfix.pl

use strict;

use DBI;

printf("Read Records From Table Sample DBD::Informix Program running.\n");

my($user)="informix";

my($passwd)="informix";

my($database)="stores_demo";

my($dbh) = DBI->connect("DBI:Informix:$database",$user,$passwd) or die;

my $prep = "SELECT * FROM table01";

my($sth) = $dbh->prepare($prep) or die;

$sth->execute() or die;

my($id,$msg);

while (($id,$msg) = $sth->fetchrow_array()) {

printf("%s %s \n", ($id,$msg));

} undef $sth;

$dbh->disconnect();

printf("\nRead Records From Table Sample Program over.\n\n");

本文出自 “yiyi” 博客，请务必保留此出处http://heyiyi.blog.51cto.com/205455/1600615

perl DBD Informix install and test

声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉：投诉/举报工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。

联系
我们

首页 > 代码库 > perl DBD Informix install and test

perl DBD Informix install and test

看完仍有疑问？有类似问题直接问程序猿