Hi,
I added the code folow in the config file, but the Apache ::DBI
module continue don't working. If I don't load the Apache::DBI module,
the apache works correctly. Using only the DBI and DBD::Oracle modules,
I can access the Oracle database no problems. Really the problem must
to have such data field in object:
$person={
name='Jack',
age=10,
...,
$dbh=...
}
$dbh have no relation to information about Jack.
Is there any better solution?
There is some piece of code
---
mainscript.pl
my $dsn = "DBI:$config{'driver'}:database=$config{'dbname'};"
On Tue, 21 Nov 2000, Ilya Soldatkin wrote:
I am creating an object that make queries to database. But how shall I
explain to him what database handler he shall use?
Under mod_perl it is too dangerous to make $dbh global variable.
Well, I can create data field in this object that will store
Hi Ilya,
IS I am creating an object that make queries to database. But how shall I
IS explain to him what database handler he shall use?
IS Under mod_perl it is too dangerous to make $dbh global variable.
IS Well, I can create data field in this object that will store current $dbh,
IS but it
,
but it seems too strange too me to have such data field in object:
$person={
name='Jack',
age=10,
...,
$dbh=...
}
$dbh have no relation to information about Jack.
Is there any better solution?
There is some piece of code
---
mainscript.pl
my $dsn = &quo
Hi,
recently there was a large thread on connection pooling. One idea was to use
DBI::ProxyServer for this purpose. This may not fit all needs, but some
them, at least mine :-)
The idea is to use DBI's connect_cached method together with ProxyServer. As
in the above mentioned thread already
Hi, Gerald,
to be honest, I don't understand the details of your patch.
I understand that you fork off some child processes and
and use connect_cached. But how do the different processes
interact? How do you guarantee, that the data from one
client reaches the right server process?
I can only
connection to the database and if a client comes
to a server process which already has opened the connection to the requested
database, the server childs process doesn't need to connect anymore. It's
similiar as with Apache and using Apache::DBI under mod_perl. By defining
the number of childs you
scripts access a PostgreSQL database. When I moved my mod_perl
configuration to two virtual servers (one ssl on port 443, one not on port
80), somehow Apache::DBI kept connections open but was not reusing them, and
over 10 or so requests, PostgreSQL would start refusing connections (and
mod_perl
Hey Friends,
I have two ORACLE_HOME directories in my client
machine (7.2.2 and 8.0.5). When I set ENV to 8.0.5 or
7.2.2, this seems there no effect. Also when I use the
connection like this :
$dbh = DBI-connect("DBI:Oracle:$sid", "$username",
"$password",
{
21:45:33 2000] null: Can't
locate object method "selectrow_array" via package "GodZoneSSI" at
/usr/local/godzone/modperl/GodZoneSSI.pm line 27, GEN0 chunk 1.
The DBI-connect would appear to work, but perl complains it ca
21:45:33 2000] null: Can't
locate object method "selectrow_array" via package "GodZoneSSI" at
/usr/local/godzone/modperl/GodZoneSSI.pm line 27, GEN0 chunk 1.
The DBI-connect would appear to work, but perl complains it ca
Derrr...
Dumb error, never trust a cut and paste. I copied in one two many lines from
the original program.
I'm considering using Apache::DBI but before I'd want to benchmark to
see
if I gain anything. To do this I just made a script that
connects/disconnects
10 times. Then I tried running ab with -n 1. The output confused me
a bit
there where only 0.9 secs difference, and it was good old DBI who
Hi there,
On Mon, 13 Nov 2000, Jon Molin wrote:
I'm considering using Apache::DBI but before I'd want to benchmark
to see if I gain anything. To do this I just made a script that
connects/disconnects 10 times.
You'd better read the Guide.
http://perl.apache.org/guide
The whole point
$Apache::DBI::VERSION = '0.87';
s/AuthDBI::DEBUG/DBI::DEBUG/;
--- Apache/DBI.pm.orig Thu Nov 9 17:46:43 2000
+++ Apache/DBI.pm Thu Nov 9 17:47:16 2000
@@ -343,7 +343,7 @@
For the menu item 'DBI connections' you need to call Apache::Status
BEFORE
Apache::DBI ! For an example
Hi,
I am hoping that I have joined the right group for these questions,
so before I go straight into my question, I'll outline the problem
that I am working on at the moment. Then I can get shot down if I'm
in the wrong place ;0
I am currently working on some DBI, in particular Auth, Authen
working on some DBI, in particular Auth, Authen, Authz
for Authorisation of users on an Apache web server with mySQL database.
Try CPAN:
Apache::AuthDBI
Is pretty configurable, works with mySQL. There are some others as well...
Am I looking in the right place? I just don't seem to be able to find
"Tamas" [EMAIL PROTECTED] writes:
Am I looking in the right place? I just don't seem to be able to find
the right docs in Perldoc or Apache or perl.apache.org.
Only if your issue is mod_perl related... ;-)
--
Dave Hodgkinson, http://www.hodgkinson.org
in the logs is:
[error] Can't locate object method "populate" via package
"Apache::Session::DBI" at
/usr/lib/perl5/site_perl/5.005/Apache/Session.pm line 368.
Alberto.
I've got a system running the following:
Perl version v5.6.0 for Apache/1.3.12 (Unix) mod_perl/1.24 mod_ssl/2.6.6
OpenSSL/0.9.5a
If I run the cgi scripts from command line they connect to the oracle
database just fine.
If I run them under the webserver (apache::registry), the cannot connect to
the
problem?
I suggest asking on the dbi-users list (archive
at http://www.xray.mpe.mpg.de/mailing-lists/dbi/ )
and submitting there a trace of 2 or higher (perldoc DBI)
the
following in my modules:
sub get_database_handle
{
my ($db_user, $db_pass, $ora_home, $ora_sid) = get_userpass();
$ENV{ORACLE_HOME} = $ora_home;
$ENV{ORACLE_SID} = $ora_sid;
my $dbh = DBI-connect("dbi:Oracle:", $db_user, $db_pass,
{ RaiseError = 1, Auto
]
In the middle of difficulty lies opportunity. - Albert Einstein
"HotMail: Bill" [EMAIL PROTECTED] on 10/26/2000 11:28:53 AM
To: [EMAIL PROTECTED]
cc:
Subject: problem connecting to oracle with DBD-Oracle-1.06/DBI-1.14 with
Perl version v5.6.0 for Apache/1.3.12 (Unix) mod
Oops correction to below: should read ORA-12154
ORA-12154 (DBD ERROR: OCIServerAttach)
- Original Message -
From: "HotMail: Bill" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, October 27, 2000 12:28 AM
Subject: problem connecting to oracle with DBD-Oracle-1.06/DBI-1.14
redhat linux 6.2
- Original Message -
From: "Richard Routh/Tampa/IBM" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, October 27, 2000 12:47 AM
Subject: Re: problem connecting to oracle with DBD-Oracle-1.06/DBI-1.14 with
Perl version v5.6.0 for Apache/1.3.12 (Unix) mod
to oracle with DBD-Oracle-1.06/DBI-1.14
with
Perl version v5.6.0 for Apache/1.3.12 (Unix) mod_perl/1.24
mod_ssl/2.6.6
OpenSSL/0.9.5a
I've got a system running the following:
Perl version v5.6.0 for Apache/1.3.12 (Unix) mod_perl/1.24
mod_ssl/2.6.6
OpenSSL/0.9.5a
If I run the cgi scripts from
connecting to oracle
with DBD-Oracle-1.06/DBI-1.14 with Perl version v5.6.0 for Apache/1.3.12
(Unix) mod_perl/1.24 mod_ssl/2.6.6 OpenSSL/0.9.5a
I had a
problem connectingto DB using CGI scripts, but it was working fine manual
connections. So we had to add line $ORACLE_HOME/lib
Hi!
I get this message in my error_log with using Apache::Session::DBI:
[Wed Oct 25 17:37:24 2000] [error] Can't locate object method "populate"
via package "Apache::Session::DBI" at
/usr/lib/perl5/site_perl/5.005/Apache/Session.pm line 368.
This occurs after I execu
Hi there,
On Wed, 25 Oct 2000, Alberto Mateos wrote:
I've re-installed apache and mod_perl but apache don't works
(Interval server error).
That's "InterNal server error" and it probably means Apache is working
fine, but your Perl/DBI stuff has a problem.
I'd remove the DBI stuf
,
Francois
error while executing /../components/loginchecknoform:
DBI-gt;connect failed: OpenClient message: LAYER = (5) ORIGIN = (3)
SEVERITY
(5) NUMBER = (6)
Message String: ct_connect(): network packet layer: internal net library
erro
Net-Library operation terminated due to disconnect
at /home
-Original Message-
From: cbell [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 18, 2000 3:00 PM
To: [EMAIL PROTECTED]
Subject: Mod_perl, DBI, and Postgres install procedures...
Does anyone have a set of procedures to install Mod_perl, Apache,
Postgres, DBI, DBI.pm
Does anyone have a set of procedures to install Mod_perl, Apache,
Postgres, DBI, DBI.pm, and anything
else needed to make Modperl talk to a postgres database. I'm new to
Linux and Mod_perl, and I've
followed all the setup procedures I can find to do this, but I still
cannot get a database
#
/PRE
Here is AuthSurvey.pm:
PRE
package AuthSurvey;
# authenticate users into the survey directory on the web server
use strict;
use Apache::Constants ':common';
use DBI;
sub handler {
my $r = shift;
my($res, $sent_pwd) = $r-get_basic_auth_pw();
return
Hi,
I've been having a problem using any Database with mod_perl. This
problem has persisted across two separate platforms. I found it
initially whilst working on one contract, and it has popped up again on
a new contract.
Firstly, the initial setup. I was using DBI with MySQL - and I had
- Original Message -
From: "Rajit Singh" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, October 16, 2000 8:58 AM
Subject: DBI/PostgreSQL/MySQL mod_perl intermittent problem
I should probably note that I've used Apache::DBI on and off to see if
it makes any differ
: Tulpenstrasse 5 D-55276 Dienheim b. Mainz
E-Mail: [EMAIL PROTECTED] Voice:+49 6133 925151
WWW:http://www.ecos.de Fax: +49 6133 925152
-
Firstly, the initial setup. I was using DBI with MySQL - and I
Hi Ken,
There is neither any error message generated in the error_log neither on linux prompt.
Thanks for writing,
Pritesh.
On Friday, October 13, 2000 at 01:30:50 AM, Ken Williams wrote:
[EMAIL PROTECTED] (Pritesh Thakor) wrote:
I installed Apache::DBI-0.87 on Apache 1.3.9
Hi,
I installed Apache::DBI-0.87 on Apache 1.3.9, Perl 5.00503, mod_perl 1.2.1 running on
RedHat Linux 6.1 and I am trying to connect to MySQL 3.22.32. After making necessary
changes in httpd.conf i.e. PerlModule Apache::DBI and giving the command
/etc/rc.d/init.d/httpd restart
[EMAIL PROTECTED] (Pritesh Thakor) wrote:
I installed Apache::DBI-0.87 on Apache 1.3.9, Perl 5.00503, mod_perl
1.2.1 running on RedHat Linux 6.1 and I am trying to connect to MySQL
3.22.32. After making necessary changes in httpd.conf i.e. PerlModule
Apache::DBI and giving the command
/etc/rc.d
at happens. BTW, only run the daemon in the
foreground for debugging purposes. Run in the foreground it forks off
no copies of itself.
-- Rob
--On 10/12/00 11:36:33 PM -0700 Pritesh Thakor [EMAIL PROTECTED]
wrote:
Hi,
I installed Apache::DBI-0.87 on Apache 1.3.9, Perl 5.00503, mod_perl
1.2
It has promise but needs someone to polish it up.
(I didn't write it and have barely looked at the code.)
Tim.
On Tue, Sep 19, 2000 at 12:50:57PM -0700, Tom Lancaster wrote:
I know, seems promising, doesn't it, especially after the overview in
the DBI book. On the other hand, you can do most
On Wed, 20 Sep 2000 [EMAIL PROTECTED] wrote:
PerlFreshRestartOn
try turning that Off. does DBI/DBD::mysql work for you without
Tie::DBI?
Slightly off topic but I think interesting. If this have been covered
sometime before about 4 months ago please point me there.
I've taken on the support of a website that was designed as a student
project. To make them feel warm and fuzzy the site was done using Windows
NT, MS IIS, SQL Server
in the httpd.conf file.
I have a feeling that the bug only exists with DSO's.
redhat used to ship a mod_perl dso rpm older than mod_perl-1.22, not sure
what versions of things they're at now.
1.22 fixed a but a bug related to pre-loading xs modules, e.g. DBI.
that the bug only exists with DSO's.
Dick
Dick et al.
Sorry for the longish multi-quoted post but I wanted to just say for anyone
interested that
1) Dick is not the only one having this problem,
2) Many search results on geocrawler for DBI and segfault or SEGV or SIGSEGV
or
"core
Dick et al.
Sorry for the longish multi-quoted post but I wanted to just say for anyone
interested that
1) Dick is not the only one having this problem,
2) Many search results on geocrawler for DBI and segfault or SEGV or SIGSEGV
or
"core dump" show that the problem is wides
Please forgive what may be an often encountered problem, but
I haven't found anything helpful in the archive or other online sources.
I am encountering a problem that I can't figure out when trying to access
a Mysql database from with mod_perl using Tie::DBI. I am having
similar problems when
Hi All
I'm thinking of restructuring my setup so that I have my apache/mod_perl
servers access database servers remotely using DBI::Proxy, rather than
locally. Does anyone have a sense of what kind of performance degradation I
should expect? Will it come chiefly from network latency (leaving
My experience of using DBI::Proxy several months ago is that it's
terribly slow, and breaks all the time.
It's not meant to be used in a production environment ( and that's
according to the authors ).
I managed to get it running, on linux and NT, but due to the lack of a
working fork
I know, seems promising, doesn't it, especially after the overview in
the DBI book. On the other hand, you can do most things another way -
SSH port forwarding for encrypted data transmission, straight DBI/DBD
available for most dbs, etc.
Bill McCabe wrote:
That's a shame. I can see good use
I am running Apache/1.3.9 (Unix) (Red Hat/Linux 6.2) and DBI-1.14.
When I include a "use DBI" in the startup.pl file, Apache code dumps.
A "use DBI" in cgi scripts works OK. However, as I need to pre-load a
few arrays with data to be shared by the child pro
This * should * work and should not cause a core dump.
That said, you should take a look at the O'Rielly DBI book. There are a
ton of error conditions that you're not checking here.
Best to turn on RaiseError and then wrap all subsequent code in an eval
block. Your code will be cleaner
Apache::DBI overrides DBI in the creation of a connection to the
database in order to cache the connection. So the connections you created
below are seen as the same by Apache::DBI and when you change one you
change the other since the connection is comming from the same persistent
pool. Try
Hi,
I am using Apache::DBI for user authentication
and it works just fine with one exception,
it does not kill the sql backend server process starting up during authentication,
so after some time postgres is running out of allowed backend server
processes and authentication does not work
On Tue, 12 Sep 2000, Evelin Halling wrote:
I am using Apache::DBI for user authentication and it works just fine
with one exception, it does not kill the sql backend server process
starting up during authentication, so after some time postgres is
running out of allowed backend server
Hi all,
I got the following weird problem about DBI in mod_perl.
Just a simple script which can run in the "cgi-bin",but failed in the mod_perl.
When I check the error_log, I find the message:
[Tue Sep 12 12:01:59 2000] [notice] child pid 1273 exit signal Segmentation fault (11)
My
On Thu, Sep 07, 2000 at 11:06:00AM -0700, Perrin Harkins wrote:
On Thu, 7 Sep 2000, Nicolas MONNET wrote:
|Well, Apache::DBI does push a cleanup handler that does a rollback if
|auto-commit is off. Are you saying this isn't working?
I've run into a situation where it was'nt. I wanted
On Fri, 8 Sep 2000, Honza Pazdziora wrote:
|The code
|
|my $needCleanup = ($Idx =~ /AutoCommit[^\d]+0/) ? 1 : 0;
|if(!$Rollback{$Idx} and $needCleanup and Apache-can('push_handlers')) {
|print STDERR "$prefix push PerlCleanupHandler \n" if $Apache::DBI::DEBUG 1;
|
Yes, I ran into this while I was making a version of Apache::DBI which uses
'reauthenticate' to maintain a single connection per Apache child (per
database) and simply reauthenticate on that connection. It turned out that
I modified what $Idx was composed of and didn't understand why I
Hi there,
I might get something wrong, but while in non-autocommit, if a script dies
before rollbacking or commiting, looks like the transaction never gets
cancelled until I kill -HUP httpd! Quite a problem ...
Is there any known way to catch this?
to catch this?
Looking at the code in Apache::DBI 0.87, the handle is only rollbacked
if the AutoCommit is set to zero during connect, not if you do
$dbh-{'AutoCommit'} = 0;
in your script.
I wonder if the $needCleanup test is wanted at all. We could make it
a configuration option
On Thu, 7 Sep 2000, Nicolas MONNET wrote:
Hi there,
I might get something wrong, but while in non-autocommit, if a script dies
before rollbacking or commiting, looks like the transaction never gets
cancelled until I kill -HUP httpd! Quite a problem ...
Is there any known way to
, Apache::DBI does push a cleanup handler that does a rollback if
auto-commit is off. Are you saying this isn't working?
- Perrin
...
|
| Is there any known way to catch this?
|
|Well, Apache::DBI does push a cleanup handler that does a rollback if
|auto-commit is off. Are you saying this isn't working?
I've run into a situation where it was'nt. I wanted to make sure
it's not the desired behaviour, before I can dig more
On Thu, 7 Sep 2000, Nicolas MONNET wrote:
|Well, Apache::DBI does push a cleanup handler that does a rollback if
|auto-commit is off. Are you saying this isn't working?
I've run into a situation where it was'nt. I wanted to make sure
it's not the desired behaviour, before I can dig more
-Original Message-
From: Pires Claudio [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 05, 2000 10:12 AM
To: modperl
Subject: Apache crashes with Apache::DBI
Hi, I have problems to load Apache DBI. I added the
PerlModule Apache::DBI
into httpd.conf and when I restarted
Hi, I have problems to load Apache DBI. I added the PerlModule Apache::DBI
into httpd.conf and when I restarted Apache I got this message
bash# /etc/rc.d/init.d/httpd restart;
Shutting down http: [ OK ]
Starting httpd: [ OK ]
bash# /etc/rc.d/init.d/httpd
::DBI to create a persistent
connection to the main DB. However, how will this affect the connections
being made to individual DBs? I have a nagging feeling that they'll connect
until mySQL reaches it's concurrent connection limit then stop being able to
connect to service since it would be filled
Hi
Sorry I don't really remember the mail, I think it was because of the
DEBUG information that were missing in the Apache error_log.
There were many reasons why my Apache wasn't working with Apache::DBI
(not well compiled with mod_perl, http.conf not correctly set, .)
I wrote a little
Hi all,
I am currently developing a web application with Apache/Mod_perl running on redhat
linux 6.1 and
connecting to Oracle Database, everything works fine, i started using persistant
connection using
Apache::DBI, and after every request the open cursor count seems to always increase (
i am
Title: RE: Apache::DBI and Oracle problem
We had this same exact problem. Same as you we were also doing $sth-finish() on each statement handle and we also even tried undef $sth after the finish(). None of these things worked. In our case we were using $dbh-{RaiseError} = 1; to do our error
Hi!
I have apache 1.3.12 and the latest DBI running on Sparc Solaris 2.7. when
i try to run an embedded perl script that makes use of the DBI i get the
following error:
ld.so.1: perl: fatal: relocation error: file
/usr/local/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBD/mysql/mysql.so: symbol
in situations where a
web application wishes to use database security. In this situation, the
current Apache::DBI on CPAN quickly runs into scaling problems as it attempts to
maintain many, many connections.
I would like input on whether people think it would
be better to distribute this in the future
Gentlemen:
Have you had any time to look at this? I'm
attatching my modified version of Apache::DBI. Please send me your
comments and concerns as I would like to send this out to the mod_perl and DBI
community very shortly. I thank you for your time!
- Original Message -
From
very interesting. I might suggest a config option
to toggle the functionality within Apache::DBI instead of a new module
entirely. Or maybe including it as another module within the Apache::DBI
distribution. I don't know how everyone else feels, but all the stuff in the
Apache:: namespace
of possible connections as well, even with only a
handfull of server-child-processes. You can monitor this from within
mysql.
- Original Message -
From: Frédéric Schwien
To: [EMAIL PROTECTED]
Sent: Saturday, July 29, 2000 10:31 AM
Subject: Apache::Session : DBI-Too many connections
Hi
Hi ,
I am using Perl 5.6.0 whith MySql 3.22.32 , Apache 1.3.12 , modperl
1.24 .
On our Production Server , Apache error logs are showing sometimes :
[Thu Jun 8 14:53:34 2000] [error] DBI-connect failed: Too many
connections at /usr/local/lib/perl5/site_perl/5.6.0/Apache/Session
just need to increase its max_connections parameter
to a bigger number.
- Original Message -
From: Frédéric Schwien
To: [EMAIL PROTECTED]
Sent: Saturday, July 29, 2000 10:31 AM
Subject: Apache::Session : DBI-Too many connections
Hi ,
I am using Perl 5.6.0 whith MySql 3.22.32 , Apache
Trond Arve Nordheim wrote, re the "segfault on DBI-connect" problem:
I found out that using all mod_perl-versions between 1.22 and 1.24 with DBI
causes this segfault (Thanks to obscurite, #linux@efnet :)
So, after downgrading my mod_perl to 1.21.3, everything works fine..
That was not the problem.
I've tried that on all 3 servers, without results...
- dufuz
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 18. juli 2000 14:27
To: Trond Arve Nordheim
Cc: [EMAIL PROTECTED]
Subject: segfault on DBI-connect (was Re: Apache segfault
Perhaps sending your startup.pl might help.
Then only time I had problems with Apache::DBI, I loaded Apache.pm in a
BEGIN{} block then everything else after and outside the block in my
startup.pl. That was to deal with an error when Apache::DBI was loaded.
--Jeff
At 10:28 AM 7/18/00 +0530
partly in C.
You should check the standard list of things that usually cause problems
for people:
- Is your mod_perl built with the exact same perl binary that's on your
system?
- Have you tried building mod_perl statically?
- Does your "use Apache::DBI" come before anything else that mig
I had the segfault problem with Redhat 6.1/mod_perl 1.2x/php 4.0RC1
Then I upgraded to PHP4.0.1pl2, and upon configuring got this little handy
message:
++
|*** WARNING *** |
|
On Tue, 18 Jul 2000, Drew Degentesh wrote:
I had the segfault problem with Redhat 6.1/mod_perl 1.2x/php 4.0RC1
Then I upgraded to PHP4.0.1pl2, and upon configuring got this little handy
message:
++
|
, 17 Jul 2000, PHANI MADHAVI wrote:
Hi All,
we have installed Apache::DBI module ( system os is linux, web server
apache, running mod_perl and mysql is rdbms) in our systems. But it is not
working.
When i try to compile a sample file to test db connectivity using
Apache::DBI, it does not work
Hi,
Yes...
installed apache, mod_perl, mysql, dbi and dbd modules using their source
code.
and mod_perl has been installed with the option EVERTYTHING=1.
But of no use..
IF AT ALL ANYBODY KNOWS HOW TO MAKE APACHE::DBI WORK,PLEASE HELP
Regards,
Madhavi
-Original Message-
From: Nigel
PHANI MADHAVI ([EMAIL PROTECTED]) said something to this effect:
IF AT ALL ANYBODY KNOWS HOW TO MAKE APACHE::DBI WORK,PLEASE HELP
The guide is quite clear on how to use and set up Apache::DBI:
http://perl.apache.org/guide/databases.html#Apache_DBI_Initiate_a_persist
http://search.cpan.org
PHANI MADHAVI wrote:
Hi All,
we have installed Apache::DBI module ( system os is linux, web server
apache, running mod_perl and mysql is rdbms) in our systems. But it is not
working.
When i try to compile a sample file to test db connectivity using
Apache::DBI, it does not work.
Same
MADHAVI
Cc: [EMAIL PROTECTED]
Subject: Re: Help needed for using Apache::DBI
PHANI MADHAVI wrote:
Hi All,
we have installed Apache::DBI module ( system os is linux, web server
apache, running mod_perl and mysql is rdbms) in our systems. But it is not
working.
When i try to compile a sample
(in the mod_perl distribution). Remove
the comment from the line.
# use Apache::DebugDBI;
and adapt the connect string. Do not change anything in your scripts for use
with Apache::DBI.
}
we have gone through all the guidelines
But it is not working. It is still trying to search the 'module
Hi All,
we have installed Apache::DBI module ( system os is linux, web server
apache, running mod_perl and mysql is rdbms) in our systems. But it is not
working.
When i try to compile a sample file to test db connectivity using
Apache::DBI, it does not work.
Same thing works if I use DBI
I'm doing a clean install of mod_per and I saw the following warning:
defined(@array) is deprecated at /software/perl5.6.0/lib/site_perl/5.6.0/Apache/DBI.pm
line 135.
(Maybe you should just omit the defined()?)
Syntax OK
Anyone care about this? ;-)
Dave
--
Dave Hodgkinson,
};
)
Commit is enabled in
the script that is performing the connect. The problem that seems to be
happening is that Apache::DBI::Oracle has db connections hanging
aroundwith commit set to 'off' and the commit from the script using
Apache::Session isn't overriding the Autocommit = 'off' connection made
Thank
you for helping me fix this. It is an integral part of a rearchitecture
plan.
Chad
Alan Prey
-
Plead Anarchy, it worked for
me.
Having a bit of trouble getting
apache::session to run with apache::DBI. Is this due to the fact that Oracle
wants AutoCommit on and Apache::DBI has it off or is there some other magic that
I am missing out on? Is anyone using Apache::Session with
Apache::DBI???
The error_log
reports
On Tue, 11 Jul 2000, Chad Billigmeier wrote:
Having a bit of trouble getting apache::session to run with apache::DBI. Is
this due to the fact that Oracle wants AutoCommit on and Apache::DBI has it
off or is there some other magic that I am missing out on? Is anyone using
Apache::Session
-SELECT-statements, the
answer is yes. In fact, all statements have to be prepare()ed when using DBI,
it's just a matter of who does the prepare(), you or DBI.
Rodney Broom
Will apache Session
and apache dbi work together. I've them both on a Solaris machine (newest
apache, newest mod_perl, newest session and newest DBI) andthe server is
not happy.
the error log
complains about 'Already connected' then 'object does not exist in the
data store'. Yeah
Hi,
I probed:
s/'/''/g
yesterday but it did'nt work, will try with HTML code. I think is the
solution.
Thanks
the easiest way is
s/'/''/g
or
s/'/#39;/g
501 - 600 of 856 matches
Mail list logo