perl_free(my_perl) affecting mod_perl?

2008-06-30 Thread Chintana Wilamuna
Hi, I'm trying to call a Perl function from C code and clean the interpreter I just created. I have a Perl script hosted with Apache + mod_perl and when a request comes to the file (say example.pl) it'll call a C function which is wrapped with SWIG. I'm getting the global request via Apache2::Re

Re: [mp2] Segfault on using $r->content_type()

2008-06-30 Thread Philippe M. Chiasson
Stephen Howard wrote: 1. Problem Description: I have an intermittent segfault with one particular ResponseHandler. The segfault, when it occurs, is triggered by calling $r->content_type in a lightly modified CGI::Simple (I made changes to it as it wasn't playing well with mod_perl2). What

Re: Lost connection to MySQL server during query (was "Segfault when connecting during Apache startup")

2008-06-30 Thread Perrin Harkins
On Mon, Jun 30, 2008 at 1:40 PM, Tobias Kremer <[EMAIL PROTECTED]> wrote: > Could you please show me the exact line in my example in which I put the > database handle in a > global during startup? On a closer look, you're not. You are keeping around your $foo closure variable in handler(), as wel

Re: Lost connection to MySQL server during query (was "Segfault when connecting during Apache startup")

2008-06-30 Thread Tobias Kremer
On 30.06.2008, at 17:10, Perrin Harkins wrote: It's not Apache::DBI that's caching it -- you're caching it. Don't put a database handle in a global before you fork. It will stay, and there's nothing Apache::DBI can do about it. Could you please show me the exact line in my example in which I

Re: mod_perl and perlMagick Write

2008-06-30 Thread André Warnier
lemur08 wrote: Hello all, I'm a newbie with mod_perl so please be patient with me. You wouldn't believe how patient the people on this list are :-) Two tips for debugging your kind of present problem, and many others with the web in the future : 1) as a browser use Firefox, with the LiveHtt

Re: mod_perl and perlMagick Write

2008-06-30 Thread lemur08
Thanks, I've received a reply with the solution. I'm now using the ImageToBlob function and it works fine! Thanks for the responses. -- View this message in context: http://www.nabble.com/mod_perl-and-perlMagick-Write-tp18198248p18198541.html Sent from the mod_perl - General mailing list archive

mod_perl and perlMagick Write

2008-06-30 Thread lemur08
Hello all, I'm a newbie with mod_perl so please be patient with me. I'm working no a very simple image manipulation script using perlMagick. The script reads an image from file, resizes it, and then serves it up to the browser using the perlMagick function Write, like this: $pic->Write("jpg:-")

Re: Lost connection to MySQL server during query (was "Segfault when connecting during Apache startup")

2008-06-30 Thread Michael Peters
Tobias Kremer wrote: > Quoting Michael Peters <[EMAIL PROTECTED]>: >> Why are you storing the DB handle in a global variable? >> If you do that then Apache::DBI can't help you if the connection goes away. > > To make this variable available to all Mason components. Then use a method to do this,

Re: nginx load balance

2008-06-30 Thread Perrin Harkins
On Mon, Jun 30, 2008 at 11:09 AM, Jeff Peng <[EMAIL PROTECTED]> wrote: > How about Apache::Session? Is it more efficient under modperl? No, it's about the same, and CGI::Session is better maintained. Don't be fooled by the name: CGI::Session works well with mod_perl. - Perrin

Re: Lost connection to MySQL server during query (was "Segfault when connecting during Apache startup")

2008-06-30 Thread Perrin Harkins
On Mon, Jun 30, 2008 at 11:02 AM, Tobias Kremer <[EMAIL PROTECTED]> wrote: > According to the docs Apache::DBI > should automatically avoid caching this connection. It's not Apache::DBI that's caching it -- you're caching it. Don't put a database handle in a global before you fork. It will stay,

Re: nginx load balance

2008-06-30 Thread Jeff Peng
On Mon, Jun 30, 2008 at 11:07 PM, Perrin Harkins <[EMAIL PROTECTED]> wrote: > On Mon, Jun 30, 2008 at 11:00 AM, Jeff Peng <[EMAIL PROTECTED]> wrote: >> what's the standard module for storing sessions in a database? > > I recommend CGI::Session. > Yes, currently I'm also using CGI::Session. How abo

Re: nginx load balance

2008-06-30 Thread Perrin Harkins
On Mon, Jun 30, 2008 at 11:00 AM, Jeff Peng <[EMAIL PROTECTED]> wrote: > what's the standard module for storing sessions in a database? I recommend CGI::Session. - Perrin

Re: nginx load balance

2008-06-30 Thread Jeff Peng
Thanks for all. what's the standard module for storing sessions in a database? On Mon, Jun 30, 2008 at 8:43 PM, Perrin Harkins <[EMAIL PROTECTED]> wrote: > On Mon, Jun 30, 2008 at 3:18 AM, James Smith <[EMAIL PROTECTED]> wrote: >> I would consider using a shared memory solution to save traffic too

Re: Lost connection to MySQL server during query (was "Segfault when connecting during Apache startup")

2008-06-30 Thread Tobias Kremer
Quoting Michael Peters <[EMAIL PROTECTED]>: > Tobias Kremer wrote: > > use vars qw( $dbh $thefoo ); > Why are you storing the DB handle in a global variable? > If you do that then Apache::DBI can't help you if the connection goes away. To make this variable available to all Mason components. Theor

Re: Lost connection to MySQL server during query (was "Segfault when connecting during Apache startup")

2008-06-30 Thread Michael Peters
Tobias Kremer wrote: > use vars qw( $dbh $thefoo ); Why are you storing the DB handle in a global variable? If you do that then Apache::DBI can't help you if the connection goes away. -- Michael Peters Plus Three, LP

Re: Lost connection to MySQL server during query (was "Segfault when connecting during Apache startup")

2008-06-30 Thread Tobias Kremer
Quoting Perrin Harkins <[EMAIL PROTECTED]>: > I don't see anything in this code, but you're not really showing us > much here. I think you'll need to try commenting out parts of it > until you find which part breaks it. I'd start with that > selectall_arrayref that you store. I can reproduce the

Re: Segfault when connecting during Apache startup with Apache::DBI

2008-06-30 Thread Frank Maas
On Mon, Jun 30, 2008 at 10:54:20AM +0200, Tobias Kremer wrote: > Any other ideas? Thanks! It could be that your query(result) is too large for the 'max_allowed_packet' setting. The mysql-client that is connected to your process will then silently die, giving the 'Lost mysql...' error as result.

Re: Lost connection to MySQL server during query (was "Segfault when connecting during Apache startup")

2008-06-30 Thread Perrin Harkins
On Mon, Jun 30, 2008 at 9:28 AM, Tobias Kremer <[EMAIL PROTECTED]> wrote: > Ok, I narrowed it down to the database connection initiated during server > startup. As soon as I remove it the errors vanish completely. Good, that's major progress. > Here are some snippets to illustrate what I'm doing:

Re: Lost connection to MySQL server during query (was "Segfault when connecting during Apache startup")

2008-06-30 Thread Tobias Kremer
Quoting Perrin Harkins <[EMAIL PROTECTED]>: > On Mon, Jun 30, 2008 at 4:54 AM, Tobias Kremer <[EMAIL PROTECTED]> wrote: > > We never fork and I thought that Apache::DBI takes care of checking if a > > connection went stale by utilizing DBI's/DBD::mysql's ping() method? > It does, but it can't stop

Re: Some perl regex help

2008-06-30 Thread Perrin Harkins
On Mon, Jun 30, 2008 at 12:47 AM, Alexander Burrows <[EMAIL PROTECTED]> wrote: > I've been trying > to read around forums and regex documents for perl but they seem unorganized > and cryptic. So any help would be appreciated. This list is for mod_perl, not general Perl help. In the future, if you

Re: Segfault when connecting during Apache startup with Apache::DBI

2008-06-30 Thread Perrin Harkins
On Mon, Jun 30, 2008 at 4:54 AM, Tobias Kremer <[EMAIL PROTECTED]> wrote: > We never fork and I thought that Apache::DBI takes care of checking if a > connection went stale by utilizing DBI's/DBD::mysql's ping() method? It does, but it can't stop you from doing things like putting a database handl

Re: nginx load balance

2008-06-30 Thread Perrin Harkins
On Mon, Jun 30, 2008 at 3:18 AM, James Smith <[EMAIL PROTECTED]> wrote: > I would consider using a shared memory solution to save traffic too > from the database server (consider a solution based on memcached??)... No, don't use memcached for sessions. It's a cache, not a database. It trades reli

Re: Some perl regex help

2008-06-30 Thread Alexander Burrows
This worked great thanks. Was exactly what I was looking for. -Alexander James Smith-7 wrote: > > > > On Sun, 29 Jun 2008, Alexander Burrows wrote: > >> >> Hello again all. Been a while since I've posted here but needed some help >> on >> a regex I was trying to write. >> >> $line =~ tr/(\(

Re: Segfault when connecting during Apache startup with Apache::DBI

2008-06-30 Thread Tobias Kremer
Quoting Perrin Harkins <[EMAIL PROTECTED]>: > On Fri, Jun 27, 2008 at 5:51 AM, Tobias Kremer <[EMAIL PROTECTED]> wrote: > > Now if I could just get rid of those annoying random "Commands out of sync" > and > > "Lost connection to MySQL server during query" errors that happen once in a > > while ...

Re: Some perl regex help

2008-06-30 Thread James Smith
On Sun, 29 Jun 2008, Alexander Burrows wrote: Hello again all. Been a while since I've posted here but needed some help on a regex I was trying to write. $line =~ tr/(\(|\)|<|>)/(\(|\)|\<|\>)/g; Simplest approach is to make a hash of the substitutions and use an "e" executed regexp my %ha

Re: nginx load balance

2008-06-30 Thread James Smith
On Sun, 29 Jun 2008, Perrin Harkins wrote: On Sat, Jun 28, 2008 at 9:48 AM, Jeff Peng <[EMAIL PROTECTED]> wrote: But I have a question, does nginx support for session-keeping? A user's request, should go always to the same original backend server. Otherwise the user's session will get lost.