[OPEN-ILS-DEV] help with OPAC configuration - thanks!

Fri May 25 00:35:24 EDT 2007

Glad you got it working Mon!

Very good catch DW! I overlooked that myself! DW++

--Don

On 5/24/07, Pseudo Admin <sayanslib at gmail.com> wrote:
> Hello everyone,
>
> Thank you so much for all your help, sorry for all the troubles, looks like
> I am almost there
>
> Don here is the result when I run the script you suggested (
> http://www.open-ils.org/dokuwiki/doku.php?id=scratchpad:dmcmorris:dbdtest)
>
> cslibadmin at cslibff:/openils/bin$ sudo perl dbitest.pl
> 1, CONS, Example Consortium
> 2, SYS1, Example System 1
> 3, SYS2, Example System 2
> 4, BR1, Example Branch 1
> 5, BR2, Example Branch 2
> 6, BR3, Example Branch 3
> 7, BR4, Example Branch 4
> 8, SL1, Example Sub-lib 1
> 9, BM1, Example Bookmobile 1
>
>
> > Message: 1
> > Date: Thu, 24 May 2007 04:55:02 -0400
> > From: "Don McMorris" <don.mcmorris at gmail.com>
> > Subject: [OPEN-ILS-DEV] Re: Open-ils-dev Digest, Vol 14, Issue 64
> > To: open-ils-dev at list.georgialibraries.org
> > Message-ID:
> >
> <f2b02f1e0705240155v502e1112vcc68f4e791f1e2a0 at mail.gmail.com
> >
> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> >
> > Since you're digested, hopefully this e-mail will will solve your
> > problem ;).  Just a quick note... gmail does group the list e-mails
> > nicely by subject if you run in "normal" mode.  I usually don't get
> > any more than a couple threads a day (with an occasional burst of
> > about half a dozen), and they're all easily distinguished with a
> > subject line beginning with "[open-ils...".
> >
> > If you want to change your list settings, you can from
> > http://www.open-ils.org/listserv.html (from here, click
> on the
> > appropriate mailing list, and at the bottom is "unsubscribe or edit
> > options").  For now, I've "BCC"'d you in hopes of getting you an
> > immediate reply so that you can expedite the fix ;)
> >
> > It was suggested in the chat (#OpenILS-Evergreen on the Freenode IRC
> > network) that we next test the Perl DBI module.  A simple way to do
> > this is to use the perl script at
> >
> http://www.open-ils.org/dokuwiki/doku.php?id=scratchpad:dmcmorris:dbdtest
> >
> > Good Luck!
> > --Don
>
> Dan here is the result when I run
>
>  cslibadmin at cslibff:/openils/bin$ sudo locate libdbdpgsql.so
>  /usr/local/lib/dbd/libdbdpgsql.so
> /home/cslibadmin/evergreen_admin/eg-srcs/libdbi-drivers-0.8.2-1/drivers/pgsql/.libs/libdbdpgsql.so
>
>  cslibadmin at cslibff:/openils/bin$ sudo ldd
> /usr/local/lib/dbd/libdbdpgsql.so
>          linux-gate.so.1 =>  (0xffffe000)
>          libpq.so.5 => /usr/lib/libpq.so.5 (0xb7ef3000)
>          libc.so.6 => /lib/tls/i686/cmov/libc.so.6 (0xb7db2000)
>          libssl.so.0.9.8 =>
> /usr/lib/i686/cmov/libssl.so.0.9.8 (0xb7d71000)
>          libcrypto.so.0.9.8 =>
> /usr/lib/i686/cmov/libcrypto.so.0.9.8 (0xb7c2f000)
>          libkrb5.so.3 => /usr/lib/libkrb5.so.3 (0xb7bb2000)
>          libcom_err.so.2 => /lib/libcom_err.so.2 (0xb7baf000)
>          libcrypt.so.1 => /lib/tls/i686/cmov/libcrypt.so.1
> (0xb7b81000)
>          libpthread.so.0 =>
> /lib/tls/i686/cmov/libpthread.so.0 (0xb7b6a000)
> /lib/ld-linux.so.2 (0x80000000)
>          libdl.so.2 => /lib/tls/i686/cmov/libdl.so.2 (0xb7b65000)
>          libz.so.1 => /usr/lib/libz.so.1 (0xb7b51000)
>          libk5crypto.so.3 => /usr/lib/libk5crypto.so.3 (0xb7b2c000)
>          libresolv.so.2 =>
> /lib/tls/i686/cmov/libresolv.so.2 (0xb7b19000)
>          libkrb5support.so.0 => /usr/lib/libkrb5support.so.0 (0xb7b15000)
>
> cslibadmin at cslibff:/openils/bin$ sudo ldd
> /home/cslibadmin/evergreen_admin/eg-srcs/libdbi-drivers-0.8.2-1/drivers/pgsql/.libs/libdbdpgsql.so
>         linux-gate.so.1 =>  (0xffffe000)
>         libpq.so.5 => /usr/lib/libpq.so.5 (0xb7f32000)
>         libc.so.6 => /lib/tls/i686/cmov/libc.so.6 (0xb7df1000)
>         libssl.so.0.9.8 =>
> /usr/lib/i686/cmov/libssl.so.0.9.8 (0xb7db0000)
>         libcrypto.so.0.9.8 =>
> /usr/lib/i686/cmov/libcrypto.so.0.9.8 (0xb7c6e000)
>         libkrb5.so.3 => /usr/lib/libkrb5.so.3 (0xb7bf1000)
>         libcom_err.so.2 => /lib/libcom_err.so.2 (0xb7bee000)
>          libcrypt.so.1 => /lib/tls/i686/cmov/libcrypt.so.1
> (0xb7bc0000)
>         libpthread.so.0 =>
> /lib/tls/i686/cmov/libpthread.so.0 (0xb7ba9000)
>         /lib/ld-linux.so.2 (0x80000000)
>         libdl.so.2 => /lib/tls/i686/cmov/libdl.so.2 (0xb7ba4000)
>         libz.so.1 => /usr/lib/libz.so.1 (0xb7b90000)
>         libk5crypto.so.3 => /usr/lib/libk5crypto.so.3 (0xb7b6b000)
>         libresolv.so.2 => /lib/tls/i686/cmov/libresolv.so.2
> (0xb7b58000)
>         libkrb5support.so.0 => /usr/lib/libkrb5support.so.0 (0xb7b54000)
>
> I tried both locations but I can't find this line
>         libdbi.so.0 => /usr/lib/dbd/libdbi.so.0
> is that bad?
>
> > Message: 2
> > Date: Thu, 24 May 2007 09:12:17 -0400
> > From: "Dan Scott" <denials at gmail.com>
> > Subject: Re: [OPEN-ILS-DEV] Re: Open-ils-dev Digest, Vol 14, Issue 64
> > To: open-ils-dev at list.georgialibraries.org
> > Message-ID:
> >
> <fbb0d11d0705240612u540695a0w46eae5653b876628 at mail.gmail.com
> >
> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> >
> > Also, please ensure that libdbdpgsql.so is linked against libdbi.so as
> > described in this email:
> >
> http://list.georgialibraries.org/pipermail/open-ils-dev/2007-May/000928.html
> >
> > 1) Can you send us the results of the following commands?
> > $ locate libdbdpgsql.so
> > -- this will give you the location where the libdbi-driver was installed
> > $ ldd /path/to/libdbdpgsql.so
> >
> > You should see a line like:
> >        libdbi.so.0 => /usr/lib/dbd/libdbi.so.0
> >
> > Let us know.
> >
> > --
> > Dan Scott
> > Laurentian University
>
> DW you are quite right! I changed lines 523 and 609 and the error was gone.
> Thank you!
>
> cslibadmin at cslibff:/openils/bin$ sudo -u opensrf /openils/bin/autogen.sh
> ../conf/bootstrap.conf
> Updating fieldmapper
> Updating web_fieldmapper
> Updating OrgTree
> removing OrgTree from the cache...
> Updating OrgTree HTML
> Done
> cslibadmin at cslibff:/openils/bin$
>
> Now that OPAc seems to be ok, I better start adding data  :)
>
> ------------------------------
> > Message: 3
> > Date: Thu, 24 May 2007 10:10:44 -0400
> > From: "Dan Wells" <dbw2 at calvin.edu>
> > Subject: [OPEN-ILS-DEV] Re: Open-ils-dev Digest, Vol 14, Issue 64
> > To: < sayanslib at gmail.com>,
> <open-ils-dev at list.georgialibraries.org>
> > Message-ID: < 4655649B.3669.00F7.0 at calvin.edu>
> > Content-Type: text/plain; charset=US-ASCII
> >
> > Hello Mon,
> >
> > I am pretty sure I found your problem, and it is a rather insidious one :)
>  On lines 523 and 609 of your opensrf.xml file, you have:
> >
> > <driver>Pg</driver>
> >
> > This would be correct in some parts of the file but not in these two
> places.  Change these lines to read:
> >
> > <driver>pgsql</driver>
> >
> > When I tried changing to your values, I got your exact error message.  I
> was actually amazed :)
> >
> > You will need to stop and start OpenSRF.  When you stop it, please make
> sure to give it time to stop completely.  I usually just run ps ax until I
> don't see any more OpenSRF stuff.
> >
> > Good luck,
> > DW
> >
>