[OPEN-ILS-DEV] problem logging in as admin

[Dan Scott]

On 04/10/2007, John Fink <john.fink at gmail.com> wrote:
> Heh.  Okay, I did this (changing every instance of
> <language>perl</language>, and now really *nothing* works.  No cstore or
> storage in ps wax.  Starting Evergreen takes a lot longer, and on shutdown
> we get the following:
>
> Stopping OpenSRF C :
> opensrf-c: no process killed
>
> ugh.  Dan, are you super extra sure that every perl needs to be Pg? :)
>
> jf
>
>
> On 10/4/07, Dan Scott <denials at gmail.com> wrote:
> > On 04/10/2007, Dan Scott <denials at gmail.com> wrote:
> > > On 04/10/2007, John Fink <john.fink at gmail.com> wrote:
> > > > Okay, stopped, cleared logs, restarted with loglevel 5 in
> opensrf_core.xml.
> > > > This is *probably* the problem; if it isn't, let me know and I'll send
> on
> > > > the full logs.
> > > >
> > > > Probably something I messed up in the install...
> > > >
> > > >
> > > > from osrfsys.log:
> > > > [2007-10-4 6:41:22] open-ils.storage [DEBG:12469:Storage.pm:31:]
> Attempting
> > > > to load OpenILS::Appli
> > > > cation::Storage::Driver::pgsql ...[2007-10-4 6:41:22] open-ils.storage
> [ERR
> > > > :12469:Storage.pm:35:] Can't load
> > > > OpenILS::Application::Storage::Driver::pgsql!  :
> Can't
> > > > locate OpenILS/Application/Storage/Driver/pgsql.pm in
> @INC
> > > > (@INC contains: /openils/lib/perl5 /etc/perl /usr/local/lib/perl/5.8.8
> > > > /usr/local/share/perl/5.8.8 /usr/lib/perl5 /usr/share/perl5
> > > > /usr/lib/perl/5.8 /usr/share/perl/5.8 /usr/local/lib/site_perl .) at
> > > > /openils/lib/perl5/OpenILS/Application/Storage.pm
> line
> > > > 33.[2007-10-4 6:41:22] open-ils.storage [ERR :12469:Storage.pm:36:]
> Can't
> > > > load OpenILS::Application::
> > > > Storage::Driver::pgsql!  :  Can't locate
> > > > OpenILS/Application/Storage/Driver/pgsql.pm in @INC
> (@INC
> > > > contains: /openils/lib/perl5 /etc/perl /usr/local/lib/perl/5.8.8
> > > > /usr/local/share/perl/5.8.8 /usr/lib/perl5 /usr/share/perl5
> > > > /usr/lib/perl/5.8 /usr/share/perl/5.8 /usr/local/lib/site_perl .) at
> > > > /openils/lib/perl5/OpenILS/Application/Storage.pm
> line 33.
> > > > [2007-10-4 6:41:22] open-ils.storage [ERR :12469:EX.pm :66:]   * !
> EXCEPTION
> > > > ! * TYPE: OpenSRF::EX::PANICMess: System PANIC Mess: Can't load
> > > > OpenILS::Application::Storage::Driver::pgsql!  :
> Can't
> > > > locate OpenILS/Application/Storage/Driver/pgsql.pm in
> @INC
> > > > (@INC contains: /openils/lib/perl5 /etc/perl /usr/local/lib/perl/5.8.8
> > > > /usr/local/share/perl/5.8.8 /usr/lib/perl5 /usr/share/perl5
> > > > /usr/lib/perl/5.8 /usr/share/perl/5.8 /usr/local/lib/site_perl .) at
> > > > /openils/lib/perl5/OpenILS/Application/Storage.pm
> line 33.
> > > >
> > > >
> > > > jf
> > > >
> > > >
> > > > On 10/3/07, Bill Erickson < erickson at esilibrary.com> wrote:
> > > > >
> > > > >
> > > > >
> > > > > On 10/2/07, Mike Rylander < mrylander at gmail.com> wrote:
> > > > > > On 10/2/07, John Fink < john.fink at gmail.com> wrote:
> > > > > > > Here's something tasty from gateway.log .  Let me know if you
> want a
> > > > look at
> > > > > > > any of the others.
> > > > > >
> > > > > > <snip the exception>
> > > > > >
> > > > > > That just means that storage is not starting properly.  The most
> > > > > > likely reason is mis-configured database settings for the storage
> app.
> > > > > > One thing to check is that for c-store the driver is called pgsql,
> > > > > > but for storage it's called Pg.
> > > > > >
> > > > > > UPDATE: as Dan suggests, sending the entire log will help diagnose
> the
> > > > > > exact reason for this.  /me steps outta Dan's way.
> > > > >
> > > > >
> > > > > For Perl processes, you'll sometimes get good information out of the
> > > > Net::Server logs as well.  The default location for the storage log is
> > > > >
> > > > > /openils/var/log/openils.storage_unix.log
> > > > >
> > > > > -bill
> > > > >
> > > > >
> > >
> > > Yeah! I think you've got it.
> > >
> > > Two possibilities come to mind:
> > >
> > > 1) You ran "make install" as root and forgot to "chown -R
> > > opensrf:opensrf /openils" after running the install. In this scenario,
> > >
> /openils/lib/perl5/OpenILS/Application/Storage/Driver/pgsql.pm
> exists,
> > > but does not have the permissions or ownership that allow the opensrf
> > > user to actually see the file.
> > >
> > > 2)
> /openils/lib/perl5/OpenILS/Application/Storage/Driver/pgsql.pm
> > > doesn't exist at all, which would be a more puzzling problem.
> > > Repeating the make install & chown steps for Evergreen would be my
> > > first stab at resolving the problem.
> > >
> > > Let's see / hope it's simply problem #1 instead.
> >
> > Oh, actually it's problem #3!
> >
> > opensrf.xml has an entry for <open-ils.storage>, with a databases
> > section. The driver for any application that has
> > <language>perl</language> should be <driver>Pg</driver>. You probably
> > have <driver>pgsql</driver>, which would cause Evergreen to try and
> > load pgsql.pm rather than Pg.pm.
> >
> > If you look in
> /openils/lib/perl5/OpenILS/Application/Storage/Driver/
> > you'll see it contains "Pg.pm".
> >
> > This should get you rolling!
> >
> > --
> > Dan Scott
> > Laurentian University

Oh, John. Yes, I'm sure that every app with language "perl" that has a
<databases> section needs to use the <driver>Pg - that being said,
there is only one perl application in my opensrf.xml that contains a
databases section, that one app being <open-ils.storage> - so I'm not
sure how you could have changed any others. Doesn't sound too good,
though :)

I'm going to throw this one out to a lifeline - am I crazy, and just
completely misleading John?

-- 
Dan Scott
Laurentian University