Open Source Integrated Library System

Evergreen on IRC

#evergreen Logs for Sunday, February 20th, 2011

< Saturday, February 19th, 2011Raw Log FileMonday, February 21st, 2011 >
#TimeNickMessage
#09:07:40bshum has joined #evergreen
#11:39:42elene has joined #evergreen
#11:40:50elenehello everyone
#11:41:12elenei have a quick question about evergreen 2.0.1 installation
#11:41:18elenewould be great if someone could help
#11:42:58eleneI just installed 2.0.1 on Ubuntu 10.04 for testing purposes and it seems to load the OPAC ( http://opac2.library.ac.ge )
#11:43:16elenebut when I try to log in from Staff Client as the administrator, I get the following error:
#11:43:22elenemethod=open-ils.auth.authenticate.init
#11:43:22eleneparams=["isiadmin"]
#11:43:23eleneTHROWN:
#11:43:23eleneNetwork Failure: status = 200
#11:43:23eleneservice=open-ils.auth&method=open-ils.auth.authenticate.init&param=%22isiadmin%22
#11:43:23eleneSTATUS:
#11:43:23elene200
#11:43:56eleneCould anyone help me find out what the error means?
#11:43:58elenethanks!
#11:44:21phasefxelene: a status 200 as an error is very weird. hrmm
#11:44:49elenehi phasefx, thanks for ur help
#11:45:04elenewould u happen to know a log file where I could take a look?
#11:46:40phasefxhave you restarted apache since starting/restarting opensrf? (oy, my isp is going up and down, so
#11:47:52eleneyes, I have tried restarting everything and everything seems to be loading without problems
#11:48:41eleneanother strange thing is that when visiting http://opac2.library.ac.ge it seems to work, but the system will not allow me to choose languages from drop-down menu :)
#11:49:08phasefxrestarting apache last in the order of events?
#11:51:25eleneI am not sure what it means :) could you tell me the right order of restarting everything?
#11:52:14phasefxhttp://evergreen-ils.org/dokuwiki/doku.php?id=troubleshooting:checking_for_errors
#11:55:55phasefxapache is always restarted last, after an osrf_ctl.sh start_all or restart_all
#11:56:57elenethank you. yes, I did try the steps outlined at the wiki article, except fishing for the errors
#11:57:07eleneas I am not familiar with error log files :)
#11:57:40eleneapart from checking error logs, everything seems to be working fine and no errors are reported when starting or stopping the services
#11:58:12eleneperhaps you could advise me which log file would be responsible for the error i mentioned?
#12:05:08phasefx_I'd grep for ERR and Fail with all the logs in /openils/var/log/. In this case, I'd expect to see something in gateway.log or activity.log (I forget which would be configured for a wiki install), and also in the Apache logs (probably /var/log/apache/)
#12:05:43elenei see. thanks a lot. i will take a look now :)
#12:20:30eleneI deleted logs, restarted server and chcked osrfsys.log which includes this error message, many times.
#12:20:31elene[2011-02-20 17:18:27] /usr/sbin/apache2 [ERR :23882:EX.pm:66:] Exception: OpenSR
#12:20:31eleneF::EX::Session 2011-02-20T17:18:27 OpenSRF::Utils::SettingsClient /usr/local/sha
#12:20:31elenere/perl/5.10.1/OpenSRF/Utils/SettingsClient.pm:103 Session Error: router@private
#12:20:31elene.localhost/opensrf.settings IS NOT CONNECTED TO THE NETWORK!!!
#12:21:26elenegateway.log also has some errors:
#12:21:26elenegateway 2011-02-20 17:18:27 [WARN:23882:transport_session.c:783:] Error 401 in I
#12:21:27eleneQ packet: not authorized
#12:21:51eleneand then these two errors:
#12:21:55elenegateway 2011-02-20 17:18:27 [WARN:23882:transport_session.c:685:] Error connecti
#12:21:55eleneng to jabber
#12:21:56elenegateway 2011-02-20 17:18:27 [INFO:23882:transport_session.c:667:] Received <erro
#12:21:56elener> message with type auth and code 401
#12:24:24elenedoes this mean something went wrong with the installation? :)
#12:26:22bshumelene: Indeed, that looks like something went wrong with your ejabberd
#12:27:28eleneI see. would you suggest reinstalling ejabberd, or deleting entire system and reinstalling server and evergreen from scratch?
#12:27:39bshumWhen you installed OpenSRF, did you change all the parts of the /etc/ejabberd/ejabberd.cfg file?
#12:28:20bshumAlso (this came up recently) but did you use any special characters in the ejabberdctl registration part?
#12:28:30bshumOther than numbers and letters
#12:28:59bshumThe changes to ejabberd.cfg are noted in step 6 of the OpenSRF 1.6 install
#12:29:13bshumSometimes people miss the other bullet items towards the end
#12:29:19elenethanks, bshum! I think I followed the guide and changed all the parts. my evergreen is 2.0.1
#12:29:21bshumFor max_stanza_size, maxrate, mod_offline
#12:30:25eleneI have max_stanza_size, 2000000
#12:30:43bshumSounds like you got those good
#12:30:43elenemaxrate 500000
#12:31:03bshumDid you use any special characters when registering ejabberd users in step 8?
#12:31:31elenelet me quickly check step 8
#12:31:35bshumSure.
#12:31:41elenei gather the step is same in 1.6 and 2.0 guide
#12:32:03bshumStep 8 of the OpenSRF install guide for 1.6.2 version of OpenSRF: http://www.open-ils.org/dokuwiki/doku.php?id=opensrf:1.6:install
#12:32:33bshumThe Evergreen install guide is something else.
#12:33:05elenei see. i am checking now
#12:34:02eleneI see. yes, I did follow the step and registered all the four users
#12:34:10eleneand used simple passwords without special chars :)
#12:35:09bshumOkay, good to check
#12:36:18elenethanks. would you advise me to reinstall opensrf (if thats possible), or reinstall everything from scratch? :)
#12:37:54bshumWell, if you reinstall opensrf then you have to reinstall Evergreen as well. Starting from scratch is certainly an option too, but a bit drastic.
#12:38:18bshumI'm not sure exactly, but 401 seems like an authentication error.
#12:38:52bshumMaybe your opensrf_core.xml file has the wrong passwords in it?
#12:39:52bshum(unlikely, now I'm just guessing)
#12:40:00bshum hates Sundays
#12:40:14eleneloool
#12:40:26eleneis there a way for me to check the passwords?
#12:40:42elenelike try logging in from terminal somehow
#12:42:05bshumWell, you would just open up the /openils/conf/opensrf_core.xml file using a text editor in the terminal and looking for the parts that define <passwd> or <password>
#12:42:38elenegreat thanks i'll do just that
#12:50:48eleneI did. They all seem to be correct :(
#12:50:54eleneshould I check router log files?
#12:51:41elenerouter private log has this error in it:
#12:51:44elenerouter 2011-02-20 17:18:05 [WARN:26609:transport_session.c:642:] Received <strea
#12:51:44elenem:error> message from Jabber server
#12:51:44elenerouter 2011-02-20 17:18:05 [WARN:26609:osrf_router.c:229:] Top level select call
#12:51:44elene failed with errno 9: Bad file descriptor
#12:51:44elenerouter 2011-02-20 17:18:05 [WARN:26609:socket_bundle.c:553:] _socket_send(): Err
#12:51:45eleneor sending data with return -1
#12:51:45elenerouter 2011-02-20 17:18:05 [WARN:26609:socket_bundle.c:554:] Last Sys Error: Bad
#12:51:45elene file descriptor
#12:52:15eleneand router public log includes this error:
#12:52:17elenerouter 2011-02-20 17:18:05 [WARN:26608:transport_session.c:642:] Received <strea
#12:52:17elenem:error> message from Jabber server
#12:52:17elenerouter 2011-02-20 17:18:05 [WARN:26608:osrf_router.c:229:] Top level select call
#12:52:17elene failed with errno 9: Bad file descriptor
#12:52:18elenerouter 2011-02-20 17:18:05 [WARN:26608:socket_bundle.c:553:] _socket_send(): Err
#12:52:18eleneor sending data with return -1
#12:52:18elenerouter 2011-02-20 17:18:05 [WARN:26608:socket_bundle.c:554:] Last Sys Error: Bad
#12:52:19elene file descriptor
#12:55:51phasefxelene: if we fail to help you here today (very few folks around), you may want to send a copy of your logs/configs (with sensitive passwords scrubbed) to the OPEN-ILS-DEV mailing list
#12:56:39elenethank you phasefx. I will that.
#12:57:04elenephasefx, bshum, thanks very much for your help!
#12:57:08phasefxminimal logs as suggested in the checking_for_errors document
#12:57:33eleneI see
#12:57:38eleneallright
#12:57:59phasefxjust mean, stop everything, erase the logs, then start stuff back up
#12:58:59phasefxin this case, I bet you'll get errors with start_router (assuming you replace start_all with start_router, start_perl, and start_c), so could stop there
#13:03:28elene has quit IRC
#13:05:58bshumPfft, lesson learned... don't uninstall memcached from a drone until *after* Evergreen is all installed...
#13:06:17bshum:(
#13:06:34_bott_ has quit IRC
#13:08:32elene has joined #evergreen
#13:09:18elenehello again, I was disconnected, so did not have a chance to say goodbye :)
#13:09:33eleneso thanks again for your help and I will be posting the logs on the list
#13:09:59rsinger has quit IRC
#13:11:21elene has left #evergreen
#13:42:50jennam has quit IRC
#15:13:02bshumHmm
#15:13:18bshumJust a guess, and if someone is around, let me know
#15:13:27bshumBut if we're using an NFS share for /openils/var
#15:13:37bshumIt seems like I should change the opensrf.xml file
#15:13:46bshumSo that the unix.pids go somewhere else
#15:13:59bshumOtherwise, the NFS share locks up usage of to only one computer?
#15:23:22bshumCool, guess that does work.
#15:29:10jeffbshum: yes, there was some discussion about that last week -- closely related, if not exactly the same scenario
#15:29:37bshumjeff: Neat, I'll check back in the logs to see if I can find something about it.
#15:31:49bshumThanks!
#15:33:53jeff'welcome
#15:34:00jeffhow did the upgrade go?
#15:34:34bshumjeff: Still underway; been a long weekend :)
#15:34:54bshumBased on that last tidbit, I think I'll have our bricks rockin' and rolling shortly.
#15:35:16eeevilbshum: db upgrade went smoothly?
#15:35:23jeffexcellent. continued good luck, and enjoy!
#15:35:24bshumeeevil: As far as we can tell.
#15:35:41eeevil:)
#15:35:41bshumeeevil: There was one minor hiccup, but I think it turned out to be a bad sequence on our end.
#15:36:17bshumeeevil: Bumping the sequence higher allowed us to upgrade to 2.0+ very smoothly.
#15:36:17eeevilgood good ... lots of folks will end up using that, so that it worked for you is great news
#15:36:38bshumNext step, 9.0, right? :)
#15:36:52eeevilbshum: mind making a note of that sequence on the wiki and the -dev list?
#15:37:08bshumeeevil: Sure, I'd be happy to. For us, it was probably an accident.
#15:37:22bshumWe use action/trigger notices
#15:37:31bshumAnd it looks like one of the new samples was bumping against ours
#15:37:39bshumBecause we hadn't done the sequence right
#15:37:51bshumDirect DB editing fail :(
#15:38:18eeevilbshum: that, (9.0) thankfully, should be pretty easy ... if you have a machine with lots of drive space for testing, I'd be interested to know if pg_upgrade (binary/in-place major version upgrade) works well
#15:38:39bshumeeevil: It's already on my to-do list for next week. :D
#15:38:42eeevilrad
#16:07:27dbsbshum: been working on (ugh) physical stuff but discussion you and I had re NFS and openils/var was on Feb 15
#16:07:52dbs has nice pink bits of insulation decorating his scalp
#16:08:14bshumOh gosh
#16:08:19bshumThat really was *me* wasn't it? :S
#16:08:57bshumHmm
#16:09:03bshumThat makes perfect sense.
#16:09:13bshumI just didn't realize it applied to the opensrf.xml config files directly.
#16:09:27bshumIt seemed that the oils_brick example would have taken care of it.
#16:14:00bshumThanks dbs
#16:14:33dbsbshum: happy to be of some help on the weekend o' stress :)
#16:18:30bshumOh shoot, you DID say it.
#16:18:40bshum2011-02-15T11:23:00 <dbs> /openils/var/run doesn't work if /openils = NFS
#16:18:55bshumGo figure, I just completely missed the meaning behind that
#16:19:21dbsbshum: I probably didn't express it clearly enough
#16:19:39bshumWell, no worries, it's all coming together!
#16:19:45dbssupa!
#16:32:41bshum1 has joined #evergreen
#16:32:47bshum has quit IRC
#16:32:49bshum1 is now known as bshum
#16:51:41elene has joined #evergreen
#16:53:24elenehi everyone. i am in the process of installing opensrf 1.6.2 and seem to have a problem registering ejabberd users (section 8 i of the guide)
#16:53:46eleneI issue the command
#16:53:55eleneejabberdctl register router private.localhost testpassword
#16:54:09eleneand I get an error
#16:54:10eleneCan't register user router@private.localhost at node ejabberd@opac2: not_allowed
#16:54:55elenemy ejabberd.cfg includes this line: {auth_method, internal}.
#16:55:14eleneWould anyone have a quick hint, or should I post my question to the mailing list?
#16:55:15eleneThanks
#16:57:25dbselene: what does your "hosts" line in ejabberd.cfg say?
#16:57:45elenehi dan, many thanks for answering me
#16:57:51elenei will check quickly
#16:58:13eleneit says: {hosts, ["localhost"]}.
#16:58:17dbsah
#16:58:34dbsyou're getting ahead of yourself, then; you need to edit it first to say: {hosts, ["localhost", "public.localhost", "private.localhost"]}.
#16:58:47dbsand then you'll need to restart ejabberd
#16:59:03eleneoops i seem to have missed that step :)
#16:59:11elenethank you so much :)
#16:59:14jeffdbs++
#17:00:14dbsMight as well make sure you've got all of step 6 on http://evergreen-ils.org/dokuwiki/doku.php?id=opensrf:1.6:install done before moving on :)
#17:00:32elenei see. thank you.
#17:01:03dbs goes back into the basement to get some more labour done
#17:07:33dbsbut not before checking out http://jshint.com/ for possible integration into the buildbot
#17:13:37jeffwhat, no "xulrunner" Environment setting? :)
#17:53:15bshum has quit IRC
#18:50:27eleneim afraid i have one more question :)
#18:50:45elenei seem to have finished EG 2.0.1 installation
#18:51:02elenebut when i issue autogen
#18:51:16elenei get this error
#18:51:24eleneUpdating Evergreen organization tree and IDL using '/openils/conf/opensrf_core.xml'
#18:51:24eleneUpdating fieldmapper
#18:51:24eleneEmpty filename at /openils/lib/perl5/OpenILS/Utils/Fieldmapper.pm line 197
#18:52:12eleneplease note that this is the first time i am running the autogen script in this installation
#18:52:17elenethanks
#18:55:19elenethis is how my Fieldmapper.pm file looks like at that section:
#18:55:46elene194 # parse the IDL ...
#18:55:46elene195 my $parser = XML::LibXML->new();
#18:55:46elene196 my $file = $args{IDL} || OpenSRF::Utils::SettingsClient->new->config_value( 'IDL' );
#19:04:14eleneI have seen Dan's reply on mailing list on similar question at http://list.georgialibraries.org/pipermail/open-ils-general/2010-February/002544.html
#19:05:23elenesuggesting that the problem lies in having old opensrf_core.xml and opensrf.xml files, and that opensrf.xml. file should include an <IDL> element.
#19:06:09elenehowever, taking a look at the installation guides of eg 2.0.1. and opensrf 1.6.x, I can not file any reference to <IDL> element
#19:34:05jeffelene: the <IDL> element isn't mentioned in the install docs, it's just that the OpenSRF tarball includes an example opensrf config that does not include that element, while the Evergreen tarball includes an example opensrf config that DOES contain that element.
#19:36:00elenethank you, jeff. I skipped copying the EG example files
#19:36:21eleneas I though I had already done it when installing OpenSRF
#19:37:28eleneI have now overwritten the files and reentered passwords in opensrf_core.xml
#19:37:45elenenow, when issuing autogen
#19:37:55eleneit does seem to work a bit
#19:38:09eleneUpdating Evergreen organization tree and IDL using '/openils/conf/opensrf_core.xml'
#19:38:09eleneUpdating fieldmapper
#19:38:09eleneUpdating web_fieldmapper
#19:39:15eleneJeff, could you kindly advise me where I could read about how I should configure opensrf.xml file? thanks.
#19:46:29dbselene: the eg_db_config.pl script generally does all of the configuration of opensrf.xml you need for a basic Evergreen installation script
#19:49:09elenethank you, dan. i have copied the xml files again from eg, and rerung the eg_db_config.pl script again
#19:49:27elenebut when running autogen, I still get this error
#19:49:45eleneUpdating Evergreen organization tree and IDL using '/openils/conf/opensrf_core.xml'Updating fieldmapper
#19:49:45eleneUpdating web_fieldmapper
#19:49:45eleneUpdating OrgTree
#19:50:27eleneSo I thought it was because my opensrf.xml was not configured correctly :)
#20:02:22dbsI ... don't see an error there
#20:05:54eleneoops
#20:06:10elenethis is the error i am getting when issuing autogen?
#20:06:21elene.Exception: OpenSRF::EX::Session 2011-02-21T00:48:51 OpenSRF::Transport /usr/local/share/perl/5.10.1/OpenSRF/Transport.pm:92 Session Error: mailto:router@private.localhost/open-ils.cstore IS NOT CONNECTED TO THE NETWORK!!!
#20:17:09eleneejabberd status:
#20:17:18eleneejabberdctl status
#20:17:18eleneThe node ejabberd@opac2 is started with status: started
#20:17:18eleneejabberd 2.1.2 is running in that node
#20:17:59dbselene,
#20:18:32dbselene: sorry - hmm - how did you start the OpenSRF services? Did you use the "-l" flag for osrf_ctl.sh?
#20:18:43eleneyes i did
#20:19:08eleneand i access the domain by: opac2.library.ac.ge
#20:19:15eleneit has a fqdn
#20:19:43elenebut i have not entered it anywhere, except in /etc/hosts file
#20:19:56dbsyeah, that should be okay
#20:20:03elenegood thanks
#20:20:19dbsSo we need to figure out why open-ils.cstore isn't starting (or staying connected)
#20:20:29elenei see
#20:21:02dbsthis would probably be a good time to post your /openils/var/log/osrfsys.log somewhere
#20:21:13elenei see just a second
#20:24:23dbs@later tell eeevil Hey, so RFC3339 requires a colon in the timezone offset between hour and minute; I guess that's why Dojo requires it (and ECMAScript 5 provides ISO parsing based on RFC3339). My curiosity is finally satisfied :)
#20:24:23pinesoldbs: The operation succeeded.
#20:27:28eleneok, i pasted the last lines of the osrfsys.log
#20:27:28elenehttp://paste.lisp.org/display/119857
#20:30:03dbsHmm, "Could not open TCP socket to Jabber server: IO::Socket::INET: connect: Connection refused" sounds like ejabberd wasn't running for a while? It isn't clear what order things are happening in. Can you:
#20:30:24dbs1) Shut down the opensrf services with: "osrf_ctl.sh -l -a stop_all"
#20:30:36eleneok
#20:31:00elenei did
#20:31:08eleneosrf_ctl.sh -l -a stop_all
#20:31:08dbs2) Clean out any process ID files (PID files) with the command: "rm -f /openils/var/run/*pid"
#20:31:08eleneStopping OpenSRF C process 7316...
#20:31:08elenekill: 209: No such process
#20:31:27elenei did
#20:31:45dbs3) Remove any log files with the command "rm -f /openils/var/log/*.log"
#20:32:03elenei did
#20:32:24dbs4) Start the opensrf router with "osrf_ctl.sh -l -a start_router"
#20:32:44dbsthen paste the contents of the new /openils/var/log/osrfsys.log file
#20:32:46elenei did
#20:33:15elenethere is no error log
#20:33:53elenelog directory contains only router-public.log and router-private.log
#20:34:34eleneshould I try osrf_ctl.sh -l -a start_all and see if logs are created?
#20:35:10dbsno
#20:35:18dbswe're just going step by step
#20:35:25elenei see
#20:35:36dbsokay, now start the perl services: "osrf_ctl.sh -l -a start_perl"
#20:35:49dbsand paste the contents of the new /openils/var/log/osrfsys.log file
#20:37:23eleneok this did generate a huge osrfsys.log
#20:37:23elenehttp://paste.lisp.org/display/119859
#20:38:30eleneand also, lots of open-ils*unix.log files were created in log dir
#20:38:49elenethey all have this error in them:
#20:38:49elene2011/02/21-01:36:24 OpenSRF::UnixServer (type OpenSRF) starting! pid(17814)
#20:38:49eleneBinding to UNIX socket file /openils/var/lock/open-ils.ingest-unix.sock using SOCK_STREAM
#20:39:09elene2011/02/21-01:36:24 OpenSRF::UnixServer (type OpenSRF) starting! pid(17814)
#20:39:18eleneBinding to UNIX socket file /openils/var/lock/open-ils.ingest-unix.sock using SOCK_STREAM
#20:39:20dbsthose aren't errors, they're just INFO
#20:39:30dbsbut "router@private.localhost/opensrf.settings IS NOT CONNECTED TO THE NETWORK!!!" is definitely a sign of a problem
#20:39:38elenei see
#20:40:12elenei have a fresh ubuntu 10.04 and tried to follow the guides step by step
#20:40:47dbsthat's okay
#20:40:54elenethough i may have done something wrong :(
#20:41:19dbsmight be a problem with the password for the router@private.localhost ejabberd user not being specified correctly in opensrf_core.xml
#20:41:40dbsI would suggest double-checking opensrf_core.xml
#20:41:45eleneok, i will reregister the user now now and reenter the pwd
#20:42:47dbsif you try to reregister the user, don't be surprised if ejabberd says "Hey, this user has already been registered!"
#20:45:03elenei checked and the password seems to be correct. I tried reregistering the user, but it tells me that User router@private.localhost already registered at node ejabberd@opac2
#20:45:37eleneshould I delete the user and try reregistering?
#20:45:41dbsno
#20:46:00dbsmight be a good time to try the settings-tester.pl script
#20:46:53eleneok, as root or as opensrf?
#20:46:54dbsas the "opensrf" user, run "perl Open-ILS/src/support-scripts/settings-tester.pl > testing.out" and paste the contents of testing.out ?
#20:47:52eleneok
#20:50:59elenedbshttp://paste.lisp.org/display/119861
#20:52:13eleneno errors :|
#20:52:16dbselene: weird. seems fine
#20:52:36elenewhat if i just rebooted the server again?
#20:52:45eleneperhaps that could help?
#20:53:19eleneor perhaps i could paste the contents of the xml files?
#20:53:20dbsnho
#20:53:23dbsno no no
#20:53:32dbsdon't reboot the server
#20:53:38eleneok
#20:54:42eleneshould i paste opensrf.xml and opensrf_core.xml files? the passwords there are just generic testing passwords
#20:54:47dbsLet's just go ahead and try starting up the OpenSRF C services: "osrf_ctl.sh -l -a start_c"
#20:54:52eleneok
#20:55:09eleneok i think it started
#20:55:15eleneshould i check the logs now?
#20:55:27dbsokay - yes, then open up osrfsys.log and jump to 2011-02-21 01:36:26
#20:55:43dbsand see if there's anything interesting after that
#20:56:24dbsThere will probably be many log entries for cstore, including some "errors"
#20:57:00dbsmaybe the best bet is just to paste the results of "grep ERR /openils/var/log/osrfsys.log"
#20:58:44eleneok
#21:00:23elenehttp://paste.lisp.org/display/119862
#21:00:50elenei think this is the same error we saw last time
#21:02:05dbsyep, same timestamp. Okay, that's reasonably good
#21:02:22dbsdoes "ps wax | grep open-ils.cstore" show anything?
#21:02:23elenereally?
#21:02:41elene ps wax | grep open-ils.cstore
#21:02:41elene 6039 ? S 0:00 OpenSRF Listener [open-ils.cstore]
#21:02:41elene 6047 ? S 0:00 OpenSRF Drone [open-ils.cstore]
#21:02:53eleneoops, too long to paste here
#21:03:21elenehttp://paste.lisp.org/display/119863
#21:03:24elenehere it is
#21:04:59dbsgood
#21:05:10dbsso what does "autogen.sh -u" do now?
#21:06:06elenehttp://paste.lisp.org/display/119864
#21:06:28elenei think this is something new
#21:07:09dbshmm - okay, can you paste the last bits of osrfsys.log again then?
#21:07:21eleneok
#21:08:14dbs(that error basically says the ->gather() method call failed)
#21:09:29eleneok here it comes
#21:09:30elenehttp://paste.lisp.org/display/119865
#21:11:03elenehmm, is something wrong with the db scheme?
#21:11:49dbsyeah, "ERROR: schema "config" does not exist" is bad
#21:12:41dbsit sounds like the "eg_db_config.pl" command was either issued without the "--create-schema" option, or that it failed
#21:13:55elenei see
#21:14:00eleneshould i rerun it?
#21:14:14dbsyou should be able to "osrf_ctl.sh -l -a stop_all" and the "eg_db_config.pl --create-schema" to try creating it again, then "osrf_ctl.sh -l -a start_all; autogen.sh -u" to try again
#21:14:46eleneok
#21:15:25elenewait
#21:15:33elenei accidentally ran
#21:15:40elene./autogen.sh -c /openils/conf/opensrf_core.xml -u
#21:15:44eleneand it said:
#21:15:53eleneautogen finished running, now run ./configure
#21:15:59elene has left #evergreen
#21:16:20elene has joined #evergreen
#21:16:31elenedoes this change anything?
#21:18:07elenethis is what it said
#21:18:08elenehttp://paste.lisp.org/display/119866
#21:19:01dbsthat's a different (confusing) autogen.sh script
#21:19:13dbsso no, it doesn't change anything
#21:20:50elenei see. i ran the commands you suggested
#21:21:05eleneand create schema brought up lots of erros
#21:21:08eleneerrors
#21:21:52elenehttp://paste.lisp.org/display/119867
#21:22:19dbsLooks like you missed some of the Evergreen installation commands
#21:22:37elenei see :(
#21:23:11elenei did run this command:
#21:23:11eleneeg_db_config.pl
#21:23:20elenei mean
#21:23:24eleneperl Open-ILS/src/support-scripts/eg_db_config.pl --update-config \
#21:23:24elene --service all --create-schema --create-offline \
#21:23:24elene --user <user> --password <password> --hostname <hostname> --port <port> \
#21:23:25dbsSee step 2. II. in http://evergreen-ils.org/dokuwiki/doku.php?id=server:2.0:install
#21:23:44dbsdid you run "make -f Open-ILS/src/extras/Makefile.install install_pgsql_server_debs_84" as root when you were going through these steps?
#21:24:23dbsand if so, then you also needed to run the commands in 3. "Issue the following commands on your PostgreSQL server, adjusting the path for the contrib repository..."
#21:24:26eleneyes, i believe i did
#21:25:06eleneyes, i also substituted the distro with ubuntu-lucid
#21:25:54dbsthe "ERROR: language "plpgsql" does not exist" tells me that either you didn't install the postgresql libs, or you didn't run the commands like "createlang plpgsql evergreen"
#21:26:16eleneoops, i did not adjust the path
#21:26:41elenei left /usr/share/postgresql/8.4/contrib/
#21:26:54elenebut i guess this might not have been wrong
#21:27:11elenei see, it WAS wrong
#21:28:13elenestrangely, i can not find contrib dir. it is neither /usr/local/share/contrib/ nor
#21:30:50eleneok i checked
#21:31:05dbshttp://packages.ubuntu.com/lucid/amd64/postgresql-contrib-8.4/filelist suggests that it should be /usr/share/postgresql/8.4/contrib/
#21:31:14eleneyes it is
#21:31:26eleneso i did not have to adjust the path
#21:32:05dbsso when you become the "postgres" user and run "createlang plpgsql evergreen" -- what happens?
#21:32:16elenesu let me see
#21:33:03elenepostgres@opac2:/root$ createlang plpgsql evergreen
#21:33:04elenecould not change directory to "/root"
#21:33:04elenecreatelang: language "plpgsql" is already installed in database "evergreen"
#21:34:08dbsweird. that doesn't seem to match up at all with what the error message said
#21:34:50elenei probably did something wrong, otherwise other users would have complained of the same issues
#21:35:13dbsyour database name is "evergreen", right?
#21:35:29eleneyes, i did not change the command
#21:35:49elenei ran createdb -T template0 -E UNICODE evergreen
#21:36:35elenei think there was an automated installer script for very early version of evergreen. does something like this still exist for 2.0 or 1.6?
#21:36:54dbsyes...
#21:37:27eleneperhaps i would have better luck with that :)
#21:37:47dbshttp://svn.open-ils.org/trac/ILS-Contrib/browser/ESI-Examples/trunk/tools/eg_dev_squeeze_installer - for Debian Squeeze
#21:38:44elenegreat. i gather this will not work on ubuntu
#21:39:00dbsprobably not without some customization
#21:40:02dbsI'm really confused as to why on the one hand PostgreSQL is saying that plpgsql is already installed in the "evergreen" database, yet when you try to create the schema it fails because plpgsql is not installed
#21:40:33dbsis your database on the same server as the rest of evergreen?
#21:40:39eleneyes
#21:41:07eleneand i used fresh ubuntu installation on VPS
#21:45:43jefftwo postgresql installs, psql / createlang using one port while another is being specified for eg_db_config.pl?
#21:50:29dbsjeff: nope
#21:50:40jeffdrat.
#21:50:49jeffthat's at least a known situation to deal with.
#21:51:01dbstsearch2 wasn't installed
#21:51:09dbsand now... autogen.sh -u ran cleanly
#21:52:05dbsrestart apache, and... http://opac2.library.ac.ge comes up with the locale selector working
#21:55:23dbs tries to wrap his head around adding SRU support for NAF/SAF requests
#22:13:23jennam has joined #evergreen
#22:13:49jennam is now known as Guest47999
#22:14:00Guest47999 is now known as jennam
#22:14:02jennam has joined #evergreen
#23:07:51elene has left #evergreen
< Saturday, February 19th, 2011Raw Log FileMonday, February 21st, 2011 >