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.
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
: 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
: [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
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
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
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
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
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
]
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
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
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
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
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';
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 {
-
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
16 matches
Mail list logo