Re: Script Running well as Root user but not as Apache user ?

2002-11-05 Thread Michael A Chase
On Wed, 06 Nov 2002 14:19:18 +0800 Armand Brisson <[EMAIL PROTECTED]> wrote: > I already have set httpd.conf with the environment variable. > > Problem occurs even if i just run the script as apache or other users > work only in root or oracle users > > Michael A Chase wrote: > >> http://xmlpro

Re: Script Running well as Root user but not as Apache user ?

2002-11-05 Thread Michael A Chase
http://xmlproj.com/fom-serve/cache/20.html http://xmlproj.com/fom-serve/cache/5.html http://xmlproj.com/fom-serve/cache/96.html Setting LD_LIBRARY_PATH after perl has started probably has no effect. It needs to be set in the webserver's environment. -- Mac :}) ** I normally forward private quest

Script Running well as Root user but not as Apache user ?

2002-11-05 Thread Armand Brisson
Ok let me give you more information 1) here is the output of the perl -V command: Summary of my perl5 (revision 5.0 version 8 subversion 0) configuration: Platform: osname=linux, osvers=2.4.18-17.7

Re: use DBD::Oracle qw(:ora_types); - from cron

2002-11-05 Thread Darin McBride
On November 5, 2002 04:41 pm, you wrote: > When I need to have a "use DBD::Oracle qw(:ora_types);" in my program, and > I am running from cron, I get a message like: > > Can't load '/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle:' > at the use DBD::Oracle line. > > Other programs that just have

use DBD::Oracle qw(:ora_types); - from cron

2002-11-05 Thread Fox, Michael
When I need to have a "use DBD::Oracle qw(:ora_types);" in my program, and I am running from cron, I get a message like: Can't load '/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle:' at the use DBD::Oracle line. Other programs that just have a 'use DBI' are fine. The normal program structure

Re: Error Sybase

2002-11-05 Thread Michael Peppler
On Tue, 2002-11-05 at 13:46, Anderson A. M. Neitzke wrote: > Help!!! > > perl: error while loading shared libraries: > /usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBD/Sybase/Sybase.so: > undefined symbol: cs_ctx_global. Good thing that I know what you are talking about, because you don't give

FW: :Oracle install snag on Compaq Tru64 (9i) [SUCCESS!!]

2002-11-05 Thread Rose, Bill
I was able to get passed the problems, once the Oracle instance was put into the tsnames.ora, and I connected - using my ID. The LIBCLNTSH option on my 'perl Makefile.pl' statement was really the breakthrough. Thanks to all who responded. -Original Message- From: Rose, Bill Sent: Tu

Error Sybase

2002-11-05 Thread Anderson A. M. Neitzke
Help!!! perl: error while loading shared libraries: /usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBD/Sybase/Sybase.so: undefined symbol: cs_ctx_global. Thanks, Anderson

FW: :Oracle install snag on Compaq Tru64 (9i) [BREAKTHROUGH]

2002-11-05 Thread Rose, Bill
Thunder - one of my team members had access to another Oracle instance that WAS in the tnsnames.ora file on my box. We ran the 'test_connect_pgm' and got the SAME ERROR as the *.t test modules experienced during the 'make test' runs. The test_connect_pgm" does a [$dbh = DBI->connect("DBI:Oracle:$

DBD::MySQL in cygwin

2002-11-05 Thread Gowri PV
Hi, Probably this question was asked earlier. How do I install DBD::MySQL in cygwin? I installed MySQL for Windows. I have installed DBI. I can start MySQL server from cygwin and connect to it. I can see and query the database using the mysql client. But I cannot insatll DBD::mysql. If

RE: DBD::Informix Install Problem on HP-UX 11.00 & INFORMIX-ESQL Version 9.51.HC3

2002-11-05 Thread Gelbolingo, Arlene - MLG
Thanks, Jonathan. I did install it and everything seems to be working fine. Also, one of our developers ran the *.t files outside of the TestHarness.pm module and everything ran smoothly. Thanks for all your help! -Original Message- From: Jonathan Leffler [mailto:jleffler@;us.ibm.com] S

Re: DBD::Informix Install Problem on HP-UX 11.00 & INFORMIX-ESQL Version 9.51.HC3

2002-11-05 Thread Jonathan Leffler
Dear Arlene, I've confirmed to my own satisfaction that the problem occurs when DBDATE is set to a non-default value such as "Y4MD-" when the server is booted, and no value is set for DBDATE in the client environment. This is a legitimate setup (though not one I particularly recommend), so I nee

Re: encoding

2002-11-05 Thread dams
"Gaul, Ken" <[EMAIL PROTECTED]> said: > Set your NLS_LANG environement variable before execution of your script and > it should work as expected. thanks I'll try that ! -- ~/.signature

RE: encoding

2002-11-05 Thread Gaul, Ken
Set your NLS_LANG environement variable before execution of your script and it should work as expected. Ken. -Original Message- From: [EMAIL PROTECTED] [mailto:dams@;idm.fr] Sent: 05 November 2002 16:07 To: [EMAIL PROTECTED] Subject: encoding Hi, I'm new to this list, so hello everyone

Problems setting up a DBI Proxy

2002-11-05 Thread Tom Cross
On Sun, 2002-10-27 at 07:58, Jeff Urlwin wrote: > Roger, > > First -- please *always* keep the dbi-users mailing list copied on e-mails. > Sending messages just to me won't help others and, in fact, can delay the > response you get as others are helpful... > > Well, 0.28 is *not* the latest, but

Postgresql driver segfault when trace is activated

2002-11-05 Thread Guillaume Rousse
The following sniplet segfault when trace is activated: #!/usr/bin/perl use DBI; my $dbh = DBI->connect("DBI:Pg:dbname=olacacea;host=localhost;port=5432", guillaume) or die("Can't connect: $DBI::errstr"); $dbh->trace(1); without trace: [guillaume@baader db]$ ./testcase Database handle destroyed

encoding

2002-11-05 Thread dams
Hi, I'm new to this list, so hello everyone, and sorry if I ask already answered questions. My pb is that I have an oracle database with datas encoded in iso-latin15 and when I use DBI::Oracle to retreive them, they are encoded in ascii or some primitive encoding, (without accents, and so). I re

Re: FW: [cpan #1764] AutoReply: Throwing an DBI::st exception fails u sing DBD::Oracle

2002-11-05 Thread David Wheeler
On Tuesday, November 5, 2002, at 06:20 AM, James.FitzGibbon wrote: The error that comes back to the application is a plain string rather than an object, and the string contains information about why the exception-throwing mechanism failed, not about the event which caused the exception-throwin

Re: SQL question

2002-11-05 Thread Michael A Chase
On Tue, 05 Nov 2002 08:56:25 -0500 Brad Smith <[EMAIL PROTECTED]> wrote: > I want to run a query that will perform a phrase search on all fields in > the table. I thought that it seemed really logical to write the > statement > like: > > my $dbh = DBI->connect('dbi:ODBC:database_name') || die

RE: SQL question

2002-11-05 Thread Mark Thornber
or, alternatively, you can write SQL to read the system catalogue and output _more_ SQL to do the search required. In one extreme case I ended up with a cascade of three queries - mete-meta-query -> meta-query -> query -> result set. The advantage is one can build up the steps one at a time a

Re: DBD-Oracle install

2002-11-05 Thread Jeremiah McElroy
the output of make test, without LD_PRELOAD follows: cpacnm - op08 - /home/cpacnm/.cpan/build/DBD-Oracle-1.12> make test PERL_DL_NONLAZY=1 /home/cpacnm/Qwest/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t t/base.../usr/lib/dld.sl: Can't shl_load() a l

FW: [cpan #1764] AutoReply: Throwing an DBI::st exception fails u sing DBD::Oracle

2002-11-05 Thread James.FitzGibbon
This is a copy of a bug I just reported to the author of Exception::Class::DBI. I've forwarded it here because having gone through some preliminary analysis, I'm not sure if the cause of the problem lies with Exception::Class::DBI or with DBI or DBD::Oracle. Read further down for the specifics, b

DBD-Oracle install

2002-11-05 Thread Jeremiah McElroy
I'm attempting to install DBD-Oracle 1.12 with DBI 1.3 (perl 5.8.0) on HP-UX 11.0. Upon running make test I receive the following error: cpacnm - op08 - /home/cpacnm/.cpan/build/DBD-Oracle-1.12> LD_PRELOAD=/Oracle/product/32bit/8.1.7.

RE: SQL question

2002-11-05 Thread Herbold, John W.
I have done something like that. I used two connections to the database. The first "outer" connection retrieved the column names from the system table. On DB2 this was Select name from sysibm.syscolumns where tbname = 'favorate_table'; Then using Perl I made the calls to the table looking for the

SQL question

2002-11-05 Thread Brad Smith
I want to run a query that will perform a phrase search on all fields in the table. I thought that it seemed really logical to write the statement like: my $dbh = DBI->connect('dbi:ODBC:database_name') || die DBI::errstr; my $sth = $dbh->prepare("SELECT * FROM table_nam

Re: Script Running well as Root user but not as Apache user ?

2002-11-05 Thread Armand Brisson
Thank you! I already had set variables in my hhtpd.conf (Virtual hosts directive) without any success and this is why i am trying to debug as typing script from a Unix users. I can loog as Root and run my script that connect to remote Oracle smoothly and properly I can log as Oracle and run my