Open Source Integrated Library System

Evergreen on IRC

#evergreen Logs for Friday, May 6th, 2011

< Thursday, May 5th, 2011Raw Log FileSaturday, May 7th, 2011 >
#TimeNickMessage
#00:13:32pmplett has quit IRC
#00:18:38pmplett has joined #evergreen
#00:45:18Callender has quit IRC
#00:45:42drdata_esi has quit IRC
#00:46:55Dmagick has quit IRC
#00:47:00mtate has quit IRC
#00:47:01phasefx has quit IRC
#01:31:24phasefx has joined #evergreen
#01:56:37Callender has joined #evergreen
#01:57:16drdata_esi has joined #evergreen
#03:17:36Callender has quit IRC
#04:35:31AndyWitter has quit IRC
#04:43:36phasefx has quit IRC
#04:45:57phasefx has joined #evergreen
#05:51:47tsbere@later tell bshum The version doubling would be for purposes of setting the installer tag to, say, 2.1 for folder and such when the version is 2.1.x. I can explain stopping the doubling if you want.
#05:51:47pinesol_greentsbere: The operation succeeded.
#05:52:07tsbere@later tell bshum Also, "make rigbeta" and "make rigrelease" work wonders for some stuff now
#05:52:07pinesol_greentsbere: The operation succeeded.
#05:53:26Andy_ has joined #evergreen
#05:53:52Andy_ is now known as Guest66265
#06:45:46rsinger has quit IRC
#07:05:34Guest66265 is now known as AndyW
#08:17:40remingtron has quit IRC
#08:17:52jenny has joined #evergreen
#08:22:43Petaris has joined #evergreen
#08:22:58kmlussier has joined #evergreen
#08:28:26PetarisMorning all
#08:28:28Petaris:)
#08:30:08PetarisI trying to create the Evergreen db but I get an error when I issue the command "createlang plperl evergreen", the error is: createlang: language installation failed: ERROR: could not access file "$libdir/plperl": No such file or directory
#08:31:36Petarisalso I checked on the contrib directory and its not in /usr/share/postgresql/8.4/contrib like it should be. Do I need to create this manually or is there something wrong with my postgresql install?
#08:40:12tsberePetaris: What version of Eg you installing?
#08:40:26Petaris2.0.5
#08:41:52Petarishrm
#08:42:19Petarisdoes the debian squeeze postgresql build have perl enabled?
#08:42:34PetarisThat seems to be what google is telling me is the problem
#08:45:22rsinger has joined #evergreen
#08:47:48Petaristsbere: Hrm, more googling and I found this: http://open-ils.org/irc_logs/openils-evergreen/2009-08/%23openils-evergreen.19-Wed-2009.log
#08:48:13PetarisDo I need to do this: 2009-08-19T11:58:24 <mrpeters-isl> did yoiu do echo "export PERL5LIB=/openils/lib/perl5:\$PERL5LIB" >> ~/.bashrc
#08:48:51eeevilPetaris: no, you need to: apt-get install postgresql-plperl-8.4
#08:49:03Petarisahh, ok
#08:49:10PetarisI didn't see that in the instructions
#08:49:57eeevilmake -f Open-ILS/src/extras/Makefile.install install_pgsql_server_debs_84 # should have done that for you
#08:50:28Petarisahh, I didn't do that as I had already installed postgre with apt
#08:50:45dbsPetaris: are you following the wiki instructions?
#08:50:55Petarisyeah
#08:50:59Petaristhese: http://www.open-ils.org/dokuwiki/doku.php?id=server:2.0:install
#08:51:09dbsYeah. See 2. II.
#08:52:12dbsalternately, if you're feeling very experimental, http://archive.georgialibraries.org/
#08:52:28dbs(for experimental DEBs for installing on Debian)
#08:52:43Petarisok, thanks dsb
#08:52:45dbsNote that those DEBs are unofficial and most of us have no idea how they were created
#08:52:48Petariser, dbs
#08:53:39AndyWyes these are experimental at the moment. recommend install on a fresh squeeze
#08:55:35kmlussier_ has joined #evergreen
#08:56:25kmlussier has quit IRC
#08:56:32kmlussier_ is now known as kmlussier
#08:59:32Petarisdbs, I'm running that script now
#08:59:56PetarisI guess I just mis read that note
#08:59:59Petarissorry
#09:00:19dbsEasy to do
#09:02:32eeevilAndyW: just putting it out there, but between the GSOC project and other interested parties, I think everyone (emerald, gpls and the community) would benefit greatly from some interaction on the DEB front ... I realize you're trying to build knowledge, but there are others that would love to /help/ that, and I'm more than a tiny bit concerned about technical decisions you're potentially making in packaging that could make your output less useful that it
#09:03:10tsbereeeevil: Dunno if there was more, you ended at "useful that it" for me
#09:03:15eeevilAndyW: so, consider this a gentle prod to write the -dev list, as a community member, about what you folks have been doing
#09:03:40eeevil... less useful that it might otherwise be, simply due to not having as many eyes as possible on the problem ... (thanks, tsbere)
#09:05:40collum has joined #evergreen
#09:05:48AndyWthx we are still just in the early stages of getting the packages built. Definitely plan on doing all of that.
#09:06:07AndyWI think bjwebb is going to work wiht us on it too
#09:06:48eeevilAndyW: my point is, we'd all benefit from /open/ communication as early as possible. like, during the decision making period about structuring the debs, etc
#09:08:12Dyrcona has joined #evergreen
#09:08:21AndyWunderstood. we plan on putting it up on git somewhere
#09:08:47AndyWcsharp is going to beat on that for us when he gets a chance
#09:08:50dbsAndyW: bjwebb and I certainly hope we can work with you! but for him, at least, it is a requirement for all of his work to be in the open - mailing list, IRC, repository
#09:09:36dbsand to the benefit of us all, as eeevil suggests (oh yeah - I'll be happy to set you up with wiki accounts if you don't already have them)
#09:09:45AndyWcoool that will work.
#09:10:08dbsgreat - just pm me name, desired username, and email address and I'll hook you up
#09:10:17AndyWk thx
#09:12:19bshumtsbere: Ah yes, I did notice that make rigbeta step and included it during my creation of the 2.1 staff client.
#09:12:57bshumI went back to find it when I noticed that the icons weren't being setup correctly.
#09:13:49tsberebshum: I try and document all of the changes I make on the page phasefx linked you to last night. What others do is a different story ;)
#09:14:06bshumHeh, tsbere++
#09:21:01yboston has joined #evergreen
#09:28:21tsbereQuestion: Is there documentation as to what the check digit function is supposed to be doing? It doesn't look anything like the one we use, and in some ways looks inefficient to me.
#09:30:11gmcharlttsbere: there are multiple checkdigit algorithms that could be used; IIRC, the one in Evergreen implements the "codabar" algo
#09:30:58tsbere"codabar" has no algo for that, and ours is /also/ referred to as that.
#09:31:50tsbereThe one there could be generating the same checksum as ours, I will have to run some tests to see
#09:33:00gmcharlttsbere: http://www.makebarcode.com/specs/codabar.html is the one I see most often
#09:33:43tsbereThat is what ours use. Yet that doesn't look like what exists in util/barcode.js to me. :/
#09:36:05gmcharlttsbere: at first glance, looks like they're equivalent
#09:36:10mtate has joined #evergreen
#09:36:44gmcharltthe util/barcode.js one just being yet another entry in the Obfuscated Codabar Checkdigit Function Contest :)
#09:36:54tsbereYea
#09:39:56tsbere feels that the methods he uses would generate different results on odd length barcodes than the one in util/barcode.js, though
#09:40:15dbseasy to test :)
#09:40:33gmcharlttest cases make the baby dbs weep...
#09:40:35gmcharlttears of joy!
#09:40:41tsbereWell, my methods are harcoded to scream on anything but a 14 digit barcode. So I would have to adjust them slightly first ;)
#09:43:37tsbereHey, I was right. Even digit count in barcode, both make the same. Odd digit count, I get different answers.
#09:45:02dbsheh, our system administrators just made me weep - they installed some HP tool that replace /etc/ld.so.conf the file with /etc/ld.so.conf a directory, presumably because they converted an RPM to DEB format to install on our system
#09:45:26dbsOf course, that broke dynamic linking horribly. Took me a while to figure out what had happened though
#09:46:38tsbere sees why he gets a difference, though
#09:46:53bshumdbs: Oh yes, that's a fun one. Happened to our HP servers that we use for DB.
#09:47:22dbsbshum: I guess we should make it an FAQ, if it's happened to two of us it will probably happen to more
#09:47:48tsbereI don't reverse the portion I am checksumming. On an odd number of digits to checksum (even length barcode) the even/odd position for doubling works out the same in both directions. On an even number of digits they are reversed....
#09:48:30gmcharltthat would do it
#09:48:36tsbere wonders which way is the "correct" way
#09:49:19gmcharlt has never heard of that checkdigit algo being applied to anything other than 14-digit barcodes, at least in library contexts, so I think we could just bake in a check on the barcode length
#09:51:15tsbereI am tempted to de-obfuscate the function in barcode.js, but am not sure if the reversing is the "correct" way to do it or not. I don't have a "non-14-digit" doc set for that.
#09:51:45jefftsbere: as just another data point, all of our 14 digit item barcodes pass this test: https://gist.github.com/958974 -- you could try it for some of your odd-length barcodes? *shrug*
#09:52:34jefftsbere: i found this and some of the linked pages helpful: http://en.wikipedia.org/wiki/Luhn_algorithm
#09:52:55gmcharltor http://git.esilibrary.com/?p=migration-tools.git;a=blob;f=sql/base/base.sql;h=6d9de88b9a138f1af7965b85fcb83f08aa90c252;hb=HEAD#l674
#09:53:50PetarisWhen I try to generate the web files for the staff client and catalogue I get this error:Can't call method "method_lookup" on an undefined value at /usr/local/share/perl/5.10.1/OpenSRF/Application.pm line 133.
#09:54:41jeff saves a copy of http://www.makebarcode.com/specs/codabar.html (linked from gmcharlt's code) for later
#09:55:49PetarisThat line is: my $coderef = $app->method_lookup( $method_name, $method_proto, 1, 1 );
#09:56:57bshumdbs: HP tools are quirky and strange. And I spent too many days looking at forums to figure their stuff out :(
#09:58:51tsbereOk. Knowing the "correct" way to do it, I can further simplify the check.
#10:01:21bshumPetaris: This error occurs during the autogen.sh process I'm guessing?
#10:02:09bshumPetaris: You may find additional information in logs, but I think whenever I encounter that error, I just go back and restart all the services on my Evergreen server (stop opensrf, restart memcached, ejabberd, start opensrf)
#10:05:08dbs looks sideways at upei's bug report - 856 subfield $u with parentheses around a second copy of the URL?
#10:05:41Ilmarinen has joined #evergreen
#10:06:51jlamos has joined #evergreen
#10:08:09Petarisbshum: Ok, I'll give that a try. I just ran it again and got a different error
#10:08:27dbsPetaris: how much RAM does your VM have?
#10:09:19Petarisdbs: I gave it 1 GB as I'm not running any graphical enviornment
#10:09:31dbsPetaris: okay, that should be plenty :)
#10:10:20bshumEh
#10:10:23bshumMaybe
#10:11:56jeffdbs: two second copies of the url, with some escaped and some unescaped ampersands? Dunno...
#10:13:45Petarisbshum: hrm, when I tried to restart ejabberd it failed this time
#10:13:51dbsjeff: yeah, I'm going to call that out. The "Equinox thinks there's some internal limit on the length of the URL" bit makes no sense to me. It's probably just a parsing error.
#10:14:23Petarisok, I just tried doing stop and start instead of restart and it worked
#10:14:25Petarisweird
#10:14:39bshumMaybe there was some stale process that it didn't like.
#10:14:51Petariscould be
#10:15:35eeevilit's surely the fact that there are 2 URLs in there
#10:15:39Petaristrying the autogen command again
#10:15:54Petarissame error as last time
#10:15:57eeevil... not sure where a length diagnosis came from ...
#10:16:20jeffit shouldn't break that way, but it might be something other than length.
#10:17:46eeevil suspects "there are two" was translated somehow to "you can only have one", which was then translated to "2 is too many" which was translated to "it's too long"
#10:18:18eeeviljeff: I like your escaping theory, except that the marc editor should be escaping amps
#10:18:44eeevilnot to say it isn't doing something wrong...
#10:19:31jeffeeevil: i was just noting that in the message as i viewed it -- which may have been mangled by both the sender and recipient's MUAs, and/or by mailman... i see a mess of escaped and unescaped.
#10:19:56jeffstep 1 would probably be to get an unmolested copy of the record to test with.
#10:20:00dbs just sent a reply to mbelvadi, didn't see jeff and eeevil's latest comments until now
#10:20:10dbsjeff: luckily, the record ID is in the message
#10:20:23dbs847956
#10:20:40jeff(assuming the record was even created/saved -- the error may require manual editing to reproduce :)
#10:21:33dbshttp://islandpines.roblib.upei.ca/opac/en-CA/skin/roblib/xml/rdetail.xml?r=847956
#10:21:40tsbereAny thoughts on http://paste.lisp.org/display/121806 (making barcode.js more readable, IMO, maybe more efficient) ?
#10:22:53dbshttp://islandpines.roblib.upei.ca/opac/extras/supercat/retrieve/marcxml/record/847956
#10:25:33bshumPetaris: Hmm, that's too bad. Have you tried any of the steps listed on this page for checking for errors? http://www.open-ils.org/dokuwiki/doku.php?id=troubleshooting:checking_for_errors
#10:27:26bshumPetaris: Also, maybe check to make sure ejabberd is actually running (given your problems earlier): ps -aef | grep ejabberd
#10:32:13Callender has joined #evergreen
#10:33:05Ilmarinen has quit IRC
#10:37:19moodaepo finishes reading scrollback
#10:38:09moodaepoI still maintain the "previews" dir is a good idea
#10:38:12bshum gives moodaepo a thumb's up sign
#10:38:35bshumI retained it for now, and updated wiki pages where I saw issues so far.
#10:38:38dbsmoodaepo: maybe do some fancy-pants rewrites so that old links don't break?
#10:39:03Petarisbshum: ejabberd is running
#10:39:14PetarisI haven't tried that page but I will look at it now
#10:39:22PetarisThanks
#10:39:29moodaepodbs: That could be one way but it's pretty easy to copy the wiki content to vi and do a find replace (which is how I update install instructions)
#10:39:55dbsmoodaepo: I was thinking of other links that may exist out in the wild
#10:40:00moodaepo goes to get some tea real quick
#10:40:05dbsbeyond the reach of your vi powers
#10:40:41moodaepodbs++ # ah right there maybe tools for dokuwiki to do that...or just find replace the dokuwiki/data folder : )
#10:41:31dbsmoodaepo: well, or other web sites like freshmeat, ohloh, wikipedia
#10:42:13dbsbut then most of the links to old preview releases probably don't matter
#10:42:59bshumBleh, code_museum....
#10:44:12mrpeters-isl_ has joined #evergreen
#10:46:13rsinger has quit IRC
#10:50:49dbs stares at UPDATE authority.record_entry SET active = active; and wills it to move faster over his 1M auth records so that he can restart postgresql and enable a connection from a remote server (d'oh)
#10:51:24berickdbs: reload won't work?
#10:51:40dbsberick: not for listenaddresses
#10:51:51dbsrestart required
#10:51:59berickah
#10:53:02mrpeters-isl_ has quit IRC
#11:00:01remingtron has joined #evergreen
#11:02:00shopkins has joined #evergreen
#11:04:15jeff waves to remingtron
#11:05:32jeffdmagick++
#11:08:50dbsremingtron++ # good to see you in-channel
#11:09:01youdonotexist has joined #evergreen
#11:09:30gmcharltwordpress++ # link in kmlussier email was line-wrapped, but WP did the right thing anyway
#11:10:01remingtronthanks, dbs and jeff. just getting my feet wet, so far so good.
#11:10:43jeffgmcharlt: my mail client "did the right thing" here. upon testing, i see that wordpress also accepts the truncated url -- nice!
#11:12:03kmlussiergmcharlt: Ah, that explains it. I thought Outlook did something special to it, which is very unlike Outlook.
#11:12:15Petarisbshum: I just went through that troubleshooting page and everything went well until the autogen bit, same error as before
#11:15:41bshumHmm
#11:16:43bshumI went back through the scrollback... after you corrected the postgresql packages, did it create the evergreen db properly using the eg_db_config.pl script?
#11:18:25bshumWondering if maybe something went wrong with the db creation and that's causing your undefined error.
#11:18:46dbsPetaris: might also be helpful to paste error output from /openils/var/log/osrfsys.log to a pastebin
#11:19:26kmlussier has quit IRC
#11:19:46Petarisbshum: The database seemed to create just fine
#11:19:49Petarisno errors
#11:19:55Petarisbut who knows
#11:20:03Petarisdbs, ok will do
#11:20:04kmlussier has joined #evergreen
#11:21:11dbshuh, that's great. restarted postgresql after the authority update finished, greeted by "postgres: startup process recovering 000000010000001200000076" in the processes
#11:24:28Petarishrm, it says the paste is too big
#11:24:28Petarislol
#11:24:51dbsPetaris: uh, trim it down to relevant bits (like "ERROR" lines) to start with
#11:25:19dbs bets that Debian's init scripts forcefully killed postgresql rather than waiting for it to shutdown cleanly. could be a long recovery. #&@*@
#11:26:07Petarisdbs, most of it is DEBG
#11:26:25dbsDEBUG? huh, that's some serious logging
#11:26:32Petarisas instructed on the troubleshooting page I enabled debug level logging
#11:26:41dbsI would strongly recommend grepping for ERR to begin with
#11:28:10moodaepoChecked freshmeat, ohloh, and wikipedia no worries about pre-release link issues at those sites. Updated wikipedia while I was there with 2.0.6 as stable release, the other two need to be updated when we get a chance.
#11:28:48dbsmoodaepo: cool, I think Amy had volunteered for that role on the "release team"
#11:28:58dbsalso blog-posting the news about new releases
#11:29:46bshumAlready tweeted about 2.0.6 last night ;)
#11:29:58moodaepodbs: Yea I was going to do that yesterday, but right now I really need to figure out why the new server is not processing mails to feedback/docs.
#11:30:05dbsmoodaepo++
#11:30:09moodaepobshum: Hey blog that also will ya? : )
#11:30:12dbssounds like the right priority
#11:30:20bshummoodaepo: I don't have blog powers.
#11:30:25dbsbshum: yeah, or create a blog post that links to the tweet for posterity
#11:30:35moodaepobshum: I am getting you one now!
#11:30:45moodaepoI thought I did that during the conf
#11:30:52Petarisdbs: The paste form isn't working for me. It just sits there after I hit submit
#11:31:05bshumdbs: Someone retweeted my 2.0.6 tweet that I don't recognize, so folks are apparently following the hashtags or something...
#11:31:09dbsPetaris: your link is on paste.lisp.org
#11:31:33Petarisok
#11:31:47Petarishrm, when I go there I get a remote server error
#11:32:25Petarisanyway, can you see the paste?
#11:32:27dbsbshum: some folks apparently are. perhaps I could construct a pseudo-blog composed of hashtags that could appear on the planet on the daily basis. for those poor souls who don't look at twitter
#11:32:38dbsPetaris: nope, looks like paste.lisp.org is down. again
#11:32:45dbstry pastebin.ca perhaps?
#11:32:55Petarisok, I'll paste it elsewhere
#11:33:22ChanServ changes topic to "Welcome to the #Evergreen library system channel! | We are publicly logged. | Large pastes at http://pastebin.ca or http://paste.lisp.org/new/evergreen or something like that"
#11:33:24bshumdbs: Speaking of the planet, should poke moodaepo to help update the menu links on the planet page.
#11:33:37dbsbshum: it's not under his control
#11:33:40Petarisdbs: http://pastebin.ca/2054578
#11:33:41moodaepobshum: dbs hosts that and I don't have access
#11:33:44bshumdbs: Ah, right, that's you :)
#11:34:29dbs*JSON Parser Error in pcrud is interesting
#11:35:10dbsactually, in opensrf.math and open-ils.auth too. weird
#11:37:40PetarisThere are some "does not exist" stuff too
#11:40:13dbsPetaris: you can ignore that stuff
#11:40:22Petarisdbs: ok
#11:40:42dbsI have no idea why you're getting JSON parser errors
#11:41:10dbsIt's as though something is injecting random crud into the XMPP messages that is busting JSON
#11:41:54dbs fears this postgres recovery is recovering the hours-long authority.record_entry update that ran just before postresql's restart
#11:42:27dbsPetaris: can you paste some log messages from around the JSON Parser error messages?
#11:42:44Petarissec
#11:43:01PetarisI just archived those and set the loglevel back to info
#11:43:10Petarislet me see what the new log says
#11:44:21moodaepo has now given bshum access to blog hope that was ok (didn't ask community permission)
#11:44:38moodaepoHe better post something soon before they take away the powers
#11:45:00moodaepo2.0.6 and beta availability
#11:45:35Petarisdbs: http://pastebin.ca/2054583
#11:45:41dbsmoodaepo: I think we generally try to do at least a straw poll in IRC before granting access like that, for transparency; not that I think anyone would object to bshum being able to blog
#11:46:29moodaepodbs: I know I remembered that after the fact and decided to come clean. Apologies
#11:46:36dbsPetaris: opensrf.math 2011-05-06 10:41:03 [INFO:6648:transport_session.c:667:] Received <error> message with type cancel and code 503
#11:47:57dbssound like you have something messed up in your opensrf_core.xml or ejabberd config, maybe a wrong username/password combo for one of the opensrf or router public or private domains
#11:48:37Petarisdbs: Ok, I'll check the usernames and passwors
#11:48:40Petariser, passwords
#11:50:50dbsPetaris: also ensure that you made all of the required changes to ejabberd.cfg (like number of concurrent user logins)
#11:54:31ybostonHello, question about OpenSRF download URLs vs EG download URL capitalization...
#11:54:37ybostonRight now the stable OpenSRF tar.gz file is named with all lowercase letters, but the EG tar.gz is mixed case
#11:54:44ybostonI am planning to submit a patch to the official EG documentation to change an OpenSRF download link that is broken because it is using mixed case
#11:55:05ybostonexample: http://docs.evergreen-ils.org/2.0/draft/html/upgradingevergreen-upgradingOpenSRF.html
#11:55:14ybostonI wanted to know if there was any plans to change the OpenSRF download file back to mixed case, or if I should continue to make the documentation point to the OpenSRF all lowercase file name?
#11:55:37dbsyboston: I plan to keep the OpenSRF download link all lowercase for any releases I make
#11:56:10ybostondbs: THanks, just making sure. I will update the EG documentation accordingly
#11:56:52dbsyboston++
#11:57:38AndyWThat will be great for building debs as the deb system complains about "package not in lower case"
#11:58:27AndyWalso for Evergreen-ILS -> evergreen-ils
#11:59:32dbsAndyW: that's actually why I switched the OpenSRF tarballs to lowercase
#11:59:48AndyWthis is great
#12:00:00AndyWone less step to building the debs
#12:00:40dbsAndyW: please open bugs on bugs.launchpad.net/evergreen with packaging-related requirements - so that, say, for 2.1 final release perhaps Evergreen can move to evergreen-ils.2.1.0.tar.gz
#12:01:40jlamosoh, speaking of which, random curiosity: why is it evergreen-ils and not just evergreen?
#12:01:49Petarisdbs: both files checked and ok
#12:02:10dbsjlamos: because there are bazillions of "evergreen" things out there
#12:02:38jlamosk, just wondering if there was a specific software conflict
#12:06:23bradlthat's why we should have called it what I wanted to call it from the beginning: turpentine
#12:07:04Petarisdbs: Could it be the JSON perl module
#12:07:05Petaris?
#12:07:20dbsPetaris: perhaps. did you have a problem installing it?
#12:07:41dbs(although that seems unlikely, as the errors are coming from C services)
#12:07:58Petarisno, not that I recall
#12:09:34kmlussier has quit IRC
#12:10:47Petarisdbs: I'm going to try rebooting the machine
#12:11:04PetarisI tried stopping ejabberd and it said it stopped but still showed a process
#12:11:16PetarisI tried to kill it and it just came back with no process found
#12:11:24Petarisbut ps -aef still showed it
#12:11:25dbsPetaris: hmm, good luck
#12:11:46Petarismaybe a zombie process in there
#12:12:01Petarisnothing was in /var/run/ejabberd/ either
#12:12:46dbswas it epmd or beam?
#12:12:59Petarisepmd I think
#12:13:04dbsI think it's normal for epmd to hang around
#12:13:08Petarisahh, ok
#12:13:23Petarisstill doesn't explain why it wasn't killable
#12:13:37dbsyou could always change the logging level for ejabberd and watch /var/log/ejabberd/ejabberd.log for anything interesting
#12:14:37senatorhttp://www.ejabberd.im/epmd
#12:14:56senatorbefore i figured that out i always kill -9'd epmd like a bad admin :-(
#12:15:24Petarissenator: ahh, ok
#12:20:01PetarisI'm running through the troubleshooting guide again
#12:20:09Petarissee if anything is different
#12:20:27moodaepoPetaris: That is mentioned in our OpenSRF installation docs...maybe one should add it into the troubleshooting guide.
#12:20:32moodaepo <-- one
#12:20:40rsinger has joined #evergreen
#12:21:25dbsPetaris: did OpenSRF work on its own (the opensrf.math 2, 2 test), before you installed Evergreen?
#12:22:30Petarisyep
#12:22:38Petarisand I did try that again, and it did work again
#12:25:51Petarisok, I have stopped, and verified they are stopped, all the relevant services
#12:26:00PetarisI then archived all log files
#12:26:12PetarisNow starting them up one at a time
#12:26:30Petarisorder: apache2, ejabberd, memcached
#12:26:47PetarisGoing to walk through starting OpenSRF one bit at a time
#12:28:53Petarishrm, before I even start that there are two files in /openils/var/log named gateway.log and osrfsys.log that have new error messages, even though OpenSRF hasn't been started
#12:29:03Petarismaybe, because it hasn't been started
#12:29:11Petarisbut just to check
#12:30:20Petarisin gateway.log I am seeing this a bunch: gateway 2011-05-06 11:21:18 [INFO:1713:osrf_system.c:628:] Bootstrapping system with domain public.localhost, port 5222, and unixpath (none)
#12:30:20Petarisgateway 2011-05-06 11:21:18 [WARN:1713:socket_bundle.c:362:] socket_open_tcp_client(): Cannot connect to server public.localhost: Connection refused
#12:31:23PetarisIn osrfsys.log I am seeing this, over and over: [2011-05-06 11:21:18] /usr/sbin/apache2 [ERR :1713:EX.pm:66:] Exception: OpenSRF::EX::Jabber 2011-05-06T11:21:18 OpenSRF::Transport::SlimJabber::Client /usr/local/share/perl/5.10.1/OpenSRF/Transport/SlimJabber/Client.pm:145 Jabber Exception: Could not open TCP socket to Jabber server: IO::Socket::INET: connect: Connection refused
#12:32:17Petarisneither log files seems to be adding anything new now
#12:33:06dbsprobably because apache is still running
#12:33:44dbsonce you install OpenSRF and set up your apache config files, apache gets upset if the opensrf stack isn't running
#12:34:06Petarisahh, ok
#12:34:48PetarisI'm going to start loading OpenSRF one piece at a time
#12:34:52Petarissee what happens
#12:36:29Petarishrm, I just tried starting router but it said it was already started
#12:36:32Petarisbut I never started it
#12:37:26moodaepoPetaris: Just to note - the order to stop is Apache > Evergreen/OpenSRF > memcached > ejabberd. The start order is then the reversed.
#12:37:52Petarisok, thanks moodaepo
#12:38:30dbsPetaris: if the router died (say, because ejabberd was killed before osrf_ctl.sh -a stop_router was issued), then a PID file will hang around confusing osrf_ctl.sh
#12:38:49Petarisdbs, ok
#12:38:51dbs(at least until opensrf 2.0, which has a nice patch from joe lewis to make osrf_ctl.sh smarter)
#12:38:58PetarisI don't think that was the case but maybe
#12:47:57Petarisdbs: This time autogen ran successfully
#12:48:06dbshuzzah
#12:48:09Petariswho knows what the issue was though
#12:48:25Petarisit kind of bothers me as I didn't "fix" anything
#12:48:27Petaris:/
#12:48:54pmplett has joined #evergreen
#12:50:12dbs suspects a problem in start/stop order
#12:50:49tsbereeeevil: You way want to note for the future that the product tag thing in windowssetup.nsi should probably just be "2.1" instead of "2.1whatever". The version (pulled from README by default) will be the more specific piece afterwards.
#12:51:09tsbere would actually recommend just doing that to the rel_2_1 branch now
#12:51:32Petaris suspects a zombie process
#12:52:03PetarisBefore the reboot I tried stopping everything and starting in the right order and it didn't help
#12:52:16Petarissame procedure after the reboot, and now it works
#12:53:29dbsPetaris: okay, never seen that myself but as long as it works
#12:53:45dbsThe_IT_Crowd++
#12:54:34Petarisdbs: Who knows but your right, at least its working
#12:57:23tsberebshum: Aside from not knowing about rigbeta/rigrelease, did you run into any other gotchas during setting up the installer that I might be able to improve upon?
#12:57:42bshumSure
#12:57:58bshumtsbere: It was pretty silly that I hadn't actually installed nsis first ;)
#12:58:09tsbere already documented that issue
#12:58:17Petarisdbs: Well if it didn't start working soon I would have had to toss it away like yesterdays jam ;)
#12:59:17bshumtsbere: There are some warnings about not finding the extras.nsi file, but that seems to be safely ignorable.
#12:59:26tsberebshum: Think it is worth putting in an attempt to detect if nsis is there with a "wait, you may want this first"?
#12:59:40bshumtsbere: I did get a new "Variable "MUI_TEXT" not referenced or never set, wasting memory!" message
#13:00:11tsbereI could make the extras.nsi warnings go away with some extra makefile stuff. And that MUI_TEXT is from the graphical piece of the installer, you didn't have permachine, automatic updates, or devbuild active.
#13:00:21bshumAha
#13:00:35eeeviltsbere: so, just: !define PRODUCT_TAG "2.1"
#13:01:08tsbereeeevil: Yea. Then the installer will be slightly less redundant. blah 2.1 2.1-beta1 or 2.1 2.1.0 instead of 2.1-beta1 2.1-beta1 ;)
#13:01:27eeevilrighto
#13:02:13tsberebshum: The MUI_TEXT warning has to do with not having options for parts. I don't show that screen at all if there is nothing to check off. The instant you devbuild, permachine, or activate automatic updates that screen shows up.
#13:02:32bshumAh okay
#13:02:58bshumI originally used devbuild but then stopped using it on subsequent runs
#13:03:00bshumThat explains that
#13:03:48tsbereIf you personally want to stop seeing the extras.nsi warning just "touch extras.nsi" and it will be including an empty file ;)
#13:04:30tsbere could also just add that to the makefile, causing the make process to create the file if it isn't there and then move on to the installer
#13:07:09collum has quit IRC
#13:07:41bshumtsbere: Writing a more friendly failure is nice, but eh, I wouldn't worry about it. For those of us using this process, we ought to just have it documented somewhere in the instructions that nsis is supposed to be installed first. Or have it be part of Evergreen 2.1 generally
#13:08:15bshumHave you seen any strange line formatting with the installer screen?
#13:08:51bshumFor example, in mine, the initial title that I'm installing Evergreen 2.1-beta1 2.1-beta1 seems to leave some part of the line obscurred in the area below
#13:09:02tsberebshum: No. As for documenting, have you read the "Packaging the staff client" section? Specifically the windows part? http://evergreen-ils.org/dokuwiki/doku.php?id=mozilla-devel:building_the_staff_client#windows_client
#13:09:23tsbereWell, unless you count "Evergreen Staff Client <tag> <version>" being too long
#13:09:24tsbere;)
#13:10:08bshumFiring up my Windows VM to see if I can get a screenshot
#13:11:10bshumYeah, it's definitely obscuring something
#13:11:55bshum"Welcome to the Evergreen Staff Client 2.1-beta1 2.1-beta1 Setup"... and then you can see the tips of another word underneath
#13:11:59bshumWizard?
#13:12:20bshumThe text of the paragraph underneath is blocking that word
#13:12:40bshumGuessing due to length of that string as you indicated
#13:14:11tsbereI am working on removing the product tag from that part entirely.
#13:14:29bshum+1 to that
#13:16:25bshumOther than that I think it all made sense to me.
#13:16:46bshumI had to re-read the paragraphs about BUILD_ID vs. STAMP_ID a couple times
#13:16:54bshumBut it was late last night
#13:20:08bshumAssuming that STAMP_ID is the one we care about, if only to make sure it matches up with what's on server side?
#13:20:39dbseeevil: would you mind if i moved http://evergreen-ils.org/dokuwiki/doku.php?id=scratchpad:build-cutting under dev:release_process:evergreen ?
#13:20:57PetarisIs there a special port that the staff client uses?
#13:21:08jeffPetaris: 80/tcp and 443/tcp
#13:21:15dbsAnd then I would move http://evergreen-ils.org/dokuwiki/doku.php?id=dev:rolling_a_release to dev:release_process:opensrf and have a nice dev:release_process page pointing to each
#13:21:17Petarisjeff, ok thanks
#13:21:19jeffPetaris: so, nothing that special.
#13:21:38Petarisyeah, I just am trying to figure out why I can't login from the client
#13:21:40dbsthen maybe bshum/tsbere could integrate the staff-client instructions into the dev:release_process:evergreen page
#13:21:47Petarisbut it can wait until after lunch
#13:22:15dbs bets admin-user / admin-pass
#13:22:40Petaristhey work with srfsh
#13:22:50dbsgmcharlt++
#13:23:02dbsPetaris: restart apache again?
#13:23:13tsberebshum: 2.1 cares about different things that 2.0 and before. I assume that is some of the confusion. The 2.1 readme for setup is different on the make install step as a result. 2.0 and before say build id there, 2.1 (and later) say stamp id there.
#13:23:49kmlussier has joined #evergreen
#13:23:50dbscool. dev:release_process:evergreen:2.0 vs. dev:release_process:evergreen:2.1 then!
#13:24:11Petarisdbs, that didn't work either. Anyway lunch time
#13:24:18Petaristalk to you guys in a bit
#13:24:19dbsidea being that all steps should be documented as granularly as possible so that we can automate as much as possible
#13:24:25bshumtsbere: Good call... the 2.1 wiki steps do not clarify that distinction. I'm starting to see the merits of dbs' suggestion to consolidate all these install steps...
#13:25:29dbs(not to mention make it possible for other people to take over release duties... poor eeevil)
#13:28:47tsbereWhich do we prefer there? "Evergreen Staff Client <version> Setup", "Evergreen Staff Client <tag> Setup", or just "Evergreen Staff Client Setup"? Examples for the first couple: Evergreen Staff Client 2.1-beta1 Setup, Evergreen Staff Client 2.1 Setup
#13:29:15bshumI like version.
#13:29:44tsbereThe title bar will still be verbose, though.
#13:32:34eeevildbs: move away, sir
#13:34:02tsbereWhile I am in here, we want to change the text on the welcome page at all?
#13:34:35bshumHmm
#13:35:07bshumIt seems okay to me, but others should read it I guess.
#13:35:52tsbereTake note it is currently the default 100% and will adjust according to language. I am actually breaking the ability for it to translate the word "Setup" in the title by forcing it to be something else, I thik.
#13:36:37tsbere could also just skip the word Setup in the title of the welcome page entirely
#13:37:43tsberes/thik/think/ <_<
#13:42:52dbsokay, moved to http://evergreen-ils.org/dokuwiki/doku.php?id=dev:release_process
#13:42:57tsberebshum/dbs/eeevil: Any thoughts on dropping the word "Setup" from that point in the installer?
#13:43:27pmplett has quit IRC
#13:43:30dbstsbere: I almost never see the installer, so am not a very good person to ask
#13:44:50bshumtsbere: From the title at the top? Or you mean within the body of the text?
#13:45:11tsberebshum: From the previously too-long line-wrapping title at the top.
#13:45:17bshumOh that thing
#13:45:49tsbereThe one I am already working on making shorter ;)
#13:46:53bshumtsbere: A suggestion from the floor is to replace the words "Setup Wizard" in there with "Install Wizard"
#13:47:09bshumIf only so that people don't worry so much that there's actual "setup" involved, but just installing
#13:48:11tsbereissue with that, thinking about it, is having to put the entire thing into the installer script. If I am only changing one word it isn't worth it ;)
#13:48:27bshumHeh
#13:49:53tsbereRemoving the big bold "Setup" at the top is doable, though.
#13:50:45tsbere suspects very few people ever read the normal sized text anyway
#13:51:33dbs can't remember - can you have a 1.6 client and a 2.0 client installed via the normal installer on the same machine at the same time?
#13:51:39gmcharltdbs: yep
#13:51:54dbsexcellent
#13:52:09tsbereAnd 2.1 doesn't know anything about either's installer ;)
#13:52:41gmcharltthe real question is, who here has ended up having *every* client version between 1.4 and present installed on their computer ;)
#13:54:25tsbereAt once? Or one by one? ;)
#13:54:32christoph_ has joined #evergreen
#13:55:07tsbere can't claim either, not having had a computer with 1.4 and 1.6 clients on it
#13:55:58gmcharlt is uncomfortable close to all them all installed simultaneously
#13:57:30berickgmcharlt: let me know if you want me to install the alpha opac on any of your test servers
#13:57:35bshumtsbere: So wait, when you remove the Setup in bold, that'll move the Wizard back into the line right?
#13:57:46gmcharltberick: aiieeee!
#13:58:12tsberebshum: I think without the "remove Setup", just removing the tag fixes that. Removing the setup in addition will pretty much guarantee it.
#13:58:36bshumtsbere: So the line would just be "Welcome to the Evergreen Staff Client 2.1-beta1 Wizard"?
#13:59:09bshumCause that seems strange now :)
#13:59:24tsbereWait, it says "Wizard" by default too?
#13:59:32bshumhttp://imageshack.us/photo/my-images/638/screenshotup.png/
#13:59:34tsbere didn't save a copy of the default before trying the new
#13:59:48bshumIs what I've been looking at.
#14:00:06tsbereHow about I just set it to "Evergreen Staff Client <version>" WITHOUT all of the welcome to wrapping?
#14:00:09bshumBeen guessing that last word in the bold title is "Wizard"
#14:00:46tsbereOh, cool, I made the MUI_TEXT warning go away too
#14:03:51rsinger has quit IRC
#14:04:09christoph_db upgrade from 1.6.0.3 to 1.6.0.4 script seems to have an error, as no default tsearch configuration exists, it seems to be fixed insofar to that error by doing CREATE TEXT SEARCH CONFIGURATION public.default ( COPY = pg_catalog.english );
#14:05:00justin_hopkins has joined #evergreen
#14:05:02christoph_Now I'm getting another error: psql:Open-ILS/src/sql/Pg/1.6.0.3-1.6.0.4-upgrade-db.sql:100: ERROR: duplicate key value violates unique constraint "materialized_simple_record_pkey"....any suggestions asto how to fix it?
#14:06:31bshumtsbere: I guess it says that because that's what it's always said in recent times. The welcome part
#14:06:41bshumOr at least, it's like in that in the 2.0 installers
#14:07:02tsberebshum: No, it says that because NSIS does that by default.
#14:07:46bshumEh, I kind of like the "Welcome" part. It seems more friendly :)
#14:08:12bshumOr maybe I'm so used to seeing it that not seeing it seems unfriendly...
#14:08:33tsbereWell, stripping off the tag means it won't translate. Should I just kill the alternate translations too? (Does anyone ever use the other two languages I left in there from the template I used?)
#14:08:59dbschristoph_: you might want to look at the upgrades leading up to 1.6.1.0 and consolidate the bits that update one another, if you're comfortable with SQL
#14:12:55PetarisDoes the staff client care about the hostname? I have the machine entered as its real hostname in the staff client, but everything in the setup was set to localhost
#14:16:00christoph_dbs: I thought I should go through all the steps from 1.6.0.0 to 1.6.1.8 and and then a bigger script. what do you mean with consolidate the bits that update one another?
#14:17:38dbschristoph_: you may find that 1.6.0.5 has a fixed version of whatever broke in the 1.6.0.4 script
#14:18:12christoph_dbs: I also noticed that the upgrade files of lower versions are in the evergreen tar-ball. could I also download the highest version and let all the upgrade scripts work through my database instead of going through the different upgrade wikis?
#14:18:29dbs(this happened a lot in 2.0.x so far, which is why I consolidated all of the 2.0.x updates into the 1.6.1-2.0 upgrade script in place - customized for our instance)
#14:19:11dbschristoph_: yes, that's the idea. Although unfortunately it seems that sometimes the version of the upgrade script in a given tarball doesn't match the script in a different tarball
#14:21:27mrpeters-isl_ has joined #evergreen
#14:22:52christoph_dbs: does that mean that I still can download the 1.8.0.8 or even to 1.6.1.8 and do all the upgrade scripts? and after this the mentioned 1.6.1.-2.0 scipt?
#14:23:50tsberebshum: So far I have made the makefile yell if you win-client without makensis, win-xulrunner yell if you don't have unzip, eliminated the extras.nsi and MUI_TEXT warnings, and adjusted the welcome page title. Anything else before I commit this and push?
#14:24:44dbschristoph_: yes, that should work
#14:25:03dbs(again, subject to the "the same script is different in different tarballs"
#14:26:22christoph_dbs: thanks, I'll try that now
#14:29:23mrpeters-isl_ has quit IRC
#14:30:06bshumtsbere: Sounds pretty great to me so far. We'll see what else shakes loose when more eyes get on it.
#14:34:17tsberebshum: Think I should have it yell if it doesn't find xulrunner-stub.exe and evergreen.ico in the right places?
#14:34:44bshumtsbere: Sure, what are the right places supposed to be? :S
#14:35:12tsberebshum: Ideally, if you don't have them, I prompt "you should really run 'make rigbeta' or 'make rigrelease'" ;)
#14:35:37tsbereIt will put them in the right places
#14:36:47justin_hopkins has quit IRC
#14:41:57mrpeters-isl has joined #evergreen
#14:49:42tsberephasefx: You around? My installer branch could use a cherry-picking ;)
#14:50:05tsbere(or anyone else who cares to, I guess)
#14:50:20pmplett has joined #evergreen
#14:51:33bshumtsbere: Ahh, that explains how those magically appeared in my directory then.
#14:53:50tsbereI am aiming for this to become as easy as possible. Just because *I* like easy ;)
#14:55:55bshumtsbere++
#14:59:40mrpeters-isl has left #evergreen
#15:00:45justin_hopkins has joined #evergreen
#15:03:49shopkins has quit IRC
#15:26:39phasefxtsbere: will look
#15:26:41christoph_ is now known as natschil
#15:27:07phasefxanyone know off-hand if the 852 holdings format for vandelay, $z status expects an id or a string? $z 0 versus $z Available
#15:27:20natschilI ran all the upgrade scripts up to the 1.6.1.7 to 1.6.1.8 ignoring all errors that related to duplicate key constraints, and all of them went somewhat fine except for the last one, which said this:
#15:28:20natschilpsql:1.6.1.7-1.6.1.8-upgrade-db.sql:64: ERROR: cannot change name of view column "xact_start" to "billing_location"
#15:28:44natschilany suggestions as to whether it's dangerous or not.... I looked at the sql code, but I couldn't make heads or tails to as to why I got this error.
#15:32:31Dyrconathink I have another metabib indexing bug, but I need to do some more digging to be sure.
#15:38:52dbwellsphasefx: hard for me to recall the reason or the history, but we have $k as the status, and it is a string
#15:40:14phasefxdbwells: thanks
#15:40:54natschilbtw, anyone know why all of the upgrade scripts are full of inserts that were made before? I mean, there's no point inserting some configuration into a table if a previous eg version already has done that, right?
#15:44:04tsberenatschil: In theory they haven't been made before. Which is why they should be in an upgrade script.
#15:44:19tsbereBut if you manually applied backported patches in the past....
#15:44:42DyrconaAh. Never mind. Upon further inspection: PEBKAC.
#15:45:02natschiltsbere: that's really weird though... as I had a "normal" 1.6.0.0 running here, and I'm still getting all those errors.
#15:46:23natschilanwho, I'm going to leave this computer now, and let christoph_ back on...
#15:46:23tsberenatschil: Which upgrade script(s) are you running?
#15:46:28natschil is now known as chts
#15:46:32chts is now known as natschil
#15:47:12natschiltsbere: the ones in the Open-ILS/src/sql/Pg folder that look like version1-version2.sql
#15:47:21natschil is now known as christoph_
#15:50:46Petaris has left #evergreen
#15:54:44moodaepoAny objections to setting up piwik as our new site statistics monitor/analyzer?
#15:55:30tsbere wasn't aware there was an existing statistics monitor/analyzer. Or at least a public one, if there is.
#15:56:30moodaepotsbere: Till last week > http://evergreen-ils.org/webalizer/
#15:56:46tsbereAhhh. See, I hadn't known that.
#15:56:56tsbereThen again, I am not sure I cared either ;)
#15:57:01moodaepoRight : )
#15:57:18tsbere is more concerned with the actual ILS code than the website stats
#15:57:58moodaepoMost definitely, it is not like we are selling/having a marketing campaign but it's nice to have
#15:58:37bshummoodaepo: +1 to piwik. I've found it to be very interesting so far.
#15:59:49tsbereI figure it is someone else's job to worry about website stats. Oh, look, you are worrying about website stats! Must be your job! ;)
#16:00:12gmcharltheh
#16:01:43dbstsbere++
#16:02:23dbspiwik stands for "Privacy Invasion ...." ?
#16:02:44moodaepoWell in other news mail for feedback and docs @evergreen-ils.org seems to be working, I went the easy route and replaced exim4 with postfix
#16:03:23dbs(kidding, +1 to something google-analytics-like but being under our control)
#16:03:33moodaepoPrivacy Invasion With Intrusive Kookies
#16:04:05moodaepoand javascript
#16:22:41kmlussier has quit IRC
#16:25:39christoph_Hi, does anyone know what the errors that natschil posted earlier mean?
#16:31:03tsbereThe cannot change name of view error? THAT would be a typo in the upgrade script.
#16:31:20tsbereme hadn't noticed that line before he looked at his scrollback
#16:31:40tsbere...
#16:31:46tsbere wants to know where his / went
#16:37:45justin_hopkinsgmcharlt: We should have server access for you guys any time now. I wanted to discuss which Evergreen version to install. Got time?
#16:38:07christoph_tsbere: how would I fix this typo?
#16:38:30tsberechristoph_: No clue. I do not (currently) deal with the combined upgrade scripts.
#16:40:10moodaepotsbere: I know you care about more important things but look shiny pretty web 5.0 and more : ) > http://evergreen-ils.org/piwik/
#16:40:37tsbereweb 5.0? WHAT HAPPENED TO 3 AND 4? :P
#16:41:10moodaepotsbere++
#16:42:15bshummoodaepo: I want to just sit here and click refresh a billion times waiting for more countries to fill in the colors :)
#16:42:40bshumSpeaking of which, huzzah, first Canada hit
#16:42:43hopkinsju has joined #evergreen
#16:42:56moodaepobshum: I don't think you need to his refresh : )
#16:43:01justin_hopkins has left #evergreen
#16:43:08bshummoodaepo: I know ;)
#16:46:10dbschristoph_: I'm not sure if there have been any bug reports about the 1.6.1.8 upgrade script on bugs.launchpad.net/evergreen or on the mailing list
#16:46:24hopkinsjugmcharlt: I switched users/irc clients, but I'm still here.
#16:47:05dbsbut it wouldn't surprise me if there are bugs; we don't have any automated tests or particularly stringent manual tests for testing upgrade scripts, so it has been a roll of the dice each release
#16:56:01gordonja has joined #evergreen
#16:56:07christoph_dbs: no bug reports there.... seeing that there are so many upgrade scripts that all produce errors here, and I am not at all familiar with sql at all, is there some other backup and restore mechanism i could use to transfer data from one server running old evergreen to a new server running new evergreen?
#16:56:30christoph_dbs: with data I mean mainly the books that are in the system, not the users or anything like that.
#16:56:58moodaepochristoph_: You could dump the marc data and import it into the new server
#16:57:53dbsI suspect christoph_ would want holdings information at the very least (call numbers and copy barcodes)
#16:58:12hopkinsjugordonja: Hey
#16:58:57dbshopkinsju: I recommend 2.0.6 :)
#16:58:58christoph_dbs: moodaepo: yes that's true, call numbers and barcodes are important
#16:59:57hopkinsjudbs: Yes, but we are implementing a library that really wants a faster OPAC experience. I was talking with Bill at the conference and I'm wondering if we should look at 2.1
#17:00:03dbschristoph_: depending on which version of Evergreen you're on (heh), an export will probably provide those for you, and an import into 2.0.6 should recreate them, but there is still some pain
#17:00:23jlamosthe services starting order is ejabber, memcache, opensrf, apache2 correct?
#17:00:30dbshopkinsju: bleeeeeeding edge eh?
#17:00:55dbsjlamos: postgresql goes in with ejabberd and memcached
#17:01:11christoph_dbs: 1.6.0.0. to 2.0.5.
#17:01:37hopkinsjudbs: Well yeah, the thinking is that if we go with 2.1 it might help speed along the development of the OPAC improvements
#17:01:47jlamosso really ejabberd == memcached == postgres > opensrf > apache2?
#17:02:00dbsjlamos: yep
#17:02:44dbshopkinsju: I guess that depends on the terms of your contract :)
#17:03:14jlamosis this new behavior for the 2.0 series? I coulda sworn we've restarted *just* opensrf in our tests
#17:03:31hopkinsjuIt's really a question of whether we want to launch bleeding edge and do bug fix upgrades or launch stable and deal with a more major upgrade *and* migrating the OPAC design into the new system
#17:05:34dbshopkinsju: it has taken 6 point releases to get 2.0 to a truly stable release, IMO; if you have dev talent, then jumping onto 2.1 at this point might be reasonable, as long as you're willing to invest the time (and accept that some bits will go south)
#17:05:35moodaepojlamos: I've always done (pstgresql|ejabberd|memcached) > (opensrf|evergreen) > apache2 for start sequence
#17:06:16moodaepohopkinsju: And be really nice to library folk (which includes patrons)
#17:06:33AndyWyea i was always able to restart opensrf without having to restart anything else
#17:06:46hopkinsjudbs: We've got a platinum support contract with Equinox so I guess it's a question of whether or not I can convince them ;)
#17:06:47moodaepo should have said especially patrons...the staff can stay or leave : )
#17:07:36moodaepoAndyW: Yes you can do that but then for Evergreen to work nice it's recommended to restart apache2
#17:07:59moodaepoThe rest are only restarted for a full clean restart process
#17:08:41AndyWso basically an init script for opensrf should call a restart of apache as a process of restarting opensrf?
#17:09:27dbsAndyW: yep
#17:11:51atzthat won't jive for packaging purposes, methinks
#17:13:33atznot that you should be stopped by that, but whoever is packaging will have to rework it
#17:14:58dbsatz: agreed, but there are plenty of hurdles to be cleared before debian would ever accept evergreen debs
#17:15:04atztons
#17:16:11jeffi suspect the better way to rework that would be to have the various perl handlers grow reconnect logic
#17:16:26jeffso that they can survive an opensrf services restart without requiring an apache restart
#17:16:43AndyWyep
#17:16:58dbssounds like a good direction, I'll buy shares in that :)
#17:17:07AndyWcant that be fixed in evergreen though?
#17:17:22christoph_dbs: would there be pains doing an export and then an import with that? Also, would I need to create org units first?
#17:17:25jeffAndyW: think so, with enough tuits.
#17:17:44adrienne has joined #evergreen
#17:18:14AndyWto make it more robust so we wont have to worry about fixing it in init scripts and the like wich break debian conventions
#17:18:23jlamosok, do any of the services report the're ready when the're actually not? I.E. are there any services we should sleep after?
#17:18:25jeffit gets complex, i'm sure. what about opensrf restarts to effect an IDL change -- how do your apache clients tell the difference between retrying and reconnecting and services restarts and what do they do differently for each...
#17:18:26dbschristoph_: I've never done it myself, so I can't say on #1; on #2, probably (assuming a string-based match is required)
#17:18:31jeff...and that turned into a bit of a run-on
#17:19:21hopkinsjuadrienne: Hi
#17:20:01adriennehopkinsju: Hey
#17:20:43natschil has joined #evergreen
#17:20:48moodaepojlamos: This is what I currently use > http://svn.mnpals.net/viewvc/evergreen/egdemo/var/system-scripts/evergreen-init_d?annotate=94
#17:21:34jlamosthat's actually what we started with
#17:21:47jlamosand it's been working great until today
#17:22:12natschilIDoing a db upgrade from 1.6.0.1 to 2.0.5 is a pain, as it gives a ton of errors etc... so what steps would need to be taken to export everything from 1.6 to
#17:22:28jeffnatschil: your message truncated at "from 1.6 yo"
#17:22:37natschils/IDoing/I'm here with christoph? and/
#17:22:37jeffer, s/yo/to/ :)
#17:22:50moodaepojlamos: Oh what happened today?
#17:23:05natschiljeff: I pressed enter by mistake :)
#17:23:12jeffnatschil: understood :)
#17:23:16moodaepoI saw you were looking at the order
#17:23:18natschil2.1 without doing a full db upgrade.
#17:23:27natschils/2.1/2.0.5/
#17:24:17natschilThe old server is at a separate location, so I was wondering what exactly to get from there when we do.
#17:25:53dbsnatschil: I'm not convinced that you'll have any less pain with an export/import approach
#17:26:27dbsYou're just paying all of the pain of working through each point release all at once, and to make it worse, extremely old point releases that most of us have forgotten :(
#17:26:43natschildbs: Is there an alternative to working through each point release?
#17:26:54jlamoslol don't know. Discovered things not working right after reboots.
#17:27:31moodaeponatschil: I agree with what dbs said but I have done the same trip and would suggest going this route - 1.6.0.* to 1.6.1.*
#17:27:33dbsnatschil: at some point, we started introducing database upgrade scripts for each change to the schema; meant for developers, really
#17:27:42moodaepoThen doing the db upgrade + 2.0.*
#17:28:08natschildbs: so how would I use those?
#17:28:17jlamoswe had S17ejabberd, S18memcached, S18postgres,S19opensrf,S20apache2.... was working, now we have to manually bounce opensrf and apache2 or we get cstore errors
#17:28:19moodaepojlamos: I put in a sleep in the script I use a while back and have not seen any issues with reboots
#17:28:19dbshopkinsju: fwiw, we hope to upgrade to 2.1 in the July time frame
#17:28:47natschildbs: It would be nice if one could upgrade evergreen without knowing the internals though....
#17:29:23Dyrcona has quit IRC
#17:29:56hopkinsjudbs: We are launching the last week of June, so yeah.
#17:29:57dbsnatschil: there's a script, build/tools/update_db.sh, that has been used for that purpose
#17:29:59dbsYMMV
#17:30:05moodaepojlamos: I have - S19postgresql S20ejabberd S20memcached S90evergreen S91apache2
#17:30:45natschildbs: allright. I shall try that.
#17:30:47dbsnatschil: I agree. Unfortunately, we have not done a great job at bullet-proofing / testing our database upgrade scripts.
#17:31:59dbshopkinsju: I still expect to have a lot of work to do once we cut over. Planning on updating to 2.0.6 at the end of May, as the 1.6->2.0 upgrade is the biggest hurdle by far.
#17:32:11dbs whispers encouragement to his test db server
#17:32:45natschildbs: I guess most people setting up and maintaining evergreen know a lot about the internals, but it's not so much the case here. I will try update_db.sh....is there any documentation as to how to use it?
#17:33:24dbsnatschil: I don't think so. If anything, it's much less non-dev friendly than the upgrade scripts
#17:33:36dbsbut you asked for alternatives, so...
#17:33:36natschildbs: basic syntax?
#17:33:57natschil looks at the code.
#17:34:02dbsusage: $0 db_host db_user db_name
#17:34:18dbsI would suggest running the version from Evergreen trunk
#17:34:19christoph_dbs: what about version numbers?
#17:34:26jenny has left #evergreen
#17:34:29dbswhat about version numbers?
#17:34:29christoph_dbs: does it find those by itself?
#17:34:43dbs needs to go to his daughter's birthday dinner
#17:35:17dbsbtw, use the script from trunk, but drop it into a 1.6.1.8 checkout - don't upgrade all the way to trunk :)
#17:35:24dbslater
#17:37:01natschildbs: if you're still there... we only have 1.6.0.1 working here, I will drop it into there.
#17:37:30natschils/1.6.0.1/1.6.0.0
#17:39:38natschilnevermind, I misunderstood, I will put it into 1.6.1.8
#17:51:15christoph_ is now known as natschil_
#17:54:01natschil_Ok, so now I am trying to completely do the db upgrade from the start. Something Ihadn't noticed before is that I'm getting a lot of errors like psql:evergreen_db.backup.2011-04-26:3689: ERROR: function "connectby" already exists with same argument types, which leads me to think that maybe the sql restore function is trying to recreate functions created in e.g. tsearch2.sql
#17:54:09natschil_would such suspicions be unfounded?
#17:58:17natschil_I'm also getting errors like psql:evergreen_db.backup.2011-04-26:3667: ERROR: could not find function "concat" in file "/usr/lib/postgresql/8.4/lib/tsearch2.so"
#17:58:35natschil_which is quite strange.
#17:59:04natschil_and I don't want to ignore these errors, as they'll probably rear their ugly heads soon in the future.
#18:14:08yboston has quit IRC
#18:28:20natschil_ has quit IRC
#18:28:26natschil has quit IRC
#18:33:37jenny has joined #evergreen
#18:35:27natschil has joined #evergreen
#18:35:35natschil_ has joined #evergreen
#18:42:07moodaeponatschil_ I ignored those same errors and have a funny feeling about them.
#18:43:11moodaeponatschil_: Look for the errors here and compare > http://paste.lisp.org/display/120094#1
#18:43:38jenny has left #evergreen
#18:45:38moodaepoIf you hear from eeevil or dbs more about these errors it would be great.
#18:45:39natschil_moodaepo: yep, same errors here, as far as I can see... and your system works?
#18:45:52moodaepoer more or less : )
#18:46:00natschil_ ignores the errors too.
#18:46:12moodaepoI believe it does work I'll know better in a couple of weeks
#18:46:25moodaepoWhen I do production upgrades and let the users do the testing ; )
#18:47:39natschil_moodaepo: :D
#18:50:39youdonotexist has quit IRC
#19:14:18natschil_ has quit IRC
#19:14:38natschil has quit IRC
#22:47:35moodaepo_ has joined #evergreen
#22:53:22moodaepo_The page was getting really long and after a chat with Bob Molyneux I started thinking about a re-org and have changed it so, we can always move back if folks feel it's not working > http://evergreen-ils.org/dokuwiki/doku.php?id=evergreen_libraries
#22:54:34moodaepo_Plan is to just list by country, we can always re-org the page and divide it up by region when we see the need.
#22:54:48moodaepo_ I also want to move away from "Forests" and "Single Plantings", sounds cool but not very informational.
#22:54:59moodaepo_ goes to watch Community
#22:55:03moodaepo_ has quit IRC
#23:07:56dbs@later tell moodaepo Fancy, I like the direction of the evergreen libraries page (didn't know about the new twisty wiki syntax - neat)
#23:07:56pinesol_greendbs: The operation succeeded.
< Thursday, May 5th, 2011Raw Log FileSaturday, May 7th, 2011 >