pb setting NLS_LANG with mod_perl 1.99_14et DBD::Oracle

2004-10-26 Thread Jean-Paul COGNET
A problem with mod_perl 1.99 et DBD::Oracle.   I cannot set the value of NLS_LANG   If I set it to any value different from '' then I cannot connect, having this log in Apache :[Tue Oct 26 12:48:30 2004] [notice] Apache/2.0.47 (Fedora) configured -- resuming normal operationsDBI connect('TOP

Re: pb setting NLS_LANG with mod_perl 1.99_14et DBD::Oracle

2004-10-26 Thread Arnaud Blancher
Jean-Paul COGNET wrote: A problem with mod_perl 1.99 et DBD::Oracle. do you read this ? http://perl.apache.org/docs/2.0/user/troubleshooting/troubleshooting.html#C_Libraries_Don_t_See_C__ENV__Entries_Set_by_Perl_Code Arnaud I cannot set the value of NLS_LANG If I set it to any value different f

Re: pb setting NLS_LANG with mod_perl 1.99_14et DBD::Oracle

2004-10-26 Thread Jean-Paul COGNET
Yes. I've read this, and I use a startup.pl script to set ENV when Apache starts, and it works fine for ORACLE_HOME. It works if I don't try to set NLS_LANG. The problem is that if NLS_LANG is set properly I can't connect with this strange message in Apache's logs about 'quoted string not properly

Apache::DBI, Postgresql, and transactions

2004-10-26 Thread Brian Dimeler
Hi, I've been converting some old CGI scripts for use with mod_perl and Apache::DBI. These scripts access a Postgres database through DBI. I didn't have any trouble until I began writing a new script which in the development phase has generated a few bad SQL commands (my fault, not the problem

Re: Apache::DBI, Postgresql, and transactions

2004-10-26 Thread Joe Thomas
Brian Dimeler wrote: So anyway, I recompiled mod_perl to ensure these kinds of handlers were enabled, restarted the server with $Apache::DBI::DEBUG set to 2, and sure enough, I started getting debug messages about rollbacks after each script finished executing. Problem is.. they stopped, after

Re: Apache::DBI, Postgresql, and transactions

2004-10-26 Thread Brian Dimeler
Thanks for the suggestion, but it's the same connection with the same params every time. The connection code is actually in a Class::DBI module, which gets use()'d by all of my scripts. This module isn't in my startup script, so that each process keeps its own copy. So there are multiple handle

Re: Apache::DBI, Postgresql, and transactions

2004-10-26 Thread Perrin Harkins
On Tue, 2004-10-26 at 15:52, Brian Dimeler wrote: > The connection code is actually in a Class::DBI > module, which gets use()'d by all of my scripts. Bingo, that's the problem. Class::DBI uses Ima::DBI, which does not play well with Apache::DBI. It keeps its own connection cache in closures an

Can't locate ../Functions/db.pl in @INC

2004-10-26 Thread mahboobeh soleimani
Hi every body. I have a apache 1.3.31 and mod_perl 1.28 and used SetHandler perl-script PerlHandler Apache::PerlRun PerlSendHeader On in http.conf but when i enter: perl /root/prelude/piwi/test/index.pl i can see this error : Can't locate ../Functions/db.pl in @IN