[OPEN-ILS-GENERAL] SPAM RE: SPAM Urgent help required please

Mon Aug 15 18:59:26 EDT 2011

Sorry for the false alarm before.  GMail is acting strange and I hit the
wrong key and the thing got sent early.

Stephen

---------- Forwarded message ----------
From: Stephen R. Westman <stephen.westman at gmail.com>
Date: Mon, Aug 15, 2011 at 6:54 PM
Subject: Re: [OPEN-ILS-GENERAL] ***SPAM*** RE: ***SPAM*** Urgent help
required please
To: Evergreen Discussion Group <open-ils-general at list.georgialibraries.org>

What we need to do here is to disambiguate the PostgreSQL login and the
Evergreen login.  To be able to get into to do what Anoop is suggesting, you
need to open up PostgreSQL to let you in.

What you can do is go into your PostgreSQL data directory (for me it's
/var/lib/pgsql/data/) and edit the pg_hba.conf. will want to do is to change
the entries for evergreen (or whatever password you use for PostgreSQL) and
change the relevant entries to this:
  TYPE    DATABASE            USER                    CIDR-ADDRESS
METHOD
local         evergreen        evergreen
                   trust
host          evergreen        evergreen                      127.0.0.1
              trust
host          evergreen        evergreen                <ip address of box>
     trust

You then need to restart the server (as user postgres)

Once you have done that, you should be able to use the

$psql -U evergreen evergreen

command to go in and to change the entry in the actor database.

Once you have successfully changed it, you can change the pg_hba.conf back
to password for security's sake.

Hope this helps.

Also, I don't know if this is at all relevant to the problem you mention,
but I notice at the very top of your page the following error from the Perl
interpreter:

Updating fieldmapper

Can't locate OpenILS/Utils/Fieldmapper.pm in @INC (@INC contains: /etc/perl
/usr/local/lib/perl/5.10.0 /usr/local/share/perl/5.10.0 /usr/lib/perl5
/usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10
/usr/local/lib/site_perl .) at fieldmapper.pl line 4.

BEGIN failed--compilation aborted at fieldmapper.pl line 4.

It comes with the Evergreen distribution.  Don't know if you saw that, but
thought you might like to know.

Stephen Westman

On Mon, Aug 15, 2011 at 1:24 PM, Wolf Halton <wolf.halton at gmail.com> wrote:

> On Mon, Aug 15, 2011 at 8:50 AM, Muhammad Faiz Chishti
> <mfaizali at hotmail.com> wrote:
> > I have looked in to my   /home/opensrf/.bashrc and found that the
> following
> > command was missing
> >
> >
> > export PERL5LIB=/openils/lib/perl5:$PERL5LIB
> >
> >
> > And manually added the path
> >
> > export PATH=/openils/bin:$PATH
> >
> > export PERL5LIB=/openils/lib/perl5:$PERL5LIB
> >
> > NOW the command
> >
> >   ./autogen.sh -c /openils/conf/opensrf_core.xml –u
> >
> > Is giving  error
> >
> > Can't call method "opac_visible" on an undefined value at
> > org_tree_html_options.pl line 54.
> >
> > From: open-ils-general-bounces at list.georgialibraries.org
> > [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of
> > Muhammad Faiz Chishti
> > Sent: Monday, August 15, 2011 4:59 PM
> > To: open-ils-general at list.georgialibraries.org
> > Cc: feedback at evergreen-ils.org
> > Subject: [OPEN-ILS-GENERAL] ***SPAM*** Urgent help required please
> >
> >
> > Hi I have installed new evergreen server and it gives error on this
> command
> >
> >
> >
> >                                     ./autogen.sh -c
> > /openils/conf/opensrf_core.xml –u
> >
> >
> >
> > opensrf at lmstest:/openils/bin$ ./autogen.sh -c
> /openils/conf/opensrf_core.xml
> > -u
> >
> > Updating Evergreen organization tree and IDL using
> > '/openils/conf/opensrf_core.xml'
> >
> >
> >
> > Updating fieldmapper
> >
> > Can't locate OpenILS/Utils/Fieldmapper.pm in @INC (@INC contains:
> /etc/perl
> > /usr/local/lib/perl/5.10.0 /usr/local/share/perl/5.10.0 /usr/lib/perl5
> > /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10
> > /usr/local/lib/site_perl .) at fieldmapper.pl line 4.
> >
> > BEGIN failed--compilation aborted at fieldmapper.pl line 4.
> >
> >
> >
> >
> >
> > settings-tester.pl    tester result
> >
> >
> >
> >
> >
> > opensrf at lmstest:~$
> > /home/opensrf/Evergreen-ILS-2.0.8/Open-ILS/src/support-scripts/
> settings-tester.pl
> >
> > LWP::UserAgent version 5.829
> >
> > 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.26
> >
> > Class::DBI version 3.0.17
> >
> > Class::DBI::AbstractSearch version 0.07
> >
> > Template version 2.20
> >
> > DBD::Pg version 2.13.1
> >
> > Net::Z3950::ZOOM version 1.25
> >
> > MARC::Record version 2.0.3
> >
> > MARC::Charset version 1.33
> >
> > MARC::File::XML version 0.93
> >
> > Text::Aspell version 0.04
> >
> > CGI version 3.29
> >
> > DateTime::TimeZone version 0.91
> >
> > DateTime version 0.49
> >
> > 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.23
> >
> > Email::Send version 2.197
> >
> > Text::CSV version 1.12
> >
> > Text::CSV_XS version 0.65
> >
> > Spreadsheet::WriteExcel::Big version 2.22
> >
> > Tie::IxHash version 1.21
> >
> > Parse::RecDescent version 1.96.0
> >
> > SRU version 0.99
> >
> > JSON::XS version 2.32
> >
> >
> >
> > 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
> > /home/opensrf/Evergreen-ILS-2.0.8/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
> >
> >
> >
> >
> >
> >
> >
> > And when I run srfsh the following error occurs
> >
> > srfsh# login admin leo
> >
> >
> >
> > Received Data: "4ca997a2c289ed413cbd285983aa2e10"
> >
> >
> >
> > ------------------------------------
> >
> > Request Completed Successfully
> >
> > Request Time in seconds: 0.002809
> >
> > ------------------------------------
> >
> >
> >
> > Received Data: {
> >
> >   "ilsevent":1000,
> >
> >   "textcode":"LOGIN_FAILED",
> >
> >   "desc":"User login failed",
> >
> >   "pid":1385,
> >
> >   "stacktrace":"oils_auth.c:565"
> >
> > }
> >
> >
> >
> > ------------------------------------
> >
> > Request Completed Successfully
> >
> > Request Time in seconds: 0.005666
> >
> > ------------------------------------
> >
> > Login Session: (none).  Session timeout: 0.000000
> >
> >
> >
> > As I have created the database schema and configured the system using
> > command
> >
> >
> >
> > perl Open-ILS/src/support-scripts/eg_db_config.pl --update-config \
> >
> >        --service all --create-schema --create-offline \
> >
> >        --user evergreen --password evergreen --hostname localhost --port
> > 5432 \
> >
> >        --database evergreen --admin-user admin --admin-pass leo
> >
> >
> >
> >
> >
> >
> >
> > Pleae help me in this as ii am totally stuck and cant seem to get
> > through,,,,,,,,,,,,,,,,,,
>
> Muhammad Faiz Chishti
>
> Did this instance ever work?
> Is the /openils directory tree owned by user opensrf?
> When you added the /openils directory to opensrf's path, were you
> acting as that user, or did you add those directories to root's path?
>
> Also, I believe it is a mistake to make the admin user something other
> than evergreen (or postgres)
>
>
>
> --
> This Apt Has Super Cow Powers - http://sourcefreedom.com
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20110815/50c0e9be/attachment.htm>

[OPEN-ILS-GENERAL] ***SPAM*** RE: ***SPAM*** Urgent help required please

[OPEN-ILS-GENERAL] SPAM RE: SPAM Urgent help required please