[OPEN-ILS-DEV] Re: Open-ils-dev Digest, Vol 14, Issue 64
Don McMorris
don.mcmorris at gmail.com
Thu May 24 04:55:02 EDT 2007
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
> >
> >
> >
>
>
>
More information about the Open-ils-dev
mailing list