Re: [OPEN-ILS-DEV] Installation issues/problems Thanks but ...one more problem ;

2008-09-17 Thread Don McMorris
Hi Thomas,

On Wed, Sep 17, 2008 at 12:45 AM, Thomas Edward [EMAIL PROTECTED]wrote:


 Hi Dan,

 Your email was quick and a huge help. I am even more excited about Evergreen. 
 I have one problem though:
 When I initiate the apache server (section: Starting the Web server) I get 
 the following error message.

 ---
 [EMAIL PROTECTED]:~# /etc/init.d/apache2 start
 * Starting web server apache2 apache2: Could not reliably determine the 
 server's fully qualified domain name, using 127.0.1.1 for ServerName
 (98)Address already in use: make_sock: could not bind to address 0.0.0.0:443
 no listening sockets available, shutting down
 Unable to open logs
 --

 This indicates that you something listening on port 443 (HTTPS).  As root,
running 'netstat -anp | grep LISTEN' should show the programs listening for
connections.  Look for a line like:
 tcp0  0 0.0.0.0:4430.0.0.0:*
LISTEN  /program-name



 I have examine the following flies for clues:
 /etc/apache2/sites-available/eg.conf
 /etc/apache2/eg_vhost.conf
 /etc/apache2/startup.pl
 /openils/conf/opensrf_core.xml
 /openils/conf/opensrf.xml

 Also, why is the IP address given as 127.0.1.1 and not 127.0.0.1?

 This is a Debian thing.  In reality, every IP beginning with 127 (IE:
127.0.0.0-127.255.255.255) is the same (loopback).  That particular about
Unable to reliably determine fully qualified domain name can be ignored.


 -


 note also the outputfor the fqdn:
 [EMAIL PROTECTED]:/etc/apache2/sites-available# perl -MNet::Domain -e 'print 
 Net::Domain::hostfqdn();'
 thomas-desktop.uwichill.edu.bb
 --

 which is the same as is in the /openils/conf/opensrf.xml file.

 Were you able to start OpenSRF services OK? It's important to note the
distinction between the opensrf services and the apache web server.  the
/openils/conf stuff refers to the opensrf services, and /etc/apache2 stuff
refers to the apache stuff.  From this level, they are pretty independent
(they communicate at an application level, but are independent at this
stage).

--Don




 Anxiously waiting your response.

 Thomas


 Thomas


 Rebirth, renew, Starting a new Life.



 
  Date: Sun, 14 Sep 2008 20:23:28 -0400
  From: [EMAIL PROTECTED]
  To: open-ils-dev@list.georgialibraries.org
  Subject: Re: [OPEN-ILS-DEV] Installation issues/problems
 
  Hi Thomas:
 
  2008/9/14 Thomas Edward :
 
  Hi,
 
  I have installed Evergreen server on Ubuntu 7.10 and have followed all the 
  instructions on 
  http://open-ils.org/dokuwiki/doku.php?id=installing_evergreen_1.2_on_ubuntu_7.10.
   I have a small lab with four machines whic dual boot Windows Vista and 
  Linux Unbuntu 7.10. This is a exercise for me but I'd like to demo to the 
  local library.
 
  Issue #1.
  When I run instruction 2 (i) under Starting Evergreen I get the 
  following error message.
 
  [EMAIL PROTECTED]:/home/thomas# su opensrf
  [EMAIL PROTECTED]:/home/thomas$ osrf_ctl.sh -c 
  /openils/conf/opensrf_core.xml -a start_router
  Starting OpenSRF Router
   Unable to connect router to jabber server localhost... exiting
 
  I think this is the big problem - it's mirrored by the error that you
  got in settings-tester.pl.
 
  Checking opensrf_core.xml, you have two different passwords for the
  opensrf Jabber user - mypass and mypassword. These passwords
  have to be correct so that the opensrf Jabber user can connect to
  Jabber and talk to the router Jabber user
 
  Issue #2
  Quote from instruction document: Instruction 17 (ii)
  Change the name of the child element of the element in opensrf.xml from 
  ... to match the fully-qualified domain name of your server. For example, 
  if the fully-qualified domain name of your server is evergreen.rocks.com:
 
  I have run the instruction perl -MNet::Domain -e 'print 
  Net::Domain::hostfqdn()
 
  but get this output:
  [EMAIL 
  PROTECTED]:/home/opensrf/Evergreen-ILS-1.2.2.3/Open-ILS/src/support-scripts#
   perl -MNet::Domain -e 'print Net::Domain::hostfqdn()
 
 What do you think the problem might be?
 
  You're missing the ending semicolon-singlequote characters for the
  command; it should be:
 
  perl -MNet::Domain -e 'print Net::Domain::hostfqdn();'
 
 
  Issue #3
  I have executed the file Open-ILS/src/support-scripts/settings-tester.pl 
  and haveattached the results for your analysis. Teh file is called 
  settings-tester-results.
 
  The list of Perl modules shows that Net::Z3950::ZOOM wasn't installed
  successfully, probably because indexdata's test server is still down.
  See 
  http://list.georgialibraries.org/pipermail/open-ils-general/2008-August/000838.html
  for details and a workaround. You won't need this until you get the
  staff client running, though, so no rush.
 
  We also see the failure to connect to the Jabber router, which I
  covered in issue 1.
 
  Issue #4
  Quote from instruction document:Section Testing connections to 

[OPEN-ILS-DEV] Prerequisite OS Load Problem (Ubunto 7.10)

2008-09-17 Thread LaBon S. Hardy
Good Afternoon

 

In the prerequisite OS Load (Ubuntu 7.10), during the sudo make -f
Makefile.install ubuntu I get this error:

 

http://ftp.indexdata.dk/pub/yaz/yaz-2.1.56.tar.gz

   ='yaz-2.1.56.tar.gz'

Connecting to ftp.indexdata.dk|83.133.64.60|:80...

 Failed:  connection timed out.

   Giving Up

Make: ***[install-yaz] Error 1

 

Any idea on how to correct this prerequisite problem?

 

Thanks you for your assistance

 

 

LaBon S. Hardy

Information Technology  Infrastructure Manager

Innovation and Technology Department

South Carolina State Library

P.O. Box 11469, 1500 Senate Street, Columbia, SC  29211

Phone:  (803)734-8627  Fax: (803)732-4757

[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 

www.statelibrary.sc.gov http://www.statelibrary.sc.gov 

 

The South Carolina State Library is a national model for innovation,
collaboration, leadership and effectiveness.  It is the keystone in
South Carolina's intellectual landscape.

 

 

 

 



[OPEN-ILS-DEV] action.pm - reshelving.complete

2008-09-17 Thread Bill Ott

Has anyone run reshelving_complete.srfsh from trunk?

I was playing with the circ.reshelving_complete.interval value within 
actor.org_unit_setting, under a 1.2.x release, when I received the 
following, which doesn't seem version related, but just SQL syntax...(?)



Status:  *** Call to 
[open-ils.storage.action.circulation.reshelving.complete] failed for 
session [1221675859.851948.122167585930291], thread trace [1]:
DBD::Pg::st execute failed: ERROR:  column setting.value must appear 
in the GROUP BY clause or be used in an aggregate function

[for StatementUPDATE  asset.copy
 SET   status = 0
 WHERE id IN (
   SELECT  id
 FROM  (SELECT cp.id, MAX(circ.checkin_time)
 FROM  asset.copy cp
   JOIN action.circulation circ ON 
(circ.target_copy = cp.id)

   LEFT JOIN actor.org_unit_setting setting
   ON (cp.circ_lib = 
setting.org_unit AND setting.name = 'circ.reshelving_complete.interval')

 WHERE circ.checkin_time IS NOT NULL
   AND cp.status = 7
 GROUP BY 1
 HAVING MAX(circ.checkin_time)  NOW() - 
CAST( COALESCE( BTRIM( setting.value,'' ), ? )  AS INTERVAL)

   ) AS foo
   UNION ALL
   SELECT  cp.id
  FROM asset.copy cp
   LEFT JOIN actor.org_unit_setting setting
   ON (cp.circ_lib = setting.org_unit AND 
setting.name = 'circ.reshelving_complete.interval')
   LEFT JOIN action.circulation circ ON 
(circ.target_copy = cp.id AND circ.id IS NULL)

 WHERE cp.status = 7
   AND cp.create_date  NOW() - CAST( COALESCE( 
BTRIM( setting.value,'' ), ? )  AS INTERVAL)

 )
 with ParamValues: 1='24h', 2='24h'] at 
/usr/share/perl5/DBIx/ContextualFetch.pm line 52.






Re: [OPEN-ILS-DEV] Prerequisite OS Load Problem (Ubunto 7.10)

2008-09-17 Thread Jason Etheridge
 I guess I misunderstood the problem, sorry about that.

No, I think you had it right and Dan Scott and I jumped the gun
thinking it was an issue with yaz testing stage in CPAN.

-- 
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


RE: [OPEN-ILS-DEV] Installation issues/problems Thanks but ...one more problem ;

2008-09-17 Thread Thomas Edward


Hi Dan,

I hate to be a bother but I still have the same problem;  I have reviewed all 
files mentioned in the installation document.

1.  Apache

*
[EMAIL PROTECTED]:/etc/apache2/ssl# /etc/init.d/apache2 start
 * Starting web server apache2 apache2: Could not reliably determine the 
server's fully qualified domain name, using 127.0.1.1 for ServerName
httpd (pid 14277) already running
*



The contents of the /etc/hosts flie is as follows:

*
127.0.0.1   localhost
127.0.1.1   thomas-desktop

# The following lines are desirable for IPv6 capable hosts
::1 ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
ff02::3 ip6-allhosts
~
*


2.  Staff client:
 When I  insert the server name (thomas-desktop.uwichill.edu.bb) re-Test 
Server, I get the following error message:


This server does not support your version of staff client.  
Please check with the system administrator.
*

I have tried both versions for Windows: versions 1.2.3.0 and 1.2.2.2
Ping work fine and I can reach thomas-desktop.uwichill.edu.bb



Looking forward to your assistance.

Thomas



Thomas
 
Rebirth, renew, Starting a new Life.  
 


 Date: Wed, 17 Sep 2008 10:04:27 -0400
 From: [EMAIL PROTECTED]
 To: open-ils-dev@list.georgialibraries.org
 Subject: Re: [OPEN-ILS-DEV] Installation issues/problems Thanks but ...one   
 more problem ; 
 
 Also...
 
 2008/9/17 Don McMorris :
 Hi Thomas,

 On Wed, Sep 17, 2008 at 12:45 AM, Thomas Edward 
 wrote:


 Hi Dan,

 Your email was quick and a huge help. I am even more excited about
 Evergreen. I have one problem though:
 When I initiate the apache server (section: Starting the Web server) I get
 the following error message.


 ---
 [EMAIL PROTECTED]:~# /etc/init.d/apache2 start
 * Starting web server apache2 apache2: Could not reliably determine the
 server's fully qualified domain name, using 127.0.1.1 for ServerName

 (98)Address already in use: make_sock: could not bind to address
 0.0.0.0:443
 no listening sockets available, shutting down
 
 Also note step 7 of Installing on Ubuntu 7.10 instructions
 (http://open-ils.org/dokuwiki/doku.php?id=installing_evergreen_1.2_on_ubuntu_7.10):
 
 
 7. As the root user, edit /etc/apache2/sites-available/eg.conf:
 
1.  Change Allow from 10.0.0.1/8 to Allow from all (to enable
 access to the configuration CGI scripts from any workstation on any
 network - note that you must secure this for a production instance,
 preferably by locking down the allowed IP addresses and adding
 authentication, because you don't want just anyone adding and deleting
 libraries from your Evergreen instance!)
 
2.  Delete the line Listen 443 as it conflicts with the same
 declaration in /etc/apache2/ports.conf.
 
 
 -- 
 Dan Scott
 Laurentian University

_
Discover the new Windows Vista
http://search.msn.com/results.aspx?q=windows+vistamkt=en-USform=QBRE

Re: [OPEN-ILS-DEV] Installation issues/problems Thanks but ...one more problem ;

2008-09-17 Thread Dan Scott
Hi Thomas:

2008/9/17 Thomas Edward [EMAIL PROTECTED]:


 Hi Dan,

 I hate to be a bother but I still have the same problem;  I have reviewed all 
 files mentioned in the installation document.

 1.  Apache

 *
 [EMAIL PROTECTED]:/etc/apache2/ssl# /etc/init.d/apache2 start
  * Starting web server apache2 apache2: Could not reliably determine the 
 server's fully qualified domain name, using 127.0.1.1 for ServerName
 httpd (pid 14277) already running
 *

You can ignore the Could not reliably determine...  message, that's
just noise.

As for the httpd (pid 14277) already running), did you stop apache2
before trying to start it again?

 2.  Staff client:
  When I  insert the server name (thomas-desktop.uwichill.edu.bb) re-Test 
 Server, I get the following error message:

 
 This server does not support your version of staff client.
 Please check with the system administrator.
 *

 I have tried both versions for Windows: versions 1.2.3.0 and 1.2.2.2
 Ping work fine and I can reach thomas-desktop.uwichill.edu.bb

When you install Evergreen, if you issue sudo make
STAFF_CLIENT_BUILD_ID=rel_1_2_3_0 install then it will install the
server part of the staff client in a directory that the packaged
Windows staff client can find.

Otherwise, you'll need to issue the following commands (where
200809dd.hhmmss is replaced by whatever the newest directory in
/openils/var/web/xul is):

cd /openils/var/web/xul
sudo ln -sf 200809dd.hhmmss rel_1_2_3_0

-- 
Dan Scott
Laurentian University


Re: [OPEN-ILS-DEV] Installation issues/problems Thanks but ...one more problem ;

2008-09-17 Thread Dan Scott
Hi Thomas:

2008/9/18 Thomas Edward [EMAIL PROTECTED]:

 Dan,

  Thanks for your help but I'm still here. It is obvious that I'm  missing 
 something here. When I run the instructions which you gave I get the 
 following:

 XX
 [EMAIL PROTECTED]:/home/opensrf/Evergreen-ILS-1.2.2.3# make
 Building...

 -- [ openils_all ] ---

 c_apps
 oils_auth.so
 oils_cstore.so
 oils_rstore.so
 oils_dataloader
 client-xul
 Building staff client

 Removing convenience symlinks from server/ and chrome/ before copying to 
 build/

 *  Kludge, make sure 
 these directories exists

 *  Creating and 
 populating build/


 * Grabbing lang.dtd 
 from the OPAC code

 * Grabbing more OPAC 
 code and legacy code and custom code


 * Placeholder for 
 debugging tweaks

 Stamping with Build ID: 20080918.002019


 To test the staff client:
  cd build/
  xulrunner application.ini


 mod_xmlent
 [EMAIL PROTECTED]:/home/opensrf/Evergreen-ILS-1.2.2.3# 
 STAFF_CLIENT_BUILD_ID=rel_1_2_3_0 install
 install: missing file operand
 Try `install --help' for more information.
 [EMAIL PROTECTED]:/home/opensrf/Evergreen-ILS-1.2.2.3#
 XX

 I am definitely not doing something right.  The requisite directory shows 
 that the expected version of the staf-client software is 1.2.2.0
 
 [EMAIL PROTECTED]:/openils/var/web/xul$ ls -l
 total 8
 drwxr-xr-x 3 opensrf opensrf 4096 2008-09-08 21:22 20080908.212011
 drwxr-xr-x 3 opensrf opensrf 4096 2008-09-18 00:18 20080918.001753
 lrwxrwxrwx 1 opensrf opensrf   15 2008-09-17 23:55 rel_1_2_3_0 - 
 20080917.234045
 lrwxrwxrwx 1 opensrf opensrf   18 2008-09-16 23:46 server - 
 rel_1_2_2_0/server
 xx

Hmm. I may be getting confused by spending too much time with the
upcoming 1.4 release. Let's try a slightly modified version of these
instructions:

(as root):

rm /openils/var/web/xul/rel_1_2_3_0
rm /openils/var/web/xul/server
make STAFF_CLIENT_BUILD_ID=rel_1_2_3_0 all
make STAFF_CLIENT_BUILD_ID=rel_1_2_3_0 install

You should then be able to use the Windows rel_1_2_3_0 client to connect.

-- 
Dan Scott
Laurentian University