| Time |
Nick |
Message |
| 06:50 |
|
JBoyer joined #evergreen |
| 07:02 |
|
agoben joined #evergreen |
| 07:08 |
|
rjackson_isl joined #evergreen |
| 08:19 |
|
bdljohn joined #evergreen |
| 08:40 |
|
mmorgan joined #evergreen |
| 08:52 |
|
Dyrcona joined #evergreen |
| 09:16 |
|
sandbergja joined #evergreen |
| 09:28 |
|
terran joined #evergreen |
| 09:41 |
|
yboston joined #evergreen |
| 10:04 |
|
jvwoolf joined #evergreen |
| 10:11 |
csharp |
@band add Git Czechout |
| 10:11 |
pinesol |
csharp: Band 'Git Czechout' added to list |
| 10:17 |
JBoyer |
\m| |m/ |
| 10:20 |
csharp |
@band |
| 10:20 |
pinesol |
csharp: Bath Editing |
| 10:21 |
berick |
@ana Bath Editing |
| 10:21 |
pinesol |
berick: Bidet hating |
| 10:21 |
berick |
har |
| 10:22 |
* csharp |
snickers |
| 10:23 |
Dyrcona |
"Why, you, bidet-hating, bath-editing, scoundrel!" |
| 10:23 |
csharp |
sounds like one of the standard @insults |
| 10:23 |
jonadab |
Sounds like something Leia would say to Han. |
| 10:24 |
Dyrcona |
@band |
| 10:24 |
pinesol |
Dyrcona: Correct Horse Battery Staple |
| 10:24 |
csharp |
@who is a scruffy-looking nerf-herder? |
| 10:24 |
pinesol |
_bott_ is a scruffy-looking nerf-herder. |
| 10:24 |
Dyrcona |
@ana correct horse battery staple |
| 10:24 |
pinesol |
Dyrcona: Crotchety, artless reprobate |
| 10:24 |
Dyrcona |
Ha! |
| 10:24 |
csharp |
pinesol++ |
| 10:25 |
jonadab |
xkcd++ |
| 10:29 |
Dyrcona |
band-plugin-- # for not taking the channel argument like all of the other plugins. |
| 10:39 |
|
Christineb joined #evergreen |
| 10:59 |
|
mmorgan joined #evergreen |
| 11:14 |
gsams |
Does anyone have a handy query for seeing what permissions aren't currently assigned to any group? |
| 11:16 |
JBoyer |
gsams, this will show things that aren't assigned anywhere: select * from permission.perm_list where id not in (select perm from permission.grp_perm_map) |
| 11:17 |
Dyrcona |
Well, that only does groups. There's also usr_perm_map. |
| 11:17 |
JBoyer |
I took the question quote literally. ;) |
| 11:17 |
JBoyer |
quite, even. |
| 11:17 |
Dyrcona |
Yeah, I guess so. I took the question in the broadest sense, I guess. |
| 11:19 |
JBoyer |
gsams hasn't said why he's interested, but I look at user perms as special needs where seeing what no groups have can help you find blind spots in your expected workflows. (assuming that people want the fewest direct perm->user assignments) |
| 11:19 |
Dyrcona |
True. |
| 11:20 |
gsams |
I was interested in finding gaps, there are a lot of permissions we've not implemented as updates have happened I wanted to get an idea of how bad it was. |
| 11:21 |
Dyrcona |
I'd probably do it with a left join: select perm_list.* from permission.perm_list left join permission.grp_perm_map on perl_list.id = grp_perm_map.perm where grp_perm_map is null; |
| 11:22 |
Dyrcona |
oops, typoed perl_list for perm_list. :) |
| 11:22 |
JBoyer |
Dr Freud: Verry eeentereshting. |
| 11:23 |
gsams |
JBoyer++ |
| 11:23 |
gsams |
Dyrcona++ |
| 11:23 |
Dyrcona |
Eliza: What makes you say, Verry eeentersthting? |
| 11:26 |
Dyrcona |
That's ok.. I'm still making mistakes even when I'm not making typos....!!:gs/cwmars/jstephenson/ didn't quite do what I wanted, either. |
| 11:30 |
|
yboston joined #evergreen |
| 11:31 |
|
ddale joined #evergreen |
| 11:33 |
ddale |
Happy Monday Everyone. I have a couple of questions for the group. Is anyone using software that will capture a patron signature and store it in the patron record in Evergreen? What about storing a picture, is anyone doing that? Also, I have been told by a vendor that a driver's licenses scanner will work with Evergreen. It would scan a licenses and transfer the information to the patron record. Is anyone using such a device? |
| 11:34 |
Dyrcona |
ddale: Evergreen has a place to store patron photos in the database, but I'm not sure that it is exposed in the user interface. |
| 11:35 |
|
sandbergja joined #evergreen |
| 11:35 |
JBoyer |
Dyrcona, I think there was talk of putting the img tag in the user record for the web client, even though there's still no way to set one. So it *may* be there. |
| 11:36 |
Dyrcona |
And, I've heard that scanning drivers' licenses can be iffy even for the commercial vendors. The standards aren't always so standard, though maybe Real ID helps with that. I haven't looked into it. |
| 11:36 |
JBoyer |
And ddale, My old library used to capture signatures and store them locally, but that was in a custom application that had no connection to Evergreen. (The DL scanning also sounds very helpful, but I don't know anything about it.) |
| 11:37 |
ddale |
Dyrcona and JBoyer: I am not a programmer so can you tell me where to look for the field that would store a photo? I need to point my system admin in the right direction. |
| 11:38 |
ddale |
Dyrcona and Boyer: Bayscan says they have a working licenses scanner for Evergreen. I am going to investigate that further. |
| 11:39 |
_bott_ |
ddale: Yes, we've been storing signatures since 2013. We use Topaz pads, and store the encoded signature in the old photo_url column. It's all a one-off, where to capture/store the signature it's in a separate Web browser tab. |
| 11:40 |
ddale |
_bott_: Thanks!! |
| 11:41 |
JBoyer |
actor.photo_url holds the url that points to the user photo. Where to put it and how to set that field are all up to the implementor. |
| 11:41 |
ddale |
JBoyer: Thanks! |
| 11:42 |
_bott_ |
Back, around version 1.2 the photo showed up in the patron summary! |
| 11:42 |
ddale |
I wonder why it was removed? |
| 11:43 |
JBoyer |
I just looked and it is displayed in the patron summary in the web client, it's just that there's not really any way to set it. |
| 11:43 |
_bott_ |
Even then, there was no interface to populate photo_url, so it had to be a manual entry to point to the image to display. There was just enough XUL to display the image if it existed. |
| 11:46 |
csharp |
gsams: I have a couple of perm-related scripts you might find helpful: https://gist.github.com/chrissharp123/e6707009e5e043b055cbb0ff152a2f89 |
| 11:46 |
csharp |
not exactly what you asked for, but maybe close |
| 11:47 |
gsams |
csharp++ |
| 11:48 |
gsams |
I think that'll come in handy as I move forward I believe |
| 11:48 |
Dyrcona |
Might be a neat enhancement to drop the photo into an object and store the oid in the actor.usr table. |
| 11:48 |
Dyrcona |
Pg is an object-relational database after all. |
| 11:48 |
csharp |
(assumed to be run on a server with .pgpass implemented) |
| 11:49 |
csharp |
Dyrcona: yeah, that sounds familiar... maybe jeff was looking into that at one time a few years ago? |
| 11:49 |
|
jihpringle joined #evergreen |
| 11:49 |
Dyrcona |
gsams: We have 270 unused permissions on our 3.0 database. |
| 11:50 |
gsams |
Dyrcona: I'm looking at 295, I know we won't use all of them necessarily, but we are definitely missing a few important permissions. |
| 11:50 |
Dyrcona |
csharp: After saying that in channel, my next thought was and how much disc space will 1.5 million photos take up in the db? |
| 11:54 |
csharp |
Dyrcona: ha! |
| 11:57 |
JBoyer |
Please submit a picture no larger than 320 x 200 in 16 colors, under 8k in size. |
| 11:58 |
csharp |
re: unused perms - I wonder how many are not actually implemented in the business logic (at all/anymore) |
| 11:58 |
csharp |
we have 269 |
| 12:03 |
|
terran joined #evergreen |
| 12:30 |
csharp |
btw, working repo watchers may have noticed this, but I'm working on reviving my Evergreen on CentOS(/RHEL/Fedora) branches |
| 12:31 |
csharp |
I got OpenSRF up and running, but have run into some vexxing issues with httpd not recognizing /openils/lib as a valid library location |
| 12:31 |
bshum |
csharp: Yeah I got snagged on the apache/httpd stuff too |
| 12:31 |
csharp |
I believe it's a systemd-related problem |
| 12:32 |
csharp |
anyway, I can make those into collab branches if others are interested |
| 12:32 |
|
khuckins joined #evergreen |
| 12:32 |
csharp |
this is not for anything production-related - just wanted to expand us beyond the Debian/Ubuntu universe and think it's interesting/fun |
| 12:36 |
bshum |
Fun is good. I wonder if we should create a separate README for Fedora so that we don't confuse any folks out there that there's any expectation to be able to use Evergreen for real with Fedora, etc. |
| 12:37 |
bshum |
With a lot of disclaimers in it |
| 12:37 |
csharp |
yeah, I was thinking about the README and how cluttered it is with all the different releases as it is |
| 12:38 |
csharp |
wondering if building the README(s) from includes rather than one giant asciidoc file would be better, but that's another project :-) |
| 12:38 |
bshum |
Yeah but I think we keep it cluttered together because then we can ask people which step of the README they're on, rather than which copy of the README For their distro like we used to do with the wiki |
| 12:38 |
bshum |
But people's opinions change :) |
| 12:38 |
Dyrcona |
csharp: I saw your branch. Didn't know what issues you might encounter. |
| 12:39 |
bshum |
And I don't support Evergreen full time anymore, so have at thee! |
| 12:39 |
csharp |
yeah, I wouldn't want to go back to the wiki-ish days |
| 12:39 |
csharp |
heh |
| 12:39 |
Dyrcona |
So, you had a problem with apache linking to /openils/lib that had nothing to do with ldconfig? |
| 12:40 |
csharp |
the main issue with OpenSRF was lack of ejabberd in CentOS/EPEL repos, but the EJabberD project provides RPMs |
| 12:41 |
csharp |
Dyrcona: yeah, it's like httpd ignores the links created by ldconfig and I'm having trouble setting LD_LIBRARY_PATH in such a way that httpd (as started by systemd) can see it |
| 12:41 |
Dyrcona |
Yeah, there's probably a way to set it through systemd. If not, another reason to ditch systemd. :) |
| 12:42 |
csharp |
this is what the logs look like with LD_DEBUG=libs added to the httpd sysconfig file: https://pastebin.com/eYkvLHdp |
| 12:42 |
* csharp |
has learned lots about how RedHat does Apache |
| 12:42 |
csharp |
I've been running Fedora desktop for years, but haven't really done much with server-side stuff |
| 12:45 |
Dyrcona |
I'll bet that apache wants the libs owned by root. It's finding them it just won't open them. |
| 12:45 |
Dyrcona |
That should be the dynamic loader though, not necessarily apahce. |
| 12:45 |
csharp |
that occurred to me, but I'm just not able to discover *where* httpd is getting its instructions for where to look |
| 12:46 |
csharp |
if I run the httpd binary as root, it runs fine |
| 12:46 |
csharp |
so it appears to be the environment, one way or another |
| 12:46 |
Dyrcona |
It's pulling it from /usr/lib64/httpd/modules/osrf_json_gateway.so. The so files has a list of the libraries that it needs. |
| 12:47 |
csharp |
yeah, if I do "ldd" on the .so files, it shows them all fine, none missing |
| 12:47 |
Dyrcona |
Well, who knows* what systemd does.... *Some people know, but not I. |
| 12:48 |
JBoyer |
Some kind of apparmor thing? |
| 12:48 |
Dyrcona |
So, maybe its time to dust off the FreeBSD branch? Stuff just works there. |
| 12:48 |
JBoyer |
(A good reason to say "thou shalt apache as root" ?) |
| 12:49 |
csharp |
JBoyer: it would be selinux in this case, but yes, that occurred to me too |
| 12:50 |
Dyrcona |
selinux would usually tell you if it's the reason...i.e. you'd get something in the logs somewhere that selinux prevented an untrusted library from loading or some such, and it would likely fail as root, too. |
| 12:51 |
Dyrcona |
That said, I haven't touched selinux seriously in about a decade. |
| 12:53 |
* Dyrcona |
wonders what "fun" there will be when Ubuntu 22.04 comes out. |
| 12:53 |
Dyrcona |
Well, I guess 20.04, really. |
| 12:53 |
JBoyer |
If 18.04 gets that 10 year support that was claimed at least we'll have some extra time to figure it out. |
| 12:54 |
Dyrcona |
heh. Guess what song started playing as I typed that? "Tomorrow is a Long Time" by Bob Dylan. :) |
| 12:54 |
JBoyer |
Dyrcona has all the best soundtracks. |
| 12:55 |
Dyrcona |
So, yeah, JBoyer, tomorrow is a long time when you have a 10-year support window. |
| 12:55 |
Dyrcona |
I was thinking (briefly) if that new support window would cause us any issues with releases and supporting multiple releases of Ubuntu. |
| 12:56 |
Dyrcona |
I really don't know. |
| 12:56 |
Dyrcona |
Ugh... typing Ctrl-c in the wrong window.... |
| 12:57 |
JBoyer |
Could be an issue if we don't do a good job of trying to keep up until too close to 2028. |
| 12:57 |
Dyrcona |
Yeah, that and will we have 4 releases of Ubuntu supported at the same time? |
| 12:58 |
JBoyer |
Other OS support should help with that though. Another good reason for csharp's interest in CentOS. |
| 12:58 |
Dyrcona |
True, and I'm only half-kidding about supporting FreeBSD. That would really help us clean up our autoconf mess. |
| 12:59 |
JBoyer |
Probably not 4, unless they start supporting every LTS for a decade. (I haven't paid that much attention) |
| 12:59 |
JBoyer |
++ |
| 13:00 |
Dyrcona |
Yeah, they said 18.04 and possibly 16.04, too. |
| 13:00 |
Dyrcona |
Maybe they'll do every other LTS for 10 years? |
| 13:00 |
|
rsulejmani joined #evergreen |
| 13:00 |
JBoyer |
That sounds miserable to manage for both sides. |
| 13:01 |
rsulejmani |
Hi everyone, I was wondering how would I setup evergreen on 1 server running both apache and evergreen at the same time |
| 13:01 |
JBoyer |
rsulejmani, you can install all of the necessary software on a single server and run everything on one machine or VM. |
| 13:02 |
rsulejmani |
Ok but how would I go with doing that |
| 13:03 |
Dyrcona |
rsulejmani: Follow the instructions in the READMEs. |
| 13:03 |
Dyrcona |
That's what I do. |
| 13:03 |
rsulejmani |
Dyrcona: The READMEs are located in the git repo correct? |
| 13:04 |
Dyrcona |
Yeah, or where you've extracted the tarball if you downloaded that, and they're on the web for the current releases. |
| 13:04 |
Dyrcona |
In the Evergreen README, you might want to jump ahead to the section on setting up PostgreSQL and do that before most of the rest. |
| 13:06 |
Dyrcona |
At least installing the prerequisites and adding the evergreen user. |
| 13:06 |
csharp |
if I can get the CentOS/RHEL 7 branches up to speed, maintaining shouldn't be too much of a burden, I don't think |
| 13:07 |
csharp |
nobody's going to run Fedora in production, so that's less important |
| 13:08 |
Dyrcona |
Well, nobody *should* run Fedora in production... |
| 13:08 |
csharp |
yeah :-) |
| 13:10 |
csharp |
from what I can tell, the type of orgs that are going to be running RHEL are not comfortable with Linux in the first place |
| 13:10 |
csharp |
at least in the library world |
| 13:10 |
Dyrcona |
Probably not. |
| 13:10 |
JBoyer |
Keep it at arms length and pay someone $yowzers a month for support so they don't have to touch it. |
| 13:10 |
JBoyer |
At least that's how it feels here... |
| 13:12 |
Dyrcona |
I think it was competition with RHEL that caused Canonical to go with a 10-year support cycle for 18.04. I seem to recall reading something about "financial institutions." |
| 13:13 |
JBoyer |
The story broke when IBM bought RH, right? I'm fairly certain that was the specific cause of the 10 year commitment. (and MS to a lesser degree, since that's been their thing for ages) |
| 13:14 |
csharp |
I don't remember the exact timeline, but yeah, sounds like a reasonable rationale |
| 13:14 |
Dyrcona |
Yeah. |
| 13:14 |
Dyrcona |
I certainly hope that RH does not end up like some other IBM acquisitions. |
| 13:15 |
csharp |
yep - that's the big concern as far as I know |
| 13:15 |
csharp |
I enjoyed visiting RedHat corporate in Raleigh - looked like a cool work environment |
| 13:16 |
|
ddale joined #evergreen |
| 14:06 |
jeff |
It seemed that <script src="https://cdnjs.cloudflare.com/ajax/libs/highlight.js/9.13.1/highlight.min.js"></script> |
| 14:06 |
jeff |
*sigh* |
| 14:07 |
jeff |
It seemed that rsulejmani may have been asking something else, but since they're no longer here... |
| 14:09 |
Bmagic |
yeah it looked like he/she was asking how to run Apache with an existing config along side Evergreen |
| 14:12 |
Dyrcona |
Did it? I didn't get that. |
| 14:14 |
Dyrcona |
I suppose that is likely what was being asked, but it isn't clear. |
| 14:15 |
Bmagic |
agreed |
| 15:39 |
|
khuckins joined #evergreen |
| 17:18 |
|
jvwoolf left #evergreen |
| 17:20 |
|
mmorgan left #evergreen |
| 17:35 |
Bmagic |
Is there a bug for webby checkout receipts including non-cats ? |
| 17:39 |
jihpringle |
Bmagic: is the issue that they're being included or not being included? |
| 17:39 |
Bmagic |
not being included |
| 17:39 |
Bmagic |
:) |
| 17:40 |
jihpringle |
I think there's a fix for that |
| 17:40 |
Bmagic |
oh sweet |
| 17:40 |
Bmagic |
it's template syntax I take it? |
| 17:40 |
jihpringle |
https://bugs.launchpad.net/evergreen/+bug/1747512 |
| 17:40 |
pinesol |
Launchpad bug 1747512 in Evergreen 3.0 "Web Client: Non -Cataloged Circulations checkouts are not displaying a title" [Medium,Fix released] |
| 17:41 |
jihpringle |
the fix deals with the non-cats not displaying properly in the Non-Cat tab in Items Out as well as on the receipt |
| 17:43 |
Bmagic |
jihpringle++ |
| 17:43 |
jihpringle |
:) |
| 17:44 |
Bmagic |
Another question: Has anyone noticed that patrons can get passed the library hold limit by suspending the previous set of holds and placing more holds, then activating them all |
| 17:45 |
jihpringle |
that's not something we've noticed, but an interesting way to get around the limits |
| 17:46 |
Bmagic |
yeah! |
| 17:46 |
Bmagic |
clever |
| 17:47 |
Bmagic |
I was looking around in the code to see if I could see where it was performing the limit test... action.find_hold_matrix_matchpoint doesn't seem to have it |
| 17:48 |
Bmagic |
found it: action.hold_request_permit_test |
| 17:49 |
Bmagic |
looks like there is a YAOUS! |
| 17:49 |
Bmagic |
hold_test.include_frozen_holds |
| 17:50 |
Bmagic |
oh, no, it's a setting from the hold_matrix_matchpoint |
| 17:52 |
Bmagic |
ha! Plain as day right there in the hold policy |
