[OPEN-ILS-DEV] installation issue with Evergreen 2.0.8 on Ubuntu 11.04

Thu Aug 18 15:46:54 EDT 2011

Thanks for your help, that was exactly the issue (well, the git version of
the sql file) did indeed fix the issue.

Thanks again,

Jp

On Wed, Aug 17, 2011 at 3:23 PM, Dan Wells <dbw2 at calvin.edu> wrote:

> Hello Jp,
>
> I think your original message got through, so no need to worry.
>
> As for your problem, I think it is likely that you are running into this
> bug:
>
> https://bugs.launchpad.net/evergreen/+bug/826844
>
> I hit it myself a few days ago installing 2.0.8.  It can effectively
> prevent INSERTs into the actor.org_unit table, which then means no users,
> which then means no login.  If you are willing, please try replacing (in
> your Evergreen source download):
>
> Open-ILS/src/sql/Pg/005.schema.actors.sql
>
> with the code found at:
>
>
> http://git.evergreen-ils.org/?p=working/Evergreen.git;a=blob_plain;f=Open-ILS/src/sql/Pg/005.schema.actors.sql;hb=890fa6b9dfa5ec7968ba1f79a5e2c96c84196cb6
>
> After that, recreate the schema using the "Open-ILS/src/support-scripts/
> eg_db_config.pl" step, stop all, then restart all ("all" meaning router
> and perl and C services).  Please report back to let us know where you end
> up.
>
> Thanks,
> Dan
>
>
> --
>
> *********************************************************************************
> Daniel Wells, Library Programmer Analyst dbw2 at calvin.edu
> Hekman Library at Calvin College
> 616.526.7133
>
>
> >>> On 8/17/2011 at 1:30 PM, jean-philippe robichaud
> <jean.philippe.robichaud at gmail.com> wrote:
> > It seems that this message wasn't originally delivered.  I'm trying again
> > now.
> >
> > Please let me know if this is the wrong mailing list.  The Documentation
> > Pages are telling users to send this kind of report to the "dev' list,
> let
> > me know if I should use the General list instead.
> >
> > Thanks.
> >
> > Jp
> >
> > On Mon, Aug 15, 2011 at 10:36 PM, jean-philippe robichaud <
> > jean.philippe.robichaud at gmail.com> wrote:
> >
> >> Hello everyone.
> >>
> >> Originally, I installed EG 2.0.3 on a fresh Ubunto 10.04 box and the
> >> installation went fine.  Unfortunately, I didn't had the chance to put
> this
> >> box in "production" (for a very small church library) and time passed
> by.  I
> >> decided to upgrade the box to Ubuntu 11.04 and push the EG version to
> 2.0.8
> >> so I followed the instructions again (the opensrf release at that time
> was
> >> still on the 1.6 branch, now it is 2.0.0).
> >>
> >> So I dropped the postgres "evergreen" db and followed the new
> installation
> >> guide (installing opensrf, creating the postgres db, then installing
> >> evergreen).
> >>
> >> Now everything seems fine according to settings-tester.pl, but I can't
> >> login using the srfsh shell nor the xulrunner interface (the web-site
> shows
> >> up properly it seems)
> >>
> >> Here is what I have when I try to login (the 'egadmin/eglise' user/pw
> are
> >> the one I gave as admin-user/admin-password to the
> eg_db_config.plcommand).
> > The srfsh.log (attached) is not helping me ...
> >>
> >> **
> >>
> >>
> >> opensrf at biblio:~/evergreen$ srfsh
> >> srfsh# login egadmin eglise
> >>
> >> Received Data: "bba887e71566956dfb8cbc1c76b6f0fa"
> >>
> >> ------------------------------------
> >> Request Completed Successfully
> >> Request Time in seconds: 0.004986
> >> ------------------------------------
> >>
> >> Received Data: {
> >>   "ilsevent":1000,
> >>   "textcode":"LOGIN_FAILED",
> >>   "desc":"User login failed",
> >>   "pid":9640,
> >>   "stacktrace":"oils_auth.c:565"
> >> }
> >>
> >> ------------------------------------
> >> Request Completed Successfully
> >> Request Time in seconds: 0.024701
> >> ------------------------------------
> >> Login Session: (none).  Session timeout: 0.000000
> >> srfsh# exit
> >>
> >>
> >> Now here is what the setting-tester.pl is reporting.  In the zip file
> >> attached are the openils config files, the srfsh log as well as the
> >> .srfsh.xml config file.  Any help would be really appreciated.  I can
> >> provide more files and run some more tests if needed.  Thanks for this
> great
> >> software and for your help!
> >>
> >> Jp
> >>
> >> opensrf at biblio:~/evergreen$
> >> ./Evergreen-ILS-2.0.8/Open-ILS/src/support-scripts/settings-tester.pl
> >> LWP::UserAgent version 5.835
> >> XML::LibXML version 1.70
> >> XML::LibXML::XPathContext version 1.70
> >> XML::LibXSLT version 1.70
> >> Net::Server::PreFork version 0.99
> >> Cache::Memcached version 1.29
> >> Class::DBI version 3.0.17
> >> Class::DBI::AbstractSearch version 0.07
> >> Template version 2.22
> >> DBD::Pg version 2.17.2
> >> Net::Z3950::ZOOM version 1.26
> >> MARC::Record version 2.0.3
> >> MARC::Charset version 1.31
> >> MARC::File::XML version 0.93
> >> Text::Aspell version 0.09
> >> CGI version 3.43
> >> DateTime::TimeZone version 1.23
> >> DateTime version 0.66
> >> 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.29
> >> Email::Send version 2.198
> >> Text::CSV version 1.21
> >> Text::CSV_XS version 0.80
> >> Spreadsheet::WriteExcel::Big version 2.37
> >> Tie::IxHash version 1.21
> >> Parse::RecDescent version 1.965001
> >> 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.
> >> * /opensrf/default/apps/open-ils.qstore/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.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
> >>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20110818/44fb14ed/attachment.htm>