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: i...@mpp.org.np On Thu, May 7, 2009 at 9:45 PM, < open-ils-dev-requ...@list.georgialibraries.org> wrote: > Send Open-ils-dev mailing list submissions to > open-ils-dev@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-requ...@list.georgialibraries.org > > You can reach the person managing the list at > open-ils-dev-ow...@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 <dibyen...@gmail.com> > Subject: [OPEN-ILS-DEV] Regarding installation of Evergreen 1.0.4 > To: Open-ILS-Dev <open-ils-dev@list.georgialibraries.org> > Message-ID: > <b262ee9f0905062242g1c6254a5t49c6dbdfed7e2...@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: > > r...@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-gene...@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: i...@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 -------------- > open...@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 <deni...@gmail.com> > Subject: Re: [OPEN-ILS-DEV] Regarding installation of Evergreen 1.0.4 > To: Evergreen Development Discussion List > <open-ils-dev@list.georgialibraries.org> > Message-ID: > <fbb0d11d0905070045t19aa8500vfa4654dc815d6...@mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > 2009/5/7 Dibyendra Hyoju <dibyen...@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: > > > > r...@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 > ******************************************* >
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