I recently installed Evergreen 1.4 on Ubuntu:8.10 server. When I test the
Evergreen connection I see:
Received Data: "20a3aa8813c4f3ae7d01c7c2aa6bb779"
------------------------------------
Request Completed Successfully
Request Time in seconds: 0.066338
------------------------------------
Received Exception:
Name: osrfMethodException
Status: No authentication seed found. open-ils.auth.authenticate.init must be
called first
Status: 404
------------------------------------
Request Completed Successfully
Request Time in seconds: 60.005434
------------------------------------
Login Session: (none). Session timeout: 0.000000
So, I ran the settings-tester.pl for more information. The first thing I
notice is that the dbname and user are blank:
Checking database connections
DBI connect('dbname=;host=localhost;port=5432','',...) failed: FATAL: database
"host=localhost" does not exist at ./settings-tester.pl line 217
* /opensrf/default/reporter/setup :: Unable to connect to database
dbi:Pg:dbname=;host=localhost;port=5432, user=, password=evergreen
* /opensrf/default/reporter/setup :: Unable to connect to database
dbi:Pg:dbname=;host=localhost;port=5432, user=, password=evergreen
Now, I think this may have happened because I used \ in one big line when
executing the eg_db_config.pl (I was so intent on following the instructions
exactly I did not stop to think about what the \ meant :) I think the dbase
and user settings were ignored when I initially ran the script because they
followed the \.
Since then I have rerun eg_db_config.pl without the \ as one big line and on
separate lines using the \ as it is meant to be used. It does run with some
errors:
Backed up original configuration file to
'/openils/conf/opensrf.xml.2009.4.1.12.58.35'
BEGIN
CREATE FUNCTION
psql:000.english.pg82.fts-config.sql:28: ERROR: duplicate key violates unique
constraint "pg_ts_cfg_pkey"
psql:000.english.pg82.fts-config.sql:29: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:000.english.pg82.fts-config.sql:30: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:000.english.pg82.fts-config.sql:31: ERROR: current transaction is
aborted, commands ignored until end of transaction block
psql:000.english.pg82.fts-config.sql:32: ERROR: current transaction is
aborted, commands ignored until end of transaction block
up to sql:136. But then the rest of the script continues.
I did restart ejabberd, memcached, osrf_ctl.sh. But when I rerun the
settings_tester.pl script dbname and user still are blank. Should I remove the
pg_ts_cfg_pkey and rerun eg_db_config.pl? Is there anything else I should try
first?
I also dug around the lists, and found some other things to check for the no
authentication seed found error. Below are host and port information
memcached:
r...@greenowwl:/etc$ ps ax | grep memcached
4115 pts/2 S 0:00 /usr/bin/memcached -m 64 -p 11211 -u nobody -l
127.0.0.1
>From opensrf.xml:
<cache>
<!-- memcache servers -->
<global>
<servers>
<server>localhost:11211</server>
</servers>
<max_cache_time>86400</max_cache_time>
</global>
</cache>
>From hosts file:
127.0.0.1 localhost
127.0.1.1 greenowwl.plshq.pls-net.org greenowwl
127.0.1.2 public.localhost public
127.0.1.3 private.localhost private
I can also telnet to:
telnet 127.0.0.1 11211
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.
quit
Connection closed by foreign host.
telnet localhost 11211
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
quit
Connection closed by foreign host.
I also found that it is not communicating with the open-ils.cstore:
srfsh# request open-ils.cstore open-ils.cstore.direct.actor.user.retrieve 1
Unable to communicate with service open-ils.cstore
I will keep looking, but if you have any suggestions of other things I could
check, I really be grateful!
(I also attached the complete results from the settings_tester.pl script in
case that helps.)
Thanks,
Roma
Pioneer Library System
Canandaigua, NY
Prototype mismatch: sub main::__LONG_MAX__ () vs none at
/usr/lib/perl/5.10/_h2ph_pre.ph line 291.
Constant subroutine __LONG_MAX__ redefined at /usr/lib/perl/5.10/_h2ph_pre.ph
line 291.
LWP::UserAgent version 5.810
XML::LibXML version 1.69
XML::LibXML::XPathContext version 1.69
XML::LibXSLT version 1.68
Net::Server::PreFork version 0.97
Cache::Memcached version 1.24
Class::DBI version 0.96
Class::DBI::AbstractSearch version 0.07
Template version 2.19
DBD::Pg version 2.8.2
Net::Z3950::ZOOM version 1.24
MARC::Record version 2.0.0
MARC::Charset version 0.98
MARC::File::XML version 0.88
Text::Aspell version 0.04
CGI version 3.29
DateTime::TimeZone version 0.7701
DateTime version 0.42
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.19
Log::Log4perl version 1.16
Email::Send version 2.192
Text::CSV version 1.06
Text::CSV_XS version 0.52
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.01
Checking Jabber connection
* Jabber successfully connected
Checking database connections
DBI connect('dbname=;host=localhost;port=5432','',...) failed: FATAL: database
"host=localhost" does not exist at ./settings-tester.pl line 217
* /opensrf/default/reporter/setup :: Unable to connect to database
dbi:Pg:dbname=;host=localhost;port=5432, user=, password=evergreen
* /opensrf/default/reporter/setup :: Unable to connect to database
dbi:Pg:dbname=;host=localhost;port=5432, user=, password=evergreen
SCALAR(0x92cf9f0)
Use of uninitialized value $encoding in pattern match (m//) at
./settings-tester.pl line 244, <DATA> line 32.
Use of uninitialized value $encoding in concatenation (.) or string at
./settings-tester.pl line 245, <DATA> line 32.
Use of uninitialized value $encoding in concatenation (.) or string at
./settings-tester.pl line 246, <DATA> line 32.
* ERROR: /opensrf/default/reporter/setup :: Database
dbi:Pg:dbname=;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=;host=localhost;port=5432','',...) failed: FATAL: database
"host=localhost" does not exist at ./settings-tester.pl line 217
* /opensrf/default/apps/open-ils.storage/app_settings/databases :: Unable to
connect to database dbi:Pg:dbname=;host=localhost;port=5432, user=,
password=evergreen
* /opensrf/default/apps/open-ils.storage/app_settings/databases :: Unable to
connect to database dbi:Pg:dbname=;host=localhost;port=5432, user=,
password=evergreen
SCALAR(0x92cf9f0)
Use of uninitialized value $encoding in pattern match (m//) at
./settings-tester.pl line 244, <DATA> line 32.
Use of uninitialized value $encoding in concatenation (.) or string at
./settings-tester.pl line 245, <DATA> line 32.
Use of uninitialized value $encoding in concatenation (.) or string at
./settings-tester.pl line 246, <DATA> line 32.
* ERROR: /opensrf/default/apps/open-ils.storage/app_settings/databases ::
Database dbi:Pg:dbname=;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=;host=localhost;port=5432','',...) failed: FATAL: database
"host=localhost" does not exist at ./settings-tester.pl line 217
* /opensrf/default/apps/open-ils.cstore/app_settings :: Unable to connect to
database dbi:Pg:dbname=;host=localhost;port=5432, user=, password=evergreen
* /opensrf/default/apps/open-ils.cstore/app_settings :: Unable to connect to
database dbi:Pg:dbname=;host=localhost;port=5432, user=, password=evergreen
SCALAR(0x92cf9f0)
Use of uninitialized value $encoding in pattern match (m//) at
./settings-tester.pl line 244, <DATA> line 32.
Use of uninitialized value $encoding in concatenation (.) or string at
./settings-tester.pl line 245, <DATA> line 32.
Use of uninitialized value $encoding in concatenation (.) or string at
./settings-tester.pl line 246, <DATA> line 32.
* ERROR: /opensrf/default/apps/open-ils.cstore/app_settings :: Database
dbi:Pg:dbname=;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=;host=localhost;port=5432','',...) failed: FATAL: database
"host=localhost" does not exist at ./settings-tester.pl line 217
* /opensrf/default/apps/open-ils.reporter-store/app_settings :: Unable to
connect to database dbi:Pg:dbname=;host=localhost;port=5432, user=,
password=evergreen
* /opensrf/default/apps/open-ils.reporter-store/app_settings :: Unable to
connect to database dbi:Pg:dbname=;host=localhost;port=5432, user=,
password=evergreen
SCALAR(0x92cf9f0)
Use of uninitialized value $encoding in pattern match (m//) at
./settings-tester.pl line 244, <DATA> line 32.
Use of uninitialized value $encoding in concatenation (.) or string at
./settings-tester.pl line 245, <DATA> line 32.
Use of uninitialized value $encoding in concatenation (.) or string at
./settings-tester.pl line 246, <DATA> line 32.
* ERROR: /opensrf/default/apps/open-ils.reporter-store/app_settings :: Database
dbi:Pg:dbname=;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
* 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
