[OPEN-ILS-GENERAL] Open-ils-general Digest, Vol 62, Issue 41

Stephen R. Westman stephen.westman at gmail.com
Sun Aug 21 14:40:21 EDT 2011 

My apologies (as I said, I'm still new at this).  The problem is not that
you didn't set the username/password incorrectly in the steps I outlined
below.  The error message is coming from the fact that it appears that
evergreen is hard-coded to use postgres/postgres as username and password to
start up the database.

I'm enough of a newbie that I will defer to those with more experience.




On Sun, Aug 21, 2011 at 2:26 PM, Stephen R. Westman <
stephen.westman at gmail.com> wrote:

> *Stephen,
>
> I noticed an  error message in the email you sent (seen below in green
> font).
>
> It seems like that username/password for logging in is not what is
> expected: evergreen/evergreen
>
> Did you do the following steps in the instructions?:*
>
>
>    1. As the *postgres* user on the PostgreSQL server, create a PostgreSQL
>    user named evergreen for the database cluster:
>
>    createuser -P -s evergreen
>
>    2. Enter the password for the new PostgreSQL superuser (“evergreen”)
>
>
>
> *Alternately, did you do the following?:
> *
> As the *root* user, enable IPv4 and IPv6 connections to the PostgreSQL
> server. For a single-server instance, enable password-protected connections
> from the evergreen user to the evergreen database on localhost by adding
> the following lines to /var/lib/pgsql/data/pg_hba.conf:
>
> # IPv4 local connections:
> host    evergreen     evergreen         127.0.0.1/32          md5
> # IPv6 local connections:
> host    evergreen     evergreen         ::1/128               md5
>
> ; then restart the PostgreSQL server to make that configuration take
> effect:
>
> *
> *
>
> *Thirdly, what values did you put in for user/password and
> admin-user/admin-pass on the following step:*
>
> As the *opensrf* user, create the database schema and configure your
> system with the corresponding database authentication details for the
> database user that you just created; on most systems,*<hostname>* will be
> localhost and *<port>* will be 5432. The *<admin-user>* and *<admin-pass>*
>  variables specify the Evergreen administrator account's user name and
> password, respectively:
>
> cd /home/opensrf/Evergreen-ILS-2.0.0
> perl Open-ILS/src/support-scripts/eg_db_config.pl --update-config \
>
>        --service all --create-schema --create-offline \
>
>        --user <user> --password <password> --hostname <hostname> --port <port> \
>
>        --database <dbname> --admin-user <admin-user> --admin-pass <admin-pass>
>
> *NOTE*: If you are entering this command on a single line, do not include
> the \ characters. These should only be used at the end of a line at a bash
> prompt to indicate that the command is continued on the next line.
>
> I'm still new to this myself and am not sure, depending on the situation,
> of the best way to proceed.  However, I would guess (anybody else want to
> weigh in here?) that - if you haven't done them before (or may have made a
> mistake doing them) - doing the first two may resolve your problem.
>
> Stephen Westman
>
> P.S. Sorry if this has already been answered.  I'm just getting the digest
> version but wanted to help.
>
>
>
>
>
> ---------- Forwarded message ----------
> From: <open-ils-general-request at list.georgialibraries.org>
> Date: Sun, Aug 21, 2011 at 12:00 PM
> Subject: Open-ils-general Digest, Vol 62, Issue 41
> To: open-ils-general at list.georgialibraries.org
>
>
> Send Open-ils-general mailing list submissions to
>        open-ils-general at list.georgialibraries.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>
> http://libmail.georgialibraries.org/mailman/listinfo/open-ils-general
> or, via email, send a message with subject or body 'help' to
>        open-ils-general-request at list.georgialibraries.org
>
> You can reach the person managing the list at
>        open-ils-general-owner at list.georgialibraries.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Open-ils-general digest..."
>
>
> Today's Topics:
>
>   1. Received no data from server (Stephen Mather)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sat, 20 Aug 2011 16:22:49 -0400
> From: Stephen Mather <mather.stephen at gmail.com>
> Subject: [OPEN-ILS-GENERAL] Received no data from server
> To: open-ils-general at list.georgialibraries.org
> Message-ID:
>        <CAPkJWLV0JnyaS3sKTeGpmn4TidS1uaWLpVV6Pz62F4v8HqCPFw at mail.gmail.com
> >
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi All,
>      Please excuse if this is a duplicate request-- I had trouble figuring
> out how to search this groups archives.  I'm working on setting up
> Evergreen
> for our church and have run into a snag.  When I test the login through
> srfsh, e.g.
>
> /openils/bin/srfsh
> login admin password
>
> I get:
>
> Received no data from server
>
> ------------------------------------
> Request Time in seconds: 0.002670
> ------------------------------------
> ???: login admin password
>
> If I test with the settings-tester.pl, I get the following:
>
> Evergreen-ILS-2.0.7/Open-ILS/src/support-scripts/settings-tester.pl
> LWP::UserAgent version 5.834
> XML::LibXML version 1.70
> XML::LibXML::XPathContext version 1.70
> XML::LibXSLT version 1.70
> Net::Server::PreFork version 0.97
> Cache::Memcached version 1.28
> Class::DBI version 3.0.17
> Class::DBI::AbstractSearch version 0.07
> Template version 2.20
> DBD::Pg version 2.16.1
> Net::Z3950::ZOOM version 1.25
> MARC::Record version 2.0.0
> MARC::Charset version 1.1
> MARC::File::XML version 0.93
> Text::Aspell version 0.04
> CGI version 3.43
> DateTime::TimeZone version 1.10
> DateTime version 0.52
> DateTime::Format::ISO8601 version 0.06
> DateTime::Format::Mail version 0.3001
> Unix::Syslog version 1.1
> GD::Graph3d version 0.63
> JavaScript::SpiderMonkey version 0.20
> Log::Log4perl version 1.26
> Email::Send version 2.198
> Text::CSV version 1.16
> Text::CSV_XS version 0.70
> Spreadsheet::WriteExcel::Big version 2.36
> Tie::IxHash version 1.21
> Parse::RecDescent version 1.963
> SRU version 0.99
> JSON::XS version 2.27
>
> 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
> * /opensrf/default/reporter/setup :: Successfully connected to database
> dbi:Pg:dbname=evergreen;host=localhost;port=5432
>  * Database has the expected server encoding UTF8.
> * /opensrf/default/apps/open-ils.storage/app_settings/databases ::
> Successfully connected to database
> dbi:Pg:dbname=evergreen;host=localhost;port=5432
>  * Database has the expected server encoding UTF8.
> * /opensrf/default/apps/open-ils.cstore/app_settings :: Successfully
> connected to database dbi:Pg:dbname=evergreen;host=localhost;port=5432
>  * Database has the expected server encoding UTF8.
> * /opensrf/default/apps/open-ils.pcrud/app_settings :: Successfully
> connected to database dbi:Pg:dbname=evergreen;host=localhost;port=5432
>
> * * Database has the expected server encoding UTF8.
> DBI connect('dbname=evergreen;**host=localhost;port=5432','**
> postgres',...)
>  failed: FATAL:  password authentication failed for user "postgres"
> FATAL:  password authentication failed for user "postgres" at
> Evergreen-ILS-2.0.7/Open-ILS/**src/support-scripts/settings-tester.pl line
> 235*
>
>
> * /opensrf/default/apps/open-ils.qstore/app_settings :: Unable to connect
> to
> database dbi:Pg:dbname=evergreen;host=localhost;port=5432, user=postgres,
> password=postgres
> * /opensrf/default/apps/open-ils.reporter-store/app_settings ::
> Successfully
> connected to database dbi:Pg:dbname=evergreen;host=localhost;port=5432
>  * Database has the expected server encoding UTF8.
>
> Checking database drivers to ensure <driver> matches <language>
> * ERROR: Unknown driver SIP in /opensrf/default/notifications/telephony
> * ERROR: Unknown driver SIP in /opensrf/default/notifications/telephony
> * OK: Pg language is undefined for reporter base configuration
> * 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.pcrud/language
> * OK: pgsql language is C in /opensrf/default/apps/open-ils.qstore/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
>
> Thanks in advance,
> Steve Mather
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20110820/a4571d2a/attachment-0001.htm
> >
>
> End of Open-ils-general Digest, Vol 62, Issue 41
> ************************************************
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20110821/9bf5df80/attachment-0001.htm>

More information about the Open-ils-general mailing list