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

[John Fink]

I did what is probably a Very Dumb Thing and just wholesale changed every
instance of <language>perl</language> to Pg without checking the context in
which those <language> tags were nested.  Worse yet, I did so brazenly and
without regard to keeping a backup file.  So I'll go in and undo tomorrow
morning, and I'm sure it will work swimmingly.

jf

On 10/4/07, Dan Scott <denials at gmail.com> wrote:
>
> 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
>



-- 
http://libgrunt.blogspot.com -- library culture and technology.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://list.georgialibraries.org/pipermail/open-ils-dev/attachments/20071004/761b5bad/attachment.html