AW: Weird issues using DBI + mod_perl

2019-09-03 Thread Andreas Mock
Hi Bruce, thank you for the feedback. Have you posted it under "#use" ? :- Best regards Andreas Von: Bruce Johnson Gesendet: Dienstag, 3. September 2019 18:36 An: Andreas Mock Cc: dbi users ; mod_perl list Betreff: Re: Weird issues using DBI + mod_perl Jus

Re: Weird issues using DBI + mod_perl

2019-09-03 Thread Bruce Johnson
Just a follow up…it was embarrassingly stupid. You know how you can stare at an error in a line dozens of times and not see it? Like the ‘#' commenting out "use Apache::DBI” in your startup.pl file ... On Aug 16, 2019, at 2:47 PM, Andreas Mock mailto:andreas.m...@web.de>> wrote: Hi Bruce, I'm

AW: Weird issues using DBI + mod_perl

2019-08-16 Thread Andreas Mock
endet: Freitag, 16. August 2019 23:36 An: dbi users ; mod_perl list Betreff: Weird issues using DBI + mod_perl So I’ve built a site using mod_perl in CGI mode, with DBI and Oracle as my database back end. Everything works fine for a while but then I get intermittent weird errors that start happenin

Weird issues using DBI + mod_perl

2019-08-16 Thread Bruce Johnson
So I’ve built a site using mod_perl in CGI mode, with DBI and Oracle as my database back end. Everything works fine for a while but then I get intermittent weird errors that start happening for every page load, which is resulting in non-functional pages and error messages “Something happened co

Re: Using DBI

2004-12-29 Thread Randy Kobes
On Wed, 29 Dec 2004, Octavian Rasnita wrote: > I have tried to install Apache-DBI from TheoryX but ppm gave an error: > > Error: no suitable installation target found for package Apache-DBI. That usually means that ppm found a package, but it was in a repository that didn't match your platform. D

Re: Using DBI

2004-12-28 Thread Octavian Rasnita
I have tried to install Apache-DBI from TheoryX but ppm gave an error: Error: no suitable installation target found for package Apache-DBI. How can I apply that patch manually? Do I need to edit the module Apache::DBI by hand? (Under Windows) Thanks. Teddy From: "Randy Kobes" <[EMAIL PROTECTED

Re: Using DBI

2004-12-28 Thread Randy Kobes
On Tue, 28 Dec 2004, Randy Kobes wrote: [ ... ] > Can you try the > following patch against Apache::DBI (version 0.94) - if > you're using ppm on Win32, you can get this from the > Apache-DBI.ppd package in the >http://theoryx5.uwinnipeg.ca/ppms/ > repository. Sorry about this - I missed one

Re: Using DBI

2004-12-28 Thread Randy Kobes
On Tue, 28 Dec 2004, Octavian Rasnita wrote: > Ok, but I have seen an example in a tutorial where the database is accessed > with the username, and the password from a startup.pl file exactly like > this: > > Apache::DBI->connect_on_init("DBI:mysql:database=presa;host=localhost", > "ODBC", undef,

Re: Using DBI

2004-12-28 Thread Stas Bekman
Malcolm J Harwood wrote: [...] This works if you are using the pre-fork MPM (which I understand doesn't work well under Win32 due to limitations of NT). It would seem that if you are using the worker MPM then it doesn't make a connection for each thread, just for the owning process. In which ca

Re: Using DBI

2004-12-28 Thread Malcolm J Harwood
On Tuesday 28 December 2004 04:56 pm, Octavian Rasnita wrote: > Ok, but I have seen an example in a tutorial where the database is accessed > with the username, and the password from a startup.pl file exactly like > this: > > Apache::DBI->connect_on_init("DBI:mysql:database=presa;host=localhost",

Re: Using DBI

2004-12-28 Thread Octavian Rasnita
pm I have used only: > > use DBI; > my $dbh = ...; > > Well, in this case the script works, but I don't know if this way of using > DBI is the best way. If you are using multiple threads, then yes. (Though I'm not sure how Apache::DBI's thread pool works with multip

Re: Using DBI

2004-12-28 Thread Malcolm J Harwood
; > And in GetCategories.pm I have used only: > > use DBI; > my $dbh = ...; > > Well, in this case the script works, but I don't know if this way of using > DBI is the best way. If you are using multiple threads, then yes. (Though I'm not sure how Apache::DBI'

Re: Using DBI

2004-12-28 Thread Stas Bekman
.\n - So I have commented out the following line in preload.pl: ###Apache::DBI->connect_on_init("DBI:mysql:database=presa;host=localhost", "ODBC", undef, {PrintError =>1, RaiseError=>0, AutoCommit => 1}); And in GetCategories.pm I have used only: use DBI; my $dbh = ...; Wel

Using DBI

2004-12-28 Thread Octavian Rasnita
mmented out the following line in preload.pl: ###Apache::DBI->connect_on_init("DBI:mysql:database=presa;host=localhost", "ODBC", undef, {PrintError =>1, RaiseError=>0, AutoCommit => 1}); And in GetCategories.pm I have used only: use DBI; my $dbh = ...; Well, in this c

Re: Using DBI and Apache::DBI together

2004-08-03 Thread Boris Zentner
Am Dienstag 03 August 2004 16:16 schrieb Tom Schindl: > Ask has already stated that he's going to include it in his next > release, I have already filed a doc-patch at rt.cpan.org > Good to know, Unfortunely I have started it also, currently I have no internet at work ;-) diff -Nur a/DBI.pm b/D

Re: Using DBI and Apache::DBI together

2004-08-03 Thread Tom Schindl
Ask has already stated that he's going to include it in his next release, I have already filed a doc-patch at rt.cpan.org Tom Stas Bekman wrote: Boris Zentner wrote: Hi, Am Mittwoch 28 Juli 2004 12:20 schrieb Tom Schindl: Boris Zentner wrote: [...] # bypass Apache::DBI $dbh = DBI->connect($data

Re: Using DBI and Apache::DBI together

2004-08-01 Thread Stas Bekman
Boris Zentner wrote: Hi, Am Mittwoch 28 Juli 2004 12:20 schrieb Tom Schindl: Boris Zentner wrote: [...] # bypass Apache::DBI $dbh = DBI->connect($data_source, $username, $password, { dbi_connect_method => 'connect' }) || die; I knew there is such a parameter, but couldn't remember it. So I took a

Re: Using DBI and Apache::DBI together

2004-07-28 Thread Boris Zentner
Hi, Am Mittwoch 28 Juli 2004 12:20 schrieb Tom Schindl: > Boris Zentner wrote: [...] > > # bypass Apache::DBI > > $dbh = DBI->connect($data_source, $username, $password, { > > dbi_connect_method => 'connect' }) || die; > > I knew there is such a parameter, but couldn't remember it. So I took a

Re: Using DBI and Apache::DBI together

2004-07-28 Thread Tom Schindl
Boris Zentner wrote: Am Mittwoch 28 Juli 2004 06:36 schrieb Chris Ochs: We have our own application server built on mod perl and the template toolkit. Most of the application specific sql queries all run as a single user which is great for Apache::DBI. Every end user also has 3-4 tables they can

Using DBI and Apache::DBI together

2004-07-28 Thread Chris Ochs
We have our own application server built on mod perl and the template toolkit. Most of the application specific sql queries all run as a single user which is great for Apache::DBI. Every end user also has 3-4 tables they can query (using the template toolkit DBI plugin) using their own username,

Re: Using DBI and Apache::DBI together

2004-07-28 Thread Boris Zentner
Am Mittwoch 28 Juli 2004 06:36 schrieb Chris Ochs: > We have our own application server built on mod perl and the template > toolkit. Most of the application specific sql queries all run as a single > user which is great for Apache::DBI. Every end user also has 3-4 tables > they can query (using

Using DBI and Apache::DBI together

2004-07-27 Thread Chris Ochs
We have our own application server built on mod perl and the template toolkit. Most of the application specific sql queries all run as a single user which is great for Apache::DBI. Every end user also has 3-4 tables they can query (using the template toolkit DBI plugin) using their own username,