error in installing DBI module in linux.NEED HELP URGENT

2010-07-08 Thread Scripting Giri
Hi Team Need Your help ASAP.I am getting error while installing the PERL DBI module,as mentioned below === [r...@dba /]# cd /usr/bin/ [r...@dba bin]# cd DBI-1.611 [r...@dba DBI-1.611]# perl Makefile.PL Can't locate Cwd.pm in @INC (@INC contains:

Re: error in installing DBI module in linux.NEED HELP URGENT

2010-07-08 Thread Martin J. Evans
Scripting Giri wrote: Hi Team Need Your help ASAP.I am getting error while installing the PERL DBI module,as mentioned below === [r...@dba /]# cd /usr/bin/ [r...@dba bin]# cd DBI-1.611 [r...@dba DBI-1.611]# perl Makefile.PL Can't locate Cwd.pm in @INC (@INC contains: Perhaps

Re: error in installing DBI module in linux.NEED HELP URGENT

2010-07-08 Thread Clive Eisen
On 08/07/2010 11:18, Martin J. Evans wrote: Scripting Giri wrote: Hi Team Need Your help ASAP.I am getting error while installing the PERL DBI module,as mentioned below === [r...@dba /]# cd /usr/bin/ [r...@dba bin]# cd DBI-1.611 [r...@dba DBI-1.611]# perl Makefile.PL Can't locate

Re: Are MySql passwords sent in the clear?

2010-07-08 Thread Andrew Yancy
Yes, I am only talking about remote connections. This sounds like a great idea Alexander, and it certainly looks doable in PHP: http://themetricsystem.rjmetrics.com/2009/01/06/php-mysql-and-ssh-tunneling-port-forwarding/ Here's hoping that it will be just as easy to do it with Perl and DBI.

Re: error in installing DBI module in linux.NEED HELP URGENT

2010-07-08 Thread John R Pierce
On 07/08/10 1:36 AM, Clive Eisen wrote: On 08/07/2010 11:18, Martin J. Evans wrote: Scripting Giri wrote: Hi Team Need Your help ASAP.I am getting error while installing the PERL DBI module,as mentioned below === [r...@dba /]# cd /usr/bin/ [r...@dba bin]# cd DBI-1.611 [r...@dba

Re: error in installing DBI module in linux.NEED HELP URGENT

2010-07-08 Thread Owen
Hi Team Need Your help ASAP.I am getting error while installing the PERL DBI module,as mentioned below === [r...@dba /]# cd /usr/bin/ [r...@dba bin]# cd DBI-1.611 [r...@dba DBI-1.611]# perl Makefile.PL Can't locate Cwd.pm in @INC (@INC contains: Error messages are meant

Re: Are MySql passwords sent in the clear?

2010-07-08 Thread Andrew Yancy
Thanks for all the replies. From those links, especially http://dev.mysql.com/doc/refman/5.1/en/password-hashing.html I'm getting the pretty clear picture that passwords are never sent in the clear in recent versions of MySql. Still though, I don't know how safe it is to assume that that's

Problem at finding sybase open client library when installing DBD::Sybase

2010-07-08 Thread lippel anna
Hello guys, I am supposed to have the Sybase Open Client library installed in my pc under the folder OCS-12_0. I started the installation of DBD::Sybase with the download provided on CPAN and when I run perl Makefile.PL it tells me Unknown Client Library version - assuming FreeTDS. so

Re: Problem at finding sybase open client library when installing DBD::Sybase

2010-07-08 Thread John R Pierce
On 07/07/10 8:37 AM, lippel anna wrote: Hello guys, I am supposed to have the Sybase Open Client library installed in my pc under the folder OCS-12_0. I started the installation of DBD::Sybase with the download provided on CPAN and when I run perl Makefile.PL it tells me Unknown Client Library

Re: Are MySql passwords sent in the clear?

2010-07-08 Thread Paul DuBois
On Jul 6, 2010, at 1:35 PM, Andrew Yancy wrote: Thanks for all the replies. From those links, especially http://dev.mysql.com/doc/refman/5.1/en/password-hashing.html I'm getting the pretty clear picture that passwords are never sent in the clear in recent versions of MySql. Still

sql*net message from client hang

2010-07-08 Thread Dan
Hello, I have some code that has been running happily for many years, but suddenly started hanging on a simple select query to our Oracle DB. The DB shows it as an inactive session with SQL*NET message from client, so the DB thinks it is waiting for the perl script, but the perl script is hung

RE: sql*net message from client hang

2010-07-08 Thread Howard, Chris
If it always stops at the same place, it makes me think of a resource problem, something like a quota? I don't remember of there are select quotas. Does it do the same if run as sysdba or some other well-endowed database user? -Original Message- From: Dan [mailto:dkele...@gmail.com]

Re: sql*net message from client hang

2010-07-08 Thread Martin Hall
there are various quotas in Oracle that could stop a query. However, they do tend to kill the guilty session rather than just hang like that. If your simple select ran multiple times for the same 10k block, would it still hang? Cheers Martin On 08/07/2010 17:07, Howard, Chris wrote: If

Re: sql*net message from client hang

2010-07-08 Thread Dan
Hello, We do not have any quotas implemented on our Oracle instance. The simple select works fine for that hanging block on sqlplus, or if i only execute it for that block in the perl script instead of iterating through them all. I just tested running for that same block 185 times instead of

Re: sql*net message from client hang

2010-07-08 Thread John Scoles
Hmm DBI 0.67 that is old and the fact you get the same error with the latest DBI and DBD::Oracle would lead me to think there may be something wrong internally in your DB or its storage medium, corrupt block perhaps or bad sector?? The code differences between 1.61 and 0.67 are vast as would be

Re: sql*net message from client hang

2010-07-08 Thread John Scoles
The $dbh-{RowCacheSize} = -1; is funny as you are telling the box to only use 1 byte for RowCach Try it with '0' and see what happens? On Thu, Jul 8, 2010 at 7:20 PM, John Scoles sco...@pythian.com wrote: Hmm DBI 0.67 that is old and the fact you get the same error with the latest DBI and