Subject: Re: [Catalyst] How to show SQL in apache

Cookie xiaoquqi at
Tue Jun 19 05:28:30 GMT 2007

If the sql print out to the STDERR,I think the apache server should be
I follow the Storage::DBI,open a new filehandle,and tried to write the
log,but it seems still useless.
I am so puzzled about this,Please help me.Thanks.

Message: 6
Date: Wed, 13 Jun 2007 06:55:05 +0100
From: Matt S Trout <dbix-class at>
Subject: Re: [Catalyst] How to show SQL in apache
To: The elegant MVC web framework <catalyst at>
Message-ID: <20070613055505.GN8493 at>
Content-Type: text/plain; charset=3Dus-ascii

On Wed, Jun 13, 2007 at 12:27:26PM +0800, Cookie wrote:
> Thanks for your answer.But I think it already can not work although I add
> $schema->storage->debug(1);
> in my code.I agree with you the output of sql is in the STDOUT.I will find
> some way of configurating the apache to record the STDOUT.

No it isn't.

STDERR is the default.

> BTW,If I want to know,if I used log4perl,Can I log the sql in my log
> file?Thanks.

Read the Storage::DBI docs and follow the references to provide a custom
debug object.

     Matt S Trout       Need help with your Catalyst or DBIx::Class project?
  Technical Director    Want a managed development or deployment platform?
 Shadowcat Systems Ltd.  Contact mst (at) for a quote   
-------------- next part --------------
An HTML attachment was scrubbed...

More information about the Catalyst mailing list