[OPEN-ILS-DEV] Open-ils-dev Digest, Vol 38, Issue 5
Dibyendra Hyoju
dibyendra at gmail.com
Fri May 8 02:01:07 EDT 2009
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/20090508/6d6b67f5/attachment-0001.htm
-------------- next part --------------
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(0x87a7bcc)
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(0x87a7bcc)
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(0x87a7bcc)
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(0x87a7bcc)
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
More information about the Open-ils-dev
mailing list