Re: [EXT] Issues connecting to an Amazon RDS instance: creating the database handle is taking a VERY long time

Have you checked *reverse* dns on the ip - 60 of the 61 seconds sound like dns timeout. > On 4 Apr 2025, at 20:56, Johnson, Bruce E - (bjohnson) > wrote: > > > >> On Mar 31, 2025, at 4:20 PM, Johnson, Bruce E - (bjohnson) >> wrote: >> >> Sadly no. It’s still instantaneous on-prem but take

Re: Oracle connection error

dnf install libnsl.x86_64 > On 12 Jan 2023, at 14:25, Syed Abdulla wrote: > > Hi, > > While installing Perl DBI module to connect to Oracle 19c on RedHat 8 VM, I > see the below error and the installation fails. > > /usr/bin/ld: cannot find -lnsl > collect2: error: ld returned 1 exit status >

Re: perl issue

yum whatprovides */Pg.so yeilds perl-DBD-Pg > On 9 Jun 2019, at 20:42, Jens Rehsack wrote: > > Where does the /usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so come from (rpm > -q...) > >> Am 08.06.2019 um 03:17 schrieb Zhang Jun > >: >> >> /usr/lib64/perl5/vendor_per

Re: Tail Module + DBI Module, can't keep up!

On 15/09/2011 14:43, Brandon Phelps wrote: Has anyone ever dealt with an issue like this and have any idea how I might rework the script and/or application to avoid this delay, which will obviously get worse and worse as time goes on? IMHO it's much more likely to be mysqld itself get http://

Re: Apache:DBI DBD::Informix and dbping

On 01/09/2011 12:16, John R Pierce wrote: On 09/01/11 2:10 AM, Clive Eisen wrote: What 'simple' piece of sql do the team suggest? select 1 from systables where tabid =1 why not just SELECT TRUE; ? because that is not valid sql unless you are using a toy database

Apache:DBI DBD::Informix and dbping

I'm using mod_perl and Informix, and therefore Apache::DBI and DBD::Informix It seems I am running into stale database handles That is to say a connect in my code 'works' but any operation on the dbh fails with a can't call method 'blah' on an undefined value after a time. Reading http:/

DBD::Informix -1820

I'm using DBD::Informix and mod_perl and was having a problem with a -1820 error (-1820: Host variable type has been changed between fetches or puts) hitting a particular query on a second or subsequent execute of a prepared statement. So I decided to check the DBD build and running the make t

Re: Database creation time with DBI and the SQLite DBD

On 05/12/2010 10:52, Owen wrote: I have 445, 6 element csv files, about 35 lines in all. I only have one machine, but a number of Linux OS. These csv files are parsed, the data checked for purity and then placed in an sqlite file. On one OS, this takes 30-35 minutes, on several other opera

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

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 Cw

Re: DBD::Informix on OSX

Clive Eisen wrote: Has anyone successfully built a 64 bit perl on OSX? I've tried and I get just over 1000 errors on make test - all relate to loading XS stuff and getting a wrong architecture error. All I did (to be fair) was ./Configure -Dcc='cc -m64' -des make && m

DBD::Informix on OSX

Has anyone successfully built a 64 bit perl on OSX? I've tried and I get just over 1000 errors on make test - all relate to loading XS stuff and getting a wrong architecture error. All I did (to be fair) was ./Configure -Dcc='cc -m64' -des make && make test If anyone has the magic incantation

Redhat/Centos users

If you use either with DBI (or indeed just with perl) I suggest you read this. http://weblog.infoworld.com/fatalexception/archives/2008/08/bitten_by_the_r.html -- Clive

Re: int8 Informix and 64bit perl

Jonathan Leffler wrote: > On 9/27/07, Clive Eisen <[EMAIL PROTECTED]> wrote: >> Jonathan Leffler wrote: >>> On 9/27/07, Clive Eisen <[EMAIL PROTECTED]> wrote: >>>> I seem to have a problem with negative int8 on a 64 bit linux platform >>>> &g

Re: int8 Informix and 64bit perl

Jonathan Leffler wrote: > On 9/27/07, Clive Eisen <[EMAIL PROTECTED]> wrote: >> I seem to have a problem with negative int8 on a 64 bit linux platform >> >> dbaccess gives the correct answer but DBD::Informix does not >> >> [EMAIL PROTECTED]:~> oninit

int8 Informix and 64bit perl

I seem to have a problem with negative int8 on a 64 bit linux platform dbaccess gives the correct answer but DBD::Informix does not [EMAIL PROTECTED]:~> oninit -V IBM Informix Dynamic Server Version 10.00.FC6 [EMAIL PROTECTED]:~> esql -V IBM Informix CSDK Version 2.90, IBM Informix-ESQL Version

Re: looks like one database from the outside, but it's two inside

Sven Miller wrote: > And unfortunately I don't know enough about MySQL to be more helpful. > Database links may be an Oracle-only thing. > > On 7/19/07, Theron Stanford <[EMAIL PROTECTED]> wrote: >> This sounds like a good idea. I guess I just don't know enough about >> databases yet to know how

Re: Can't locate loadable object for module DBI in

Sunil A V wrote: > Hi, > > I have a properly installed and working DBI/DBD::Oracle on Sun Solaris Unix > box 'A'. While installing this, I had used INSTALLIBDIR option which > created > all my lib and DBI.pm and DBD.pm in the directory I mentioned. I have > working perl programs using these DBI/DB

Re: Named pipe

Loo, Peter # PHX wrote: Hi All, I was wondering if anyone might have an answer as to how I can sync the start up of the write and INSERT INTO at the same time or perhaps some other method. named pipe - good idea - on nfs - bad idea take a look at netcat, socat, tcpclient & tcpserver a

Re: A common perl script for different database platforms

Hetal Soni wrote: Thanks for your input guys. I removed both "use:DBD::Oralce" and "use"DBD:DB2" lines and now getting following error: Can't locate object method "connect" via package "DBI" (perhaps you forgot to lo ad "DBI"?) at tmp1.plx line 58. you do have use DBI; in your program?

Re: PostgreSQL trouble

Christian Stalp wrote: Have you got tcpip_socket = true in postgresql.conf? Yea, exactly. This is funny. I allready tried this. See: venus:/home/chris# pg_ctlcluster 8.1 main restart The PostgreSQL server failed to start. Please check the log output: FATAL: unbekannter Konfigurationsp

Re: PostgreSQL trouble

Christian Stalp wrote: The whole script: #!/usr/bin/perl use warnings; use strict; use DBI; #my $dbh = DBI->connect ("DBI:Pg:dbname=test2", "postgres", "sonderbar") #my $dbh = DBI->connect ("DBI:Pg:dbname=test2", *host="localhost" ) # or die "Keine Verbindung mit der DB!\n"; my $dbh = DBI-

Re: regarding DBI

prashanth wrote: hi i want to write an interface (a very simple one) similar to the DBI. could any one give me some suggestions or give relevent pointers regarding the same. i couldnt get any pointers on the internal architecture or philosophy of the DBI...thank you. You want us to do

Re: Parsing question...

Just goes to prove that one should always look on CPAN before writing almost anything .. NIPP, SCOTT V (SBCSI) wrote: The suggestion of using Text::CSV_XS was the winner. This is a very simple module to use. Thanks for the feedback though.

Re: Large SQL statements...

NIPP, SCOTT V (SBCSI) wrote: I have a table with 22 columns, and my INSERT on this table is actually putting in data to possibly all 22 fields. My question is, is there a better way to write this INSERT? Here's what I have: while ($line = ) { $csv->parse($line); @data = $csv->fields; $

Re: moving Perl::DBI to a Solaris 2.8 machine without a compiler

Bruce Shaw wrote: For reasons beyond my control, I need to use Perl version 5.8.2 DBI-1.39 DBD-Oracle-1.14 TermReadKey-2.21 together on a machine lacking a compiler. I have compiled everything successfully on a different, pretty-much-identical machine and got Perl moved over successfully. Howev

Re: Basic symlink question...

NIPP, SCOTT V (SBCSI) wrote: I know this is not the correct forum for this question, but I figure someone will know easily enough... I am attempting to use the Perl symlink command to create/update a link on the Unix server. Below is the syntax I am using, and not having any luck with.