This queue is for tickets about the Msql-Mysql-modules CPAN distribution.

Report information
The Basics

Nobody in particular
dmadrid [...]

Broken in:
Fixed in:
(no value)

Subject: mSQL and Perl
I can't seem to build perl-5.6.1 with DBI and DBD. I appreciate your time and assistance in this issue. I'm running OSF1 qxms V5.1 1885 alpha on a Compaq Cluster. My goal is to access the Compaq SC Cluster Management RMS database. ************************************ The perl code and resulting error message is : qxms:~ [108] > cat #!/usr/local/gnu/packages/perl-5.6.1-db/bin/perl # # Perl mini script to test database calls on rms database # Author: Diane Madrid # Date: Jun 2002 # use DBI; $driver = "mSQL"; $database = "rms-qx"; $hostname="qxms"; $dsn = "DBI:$driver:database=$database;host=$hostname"; print "$dsn \n"; $dbh=DBI->connect($dsn, undef, undef) || die ("Connect error: $DBI::errstr"); $drh = DBI->install_driver("msql"); $sth=$dbh->prepare("select name,username,hostnames,startTime,endTime from resources where username='toh'") || die ("Prepare error: $DBI::errstr"); @db_array = $sth->fetchrow_array || die ("Connect error: $DBI::errstr"); print("db_array is @db_array"); $sth->finish; $result=$dbh->disconnect || die ("Disconnect error: $DBI::errstr"); qxms:~ [109] > perl DBI:mSQL:database=rms-qx;host=qxms install_driver(mSQL) failed: Can't find 'boot_DBD__mSQL' symbol in /usr/local/gnu/packages/perl-5.6.1-db/lib/ at (eval 1) line 3 Compilation failed in require at (eval 1) line 3. at line 16 qxms:~ [110] > ****************************************************** HOW PERL WAS BUILT. I started from scratch and build perl-5.6.1, perl DBI, DBD and Data-ShowTable-3.3. Below is the output from building DBI-1.28 and root@qxms:/<2>gnu/packages/perl-5.6.1-db [20] # cd DBI-1.28/ root@qxms:/<3>packages/perl-5.6.1-db/DBI-1.28 [21] # ls ./ Driver.xst Makefile.PL* ToDo dbipport.h lib/ ../ DBI.xs Driver_xst.h Perl.xs dbd_xsh.h dbiproxy.PL t/ Changes DBIXS.h MANIFEST README dbi_sql.h dbish.PL* root@qxms:/<3>packages/perl-5.6.1-db/DBI-1.28 [22] # perl Makefile.pL Can't open perl script "Makefile.pL": No such file or directory root@qxms:/<3>packages/perl-5.6.1-db/DBI-1.28 [23] # perl Makefile.PL *** Note: The optional PlRPC-modules (RPC::PlServer etc) are not installed. If you want to use the DBD::Proxy driver and DBI::ProxyServer modules, then you'll need to install the RPC::PlServer, RPC::PlClient, Storable and Net::Daemon modules. The CPAN Bundle::DBI may help you. You can install them any time after installing the DBI. You do *not* need these modules for typical DBI usage. Optional modules are available from any CPAN mirror, in particular Creating extra DBI::PurePerl test: t/zz_01basics_pp.t Creating extra DBI::PurePerl test: t/zz_02dbidrv_pp.t Creating extra DBI::PurePerl test: t/zz_03hleak_pp.t Creating extra DBI::PurePerl test: t/zz_04mods_pp.t Creating extra DBI::PurePerl test: t/zz_10examp_pp.t Creating extra DBI::PurePerl test: t/zz_15array_pp.t Creating extra DBI::PurePerl test: t/zz_20meta_pp.t Creating extra DBI::PurePerl test: t/zz_30subclass_pp.t Creating extra DBI::PurePerl test: t/zz_40profile_pp.t Creating extra DBI::PurePerl test: t/zz_60preparse_pp.t Creating extra DBI::PurePerl test: t/zz_70shell_pp.t Creating extra DBI::PurePerl test: t/zz_80proxy_pp.t Checking if your kit is complete... Looks good Warning: By default new modules are installed into your 'site_lib' directories. Since site_lib directories come after the normal library directories you must delete old DBI files and directories from your 'privlib' and 'archlib' directories and their auto subdirectories. Reinstall DBI and your DBD::* drivers after deleting the old directories. Here's a list of probable old files and directories: /usr/local/gnu/packages/perl-5.6.1-db/lib/5.6.1/alpha-dec_osf/DBD Writing Makefile for DBI Remember to actually *read* the README file! Use 'make' to build the software (dmake or nmake on Windows). Then 'make test' to execute self tests. Then 'make install' to install the DBI and then delete this working directory before unpacking and building any DBD::* drivers. root@qxms:/<3>packages/perl-5.6.1-db/DBI-1.28 [24] # make ../perl -I../lib -I../lib -MExtUtils::Command -e mkpath blib/lib/DBI rm -f blib/lib/DBI/ cp Changes blib/lib/DBI/ cp Driver_xst.h blib/arch/auto/DBI/Driver_xst.h cp DBIXS.h blib/arch/auto/DBI/DBIXS.h cp lib/DBD/ blib/lib/DBD/ cp dbipport.h blib/arch/auto/DBI/dbipport.h cp lib/DBI/ blib/lib/DBI/ cp lib/DBI/Const/ blib/lib/DBI/Const/ cp dbd_xsh.h blib/arch/auto/DBI/dbd_xsh.h cp lib/DBI/Const/GetInfo/ blib/lib/DBI/Const/GetInfo/ cp lib/DBI/ blib/lib/DBI/ cp lib/DBI/ blib/lib/DBI/ cp lib/DBI/ blib/lib/DBI/ cp blib/lib/ cp lib/DBI/ blib/lib/DBI/ cp lib/DBD/ blib/lib/DBD/ cp lib/Bundle/ blib/lib/Bundle/ cp lib/Win32/ blib/lib/Win32/ cp lib/DBI/ blib/lib/DBI/ cp lib/DBI/ blib/lib/DBI/ cp lib/DBI/Const/ blib/lib/DBI/Const/ cp lib/DBI/ blib/lib/DBI/ cp lib/DBD/ blib/lib/DBD/ cp dbi_sql.h blib/arch/auto/DBI/dbi_sql.h cp Driver.xst blib/arch/auto/DBI/Driver.xst cp lib/DBI/Const/GetInfo/ blib/lib/DBI/Const/GetInfo/ cp lib/DBD/ blib/lib/DBD/ ../perl -p -e "s/~DRIVER~/Perl/g" < blib/arch/auto/DBI/Driver.xst > Perl.xsi ../perl -I../lib -I../lib ../lib/ExtUtils/xsubpp -typemap ../lib/ExtUtils/typemap Perl.xs > Perl.xsc && mv Perl.xsc Perl.c cc -c -std -fprm d -ieee -D_INTRINSICS -I/usr/local/include -DLANGUAGE_C -O4 -DVERSION=\"1.28\" -DXS_VERSION=\"1.28\" -I.. -DDBI_NO_THREADS Perl.c ../perl -I../lib -I../lib ../lib/ExtUtils/xsubpp -typemap ../lib/ExtUtils/typemap DBI.xs > DBI.xsc && mv DBI.xsc DBI.c cc -c -std -fprm d -ieee -D_INTRINSICS -I/usr/local/include -DLANGUAGE_C -O4 -DVERSION=\"1.28\" -DXS_VERSION=\"1.28\" -I.. -DDBI_NO_THREADS DBI.c Running Mkbootstrap for DBI () chmod 644 ar cr tmp.a DBI.o : tmp.a rm -f blib/arch/auto/DBI/ LD_RUN_PATH="" ld -shared -expect_unresolved "*" -O4 -msym -std -s -L/usr/local/lib -all tmp.a -none -o blib/arch/auto/DBI/ chmod 755 blib/arch/auto/DBI/ cp blib/arch/auto/DBI/ chmod 644 blib/arch/auto/DBI/ ../perl -Iblib/arch -Iblib/lib -I../lib -I../lib dbiproxy.PL dbiproxy Extracted dbiproxy from dbiproxy.PL with variable substitutions. cp dbiproxy blib/script/dbiproxy ../perl -I../lib -I../lib -MExtUtils::MakeMaker -e "MY->fixin(shift)" blib/script/dbiproxy ../perl -Iblib/arch -Iblib/lib -I../lib -I../lib dbish.PL dbish Extracted dbish from dbish.PL with variable substitutions. cp dbish blib/script/dbish ../perl -I../lib -I../lib -MExtUtils::MakeMaker -e "MY->fixin(shift)" blib/script/dbish Manifying blib/man3/DBD::Proxy.3 Manifying blib/man3/DBI::ProxyServer.3 Manifying blib/man3/DBI::Const::GetInfoType.3 Manifying blib/man3/DBI::Format.3 Manifying blib/man3/DBI::Const::GetInfoReturn.3 Manifying blib/man1/dbish.1 Manifying blib/man3/DBI::Const::GetInfo::ANSI.3 Manifying blib/man3/DBI::PurePerl.3 Manifying blib/man3/DBI::Profile.3 Manifying blib/man3/DBI::Shell.3 Manifying blib/man3/DBI::FAQ.3 Manifying blib/man3/DBI.3 Manifying blib/man3/Bundle::DBI.3 Manifying blib/man3/Win32::DBIODBC.3 Manifying blib/man1/dbiproxy.1 Manifying blib/man3/DBI::Const::GetInfo::ODBC.3 Manifying blib/man3/DBI::W32ODBC.3 Manifying blib/man3/DBI::DBD.3 root@qxms:/<3>packages/perl-5.6.1-db/DBI-1.28 [25] # make test PERL_DL_NONLAZY=1 ../perl -Iblib/arch -Iblib/lib -I../lib -I../lib -e 'use Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/01basics............ok t/02dbidrv............ok t/03hleak.............ok t/04mods..............ok t/10examp.............ok t/15array.............ok t/20meta..............ok t/30subclass..........ok t/40profile...........ok t/60preparse..........ok t/70shell.............ok t/80proxy.............skipped all skipped: modules required for proxy are probably not installed t/zz_01basics_pp...... Using DBI::PurePerl (DBI_PUREPERL=2) t/zz_01basics_pp......ok t/zz_02dbidrv_pp......ok t/zz_03hleak_pp.......ok t/zz_04mods_pp........ok t/zz_10examp_pp.......ok 53/215 Taint attribute tests skipped t/zz_10examp_pp.......ok t/zz_15array_pp.......ok t/zz_20meta_pp........ok t/zz_30subclass_pp....ok t/zz_40profile_pp.....skipped all skipped: profiling not supported for DBI::PurePerl t/zz_60preparse_pp....skipped all skipped: preparse not supported for DBI::PurePerl t/zz_70shell_pp.......ok t/zz_80proxy_pp.......skipped all skipped: modules required for proxy are probably not installed All tests successful, 4 tests skipped. Files=24, Tests=718, 15 wallclock secs (11.45 cusr + 1.90 csys = 13.35 CPU) PERL_DL_NONLAZY=1 ../perl -Iblib/arch -Iblib/lib -I../lib -I../lib DBI test application $Revision: 11.5 $ Using /usr/local/gnu/packages/perl-5.6.1-db/DBI-1.28/blib Switch: DBI 1.28 by Tim Bunce, 1.28 Available Drivers: ExampleP, Proxy, mSQL dbi:ExampleP:: testing 5 sets of 20 connections: Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Disconnecting... Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Disconnecting... Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Disconnecting... Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Disconnecting... Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Disconnecting... Made 100 connections in 0 wallclock secs ( 0.08 usr + 0.00 sys = 0.08 CPU) Testing handle creation speed... 10000 NullP statement handles cycled in 3.3 cpu+sys seconds (2985 per sec) done root@qxms:/<3>packages/perl-5.6.1-db/DBI-1.28 [26] # module list Currently Loaded Modulefiles: 1) perl_5.6.1-db root@qxms:/<3>packages/perl-5.6.1-db/DBI-1.28 [27] # make install Installing /usr/local/gnu/packages/perl-5.6.1-db/lib/site_perl/5.6.1/alpha-dec_osf/auto/DBI/ Files found in blib/arch: installing files in blib/lib into architecture dependent library tree Installing /usr/local/gnu/packages/perl-5.6.1-db/lib/site_perl/5.6.1/alpha-dec_osf/DBI/ Installing /usr/local/gnu/packages/perl-5.6.1-db/man/man1/dbish.1 Installing /usr/local/gnu/packages/perl-5.6.1-db/man/man1/dbiproxy.1 Installing /usr/local/gnu/packages/perl-5.6.1-db/man/man3/DBD::Proxy.3 Installing /usr/local/gnu/packages/perl-5.6.1-db/man/man3/DBI::ProxyServer.3 Installing /usr/local/gnu/packages/perl-5.6.1-db/man/man3/DBI::Const::GetInfoType.3 Installing /usr/local/gnu/packages/perl-5.6.1-db/man/man3/DBI::Format.3 Installing /usr/local/gnu/packages/perl-5.6.1-db/man/man3/DBI::Const::GetInfoReturn.3 Installing /usr/local/gnu/packages/perl-5.6.1-db/man/man3/DBI::Const::GetInfo::ANSI.3 Installing /usr/local/gnu/packages/perl-5.6.1-db/man/man3/DBI::PurePerl.3 Installing /usr/local/gnu/packages/perl-5.6.1-db/man/man3/DBI::Profile.3 Installing /usr/local/gnu/packages/perl-5.6.1-db/man/man3/DBI::Shell.3 Installing /usr/local/gnu/packages/perl-5.6.1-db/man/man3/DBI::FAQ.3 Installing /usr/local/gnu/packages/perl-5.6.1-db/man/man3/DBI.3 Installing /usr/local/gnu/packages/perl-5.6.1-db/man/man3/Bundle::DBI.3 Installing /usr/local/gnu/packages/perl-5.6.1-db/man/man3/Win32::DBIODBC.3 Installing /usr/local/gnu/packages/perl-5.6.1-db/man/man3/DBI::Const::GetInfo::ODBC.3 Installing /usr/local/gnu/packages/perl-5.6.1-db/man/man3/DBI::W32ODBC.3 Installing /usr/local/gnu/packages/perl-5.6.1-db/man/man3/DBI::DBD.3 Writing /usr/local/gnu/packages/perl-5.6.1-db/lib/site_perl/5.6.1/alpha-dec_osf/auto/DBI/.packlist Appending installation info to /usr/local/gnu/packages/perl-5.6.1-db/lib/5.6.1/alpha-dec_osf/perllocal.pod root@qxms:/<3>packages/perl-5.6.1-db/DBI-1.28 [28] # cd .. root@qxms:/<2>gnu/packages/perl-5.6.1-db [29] # ls Msql-Mysql-modules-1.2219 ./ MANIFEST* Makefile.PL* blib/ lib/ nodbd/ ../ MANIFEST.SKIP* Makefile.old dbd/ mSQL/ pm_to_blib ChangeLog* Makefile README* dbimon mysql/ tests/ root@qxms:/<2>gnu/packages/perl-5.6.1-db [30] # perl Makefile.PL Can't open perl script "Makefile.PL": No such file or directory root@qxms:/<2>gnu/packages/perl-5.6.1-db [31] # cd Msql-Mysql-modules-1.2219/ root@qxms:/<3>packages/perl-5.6.1-db/Msql-Mysql-modules-1.2219 [32] # root@qxms:/<3>packages/perl-5.6.1-db/Msql-Mysql-modules-1.2219 [33] # perl Makefile.PL Which drivers do you want to install? 1) MySQL only 2) mSQL only (either of mSQL 1 or mSQL 2) 3) MySQL and mSQL (either of mSQL 1 or mSQL 2) 4) mSQL 1 and mSQL 2 5) MySQL, mSQL 1 and mSQL 2 Enter the appropriate number: [3] 4 Do you want to install the MsqlPerl emulation? You might keep your old Mysql module (to be distinguished from DBD::mysql!) if you are concerned about compatibility to existing applications! [y] Using DBI 1.28 installed in /usr/local/gnu/packages/perl-5.6.1-db/lib/site_perl/5.6.1/alpha-dec_osf/auto/DBI Writing Makefile for DBD::mSQL Writing Makefile for Msql-Mysql-modules root@qxms:/<3>packages/perl-5.6.1-db/Msql-Mysql-modules-1.2219 [34] # make make[1]: Entering directory `/usr/local/gnu/packages/perl-5.6.1-db/Msql-Mysql-modules-1.2219/mSQL' ../../perl -I../blib/arch -I../blib/lib -I../../lib \ -I../../lib -I../lib -MExtUtils::PerlPP \ -e "ppp('../nodbd/', 'pmsql', '../lib/DBD/mSQL/Install/')" ../../perl -I../blib/arch -I../blib/lib -I../../lib \ -I../../lib -I../lib -MExtUtils::PerlPP \ -e "ppp('../tests/msql1.t', 't/msql1.t', '../lib/DBD/mSQL/Install/')" ../../perl -I../blib/arch -I../blib/lib -I../../lib \ -I../../lib -I../lib -MExtUtils::PerlPP \ -e "ppp('../tests/msql2.t', 't/msql2.t', '../lib/DBD/mSQL/Install/')" ../../perl -I../blib/arch -I../blib/lib -I../../lib \ -I../../lib -I../lib -MExtUtils::PerlPP \ -e "ppp('../tests/akmisc.t', 't/akmisc.t', '../lib/DBD/mSQL/Install/')" Skip ../blib/lib/ (unchanged) Skip ../blib/lib/DBD/ (unchanged) Skip ../blib/lib/Bundle/DBD/ (unchanged) Skip ../blib/lib/Msql/ (unchanged) cc -c -I/usr/local/gnu/packages/perl-5.6.1-db/lib/site_perl/5.6.1/alpha-dec_osf/auto/DBI -I../dbd -I/usr/opt/rms/include -I/usr/local/gnu/packages/perl-5.6.1-db/lib/site_perl/5.6.1/alpha-dec_osf/auto/DBI -I/usr/local/gnu/packages/perl-5.6.1-db/lib/5.6.1/alpha-dec_osf -std -fprm d -ieee -D_INTRINSICS -I/usr/local/include -DLANGUAGE_C -O4 -DVERSION=\"2.0419\" -DXS_VERSION=\"2.0419\" -I../.. -DDBD_MSQL dbdimp.c cc -c -I/usr/local/gnu/packages/perl-5.6.1-db/lib/site_perl/5.6.1/alpha-dec_osf/auto/DBI -I../dbd -I/usr/opt/rms/include -I/usr/local/gnu/packages/perl-5.6.1-db/lib/site_perl/5.6.1/alpha-dec_osf/auto/DBI -I/usr/local/gnu/packages/perl-5.6.1-db/lib/5.6.1/alpha-dec_osf -std -fprm d -ieee -D_INTRINSICS -I/usr/local/include -DLANGUAGE_C -O4 -DVERSION=\"2.0419\" -DXS_VERSION=\"2.0419\" -I../.. -DDBD_MSQL mSQL.c cc: Warning: mSQL.xs, line 44: In this statement, "msqlUnixTimeToDate(...)" of type "int", is being converted to "pointer to char". (cvtdiftypes) RETVAL = msqlUnixTimeToDate(clock); ----^ cc: Warning: mSQL.xs, line 53: In this statement, "msqlUnixTimeToTime(...)" of type "int", is being converted to "pointer to char". (cvtdiftypes) RETVAL = msqlUnixTimeToTime(clock); ----^ Running Mkbootstrap for DBD::mSQL () chmod 644 ar cr tmp.a dbdimp.o mSQL.o : tmp.a rm -f ../blib/arch/auto/DBD/mSQL/ LD_RUN_PATH="/usr/opt/rms/lib:/usr/shlib" ld -shared -expect_unresolved "*" -O4 -msym -std -s -L/usr/local/lib -all tmp.a -none -L/usr/opt/rms/lib -o ../blib/arch/auto/DBD/mSQL/ -L/usr/opt/rms/lib -lmsql -lm chmod 755 ../blib/arch/auto/DBD/mSQL/ cp ../blib/arch/auto/DBD/mSQL/ chmod 644 ../blib/arch/auto/DBD/mSQL/ Manifying ../blib/man3/Msql.3 Manifying ../blib/man3/DBD::mSQL.3 Manifying ../blib/man3/Bundle::DBD::mSQL.3 make[1]: Leaving directory `/usr/local/gnu/packages/perl-5.6.1-db/Msql-Mysql-modules-1.2219/mSQL' cp dbimon blib/script/dbimon ../perl -I../lib -I../lib -MExtUtils::MakeMaker -e "MY->fixin(shift)" blib/script/dbimon Manifying blib/man1/dbimon.1

This service runs on Request Tracker, is sponsored by The Perl Foundation, and maintained by Best Practical Solutions.

Please report any issues with to