[OPEN-ILS-DEV] Re: Open-ils-dev Digest, Vol 14, Issue 64
Dan Scott
denials at gmail.com
Thu May 24 09:12:17 EDT 2007
On 24/05/07, Don McMorris <don.mcmorris at gmail.com> wrote:
> 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
>
>
>
> On 5/23/07, Pseudo Admin <sayanslib at gmail.com> wrote:
> >
> > > Hello Don,
> >
> > Here is the output when I run cslibadmin at cslibff:~$ psql -U [berde]
> > evergreen
> >
> > cslibadmin at cslibff:~$ psql -U berde evergreen
> > Password for user berde:
> > Welcome to psql 8.2.4, the PostgreSQL interactive terminal.
> >
> > Type: \copyright for distribution terms
> > \h for help with SQL commands
> > \? for help with psql commands
> > \g or terminate with semicolon to execute query
> > \q to quit
> >
> > evergreen=# SELECT * FROM actor.org_unit;
> > id | parent_ou | ou_type | ill_address | holds_address | mailing_address |
> > billing_address | shortname | name | email | phone |
> > opac_visible
> > ----+-----------+---------+-------------+---------------+-----------------+-----------------+-----------+----------------------+-------+-------+--------------
> > 1 | | 1 | 1 | 1 | 1 |
> > 1 | CONS | Example Consortium | | | t
> > 2 | 1 | 2 | 1 | 1 | 1 |
> > 1 | SYS1 | Example System 1 | | | t
> > 3 | 1 | 2 | 1 | 1 | 1 |
> > 1 | SYS2 | Example System 2 | | | t
> > 4 | 2 | 3 | 1 | 1 | 1 |
> > 1 | BR1 | Example Branch 1 | | | t
> > 5 | 2 | 3 | 1 | 1 | 1 |
> > 1 | BR2 | Example Branch 2 | | | t
> > 6 | 3 | 3 | 1 | 1 | 1 |
> > 1 | BR3 | Example Branch 3 | | | t
> > 7 | 3 | 3 | 1 | 1 | 1 |
> > 1 | BR4 | Example Branch 4 | | | t
> > 8 | 4 | 4 | 1 | 1 | 1 |
> > 1 | SL1 | Example Sub-lib 1 | | | t
> > 9 | 6 | 5 | 1 | 1 | 1 |
> > 1 | BM1 | Example Bookmobile 1 | | | t
> > (9 rows)
> >
> > evergreen=#
> > evergreen=# \q
> > cslibadmin at cslibff:~$
> >
> > I checked my opensrf.xml and it looks fine so I'm sending my configurations
> > and logs - openils.tar.bz2
> >
> > It is good to know that I did not make a mess with my configuration when I
> > used opensrf.xml :)
> >
> > thanks!
> >
> > Mon
> >
> >
> > > Message: 3
> > > Date: Wed, 23 May 2007 08:14:07 -0400
> > > From: "Don McMorris" <don.mcmorris at gmail.com>
> > > Subject: SPAM: Re: [OPEN-ILS-DEV] help with OPAC configuration
> > > To: open-ils-dev at list.georgialibraries.org,
> > sayanslib at gmail.com
> > > Message-ID:
> > >
> > <f2b02f1e0705230514n7fc2658encdf7468f8d769b7a at mail.gmail.com
> > >
> > > Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> > >
> > > HI Mon:
> > >
> > > This message is sent both to you and the list. The troubleshooting
> > > process and eventual solution will be beneficial to the community, and
> > > the reply to you will bypass the digest.
> > >
> > > My initial hunch is a database issue. Would you run the following,
> > > and report the output to us?:
> > > user$: su postgres -c "psql openils"
> > > openils=# SELECT * FROM actor.org_unit;
> > > [[output]]
> > > openils=# \q
> > >
> > > the "openils" in this case is the database name. If you are using a
> > > different name, you can change this. If you'd rather connect to the
> > > database as a different user, your command would look like:
> > > user$: psql -U [user] openils
> > >
> > > Basically, here's how it'd work...
> > > If you have an output similar to:
> > > openils=# SELECT * from actor.org_unit;
> > > id | parent_ou | ou_type | ill_address | holds_address |
> > > mailing_address | billing_address | shortname | name |
> > > email | phone | opac_visible
> > >
> > ----+-----------+---------+-------------+---------------+-----------------+-----------------+-----------+----------------------+-------+-------+--------------
> > > 1 | | 1 | 1 | 1 |
> > > 1 | 1 | CONS | Example Consortium | |
> > > | t
> > > 2 | 1 | 2 | 1 | 1 |
> > > 1 | 1 | SYS1 | Example System 1 | |
> > > | t
> > > 3 | 1 | 2 | 1 | 1 |
> > > 1 | 1 | SYS2 | Example System 2 | |
> > > | t
> > > 4 | 2 | 3 | 1 | 1 |
> > > 1 | 1 | BR1 | Example Branch 1 | |
> > > | t
> > > 5 | 2 | 3 | 1 | 1 |
> > > 1 | 1 | BR2 | Example Branch 2 | |
> > > | t
> > > 6 | 3 | 3 | 1 | 1 |
> > > 1 | 1 | BR3 | Example Branch 3 | |
> > > | t
> > > 7 | 3 | 3 | 1 | 1 |
> > > 1 | 1 | BR4 | Example Branch 4 | |
> > > | t
> > > 8 | 4 | 4 | 1 | 1 |
> > > 1 | 1 | SL1 | Example Sub-lib 1 | |
> > > | t
> > > 9 | 6 | 5 | 1 | 1 |
> > > 1 | 1 | BM1 | Example Bookmobile 1 | |
> > > | t
> > > (9 rows)
> > > then the database is probably OK (check your configuration to see if
> > > your hostname/user/password/database names are all right in the
> > > opensrf.xml config.
> > >
> > > If you get 0 rows, then go back to bootstrapping and make sure you
> > > have at least 1 OU.
> > >
> > > If you get an error that the relation doesn't exist, you probably have
> > > an issue that prevented the data from loading into the database. If
> > > this is the issue, we can tackle it then.
> > >
> > >
> > > Just a comment also... openils.xml is depreciated in 1.1x and later.
> > > It's all in opensrf.xml now. Your modified directions are correct!
> > > I'll make a note on the documentation (1.0.x still uses open-ils.xml).
> > >
> > > If the database looks fine and your configuration looks correct, would
> > > you mind sending us your configurations and logs? You can do this as
> > > follows:
> > > user$ su opensrf
> > > opensrf$ mkdir /tmp/openils
> > > opensrf$ cp -Rv /openils/{var/log,conf} /tmp/openils
> > > opensrf$ cd /tmp/openils/conf
> > > /* Take this moment to go through the conf and sanitize it of any
> > > sensitive passwords */
> > > opensrf$ cd /tmp
> > > opensrf$ tar -cjf openils.tar.bz2 openils/
> > >
> > > and send us openils.tar.bz2.
> > >
> > > Talk to you soon!
> > > --Don
> > >
> > >
> > >
> >
> >
> >
>
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
More information about the Open-ils-dev
mailing list