[OPEN-ILS-DEV] Installation of Perl modules has failed

[Sharp, Chris]

Elliot,

Looking more closely at your error message:

> ERROR: function xml_is_well_formed(text) does not exist
> LINE 1: SELECT xml_is_well_formed( $1 )

That seems to indicate that the pgxml contrib module did not get installed.  Refer to Step 3 of the instructions here:

http://evergreen-ils.org/dokuwiki/doku.php?id=server:2.0:install

You'll probably want to run this command (as the postgres user):

psql -f /usr/share/postgresql/8.4/contrib/pgxml.sql     evergreen

(replacing "evergreen" with your actual database name if necessary).

Hope that helps,

Chris

----- Original Message -----
> From: "Elliot Voris" <evoris at slcconline.edu>
> To: "Evergreen Development Discussion List" <open-ils-dev at list.georgialibraries.org>
> Sent: Thursday, July 28, 2011 4:49:47 PM
> Subject: Re: [OPEN-ILS-DEV] Installation of Perl modules has failed
> Thank you so much for your help, Chris!
> 
> I'm at a small college with a library running on Evergreen. The server
> went down and we have a backed up pgdump (evergreen.sql). In trying to
> get the server up and running again, I tried installing Evergreen 2.0
> and importing the file into that server (psql evergreen <
> evergreen.sql).
> 
> The output from that was as follows:
> 
> postgres at server:~$ psql database < olddb.sql
> SET
> SET
> SET
> SET
> SET
> SET
> setval
> --------
> 23405
> (1 row)
> 
> ERROR: function xml_is_well_formed(text) does not exist
> LINE 1: SELECT xml_is_well_formed( $1 )
> 
> HINT: No function matches the given name and argument types. You might
> need to
> add explicit type casts
> QUERY: SELECT xml_is_well_formed( $1 )
> CONTEXT: PL/pgSQL function “check_marcxml_well_formed” line 3 at IF
> COPY record_entry, line 1: “-1 1 1 1 -1 2009-06-29 18:54
> :59.184263+00 2009-06-29 15:54:59.184263+00 f f AUTOGEN-
> 1 FOO”
> 
> I posted to the PostgreSQL mailing list about this, and the
> recommendation I received was to try and recreate the original server
> as best as I could, and follow the upgrade path after importing the
> data.
> 
> So, essentially, I have a .sql file from PostgreSQL 8.2 or 8.3 (not
> really sure, but I think 8.3) that I need to import into a new
> evergreen installation (old or new, doesn't bother me). If there is an
> easier way than what I am trying, I'd love to hear it. Even if there's
> a harder way, I'd love to hear it. We need this back up and running
> very soon.
> 
> Thanks, again for your help!
> 
> Elliot
> 
> -----Original Message-----
> From: open-ils-dev-bounces at list.georgialibraries.org
> [mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of
> Sharp, Chris
> Sent: Thursday, July 28, 2011 2:41 PM
> To: Evergreen Development Discussion List
> Subject: Re: [OPEN-ILS-DEV] Installation of Perl modules has failed
> 
> Elliot,
> 
> I just attempted to install OpenSRF-1.0.7 on Ubuntu 8.04 to try and
> replicate your issue, and I can replicated it. I saw some errors
> during the CPAN module installation section of the Makefile.install
> step, but I have not had a chance to see what did not get installed. I
> may be able to dig in a bit more later.
> 
> > I’m trying to install Evergreen 1.4.0.6 onto an Ubuntu 8.04.4
> > server.
> > I know it’s old, but for the sake of saving my data, I need to start
> > here.
> 
> Since OpenSRF 1.0.7 and Evergreen 1.4.0.6 are EOL as far as community
> support goes, this installation may not succeed (at least without a
> lot of shoehorning). Can you elaborate on the particulars of your
> situation? There may be alternative ways to get what you're trying to
> do done.
> 
> Chris
> 
> ----- Original Message -----
> > From: "Elliot Voris" <evoris at slcconline.edu>
> > To: open-ils-dev at list.georgialibraries.org
> > Sent: Thursday, July 28, 2011 1:40:46 PM
> > Subject: [OPEN-ILS-DEV] Installation of Perl modules has failed
> > Hello,
> > Everyone.
> >
> >
> >
> > I’m trying to install Evergreen 1.4.0.6 onto an Ubuntu 8.04.4
> > server.
> > I know it’s old, but for the sake of saving my data, I need to start
> > here.
> >
> >
> >
> > I’ve already install PostgreSQL on the same server, as outlined
> > here:
> > http://evergreen-ils.org/dokuwiki/doku.php?id=postgresql:8.2:debian
> >
> > I’m following the instructions to install OpenSRF here:
> > http://evergreen-ils.org/dokuwiki/doku.php?id=opensrf:1.0:install
> >
> >
> >
> > During the installation of OpenSRF, I get the errors. Everything
> > seems
> > to be working fine up to the point of performing “make install” as
> > root. The last bit of output that I can see is the following:
> >
> >
> >
> > t/07-Transport.t 8 2048 10 8 80.00% 1-3 5-8 10
> >
> > t/08-UnixServer.t 1 256 1 1 100.00% 1
> >
> > t/09-Utils.t 3 768 8 3 37.50% 1-2 7
> >
> > Failed 9/12 test scripts, 25.00% okay. 21/65 subtests failed, 67.69%
> > okay.
> >
> > make[5]: *** [test_dynamic] Error 255
> >
> > make[5]: Leaving directory ‘/home/opensrf/OpenSRF-1.0.7/src/perl’
> >
> > make[5]: Entering directory ‘/home/opensrf/OpenSRF-1.0.7/src’
> >
> >
> >
> > >>> Installation of Perl modules has failed. The most likely
> >
> > >>> possibility is that a dependency is not pre-installed
> >
> > >>> or that a test has failed.
> >
> > >>> Se the messages above this one for more information
> >
> >
> >
> > make[5]: *** [install-perl-fail] Error 1
> >
> > make[5]: Leaving directory ‘/home/opensrf/OpenSRF-1.0.7/src’
> >
> > make[4]: *** [install-perl] Error 2
> >
> > make[4]: Leaving directory ‘/home/opensrf/OpenSRF-1.0.7/src’
> >
> > make[3]: *** [install-exec-local] Error 2
> >
> > make[3]: Leaving directory ‘/home/opensrf/OpenSRF-1.0.7/src’
> >
> > make[2]: *** [install-am] Error 2
> >
> > make[2]: Leaving directory ‘/home/opensrf/OpenSRF-1.0.7/src’
> >
> > make[1]: *** [install-recursive] Error 1
> >
> > make[1]: Leaving directory ‘/home/opensrf/OpenSRF-1.0.7/src’
> >
> > make: *** [install-recursive] Error 1
> >
> >
> >
> > I don’t know how to interpret this, or how to get around it. I’m
> > assuming that something is not installed that needs to be installed.
> > However, I can’t figure it out. Isn’t the Makefile designed to
> > avoide
> > these kinds of errors? Does anyone know how I can move past this?
> >
> >
> >
> > Thanks, everyone!
> >
> >
> >
> > Elliot
> 
> --
> Chris Sharp
> PINES Program Manager
> Georgia Public Library Service
> 1800 Century Place, Suite 150
> Atlanta, Georgia 30345
> (404) 235-7147
> csharp at georgialibraries.org
> http://pines.georgialibraries.org/

-- 
Chris Sharp
PINES Program Manager
Georgia Public Library Service
1800 Century Place, Suite 150
Atlanta, Georgia 30345
(404) 235-7147
csharp at georgialibraries.org
http://pines.georgialibraries.org/