Evergreen ILS Website

IRC log for #evergreen, 2014-05-22

| Channels | #evergreen index | Today | | Search | Google Search | Plain-Text | summary | Join Webchat

All times shown according to the server's local time.

Time Nick Message
02:04 b_bonner joined #evergreen
02:05 mtcarlson_away joined #evergreen
05:02 pinesol_green Incoming from qatests: Test Success - http://testing.evergreen-ils.org/~live/test.html <http://testing.evergreen-ils.org/~live/test.html>
07:39 akilsdonk joined #evergreen
08:28 mrpeters joined #evergreen
08:34 Dyrcona joined #evergreen
08:34 Dyrcona left #evergreen
08:35 Dyrcona joined #evergreen
08:36 timf joined #evergreen
08:44 mmorgan joined #evergreen
08:44 Shae joined #evergreen
08:50 jwoodard joined #evergreen
08:52 kbeswick joined #evergreen
09:07 ldw joined #evergreen
09:17 pinesol_green [evergreen|Galen Charlton] LP#1321411: restore ability to handle credit payments using a processor other than Stripe - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=e2261fe>
09:34 yboston joined #evergreen
09:45 pastebot "mrpeters" at 64.57.241.14 pasted "An easier way to audit in-db circ rules via PostgreSQL" (7 lines) at http://paste.evergreen-ils.org/39
09:46 mrpeters ^^ whipped that up, threw it on random magic spells also
09:46 mrpeters makes it more similar to what you see in the staff client when editing circ policies
09:47 mrpeters actually should take it one step more and add copy location
09:47 bshum mrpeters: http://pastie.org/9199134
09:47 bshum That's what we use in our consortium to track circ policy
09:47 bshum I added limit sets too :)
09:47 mrpeters oh, shoot, look at me reinventing the wheel again :(
09:47 bshum We don't circ based on copy locations for us
09:48 bshum No I probably need to adjust ours anyways
09:48 bshum Actually definitely
09:48 bshum It should be more like yours with LEFT OUTER JOIN
09:48 bshum Not INNER JOIN for those duration, etc.
09:48 bshum Since there's fall through to consider
09:50 * mrpeters needs to learn more about which joins to use in various cases
09:51 bshum I like to think of it as INNER is 1:1 (expect something on both sides to link with)
09:51 * Dyrcona uses a Perl script to dump everything to an Excel spreadsheet, naturally.
09:51 bshum LEFT OUTER means expect 1:0 (always something on the left, sometimes something on the right
09:51 Dyrcona It's available in my evergreen_utilites repo, naturally.
09:51 pastebot "mrpeters" at 64.57.241.14 pasted "An easier way to audit in-db circ rules via PostgreSQL (now with copy locations)" (8 lines) at http://paste.evergreen-ils.org/40
09:51 mrpeters Dyrcona: now that is awesome!
09:52 mrpeters i just run this with a COPY WITH CSV HEADER but thats pretty sweet
09:52 * bshum rarely uses RIGHT OUTER JOINs.
09:52 mrpeters i should have asked around first :(
09:52 Dyrcona mrpeters: You should reserve your judgment until you see what you actually get. :)
09:54 bshum Oh I guess I could use string_agg now
09:54 bshum new_postgresql++
09:55 mrpeters Dyrcona: well, i got what i needed from mine but i will give yours a look when i have some free time
09:55 mrpeters something with my query is boned though, becuase i get the same config.circ_matrix_matchpoint ID value multiple times in some cases
09:56 Dyrcona mrpeters: Mine ignores a few things because we don't really use them that heavily here.
09:56 PSM joined #evergreen
09:58 PSM good morning, I installed eg server 2.6 and was unfortunately unable to restart PostgresSQL using pg_ctl start. I received the error 'command not found', could you help me with this please?
10:01 csharp PSM: what OS are you on?  how did you install postgresql?
10:01 pinesol_green [evergreen|Remington Steed] Remove buggy, unused function get_leaders_from_usergroup - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=0575262>
10:02 PSM ubuntu 12.04 precise, I believe I installed it using software center
10:02 csharp PSM: then you should probably try 'sudo /etc/init.d/postgresql restart'?
10:03 kmlussier joined #evergreen
10:08 csharp PSM: note that if you restart postgresql, you'll also need to restart opensrf
10:08 phasefx jfyi, and maybe apropos to PSM, I'm redoing the checking_for_errors document for osrf_control
10:09 ldw joined #evergreen
10:13 Bmagic im having an issue with /openils/bin/opensrf_router . it is telling me that it can't load libopensrf.so.2 (file not found). When I do an strace, it's looking for it here: /lib/tls/x86_64/libopensrf.so.2   Why? It should be looking for it  in /openils/lib right?
10:15 tsbere Bmagic: Did you do the /etc/ld.so.conf.d/opensrf.conf and ldconfig steps?
10:16 Bmagic echo "/usr/local/lib/dbd" > /etc/ld.so.conf.d/eg.conf   yes
10:16 Bmagic ldconfig yes
10:16 Bmagic tsbere: oh wait, let me check opensrf
10:17 zerick2 joined #evergreen
10:17 mllewellyn joined #evergreen
10:18 Bmagic tsbere: echo openils/lib > /etc/ld.so.conf.d/opensrf.conf  yes
10:19 Bmagic tsbere: I may have found it
10:19 Bmagic contents of /etc/ld.so.conf.d/opensrf.conf   was this  "openils/lib"   It needs the beginning "/" I bet
10:19 tsbere Bmagic: I was going to mention the missing / from the echo when you said you may have found it
10:20 Bmagic tsbere: Thanks, sometimes its the simple things
10:20 Bmagic tsbere++
10:21 PSM <csharp> Great, 'sudo /etc/init.d/postgresql restart' worked. Does restarting the computer restart also opensrf? I would like also to ask if there is a certain procedure I have to follow to close eg before shuting down the computer?
10:25 Dyrcona PSM: Unless you have created your own init scripts, you will want to manually stop OpenSRF before shutting down and starting OpenSRF after starting the computer/vm.
10:25 csharp PSM: to restart opensrf, you should, as the opensrf user, do 'osrf_ctl -l -a restart_all' (or 'osrf_control --localhost --restart-all' if you're on a newer version) - unless you've created an init/upstart script, you have to do it manually
10:26 Dyrcona PSM: You will likely have to restart Apache after starting OpenSRF.
10:26 csharp Dyrcona beat me to it ;-)
10:26 Dyrcona PSM: Depending on the version of OpenSRF, I'd recommend osrf_control over osrf_ctl.sh.
10:27 Dyrcona If you don't stop OpenSRF before shutting down, it's usually not a big deal, but you'll get messages about stale PID files when starting OpenSRF after the reboot.
10:32 PSM Thanks. I have another issue that is still persistent every time I try to save a new record in my Staff Client I receive an error: 'Event: 2002: DATABASE_QUERY_FAILED-> The attempt to query to the DB failed' I would really appreciate if you can help me with this issue as well.
10:38 ldw joined #evergreen
10:49 Dyrcona PSM: That's a more difficult problem as bad data or bad code could cause it and without direct access to the hardware to look at logs, it would be difficult to determine what, exactly, is causing your problem.
10:50 Dyrcona PSM: A good place to start would be the logs on the postgresql server. There should be entries in there with the details of the query that failed.
10:51 PSM <Dyrcona> Sounds like a good start. Where can I find these logs?
10:51 Dyrcona PSM: On your server that runs postgres. The location may depend on what gnu/linux distro you use.
10:52 PSM I am running precise
10:56 Dyrcona /var/log/postgresql/postgresql-{version}-main.log
10:57 Dyrcona Where {version} is the version of postgres, like 9.1 or 9.3 or whatever.
10:57 PSM 9.1
11:06 PSM <Dyrcona> got it, following are few of the lines that I copied from postgresql log file 2014-05-22 09:11:50 CDT LOG:  database system is shut down 2014-05-22 09:13:10 CDT LOG:  database system was shut down at 2014-05-22 09:11:50 CDT 2014-05-22 09:13:10 CDT LOG:  database system is ready to accept connections 2014-05-22 09:13:10 CDT LOG:  autovacuum launcher started 2014-05-22 09:13:10 CDT LOG:  incomplete startup packet 2014-05-22 0
11:07 PSM <Dyrcona> 2014-05-22 09:14:42 CDT ERROR:  "search_result" is a composite type at character 15 2014-05-22 09:14:42 CDT STATEMENT:  SELECT * FROM search.search_result AS x WHERE 1=0; 2014-05-22 09:14:42 CDT ERROR:  "search_result" is a composite type at character 15 2014-05-22 09:14:42 CDT STATEMENT:  SELECT * FROM search.search_result AS x WHERE 1=0; 2014-05-22 09:14:42 CDT ERROR:  "search_result" is a composite type at character 15 2
11:08 Dyrcona PSM: Stop pasting all that in the channel, please.
11:08 PSM ok
11:09 Dyrcona Here's what I suggest: tail -f /var/log/postgresql/postgresql-9.1-main.log
11:10 Dyrcona Have the window with that visible while you try to add a record in the staff client.
11:10 Dyrcona you should see the error go scrolling by in the window with the tail -f running.
11:12 PSM ok, let me try
11:18 PSM <Dyrcona> the first line of the errors says: CDT ERROR:  new row for relation "lineitem" violates check constraint "picklist_or_po"
11:20 RoganH joined #evergreen
11:21 PSM <Dyrcona> may be the second line will you give more light, it says: CDT STATEMENT:  INSERT INTO acq.lineitem
11:21 Dyrcona Ah, you're trying to create records via acquistions, it sounds like.
11:22 Dyrcona I don't really know much about acquisitions.
11:22 PSM that's right
11:22 Dyrcona You should use New MARC Record from the CAtaloging menu.
11:23 PSM I tried that, but was unable to type in the typing places, but I will try that again now
11:24 dbwells grabbing 0881
11:28 PSM <Dyrcona> I went to Cataloging, load, Create Record, I can click next to title where it gives me a space to type, but no entries can be done, same problem also when I try to go to add volumes. I noticed there is no new logs in the postgresql log file
11:30 pinesol_green [evergreen|Jason Etheridge] LP#1314920 change the desc for the org hiding setting - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=4dbe9b1>
11:30 pinesol_green [evergreen|Dan Wells] LP#1314920 Stamping upgrade script - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=5beaf3a>
11:31 Dyrcona PSM: At that point, I don't think you're even getting to the database.
11:32 Dyrcona PSM: Your problems are more complicated than I can help with over IRC. I suggest you reinstall everything.
11:34 PSM <Dyrcona> Ok, this is a new installation, I installed server 2.6 by mistake, would you suggest I reinstall 2.6 or go with 2.5 instead?
11:35 Dyrcona PSM: I don't understand why you say you installed 2.6 by mistake? It is the latest version.
11:37 PSM <Dyrcona> It's because eg download site says 'Currently the latest release from the Evergreen 2.5 series is recommended for new installations' which I haven't read before I started
11:39 kmlussier Downloads page needs to be updated?
11:39 * kmlussier can do it unless bshum beats me to it.
11:40 bshum kmlussier: I'm at a day conference and intermittently here and there today.
11:40 bshum So you can beat me to it ;)
11:40 kmlussier Happy to. :)
11:41 Dyrcona PSM: I recommend using git to get the code directly from the repositories and install the master branch. I do not recommend using the release tarballs.
11:42 bshum PSM: That said, 2.6 is supposed to be the recommended version on the downloads page.
11:43 kmlussier Done
11:43 bshum kmlussier++
11:44 PSM I am glad to hear that and thanks for updating the website so quickly. Where can I find the instructions to use git and to install the master branch as you kindly recommended?
11:45 Dyrcona PSM: There aren't any such instructions because I'm the only who recommends doing it that way. Everyone else recommends the tarballs.
11:46 Dyrcona You either have the patience to figure it out, or you don't.
11:46 PSM <Dyrcona> I would love to do it your way, if you tell how to.
11:59 PSM I am sorry I have to go now. I will try to reinstall 2.6 as you kindly suggested. Thanks for the excellent support I received today.
12:04 pinesol_green [evergreen|Josh Stompro] (doc) add overdues to summary of the phone list feature - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=926ac84>
12:04 pinesol_green [evergreen|Josh Stompro] (doc) 'debian-wheezy' was left out of the OS options - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=d286fbe>
12:04 pmurray joined #evergreen
12:07 bmills joined #evergreen
12:15 vlewis joined #evergreen
12:59 kmlussier joined #evergreen
12:59 RoganH joined #evergreen
13:03 hbrennan joined #evergreen
13:08 dMiller_ joined #evergreen
13:12 dluch joined #evergreen
13:28 ldw joined #evergreen
13:33 jeffdavis joined #evergreen
13:39 kayals joined #evergreen
13:42 jeff syslog and Data::Dumper aren't good friends.
13:42 jeff especially not Dumper(\$ctx) in tpac :-)
13:55 jwoodard joined #evergreen
14:06 jboyer-isl gmcharlt: I've got a commit for contrib/equinox that adds holds extracts to CollectionHQ, would it be best to just send the details here, or via email, or via someone else entirely? (Don't want to be a bother)
14:06 gmcharlt jboyer-isl: shoot me an email
14:06 gmcharlt and thanks!
14:06 jboyer-isl On it's way.
14:09 phasefx ha, lost my unsaved work in the wiki when firefox crashed
14:09 PSm joined #evergreen
14:09 jeff you should have bought a squirrel!
14:09 * phasefx will edit in vim from now on :-)
14:09 jeff and by "bought a squirrel", I mean "edited outside the browser"
14:09 jeff :-)
14:09 phasefx brought it on myself
14:11 * phasefx usually uses chrome, but there's this web app that actually exercises a chrome bug :(
14:11 PSm Hi, I am trying to install staff client 2.6 on my server 2.6 Currently I am at the step 4 'download the 32-bit or 64-bit version of the staff client from your Web server at http://hostname/updates/manualupdate.html' I am not sure where can I find this download, could you help me please?
14:12 phasefx PSm: if you're not going for a self-upgrading client, I would just download the client from evergreen-ils.org
14:12 Dyrcona PSm: You have to have built the staff client during the server installation for that to exist.
14:13 phasefx is that actually in installation instructions somewhere?
14:13 Dyrcona probably on the wiki's staff client pages somewhere.
14:13 phasefx PSm: step 4 where?
14:14 PSm here http://docs.evergreen-ils.org/​2.3/_installing_on_linux.html
14:14 Dyrcona PSm: I don't recommend you run the staff client on the server.
14:15 Dyrcona PSm: You should use these docs instead http://docs.evergreen-ils.org/2.6/
14:16 phasefx I think that section of the documentation is inconsistent/misleading.. compare Installing on Windows with Installing on Linux
14:17 phasefx not enough tuits
14:18 * dbs likes the header at http://www.postgresql.org/do​cs/8.0/interactive/mvcc.html which lists the Unsupported Versions of the docs. Could still use a clearer "unsupported" warning for any given page though
14:18 dbs Something like a "WARNING: This version of the softare is no longer supported." watermark
14:19 Dyrcona If you do step 3 before step2, then you don't have to be root to do step 2.
14:20 Dyrcona You also have to restart Apache, I think before step 4 works, but I usually build my clients while installing the rest of the server components.
14:21 Dyrcona PSm: You really only need to do the steps on that page if you use a custom staff client version for some reason. This means most people, probably including you, don't have to do those steps.
14:21 phasefx I think it'd be kind of neat to have localized overlays for the docs too.. encourage some of the big sites to improve the main documentation instead of writing their own, and just have the local site-specific stuff in "sidebars" and "examples" that could be filtered out
14:22 dbs hmm, downloads page links to http://evergreen-ils.org/dokuwiki/doku.p​hp?id=evergreen-user:installing_and_runn​ing_the_staff_client#installing_on_linux for building and installing the client
14:23 Dyrcona PSm: Step four assumes you are on a different computer from the server and that you replace "hostname" with the fully qualified domain name of your Evergreen server.
14:23 dbs mebbe we should get that sorted out
14:23 bshum dbs: Sigh, yeah, that's the traditional link from past website versions.  Back from before we had actual Linux builds.
14:24 bshum Could probably just remove it
14:24 dbs phasefx: that sounds confusing and likely unworkable to me. better to encourage them to fork the git docs repo, build their own local version of the docs, and make their docs openly available under a CC-BY-SA license so DIG can roll whatever they want back in
14:24 Dyrcona dbs: Those instructions are ever worse and mostly untrue.
14:24 bshum And link to the tarballs for Linux?
14:24 dbs bshum++ # yes
14:26 phasefx dbs: I can dream; I doubt anything will happen along either of those lines :)  but take a drop-down for switching languages on the fly, and just extend the concept.  That's what I was thinking
14:27 dbs We basically jumpstarted the docs thanks to SITKA and Michigan Evergreen and a few others who had their own local docs
14:28 bshum dbs: I'll try and take a poke at it later this afternoon if someone else doesn't get there first.  I'm at a day conference and learning about OpenStack right now :)
14:30 PSm Do you think I should not install client same machine as the server, not even to be able to test the DB?
14:31 Dyrcona PSm: I'd recommend downloading a client to your local computer and testing it from there.
14:31 PSm ok, thanks for the advice
14:34 Dyrcona bshum: Kill it with fire. Those instructions are for 1.6!
14:36 Callender joined #evergreen
15:04 mllewellyn left #evergreen
15:09 hbrennan Dyrcona: You can have the 45,000 acres of forest burning 50 miles from my house. :)
15:09 hbrennan (Yeah, that was a 40 minute delayed joke)
15:10 Dyrcona hbrennan: Oh, thank you! You can send the title to my agent in Anchorage. He works for the state library.
15:11 hbrennan Dyrcona: :)
15:11 Dyrcona hbrennan: Sorry to hear about the fire. Hopes it hasn't been deadly.
15:12 hbrennan Not so far. Poor moose though.. it's calving season
15:15 * berick looks up for a second... returns to his 1's and 0's
15:19 kmlussier hbrennan: Still smoky there?
15:20 hbrennan kmlussier: Yes. It's so gross! Straight from terrible pollen to smoke and ash falling...
15:21 hbrennan https://www.facebook.com/photo.php?​fbid=877018186806&amp;l=c433076f9b
15:21 hbrennan There's a photo of what the sun and sky looked like the other day
15:22 kmlussier Terrible. I think I would prefer the pollen.
15:22 bshum dbs: I pulled the link to that horribly old wiki page.  And then I put the 32-bit and 64-bit package file links for the various versions.
15:22 hbrennan Me too. At least it was yellow. :)
15:22 hbrennan Okay, my show and tell is over. Back to work!
15:23 dbs bshum++
15:23 bshum Just to get us moving in the right direction again for now.
15:43 mrpeters if i'm reading Holds.pm correctly, an error such as:  "Can't call method "id" on an undefined value at /usr/local/share/perl/5.14.2/Op​enILS/Application/Circ/Holds.pm line 3261." would indicate it
15:43 mrpeters is trying to pull a hold where the target doesnt exist?
15:45 tsbere mrpeters: Maybe? Not sure what the actual contents of that line is in your system compared to my dev machine
15:46 mrpeters 2.3.5 -- let me paste
15:46 mrpeters oh, thats surely it
15:46 mrpeters SELECT id, target, hold_type FROM action.hold_request WHERE requestor IN (SELECT id FROM actor.usr WHERE home_ou=117) AND hold_type='T'  AND target NOT IN (SELECT id FROM biblio.record_entry);
15:47 mrpeters yep, thats gonna cause a problem lol
15:48 tsbere mrpeters: Fun query: SELECT ahr.* FROM action.hold_request ahr LEFT JOIN reporter.hold_request_record rhrr USING (id) WHERE rhrr.bib_record IS NULL;
15:48 mrpeters actually, the issue is they are mapped as T holds and should be C
15:48 mrpeters easy peasy fix
15:49 dkyle left #evergreen
15:51 jihpringle joined #evergreen
16:01 akilsdonk joined #evergreen
16:26 jeff pretty sure this FIRST() is pointless, but would appreciate a sanity check: FIRST((SELECT create_date FROM biblio.record_entry rbr WHERE rbr.id = m.source))
16:27 tsbere jeff: I can't give you a sanity check without the rest of the query.
16:28 tsbere jeff: If something other than m.source is being grouped by, for example, thus leaving the potential of multiple lookups like that, then it is, in fact, doing something useful...
16:31 jeff tsbere: right around here: http://git.evergreen-ils.org/?p=Evergreen.git;a=​blob;f=Open-ILS/src/perlmods/lib/OpenILS/Applica​tion/Storage/Driver/Pg/QueryParser.pm;h=147b1657​1eb73ba8b08ae9fa5b02afafdc21d680;hb=HEAD#l816
16:32 tsbere jeff: When doing a standard search it is less useful. When doing a metarecord search it is more useful.
16:35 tsbere jeff: That is not to say it couldn't be done more efficiently in some cases. I haven't double-checked, but when biblio.record_entry is in the joins *anyway* we can probably skip the subquery...
16:37 tsbere jeff: Are you seeing a problem with it, or just trying to improve search speeds?
16:42 jeff tsbere: I created a problem for myself when playing with a container_date sort, and that made me look at and question the use of FIRST() there. See the two tip commits here: http://git.evergreen-ils.org/?p=work​ing/Evergreen.git;a=shortlog;h=refs/​heads/user/jeff/container_date_sort
16:42 yboston I am customizing my TPAC skin/theme and wondering if there is a way to analyze the DOM of the TPAC HTML that is loaded inside the EG client?
16:42 yboston The reason is that the custom skin works well when just using TPAC in a browser, but when searching the catalog within the browser I am having some issues
16:42 yboston I see that there is an option inside the client for a DOM inspecotr, but it is grayed out. For the record, I am running 2.5.1
16:46 tsbere jeff: I might have solved your second commit's problem with something along the lines of wrapping create_time in an aggregate. MIN(create_date) instead of ordering with limit and all. Dunno which is actually going to be faster though...
16:47 ldw joined #evergreen
16:47 jeff hrm. yeah, not sure why i didn't go that route, now that i think about it.
16:48 jeff though in the case of the route i selected, I'd use MAX()
16:52 tsbere jeff: I would have been tempted to teach the container stuff to drop the filter_alias into a visible spot and have it put the relevant data there. Then container_<filter alias>.whatever would be available without a subquery for sorting. Again, haven't done any analysis for performance reasons, but that would also mean you don't have to worry about container type. The first container of any type could be used.
16:55 jeff i like the direction of that. it might be a good second approach.
16:55 jeff this is mostly proof of concept (though it has escaped into production)
16:56 Dyrcona yboston: You might be able to download the DOM instpector from addons.mozilla.org. I got Venkman that way.
16:56 Dyrcona Venkman == JavaScript debugger.
16:59 * Dyrcona disappears in a puff of logic.
17:00 kmlussier left #evergreen
17:19 mmorgan left #evergreen
17:35 bmills joined #evergreen
17:35 pinesol_green Incoming from qatests: Test Success - http://testing.evergreen-ils.org/~live/test.html <http://testing.evergreen-ils.org/~live/test.html>
19:55 gamambel joined #evergreen
19:56 gamambel is it possible to federate libraries with evergreen? i want users to be able to return books at a different library, for example, but have the libraries run independent instances
20:45 kbeswick joined #evergreen

| Channels | #evergreen index | Today | | Search | Google Search | Plain-Text | summary | Join Webchat