Mailing-List: contact modperl-help@perl.apache.org; run by ezmlm
Precedence: bulk
Received-SPF: pass (athena.apache.org: domain of pharkins@gmail.com designates
 209.85.216.49 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:sender:in-reply-to:references:date
         :x-google-sender-auth:message-id:subject:from:to:cc:content-type
         :content-transfer-encoding;
        b=bDoiOJ97E2eE8qpl3si4OUIxvl5SEhoFOO2TQmmqtvKnFiXwpRSc5F7VZQWRTVU1sS
         de/nWL/NuMYsNHw60ymw/cueBp1k/nr0U/btHothiWAdKzbxP5ftIEOYjqbyCuReIIP9
         UHCzucAiBHR5adpwe07NCmQAuik0NaIeCSCwc=
MIME-Version: 1.0
Sender: pharkins@gmail.com
In-Reply-To: <4CDB27B5.6090607@1200group.com>
References: <4CDB27B5.6090607@1200group.com>
Date: Wed, 10 Nov 2010 18:30:21 -0500
Message-ID: <AANLkTi=ptaHH=W1Rkewu79t0dz95BWZ=sMb_1fVdc6YR@mail.gmail.com>
Subject: Re: I think AuthCookie(DBI) is causing segfaults?
From: Perrin Harkins <perrin@elem.com>
To: Tosh Cooey <tosh@1200group.com>
Cc: "modperl@perl.apache.org" <modperl@perl.apache.org>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Which MPM are you using?

- Perrin

On Wed, Nov 10, 2010 at 6:16 PM, Tosh Cooey <tosh@1200group.com> wrote:
> I have a standard mod_perl setup, application is a server and mysql is
> another.
>
> I use AuthCookieDBI
> http://cpansearch.perl.org/src/MATISSE/Apache2-AuthCookieDBI-2.05/lib/Apa=
che2/AuthCookieDBI.pm
> for authentication against the DB.
>
> If the application has not been used for a while, a few hours, then when =
a
> user tries to connect Apache segfaults. =A0Here is debug output:
>
> [Wed Nov 10 22:37:04 2010] [error] auth_type DISKO::AUTH
> [Wed Nov 10 22:37:04 2010] [error] r=3DApache2::RequestRec=3DSCALAR(0x81f=
6f290)
> authtype=3DDISKO::AUTH
> [Wed Nov 10 22:37:04 2010] [error] auth_name berlin3
> [Wed Nov 10 22:37:04 2010] [error] ses_key_cookie <cookiestuff>
> [Wed Nov 10 22:37:04 2010] [error] uri /clientID/index.pl
> [Wed Nov 10 22:37:04 2010] [error] user authenticated as tosh
> [Wed Nov 10 22:37:04 2010] [error] authorize() for /clientID/index.pl
> [Wed Nov 10 22:37:04 2010] [error] authorize user=3Dtosh type=3DDISKO::AU=
TH
> [Wed Nov 10 22:37:04 2010] [error] requirement :=3D valid-user,
> [Wed Nov 10 22:37:04 2010] [notice] child pid 17510 exit signal Segmentat=
ion
> fault (11)
>
> DISKO::AUTH is where I override:
> *Apache2::AuthCookieDBI::_dbi_connect =3D sub {
> the connect() sub so I can do some on-the-fly modification of DSN names.
>
> DBI->connect_cached is used if that is of importance.
>
> My understanding of DBI is that things like ping() and reconnecting are a=
ll
> taken care of automagically, so I'm a bit baffled by this, especially as =
I
> have never had this happen on somewhat similar application setups.
>
> Is there something wrong with Apache2::AuthCookieDBI::_dbi_connect ?
>
> Or should I just cron a task to ping the application every hour?
>
> Thanks!
>
> Tosh
>
> --
> McIntosh Cooey - Twelve Hundred Group LLC - http://www.1200group.com/
>