in reply to Re: Re: accessing Apache::DBI 'cached connections'
in thread accessing Apache::DBI 'cached connections'

Did you also fix the module code so that you are actually assigning the return value of DBI->connect to $DBH?

--Bob Niederman, http://bob-n.com
  • Comment on Re: Re: Re: accessing Apache::DBI 'cached connections'

Replies are listed 'Best First'.
Re: Re: Re: Re: accessing Apache::DBI 'cached connections'
by geektron (Curate) on Jul 21, 2003 at 21:46 UTC
    i had the connect string completely wrong.

    it's fixed now, and reads:

    $DBH = DBI->connect( "dbi:mysql:rentsavers", "root", "", ) ;
    i can't believe i blew the $dsn ....
      This is why you have to check return values or turn on RaiseError.

        Agreed. Unless you're really diligent, turning on RaiseError is better. You can always wrap in an eval when you rally want somthing other than death.

        I turn on RaiseError. ;-/

        --Bob Niederman, http://bob-n.com
        yes, agreed. i thought i was getting info from the startup.pl .. but that doesn't seem to be the case. maybe subject for different node ... but i've preloaded CGI::Carp ...
        # Tell me more about warnings use CGI::Carp qw( fatalsToBrowser warningsToBrowser ); $SIG{__WARN__} = \&Carp::cluck;
        but i'm not getting the fatalsToBrowser behaviour i'm supposed to ... normal 500 error messages, not Carp output
Re: Re: Re: Re: accessing Apache::DBI 'cached connections'
by geektron (Curate) on Jul 21, 2003 at 21:38 UTC
    yes, i changed it to:
    $DBH = DBI->connect( "dbi:mysql:localhost", "rentsavers", "root", "", +) ;
    but i still get nothing ....