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

Fri Jul 29 14:09:54 EDT 2011

Hey, guys

Evergreen 2.0.7 still doesn’t seem to like my .sql file. I'm still getting the xml_is_well_formed error trying to psql the file into the database. I tried "pg_restore", too. But, the database doesn't seem to like the format of the file. Renaming it doesn't help, either.

At this point, I will attempt to move forward with 1.4.0.6 and see where I can get. Thanks so much for everything, and I will keep you all updated.

Thanks!!

Elliot

-----Original Message-----
From: open-ils-dev-bounces at list.georgialibraries.org [mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of Elliot Voris
Sent: Friday, July 29, 2011 10:17 AM
To: Evergreen Development Discussion List
Subject: Re: [OPEN-ILS-DEV] Installation of Perl modules has failed

Thanks, Ben and Chris!

Since I had run the command "make -f Open-ILS/src/extras/Makefile.install install_pgsql_server_debs_84" I guess I assumed that all the necessary modules were automatically in place and ready to go.

I'll give this another go 'round today, using the links you guys have provided. I'll let you know as soon as it works/doesn't work/I need help.

Thanks, again!!

Elliot

-----Original Message-----
From: open-ils-dev-bounces at list.georgialibraries.org [mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of Ben Shum
Sent: Friday, July 29, 2011 10:07 AM
To: open-ils-dev at list.georgialibraries.org
Subject: Re: [OPEN-ILS-DEV] Installation of Perl modules has failed

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