[OPEN-ILS-DEV] Debian VMWare image updated to 1.2.2.1

2008-06-16 Thread Dan Scott
I have updated the Debian VMWare image to Evergreen 1.2.2.1. Along
with the version upgrade, I have included the following additional
features:

  * Gutenberg records are preloaded in the database
  * Reporter is ready to run out of the box
  * VMWare tools have been updated to VMWare 1.0.5

You can download the image from http://open-ils.org/downloads.php ;
instructions for using the image are included in a README file in the
Evergreen_Debian directory when you unzip the file.

-- 
Dan Scott
Laurentian University


Re: [OPEN-ILS-DEV] Reporter and classic views

2008-06-16 Thread evergreen
Thanks Dan.  That did it!Good way to start the week!  
Robert
  


On Sun Jun 15 23:20 , Dan Scott  sent:

2008/6/15  [EMAIL PROTECTED]:
 I setup a template using the Classic Item List source.  When running the
report the following
 error message is given in the output folder list:
 DBD::Pg::st execute failed: ERROR:  relation reporter.classic_item_list
does not exist

 The same happens with classic_current_circ.  Other Sources seem to work ok.

These sources are defined in
Evergreen-ILS-1.2.2.1/Open-ILS/src/sql/Pg/example.reporter-extension.sql
(adjust to your version of Evergreen), which is not installed by
default. You can run a command like:

psql -U evergreen -h localhost -f example.reporter-extension.sql

if you want to create them.

-- 
Dan Scott
Laurentian University




[OPEN-ILS-DEV] Evergreen on Red Hat Linux

2008-06-16 Thread Frances Dean McNamara
I wanted to share the below information with the list.  The suggested fix did 
work.  Dale was able to run autogen to completion last week.  Unfortunately, we 
still cannot log on with the client, however!  We need to fix that so we can 
load bibs and items.

Frances McNamara
University of Chicago

-Original Message-
From: Dan Wells [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2008 10:38 AM
To: Frances Dean McNamara
Subject: Re: FW: Evergreen progress

Hello Frances,

If you are using libdbi-0.8.3 (the latest version), there is a problem with the 
configure scripts that causes the --enable-libdbi to actually DISable linking, 
as linking is now the default behavior.  So, when building the drivers, make 
sure to leave that switch out completely:

./configure --disable-docs --with-pgsql

I have alerted the libdbi developers, and they confirmed the bug, but I don't 
think a fix will be rolled in until the next release.

Let me know if this helps,
Dan

 Frances Dean McNamara [EMAIL PROTECTED] 6/12/2008 9:16 AM 
Dan,

I noticed in a recent list posting you said you have moved to Red Hat.  We are 
almost there with getting our installation running but have run into the below 
problem.  As you can see, we're working with Bill Erickson, but I thought it 
was worth asking whether you have seen this problem.  Thanks.

Frances McNamara
University of Chicago



RE: [OPEN-ILS-DEV] Re: [Support] Installing staff clients onnon-privileged Windows accounts

2008-06-16 Thread Murphy, S.K.
Hi, Brandon -

I've seen this happen with Windows Mandatory user accounts (these are
the accounts Jason refered to that wipe out any changes to the user's
'Documents and Settings' folder upon logout).

Here's Microsoft's page on assigning mandatory profiles.
http://support.microsoft.com/kb/q307800/

I believe to change a profile away from 'mandatory', you can just change
their Ntuser.man file to be named Ntuser.dat. (If the profile is
manadtory, then 'Ntuser.man' is found under C:\Documents and
Settings\Windows Login Name\).


Hope that helps!
-Murph

Some say the world will end in fire and ice.  Others say it will be
segfaults.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Jason Etheridge
Sent: Thursday, June 12, 2008 10:54 PM
To: Brandon W. Uhlman
Cc: open-ils-dev@list.georgialibraries.org
Subject: [OPEN-ILS-DEV] Re: [Support] Installing staff clients
onnon-privileged Windows accounts

 We've run into a problem on some of our Windows XP staff clients where
users
 without Administrator rights don't seem to retain workstation
registrations.
 I'm pretty sure this is because the file ws_info is not being written.
Are
 there any magic suggestions that people have other than using
Evergreen on
 user accounts with Administrator rights? Or, are Administrator rights
in
 fact, required?

For installation, Administrator rights are not necessarily required,
depending on where you try to install the client (if you install to
your Desktop, for example, you should not need Admin rights).

For regular use, Administrator rights should not be required as long
as the prefs.js file in the installation directory has a line reading
pref(open-ils.write_in_user_chrome_directory, true);

 In Windows XP, this would make files like ws_info get written in a
directory resembling this: C:\Documents and
Settings\phasefx\Application
Data\OpenILS\open_ils_staff_client\Profiles\dqh08qrd.default\chrome\

Now, I have seen Windows systems protected in such a way where files
in C:\Documents and Settings\ gets purged after the Windows user logs
off.  I'm not sure how this is done, or whether that's what is
affecting you.

One thing you could do is run the staff client with the debug window
open.  This explains how:
http://open-ils.org/dokuwiki/doku.php?id=scratchpad:debug_console

That'll actually show you the path used for ws_info, and you can then
more easily watch the behavior from Windows and see if the file gets
created in the first place or deleted after the fact.

Let us know if this helps!

-- 
Jason Etheridge
 | VP, Community Support and Advocacy
 | Equinox Software, Inc. / The Evergreen Experts
 | phone: 1-877-OPEN-ILS (673-6457)
 | email: [EMAIL PROTECTED]
 | web: http://www.esilibrary.com




[OPEN-ILS-DEV] offline blocked list

2008-06-16 Thread Bill Ott

Strange doings with the offline blocked list.

When running offline-blocked-list.pl, I end up missing one user.  I 
don't see any rhyme or reason for which user it drops, but it seems 
consistent.


For instance, I currently have 4 users set to barred:

evergreen=# select count(*) from actor.usr where barred = 't';
count
---
4



When I run the script, I only receive 3:

$ /openils/bin/offline-blocked-list.pl /home/opensrf/.srfsh.xml srfsh
- echo open-ils.storage open-ils.storage.actor.user.lost_barcodes | 
/openils/bin/oils_requestor -f /home/opensrf/.srfsh.xml -c srfsh -h 
blade9.grpl.org
- echo open-ils.storage open-ils.storage.actor.user.barred_barcodes | 
/openils/bin/oils_requestor -f /home/opensrf/.srfsh.xml -c srfsh -h 
blade9.grpl.org

16822707 B
P19751013 B
910911 B
- echo open-ils.storage 
open-ils.storage.actor.user.penalized_barcodes | 
/openils/bin/oils_requestor -f /home/opensrf/.srfsh.xml -c srfsh -h 
blade9.grpl.org





Re: [OPEN-ILS-DEV] SPAM: Error loading libdbi driver

2008-06-16 Thread Dan Scott
Hi Dale:

2008/6/16 Dale Arntson [EMAIL PROTECTED]:
 Hi All,

 I working on installing Evergreen on Redhat , and I've run into a libdbi
 driver problem. When I start up evergreen I get this error in the
 osrfsys.log:

 open-ils.cstore 2008-06-16 13:56:08 [DEBG:18124:oils_cstore.c:218:]
 Attempting to initialize libdbi...
 open-ils.cstore 2008-06-16 13:56:08 [DEBG:18124:oils_cstore.c:220:] ...
 libdbi initialized.
 open-ils.cstore 2008-06-16 13:56:08 [DEBG:18124:oils_cstore.c:230:]
 Attempting to load the database driver [Pg]...
 open-ils.cstore 2008-06-16 13:56:08 [ERR :18124:oils_cstore.c:234:] Error
 loading database driver [Pg]

The error messages might be throwing you off here. I'm pretty sure
that running settings-tester.pl will tell you that the driver for
open-ils.cstore (in opensrf.xml) needs to be set to pgsql, not Pg.

If the language element is C, then the driver element must be pgsql.

If the language element is perl, then the driver element must be Pg.

And before you ask... at some point, a port to a different database
may become available, which is why these settings can't simply be
collapsed into one.

-- 
Dan Scott
Laurentian University


Re: [OPEN-ILS-DEV] SPAM: Error loading libdbi driver

2008-06-16 Thread Dale Arntson

Hi Dan,

Thanks for pointing this out. This is how I had it before. However, when 
I set the driver entry under open-ils.cstore and open-ils.reporter-store 
in opensrf.xml back to pgsql, I get the same result.


-dale

Dan Scott wrote:

Hi Dale:

2008/6/16 Dale Arntson [EMAIL PROTECTED]:

Hi All,

I working on installing Evergreen on Redhat , and I've run into a libdbi
driver problem. When I start up evergreen I get this error in the
osrfsys.log:

open-ils.cstore 2008-06-16 13:56:08 [DEBG:18124:oils_cstore.c:218:]
Attempting to initialize libdbi...
open-ils.cstore 2008-06-16 13:56:08 [DEBG:18124:oils_cstore.c:220:] ...
libdbi initialized.
open-ils.cstore 2008-06-16 13:56:08 [DEBG:18124:oils_cstore.c:230:]
Attempting to load the database driver [Pg]...
open-ils.cstore 2008-06-16 13:56:08 [ERR :18124:oils_cstore.c:234:] Error
loading database driver [Pg]


The error messages might be throwing you off here. I'm pretty sure
that running settings-tester.pl will tell you that the driver for
open-ils.cstore (in opensrf.xml) needs to be set to pgsql, not Pg.

If the language element is C, then the driver element must be pgsql.

If the language element is perl, then the driver element must be Pg.

And before you ask... at some point, a port to a different database
may become available, which is why these settings can't simply be
collapsed into one.



Re: [OPEN-ILS-DEV]: Error loading libdbi driver

2008-06-16 Thread Dale Arntson
I ran settings-tester.pl and it confirms that I have the right driver 
names in the right places.


-dale

Dale Arntson wrote:

Hi Dan,

Thanks for pointing this out. This is how I had it before. However, when 
I set the driver entry under open-ils.cstore and open-ils.reporter-store 
in opensrf.xml back to pgsql, I get the same result.


-dale

Dan Scott wrote:

Hi Dale:

2008/6/16 Dale Arntson [EMAIL PROTECTED]:

Hi All,

I working on installing Evergreen on Redhat , and I've run into a libdbi
driver problem. When I start up evergreen I get this error in the
osrfsys.log:

open-ils.cstore 2008-06-16 13:56:08 [DEBG:18124:oils_cstore.c:218:]
Attempting to initialize libdbi...
open-ils.cstore 2008-06-16 13:56:08 [DEBG:18124:oils_cstore.c:220:] ...
libdbi initialized.
open-ils.cstore 2008-06-16 13:56:08 [DEBG:18124:oils_cstore.c:230:]
Attempting to load the database driver [Pg]...
open-ils.cstore 2008-06-16 13:56:08 [ERR :18124:oils_cstore.c:234:] 
Error

loading database driver [Pg]


The error messages might be throwing you off here. I'm pretty sure
that running settings-tester.pl will tell you that the driver for
open-ils.cstore (in opensrf.xml) needs to be set to pgsql, not Pg.

If the language element is C, then the driver element must be pgsql.

If the language element is perl, then the driver element must be Pg.

And before you ask... at some point, a port to a different database
may become available, which is why these settings can't simply be
collapsed into one.



Re: [OPEN-ILS-DEV] SPAM: Error loading libdbi driver

2008-06-16 Thread Dan Scott
2008/6/16 Dale Arntson [EMAIL PROTECTED]:
 Hi Dan,

 Thanks for pointing this out. This is how I had it before. However, when I
 set the driver entry under open-ils.cstore and open-ils.reporter-store in
 opensrf.xml back to pgsql, I get the same result.


Hmm. That really doesn't make sense; I would expect a different set of
errors, at the least. open-ils.cstore should not be trying to load Pg
as a driver.

I noticed in your opensrf.xml file that you're pointing to
/opt/openils in most cases. Is there any chance that
settings-tester.pl is checking the wrong version of opensrf_core.xml /
opensrf.xml? By default, it reads /openils/conf/opensrf_core.xml and
figures out which opensrf.xml to read from there: you can use the
--config option to override this if need be.

I should also point out that while in theory using a prefix other than
/openils/ should work, very few people (perhaps none) have actually
tried that out in practice. It's possible you may be running into some
hardcoded assumptions about file placement. You might want to keep
things as simple as possible to start with by sticking with /openils/
for now and keeping the number of changes to opensrf_core.xml and
opensrf.xml to a minimum.

-- 
Dan Scott
Laurentian University