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

[Dan Scott]

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