RE: Problems installing DBI 1.14 on SunOS 5.6 (Solaris 2.6)
Looks like your make is broken. Get an update from your nearest mirror under /pub/gnu -Neil -Original Message- From: ARCS (Wade) [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 4:22 PM To: [EMAIL PROTECTED] Subject: Problems installing DBI 1.14 on SunOS 5.6 (Solaris 2.6) Hello, I am trying to get DBI 1.14 installed for client and have been unsuccessful. I'm really stuck between a rock and a hard place here, so any help would be greatly appreciated. Would be willing to pay someone to get DBI and DBD::mysql installed if anyone is interested. Here are the results of the attempted installation: --- - # 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 http://www.perl.com/CPAN/modules/by-module http://www.perl.org/CPAN/modules/by-module ftp://ftp.funet.fi/pub/languages/perl/CPAN/modules/by-module Warning: I could not locate your pod2man program. Please make sure, your pod2man program is in your PATH before you execute 'make' 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. # make make: Warning: Can't find `default.mk': No such file or directory /usr/bin/perl -I/usr/local/lib/perl5/sun4-solaris/5.00404 -I/usr/local/l ib/p erl5 /usr/local/lib/perl5/ExtUtils/xsubpp -typemap /usr/local/lib/perl5/ExtUtils/typemap DBI.xs xstmp.c mv xstmp.c DBI.c gcc -c -I/usr/local/include -O -DVERSION=\1.14\ -DXS_VERSION=\1 .14\ -fpic -I/usr/local/lib/perl5/sun4-solaris/5.00404/CORE -Wall -Wno-comm ent -DDBI_NO_THREADS DBI.c sh: gcc: not found *** Error code 1 make: Fatal error: Command failed for target `DBI.o' # make test make: Warning: Can't find `default.mk': No such file or directory /usr/bin/perl -I/usr/local/lib/perl5/sun4-solaris/5.00404 -I/usr/local/l ib/p erl5 /usr/local/lib/perl5/ExtUtils/xsubpp -typemap /usr/local/lib/perl5/ExtUtils/typemap DBI.xs xstmp.c mv xstmp.c DBI.c gcc -c -I/usr/local/include -O -DVERSION=\1.14\ -DXS_VERSION=\1 .14\ -fpic -I/usr/local/lib/perl5/sun4-solaris/5.00404/CORE -Wall -Wno-comm ent -DDBI_NO_THREADS DBI.c sh: gcc: not found *** Error code 1 make: Fatal error: Command failed for target `DBI.o' # make test TEST_VERBOSE=1 make: Warning: Can't find `default.mk': No such file or directory /usr/bin/perl -I/usr/local/lib/perl5/sun4-solaris/5.00404 -I/usr/local/l ib/p erl5 /usr/local/lib/perl5/ExtUtils/xsubpp -typemap /usr/local/lib/perl5/ExtUtils/typemap DBI.xs xstmp.c mv xstmp.c DBI.c gcc -c -I/usr/local/include -O -DVERSION=\1.14\ -DXS_VERSION=\1 .14\ -fpic -I/usr/local/lib/perl5/sun4-solaris/5.00404/CORE -Wall -Wno-comm ent -DDBI_NO_THREADS DBI.c sh: gcc: not found *** Error code 1 make: Fatal error: Command failed for target `DBI.o' # make install make: Warning: Can't find `default.mk': No such file or directory /usr/bin/perl -I/usr/local/lib/perl5/sun4-solaris/5.00404 -I/usr/local/l ib/p erl5 /usr/local/lib/perl5/ExtUtils/xsubpp -typemap /usr/local/lib/perl5/ExtUtils/typemap DBI.xs xstmp.c mv xstmp.c DBI.c gcc -c -I/usr/local/include -O -DVERSION=\1.14\ -DXS_VERSION=\1 .14\ -fpic -I/usr/local/lib/perl5/sun4-solaris/5.00404/CORE -Wall -Wno-comm ent -DDBI_NO_THREADS DBI.c sh: gcc: not found *** Error code 1 make: Fatal error: Command failed for target `DBI.o' # perl -V Summary of my perl5 (5.0 patchlevel 4 subversion 4) configuration: Platform: osname=solaris, osvers=2.6, archname=sun4-solaris uname='sunos 5.6 generic sun4u sparc sunw,ultra-1 ' hint=recommended, useposix=true, d_sigaction=define bincompat3=y useperlio=undef d_sfio=undef Compiler: cc='gcc', optimize='-O', gccversion=2.8.1 cppflags='-I/usr/local/include' ccflags ='-I/usr/local/include' stdchar='unsigned char', d_stdstdio=define, usevfork=false voidflags=15, castflags=0, d_casti32=define, d_castneg=define intsize=4, alignbytes=8, usemymalloc=y, prototype=define Linker and Libraries: ld='gcc', ldflags =' -L/usr/local/lib' libpth=/usr/local/lib /lib /usr/lib /usr/ccs/lib libs=-lsocket -lnsl -ldl -lm -lc -lcrypt libc=/lib/libc.so, so=so useshrplib=false, libperl=libperl.a Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' '
DBD:ODBC problem (causes Perl to crash w/ Access Violation?)
DBI v1.14
DBD-ODBC v0.28
Win 2000
Perl 5.6.0
Microsoft dBase VFP Driver (*.dbf) v 6.01.8629.01
The following program:
#--
# tkttest.pl
use DBI;
use strict;
my $DSN= 'tkt.dsn';
my $dbh = undef;
my @row;
#DBI-trace(3);
if ( $dbh = DBI-connect(dbi:ODBC:$DSN, '', '') ) {
print success!\n;
my $sth = $dbh-prepare( SELECT TCKT_VALID, SERIAL, MACHINE from
+tcktrdmp WHERE TCKT_VALID=89959);
$sth-execute();
while ( @row = $sth-fetchrow_array ) {
print $row[0] | $row[1] | $row[2]\n;
}
} else {
print failure |$DBI::errstr|\n;
}
# ---
Produces the output:
success!
89959 | 11097840 | 1237
Which is correct, but then ends with the following error:
The instruction at 0x280706b4 referenced memory at 0x0004. The
memory could not be written.
I have include a level 3 debug trace rather than the dbf which is 5 MB.
Level 3 trace output
DBI 1.14-nothread dispatch trace level set to 3
Note: perl is running without the recommended perl -w option
- DBI-connect(dbi:ODBC:tkt.dsn, , )
- DBI-install_driver(ODBC) for perl=5.006 pid=556 ruid=0 euid=0
install_driver: DBD::ODBC loaded (version 0.28)
New DBI::dr (for DBD::ODBC::dr, parent=, id=)
dbih_setup_handle(DBI::dr=HASH(0x1a7a18c)=DBI::dr=HASH(0x1caa7fc),
DBD::ODBC::dr, 0, Null!)
dbih_make_com(Null!, DBD::ODBC::dr, 92)
- install_driver= DBI::dr=HASH(0x1a7a18c)
- connect for DBD::ODBC::dr (DBI::dr=HASH(0x1a7a18c)~0x1caa7fc 'tkt.dsn' ''
HASH(0x1a7f138))
New DBI::db (for DBD::ODBC::db, parent=DBI::dr=HASH(0x1caa7fc), id=)
dbih_setup_handle(DBI::db=HASH(0x1caa79c)=DBI::db=HASH(0x1caa7c0),
DBD::ODBC::db, 1cf0058, Null!)
dbih_make_com(DBI::dr=HASH(0x1caa7fc), DBD::ODBC::db, 92)
Driver connect 'tkt.dsn', '', ''
SQLConnect 'tkt.dsn', '', ''
- connect= DBI::db=HASH(0x1caa79c) at DBI.pm line 408.
- STORE for DBD::ODBC::db (DBI::db=HASH(0x1caa7c0)~INNER 'PrintError' 1)
STORE DBI::db=HASH(0x1caa7c0) 'PrintError' = 1
- STORE= 1 at DBI.pm line 433.
- STORE for DBD::ODBC::db (DBI::db=HASH(0x1caa7c0)~INNER 'AutoCommit' 1)
- STORE= 1 at DBI.pm line 433.
- connect= DBI::db=HASH(0x1caa79c)
- prepare for DBD::ODBC::db (DBI::db=HASH(0x1caa79c)~0x1caa7c0 ' SELECT
TCKT_VALID, SERIAL, MACHINE from tcktrdmp WHERE TCKT_VALID=89959')
New DBI::st (for DBD::ODBC::st, parent=DBI::db=HASH(0x1caa7c0), id=)
dbih_setup_handle(DBI::st=HASH(0x1cabf7c)=DBI::st=HASH(0x1cabf34),
DBD::ODBC::st, 1caa790, Null!)
dbih_make_com(DBI::db=HASH(0x1caa7c0), DBD::ODBC::st, 164)
dbd_st_prepare'd sql f30546080
SELECT TCKT_VALID, SERIAL, MACHINE from tcktrdmp WHERE TCKT_VALID=89959
- prepare= DBI::st=HASH(0x1cabf7c) at tkttest.pl line 20.
- execute for DBD::ODBC::st (DBI::st=HASH(0x1cabf7c)~0x1cabf34)
dbd_st_execute (for sql f30546080 after)...
dbd_describe sql 30546080: num_fields=3
col 1: NUMERIC len= 15 disp= 16, prec= 15 scale=0
col 2: NUMERIC len= 15 disp= 16, prec= 15 scale=0
col 3: NUMERIC len= 10 disp= 11, prec= 10 scale=0
col 1: 'tckt_valid' sqltype=NUMERIC, ctype=SQL_C_CHAR, maxlen=16
col 2: 'serial' sqltype=NUMERIC, ctype=SQL_C_CHAR, maxlen=16
col 3: 'machine' sqltype=NUMERIC, ctype=SQL_C_CHAR, maxlen=11
- execute= -1 at tkttest.pl line 23.
- fetchrow_array for DBD::ODBC::st (DBI::st=HASH(0x1cabf7c)~0x1cabf34)
SQLFetch rc 0
dbih_setup_fbav for 3 fields = 0x1cabef8
fetch num_fields=3
- fetchrow_array= ( '89959' '11097840' '1237' ) 3 items at tkttest.pl line
24.
- fetchrow_array for DBD::ODBC::st (DBI::st=HASH(0x1cabf7c)~0x1cabf34)
SQLFetch rc 100
SQLGetFunctions - supported: 1
- fetchrow_array= ( ) 0 items at tkttest.pl line 24. Attempt to free
unreferenced scalar.
DESTROY ignored for outer handle DBI::st=HASH(0x1cabf7c) (inner
DBI::st=HASH(0x1cabf34))
- DESTROY for DBD::ODBC::st (DBI::st=HASH(0x1cabf34)~INNER)
If you click Cancel on the windows error and go to Visual C++ you get the
error:
Unhandled exception in Perl.exe (Perl56.DLL): 0xC005: Access Violation
Can you help?
Thanks!
Gary
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
Re[2]: DBI modules
Hello all, I wanted to thank everyone for the assistance with this. After re-installing a fresh copy of perl5.6.1 everything is now back to normal and working properly!! :) On another note, has any one successfully install DBD::AnyData and used it?? It seems to install properly, but when used in a script, I keep getting an error, about DBD/AnyData.pm line 21 can't find (AnyData driver) ?? What's this all about?? On Fri, 13 Jul 2001 00:19:04 -0400, Sterin, Ilya [EMAIL PROTECTED] wrote: I was hoping to avoid that, but it looks like that's the only alternative! :) I tried using CPAN to install Perl, but it keeps failing, can't do 'make' successfully for some reason! And some other modules are missing that CPAN looks for, MD5, LWP.. Which where all there with Perl 5.005! but CPAN can't find those. Damn!! :) Well a good learning experience here.!!! Stay with the defaults settings when your not sure!! :) You can install again, but this time with the correct directory. That way you will have two 5.6 installs. Ilya -Original Message- From: ThunderRain Publishing Corp. [mailto:ThunderRain Publishing Corp.]On Behalf Of MikemickaloBlezien Sent: Friday, July 13, 2001 12:08 AM To: Sterin, Ilya Cc: [EMAIL PROTECTED] Subject: Re: DBI modules Perl is working fine, except when Perl 5.006 got installed, instead of using the default pervious setup of /usr/local/lib/perl5/ for the existing 5.005, it's now /usr/bin/lib/perl5/... Perl 5.005 is still there with all the modules. All I need to do is reset the paths back to what they where so we don't have re-install all the existing modules in the Perl 5.005 which are not there now for the Perl 5.006 as the @INC all point to /usr/bin... instead of /usr/local/... and I haven't figured out how to change back without going thru a whole bunch of headaches! :) I thought using 'setenv PERLIB.' to reset the paths back would do it, but it didn't! On Fri, 13 Jul 2001 00:06:24 -0400, Sterin, Ilya [EMAIL PROTECTED] wrote: Use the full path:-) Why did you screw it up, just use the perl installation in the /usr/bin, I don't see a problem, unless you are not telling us something. Ilya -Original Message- From: ThunderRain Publishing Corp. [mailto:ThunderRain Publishing Corp.]On Behalf Of MikemickaloBlezien Sent: Thursday, July 12, 2001 7:46 PM To: [EMAIL PROTECTED] Subject: DBI modules Hi All, Hope some one might be able to help out here. I was in the process upgrading a few of our DBI and related modules thru CPAN, and screwed up! When attempting to install the DBD::mysql module, I was prompted to upgraded Perl from the 5.005 to 5.006 I believe, to support it. During the install of Perl, it prompted for location /usr/local by default setting and I think I screwed it by using /usr/bin instead and now, needless to say, things are a bit screwed up. What would be the best way to tell the server to use the original Perl that was installed before I screwed by installing the newer version of Perl!! Any help would be much appreciated! Good thing this is a development server :) Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Fwd: ORA-01008 on Oracle7 with DBD::Oracle v1.07
The user [of DDL::Oracle] who originally reported this error had said: I'm running the latest from the latest software: - RedHat 7.1 - DBI-1.18 - DBD-Oracle-1.07 - DDL-Oracle-1.10 - Oracle Client 8.0.5.0.0 He now reports that after upgrading his Oracle evironment to 8.0.6.1, that the problem has disappeared. Case closed. Thanks to those of you who spent time looking at this. I really appreciate it. Richard --- Richard Sutherland [EMAIL PROTECTED] wrote: Date: Thu, 12 Jul 2001 03:28:22 -0700 (PDT) From: Richard Sutherland [EMAIL PROTECTED] Subject: ORA-01008 on Oracle7 with DBD::Oracle v1.07 To: [EMAIL PROTECTED] All, I am getting an ORA-01008 when using bind variables on Oracle7 instances, but not on Oracle8 instances. This has happened on both Unix and Linux OS's. Here is the error: DBD::Oracle::db prepare failed: ORA-01008: not all variables bound (DBD ERROR: OCIStmtExecute/Describe) at ddl_test.pl line 40, STDIN chunk 3. This was not happening with prior versions of DBD::Oracle (back with 1.06, I think). Attached is a small test script. Would those of you with a little time please see if you can confirm/deny that you also do/don't get the same error? Also attached is a trace from a failed execution on a Unix host. Thanks! Richard = Richard Sutherland [EMAIL PROTECTED] The four stages of man are infancy, childhood, adolescence and obsolescence. - Art Linkletter, author __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/
Re: .htpasswd and DBD::CSV
Bodo Eing wrote:
regarding the items you mentioned above, true. But *DBD::CSV does not work
with files containing periods the file name*,
Not quite right, see below.
because the file names are used
as the table names by the SQL Layer on top of Text::CSV_XS.
Right, because a period in a table name has a specific meaning in SQL,
different than the one it does in a file system.
That's why DBD::AnyData uses a catalog statement to associate a file
name with a table name:
$dbh-func( 'htp', 'CSV', '.htpasswd','ad_catalog')
That says to use the alias htp to refer to the CSV formatted table
held in the file .htpasswd. The period is legal in the file name but
not in the table name.
The same kind of thing is also available in DBD::CSV with the csv_tables
hash:
$dbh-{csv_tables}-{htp}-{file} = '.htpasswd';
That accomplishes the same thing for DBD::CSV that the example above
accomplishes for DBD::AnyData.
--
Jeff
AnyData Installation, Was: Re: DBI modules
MikeBlezien wrote: On another note, Please use a different subject line when you are starting a new subject, I only found this by accident. has any one successfully install DBD::AnyData and used it?? It seems to install properly, but when used in a script, I keep getting an error, about DBD/AnyData.pm line 21 can't find (AnyData driver) ?? What's this all about?? You need to install AnyData.pm first and then install DBD::AnyData.pm. They are in two different tarballs AnyData-0.04.tar.gz and DBD-AnyData-0.04.tar.gz. At some point I'll make a bundle so the two downloads aren't necessary. This is all covered in the readme and installation notes for the modules. If you've installed AnyData.pm and still get errors, let me know. -- Jeff
Re: AnyData Installation, Was: Re: DBI modules
Yes, I did figure that out after digging a little deeper, but still no luck installing the AnyData module. I've tried installing the XML-DOM and Bundle::XML with no luck either. this is on a freeBSD 4.1 XML ... Error Opening File-Parser: Can't locate XML/Twig.pm in @INC (@INC contains: blib/arch blib/lib /usr/local/lib/perl5/5.6.1/i386-freebsd /usr/local/lib/perl5/5.6.1/i386-freebsd /usr/local/lib/perl5/5.6.1 /usr/ local/lib/perl5/5.6.1/i386-freebsd /usr/local/lib/perl5/5.6.1 /usr/local/lib/perl5/site_perl/5.6.1/i386-freebsd /usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl/5.005/i386-freebsd /usr/local/lib/perl5/site _perl/5.005 /usr/local/lib/perl5/site_perl .) at blib/lib/AnyData/Format/XML.pm line 12. BEGIN failed--compilation aborted at blib/lib/AnyData/Format/XML.pm line 12. Compilation failed in require at blib/lib/AnyData.pm line 26. *** Error code 2 Stop in /root/.cpan/build/AnyData-0.04. /usr/bin/make test -- NOT OK Running make install make test had returned bad status, won't install without force On Fri, 13 Jul 2001 12:45:26 -0700, Jeff Zucker [EMAIL PROTECTED] wrote: You need to install AnyData.pm first and then install DBD::AnyData.pm. They are in two different tarballs AnyData-0.04.tar.gz and DBD-AnyData-0.04.tar.gz. At some point I'll make a bundle so the two downloads aren't necessary. This is all covered in the readme and installation notes for the modules. If you've installed AnyData.pm and still get errors, let me know. Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Re: AnyData Installation, Was: Re: DBI modules
MikeBlezien wrote: Yes, I did figure that out after digging a little deeper, but still no luck installing the AnyData module. I've tried installing the XML-DOM and Bundle::XML with no luck either. this is on a freeBSD 4.1 XML ... Error Opening File-Parser: Can't locate XML/Twig.pm in @INC AFAIK, XML::Twig is not part of those bundles, you'll need to install it separately from CPAN. (But only if you want to do XML. If you're using AnyData or DBD-AnyData for other formats, you don't need to install it at all.) Stop in /root/.cpan/build/AnyData-0.04. /usr/bin/make test -- NOT OK Running make install make test had returned bad status, won't install without force In the next release I will make the test give warnings about missing modules rather than dieing. In the meantime, you should be able to install it with a manual make install and just ignore the test failure. -- Jeff
fetchall_hashref() - does/will it exist?
I just downloaded DBI 1.18, and although the fetchall_hashref method is mentioned in the documentation, it doesn't appear to exist in the code. Is this is an oversight? In any case, will this method be included in the next version of DBI, and if so, is that expected to be soon? Thanks, Alex Algard
Re: Placeholder Info
A useful place to start is the DBI documentation. Run 'perldoc DBI' to see it. It isn't a tutorial, but it does explain what placeholders are had gives a couple examples. There are more examples in DBD-Oracle-1.0x.tar.gz subdirectory Oracle.ex/ which aren't completely Oracle specific. -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age. - Original Message - From: Joel Divekar [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 12, 2001 23:05 Subject: Placeholder Info I wanted to know the significance of placeholders in SQL statements, can anybody guide me or provide me with links from where I will get easy to understand tutorial on the same.
Re: Silly question re: bind_param vs: bind_columns
See $sth-execute() in the DBI manual. This belongs in dbi-users, not dbi-dev. -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 13, 2001 10:34 Subject: Silly question re: bind_param vs: bind_columns I'm looking at DBI 1.14 and wondering why isn't there a bind_params method like: $rc = $sth-bind_params(@refs_to_params); #dies if wrong number of params or $rc = $sth-bind_params(%hash_of_params_with_field_names_or_numbers); #dies if hash key mismatch It seems like an obvious idea, so I assume there's a good reason it hasn't been implemented. John A
DBD::Oracle and LOB datatypes
The documentation for the Oracle DBD shows how to INSERT and UPDATE an LOB but there doesn't appear to be anything that indicates how to do a SELECT and especially a LIKE equivalent. Does anyone have some examples? Craig Steffler ATS Project e.Gulfstream Web Development [EMAIL PROTECTED]
fetchall_hashref() - does/will it exist?
I just downloaded DBI 1.18, and although the fetchall_hashref method is mentioned in the documentation, it doesn't appear to exist in the code. Is this is an oversight? In any case, will this method be included in the next version of DBI, and if so, is that expected to be soon? Thanks, Alex Algard
