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

[Ben Shum]

Hi Elliot,

Looks like Chris nailed an important part of the database restore process.

I'd like to point you also to this wiki page: 
http://evergreen-ils.org/dokuwiki/doku.php?id=evergreen-admin:maintenance:backups

The section entitled "Backing up the Evergreen database" includes some
generic steps for starting a new Evergreen database and restoring from a
dump file.

My recommendation would be to use a newer version of PostgreSQL (8.4 or
9.0) so that you'll be ready for upgrading to newer Evergreen version as
well.  If you're going by the steps in the Evergreen install process,
you'd want to reload the database and run update SQL (see
http://evergreen-ils.org/dokuwiki/doku.php?id=upgrading:evergreen for
some broad steps in how that might be done) instead of creating a fresh
database schema.

Feel free to ask more questions via mailing list or come poke some of us
in the Evergreen IRC channel too.

-- Ben

On 07/29/2011 07:57 AM, Sharp, Chris wrote:
> 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/

-- 
Benjamin Shum
Open Source Software Coordinator
Bibliomation, Inc.
32 Crest Road
Middlebury, CT 06762
203-577-4070, ext. 113