Hello all, Earlier, this issue was posted in the the Open-ILS Dev mailing list. As, this post is relevant to the general mailing list, I am again forwarding the same issue again to this list.
This is a forwarded copy of the earlier email. So, it is a bit long email. Initial problem was fixed from Dan's suggestion, but the problem about connecting to the PostgreSQL still persists. While working on this issue, I noticed that "opensrf.xml" contains no information about PostgreSQL authentication, which should have been updated by the file "eg_db_config.pl". If anyone of you have already faced this kind of issue before, or had a chance to resolve this issue, please share your experience. Your help will be highly appreciated. Thank you very much in advance. -- 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: [email protected] ---------- Forwarded message ---------- From: <[email protected]> Date: Tue, May 12, 2009 at 12:34 PM Subject: Open-ils-dev Digest, Vol 38, Issue 7 To: [email protected] Send Open-ils-dev mailing list submissions to [email protected] 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 [email protected] You can reach the person managing the list at [email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of Open-ils-dev digest..." Today's Topics: 1. Re: Open-ils-dev Digest, Vol 38, Issue 5 (Dibyendra Hyoju) ---------------------------------------------------------------------- Message: 1 Date: Tue, 12 May 2009 12:25:57 +0545 From: Dibyendra Hyoju <[email protected]> Subject: Re: [OPEN-ILS-DEV] Open-ils-dev Digest, Vol 38, Issue 5 To: [email protected] Message-ID: <[email protected]> Content-Type: text/plain; charset="utf-8" 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 <[email protected]>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: [email protected] > > On Thu, May 7, 2009 at 9:45 PM, < > [email protected]> wrote: > >> Send Open-ils-dev mailing list submissions to >> [email protected] >> >> 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 >> [email protected] >> >> You can reach the person managing the list at >> [email protected] >> >> 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 <[email protected]> >> Subject: [OPEN-ILS-DEV] Regarding installation of Evergreen 1.0.4 >> To: Open-ILS-Dev <[email protected]> >> Message-ID: >> <[email protected]> >> 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 * >> * [email protected] 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: [email protected] >> -------------- 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 <[email protected]> >> Subject: Re: [OPEN-ILS-DEV] Regarding installation of Evergreen 1.0.4 >> To: Evergreen Development Discussion List >> <[email protected]> >> Message-ID: >> <[email protected]> >> Content-Type: text/plain; charset=UTF-8 >> >> 2009/5/7 Dibyendra Hyoju <[email protected]>: >> > 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 >> ******************************************* >> > -------------- next part -------------- An HTML attachment was scrubbed... URL: http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20090512/f8bfef1d/attachment.htm End of Open-ils-dev Digest, Vol 38, Issue 7 *******************************************
