| Time |
Nick |
Message |
| 06:59 |
|
rfrasur joined #evergreen |
| 07:21 |
|
rjackson_isl_hom joined #evergreen |
| 08:05 |
|
alynn26 joined #evergreen |
| 08:14 |
|
Dyrcona joined #evergreen |
| 08:24 |
|
Stompro joined #evergreen |
| 08:25 |
|
mantis1 joined #evergreen |
| 08:36 |
|
mmorgan joined #evergreen |
| 08:52 |
csharp |
https://github.com/kamranahmedse/developer-roadmap - this is cool and makes me want something like it that would be specific to EG |
| 09:13 |
alynn26 |
I would love something like this for EG. |
| 09:18 |
Dyrcona |
Well, start with those road maps, then add things. |
| 09:18 |
alynn26 |
That was what I was thinking |
| 09:18 |
Bmagic |
csharp++ |
| 09:26 |
|
jvwoolf joined #evergreen |
| 09:40 |
|
jvwoolf1 joined #evergreen |
| 09:49 |
|
sandbergja joined #evergreen |
| 10:58 |
|
scpl_shardina joined #evergreen |
| 11:17 |
scpl_shardina |
I'm setting up OpenSRF per the instructions, and everything goes smoothly until I go to test with the opensrf.math service, at which point I get a “Received no data from server” message - but the common cause for that I've found online (incorrect ejabberd password) isn't the issue. I'm getting “Failed to dlopen library file/cannot open shared object file/no such file or directory” errors for libosrf_math.so, libosrf_dbmath |
| 11:17 |
scpl_shardina |
.so and libosrf_cslow.so in osrfsys.log. Any ideas what the issue might be? |
| 11:18 |
scpl_shardina |
I do have multiple OpenSRF process running in ps aux, OpenSRF Router and Listeners/Drones for opensrf.settings, opensrf.validator, opensrf.slooooooow, opensrf.persist are all there. |
| 11:22 |
csharp |
scpl_shardina: are the .so files installed? |
| 11:22 |
jeff |
possible that you missed a step with adding the opensrf shared libraries location and re-running ldconfig |
| 11:22 |
csharp |
that too |
| 11:22 |
scpl_shardina |
yep, they're in /openils/lib |
| 11:23 |
jeff |
http://evergreen-ils.org/documentation/install/OpenSRF/README_3_2_0.html#_adjust_the_system_dynamic_library_path |
| 11:23 |
jeff |
does /etc/ld.so.conf.d/opensrf.conf exist and does it contain /openils/lib? |
| 11:24 |
scpl_shardina |
Ah ha, that's probably the issue - no leading / in that file, it's just openils/lib |
| 11:27 |
scpl_shardina |
Perfect, that did it, thanks! |
| 11:27 |
jeff |
You're welcome! |
| 11:50 |
|
jihpringle joined #evergreen |
| 12:03 |
Dyrcona |
BTW: On Debian Stretch, Buster, and Ubuntu 18.04, you have to run ldconfig again after installing Evergreen or the services written in C will not work. NOTE: My experience on Ubuntu 18.04 has been mixed. Sometimes it works without running ldconfig again. |
| 12:07 |
Dyrcona |
Question: Which is better: a) 1,853 individual update statements or b) 1 update statement with 1,853 barcodes in an IN? |
| 12:08 |
Dyrcona |
I'm going with a) for this one, but sometimes do b). Anyone have thoughts? |
| 12:08 |
alynn26 |
a |
| 12:08 |
Dyrcona |
I use a transaction if you think that matters. |
| 12:08 |
|
mrisher joined #evergreen |
| 12:09 |
Dyrcona |
A) certainly leads to a larger code file. :) |
| 12:09 |
|
rjackson_isl_hom joined #evergreen |
| 12:09 |
Dyrcona |
alynn26: Any particular reason? |
| 12:10 |
abneiman |
Dyrcona: 1000 duck-sized horses or 1 horse-sized duck? :) |
| 12:10 |
Dyrcona |
Heh. |
| 12:10 |
Dyrcona |
abneiman++ |
| 12:11 |
mmorgan |
abneiman++ |
| 12:11 |
Dyrcona |
The output of b) is cleaner: UPDATE 1853. That's the reason that I usually pick b) when I do. |
| 12:12 |
* mmorgan |
often takes the b) approach |
| 12:12 |
mmorgan |
usually, actually. |
| 12:32 |
jeff |
If I'm working with psql and I have the input criteria in a file, I'll often load that into a temporary table and do a single UPDATE statement referencing the values from the temp table. |
| 12:34 |
JBoyer |
Dyrcona, I usually base it on "how many triggers are going to be run if I do all of this at once?" so it changes a lot. :) |
| 12:45 |
Dyrcona |
JBoyer: I find it makes little difference if it's all wrapped in a transaction. |
| 12:45 |
Dyrcona |
jeff: I try to avoid temporary tables unless what I'm doing is very complicated. |
| 12:45 |
* miker |
points at jeff's response, "me. that." |
| 12:46 |
Dyrcona |
In this case, I'm updating 1,853 copies to the same copy location. |
| 12:46 |
JBoyer |
Overall maybe not, but I'd rather have 100 short commits that add up to roughly the same amount of time as a single long commit. :) |
| 12:46 |
miker |
I like having the explicit artifact around -- I don't use a temp table usually. |
| 12:46 |
JBoyer |
That's definitely a "b" easy. |
| 12:47 |
Dyrcona |
I will sometimes save pre-update data to a table in a custom schema when it is something that will likely be undone later. |
| 12:48 |
Dyrcona |
JBoyer: I usually do b) for these but a) felt easier from a regex-search-and-replace standpoint, i.e. when writing the queries. :) |
| 12:49 |
Dyrcona |
We could probably so a SQL round table sometime. |
| 12:52 |
Dyrcona |
There are some updates that I get asked to do so frequently that I have templates and macros to generate the SQL from CSV-style data. |
| 13:00 |
JBoyer |
I could see some things being common enough that while you don't want an interface for them, admins would get some good out of a collection of common queries. |
| 13:02 |
mmorgan |
+1 |
| 14:00 |
|
khuckins joined #evergreen |
| 14:06 |
|
alynn26 joined #evergreen |
| 14:06 |
|
jvwoolf joined #evergreen |
| 14:09 |
|
dbwells_ joined #evergreen |
| 14:09 |
|
alynn26_away joined #evergreen |
| 14:39 |
|
rjackson_isl_hom joined #evergreen |
| 15:22 |
abneiman |
If anyone wants a quick Friday review, I've put an (aspirational) 3.5.0 target on a small wishlist item adding another best hold sort selection order option --> https://bugs.launchpad.net/evergreen/+bug/1869794 |
| 15:22 |
pinesol |
Launchpad bug 1869794 in Evergreen "wishlist: add new best-hold sort option for proximity between user home library and item circulating library" [Undecided,New] |
| 15:25 |
sandbergja |
abneiman: Thanks for organizing the virtual conference! Do you have a sense for when it would be (Spring? Summer? Fall?) |
| 15:26 |
abneiman |
sandbergja: I'm thinking May or June, but really it will depend on availability of our presenters - which is why I wanted to get a sense of who was interested in adapting their presentation |
| 15:26 |
abneiman |
sandbergja: once I have that info, I |
| 15:26 |
abneiman |
'll reach out to interested presenters and see if we can find a timeframe that works for most of us |
| 15:27 |
abneiman |
we're talking about spreading out content over a couple weeks, and of course there's also an option for someone to pre-record if they have that ability |
| 15:27 |
abneiman |
basically anything goes at this point :) |
| 15:27 |
sandbergja |
Thanks, that helps a lot! |
| 15:27 |
abneiman |
you're welcome :) |
| 15:37 |
|
scpl_shardina joined #evergreen |
| 15:38 |
|
mantis1 left #evergreen |
| 15:46 |
scpl_shardina |
Back with another question! So, in the OpenSRF installation instructions, you make the opensrf user owner of the /openils/ dir. After installing OpenSRF, I started going through the Evergreen install instructions, and it wants you to run the ./configure command as the user account - which gets a Permission Denied error, I believe because opensrf has ownership. Does my user account need special permissions? |
| 15:51 |
bshum |
scpl_shardina: Hmm, I think perhaps you might be in the wrong directory when you try to run that command |
| 15:51 |
bshum |
So you do grant ownership of the /openils directory to the opensrf user |
| 15:52 |
bshum |
And when you're doing the Evergreen steps as the user account, you're supposed to be doing that ./configure in the extracted Evergreen-ILS folder you have |
| 15:52 |
bshum |
Not in /openils |
| 15:52 |
scpl_shardina |
Yep, in step 7 here: http://evergreen-ils.org/documentation/install/OpenSRF/README_3_2_0.html |
| 15:52 |
bshum |
Right that's all correct. |
| 15:52 |
scpl_shardina |
And then in step 5 here: https://evergreen-ils.org/documentation/install/README_3_4_2.html I'm in the Evergreen-ILS-3.4.2 folder extracted from the tar |
| 15:54 |
bshum |
Okay, which user did you download Evergreen-ILS tar.gz to, and which user did you use to extract the files? |
| 15:54 |
scpl_shardina |
And get "./configure: line 2019: config.log: Permission denied" and the same for line 2029 |
| 15:54 |
bshum |
In general, if I were say... linuxuser as my login |
| 15:54 |
bshum |
I'd probably download Evergreen to my home directory or downloads folder |
| 15:54 |
bshum |
So it'd be in /home/linuxuser/Evergreen-ILS-3.4.2/ |
| 15:55 |
bshum |
And then go inside that folder to run that ./configure |
| 15:55 |
scpl_shardina |
Ha, that's it! Wrong user extracted it. That's what I get for walking away from my computer for another project :) |
| 15:55 |
bshum |
Aha :) |
| 15:55 |
bshum |
Cool deal |
| 15:55 |
bshum |
Yeah try it again using the same user account |
| 15:55 |
bshum |
Should help |
| 15:57 |
scpl_shardina |
That did it - thanks! |
| 16:01 |
* jeffdavis |
does a double-take, looks up opensrf.slooooooow |
| 16:17 |
* mmorgan |
thinks that must be controlling passage of time this afternoon. |
| 16:18 |
|
mmorgan1 joined #evergreen |
| 16:58 |
jeffdavis |
According to a guy I knew in high school, "they" make the clocks run slower in the afternoon. |
| 16:59 |
jeffdavis |
I'm not sure who "they" were, but apparently it included all school administrators, and also for some reason the Queen. |
| 17:12 |
mmorgan |
jeffdavis++ |
| 17:12 |
|
jvwoolf joined #evergreen |
| 17:13 |
mmorgan |
Good weekend, all! |
| 17:13 |
|
mmorgan left #evergreen |
| 18:25 |
|
rjackson_isl_hom joined #evergreen |
| 21:23 |
|
Dyrcona joined #evergreen |
| 23:36 |
|
mrisher joined #evergreen |
