[OPEN-ILS-GENERAL] ***SPAM*** Re: ***SPAM*** Question about install Evergreen.

[Wolf Halton]

The system did not get your evergreen user password or your postgres
user password right.

The following is based on an installation of evergreen 2.1 on one of
my 6 evergreen servers. Your mileage may vary.

This line of code comes from the Evergreen-ils readme file and is also
the instructions for 2.1 version on the download page
http://open-ils.org/documentation/install/README_2_1_1.html#_creating_the_evergreen_database

perl Open-ILS/src/support-scripts/eg_db_config.pl --update-config \
       --service all --create-database --create-schema --create-offline \
       --user <user> --password <password> --hostname <hostname> --port <port> \
       --database <dbname> --admin-user <admin-user> --admin-pass <admin-pass>

on line 3 the <user> placemarker should be your evergreen database
user's name and the password should be your evergreen database user's
password.  You can re-run this perlscript with a few pieces missing,
to make the change on the database.

perl Open-ILS/src/support-scripts/eg_db_config.pl --update-config \
       --user <user> --password <password> --hostname <hostname> --port <port> \
       --database <dbname>

Once you have done that, remember that the postgres user is a unix
system user for the postgresql database.  postgres user's password is
essentially a log-in password so if you are not entirely sure what you
gave the postgres user as a password on your linux system, run
      sudo passwd postgres
at the command line

Then go to /openils/conf/opensrf.xml and look for mentions of the database.
sudo vi /openils/conf/opensrf.xml
inside opensrf.xml (these line numbers are approximate)
on line 151 is a stanza mentioning the evergreen db user
on line 880 is another such
on line 909 is another
on line 943 is another
on line 970 is one that mentions the postgres user, and here the
password must be what you now know the postgres user's system password
to be.
on line 1051 is another mention of the evergreen user

Make sure the password you set on the database with the perlscript
above is the one mentioned wherever the evergreen db user is
mentioned.

2012/2/13 윤현탁 <dhtmxh at gmail.com>:
> Hello.
> It`s been a 2 weeks that I trying install it.
> The problem is it : Error occurred at 'autogen.sh'.
> I installed opensrf and tested successfully. But when I try to install
> evergreen, an error occured..
> First of all, opensrf doesn`t work. I copy evergreen`s opensrf_core.xml file
> to /openils/conf, and changed password that I registered. But opensrf
> doesn`t receive data from server. Anything else that I change? When I typed
> 'settings-tester.pl', these messages are printed.
> 1..5
> ok 1 - use OpenSRF::Utils::Config;
> ok 2 - use UNIVERSAL::require;
> ok 3 - use Getopt::Long;
> ok 4 - use MARC::Record;
> ok 5 - use Net::Domain;
> 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.3
> 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.32
> UUID::Tiny version 1.03
> Business::CreditCard::Object version 1.00
> Net::Z3950::Simple2ZOOM version 1.04
>
> Checking /openils/conf/opensrf_core.xml for Evergreen services:
> * OK: Found a public Evergreen service in /openils/conf/opensrf_core.xml
>
> 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=evergreen;host=localhost;port=5432','postgres',...)
> failed: ?????:  ??? "postgres"? password ??? ??????
> ?????:  ??? "postgres"? password ??? ?????? at
> /home/opensrf/Evergreen-ILS-2.1.1/Open-ILS/src/support-scripts/settings-tester.pl
> line 158
> * /opensrf/default/reporter/setup :: Unable to connect to database
> dbi:Pg:dbname=evergreen;host=localhost;port=5432, user=postgres,
> password=postgres
> DBI connect('dbname=evergreen;host=localhost;port=5432','postgres',...)
> failed: ?????:  ??? "postgres"? password ??? ??????
> ?????:  ??? "postgres"? password ??? ?????? at
> /home/opensrf/Evergreen-ILS-2.1.1/Open-ILS/src/support-scripts/settings-tester.pl
> line 158
> * /opensrf/default/apps/open-ils.storage/app_settings/databases :: Unable to
> connect to database dbi:Pg:dbname=evergreen;host=localhost;port=5432,
> user=postgres, password=postgres
> DBI connect('dbname=evergreen;host=localhost;port=5432','postgres',...)
> failed: ?????:  ??? "postgres"? password ??? ??????
> ?????:  ??? "postgres"? password ??? ?????? at
> /home/opensrf/Evergreen-ILS-2.1.1/Open-ILS/src/support-scripts/settings-tester.pl
> line 158
> * /opensrf/default/apps/open-ils.cstore/app_settings :: Unable to connect to
> database dbi:Pg:dbname=evergreen;host=localhost;port=5432, user=postgres,
> password=postgres
> DBI connect('dbname=evergreen;host=localhost;port=5432','postgres',...)
> failed: ?????:  ??? "postgres"? password ??? ??????
> ?????:  ??? "postgres"? password ??? ?????? at
> /home/opensrf/Evergreen-ILS-2.1.1/Open-ILS/src/support-scripts/settings-tester.pl
> line 158
> * /opensrf/default/apps/open-ils.pcrud/app_settings :: Unable to connect to
> database dbi:Pg:dbname=evergreen;host=localhost;port=5432, user=postgres,
> password=postgres
> DBI connect('dbname=evergreen;host=localhost;port=5432','postgres',...)
> failed: ?????:  ??? "postgres"? password ??? ??????
> ?????:  ??? "postgres"? password ??? ?????? at
> /home/opensrf/Evergreen-ILS-2.1.1/Open-ILS/src/support-scripts/settings-tester.pl
> line 158
> * /opensrf/default/apps/open-ils.reporter-store/app_settings :: Unable to
> connect to database dbi:Pg:dbname=evergreen;host=localhost;port=5432,
> user=postgres, password=postgres
>
> Checking database drivers to ensure <driver> matches <language>
> * OK SIP from telephony section.
> * OK SIP from telephony section.
> * 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 postgresql version
> psql (PostgreSQL) 9.0.5
> 명령행 편집을 위해 지원하는 기능:
>
> 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
>
> He says Jabbers are connected...But also says not connected at other type..
>
> Second question is error occured at 'autogen.sh'. When I typed that order..
>
> Updating Evergreen organization tree and IDL
>
> Updating fieldmapper
>  -> /openils/var/web/opac/common/js//fmall.js
> Updating web_fieldmapper
>  -> /openils/var/web/opac/common/js//fmcore.js
> Updating OrgTree
> Exception: OpenSRF::EX::Session 2012-02-14T12:04:53 OpenSRF::Transport
> /usr/local/share/perl/5.10.1/OpenSRF/Transport.pm:83 Session Error:
> router at private.localhost/open-ils.cstore IS NOT CONNECTED TO THE NETWORK!!!
>
> What`s the matter? I don`t know what log file to see..Is log file exsist at
> /openils/var/log?



-- 
This Apt Has Super Cow Powers - http://sourcefreedom.com
Advancing Libraries Together - http://LYRASIS.org