2008-09-03T00:01:06 *** phase_bb has joined #openils-evergreen 2008-09-03T00:16:14 hee hee - trying out evergreen opac on my wii 2008-09-03T00:18:20 awesome - it worketh quite nicely 2008-09-03T00:19:13 i've never had force feedback rolling over links before; the wiimote sounds like a geiger counter as it roams over the page and clicks/rumbles to announce every link and image 2008-09-03T00:19:29 $5.00 well spent! 2008-09-03T00:24:27 you're selling Evergreen OPAC in the WiiWare store? dang, wish I'd thought of that... 2008-09-03T00:25:58 heh 2008-09-03T00:27:05 it doesn't seem to like the language picker, and the library picker sorts kinda weird 2008-09-03T00:27:13 sylvar: you're onto something, man 2008-09-03T00:27:44 me, I'm probably just on something 2008-09-03T00:27:57 I think iPhones would sell more copies of the OPAC though... when you wait in like for 24 hours outside of a store, you can actually BUY an iPhone. Wiis are harder to find. 2008-09-03T00:49:25 *** dbs has quit IRC 2008-09-03T06:20:26 *** kgs has joined #openils-evergreen 2008-09-03T07:41:55 *** kgs_ has joined #openils-evergreen 2008-09-03T07:45:23 *** kgs has quit IRC 2008-09-03T07:45:35 *** kgs_ is now known as kgs 2008-09-03T07:46:55 miker_ or berick, either of you around? I've got my zip.txt file located in /openils/var/data and the perl services were restarted last night. evergreen doesn't appear to be reading from my zip.txt file. anything else need to be massaged in order for this feature to work? 2008-09-03T07:49:28 atheos: it's just a tiny bit early since I saw them working as late as 11:30 ET last nite :) 2008-09-03T07:49:36 (this is karen...community librarian) 2008-09-03T07:49:50 early? I didn't think they slept 2008-09-03T07:50:03 well I advise them to bathe once a week whether they need it or not 2008-09-03T07:50:37 I think I better send them a case of redbull 2008-09-03T08:15:52 atheos: zips.txt ... plural 2008-09-03T08:16:18 tkx 2008-09-03T08:16:35 atheos: sorry ... thought I mentioned that on the phone 2008-09-03T08:16:43 I"m sure you did 2008-09-03T08:17:01 I'll go restart the services, and see if I'm good 2008-09-03T08:17:28 luckily, there are still a few minutes for another restart :) 2008-09-03T08:17:33 ha 2008-09-03T08:17:34 yeah 2008-09-03T08:17:44 well, a little more than an hour, yea. 2008-09-03T08:18:34 ahh... I was thinking 8:30, but that's even better 2008-09-03T08:19:31 still not working. Does this look valid? |IN|Zionsville|46077|||| 2008-09-03T08:20:29 hrm... it may need /something/ in the other positions. I haven't looked at the code that chops it up 2008-09-03T08:20:31 berick? 2008-09-03T08:23:02 ok, I think I found the issue. It's commented out in opensrf.xml 2008-09-03T08:23:55 heh :) 2008-09-03T08:24:07 grep is my friend 2008-09-03T08:24:27 I thought it was enabled by default, that's my bad 2008-09-03T08:24:38 *** kgs has quit IRC 2008-09-03T08:25:07 *** rickd has joined #openils-evergreen 2008-09-03T08:25:10 still not working. oh well 2008-09-03T08:25:45 it does not like my ident 2008-09-03T08:26:20 atheos: we will grab berick when is becomes available. that should be before 9:30 2008-09-03T08:26:39 awesome, thanks. I'm sure staff will like this feature 2008-09-03T08:29:00 atheos: logs got anything for you? 2008-09-03T08:29:49 berick, I'll confess that I'm not certain what look to look into 2008-09-03T08:30:20 heh, 9:30. 2008-09-03T08:30:23 * berick goes back to sleep 2008-09-03T08:30:38 sleep? isn't it close to lunch time? 2008-09-03T08:31:55 so, it's finding the file... 2008-09-03T08:32:05 ok, the logs are indicating a read on the file 2008-09-03T08:32:27 but, nothing further. maybe the format of my file is whack? 2008-09-03T08:33:13 Message processing duration 0.000004 2008-09-03T08:33:25 probably won't be a problem to list all US zips in that file. 2008-09-03T08:34:23 *** kgs_ has joined #openils-evergreen 2008-09-03T08:34:28 *** kgs_ is now known as kgs 2008-09-03T08:35:27 oh, arg. there is a "valid" column which should be set to 1. column 4 2008-09-03T08:35:42 sweet, I'll go fix that. 2008-09-03T08:35:45 tkx 2008-09-03T08:35:57 atheos: it'll need another perl restart, too 2008-09-03T08:36:05 k, np. 2008-09-03T08:47:39 *** dbs has joined #openils-evergreen 2008-09-03T08:48:12 Miker_: When you overlay the circ map with a new one and start circing, will the new policies only affect those items that are checked out or renewed going forward? 2008-09-03T08:55:52 ok, our zips.txt is working. Thanks for the help miker_ and berick 2008-09-03T08:57:01 atheos: great! 2008-09-03T08:57:29 it bugs me that I don't have the counties. I guess I'll start looking for a solution to that problem. 2008-09-03T09:06:30 biab 2008-09-03T09:06:33 * miker_ commutes 2008-09-03T09:09:10 1st day of schoool!!! yay!!11 2008-09-03T09:09:53 weeee 2008-09-03T09:13:00 *** rsinger_ is now known as rsinger 2008-09-03T09:27:10 *** skmurphy_lt has joined #openils-evergreen 2008-09-03T09:55:39 phasefx et al: so where else are you running into missing entity problems? I fired up trunk staff client on a fresh install and haven't hit anything obvious yet on the cataloging side 2008-09-03T09:56:16 *** rickd_ has joined #openils-evergreen 2008-09-03T09:56:16 *** rickd has quit IRC 2008-09-03T09:56:17 *** rickd_ is now known as rickd 2008-09-03T10:01:36 dbs: did some light poking about, trunk is working well for me (yay!) 2008-09-03T10:02:22 and the language picker works in the embedded opac ;) 2008-09-03T10:02:33 sw33t 2008-09-03T10:07:48 *** rsinger_ has joined #OpenILS-Evergreen 2008-09-03T10:24:36 *** rsinger has quit IRC 2008-09-03T10:24:41 *** rsinger_ is now known as rsinger 2008-09-03T10:53:18 berick: is there anything else I should need to make vandelay work - http://comet.cs.uoguelph.ca/vandelay/vandelay.html?ses=10327288e02de0773a0a232c020271df triggers some action on osrfsys.log, but "Upload" doesn't seem to do anything 2008-09-03T10:55:18 dbs: 2008-09-03T10:55:22 SetHandler perl-script PerlHandler OpenILS::WWW::Vandelay::spool_marc Options +ExecCGI allow from all 2008-09-03T10:55:25 2008-09-03T10:55:34 eg_vhost.conf 2008-09-03T10:56:08 probably need to change the Location of that so it doesn't collide with the UI location 2008-09-03T10:57:11 ? 2008-09-03T10:57:39 too early to add to Open-ILS/examples/apache/eg_vhost.conf? 2008-09-03T10:58:28 I'll give it a shot and check in an updated version of eg_vhost.conf if it works for me 2008-09-03T10:59:35 dbs: thanks. yeah, needed to work out the path before i added to the example 2008-09-03T11:36:33 *** mrpeters-isl has joined #openils-evergreen 2008-09-03T11:36:42 hey all...anyone here have some experience with reporting? 2008-09-03T11:42:44 mrpeters-isl: I have a very little bit, and others do if they're around and awake. what's your question? 2008-09-03T11:45:53 lucky me, i get to teach all of our libraries how to create report templates but im not sure what sorts of things libraries would need to report on 2008-09-03T11:46:14 i dont come from the library world, so i havent yet learned many of the inner-workings of what sorts of things libraries need to know 2008-09-03T11:46:51 there is no doubt about using the software, more of what sorts of things they need me to show in the software...if that makes sense 2008-09-03T11:55:06 *** skmurphy_lt_ has joined #openils-evergreen 2008-09-03T11:55:11 *** rsinger has quit IRC 2008-09-03T11:55:40 *** rsinger has joined #OpenILS-Evergreen 2008-09-03T12:00:50 *** skmurphy_lt has quit IRC 2008-09-03T12:01:01 *** skmurphy_lt_ is now known as skmurphy_lt 2008-09-03T12:05:02 mrpeters-isl: they will be interested in things like # of items circulated / day, perhaps broken down further by patron category; lists of items overdue > 1 week, > 1 month, > 1 year; ... actually, a list of frequently run reports (FRR) would be good 2008-09-03T12:06:18 huh, getting 403s now that I've added that location entry for vandelay (and the corresponding use entry in startup.pl)... too hungry to debug, will go get food 2008-09-03T12:22:28 *** kgs has quit IRC 2008-09-03T12:43:40 first class of day: my prof spent 5 minutes trying to find the backspace button on a french keyboard (it's in the exact same place as on an english keyboard) 2008-09-03T12:44:04 then the wireless mouse wouldn't work, so she couldn't teach 2008-09-03T12:44:42 i need some lunch... 2008-09-03T12:44:50 good start, kbeswick_ 2008-09-03T12:44:54 was it a course on i18n? 2008-09-03T12:44:58 hahaha 2008-09-03T12:45:00 computer networks 2008-09-03T12:45:25 and i have her for another class this afternoon 2008-09-03T12:46:16 dbms? 2008-09-03T12:46:20 indeed 2008-09-03T12:47:04 my friend had her for the 2nd year DB class last year, and he said he had to teach her SQL 2008-09-03T12:47:20 bring a copy of Apache Derby, I'm telling you. not only is it a handy hefty weapon, you can intimidate others with your ability to quickly look up basis dbms principles 2008-09-03T12:47:26 hahaha 2008-09-03T12:47:32 can i get it autographed? 2008-09-03T12:47:34 that's so sad. why don't they get me to teach that course? 2008-09-03T12:47:45 you should tell them to let you 2008-09-03T12:48:07 your initials are practically dbms 2008-09-03T12:48:13 you are more than qualified 2008-09-03T12:48:41 with special guest lecture by m "1667 minutes!" rylander 2008-09-03T12:48:46 :) 2008-09-03T12:49:41 hey, i was peeking at your hardware database the other day. i didn't see any ip addresses, buster 2008-09-03T12:50:08 they should be there 2008-09-03T12:50:12 i remember putting them in 2008-09-03T12:50:37 hmm. remind me how SQL works again? 2008-09-03T12:50:41 (go eat) 2008-09-03T12:50:57 dbs: have you been to the caf recently? 2008-09-03T12:51:07 as in the past hour 2008-09-03T12:51:10 about 15 minutes ago, yeah 2008-09-03T12:51:14 is it crazy? 2008-09-03T12:51:23 no, it was fast 2008-09-03T12:51:29 good 2008-09-03T12:51:31 brb! 2008-09-03T12:54:09 kbeswick_: ah, you put ip addresses into the inventory_owner table. I guess that makes a certain amount of (crazy) sense. 2008-09-03T13:19:42 *** kgs_ has joined #openils-evergreen 2008-09-03T13:19:47 *** kgs_ is now known as kgs 2008-09-03T13:20:17 doh - having a valid ses token helps avoid 403s in vandelay. dbs-- 2008-09-03T13:24:16 dbs: are you able to communicate with vandelay now? 2008-09-03T13:25:03 berick: got the interface running to the point of a clickable upload button, just recreated the schema, but I'm sure that other parts of my schema are out of date 2008-09-03T13:25:14 https://comet.cs.uoguelph.ca/vandelay/vandelay.html?ses=cc6a851e7df8bbb2d700adb19543224d 2008-09-03T13:25:48 I was just going to go check commits to src/sql/Pg to see what I should poke into 2008-09-03T13:26:18 dbs: is open-ils.vandelay enabled/configured in opensrf.xml? 2008-09-03T13:26:19 eeevil: you there? 2008-09-03T13:26:44 berick: oh. shut. up. :) 2008-09-03T13:26:51 hm, there's no default config in the example 2008-09-03T13:26:54 i'll add one... 2008-09-03T13:27:43 I actually looked at Vandelay.pm for that purpose but got distracted by schema stuff 2008-09-03T13:28:33 added 2008-09-03T13:28:42 no special sauce 2008-09-03T13:37:57 would anyone with some experience with creating report templates mind looking at the little user manual i just built and let me know if im completely off base, or maybe on the right track? 2008-09-03T13:38:40 i can 2008-09-03T13:38:52 but 2008-09-03T13:38:59 i get to use parts of it in the big one i've been working on 2008-09-03T13:39:18 that will then, eventually, be contributed to Evergreen 2008-09-03T13:39:45 sk, you have an email? 2008-09-03T13:40:14 sure, use error23@gmail.com 2008-09-03T13:40:20 and just out of curiosity, are you with a library system? 2008-09-03T13:40:25 yes 2008-09-03T13:40:28 ish 2008-09-03T13:40:30 which? 2008-09-03T13:40:30 i work for PINES 2008-09-03T13:40:34 ok, great 2008-09-03T13:40:37 im with the Indiana State Library 2008-09-03T13:40:51 Well, I work for GPLS, the agency that wrangles the Georgia PINES consortium 2008-09-03T13:40:55 great 2008-09-03T13:41:05 you want to do me a big favor? 2008-09-03T13:41:10 i can try 2008-09-03T13:41:17 I've written a beginning guide to reports that i've been trying to get people to edit for me 2008-09-03T13:41:24 ok 2008-09-03T13:41:56 i'd love it if you'd look over it and send me criticisms, changes, clarifications, or points that i've missed 2008-09-03T13:41:59 sweet 2008-09-03T13:42:04 sure, i could do that 2008-09-03T13:42:08 email on its way with my guide 2008-09-03T13:42:09 double sweet! 2008-09-03T13:42:49 skmurphy_lt: can you also forward it to shae@esilibrary.com 2008-09-03T13:42:57 we're both at critical mass right now 2008-09-03T13:43:03 sure 2008-09-03T13:43:11 shae doesnt need any more work ;) 2008-09-03T13:43:14 also... have you considered forwarding it to the documentation list for feedbacck? 2008-09-03T13:43:28 i was figuring on doing so after i got it pines-worthy 2008-09-03T13:43:44 but, i suppose i could now, instead 2008-09-03T13:44:01 mrpeters_isl I know... she and I are sitting next to each other ;-) 2008-09-03T13:44:19 kbeswick_: I'm around now 2008-09-03T13:44:25 (i'm a little embarrassed since its just me that's worked on it... i kinda want to get a few people to look at first before i send it to a big list) 2008-09-03T13:44:36 skmurphy_lt understood :) 2008-09-03T13:44:38 give her my hello 2008-09-03T13:44:46 have you shared it with the reports subcomm? 2008-09-03T13:48:20 one thing i really need is some better information on what is what in the database source browser 2008-09-03T13:48:38 i was just trying to run a report to find out how many items the library had in its catalog for example, and im not quite sure on how to do that 2008-09-03T13:51:34 oh, sure 2008-09-03T13:51:42 you create a template off the "Classic Item List" 2008-09-03T13:52:08 filter on "Owning Lib" with the transform 'in list' 2008-09-03T13:52:17 really, though, documenting that's gonna be difficult 2008-09-03T13:52:30 i use the database schema as a reference when creating reports 2008-09-03T13:52:36 hmm 2008-09-03T13:52:39 where might i see that? 2008-09-03T13:52:53 i guess maybe i dont know enough about databases 2008-09-03T13:52:56 berick++ 2008-09-03T13:53:09 file has been uploaded and a queue has been created 2008-09-03T13:53:22 sk....i dont have a transfor for "in list" 2008-09-03T13:53:33 http://open-ils.org/documentation/evergreen_1.1.3_erd.html 2008-09-03T13:53:55 That lists the database tables and fields 2008-09-03T13:53:57 its a little out of date 2008-09-03T13:54:01 but useful for most things 2008-09-03T13:54:06 dbs: great! so no problems with the conflicting apache location? 2008-09-03T13:54:18 berick: I'm using vandelay-upload 2008-09-03T13:54:23 ahh, ok, cool 2008-09-03T13:54:43 dbs: are you planning to commit your startup.pl and eg_vhost.conf changes? 2008-09-03T13:55:28 berick: yep, just wanted to ensure that things were mostly functional first 2008-09-03T13:55:42 dbs++ 2008-09-03T13:57:48 berick: bah, I've done nothing in comparison 2008-09-03T13:59:19 what's the xsl command to /not/ output any surrounding bits (e.g. ) 2008-09-03T13:59:31 * berick suspects xsl:output 2008-09-03T14:08:19 berick: you just want to remove the version processing instruction? 2008-09-03T14:09:24 eeevil: i don't want anything i'm not explicitly outputting. 2008-09-03T14:10:00 you could use I suppose, but ... is it outputing malformed xml? 2008-09-03T14:10:17 i think i'm close with.. 2008-09-03T14:10:19 yeah. 2008-09-03T14:10:20 2008-09-03T14:10:52 testing... 2008-09-03T14:11:06 wait ... xsltproc is spitting out malformed xml??? 2008-09-03T14:11:29 no, sorry, was saying "yeah" to type="text" 2008-09-03T14:11:31 method="text" won't like the bare elements 2008-09-03T14:11:37 oh 2008-09-03T14:12:40 there it goes 2008-09-03T14:13:36 berick: what are you working on that can't accept the processing instruction? 2008-09-03T14:15:40 eeevil: i want an HTML version of the MARC that's just a div with a table, and not the whole html document. 2008-09-03T14:16:37 hrm... why not just get the responseXML and grab the div out of it? 2008-09-03T14:16:51 but ... really, whatever works. 2008-09-03T14:17:04 cuz that would require bypassing the net infrastructure and doing raw xhrequests 2008-09-03T14:17:25 point :) 2008-09-03T14:17:41 but ... hrm... how do we do added content for reviews and stuff 2008-09-03T14:18:17 why, raw requests, of course ;) 2008-09-03T14:18:54 heh ;) 2008-09-03T14:30:15 skmurphy_lt - this basic documentation on reporting you gave is great! 2008-09-03T14:30:39 hopefully we can get all of these templates shared with us! it will make life so much easier! 2008-09-03T14:37:02 mrpeters-isl: thanks! having those shared templates is vital; most librarians don't ever create templates if they can avoid it (or, they try and then get one of us to do it for them) 2008-09-03T14:37:18 bingo...thats what im hoping for 2008-09-03T14:37:39 right now there's not really any "Email a template to another library" option though 2008-09-03T14:37:42 i just emailed bill on it again, so hopefully we can get it up so we only have to train a very select few on creating new templates, and can focus on training staff on how to use the existing ones 2008-09-03T14:38:14 right, dbs, we have discussed that....Bill brought that up and said it was a good idea for the future, but that it wasnt that much trouble for him to get them out of the database and onto ours. At leats thats the way I understood it. 2008-09-03T14:38:39 mrpeters-isl: cool! 2008-09-03T14:40:58 mrpeters-isl: can you send me that document in .doc format? I'll add in how to specify filters 2008-09-03T14:41:10 sure, on its way 2008-09-03T14:41:17 woo! 2008-09-03T14:41:41 done 2008-09-03T14:42:45 *** kgs has quit IRC 2008-09-03T14:47:46 *** _bott_ has joined #OpenILS-Evergreen 2008-09-03T15:26:09 *** gmcharlt has joined #OpenILS-Evergreen 2008-09-03T15:27:01 *** gmcharlt has joined #OpenILS-Evergreen 2008-09-03T16:16:25 ps - not sure if you've seen this group in colorado - http://groups.google.ca/group/open-source-co-libraries/browse_thread/thread/da3d69ff459ed6c 2008-09-03T16:29:01 come on Colorado, all the cool states are doing it. 2008-09-03T17:42:37 *** dbs has quit IRC 2008-09-03T18:06:05 *** phase_bb has quit IRC 2008-09-03T18:06:13 Dumb question alert: 2008-09-03T18:06:16 I understand that the reason for doing separate calls to osrf_ctl.sh to start the router, perl, and c services (as opposed to using the start_all action) is that there's a possibility of a race condition that causes problems, right? So, can we not just put some sleepy time in there? 2008-09-03T18:07:13 Rather than doing each step by hand, I mean (I'm working in a test environment where I'm switching an Evg server from one DB to another via different config files so I'm doing a lot of restarts....) 2008-09-03T19:40:41 agJohn: we've put some sleep in there (up to 5s I think), but some environments (vmware instances in particular) can take too long for even that. the "right" way, and the way in 1.4 (for perl services now, hopefully for C as well) will be starting them up in turn in the proper order and waiting until we have confirmation that each is started before moving on to the next 2008-09-03T19:41:28 miker_: so what are the symptoms when it doesn't work right? 2008-09-03T19:42:06 the c services don't start properly, which means no db access (the most noticeable symptom) 2008-09-03T19:42:27 you can test the full stack other than apache by running autogen.sh 2008-09-03T19:43:35 dumb suggestion alert: could you have a shell script check for the positive result of executing each step? 2008-09-03T19:44:16 miker_:Yah. That's fairly noticeable. srfsh would test it too, wouldn't it, if you asked it to login? 2008-09-03T19:44:18 (The 1.2.3.0 version of osrf_ctl.sh I looked at didn't seem to have sleep time happening, but I might've missed it.) 2008-09-03T19:44:19 I've not seen the problem arise to recognize it. Does the c service /report/ that it starts but doesn't really? 2008-09-03T19:44:50 sylvar: I was wondering that too--at what point is the pid file in place? Too early to be used for such a test? 2008-09-03T19:45:27 srfsh would be a good test, yes 2008-09-03T19:46:32 sylvar: Are you at a point you can sign onto Skype? I have some info about a missing index to pass along. 2008-09-03T19:46:40 the services report to the log that they were unable to reach the settings server (which is perl) but not to the console ... they're daemonized by that point 2008-09-03T19:47:10 agJohn: not right now, but would email work? I'm not on my laptop and this machine doesn't have Skype. 2008-09-03T19:47:49 Thanks, miker_. Good to know. sylvar: yup, I'll send you an email...duh... 2008-09-03T19:49:05 miker_: One last thing in case I suspect this has bitten me (because I'm going to try some stuff to make this simpler for me to switch where things are pointing), would that error be in the osrfsys.log file or somewhere else? 2008-09-03T19:53:00 yes, that should be the correct log (or the relevent syslog file, if you're logging there) 2008-09-03T20:07:06 miker_: I assume if I want to see what such an error would like, I could just try to start_c without doing the start_perl action? 2008-09-03T20:07:23 agJohn: that should do it 2008-09-03T20:08:43 *** dbs has joined #openils-evergreen 2008-09-03T20:12:53 *** b_bonner has joined #openils-evergreen 2008-09-03T20:16:17 Hi all, my first time joining chat. I'm pretty new to evergreen and a lot of it's technologies.. I'm experimenting with the VMware 1.2.2.3 debian image and am running into problems with the staff client connection. I saw on the instruction page that there is a known issue with the symbolic links to the xul files, can you help me work around that? 2008-09-03T20:17:41 sure, as that problem is my fault 2008-09-03T20:17:51 heh. thanks! 2008-09-03T20:17:58 just waiting until 1.2.3.1 to upload a new (fixed) image :) 2008-09-03T20:18:16 so - the simplest thing to do is probably: 2008-09-03T20:18:26 su - root 2008-09-03T20:18:40 (password = openils) 2008-09-03T20:18:46 oh wait, you're probably already root 2008-09-03T20:18:51 okay, then 2008-09-03T20:18:55 I wasnt, am now. go ahead. 2008-09-03T20:18:56 cd /openils/var/web/xul 2008-09-03T20:19:19 ls -l 2008-09-03T20:20:09 you see the link pointing back to /home/evergreen/Evergreen-1.2.2.2 (I think? just booting up my vmware image now) 2008-09-03T20:20:46 I see the 1222 directory, am I looking for the HEAD link? (sorry, lots of this is new to me) 2008-09-03T20:21:28 sorry - yes, ROOT -> /root/Evergreen-ILS-1.2.2.2/Open-ILS/xul/staff_client/build 2008-09-03T20:21:43 uh, dang, not ROOT, HEAD 2008-09-03T20:21:48 anyways... 2008-09-03T20:21:51 rm HEAD 2008-09-03T20:22:08 mine actually says 1.2.2.3, possibly because I played around a little trying to fix it myself maybe 2008-09-03T20:22:25 oh 2008-09-03T20:22:34 what exactly does it point to? 2008-09-03T20:23:48 or, skip that too, and just cd /root/Evergreen-ILS-1.2.2.3 2008-09-03T20:23:48 it points to /root/Evergreen-ILS-1.2.23/Open-ILS/xul/staff_client/build/ 2008-09-03T20:23:58 oh, 23? not 2.3? 2008-09-03T20:24:15 typo. 2.3, cant copy from my vm 2008-09-03T20:24:49 ok, cd'd to the evergreen dir 2008-09-03T20:25:38 okay - for sanity's sake, "grep TARGETS install.conf" 2008-09-03T20:25:47 and let me know what the content of that is 2008-09-03T20:26:34 gonna summarize, core, web, reporter, client_xul, server_xul 2008-09-03T20:27:08 excellent 2008-09-03T20:27:19 make STAFF_CLIENT_BUILD_ID=rel_1_2_2_3 install 2008-09-03T20:28:12 done 2008-09-03T20:28:12 *** kgs_writing has joined #openils-evergreen 2008-09-03T20:28:22 should I do the chown? 2008-09-03T20:28:47 yep 2008-09-03T20:29:04 ok, done 2008-09-03T20:29:41 ok - you are indeed done 2008-09-03T20:30:11 you should be able to use the Windows 1.2.2.3 staff client to connect to your image now 2008-09-03T20:30:12 great. I appreciate it. I'm assuming this was the cause of the staff client's error message about version? 2008-09-03T20:30:56 connection to staff client is working now. Thanks so much. I'm sure I'll be back with a lot more questions later ;) 2008-09-03T20:31:20 yep - for one thing, there was no rel_1_2_2_3 link in the /openils/var/web/xul directory (I think I built the image before the staff client was released) 2008-09-03T20:31:33 for another thing, the symbolic link for all the other versions was dead wrong :( 2008-09-03T20:32:21 I also recently build an ubuntu hardy image from scratch using v1.2.3.0 and was getting the same version message. should I look for a similar cause there? 2008-09-03T20:33:41 *** kgs_writing is now known as kgs 2008-09-03T20:33:49 probably - there is no 1.2.3.0 packaged Windows staff client, IIRC 2008-09-03T20:34:11 oh - I'm wrong 2008-09-03T20:34:16 its on the dl page 2008-09-03T20:34:31 right, so for that version of the client make STAFF_CLIENT_BUILD_ID=rel_1_2_3_0 install 2008-09-03T20:34:41 or symlink them 2008-09-03T20:35:10 I think I am experiencing an opensrf connection problem on that build too, I'll research that first and get back to you on this if I can't get it ironed out. Again, thanks.. 2008-09-03T20:35:21 I've been kinda tweaking the download page -- don't know if you find this a little easier to navigate: http://evergreen-ils.org/downloads.kgs.php 2008-09-03T20:37:12 b_bonner: my pleasure - btw, on hardy you installed postgresql 8.2 right? 2008-09-03T20:37:21 postgresql 8.3 isn't supported yet 2008-09-03T20:37:33 I did, I read all about the 8.3 issues 2008-09-03T20:37:43 good good 2008-09-03T20:38:11 and settings-tester.pl can come in handy, verbose as it is 2008-09-03T20:39:06 I've used that some, I've been trying to figure out as much as I can on my own..glad you're hear to help though. 2008-09-03T20:39:20 *here*, long day. 2008-09-03T20:39:22 b_bonner: most hours of the day, and some of the night :) 2008-09-03T20:39:37 I've noticed that on the chat logs, you are a machine! 2008-09-03T20:40:16 kgs: I kind of like the http://filezilla-project.org/ approach - downloads front and center, not too wordy, link off to a separate page if need be 2008-09-03T20:40:42 our current download page is really long, and kind of cramped due to the borders on the left and right 2008-09-03T20:41:15 interesting approach... I think I need to chill for the evening... extremely long couple of days. be well! 2008-09-03T20:41:21 *** kgs is now known as kgs_evening 2008-09-03T20:46:03 have a good relaxing evening, kgs! 2008-09-03T21:15:08 *** b_bonner has quit IRC 2008-09-03T21:26:13 miker_: i have gotten the check 2008-09-03T21:31:42 miker_: can I have a cheque too, please? 2008-09-03T21:34:52 *** skmurphy_lt_ has joined #openils-evergreen 2008-09-03T21:39:55 *** skmurphy_lt has quit IRC 2008-09-03T21:40:02 *** skmurphy_lt_ is now known as skmurphy_lt 2008-09-03T21:45:48 dbs: what is the hotkey in windows to change between keyboard locales? 2008-09-03T21:46:04 ctrl-alt-alt ? 2008-09-03T21:46:11 or ctrl-shift-shift? 2008-09-03T21:46:45 ah , nm problem solved. thanks 2008-09-03T21:46:58 left-alt + shift 2008-09-03T21:48:00 *** skmurphy_lt_ has joined #openils-evergreen 2008-09-03T22:00:23 skmurphy_lt_: just finished reading your reporting doc 2008-09-03T22:00:37 * skmurphy_lt_ braces 2008-09-03T22:01:23 I think our librarians and staff would be happy to have that in their hands, vs. the docs we have for our product today 2008-09-03T22:02:13 I really liked the "type of question vs. specific question" angle you took 2008-09-03T22:02:25 thanks; that seems to be really effective in the trainings 2008-09-03T22:02:58 I tried /real/ hard not to get to pedantic 2008-09-03T22:03:09 and also liked the "How to..." steps section 2008-09-03T22:03:48 and also liked the judicious use of screenshots, focusing on the pertinent section 2008-09-03T22:03:54 were there any parts that just didn't make sense? 2008-09-03T22:03:57 so there 2008-09-03T22:04:06 or language i can clean up/get rid of? 2008-09-03T22:04:21 *** skmurphy_lt has quit IRC 2008-09-03T22:04:23 Also, thanks, I'm glad you liked it! 2008-09-03T22:07:31 I thought there was a bit of inconsistency between the WARNING box and the TIP! icon (the first tip seemed to be warning that you could lose the customizations you already made if you navigated away, making it more of a warning than a tip) but that could be _me_ being pedantic 2008-09-03T22:07:52 *** rsinger_ has joined #OpenILS-Evergreen 2008-09-03T22:08:21 so my suggestion there would be to stick with one style of delineating warnings and tips, and maybe convert that first tip into a warning :) 2008-09-03T22:09:32 nah, that's a good point 2008-09-03T22:09:46 that document is a mash of older ones 2008-09-03T22:09:58 can you send me a versioned copy with comments on the parts where you see inconsistencies? 2008-09-03T22:10:11 i'd much appreciate it 2008-09-03T22:12:46 dbs: i can get 5 bonus marks if i do a 20 minute presentation on a topic of my choice in DBMS class 2008-09-03T22:13:00 dbs: im thinking a presentation with a guest speaker: dbs! 2008-09-03T22:13:03 hahaha 2008-09-03T22:13:21 kbeswick_: hahaha... ahhh 2008-09-03T22:13:47 skmurphy_lt_: sure, I'll do that 2008-09-03T22:14:00 excellent; thanks! 2008-09-03T22:14:01 hopefully openoffice won't mangle the formatting too badly 2008-09-03T22:14:07 heh, hopefully! 2008-09-03T22:14:25 Well, after I look over it, I guess I'll send it to the documentation listserv 2008-09-03T22:14:33 (and give it to PINES) 2008-09-03T22:14:37 kbeswick_: on full text search, performance tuning... what else? 2008-09-03T22:14:47 dbs: being awesome 2008-09-03T22:14:54 I appreciate it, dbs! And now, good night! 2008-09-03T22:15:02 skmurphy_lt_: good night to you 2008-09-03T22:15:28 kbeswick_: relation drinking games 2008-09-03T22:16:48 Normalization? I Think I Saw Something About That Once: Database "Design" In The Real World 2008-09-03T22:16:59 (not bitter) 2008-09-03T22:23:49 sboyette++ 2008-09-03T22:23:56 *** rsinger has quit IRC 2008-09-03T22:35:47 "Reducing your DBMS to the lowest common denominator with wildly popular frameworks"? 2008-09-03T22:36:16 kbeswick_: you could also repeat my couchdb presentation from code4lib verbatim 2008-09-03T22:41:49 dbs: less work for me!!! 2008-09-03T22:41:51 hahahah 2008-09-03T22:42:11 dbs: i'll just play a sound byte and lip sync 2008-09-03T22:42:15 no one will ever know 2008-09-03T22:42:36 kbeswick_: except that dbs' voice is trademarked 2008-09-03T22:42:58 "We...are...Everrrrgreeeenn!" 2008-09-03T22:43:35 i should just get dbs, and have berick and miker_ linked up via webcam 2008-09-03T22:43:39 classroom party! 2008-09-03T22:46:38 in reality, it will probably just end up being me standing in front of the class of 6 people saying "databases rock and stuff. yeah..." 2008-09-03T22:49:50 the schema i came up with for my thesaurus project is in Domain/Key Normal Form. that's Five-and-a-half-th Normal Form. i was surprised to discover this. 2008-09-03T22:50:09 i should REALLY get back to that soon 2008-09-03T22:51:19 that's halfway turned up to 11 2008-09-03T22:52:16 * miker_ shudders at the thought of 11th normal form 2008-09-03T22:53:02 instead of "the key and only the key" would it be "the bit and only the bit"? 2008-09-03T22:55:36 quantum-relational. you can get all data related to any other datum just by looking at it 2008-09-03T22:55:55 "the spin and only the spin" 2008-09-03T22:57:59 All the world's to me a database, and we are merely data 2008-09-03T22:58:57 berick: is vandelay up on dev somewhere? or on acq perhpas 2008-09-03T22:59:23 meh ... baib 2008-09-03T23:02:34 miker_: http://dev.gapines.org/~erickson/vandelay.html?ses=20949748c870499210e6bbbd84dd2c3d&qtype=bib&qid=3 2008-09-03T23:02:47 got rid of the qtype and qid params to get back to the upload form 2008-09-03T23:02:53 s/got/get/ 2008-09-03T23:03:59 berick: ah, is that how you display queues 2008-09-03T23:04:35 dbs: it is. but if you upload a batch of marc data, it should display the newly imported queue as well (sans the url params) 2008-09-03T23:05:39 hmm - didn't get that, although a queue was added to the vandelay tables. innarestin 2008-09-03T23:05:51 ui challenge i need to deal with (in acq as well) is defining a way to decide which columns to display, how to sort, which ones have auth width, etc. 2008-09-03T23:06:14 dbs: yeah, something prolly exploded 2008-09-03T23:06:28 given the data set I uploaded, no surprise 2008-09-03T23:20:14 *** dbs has quit IRC 2008-09-03T23:23:12 *** dbs has joined #openils-evergreen 2008-09-03T23:24:01 Hmm. Confused. as to 1) why my laptop crashes seemingly randomly a couple of times a day and 2008-09-03T23:24:03 DB response question: 2008-09-03T23:24:04 I've got a test DB w/ a couple of million bibs and around 3 million items. It does keyword searching just fine. But, when I try to do an ISBN search, it thrashes for many minutes. 2008-09-03T23:24:06 The query generated by the search engine is: 2008-09-03T23:24:08 2008-09-03T23:24:09 SELECT DISTINCT f.record 2008-09-03T23:24:10 FROM metabib.full_rec f 2008-09-03T23:24:12 JOIN biblio.record_entry b 2008-09-03T23:24:14 ON (b.id = f.record) 2008-09-03T23:24:16 WHERE ( f.tag = '020' OR f.tag = '024' ) 2008-09-03T23:24:17 AND f.value like '0679891382%' 2008-09-03T23:24:19 AND b.deleted IS FALSE 2008-09-03T23:24:20 2008-09-03T23:24:22 Now, it turned out that my test DB was missing the index on metabib.full_rec on the tag and subfield columns, so that wouldn't help it any. So, I created the index & reran the query. Thrashed for 473 seconds. 2008-09-03T23:24:24 Checking another DB I have access to, I see that there is an index on metabib.full_rec.value--but, I can't build that on this DB because it gives me the following error: 2008-09-03T23:24:25 ERROR: index row size 3032 exceeds btree maximum, 2713 (long subfield, I guess). 2008-09-03T23:24:27 So, is this missing index the problem, and if so, should I build it on a substring of value or what (the HINT suggests "a function index of an MD5 hash of the value, or use full text indexing)--well, it doesn't look to me like either of those will help this query run faster. Suggestions? 2008-09-03T23:24:36 paste! 2008-09-03T23:24:59 2) http://svn.open-ils.org/trac/ILS/browser/trunk/Open-ILS/src/perlmods/OpenILS/WWW/Vandelay.pm#L74 - my vandelay is quite happily printing exactly that (well, with the md5 value for data_fingerprint) 2008-09-03T23:25:37 agJohn: see a 1.4 patch for an index expression 2008-09-03T23:25:56 that just indexes the first 1024 characters of the full_rec.value 2008-09-03T23:26:23 specifically: http://svn.open-ils.org/trac/ILS/browser/trunk/Open-ILS/src/sql/Pg/1.4-shadow_full_rec-upgrade-db.sql 2008-09-03T23:27:04 OK. That seemed like the way to go. Philosophically, is there any reason to even to 1K chars (seems a lot for this type of search--but I guess there's also the general tag/subfield search too, right?). 2008-09-03T23:27:11 it's running rather happily here 2008-09-03T23:27:29 Excellent. 2008-09-03T23:27:45 agJohn: philosphically, and even practically, yes - contents fields for music collections often blow past that 2008-09-03T23:29:20 http://comet.cs.uoguelph.ca/vandelay-upload/vandelay/vandelay.html?ses=fda21a14432f4d56176ae3159614f84c 2008-09-03T23:29:22 sigh. 2008-09-03T23:29:43 extra headers i guess 2008-09-03T23:29:49 Oh, I wasn't meaning that the contents of a subfield wouldn't be longer than 1K--just wondering how often a search would be done (using the above formulation) that would go beyond the first say 50 characters--but I'd forgotten about the generic search. So, it'd be interesting to see where the balance point would be. That is, you could do a keyword search (assuming it's an indexed subfield). 2008-09-03T23:29:51 2008-09-03T23:29:53 BTW, was that "paste!" a directive to me... 2008-09-03T23:30:34 Trying to teach me better IRC manners, perhaps? 2008-09-03T23:30:40 agJohn: yeah, although it's not really such a concern when things aren't too busy :) 2008-09-03T23:31:03 I'm an IRC novice so I do dumb stuff.... 2008-09-03T23:31:20 And, I either don't provide enough detail or I send too much.... 2008-09-03T23:31:31 don't worry about it 2008-09-03T23:31:52 yeah - an isbn search isn't going to go past 50 chars :) 2008-09-03T23:32:22 Not until ISBN-51, anyway, and that's a few years off yet. 2008-09-03T23:33:10 sylvar++ :-D 2008-09-03T23:33:59 agJohn, I replied by email. Not sure if I'll be around by the time you reply. It's late over here. :) 2008-09-03T23:34:37 dbs pasted "meh - duplicate headers from vandelay? what the..." at http://paste.lisp.org/display/66276 2008-09-03T23:35:37 I'll take a look now. 2008-09-03T23:35:39 dbs: Just FYI, the comet.cs.uoguelph.ca/vandelay... URL returns a 403 forbidden to me... 2008-09-03T23:36:32 agJohn: session expired, the paste has http://comet.cs.uoguelph.ca/vandelay-upload/vandelay/vandelay.html?ses=bc1c86f46bd57d5cf77bfafe1ac3080b 2008-09-03T23:37:50 dbs annotated #66276 with "bah! curl says otherwise" at http://paste.lisp.org/display/66276#1 2008-09-03T23:39:27 dbs: not sure what you're trying to show me, but I do, in fact see what the curl paste shows--not getting it.... 2008-09-03T23:39:38 agJohn: exaclty 2008-09-03T23:39:46 you're supposed to see a nice upload form 2008-09-03T23:39:59 Ah, gotcha. 2008-09-03T23:40:10 compare with: curl http://dev.gapines.org/~erickson/vandelay.html -d ses=20949748c870499210e6bbbd84dd2c3d -G 2008-09-03T23:40:35 I see that when I click on this link at the top of my IRC client: 2008-09-03T23:40:36 http://paste.lisp.org/new/openils-evergreen 2008-09-03T23:40:41 or in your browser http://dev.gapines.org/~erickson/vandelay.html?ses=20949748c870499210e6bbbd84dd2c3d 2008-09-03T23:41:13 I'll remember how to paste next time. Thanks! (And, do you always work this late?) 2008-09-03T23:41:30 sadly, it seems so! 2008-09-03T23:41:36 cool - we'll see you around