Re: Make problems with DBD::Sybase 1.0 on HP
Figured it out. We have a statically linked Perl due to some problems I encountered some time ago with the HP linker. I changed the CONFIG option to static and it built and test fine. Thanks On Sun, 2003-07-27 at 06:43, Matthew O. Persico wrote: On 25 Jul 2003 13:46:47 -0700, Mark Mertel wrote: [snip] [EMAIL PROTECTED]make test PERL_DL_NONLAZY=1 /apps/cup/perl5/bin/perl -Iblib/arch -Iblib/lib -I/apps/cup/perl5/lib/5.6.1/PA-RISC2.0 -I/apps/cup/perl5/lib/5.6.1 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/autocommitinstall_driver(Sybase) failed: DBD::Sybase object version 0.95 does not match bootstrap parameter 1.00 at blib/lib/DBD/Sybase.pm line 32. Compilation failed in require at (eval 1) line 3. That's bizzare. I've never seen the old version conflict with the new one. Short term, if this is not a production box, try uninstalling 0.95 and see what happends. at t/autocommit.t line 40 t/autocommitdubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 2-4 Failed 3/4 tests, 25.00% okay t/base..install_driver(Sybase) failed: DBD::Sybase object version 0.95 does not match bootstrap parameter 1.00 at blib/lib/DBD/Sybase.pm line 32. -- Matthew O. Persico -- Mark Mertel [EMAIL PROTECTED] Mertel Software, Inc.
Re: Make dbi socket.h errors....
On Mon, 28 Jul 2003 10:37:08 +0200, [EMAIL PROTECTED] wrote: anybody can help me whats the problem of dbi installation on my hpux workstation with HPUX 11.11??? Could it be that perl is compiled with ansi/c and the dbi uses gcc? If you're using a perl that was preinstalled on your system, it can indeed be that you're trying to use a different compiler to install XS modules, yes. Try to find out what compiler they used, and use the same yourself, or recompile all of perl. Which is, like, ugh. -- Bart.
RE: Question regarding Apache::DBI
Can you put commit/rollback's into the END block ? -Original Message- From: Steve Baldwin [mailto:[EMAIL PROTECTED] Sent: Sunday, July 27, 2003 8:02 PM To: [EMAIL PROTECTED] Subject: Question regarding Apache::DBI We're using Apache::DBI and running into problems with Apache child processes not releasing locks. My current theory for how this happens goes something like this ... (Our DB is Oracle if that's relevant) script issues an update which is successful, and locks the updated row does other stuff cleanup code (issues commit or rollback depending on logical success or failure (which releases the lock)) Now if in the does other stuff section, we get a 500 error, it doesn't get to the cleanup code, which is where the commit/rollback occurs. We therefore have an Apache child process that is going to effectively hold on to this row lock forever (or until it terminates). The user attempts to re-display the same page, and it hangs because it is attempting to update the row the other child process has locked. We don't see any contention when we're running plain DBI rather than Apache::DBI. Does this sound like a plausible explanation for the contention problems we're seeing, and if so, has anybody got any suggestions for ways of solving them. Thanks, Steve
Re: DBI, DBD::Informix and Statement SIze
Jonathan Leffler wrote: Rasoul Hajikhani wrote: Here is a brief description of my DBD::Informix Type: dr Name: Informix Version: 2003.04 Attribution: Jonathan Leffler [EMAIL PROTECTED] Product: INFORMIX-ESQL Version 9.51.UC1 Product Version: 951 I am trying to insert a 16MB data into a idn_mrLvarchar data type which has 2GIG capacity. This I can achieve using LOAD statement within 'dbaccess'. However, going through DBI, I can only achieve 256Bytes of data insertion. DBI::bind_param, and DBI::bind_param_inout are not implemented. I have used place holders with no effect either. Short of asking 'What Next', I am wondering if DBI does not care about the size of a SQL statement, which some of this group's members suggested some other day in their email to me, then what is preventing this insertion? I have a read some old email on this list and in one of them it was suggested that the sql size limit is 64K (True/False?). Is there any way of changing size limit in DBI, if such functionality exists at all? I appreciate any feed back.. Thanks in advance The bind_param method is implemented, True, my mistake... :( though bind_param_inout is not. Informix poses a limit of 64 KB on the size of a statement - the DBMS and access code such as ESQL/C does this. DBD::Informix cannot change it. However, you can provide parameters which are much larger. Since I don't recognize idn_mrLvarchar as a data type - though I suspect it is a DataBlade (probably the multi-representational long varchar data type from the Informix Developer Network), and someone had a question about this on comp.databases.informix a week or so ago (a bit before I took some vacation) - I suspect that most of the people on the dbi-users mailing list won't recognize it either. From http://www7b.boulder.ibm.com/dmdd/zones/informix/library/techarticle/db_mrLvarchar.html: The idn_mrLvarchar user-defined type (UDT) stores character data up to 2 gigabytes. It is like the built-in lvarchar SQL type, but without the 2K column limit. idn_mrLvarchar is implemented as a multirep, which means that text shorter than 2K is stored in-row and text longer than 2K is stored in a smart blob. (Ok, 8 bytes of housekeeping information gets maintained in the UDT value. Specifically, a value = 2040 bytes is stored in-row. Anything larger gets stored in a smart blob.) Since you don't show us any code - let alone provide a simple reproduction of your problem - I can't yet provide very much more help. use DBI; #Read the contents of a file w/ 12mb of data... my $theFile = $ARGV[0]; undef $/; my $fh = new IO::File $theFile,r or die IO::FILE NEW FAILED $theFile: $!\n; my $data= $fh; close $fh or die CLOSE FAILED: $!\n; my $sql = INSERT INTO secure_users (code,username,gpgusername,gpgpassphrase_mrlvc) VALUES (?,?,?,?); my $sth = $dbh-prepare($sql) || die ERROR: $DBI::errstr\n; my $rc = $sth-bind_param(1,1456); $rc = $sth-bind_param(2,'yadayada'); $rc = $sth-bind_param(3,'yayayay'); $rc = $sth-bind_param(4,$data); $sth-execute(); $sth-finish(); Using the above method and code, only 256b are inserted into the table. The large data gets truncated at insertion time. Thanks in advance for your feed back -r
DBD::mysql Error
I have a Red Hat 8.0 box with: MySQL 3.23.52-3 perl 5.8.0-55 DBD MySQL 2.1017-3 When I run my perl script I always get: Can't find 'boot_DBD__mysql' symbol in /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBD/mysql/mysql. so at ./Backup.pl line 8 Compilation failed in require at ./Backup.pl line 8. BEGIN failed--compilation aborted at ./Backup.pl line 8. Backup.pl: #!/usr/bin/perl -w # # # # This Script performs a backup of the specified host # # use DBI; use DBD::mysql; I know the script works fine because I can run it on my FreeBSD machine and it works fine. Any help would be great Thanks, Jamin Roth Systems/Network Administrator Sorensen Associates Inc Phone: (503) 665-0123 ext 289 Fax: (503) 666-5113 http://www.sorensen-associates.com/
RE: :mysql Error
Then I get: Name main::row used only once: possible typo at ./Backup.pl line 93. install_driver(mysql) failed: Can't find 'boot_DBD__mysql' symbol in /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBD/mysql/mysql. so at (eval 1) line 3 Compilation failed in require at (eval 1) line 3. I think the problem is that perl is installed with linux threads and I don't have a multi processor machine so I don't need it. But when I reinstall the rpm it continues to use threads. Any Ideas on how to reinstall without threads? Thanks, Jamin Roth Systems/Network Administrator Sorensen Associates Inc Phone: (503) 665-0123 ext 289 Fax: (503) 666-5113 http://www.sorensen-associates.com/ -Original Message- From: PARLEY,THUNDER (HP-MountainView,ex1) [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 11:53 AM To: 'Jamin Roth' Subject: RE: :mysql Error Hi Jamin, Remove the line use DBD:mysql; It is unnecessary, DBI will load the correct DBD depending on the connection string, etc. --Thunder -Original Message- From: Jamin Roth [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 11:12 AM To: DBI users Subject: DBD::mysql Error I have a Red Hat 8.0 box with: MySQL 3.23.52-3 perl 5.8.0-55 DBD MySQL 2.1017-3 When I run my perl script I always get: Can't find 'boot_DBD__mysql' symbol in /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBD/mysql/mysql. so at ./Backup.pl line 8 Compilation failed in require at ./Backup.pl line 8. BEGIN failed--compilation aborted at ./Backup.pl line 8. Backup.pl: #!/usr/bin/perl -w # # # # This Script performs a backup of the specified host # # use DBI; use DBD::mysql; I know the script works fine because I can run it on my FreeBSD machine and it works fine. Any help would be great Thanks, Jamin Roth Systems/Network Administrator Sorensen Associates Inc Phone: (503) 665-0123 ext 289 Fax: (503) 666-5113 http://www.sorensen-associates.com/
TEST - Please IGNORE
TEST - Please IGNORE -- Samir Unadkat Sr Web Integration Consultant McFadyen Consulting Phone: 703.226.3800 --
Cannot compile DBI:Oracle
I am trying to compile DBD Oracle 1.14. When I run nmake, I get the
following error:
LINK : fatal error LNK1104: cannot open file 'Oracle.def'
[details of running nmake below]
I have installed DBI 1.2. I am using Oracle 9i. Platform: Win32, Microsoft
.Net. [details of perl version below]
Any help/suggestions/RTFMs/anything at all appreciated !
Thanks,
Samir
---
perl Makefile.PL
---
Using DBI 1.20 installed in f:\iw-home\iw-perl\site\lib/MSWin32-x86/auto/DBI
Configuring DBD::Oracle ...
Remember to actually *READ* the README file!
Especially if you have any problems.
Using Oracle in E:/oracle/ora90
Found header files in rdbms/demo.
*
I can't find the header files I need in your Oracle installation.
You probably need to install some more Oracle components.
I'll keep going, but the compile will probably fail.
See README.clients for more information.
*
Found oci directory
Using OCI directory 'oci'
Found oci/lib/MSVC/oci.lib library
Found oci/lib/MSVC/ociw32.lib library
Found oci/lib/MSVC/oraocci9.lib library
Using oci/lib/MSVC/OCI.lib
System: perl5.00503
Compiler:
cl.exe -Od -MD -DNDEBUG -Od -MD -DNDEBUG -DWIN32 -D_CONSOLE -DNO_STR
ICT
Linker: ld not found
Sysliblist:
Reference found where even-sized list expected at
f:\iw-home\iw-perl\site\lib/DB
I/DBD.pm line 1781.
Checking if your kit is complete...
Looks good
'HASH(0x349b14)' is not a known MakeMaker parameter name.
Warning: Guessing NAME [DBD-Oracle] from current directory name.
LD_RUN_PATH=E:/oracle/ora90/lib:E:/oracle/ora90/rdbms/lib
Using DBD::Oracle 0.10.
Using DBI 1.20 installed in f:\iw-home\iw-perl\site\lib/MSWin32-x86/auto/DBI
Writing Makefile for DBD-Oracle
*** If you have problems...
read all the log printed above, and the README and README.help files.
(Of course, you have read README by now anyway, haven't you?)
---
nmake
---
Microsoft (R) Program Maintenance Utility Version 7.00.9466
Copyright (C) Microsoft Corporation. All rights reserved.
mkdir blib
mkdir blib\lib
mkdir blib\arch
mkdir blib\arch\auto
mkdir blib\arch\auto\DBD-Oracle
mkdir blib\lib\auto
mkdir blib\lib\auto\DBD-Oracle
mkdir blib\man3
cp Oraperl.pm blib\lib/Oraperl.pm
cp ocitrace.h blib\arch\auto\DBD-Oracle/ocitrace.h
cp Oracle.pm blib\lib\Oracle.pm
cp mk.pm blib\arch\auto\DBD-Oracle/mk.pm
cp dbdimp.h blib\arch\auto\DBD-Oracle/dbdimp.h
cp oraperl.ph blib\lib/oraperl.ph
cp lib/DBD/Oracle/GetInfo.pm blib\lib\DBD\Oracle\GetInfo.pm
cp Oracle.h blib\arch\auto\DBD-Oracle/Oracle.h
f:\iw-home\iw-perl\bin\iwperl.exe -If:\iw-home\iw-perl\lib\MSWin32-x86 -
If:\iw-home\iw-perl\lib F:\iw-home\iw-perl\lib\ExtUtils/xsubpp -typemap
F:\iw-h
ome\iw-perl\lib\ExtUtils\typemap Oracle.xs xstmp.c
f:\iw-home\iw-perl\bin\iw
perl.exe -If:\iw-home\iw-perl\lib\MSWin32-x86 -If:\iw-home\iw-perl\lib -MExt
Util
s::Command -e mv xstmp.c Oracle.c
cl.exe -c -Od -MD -DNDEBUG -DWIN32 -D_CONSOLE -DNO_STRICT -Od -MD -DNDE
BUG -DVERSION=\0.10\ -DXS_VERSION=\0.10\ -IF:\iw-home\iw-perl\lib\
MSWi
n32-x86\CORE Oracle.c
Microsoft (R) 32-bit C/C++ Optimizing Compiler Version 13.00.9466 for 80x86
Copyright (C) Microsoft Corporation 1984-2001. All rights reserved.
Oracle.c
Running Mkbootstrap for DBD-Oracle ()
f:\iw-home\iw-perl\bin\iwperl.exe -If:\iw-home\iw-perl\lib\MSWin32-x86 -
If:\iw-home\iw-perl\lib -MExtUtils::Command -e chmod 644 Oracle.bs
f:\iw-home\iw-perl\bin\iwperl.exe
-If:\iw-home\iw-perl\lib\MSWin32-x86
-If:\iw-home\iw-perl\lib -MExtUtils::Mksymlists -e Mksymlists('NAME' =
'DB
D-Oracle', 'DLBASE' = 'Oracle', 'DL_FUNCS' = { }, 'FUNCLIST' = [],
'IMPORTS'
= { }, 'DL_VARS' = []);
link -out:blib\arch\auto\DBD-Oracle\Oracle.dll -dll -nologo -nodefaultli
b -release -machine:x86 Oracle.obj
F:\iw-home\iw-perl\lib\MSWin32-x86\CORE\per
l.lib oldnames.lib kernel32.lib user32.lib gdi32.lib winspool.lib
comdlg32.lib
advapi32.lib shell32.lib ole32.lib oleaut32.lib netapi32.lib uuid.lib
wsock32.l
ib mpr.lib winmm.lib version.lib odbc32.lib odbccp32.lib
PerlCRT.lib -def:Oracl
e.def
LINK : fatal error LNK1104: cannot open file 'Oracle.def'
LINK : fatal error LNK1141: failure during build of exports file
NMAKE : fatal error U1077: 'link' : return code '0x475'
Stop.
---
perl -V
---
Summary of my perl5 (5.0 patchlevel 5 subversion 03) configuration:
Platform:
osname=MSWin32, osvers=4.0, archname=MSWin32-x86
uname=''
hint=recommended, useposix=true, d_sigaction=undef
usethreads=undef useperlio=undef d_sfio=undef
Compiler:
cc='cl.exe', optimize='-Od -MD -DNDEBUG', gccversion=
cppflags='-DWIN32'
ccflags ='-Od -MD -DNDEBUG
DBI ProxyServer (a DUH moment)
my problem of last week was associated with variable scoping ... got a little too quick and the scalars i was trying to insert were not visible to the subroutine in which the insert command is executed. the command was therefore being executed with scalars that were not yet defined. john cuson ([EMAIL PROTECTED], [EMAIL PROTECTED]) The world is full of obvious things which nobody by any chance ever observes. Sir Arthur Conan Doyle
RE: :mysql Error
I was using the wrong libs. I removed the /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi and all is well! Thanks, Jamin Roth Systems/Network Administrator Sorensen Associates Inc Phone: (503) 665-0123 ext 289 Fax: (503) 666-5113 http://www.sorensen-associates.com/ -Original Message- From: JT MacNeil [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 12:36 PM To: 'Jamin Roth' Subject: RE: :mysql Error Hello, The number of processors has nothing to do with linux threads, they'll work on multi- and uni-proc machines. Are the MySQL client libs are on the the Linux box? J-T MacNeil Design Team Member, Connect 24 Division Digital Security Controls Phone: (905) 760-3000 x7318 e-Mail: [EMAIL PROTECTED] -Original Message- From: Jamin Roth [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 3:29 PM To: PARLEY,THUNDER (HP-MountainView,ex1) Cc: DBI users Subject: RE: :mysql Error Then I get: Name main::row used only once: possible typo at ./Backup.pl line 93. install_driver(mysql) failed: Can't find 'boot_DBD__mysql' symbol in /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DB D/mysql/mysql. so at (eval 1) line 3 Compilation failed in require at (eval 1) line 3. I think the problem is that perl is installed with linux threads and I don't have a multi processor machine so I don't need it. But when I reinstall the rpm it continues to use threads. Any Ideas on how to reinstall without threads? Thanks, Jamin Roth Systems/Network Administrator Sorensen Associates Inc Phone: (503) 665-0123 ext 289 Fax: (503) 666-5113 http://www.sorensen-associates.com/ -Original Message- From: PARLEY,THUNDER (HP-MountainView,ex1) [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 11:53 AM To: 'Jamin Roth' Subject: RE: :mysql Error Hi Jamin, Remove the line use DBD:mysql; It is unnecessary, DBI will load the correct DBD depending on the connection string, etc. --Thunder -Original Message- From: Jamin Roth [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 11:12 AM To: DBI users Subject: DBD::mysql Error I have a Red Hat 8.0 box with: MySQL 3.23.52-3 perl 5.8.0-55 DBD MySQL 2.1017-3 When I run my perl script I always get: Can't find 'boot_DBD__mysql' symbol in /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DB D/mysql/mysql. so at ./Backup.pl line 8 Compilation failed in require at ./Backup.pl line 8. BEGIN failed--compilation aborted at ./Backup.pl line 8. Backup.pl: #!/usr/bin/perl -w # # # # This Script performs a backup of the specified host # # use DBI; use DBD::mysql; I know the script works fine because I can run it on my FreeBSD machine and it works fine. Any help would be great Thanks, Jamin Roth Systems/Network Administrator Sorensen Associates Inc Phone: (503) 665-0123 ext 289 Fax: (503) 666-5113 http://www.sorensen-associates.com/
RE: Cannot compile DBI:Oracle
Just wanted to follow up with more information:
I cannot find the file Oracle.def anywhere.
I have also tried to install older versions of DBD Oracle. Some older
versions do have the file Oracle.def. However I get other errors on running
nmake.
Any help appreciated.
Thanks,
Samir
-Original Message-
From: Samir Unadkat [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 4:00 PM
To: [EMAIL PROTECTED]
Subject: Cannot compile DBI:Oracle
I am trying to compile DBD Oracle 1.14. When I run nmake, I get the
following error:
LINK : fatal error LNK1104: cannot open file 'Oracle.def'
[details of running nmake below]
I have installed DBI 1.2. I am using Oracle 9i. Platform: Win32, Microsoft
.Net. [details of perl version below]
Any help/suggestions/RTFMs/anything at all appreciated !
Thanks,
Samir
---
perl Makefile.PL
---
Using DBI 1.20 installed in
f:\iw-home\iw-perl\site\lib/MSWin32-x86/auto/DBI
Configuring DBD::Oracle ...
Remember to actually *READ* the README file!
Especially if you have any problems.
Using Oracle in E:/oracle/ora90
Found header files in rdbms/demo.
*
I can't find the header files I need in your Oracle installation.
You probably need to install some more Oracle components.
I'll keep going, but the compile will probably fail.
See README.clients for more information.
*
Found oci directory
Using OCI directory 'oci'
Found oci/lib/MSVC/oci.lib library
Found oci/lib/MSVC/ociw32.lib library
Found oci/lib/MSVC/oraocci9.lib library
Using oci/lib/MSVC/OCI.lib
System: perl5.00503
Compiler:
cl.exe -Od -MD -DNDEBUG -Od -MD -DNDEBUG -DWIN32 -D_CONSOLE -DNO_STR
ICT
Linker: ld not found
Sysliblist:
Reference found where even-sized list expected at
f:\iw-home\iw-perl\site\lib/DB
I/DBD.pm line 1781.
Checking if your kit is complete...
Looks good
'HASH(0x349b14)' is not a known MakeMaker parameter name.
Warning: Guessing NAME [DBD-Oracle] from current directory name.
LD_RUN_PATH=E:/oracle/ora90/lib:E:/oracle/ora90/rdbms/lib
Using DBD::Oracle 0.10.
Using DBI 1.20 installed in
f:\iw-home\iw-perl\site\lib/MSWin32-x86/auto/DBI
Writing Makefile for DBD-Oracle
*** If you have problems...
read all the log printed above, and the README and README.help files.
(Of course, you have read README by now anyway, haven't you?)
---
nmake
---
Microsoft (R) Program Maintenance Utility Version 7.00.9466
Copyright (C) Microsoft Corporation. All rights reserved.
mkdir blib
mkdir blib\lib
mkdir blib\arch
mkdir blib\arch\auto
mkdir blib\arch\auto\DBD-Oracle
mkdir blib\lib\auto
mkdir blib\lib\auto\DBD-Oracle
mkdir blib\man3
cp Oraperl.pm blib\lib/Oraperl.pm
cp ocitrace.h blib\arch\auto\DBD-Oracle/ocitrace.h
cp Oracle.pm blib\lib\Oracle.pm
cp mk.pm blib\arch\auto\DBD-Oracle/mk.pm
cp dbdimp.h blib\arch\auto\DBD-Oracle/dbdimp.h
cp oraperl.ph blib\lib/oraperl.ph
cp lib/DBD/Oracle/GetInfo.pm blib\lib\DBD\Oracle\GetInfo.pm
cp Oracle.h blib\arch\auto\DBD-Oracle/Oracle.h
f:\iw-home\iw-perl\bin\iwperl.exe
-If:\iw-home\iw-perl\lib\MSWin32-x86 -
If:\iw-home\iw-perl\lib F:\iw-home\iw-perl\lib\ExtUtils/xsubpp -typemap
F:\iw-h
ome\iw-perl\lib\ExtUtils\typemap Oracle.xs xstmp.c
f:\iw-home\iw-perl\bin\iw
perl.exe -If:\iw-home\iw-perl\lib\MSWin32-x86
-If:\iw-home\iw-perl\lib -MExt
Util
s::Command -e mv xstmp.c Oracle.c
cl.exe -c -Od -MD -DNDEBUG -DWIN32 -D_CONSOLE -DNO_STRICT -Od
-MD -DNDE
BUG -DVERSION=\0.10\ -DXS_VERSION=\0.10\
-IF:\iw-home\iw-perl\lib\
MSWi
n32-x86\CORE Oracle.c
Microsoft (R) 32-bit C/C++ Optimizing Compiler Version 13.00.9466 for 80x86
Copyright (C) Microsoft Corporation 1984-2001. All rights reserved.
Oracle.c
Running Mkbootstrap for DBD-Oracle ()
f:\iw-home\iw-perl\bin\iwperl.exe
-If:\iw-home\iw-perl\lib\MSWin32-x86 -
If:\iw-home\iw-perl\lib -MExtUtils::Command -e chmod 644 Oracle.bs
f:\iw-home\iw-perl\bin\iwperl.exe
-If:\iw-home\iw-perl\lib\MSWin32-x86
-If:\iw-home\iw-perl\lib -MExtUtils::Mksymlists -e
Mksymlists('NAME' =
'DB
D-Oracle', 'DLBASE' = 'Oracle', 'DL_FUNCS' = { }, 'FUNCLIST' = [],
'IMPORTS'
= { }, 'DL_VARS' = []);
link -out:blib\arch\auto\DBD-Oracle\Oracle.dll -dll -nologo
-nodefaultli
b -release -machine:x86 Oracle.obj
F:\iw-home\iw-perl\lib\MSWin32-x86\CORE\per
l.lib oldnames.lib kernel32.lib user32.lib gdi32.lib winspool.lib
comdlg32.lib
advapi32.lib shell32.lib ole32.lib oleaut32.lib netapi32.lib uuid.lib
wsock32.l
ib mpr.lib winmm.lib version.lib odbc32.lib odbccp32.lib
PerlCRT.lib -def:Oracl
e.def
LINK : fatal error LNK1104: cannot open file 'Oracle.def'
LINK : fatal error LNK1141: failure during build of exports file
NMAKE : fatal error U1077: 'link' : return code '0x475'
Stop.
Re: Logging in without username and password
[EMAIL PROTECTED] (Suzanne M Ruggiero) writes: I am running the script from a different server to where the database is held, and due to security issues I am unable to hardcode the username and password. I have searched and am unable to find anything to cover this. That is correct - you are looking for one of the classic perpetual motion machines of programming. You won't find one. You have somehow to set up trust between the computers. There are mecahisms to do this. But ultimately is must come down to a secret stored on the client and verified by the server. Either a shared secret or a public-key crypto solution. This message and any attachments are confidential... [ drivel ] ...bind the HSBC entity referred to is duly verified. Please don't do that. -- \\ ( ) . _\\__[oo .__/ \\ /\@ . l___\\ # ll l\\ ###LL LL\\
RE: Logging in without username and password
Using STDIN is not an option? Do you not want the user to know the password? Jamin Roth Systems/Network Administrator Sorensen Associates Inc Phone: (503) 665-0123 ext 289 Fax: (503) 666-5113 http://www.sorensen-associates.com/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, July 24, 2003 6:55 AM To: [EMAIL PROTECTED] Subject: Logging in without username and password Hi all, I am running the script from a different server to where the database is held, and due to security issues I am unable to hardcode the username and password. I have searched and am unable to find anything to cover this. The environment is Unix and the database is DB2. Any help would be much appreciated. Thanks, Suzanne ** HSBC's website is at www.hsbc.com ** This message and any attachments are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee you may not copy, forward, disclose or use any part of the message or its attachments and if you have received this message in error, please notify the sender immediately by return e-mail and delete it from your system. Internet communications cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, arrive late or contain viruses. The sender therefore does not accept liability for any errors or omissions in the context of this message which arise as a result of Internet transmission. Any opinions contained in this message are those of the author and are not given or endorsed by the HSBC Group company or office through which this message is sent unless otherwise clearly indicated in this message and the authority of the author to so bind the HSBC entity referred to is duly verified.
Re: DBI, DBD::Informix and Statement SIze
Rasoul Hajikhani wrote:
Jonathan Leffler wrote:
Rasoul Hajikhani wrote:
Here is a brief description of my DBD::Informix
Type: dr
Name: Informix
Version: 2003.04
Attribution: Jonathan Leffler [EMAIL PROTECTED]
Product: INFORMIX-ESQL Version 9.51.UC1
Product Version: 951
I am trying to insert a 16MB data into a idn_mrLvarchar data type
which has 2GIG capacity. This I can achieve using LOAD statement
within 'dbaccess'. However, going through DBI, I can only achieve
256Bytes of data insertion. DBI::bind_param, and
DBI::bind_param_inout are not implemented. I have used place holders
with no effect either. Short of asking 'What Next', I am wondering if
DBI does not care about the size of a SQL statement, which some of
this group's members suggested some other day in their email to me,
then what is preventing this insertion? I have a read some old email
on this list and in one of them it was suggested that the sql size
limit is 64K (True/False?). Is there any way of changing size limit
in DBI, if such functionality exists at all?
The bind_param method is implemented,
True, my mistake... :(
though bind_param_inout is not.
Informix poses a limit of 64 KB on the size of a statement - the DBMS
and access code such as ESQL/C does this. DBD::Informix cannot change
it. However, you can provide parameters which are much larger.
Since I don't recognize idn_mrLvarchar as a data type - though I
suspect it is a DataBlade (probably the multi-representational long
varchar data type from the Informix Developer Network), and someone
had a question about this on comp.databases.informix a week or so ago
(a bit before I took some vacation) - I suspect that most of the
people on the dbi-users mailing list won't recognize it either.
From
http://www7b.boulder.ibm.com/dmdd/zones/informix/library/techarticle/db_mrLvarchar.html:
The idn_mrLvarchar user-defined type (UDT) stores character data up to 2
gigabytes. It is like the built-in lvarchar SQL type, but without the 2K
column limit.
OK - it is the multi-rep varchar data type. I will have to get it
installed on my machine, I suppose.
idn_mrLvarchar is implemented as a multirep, which means that text
shorter than 2K is stored in-row and text longer than 2K is stored in a
smart blob. (Ok, 8 bytes of housekeeping information gets maintained in
the UDT value. Specifically, a value = 2040 bytes is stored in-row.
Anything larger gets stored in a smart blob.)
Since you don't show us any code - let alone provide a simple
reproduction of your problem - I can't yet provide very much more help.
use DBI;
#Read the contents of a file w/ 12mb of data...
my $theFile = $ARGV[0];
undef $/;
my $fh = new IO::File $theFile,r or die IO::FILE NEW
FAILED $theFile: $!\n;
my $data= $fh;
close $fh or die CLOSE FAILED: $!\n;
my $sql = INSERT INTO secure_users
(code,username,gpgusername,gpgpassphrase_mrlvc) VALUES (?,?,?,?);
my $sth = $dbh-prepare($sql) || die ERROR: $DBI::errstr\n;
my $rc = $sth-bind_param(1,1456);
$rc = $sth-bind_param(2,'yadayada');
$rc = $sth-bind_param(3,'yayayay');
$rc = $sth-bind_param(4,$data);
$sth-execute();
$sth-finish();
Using the above method and code, only 256b are inserted into the table.
The large data gets truncated at insertion time.
OK: the problem is, I think, that the DBD::Informix code only handles
UDTs up to 256 bytes at the moment. That was a limit that was going
to have to go, sooner or later, and now maybe sooner rather than
later. However, I've got another change in the works which is, I
think, a pre-requisite for this and a few other changes (including
bind_param_inout!).
In the meantime, try this untested workaround:
use DBI;
use DBD::Informix qw(:ix_types);
...
$rc = $sth-bind_param(4, $data, { ix_type = SQLLVARCHAR });
...
That may well get you around the problem.
You'll need to check the spelling of the RHS of the = -- that's in
the documentation for DBD::Informix (v2003.04).
The theory is that if you tell it that the type is an LVARCHAR, it
will transfer up to 2 GB of data and the DBMS will handle the
conversion to your UDT. Whether the practice matches the theory
remains to be seen.
--
Jonathan Leffler ([EMAIL PROTECTED], [EMAIL PROTECTED])
#include disclaimer.h
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/
