[OPEN-ILS-DEV] Open-ils-dev Digest, Vol 38, Issue 5

Dibyendra Hyoju dibyendra at gmail.com
Tue May 12 02:40:57 EDT 2009


Hello everyone,

I am still trying to get Evergreen working, but I am still stuck into same
authentication error. I still doubt that the problem is due to the script
"eg_db_config.pl" which couldn't update the opensrf.xml file with database
authentication information. Evergreen couldn't connect the PostgreSQL server
due to this problem. I don't know whether manul editing the information in
opensrf.xml works or not, but still I will try that as well. If anyone has
faced similar problem, please share your experience. Your help will be
highly appreciated.

Thank you.

On Fri, May 8, 2009 at 11:46 AM, Dibyendra Hyoju <dibyendra at gmail.com>wrote:

> Hello Dan,
>
> Thank you very much for your response.
>
> After making appropriate changes on the earlier command, that command
> worked well, apart from some errors that occurred during the execution of
> that script such as 'psql:extend-reporter.sql:17: ERROR:  schema
> "extend_reporter" does not exist', 'psql:reporter-schema.sql:18: ERROR:
> schema "reporter" does not exist', etc.
>
> After running the settings-tester.pl, it still reported the same problem
> about connecting to PostgreSQL database. I have attached the partial result
> from settings-tester.pl, so as to show the progress and make the problem
> more clear. One thing that I noticed after viewing the opensrf.xml was that
> the script "eg_db_config.pl" didn't alter the opensrf.xml. Probably, I might
> be wrong but I noticed none of the nodes about database contain required
> information.
>
> I have picked one of the node from opensrf.xml as a sample which looks like
> follows:
>
>  <database>
>                         <type>master</type>
>                         <weight>2</weight>
>                         <user/>
>                         <host/>
>                         <port/>
>                         <pw/>
>                         <db/>
>                         <client_encoding>UTF-8</client_encoding>
> </database>
>
> And, I have also copied the content of the files, "live-db-setup.pl" and
> "offline-config.pl" so as to make the debugging process simpler:
>
> ###live-db-setup.pl###
>
> $main::config{dsn} = 'dbi:Pg:host=localhost;dbname=evergreen;port=5432';
> $main::config{usr} = 'evergreen';
> $main::config{pw} = 'evergreendb';
> $main::config{index} = 'config.cgi';
>
> ###end###
>
> ###offline-config.pl###
>
> $main::config{base_dir} = '/openils/var/data/offline/';
> $main::config{bootstrap} = '/openils/conf/opensrf_core.xml';
> $main::config{dsn} = 'dbi:Pg:host=localhost;dbname=evergreen;port=5432';
> $main::config{usr} = 'evergreen';
> $main::config{pw} = 'evergreendb';
>
> ###end###
>
> Any further help on this problem will be let me move ahead into more
> important part that is importing the records into the system. Thank you once
> again.
>
> --
> With Best Regards,
> Dibyendra Hyoju
>
> Madan Puraskar Pustakalaya
> Patan Dhoka, Lalitpur
> Nepal
> Phone: 977-1-15549948
> Fax: 977-1-5536390
> URL: www.madanpuraskar.org
> Email: info at mpp.org.np
>
> On Thu, May 7, 2009 at 9:45 PM, <
> open-ils-dev-request at list.georgialibraries.org> wrote:
>
>> Send Open-ils-dev mailing list submissions to
>>        open-ils-dev at list.georgialibraries.org
>>
>> To subscribe or unsubscribe via the World Wide Web, visit
>>        http://libmail.georgialibraries.org/mailman/listinfo/open-ils-dev
>> or, via email, send a message with subject or body 'help' to
>>        open-ils-dev-request at list.georgialibraries.org
>>
>> You can reach the person managing the list at
>>        open-ils-dev-owner at list.georgialibraries.org
>>
>> When replying, please edit your Subject line so it is more specific
>> than "Re: Contents of Open-ils-dev digest..."
>>
>>
>> Today's Topics:
>>
>>   1. Regarding installation of Evergreen 1.0.4 (Dibyendra Hyoju)
>>   2. Re: Regarding installation of Evergreen 1.0.4 (Dan Scott)
>>
>>
>> ----------------------------------------------------------------------
>>
>> Message: 1
>> Date: Thu, 7 May 2009 11:27:46 +0545
>> From: Dibyendra Hyoju <dibyendra at gmail.com>
>> Subject: [OPEN-ILS-DEV] Regarding installation of Evergreen 1.0.4
>> To: Open-ILS-Dev <open-ils-dev at list.georgialibraries.org>
>> Message-ID:
>>        <b262ee9f0905062242g1c6254a5t49c6dbdfed7e2639 at mail.gmail.com>
>> Content-Type: text/plain; charset="utf-8"
>>
>> Hello everyone,
>>
>> I have been trying to install Evergreen 1.4.0 on Ubuntu 8.04 Hardy Heron
>> since couple of days ago. I have successfully installed PostgreSQL 8.2
>> database system from the source code. Also, installation of the OpenSRF
>> 1.0.6 was successful. After coming back to the installation of Evergreen
>> 1.4.0, I have followed the provided 15 steps, as provided on
>> http://open-ils.org/dokuwiki/doku.php?id=server:1.4.0:install, but
>> couldn't
>> succeed in starting Evergreen due to the problem occured in step 4,
>> relating
>> to PostgreSQL.
>>
>> While issuing the following command, following error occurs, although the
>> two configuration files contain correct authentication parameters for
>> PostgreSQL:
>>
>> root at dibyendra-laptop:/home/opensrf/Evergreen-ILS-1.4.0.4#  perl
>> Open-ILS/src/support-scripts/eg_db_config.pl --update-config --service-all
>> --create-schema --create-bootstrap --create-offline --user evergreen
>> --password evergreendb --hostname localhost --port 5432 -- database
>> evergreen
>> Unknown option: service-all
>> Backed up original configuration file to
>> '/openils/conf/opensrf.xml.2009.5.7.11.16.10'
>> psql: FATAL:  role "evergreendb" does not exist
>>
>> ********************************************************************************
>> * Could not determine the version of PostgreSQL you have installed.  Our
>> best  *
>> * guess
>> was:                                                                   *
>> *
>> * which didn't make any sense.  For assistance, please
>> email                   *
>> * open-ils-general at list.georgialibraries.org or join #OpenILS-Evergreen
>> on
>> the *
>> * freenode IRC
>> network.                                                        *
>>
>> ********************************************************************************
>> Writing database bootstrapping configuration to
>> /openils/conf/live-db-setup.pl
>> Writing offline database configuration to /openils/conf/offline-config.pl
>>
>> -----------------
>>
>> I have also attached result generated from settings-tester.pl so that the
>> problem can be traced easily. Any help will be appreciated.
>>
>> Thank you.
>>
>> --
>> With Best Regards,
>> Dibyendra Hyoju
>>
>> Madan Puraskar Pustakalaya
>> Patan Dhoka, Lalitpur
>> Nepal
>> Phone: 977-1-15549948
>> Fax: 977-1-5536390
>> URL: www.madanpuraskar.org
>> Email: info at mpp.org.np
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>> URL:
>> http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20090507/1fd0e617/attachment-0001.htm
>> -------------- next part --------------
>> opensrf at dibyendra-laptop:~/Evergreen-ILS-1.4.0.4/Open-ILS/src/support-scripts$
>> ./settings-tester.pl
>> LWP::UserAgent version 2.036
>> XML::LibXML version 1.69
>> XML::LibXML::XPathContext version 1.69
>> XML::LibXSLT version 1.68
>> Net::Server::PreFork version 0.90
>> Cache::Memcached version 1.20
>> Class::DBI version 0.96
>> Class::DBI::AbstractSearch version 0.07
>> Template version 2.19
>> DBD::Pg version 1.49
>> Net::Z3950::ZOOM version 1.25
>> MARC::Record version 2.0.0
>> MARC::Charset version 1.0
>> MARC::File::XML version 0.88
>> Text::Aspell version 0.04
>> CGI version 3.15
>> DateTime::TimeZone version 0.90
>> DateTime version 0.47
>> DateTime::Format::ISO8601 version 0.06
>> DateTime::Format::Mail version 0.3001
>> Unix::Syslog version 1.0
>> GD::Graph3d version 0.63
>> JavaScript::SpiderMonkey version 0.19
>> Log::Log4perl version 1.15
>> Email::Send version 2.192
>> Text::CSV_XS version 0.32
>> Spreadsheet::WriteExcel::Big version 2.20
>> Tie::IxHash version 1.21
>> Parse::RecDescent version 1.95.1
>> SRU version 0.97
>> JSON::XS version 2.232
>>
>> Checking Jabber connection for user opensrf, domain private.localhost
>> * Jabber successfully connected
>>
>> Checking Jabber connection for user opensrf, domain public.localhost
>> * Jabber successfully connected
>>
>> Checking Jabber connection for user router, domain public.localhost
>> * Jabber successfully connected
>>
>> Checking Jabber connection for user router, domain private.localhost
>> * Jabber successfully connected
>>
>> Checking database connections
>> DBI connect('dbname=;host=;port=','',...) failed: FATAL:  database "host="
>> does not exist
>>  at ./settings-tester.pl line 205
>> * /opensrf/default/reporter/setup :: Unable to connect to database
>> dbi:Pg:dbname=;host=;port=, user=, password=
>> * /opensrf/default/reporter/setup :: Unable to connect to database
>> dbi:Pg:dbname=;host=;port=, user=, password=
>> SCALAR(0x87a7cb4)
>> Use of uninitialized value in pattern match (m//) at ./settings-tester.pl
>> line 232, <DATA> line 32.
>> Use of uninitialized value in concatenation (.) or string at
>> ./settings-tester.pl line 233, <DATA> line 32.
>> Use of uninitialized value in concatenation (.) or string at
>> ./settings-tester.pl line 234, <DATA> line 32.
>> * ERROR: /opensrf/default/reporter/setup :: Database
>> dbi:Pg:dbname=;host=;port= has encoding  instead of UTF8 or UNICODE.
>>  * ERROR: Language 'plpgsql' is not enabled in the target database
>>  * ERROR: Language 'plperlu' is not enabled in the target database
>>  * ERROR: Language 'plperl' is not enabled in the target database
>> DBI connect('dbname=;host=;port=','',...) failed: FATAL:  database "host="
>> does not exist
>>  at ./settings-tester.pl line 205
>> * /opensrf/default/apps/open-ils.storage/app_settings/databases :: Unable
>> to connect to database dbi:Pg:dbname=;host=;port=, user=, password=
>> * /opensrf/default/apps/open-ils.storage/app_settings/databases :: Unable
>> to connect to database dbi:Pg:dbname=;host=;port=, user=, password=
>> SCALAR(0x87a7cb4)
>> Use of uninitialized value in pattern match (m//) at ./settings-tester.pl
>> line 232, <DATA> line 32.
>> Use of uninitialized value in concatenation (.) or string at
>> ./settings-tester.pl line 233, <DATA> line 32.
>> Use of uninitialized value in concatenation (.) or string at
>> ./settings-tester.pl line 234, <DATA> line 32.
>> * ERROR: /opensrf/default/apps/open-ils.storage/app_settings/databases ::
>> Database dbi:Pg:dbname=;host=;port= has encoding  instead of UTF8 or
>> UNICODE.
>>  * ERROR: Language 'plpgsql' is not enabled in the target database
>>  * ERROR: Language 'plperlu' is not enabled in the target database
>>  * ERROR: Language 'plperl' is not enabled in the target database
>> DBI connect('dbname=;host=;port=','',...) failed: FATAL:  database "host="
>> does not exist
>>  at ./settings-tester.pl line 205
>> * /opensrf/default/apps/open-ils.cstore/app_settings :: Unable to connect
>> to database dbi:Pg:dbname=;host=;port=, user=, password=
>> * /opensrf/default/apps/open-ils.cstore/app_settings :: Unable to connect
>> to database dbi:Pg:dbname=;host=;port=, user=, password=
>> SCALAR(0x87a7cb4)
>> Use of uninitialized value in pattern match (m//) at ./settings-tester.pl
>> line 232, <DATA> line 32.
>> Use of uninitialized value in concatenation (.) or string at
>> ./settings-tester.pl line 233, <DATA> line 32.
>> Use of uninitialized value in concatenation (.) or string at
>> ./settings-tester.pl line 234, <DATA> line 32.
>> * ERROR: /opensrf/default/apps/open-ils.cstore/app_settings :: Database
>> dbi:Pg:dbname=;host=;port= has encoding  instead of UTF8 or UNICODE.
>>  * ERROR: Language 'plpgsql' is not enabled in the target database
>>  * ERROR: Language 'plperlu' is not enabled in the target database
>>  * ERROR: Language 'plperl' is not enabled in the target database
>> DBI connect('dbname=;host=;port=','',...) failed: FATAL:  database "host="
>> does not exist
>>  at ./settings-tester.pl line 205
>> * /opensrf/default/apps/open-ils.reporter-store/app_settings :: Unable to
>> connect to database dbi:Pg:dbname=;host=;port=, user=, password=
>> * /opensrf/default/apps/open-ils.reporter-store/app_settings :: Unable to
>> connect to database dbi:Pg:dbname=;host=;port=, user=, password=
>> SCALAR(0x87a7cb4)
>> Use of uninitialized value in pattern match (m//) at ./settings-tester.pl
>> line 232, <DATA> line 32.
>> Use of uninitialized value in concatenation (.) or string at
>> ./settings-tester.pl line 233, <DATA> line 32.
>> Use of uninitialized value in concatenation (.) or string at
>> ./settings-tester.pl line 234, <DATA> line 32.
>> * ERROR: /opensrf/default/apps/open-ils.reporter-store/app_settings ::
>> Database dbi:Pg:dbname=;host=;port= has encoding  instead of UTF8 or
>> UNICODE.
>>  * ERROR: Language 'plpgsql' is not enabled in the target database
>>  * ERROR: Language 'plperlu' is not enabled in the target database
>>  * ERROR: Language 'plperl' is not enabled in the target database
>>
>> Checking database drivers to ensure <driver> matches <language>
>> * OK: Pg language is undefined for reporter base configuration
>> * OK: Pg language is perl in
>> /opensrf/default/apps/open-ils.storage/language
>> * OK: pgsql language is C in
>> /opensrf/default/apps/open-ils.cstore/language
>> * OK: pgsql language is C in
>> /opensrf/default/apps/open-ils.reporter-store/language
>>
>> Checking libdbi and libdbi-drivers
>>  * OK - found locally installed libdbi.so and libdbdpgsql.so in shared
>> library path
>>
>> Checking hostname
>>  * OK: found hostname 'localhost' in <hosts> section of opensrf.xml
>>
>> ------------------------------
>>
>> Message: 2
>> Date: Thu, 7 May 2009 03:45:57 -0400
>> From: Dan Scott <denials at gmail.com>
>> Subject: Re: [OPEN-ILS-DEV] Regarding installation of Evergreen 1.0.4
>> To: Evergreen Development Discussion List
>>        <open-ils-dev at list.georgialibraries.org>
>> Message-ID:
>>        <fbb0d11d0905070045t19aa8500vfa4654dc815d6a88 at mail.gmail.com>
>> Content-Type: text/plain; charset=UTF-8
>>
>> 2009/5/7 Dibyendra Hyoju <dibyendra at gmail.com>:
>> > Hello everyone,
>> >
>> > I have been trying to install Evergreen 1.4.0 on Ubuntu 8.04 Hardy Heron
>> > since couple of days ago. I have successfully installed PostgreSQL 8.2
>> > database system from the source code. Also, installation of the OpenSRF
>> > 1.0.6 was successful. After coming back to the installation of Evergreen
>> > 1.4.0, I have followed the provided 15 steps, as provided on
>> > http://open-ils.org/dokuwiki/doku.php?id=server:1.4.0:install, but
>> couldn't
>> > succeed in starting Evergreen due to the problem occured in step 4,
>> relating
>> > to PostgreSQL.
>> >
>> > While issuing the following command, following error occurs, although
>> the
>> > two configuration files contain correct authentication parameters for
>> > PostgreSQL:
>> >
>> > root at dibyendra-laptop:/home/opensrf/Evergreen-ILS-1.4.0.4#? perl
>> > Open-ILS/src/support-scripts/eg_db_config.pl --update-config
>> --service-all
>> > --create-schema --create-bootstrap --create-offline --user evergreen
>> > --password evergreendb --hostname localhost --port 5432 -- database
>> > evergreen
>> > Unknown option: service-all
>>
>> This is one of the keys! The option should be "--service all" - no
>> connecting hyphen (-) between the two. This tells the script to update
>> all of the Evergreen services in opensrf.xml that connect to a
>> database to use the parameters that you are passing at the command
>> line; or, if you don't pass a parameter at the command line, to use
>> the first corresponding value of that it finds in opensrf.xml.
>>
>> So, when you pass "-- database evergreen", the extra space between the
>> "--" and "database" is enough to confuse the script, and it goes to
>> lookup the database name from the existing opensrf.xml file. Try
>> "--database evergreen" instead.
>>
>> When you fix those two options in your command, things should be a lot
>> better!
>>
>> --
>> Dan Scott
>> Laurentian University
>>
>>
>> End of Open-ils-dev Digest, Vol 38, Issue 5
>> *******************************************
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20090512/f8bfef1d/attachment-0001.htm 


More information about the Open-ils-dev mailing list