[OPEN-ILS-GENERAL] Testing and fixing My Evergreen

[makekee at msu.ac.zw]

Hi guys

After running the settings-tester.pl, this is what I am getting. I have no idea
of what I should really do.

opensrf at eg-server2:~$ perl settings-tester.pl
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 0.96
Class::DBI::AbstractSearch version 0.07
Template version 2.19
DBD::Pg version 1.49
Please install one of the following modules: Net::Z3950 Net::Z3950::ZOOM
MARC::Record version 2.0.0
MARC::Charset version 1.1
MARC::File::XML version 0.92
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
* Jabber successfully connected

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(0x8738560)
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(0x8738560)
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(0x8738560)
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 'eg-server2' in <hosts> section of opensrf.xml
opensrf at eg-server2:~$


Help!

Ephraim

----------------------------------------------------------------
Message From Midlands State University P Bag 9055,Gweru,Zimbabwe
                                website:  www.msu.ac.zw