[OPEN-ILS-GENERAL] settings-tester.pl output - need assistance with installation

[Donald Beck]

I have followed the instructions:

Installing Evergreen 1.2 on Ubuntu 8.04 (Hardy Heron) and 7.10 (Gutsy Gibbon)

but cannot get the services started.  I am installing on the most
updated version of Ubuntu 8.04 and Postgres 8.2.

The problem appears to be with connecting to jabber but I also get
language errors for my Postgres database (although I have added the
support using the CREATE LANGUAGE command.  Below is the output for
the settings-tester.pl script:

LWP::UserAgent version 2.036
XML::LibXML version 1.69
XML::LibXML::XPathContext version 1.69
XML::LibXSLT version 1.62
Net::Server::PreFork version 0.90
Cache::Memcached version 1.20
Class::DBI version 3.0.17
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.70
DateTime version 0.41
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

Checking Jabber connection
* Error connecting to jabber:
SCALAR(0x8738b7c)

Checking database connections
* WARNING: Deprecated <password> element used for the <reporter>
entry.  Please use <pw> instead.
DBI connect('dbname=evergreen;host=localhost;port=5432','postgres',...)
failed: FATAL:  password authentication failed for user "postgres"
 at ./settings-tester.pl line 216
* /opensrf/default/reporter/setup :: Unable to connect to database
dbi:Pg:dbname=evergreen;host=localhost;port=5432, user=postgres,
password=postgres
* /opensrf/default/reporter/setup :: Unable to connect to database
dbi:Pg:dbname=evergreen;host=localhost;port=5432, user=postgres,
password=postgres
SCALAR(0x8738b7c)
Use of uninitialized value in pattern match (m//) at
./settings-tester.pl line 243, <DATA> line 29.
Use of uninitialized value in concatenation (.) or string at
./settings-tester.pl line 244, <DATA> line 29.
Use of uninitialized value in concatenation (.) or string at
./settings-tester.pl line 245, <DATA> line 29.
* ERROR: /opensrf/default/reporter/setup :: Database
dbi:Pg:dbname=evergreen;host=localhost;port=5432 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
* /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.
DBI connect('dbname=evergreen;host=localhost;port=5432','postgres',...)
failed: FATAL:  password authentication failed for user "postgres"
 at ./settings-tester.pl line 216
* /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
* /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
SCALAR(0x8738b7c)
Use of uninitialized value in pattern match (m//) at
./settings-tester.pl line 243, <DATA> line 29.
Use of uninitialized value in concatenation (.) or string at
./settings-tester.pl line 244, <DATA> line 29.
Use of uninitialized value in concatenation (.) or string at
./settings-tester.pl line 245, <DATA> line 29.
* ERROR: /opensrf/default/apps/open-ils.cstore/app_settings ::
Database dbi:Pg:dbname=evergreen;host=localhost;port=5432 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=evergreen;host=localhost;port=5432','postgres',...)
failed: FATAL:  password authentication failed for user "postgres"
 at ./settings-tester.pl line 216
* /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
* /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
SCALAR(0x8738b7c)
Use of uninitialized value in pattern match (m//) at
./settings-tester.pl line 243, <DATA> line 29.
Use of uninitialized value in concatenation (.) or string at
./settings-tester.pl line 244, <DATA> line 29.
Use of uninitialized value in concatenation (.) or string at
./settings-tester.pl line 245, <DATA> line 29.
* ERROR: /opensrf/default/apps/open-ils.reporter-store/app_settings ::
Database dbi:Pg:dbname=evergreen;host=localhost;port=5432 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
/usr/local/lib/dbd/libdbdpgsql.so
 was not linked against libdbi - you probably need to compile
libdbi-drivers from source with the --enable-libdbi configure switch.

Checking hostname
 * OK: found hostname 'evergreen' in <hosts> section of opensrf.xml