No data transmission on new connection

2008-06-12 Thread Ulrich Wisser
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, We developed an EPP server application with Apache and mod-perl. It is Implemented as an connection handler PerlProcessConnectionHandler EPP::Connection When you connect to the server, the server is supposed to send a greeting message before

Re: No data transmission on new connection

2008-06-12 Thread Torsten Foertsch
On Thu 12 Jun 2008, Ulrich Wisser wrote: > On Ubuntu Dapper with Apache 2.0.x and mod-perl 2.0.2 everything works > fine. On Hardy with Apache 2.2.4 and mod-perl 2.0.3 the connection handler > gets Called only after the client has sent the first byte. This is an Apache thing, see http://httpd.a

Re: return value for response handler

2008-06-12 Thread Geoffrey Young
Torsten Foertsch wrote: On Tue 10 Jun 2008, John ORourke wrote: I had a bug with an interesting side effect which I want to understand. I wanted to redirect the user's browser, and in my response handler I was setting $r->status(302) but returning Apache2::Const::OK instead of the correct Apa

Re: return value for response handler

2008-06-12 Thread John ORourke
Geoffrey Young wrote: I wanted to redirect the user's browser, and in my response handler I was setting $r->status(302) but returning Apache2::Const::OK instead of the correct Apache2::Const::DONE. return Apache2::Const::REDIRECT Unfortunately I can't easily do that here - I have plug-in modul

mod_perl2 newbie DBI question

2008-06-12 Thread Brian Gaber
I have a MySQL database application that is used and managed by cgi-bin scripts (CGI.pm). In development the performance was fine, but a productin trial showed the performance to be unacceptable. I am attempting to fix the performance by using mod_perl2 which I have never used. I have successful

Re: mod_perl2 newbie DBI question

2008-06-12 Thread Michael Peters
Brian Gaber wrote: > I have modified scripts to work in mod_perl2, but they don't > work reliably. Sometimes they work and then they stop working and then > I have to stop and start Apache to get it working again. "stop working" is really too generic a description for anyone to really d

Re: mod_perl2 newbie DBI question

2008-06-12 Thread Jim Brandt
Michael Peters wrote: Brian Gaber wrote: I have modified scripts to work in mod_perl2, but they don't work reliably. Sometimes they work and then they stop working and then I have to stop and start Apache to get it working again. "stop working" is really too generic a description

RE: mod_perl2 newbie DBI question

2008-06-12 Thread Brian Gaber
Answers: Is there anything useful in the Apache error log? Works fine a few times and then DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at /usr/local/apache2/perl-r

Re: mod_perl2 newbie DBI question

2008-06-12 Thread Michael Peters
Brian Gaber wrote: > Is there anything useful in the Apache error log? Works fine a few > times and then > DBD::mysql::st execute failed: You have an error in your SQL syntax; > check the manual that corresponds to your MySQL server version for the > right syntax to use near '' at line 1 at > /us

Re: mod_perl2 newbie DBI question

2008-06-12 Thread Dodger
2008/6/12 Michael Peters <[EMAIL PROTECTED]>: > Brian Gaber wrote: >> # Determine MySQL locks table name >> my $sth = $dbh->prepare("SELECT * FROM region_props WHERE region = >> '$region'"); >> $sth->execute(); > Btw, this is *really* bad security wise. $region is coming straight from the > brows

Re: mod_perl2 newbie DBI question

2008-06-12 Thread David Kaufman
Hi Brian, "Brian Gaber" <[EMAIL PROTECTED]> wrote... my $region = param('region'); # ... my $sth = $dbh->prepare( "SELECT * FROM region_props WHERE region = '$region'" ); Works fine a few times and then: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual t