RE: Safe handling of an SQL query

Vincent, Don't make the mistake of thinking that you're not directly using DBI. These modules provide an abstraction for creating SQL that is data driven. They free you from the error-prone string manipulation process, and allow you to build your queries in such a way as to be able to

RE: Considering using Perl Sections

We use a combination of Perl sections and Template Toolkit to generate our apache configs. The Perl sections are good for run-time setup for things like host names (i.e., to name logs per host in our cluster) and the templating is good for setting up things like multiple proxies that have just

RE: [mp2] mod_perl closes apache's stdin and/or stdout

I'm starting to use Gearman to get around this whole problem. We use a lot of external processes for many things, so this issue wtih Apache2 really bit me hard in the bee-hind. I've gone to great lengths to work around it, but so far the job queue approach seems to be the most elegant and

RE: Apache2::SubProcess subprocess not subprocessing properly

We are configured to have mod_perl serve the .pl scripts and leave the .cgi scripts to be served as regular old CGI, just as a point of interest. Eric -Original Message- From: Tosh Cooey [mailto:t...@1200group.com] Sent: Thursday, February 11, 2010 6:08 AM To: Torsten Förtsch Cc:

Logs show reasonable request handling duration, but proxied clients timing out

For sometime I've had complaints from one of the users of a particular mod_perl handler that is timing out on their end. They are using a programmatic Java client, accessing a mod_perl registry handler that simply returns a text file. The client is accessing my servers via a proxy which then

Subprocess still running and spawn_proc_prog() returns immediately

I've got an Apache2 problem with a registry script that runs another perl script in a subprocess. The spawn_proc_prog() returns immediately, though the subprocess is still running, which causes a blocking situation when I try to read the stdout/err causing the script to hang indefinitely. The

RE: Subprocess still running and spawn_proc_prog() returns immediately

BTW, using IPC::Run3 -- which I could do since I didn't have to set env vars or a few other things -- worked just fine. Eric -Original Message- From: Berg, Eric: IT (NYK) Sent: Thursday, September 03, 2009 1:31 PM To: modperl@perl.apache.org Subject: Subprocess still running and

RE: tracking a coredump problem

Carl, I may have missed it, but did you say at what point you were seeing the segfault? I assume you mean at startup, but can you confirm? E -Original Message- From: Carl Brewer [mailto:c...@bl.echidna.id.au] Sent: Wednesday, January 28, 2009 7:43 AM To: Philippe M. Chiasson Cc:

RE: Apache 1.3 - 2.x portability

We have a bunch of registry/CGI tools that exec external apps, including Autosys CLI tools and CVS. The problem is that, whereas in 1.3 the environment was passed to the spawned process, in 2.0, that's not the case. We had to make use of Env::C and the Apache2::SubRequest mods to allow us to

Custom Error Log for Specific URL/File matches

I'd like to be able to provide separate logs for developers who are devloping in their ~/public_html directories so that any error log messages for requests made for content that is in one of those directories would be logged to a file in that user's directory instead of (or in addition to) the

RE: Checking Return Codes in Apache2::SubProcess-spawn_proc_prog()

Am I missing something, Fred, or is there actually something in that test that indicates how to read the exit status of the process (i.e., $?)? I have read this a number of times, but have yet to find anything relevant there. Eric -Original Message- From: Fred Moyer [mailto:[EMAIL

Checking Return Codes in Apache2::SubProcess-spawn_proc_prog()

I'm using spawn_proc_prog() to run external programs from apache, but can't find any docs on how to check the return status. It doesn't appear to set $?, nor have I found any reference to variables or methods that would provide that information. Can anybody help me with this? The specific