RE: (Fwd) Compile problem with DBD-Oracle-1.12
I was having the exact problem on my installation. Aix 4.3.3.10 Perl 5.6 I solved the problem by recompiling perl with the USE_64_BIT_ALL option. But then i got stuck on some other issues... See my other mails for that :) Greetz -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: woensdag 11 september 2002 17:44 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: (Fwd) Compile problem with DBD-Oracle-1.12 - Forwarded message from Frank Meyers <[EMAIL PROTECTED]> - Delivered-To: [EMAIL PROTECTED] Date: Wed, 11 Sep 2002 10:30:06 -0500 From: "Frank Meyers" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: Compile problem with DBD-Oracle-1.12 Tim, Hello my name is Frank Meyers. I wanted to know if there is a work around for the following problem we are having compiling DBD-Oracle-1.12 with Oracle 9i. The error we get when we try to run "make" is the following... rm -f blib/arch/auto/DBD/Oracle/Oracle.so LD_RUN_PATH="/u01/app/oraclex/product/920/lib" ld -bhalt:4 -bM:SRE -bI:/appl/perl/lib/5.6.1/aix/CORE/perl.exp -bexpall -berok -b noentry -lc -L/usr/local/lib Oracle.o dbdimp.o oci7.o oci8.o /u01/app/oraclex/product/920/rdbms/lib/defopt.o /lib/crt0_64.o -o blib/arch/auto/DBD/Oracle/Oracle.so -L/u01/app/oraclex/product/920/lib/ -lclntsh -lld -lm -ldl -lc -lm -lpthreads -lodm -lbsd_r -lld -lm -lpthreads ld: 0711-736 ERROR: Input file /u01/app/oraclex/product/920/rdbms/lib/defopt.o: XCOFF64 object files are not allowed in 32-bit mode. make: 1254-004 The error code from the last command is 8. Here is some version information on the system we compiled this on. OS:AIX 4.3.3.10 Perl: Version 5.6.1 DBI Module: 1.20 gcc: 3.2 Oracle: 9i I know you are busy and appreciate you taking the time to look at this. Thanks Frank Meyers Trans Union Chicago DSI [EMAIL PROTECTED] 312-466-8536 - End forwarded message -
Re: Multiple Oracle client versions and Perl DBI
Unless you need to exploit new features of the database that will not work from Perl without linking in the newer libraries, you don't need to reset your ORACLE_HOME. Just connect to the 9i database with the 8i libs. I use 8.1.7 build of DBD::Oracle to connect to 7.3.4, 8.0.4, 8.0.6, 8.1.6, 8.1.7 and 9.2.0. Jared On Wednesday 04 September 2002 18:36, Ellen Yu wrote: > Does anybody know if it's possible to have many Oracle client versions use > Perl DBI? I recently upgraded one of our servers from 8.1.7 to 9.2.0. > > Now if I run perl scripts with the 8.1.7 environment it works, but if I > set it to 9.2.0 it doesn't. > > If I have to make the perl modules again, does that mean that I couldn't > run the perl script with the 8.1.7 environment settings? > > > Regards, > > Ellen Yu
rows not being returned with DBI-1.30/DBD-Oracle-1.12
This is probably a nubbie question, but I can't find anything to point
me in the right direction. I'm moving a database written in access to
oracle91, and I'm now attempting to write a perl (And soon, a cgi)
interface. The problem is when I select based on an IP I get no rows
returned, but when I select based of of MAC address, rows ar returned.
I'm running Oracle 9i on Redhat Linux 7.3 with Perl 5.6.1 with DBI 1.30
and DBD-Oracle 1.12. Thanks in advance.
Table Definition
CREATE TABLE "DCROWN"."tblStaticIP" ("IP" CHAR(15 byte) NOT NULL,
"MOVEIPTO" CHAR(15 byte), "MOVEIP" NUMBER(2), "MACADDRESS"
CHAR(12 byte), "DESCRIPTION" CHAR(32 byte), "TYPEID"
NUMBER(10), "BRAND" CHAR(16 byte), "MODEL" CHAR(16 byte),
"APPROVEDBY" CHAR(32 byte), "ADDEDBY" CHAR(32 byte),
"DATEADDED" CHAR(10 byte), "COMMENTS" CHAR(255 byte),
"CONTACTPOINT" CHAR(32 byte), "CONTACTNUM" CHAR(10 byte),
"CID" CHAR(20 byte), "SPID_1" NUMBER(7), "SPID_2" NUMBER(7),
"PAIRED_DEV" NUMBER(1) DEFAULT 0, "PAIRED_IP" CHAR(15 byte),
CONSTRAINT "IP_PK" PRIMARY KEY("IP"))
TABLESPACE "MAIN" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS
255
STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0)
LOGGING
Perl code
--
#!/usr/bin/perl -w
use DBI;
$ip_db = DBI
->connect("DBI:Oracle:host=netmon.dnrec.state.de.us;sid=devices",'the_us
ername','the_password') || die "Failure to connect: " . DBI::errstr;
$ip_db->{RaiseError} = 1;
$sql= qq{SELECT * FROM "DCROWN"."tblStaticIP" WHERE ("IP" = :str) };
$lookup = $ip_db->prepare($sql) || die "failure on prepare: " .
$ip_db->errstr;
print ("enter ip address: ");
chomp ($instr = );
#$instr = "\'".$instr . "\'";
print ("sql statment of $sql\n");
$lookup->bind_param(':str', $instr );
$lookup->execute() || die "SQL statement failed: " . $lookup->errstr;
my @records;
@records = $lookup->fetchrow_array ;
print("IP $records[0] is $records[4] with mac of $records[3]\n");
$ip_db->disconnect;
David Crown, MCSE, MCP+I, CCNA
Information Resources Management
State of Delaware,
Department of Natural Resources and Environmental Control
[EMAIL PROTECTED]
Voice: (302)739-4409 Fax: (302)739-6242
www.dnrec.state.de.us/
Re: "Relocation error"
I thought 5.8.0 was stable? Do you suggest I use an earlier version? I also have 5.6.1 but wouldn't a lot of things get screwed up if I removed 5.8.0? I tried "apt-get install libdbd-mysql-perl" and it says I have the newest version. Rich - Original Message - From: "Waldemar Zurowski" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 11, 2002 1:41 PM Subject: Re: "Relocation error" > On Wed, 11 Sep 2002 10:33:36 -0400 > "Rich DeSimone" <[EMAIL PROTECTED]> wrote: > > > I am using debian and I verified which packages are installed by viewing a > > list at http://slashcode.com/docs/INSTALL.debian I installed all the perl > > modules packages even though I am sure I don't need all of them. Anyway I > > am still getting "perl: relocation error: > > /usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBD/mysql/mysql.so: > > undefined symbol: mysql_init" > > > :) Using unstable and wandering why sometimes things doesn't work... > > Have you tried: > # apt-get install libdbd-mysql-perl > ? > > and You should remove any previous installation of DBD::mysql from /usr/local, as they are taken first, before any module installed from packages. > > Waldemar
Re: "Relocation error"
On Wed, 11 Sep 2002 10:33:36 -0400 "Rich DeSimone" <[EMAIL PROTECTED]> wrote: > I am using debian and I verified which packages are installed by viewing a > list at http://slashcode.com/docs/INSTALL.debian I installed all the perl > modules packages even though I am sure I don't need all of them. Anyway I > am still getting "perl: relocation error: > /usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBD/mysql/mysql.so: > undefined symbol: mysql_init" :) Using unstable and wandering why sometimes things doesn't work... Have you tried: # apt-get install libdbd-mysql-perl ? and You should remove any previous installation of DBD::mysql from /usr/local, as they are taken first, before any module installed from packages. Waldemar
FW: DBI core dump version 1.30
> -Original Message- > From: Heiligenberg, Etienne van den > Sent: Wednesday 11 September 2002 1:32 PM > To: '[EMAIL PROTECTED]' > Cc: '[EMAIL PROTECTED]' > Subject: DBI core dump version 1.30 > > Hi, > > Some specs: > 9ias 1.0.2.2.0 > Apache 1.3.19 > > oslevel: 4.3.3.0 > > Installed module DBI version 1.30. When starting Apache with: PerlModule > Apache::DBI, I get: > > rs0130:ora_ias [/oracle/product/ias/Apache/Apache/conf] apachectl start > /oracle/product/ias/Apache/Apache/bin/apachectl[99]: 17382 Segmentation > fault(coredump) > /oracle/product/ias/Apache/Apache/bin/apachectl start: httpd could not be > started > rs0130:ora_ias [/oracle/product/ias/Apache/Apache/conf] > > 1. Install-log looks good: > > <> > > 2. Output of perl -V: > > rs0130:ora_ias [/oracle/product/ias/Apache/Apache/conf] perl -V > Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration: > Platform: > osname=aix, osvers=4.3.2.0, archname=aix > uname='aix 3 4 000b540d4c00 ' > hint=recommended, useposix=true, d_sigaction=define > usethreads=undef useperlio=undef d_sfio=undef > Compiler: > cc='xlc', optimize='-O', gccversion= > cppflags='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=8192 > -I/usr/local/include' > ccflags ='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=8192 > -I/usr/local/include' > stdchar='unsigned char', d_stdstdio=define, usevfork=false > intsize=4, longsize=4, ptrsize=4, doublesize=8 > d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=8 > alignbytes=8, usemymalloc=n, prototype=define > Linker and Libraries: > ld='ld', ldflags =' -L/usr/local/lib' > libpth=/usr/local/lib /lib /usr/lib /usr/ccs/lib > libs=-lnsl -ldbm -ldl -lld -lm -lc -lcrypt -lbsd -lPW > libc=, so=a, useshrplib=false, libperl=libperl.a > Dynamic Linking: > dlsrc=dl_aix.xs, dlext=so, d_dlsymun=undef, ccdlflags='-bE:perl.exp' > cccdlflags=' ', lddlflags='-bhalt:4 -bM:SRE -bI:$(PERL_INC)/perl.exp > -bE:$(BASEEXT).exp -b noentry -lc -L/usr/local/lib' > > > Characteristics of this binary (from libperl): > Built under aix > Compiled at Aug 14 1999 08:59:55 > %ENV: > > PERL5LIB="/oracle/product/ias/Apache/perl/lib/5.00503:/oracle/product/ias/ > Apache/perl/lib/site_perl/5.005" > @INC: > /oracle/product/ias/Apache/perl/lib/5.00503/aix > /oracle/product/ias/Apache/perl/lib/5.00503 > /oracle/product/ias/Apache/perl/lib/site_perl/5.005/aix > /oracle/product/ias/Apache/perl/lib/site_perl/5.005 > /usr/opt/perl5/lib/5.00503/aix > /usr/opt/perl5/lib/5.00503 > /usr/opt/perl5/lib/site_perl/5.005/aix > /usr/opt/perl5/lib/site_perl/5.005 > > 3. dbx output: > > rs0130:ora_ias [/oracle/product/ias/Apache/Apache/bin] dbx httpd > Type 'help' for help. > reading symbolic information ... > [using memory image in core] > > Segmentation fault in strcmp.strcmp > [/oracle/product/ias/Apache/perl/lib/site_perl/5.005/aix/auto/DBI/DBI.so] > at 0xd37f680c ($t1) > 0xd37f680c (strcmp+0xcc) 88a30001lbz r5,0x1(r3) > (dbx) where > strcmp.strcmp() at 0xd37f680c > Perl_pp_entersub() at 0xd0b7c7b8 > Perl_runops_standard() at 0xd0bb7b20 > perl_call_sv() at 0xd0b64f8c > Perl_call_list() at 0xd0b66538 > Perl_newSUB() at 0xd0b944d8 > Perl_yyparse() at 0xd0b8caf0 > doeval() at 0xd0b81f48 > Perl_pp_require() at 0xd0b85fbc > Perl_runops_standard() at 0xd0bb7b20 > perl_call_sv() at 0xd0b64f8c > Perl_call_list() at 0xd0b66538 > Perl_newSUB() at 0xd0b944d8 > Perl_utilize() at 0xd0b8f9ec > Perl_yyparse() at 0xd0b8ce1c > doeval() at 0xd0b81f48 > Perl_pp_require() at 0xd0b85fbc > Perl_runops_standard() at 0xd0bb7b20 > perl_eval_sv() at 0xd0b63e00 > perl_require_module() at 0xd0bcd388 > perl_cmd_module() at 0xd0b3f27c > invoke_cmd(0x200c5b58, 0x2ff22898, 0x2006a310, 0x2ff20856), line 1071 in > "http_config.c" > unnamed block $b13, line 1204 in "http_config.c" > ap_handle_command(0x2ff22898, 0x20018910, 0x2ff20840), line 1204 in > "http_config.c" > unnamed block $b16, line 1218 in "http_config.c" > ap_srm_command_loop(0x2ff22898, 0x20018910), line 1218 in "http_config.c" > ap_process_resource_config(0x20018390, 0x20019ab0, 0x20018368, > 0x2001c3a8), line 1480 in "http_config.c" > ap_read_config(0x20018368, 0x2001c3a8, 0x20003648), line 1772 in > "http_config.c" > main(argc = 3, argv = 0x2ff22aa4), line 5215 in "http_main.c" > (dbx) quit > > What seems to be the problem here? > > Thanks for your time on time on this issue > > Etienne van den Heiligenberg > DBA ORACLE (Oracle corporation, The Netherlands) > > Having this issue at the following site: > ING BANK, The Netherlands > > phone: +31 20 5013173 > email: > [EMAIL PROTECTED] > [EMAIL PROTECTED] > 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::PlCl
RE: why do I need to supply user & password
I don't actually do anything to authenticate for SQL Server access. I use Net::LDAP to authenticate users before they enter various unix based web applications. Since we have a mix of NT and Unix I want to use NT id authentication. Either way, you will need to ask for, or provide a user/pass combination. If this still sounds like something you can use I'd be happy to share the experience of getting this to work and code examples. FYI, there is also a DBD::LDAP. -Original Message- From: cp [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 10:56 AM To: Vanole, Mike; dbi users perl.org Subject: Re: why do I need to supply user & password Can you post an example of using Net::LDAP to authenticate to a SQL server form a *Nix platform? I'd love to use something like that in our shop. -- Give a man a match, and he'll be warm for a minute, but set him on fire, and he'll be warm for the rest of his life. > From: "Vanole, Mike" <[EMAIL PROTECTED]> > Date: Wed, 11 Sep 2002 10:36:59 -0500 > To: "'Levine, Peter W'" <[EMAIL PROTECTED]>, "'Jeff Urlwin'" > <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > Subject: RE: why do I need to supply user & password > > You can try LDAP autentication with Net::LDAP from UNIX. I do it just fine > from Solaris. > > -Original Message- > From: Levine, Peter W [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 11, 2002 10:33 AM > To: 'Jeff Urlwin'; [EMAIL PROTECTED] > Subject: RE: why do I need to supply user & password > > > Jeff, > > Can I use Windows authentication from a UNIX server? > > Pete > > -Original Message- > From: Jeff Urlwin [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 11, 2002 8:31 AM > To: Levine, Peter W; [EMAIL PROTECTED]; 'Jeff Urlwin' > Subject: RE: why do I need to supply user & password > > > Peter, > > I think so. I just checked. I do *not* see a password stored in my > registry when I try to switch authentication to SQL Server authentication. > IF you can switch to NT authentication (which I'm guessing you can't, > but...), then the authentication is handled behind the scenes...
Re: why do I need to supply user & password
Can you post an example of using Net::LDAP to authenticate to a SQL server form a *Nix platform? I'd love to use something like that in our shop. -- Give a man a match, and he'll be warm for a minute, but set him on fire, and he'll be warm for the rest of his life. > From: "Vanole, Mike" <[EMAIL PROTECTED]> > Date: Wed, 11 Sep 2002 10:36:59 -0500 > To: "'Levine, Peter W'" <[EMAIL PROTECTED]>, "'Jeff Urlwin'" > <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > Subject: RE: why do I need to supply user & password > > You can try LDAP autentication with Net::LDAP from UNIX. I do it just fine > from Solaris. > > -Original Message- > From: Levine, Peter W [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 11, 2002 10:33 AM > To: 'Jeff Urlwin'; [EMAIL PROTECTED] > Subject: RE: why do I need to supply user & password > > > Jeff, > > Can I use Windows authentication from a UNIX server? > > Pete > > -Original Message- > From: Jeff Urlwin [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 11, 2002 8:31 AM > To: Levine, Peter W; [EMAIL PROTECTED]; 'Jeff Urlwin' > Subject: RE: why do I need to supply user & password > > > Peter, > > I think so. I just checked. I do *not* see a password stored in my > registry when I try to switch authentication to SQL Server authentication. > IF you can switch to NT authentication (which I'm guessing you can't, > but...), then the authentication is handled behind the scenes...
Re: $sth->err for multiples descriptors
The docs say: The DBI resets $h->err to undef before most DBI method calls, so the value only has a short lifespan. Also, most drivers share the same error variables across all their handles, so calling a method on one handle will typically reset the error on all the other handles that are children of that driver. That may be the issue. Tim. On Wed, Sep 11, 2002 at 04:51:08PM +0200, sidi MOHAMED CHEINE wrote: > I have a problem with dbi, I set up a system of > capture of error. > In my program I use two descriptors dbi, only when I > intercept an error on the undes descriptors, the tests > of errors $sth->err gives the same result on both. Is > what somebody would have a solution has to propose to > me > thank you in advance > > and good day. > > Sidi > > ___ > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en franais ! > Yahoo! Mail : http://fr.mail.yahoo.com
(Fwd) Compile problem with DBD-Oracle-1.12
- Forwarded message from Frank Meyers <[EMAIL PROTECTED]> - Delivered-To: [EMAIL PROTECTED] Date: Wed, 11 Sep 2002 10:30:06 -0500 From: "Frank Meyers" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: Compile problem with DBD-Oracle-1.12 Tim, Hello my name is Frank Meyers. I wanted to know if there is a work around for the following problem we are having compiling DBD-Oracle-1.12 with Oracle 9i. The error we get when we try to run "make" is the following... rm -f blib/arch/auto/DBD/Oracle/Oracle.so LD_RUN_PATH="/u01/app/oraclex/product/920/lib" ld -bhalt:4 -bM:SRE -bI:/appl/perl/lib/5.6.1/aix/CORE/perl.exp -bexpall -berok -b noentry -lc -L/usr/local/lib Oracle.o dbdimp.o oci7.o oci8.o /u01/app/oraclex/product/920/rdbms/lib/defopt.o /lib/crt0_64.o -o blib/arch/auto/DBD/Oracle/Oracle.so -L/u01/app/oraclex/product/920/lib/ -lclntsh -lld -lm -ldl -lc -lm -lpthreads -lodm -lbsd_r -lld -lm -lpthreads ld: 0711-736 ERROR: Input file /u01/app/oraclex/product/920/rdbms/lib/defopt.o: XCOFF64 object files are not allowed in 32-bit mode. make: 1254-004 The error code from the last command is 8. Here is some version information on the system we compiled this on. OS:AIX 4.3.3.10 Perl: Version 5.6.1 DBI Module: 1.20 gcc: 3.2 Oracle: 9i I know you are busy and appreciate you taking the time to look at this. Thanks Frank Meyers Trans Union Chicago DSI [EMAIL PROTECTED] 312-466-8536 - End forwarded message -
RE: why do I need to supply user & password
You can try LDAP autentication with Net::LDAP from UNIX. I do it just fine from Solaris. -Original Message- From: Levine, Peter W [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 10:33 AM To: 'Jeff Urlwin'; [EMAIL PROTECTED] Subject: RE: why do I need to supply user & password Jeff, Can I use Windows authentication from a UNIX server? Pete -Original Message- From: Jeff Urlwin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 8:31 AM To: Levine, Peter W; [EMAIL PROTECTED]; 'Jeff Urlwin' Subject: RE: why do I need to supply user & password Peter, I think so. I just checked. I do *not* see a password stored in my registry when I try to switch authentication to SQL Server authentication. IF you can switch to NT authentication (which I'm guessing you can't, but...), then the authentication is handled behind the scenes... Regards, Jeff > > Hi, > > Follow-up. So is the error I get 'working as designed'? In other words is > SQL authentication without explicit user and password parameters in the > connect() not supported? > > If not, I would like it to since hard-coding the user/password in > my script > or as part of the environment are not solutions I like. > > Pete > > -Original Message- > From: Levine, Peter W > Sent: Thursday, September 05, 2002 1:58 PM > To: 'Jeff Urlwin' > Subject: RE: why do I need to supply user & password > > > Hi, > > I'm using SQL server authentication not NT authentication. If I levae out > user and password I get this error: > > > ERROR: [OpenLink][ODBC][SQL Server]Login failed for user '(null)'. Reason: > Not associated with a trusted SQL Server connection. (18452) > (SQL-S1000)(DBD: db_login/SQLConnect err=-1) > > Pete > > -Original Message- > From: Jeff Urlwin [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 05, 2002 1:49 PM > To: Levine, Peter W; [EMAIL PROTECTED] > Subject: RE: why do I need to supply user & password > > > > > > > > > Hi, > > > > Why do I need to supply user name and password with > DBI->connect() if I am > > using DBD:ODBC? This information is already supplied in the DSN? > > > > my $DSN="dbi:ODBC:sqlserver_dsn"; > > my $DBI_USER="Why do I need this?" > > my $DBI_PASS="Why do I need this?" > > > > $dbh=DBI->connect($DSN,$DBI_USER,$DBI_PASS); > > Err -- you don't -- I don't think -- at least I don't need to, > here. But my > SQL Server is configured for NT authentication. what happens > when you just > $dbh=DBI->connect($DSN);? > > Jeff > > >
RE: why do I need to supply user & password
Jeff, Can I use Windows authentication from a UNIX server? Pete -Original Message- From: Jeff Urlwin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 8:31 AM To: Levine, Peter W; [EMAIL PROTECTED]; 'Jeff Urlwin' Subject: RE: why do I need to supply user & password Peter, I think so. I just checked. I do *not* see a password stored in my registry when I try to switch authentication to SQL Server authentication. IF you can switch to NT authentication (which I'm guessing you can't, but...), then the authentication is handled behind the scenes... Regards, Jeff > > Hi, > > Follow-up. So is the error I get 'working as designed'? In other words is > SQL authentication without explicit user and password parameters in the > connect() not supported? > > If not, I would like it to since hard-coding the user/password in > my script > or as part of the environment are not solutions I like. > > Pete > > -Original Message- > From: Levine, Peter W > Sent: Thursday, September 05, 2002 1:58 PM > To: 'Jeff Urlwin' > Subject: RE: why do I need to supply user & password > > > Hi, > > I'm using SQL server authentication not NT authentication. If I levae out > user and password I get this error: > > > ERROR: [OpenLink][ODBC][SQL Server]Login failed for user '(null)'. Reason: > Not associated with a trusted SQL Server connection. (18452) > (SQL-S1000)(DBD: db_login/SQLConnect err=-1) > > Pete > > -Original Message- > From: Jeff Urlwin [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 05, 2002 1:49 PM > To: Levine, Peter W; [EMAIL PROTECTED] > Subject: RE: why do I need to supply user & password > > > > > > > > > Hi, > > > > Why do I need to supply user name and password with > DBI->connect() if I am > > using DBD:ODBC? This information is already supplied in the DSN? > > > > my $DSN="dbi:ODBC:sqlserver_dsn"; > > my $DBI_USER="Why do I need this?" > > my $DBI_PASS="Why do I need this?" > > > > $dbh=DBI->connect($DSN,$DBI_USER,$DBI_PASS); > > Err -- you don't -- I don't think -- at least I don't need to, > here. But my > SQL Server is configured for NT authentication. what happens > when you just > $dbh=DBI->connect($DSN);? > > Jeff > > >
RE: why do I need to supply user & password
Peter, I think so. I just checked. I do *not* see a password stored in my registry when I try to switch authentication to SQL Server authentication. IF you can switch to NT authentication (which I'm guessing you can't, but...), then the authentication is handled behind the scenes... Regards, Jeff > > Hi, > > Follow-up. So is the error I get 'working as designed'? In other words is > SQL authentication without explicit user and password parameters in the > connect() not supported? > > If not, I would like it to since hard-coding the user/password in > my script > or as part of the environment are not solutions I like. > > Pete > > -Original Message- > From: Levine, Peter W > Sent: Thursday, September 05, 2002 1:58 PM > To: 'Jeff Urlwin' > Subject: RE: why do I need to supply user & password > > > Hi, > > I'm using SQL server authentication not NT authentication. If I levae out > user and password I get this error: > > > ERROR: [OpenLink][ODBC][SQL Server]Login failed for user '(null)'. Reason: > Not associated with a trusted SQL Server connection. (18452) > (SQL-S1000)(DBD: db_login/SQLConnect err=-1) > > Pete > > -Original Message- > From: Jeff Urlwin [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 05, 2002 1:49 PM > To: Levine, Peter W; [EMAIL PROTECTED] > Subject: RE: why do I need to supply user & password > > > > > > > > > Hi, > > > > Why do I need to supply user name and password with > DBI->connect() if I am > > using DBD:ODBC? This information is already supplied in the DSN? > > > > my $DSN="dbi:ODBC:sqlserver_dsn"; > > my $DBI_USER="Why do I need this?" > > my $DBI_PASS="Why do I need this?" > > > > $dbh=DBI->connect($DSN,$DBI_USER,$DBI_PASS); > > Err -- you don't -- I don't think -- at least I don't need to, > here. But my > SQL Server is configured for NT authentication. what happens > when you just > $dbh=DBI->connect($DSN);? > > Jeff > > >
Re: $sth->err for multiples descriptors
Could you provide a code sample? On Wed, 2002-09-11 at 10:51, sidi MOHAMED CHEINE wrote: > I have a problem with dbi, I set up a system of > capture of error. > In my program I use two descriptors dbi, only when I > intercept an error on the undes descriptors, the tests > of errors $sth->err gives the same result on both. Is > what somebody would have a solution has to propose to > me > thank you in advance > > and good day. > > Sidi > > ___ > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! > Yahoo! Mail : http://fr.mail.yahoo.com
FW: why do I need to supply user & password
Hi, Follow-up. So is the error I get 'working as designed'? In other words is SQL authentication without explicit user and password parameters in the connect() not supported? If not, I would like it to since hard-coding the user/password in my script or as part of the environment are not solutions I like. Pete -Original Message- From: Levine, Peter W Sent: Thursday, September 05, 2002 1:58 PM To: 'Jeff Urlwin' Subject: RE: why do I need to supply user & password Hi, I'm using SQL server authentication not NT authentication. If I levae out user and password I get this error: ERROR: [OpenLink][ODBC][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. (18452) (SQL-S1000)(DBD: db_login/SQLConnect err=-1) Pete -Original Message- From: Jeff Urlwin [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 1:49 PM To: Levine, Peter W; [EMAIL PROTECTED] Subject: RE: why do I need to supply user & password > > > Hi, > > Why do I need to supply user name and password with DBI->connect() if I am > using DBD:ODBC? This information is already supplied in the DSN? > > my $DSN="dbi:ODBC:sqlserver_dsn"; > my $DBI_USER="Why do I need this?" > my $DBI_PASS="Why do I need this?" > > $dbh=DBI->connect($DSN,$DBI_USER,$DBI_PASS); Err -- you don't -- I don't think -- at least I don't need to, here. But my SQL Server is configured for NT authentication. what happens when you just $dbh=DBI->connect($DSN);? Jeff
$sth->err for multiples descriptors
I have a problem with dbi, I set up a system of capture of error. In my program I use two descriptors dbi, only when I intercept an error on the undes descriptors, the tests of errors $sth->err gives the same result on both. Is what somebody would have a solution has to propose to me thank you in advance and good day. Sidi ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com
Re: "Relocation error"
I am using debian and I verified which packages are installed by viewing a list at http://slashcode.com/docs/INSTALL.debian I installed all the perl modules packages even though I am sure I don't need all of them. Anyway I am still getting "perl: relocation error: /usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBD/mysql/mysql.so: undefined symbol: mysql_init" Any other ideas with this relocation error? Rich - Original Message - From: "Waldemar Zurowski" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 11, 2002 4:43 AM Subject: Re: "Relocation error" > On Tue, 10 Sep 2002 22:16:19 -0400 > "Rich DeSimone" <[EMAIL PROTECTED]> wrote: > [..] > > So I am assuming that code is right and I don't think it is even relevant to my problem. When I try to run the script I get "perl: relocation error: /usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBD/mysql/mysql.so: undefined symbol: mysql_init" > > > > Anyone know what the problem is and a possible solution? > > What linux distribution are you using? > > And why You don't use packages with DBI and DBD::MySQL build for your distibution? > > Waldemar
installation of DBD::Oracle 1.12 on ibm aix 64bit
Title: Message I'm new to this list and would like to say hi to everyone in it first of all. I am in seacrh for a solution for my problem for 5 days now and i am becoming a bit desperate. Here's my description : Before I installed oracle 9i on my server Perl, DBI and DBD::Oracle worked in perfect harmony. But with the instalation came the problems. So i decided to reinstall everything from perl, DBI and DBD. After some struggles with the 64 bit AIX ( on rs6000 ), I came to a perfect installation of perl "Perl v5.8.0 built for aix-64all-stdio" and DBI-1.20. However when i try to install DBD::Oracle 1.12 i get the following : perl Makefile.PL.txt make.txt ( see attachments ) The errormessage i get is : ld: 0711-317 ERROR: Undefined symbol: ksmsgl_ ld: 0711-317 ERROR: Undefined symbol: ksbdpt_ ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information. make: The error code from the last command is 8. Stop. I have tried to compile with the 8 libraries from Oracle but then i get a whole lot errors about the 64bit mode ( XCOFF64 not available in 32 bit mode , ... ) I'm a bit stuck here and would love some help from the experts thanks in advance for your time. greetz Bjorn Naessens Roularta IT Solutions Using DBI 1.20 installed in /usr/local/lib/perl5/site_perl/5.8.0/aix-64all-stdio/auto/DBI Duplicate specification "S=s" for option "s" Configuring DBD::Oracle ... >>> Remember to actually *READ* the README file! Especially if you have any problems. Using Oracle in /softw/app/oracle/producti/901 Found header files in rdbms/demo. Found /softw/app/oracle/producti/901/rdbms/demo/demo_rdbms.mk Found /softw/app/oracle/producti/901/otrace/demo/atmoci.mk Found /softw/app/oracle/producti/901/precomp/demo/proc/demo_proc.mk Using /softw/app/oracle/producti/901/rdbms/demo/demo_rdbms.mk Reading /softw/app/oracle/producti/901/rdbms/demo/demo_rdbms.mk. Reading /softw/app/oracle/producti/901/rdbms/lib/env_rdbms.mk. Deleting -b64 from COMPOBJS because -b64 doesn't exist. Appending '-bbigtoc' to LINKSTLIBS Evaluating `cat $(LIBHOME)ldflags` expanded `cat /softw/app/oracle/producti/901/lib/ldflags` returned '-lnbeq9 -lnhost9 -lnus9 -lnldap9 -lldapclnt9 -lnsslb9 -lnoname9 -lntcp9 -lntcps9 -lnsslb9 -lntcp9 -lntns9 ' expanded `cat /softw/app/oracle/producti/901/lib/ldflags` expanded `cat /softw/app/oracle/producti/901/lib/ldflags` expanded `cat /softw/app/oracle/producti/901/lib/ldflags` Evaluating `cat $(LIBHOME)sysliblist` expanded `cat /softw/app/oracle/producti/901/lib/sysliblist` returned '/lib/crt0_64.o -ldl -lc -lm -lpthreads -lodm -lbsd_r -lld' Attempting to discover Oracle OCI build rules... xlc_r -c -I. -I/softw/app/oracle/producti/901/precomp/public -I/softw/app/oracle/producti/901/rdbms/public -I/softw/app/oracle/producti/901/rdbms/demo -I/softw/app/oracle/producti/901/plsql/public -I/softw/app/oracle/producti/901/network/public -I/softw/app/oracle/producti/901/rdbms/demo -I/softw/app/oracle/producti/901/rdbms/demo -I/usr/local/lib/perl5/site_perl/5.8.0/aix-64all-stdio/auto/DBI -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -qnoansialias -DUSE_NATIVE_DLOPEN -I/usr/local/include -q64 -DUSE_64_BIT_ALL -q64 -O-DVERSION=\"1.12\" -DXS_VERSION=\"1.12\" "-I/usr/local/lib/perl5/5.8.0/aix-64all-stdio/CORE" DBD_ORA_OBJ.c 1506-507 (W) No licenses available. Contact your program supplier to add additional users. Compilation will proceed shortly. Oracle oci build command: echo -q64 -L/softw/app/oracle/producti/901/lib/ -L/softw/app/oracle/producti/901/rdbms/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o /softw/app/oracle/producti/901/lib/nautab.o /softw/app/oracle/producti/901/lib/naeet.o /softw/app/oracle/producti/901/lib/naect.o /softw/app/oracle/producti/901/lib/naedhs.o `cat /softw/app/oracle/producti/901/lib/ldflags`-lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnro9 `cat /softw/app/oracle/producti/901/lib/ldflags`-lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lclient9 -lvsn9 -lwtc9 -lcommon9 -lgeneric9 -lwtc9 -lmm -lnls9 -lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 `cat /softw/app/oracle/producti/901/lib/ldflags`-lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnro9 `cat /softw/app/oracle/producti/901/lib/ldflags`-lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lclient9 -lvsn9 -lwtc9 -lcommon9 -lgeneric9 -lpls9 -ltrace9 -lnls9 -lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 -lclient9 -lvsn9 -lwtc9 -lcommon9 -lgeneric9 -lnls9 -lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 -lld -lm `cat /softw/app/oracle/producti/901/lib/sysliblist` -lm -lpls9 -lsql9 -bI:/softw/app/oracle/producti/901/lib/pw-syscall.exp -bI:/softw/app/oracle/producti/901/lib/ksms.imp /softw/app/oracle/producti/901/rdbms/lib/defopt.o -lpthreads -q64 -L/softw/app/ora
test message - disregard plz
Test-message, disregard
Re: "Relocation error"
On Tue, 10 Sep 2002 22:16:19 -0400 "Rich DeSimone" <[EMAIL PROTECTED]> wrote: [..] > So I am assuming that code is right and I don't think it is even relevant to my >problem. When I try to run the script I get "perl: relocation error: >/usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBD/mysql/mysql.so: undefined >symbol: mysql_init" > > Anyone know what the problem is and a possible solution? What linux distribution are you using? And why You don't use packages with DBI and DBD::MySQL build for your distibution? Waldemar
Re: How do I detect non-select statements after calling $sth->execute()
Tim Bunce wrote:
>On Tue, Sep 10, 2002 at 01:49:35PM +0200, Roger Perttu wrote:
>
>
>>Tim Bunce wrote:
>>
>>
>>>On Wed, Sep 04, 2002 at 09:58:35AM -0500, Paul DuBois wrote:
>>>
>>>
>>>
At 9:50 -0500 9/4/02, David Dooling wrote:
>For security reasons, wouldn't you want to know what statements are
>non-select _before_ you execute?
>
>If you only care about after, how about something like this:
>
> $sth->execute;
> my @row = $sth->fetchrow_array;
> if (@row) { # results }
> elsif (!$sth->errstr) { # now rows }
> else { warn $sth->errstr }
>
>You can't distinguish between selects that return no data and
>non-selects. But for your example below, it really wouldn't matter.
>It seems you need to parse this stuff before.
>
>
>
In MySQL, you can distinguish select from non-select statements after
$sth->execute by checking $sth->{NUM_OF_FIELDS}. If it's zero, it's
a non-select, if it's non-zero, it's a select. This works even if the
select returns zero rows, because the "width" of the result set is
greater than zero. No parsing of the statement or any other messing
around with it is necessary.
Does this work for other database engines as well?
>>>It has to as it's the "standard" way to check. The DBI docs specifically
>>>say "Non-C statements will have C."
>>>
>>>Tim.
>>>
>>>
>
>
>
>>The pod is a bit unclear about NUM_OF_FIELDS. I know that it returns
>>something > 0 for stored procedures containing select-statements. But I
>>know this by testing not by reading the pod.
>>
>>
>
>That's very database/driver-specific (Sybase and MSSQL only as far
>as I know) and the whole issue of how such cases should be handled
>by the DBI is currently mostly undefined.
>
>
>
I'm glad that I'm using MSSQL then!
I'm the one that started this thread and I'm _not_ interested in the
number of columns returned. All I want to do is to call fetch without
having the "no select statement currently executing" message thrown at
me. I get it the _first_ time I call fetch if it's a non
select-statement. I now know that I can catch the error using
HandleError but the code will be ugly. It would be much better if I
could disable this _unwanted_ help from DBI. All I want is undef unless
there is a serious error (syntax error, primary key violation etc).
Roger P
RE:problem with DBD
I check the permissions, I have the same configuration to the oracle client on two computer. But I have the error only on one. ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com
