Hello,
I'm really desperate for a solution to this problem so I'll be eternally
grateful to anyone who can help me.
My setup is as follows:
perl 5.6.1, DBD and DBI using Oracle 9i and connecting to a 9i database
I cannot connect as the 'sys' user
My current syntax is as follows:
my
Hi!
oracle@xcsyt99x:~ oerr ora 1031
01031, 0, insufficient privileges
// *Cause: An attempt was made to change the current username or password
// without the appropriate privilege. This error also occurs if
// attempting to install a database without the necessary
Thankyou for the feedback, it is much appreciated.
I'll give you a further insight into the problem.
I'm using OS authentication to connect to the database. I am the user
'oracle' who is a member of the dba group.
Under Oracle 8i, I used the following syntax:
my
Hello...
I need to connect to an SQLServer database, using DBD-Sybase-0.93 module.
After modifying the CONFIG file as follows:
SYBASE=/usr/local/freetds (where I have installed the FREETDS)
DBI_INCLUDE=/usr/lib/perl5/site_perl/5.6.0/i386-linux/DBI
and running perl Makefile.PL --file (I put
Ricardo Derbes wrote:
Hello...
I need to connect to an SQLServer database, using DBD-Sybase-0.93 module.
After modifying the CONFIG file as follows:
SYBASE=/usr/local/freetds (where I have installed the FREETDS)
DBI_INCLUDE=/usr/lib/perl5/site_perl/5.6.0/i386-linux/DBI
I believe 0.93
I am attempting to upgrade my Dbase code to Berkeley DBI 3.1.*.
I am not having any luck looking up $hash{854}. Is there someone
out there who can help me with this code?
Todd Gruhn
--
Indeed in nothing is the power of the Dark Lord more clearly shown than in the
estrangement that divides all
Todd Gruhns Acct wrote:
I am attempting to upgrade my Dbase code to Berkeley DBI 3.1.*.
I am not having any luck looking up $hash{854}. Is there someone
out there who can help me with this code?
Did you try $hash{731}, too?
Joern
--
Joern Reder -- Software Development, dimedis GmbH,
Hi!
Maybe you have to grant the SYSDBA again to the SYSTEM user and please use
the alter user statement, to get synchronous SYSDBA and normal password
for system.
(I allways do that :-)
Try using a passwordfile for oracle.
You need it every time you want to connect to the database via
Hello all,
I am using DBD-Oracle-1.06 and DBI-1.15 modules on SunOS 5.8 While
executing a perl script that used to work fine on dev machine i am getting
this error:
$ select_infopump_completion.pl
You must install a Solaris patch to run this version of the Java runtime.
Please see the README
See README.java.
Ilya
-Original Message-
From: Rozengurtel, Daniel
To: '[EMAIL PROTECTED]'
Sent: 12/11/01 8:35 AM
Subject: Java Error
Hello all,
I am using DBD-Oracle-1.06 and DBI-1.15 modules on SunOS 5.8 While
executing a perl script that used to work fine on dev machine i am
Darren Clissold writes:
make test
And I get this error on basically all the tests.
install_driver(Sybase) failed: Can't load
'blib/arch/auto/DBD/Sybase/Sybase.so' for module DBD::Sybase: ld.so.1:
/usr/local/bin/perl: fatal: relocation error: file
I get the feeling you're mixing apple and oranges.
OS authentication - means you don't need to supply a userid or password.
You connect to the database as the OS user (of the process trying to
connect). You need to have the
REMOTE_LOGIN_PASSWORDFILE =none in the init.ora. And you need to
On Mon, Dec 10, 2001 at 11:45:16PM -0800, Matisse Enzer wrote:
Hi folks.
I'm looking for feedback on this...
The source code is on my web site at:
http://www.matisse.net/perl-modules/DBI/Wrapper/
Here's the README:
DBI/Wrapper version 0.01
I'm new to OO Perl, and have a question about storing the value
of the $dbh in an object.
This is a Perl CGI(not CGI.pm) DBI application - each cgi script
connects at the start and creates a $dbh which then gets used
throughout the remainder of the script. For this application,
I created a
I usually set a class level $dbh based on the DB that's
right for the object -- we have several DB's here so there
is no concept of a global $dbh -- it depends on what data
you're dealing with.
I do not like passing it per object method either. It may
make sense for some methods as an optional
[EMAIL PROTECTED] (Hardy Merrill) writes:
My question is, what is the best method for allowing the object
methods to use the $dbh established at the beginning of a cgi
script? The 3 options I saw were:
What I like to do is to create the $dbh in the constructor, and store
it as part of the
[EMAIL PROTECTED] (Joseph Xu) writes:
The following test script has strange behavior. It may relate
to CGI::Vars. please advice.
Thanks
#!/usr/bin/perl
use DBI;
use CGI;
my $dbh = DBI-connect(dbi:mysql:wirepoll01, UID, PWD);
my $q = new CGI;
$q-param('abc' = 'teststring');
I have a security related question. How does one deal with database
security such as connect usernames and passwords in plain text perl scripts?
Obviously encoding them directly into the scripts is not optimal. This also
makes it difficult to alter all these scripts if you need to
Being a newbie I am not sure what I am doing is the best way BUT it works
for us. I create accounts with ONLY the access the accound needs. I have
no 'system wide' accounts. If the username/password is used for reporting
(as most of mine are) they get only the ability to read data not modify
well this makes sense of course narrowing it down only giving
accounts access to what they need but we have scripts that run at 3am from
the cron demon, so i can't be there to type in passwords. obviously the
most secure (aside from locking a computer in a room with no network
connection
ok this is a different ball of wax altogether :-) We do use ssh
instead of ftp to prevent network sniffing of data, but i am not even
looking at this yet how to prevent someone from sniffing the connection and
stealing stuff. We use oracle. But that is an interesting link thanks. We
Well depending on what the scripts do, they don't necessarily have
to run as root. Ideally they don't whenever possible but obviously
sometimes it is necessary. And yes of course if someone were to get root
access, that pretty much seals the deal, it is indeed very bad. But as you
oh, yea - i forgot: i simply do() a little file at the beginning of my
cgi-stuff, and that one connects to the db (and dumps out headers, etc),
so i can change any setting there at the push of a button (and i can
tell apache to ignore that init-file for security's sake). that works
just fine -
I think you missed his point Bill.
I imagine he intends to use it in a SQL query, but is
just showing it in a single print statement to isolate
the error.
try using vars in list context
%params = $q-Vars;
or use the quote method on the param call like:
$dbh-quote(param('abc'));
Job
I am have a huge problem trying to understand the following errors while
trying to install the DBD::Oracle module on or HPUX machine. These are the
errors I am getting:
/usr/lib/dld.sl: Can't shl_load() a library containing Thread Local Storage:
/usr/lib/libpthread.1
/usr/lib/dld.sl: Exec format
Hi all,
I compiled a static Perl, then compiled DBI module, and
finally DBD::Informix.
after that I removed everything and kept only the Perl
executalbe, why it is still trying to locate DBI in the @INC,
I already added the DBD and DBD::Informix to the executable itself.
Can't locate DBI.pm in
On Monday, December 10, 2001, at 11:45 PM, Matisse Enzer wrote:
Hi folks.
Hi Matisse.
I'm looking for feedback on this...
You would write:
my $sql = SELECT name,address FROM $table WHERE zipcode=?;
my $found_rows = $wrapper-FetchAll($sql,$zipcode);
# $found_rows is an
Not quit there yet,
I now get Seg Faults.
PERL_DL_NONLAZY=1 /usr/local/bin/perl -Iblib/arch -Iblib/lib
-I/usr/local/lib/perl5/5.6.1/sun4-solaris -I/usr/local/lib/perl5/5.6.1 -e
'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;'
t/*.t
t/autocommitdubious
Darren Clissold writes:
Not quit there yet,
I now get Seg Faults.
PERL_DL_NONLAZY=1 /usr/local/bin/perl -Iblib/arch -Iblib/lib
-I/usr/local/lib/perl5/5.6.1/sun4-solaris -I/usr/local/lib/perl5/5.6.1 -e
'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;'
t/*.t
DBI 1.20 does not appear to honour the PREFIX when it is supplied.
perl Makefile.PL PREFIX=/tmp/blah
make
make install
Installing /usr/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI/DBIXS.h
Installing /usr/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI/dbipport.h
Installing
It is true that selectall_hashref returns the same thing as this
modules' FetchAll method - the difference is that the FetchAll method
will call
Carp::confess if the DBI prepare or execute methods fail.
Perhaps this isn't worth it - DBI-trace could be turned on for example.
At 9:33 AM
At 5:36 PM + 12/11/01, Tim Bunce wrote:
my $sql = SELECT name,address FROM $table WHERE zipcode=?;
my $found_rows = $wrapper-FetchAll($sql,$zipcode);
# $found_rows is an array_ref of hash_refs
Personally, I'd write
$found_rows = $dbh-selectall_arrayref($sql, {
Running the test scripts manually didn't give any more information.
1..14
ok 1
Switch: DBI 1.20 by Tim Bunce, 1.20
Available Drivers: ExampleP, Proxy, Sybase
Segmentation Fault (core dumped)
I found that -ltli was not in EXTRALIBS
# Solaris 2.x needs -ltli
I added it in and now I'm back to
Hello,
i'm trying to call an oracle procedure from a modperl script, which
works somewhat, but I need to get the return value from the procedure.
I followed some hints on websites/mailinglists i searched, but i still
haven't had any luck in succeeding.
This is what I use:
my $func =
34 matches
Mail list logo