Re: apache2, DBD/Oracle problem

2002-08-16 Thread Fredo Sartori
Hi, the problem connecting to an oracle DB through mod_perl is solved: the solution was, to convert the script into a mod_perl handler as it was suggested by Stas. I adopted the code posted by Atsushi Fujita and it worked just perfect for me. So, thank you all for your help. Fredo -- Dr.

Re: apache2, DBD/Oracle problem

2002-08-16 Thread Stas Bekman
Atsushi Fujita wrote: Hi Stas, Can you please try to convert the script into a mod_perl handler and test again? OK, I just checked it. The result was everything fine using by mod_perl handler! There was no problem in my new code. ...But I want to use ModPerl::Registry, because this

Re: apache2, DBD/Oracle problem

2002-08-16 Thread Atsushi Fujita
: apache2, DBD/Oracle problem Atsushi Fujita wrote: Hi Stas, Can you please try to convert the script into a mod_perl handler and test again? OK, I just checked it. The result was everything fine using by mod_perl handler! There was no problem in my new code. ...But I want to use

Re: apache2, DBD/Oracle problem

2002-08-16 Thread Stas Bekman
: [EMAIL PROTECTED] Sent: Friday, August 16, 2002 6:12 PM Subject: Re: apache2, DBD/Oracle problem Atsushi Fujita wrote: Hi Stas, Can you please try to convert the script into a mod_perl handler and test again? OK, I just checked it. The result was everything fine using by mod_perl

apache2, DBD/Oracle problem

2002-08-15 Thread Fredo Sartori
Hi, I have problems connecting to an Oracle-DB through apache2. A test script, that works fine when run directly from the shell, fails to connect to the Orcacle DB, when run through apache. As far as I can see, the SID is not passed to the DB server. . The

Re: apache2, DBD/Oracle problem

2002-08-15 Thread Mike P. Mikhailov
Hello Fredo Sartori, You are connecting to Oracle with service specified in connect string. Does this service resolves correctly with tnsping ? Does this code work correctly as regular perl script ? Thursday, August 15, 2002, 1:44:34 PM, you wrote: FS Hi, FS I have problems connecting to an

Re: apache2, DBD/Oracle problem

2002-08-15 Thread Fredo Sartori
Hello Mike, the code works from the shell as a regular perl script. The service is correctly resolved with tnsping. Fredo Am Don, 2002-08-15 um 10.05 schrieb Mike P. Mikhailov: Hello Fredo Sartori, You are connecting to Oracle with service specified in connect string. Does this service

[OT] Re[2]: apache2, DBD/Oracle problem

2002-08-15 Thread Mike P. Mikhailov
Hello Fredo Sartori, Hmm... It looks like a TNS error. TNS-12505 TNS:listener could not resolve SID given in connect descriptor I think it has nothing to do with mod_perl :( Thursday, August 15, 2002, 3:10:59 PM, you wrote: FS Hello Mike, FS the code works from the shell as a regular perl

Re: [OT] Re[2]: apache2, DBD/Oracle problem

2002-08-15 Thread Fredo Sartori
Hello Mike, of course: the error message of the listener is correct: theres is no SID sent to the DB server. But, if the same script is run from the command line, the SID is transmitted. Fredo Am Don, 2002-08-15 um 11.34 schrieb Mike P. Mikhailov: Hello Fredo Sartori, Hmm... It looks like

Re: apache2, DBD/Oracle problem

2002-08-15 Thread Atsushi Fujita
] To: [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 4:44 PM Subject: apache2, DBD/Oracle problem Hi, I have problems connecting to an Oracle-DB through apache2. A test script, that works fine when run directly from the shell, fails to connect to the Orcacle DB, when run through apache. As far as I

Re: apache2, DBD/Oracle problem

2002-08-15 Thread Lyle Brooks
Sartori [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 4:44 PM Subject: apache2, DBD/Oracle problem Hi, I have problems connecting to an Oracle-DB through apache2. A test script, that works fine when run directly from the shell, fails to connect to the Orcacle DB

Re: apache2, DBD/Oracle problem

2002-08-15 Thread Atsushi Fujita
is working DBD Oracle under mod_perl2? Thank you. Atsushi - Original Message - From: Lyle Brooks [EMAIL PROTECTED] To: Atsushi Fujita [EMAIL PROTECTED] Cc: Fredo Sartori [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 11:07 PM Subject: Re: apache2, DBD/Oracle problem

Re: apache2, DBD/Oracle problem

2002-08-15 Thread Stas Bekman
Atsushi Fujita wrote: Hi Lyle, I does seem to be an ORACLE environment issue. Can you please try to convert the script into a mod_perl handler and test again? I doubt this is registry problem, but probably something that about setting up the env for mod_perl in general. What would help

Re: apache2, DBD/Oracle problem

2002-08-15 Thread Mike P. Mikhailov
Hello Fredo Sartori, Thursday, August 15, 2002, 1:44:34 PM, you wrote: I mabe wrong, but what about to move code to setup ENV out from BEGIN block ? I wrote simple test below: # Test.pm package Test; use Apache::Constants qw ( :common ); BEGIN { $ENV{FOO1} = 'BAR1';

Re: apache2, DBD/Oracle problem

2002-08-15 Thread Stas Bekman
Mike P. Mikhailov wrote: Hello Fredo Sartori, Thursday, August 15, 2002, 1:44:34 PM, you wrote: I mabe wrong, but what about to move code to setup ENV out from BEGIN block ? I wrote simple test below: # Test.pm package Test; use Apache::Constants qw ( :common ); BEGIN {

Re: apache2, DBD/Oracle problem

2002-08-15 Thread Atsushi Fujita
- From: Stas Bekman [EMAIL PROTECTED] To: Atsushi Fujita [EMAIL PROTECTED] Cc: Lyle Brooks [EMAIL PROTECTED]; Fredo Sartori [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, August 16, 2002 11:42 AM Subject: Re: apache2, DBD/Oracle problem Atsushi Fujita wrote: Hi Lyle, I does seem