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

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

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

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

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

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 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

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 browser. You're

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 that