Apache::DBI, Postgresql, and transactions

Hi, I've been converting some old CGI scripts for use with mod_perl and Apache::DBI. These scripts access a Postgres database through DBI. I didn't have any trouble until I began writing a new script which in the development phase has generated a few bad SQL commands (my fault, not the problem

Re: Apache::DBI, Postgresql, and transactions

Thanks for the suggestion, but it's the same connection with the same params every time. The connection code is actually in a Class::DBI module, which gets use()'d by all of my scripts. This module isn't in my startup script, so that each process keeps its own copy. So there are multiple handle

Re: Apache::DBI, Postgresql, and transactions

Thanks! It seems to be working correctly after implementing your changes. Brian Perrin Harkins wrote: I plan to submit a patch for Ima::DBI to fix this, but in the meantime I am handling it by overriding db_Main and doing the connections myself. Here's the code I use: my $db_options = { Raise

CGI::Carp and PerlRun

Hi, I've noticed that on some of my simpler CGI scripts, in which I use CGI::Carp's 'die' replacement to print an error message to the browser, PerlRun will give an internal server error instead, but still log the error message. These scripts worked fine under mod_cgi. CGI::Carp's documentatio

Mac::Glue and mod_perl

Sorry for cross-posting this, but i think it applies to both groups. I'm trying to write a mod_perl script (for PerlRun) that will present an online interface to my Mac OS X Address Book. Using the standard method of connecting to the glue (new Mac::Glue 'Address Book') doesn't work; the webserv

Re: Mac::Glue and mod_perl

Well, if you mean restarting the whole computer, no; but I had shut down and restarted the webserver a few times, and always gotten the same results. Martin Moss wrote: please forgive the really daft question, but have done a complete server shutdown and restart? I've come across bus errors befor

[mp1] binmode(STDOUT, ':utf8') fails silently

Hi, I'm trying to set binmode(STDOUT, ':utf8') from within a PerlRun script (mod_perl 1.29, apache 1.3.29, perl 5.8.6), and it's failing (returning undef) without setting $!, as the docs claim it should. I really shouldn't even have to do this at all, since I'm already setting Content-type: text

Re: [mp1] binmode(STDOUT, ':utf8') fails silently

till curious about binmode(), though; is there some mod_perl-specific reason that it would fail? Brian Dimeler wrote: Hi, I'm trying to set binmode(STDOUT, ':utf8') from within a PerlRun script (mod_perl 1.29, apache 1.3.29, perl 5.8.6), and it's failing (returning undef) wi

[mp1] Apache::PerlRun errs on backtick operator

I'm moving my all of my PerlRun scripts to a new webserver, and have discovered that a few modules which invoke system commands via the backtick `` operator are failing to compile when they reach those commands. This doesn't happen when I run the scripts from the command line; only when run as m

[mp1] CGI upload_hook with PerlRun

Hi, I have a file-uploading script from a server running perl scripts as plain old CGI, and I'm trying to port it to an Apache 1.3 server using PerlRun. Everything works except CGI's upload hook. On the vanilla CGI server, the upload hook routine is called repeatedly during the upload process,