| Time |
Nick |
Message |
| 03:00 |
|
Rogan joined #evergreen |
| 07:06 |
|
collum joined #evergreen |
| 08:04 |
|
BDorsey joined #evergreen |
| 08:21 |
|
Dyrcona joined #evergreen |
| 08:27 |
|
mmorgan joined #evergreen |
| 08:52 |
|
redavis joined #evergreen |
| 08:54 |
|
kmlussier joined #evergreen |
| 08:55 |
|
sandbergja joined #evergreen |
| 08:55 |
kmlussier |
Good morning #evergreen! |
| 08:55 |
kmlussier |
@coffee [someone] |
| 08:55 |
* pinesol |
brews and pours a cup of Kenya Thiriku Top Auction Lot, and sends it sliding down the bar to eglogbot |
| 08:55 |
kmlussier |
@tea [someone] |
| 08:55 |
* pinesol |
brews and pours a pot of Chamomile Lemon (Sweet Meadows), and sends it sliding down the bar to BDorsey (http://ratetea.com/tea/numi/chamomile-lemon/504/) |
| 09:07 |
|
dguarrac joined #evergreen |
| 09:22 |
|
Dyrcona joined #evergreen |
| 09:39 |
Dyrcona |
due_date: "3812-01-17 23:59:59-05" Sure, that's plausible. |
| 09:40 |
mmorgan |
:) |
| 09:41 |
Dyrcona |
And, it looks like a test or someone was messing with due dates. It was checked in in 2018. |
| 09:41 |
mmorgan |
Or a barcode got scanned into the due date field? |
| 09:42 |
Dyrcona |
mmorgan: That might be a possibility. 38120 looks like a valid item barcode prefix for Massachusetts. |
| 09:43 |
Dyrcona |
I think I need to do something more sophisticated than just select max(due_date) from action.circulation; :) |
| 09:43 |
Bmagic |
jeffdavis: are you working on SSO for Evergreen staff client? |
| 09:44 |
Dyrcona |
I'm looking for things I can renew in my test database with a script to try out the osrf-gateway-v1. |
| 09:44 |
Dyrcona |
I can wait until next week. The data should be refreshed on Sunday. |
| 09:51 |
Dyrcona |
Think I'll give it a shot anyway. |
| 10:03 |
Dyrcona |
Hm. Left joins with a where clause on "right_table.columns is null" seem to be a lot faster in Pg 15 than in Pg 10. |
| 10:05 |
Dyrcona |
And it makes no difference to my query results, so that's good. I guess I can remove it. |
| 10:23 |
csharp_ |
sounds like we need to do a little date math here and there to make sure we're not getting circ periods beyond imagining |
| 10:24 |
berick |
https://i.imgur.com/myUDFCt.gif |
| 10:27 |
csharp_ |
berick++ |
| 10:27 |
csharp_ |
gifs you can hear if you're of an age |
| 10:28 |
* csharp_ |
turns 50 next month - saw Star Wars in the theater during an early run |
| 10:30 |
Dyrcona |
I saw it 7 times in a theater back in 1977. |
| 10:30 |
Dyrcona |
berick++ csharp_++ |
| 10:36 |
Dyrcona |
Are the login/auth types for open-ils.auth documented somewhere? I'm pretty sure there is "staff" and "opac," but I wanted to know if there are more and don't feel like spelunking right now. |
| 10:40 |
JBoyer |
berick++ |
| 10:40 |
JBoyer |
Dyrcona, there's at least temp (or temporary) that's sometimes used by the switch user function |
| 10:56 |
jeff |
opac, staff, temp, and persist. |
| 11:00 |
|
briank joined #evergreen |
| 11:07 |
csharp_ |
oh my! |
| 11:08 |
eeevil |
ugh ... SFTP != FTPS. but RemoteAccount sure thinks so, and can't actually handle either because of that :( |
| 11:09 |
csharp_ |
eeevil: yes |
| 11:10 |
csharp_ |
eeevil: my WIP branch: https://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/csharp/reimplement_sftp_for_acq_edi |
| 11:11 |
csharp_ |
I'll rebase/fixup that branch - I don't think we have a bug yet? |
| 11:12 |
eeevil |
unfortunately, it also throws away the scheme when mis-detecting the desired protocol if it's ftps (looking at YOU silently changing your servers, Brodart) |
| 11:13 |
csharp_ |
rebased and force pushed |
| 11:13 |
eeevil |
csharp_: at a glance, the patch removes the libnet-ssh2 installation, but ... is that force because of libnet-sftp-foreign? if so, we might want a note of that |
| 11:14 |
csharp_ |
eeevil: yeah, I didn't consider FTPS in my branch |
| 11:14 |
csharp_ |
eeevil: yeah, that's a mistake - shouldn't have removed libnet-ssh-perl |
| 11:14 |
eeevil |
well, yes, but just on the SFTP addition, it removes (it looks like) SSH support |
| 11:14 |
csharp_ |
sorry libnet-ssh2-perl |
| 11:15 |
csharp_ |
I removed it in the makefiles but still call it in the perl - that would have been caught in the fleetingist of testing |
| 11:15 |
eeevil |
right, it might still get installed as a dep, which would be fine |
| 11:15 |
csharp_ |
yeah |
| 11:16 |
eeevil |
but, it looks like pure ssh2 support gets broken |
| 11:17 |
csharp_ |
I haven't eyed that since the hackaway so I'll need to reaquaint myself |
| 11:17 |
eeevil |
if you look at the changes in 'sub delete' of RemoteAccount, the 'if' is for FTP, but then there's an 'elsif' with no condition at all that assumes sftp |
| 11:17 |
csharp_ |
reverse engineering atz's stuff was fun |
| 11:17 |
eeevil |
heh... "fun, he says" |
| 11:20 |
Dyrcona |
Net::STFP::Foreign does not use libnet-ssh-perl unles you tell it to. That's actually the point of Net::SFTP::Foreign. It defaults to using the sftp client on the host. |
| 11:21 |
* Dyrcona |
uses Net::SFTP::Foreign in several utility scripts. |
| 11:22 |
Dyrcona |
berick++ jeff++ Thanks for the answers. I thought I was missing a couple. |
| 11:23 |
Dyrcona |
I have another question, but I'll check the code, too. I think it's possible to login with user id and not barcode or username, right? I'm working on a program to test OPAC renewals through osrf-gateway-v1, in case anyone missed it. |
| 11:23 |
csharp_ |
eeevil: are you looking at the latest I pushed? I see the sub delete with } elsif ($self->type eq "SFTP") { |
| 11:23 |
csharp_ |
or maybe I'm misunderstanding... |
| 11:24 |
Dyrcona |
FTPS.... Ugh. Someone actually uses that? |
| 11:24 |
eeevil |
csharp_: I'm looking at https://git.evergreen-ils.org/?p=working/Evergreen.git;a=commitdiff;h=b6afdf927639e6a614a3ccd9c249f100729f9cdc#patch5 just before "Internal Mechanics" |
| 11:24 |
csharp_ |
Dyrcona: I've encountered that in the wild when we were pushing to school servers for the student card stuff |
| 11:24 |
Dyrcona |
I've not had the pleasure, yet. :) |
| 11:25 |
Dyrcona |
Oh, right! I have a meeting. |
| 11:25 |
csharp_ |
eeevil: https://git.evergreen-ils.org/?p=working/Evergreen.git;a=blobdiff;f=Open-ILS/src/perlmods/lib/OpenILS/Utils/RemoteAccount.pm;h=19f8c45278ac7fcc7524c7df5fdb217a7e63d66d;hp=b4a8f1ecf1bcc74e3e4b29b870f8cfae5982fcec;hb=323e77fd1a1b6b1281198a955260255d167c39a8;hpb=d7d32af55cc9edaef390a0eba3407664f59ee38f |
| 11:25 |
Dyrcona |
calendar-reminder++ |
| 11:27 |
eeevil |
csharp_: oh ho! that's different. and unless where I went (first link at 11:10) is just stale code, a little scary that git maybe got confused |
| 11:28 |
eeevil |
Dyrcona: it is alleged, but not yet confirmed, that brodart started requiring ftps to secure ftp upload some time in October. this is a game of telephone right now, though. |
| 11:28 |
csharp_ |
it's stale, yes |
| 11:29 |
* eeevil |
feeds stale code to the rubber ducks |
| 11:29 |
csharp_ |
should've rebased before @-ing you, but I got excited that someone else cares about acq SFTP! |
| 11:29 |
csharp_ |
@who got out ahead of their skis? |
| 11:29 |
pinesol |
phasefx got out ahead of their skis. |
| 11:30 |
eeevil |
no worries! glad to see movement |
| 11:30 |
Dyrcona |
csharp_: I also care, but haven't had the time to look at your branch. |
| 11:30 |
csharp_ |
@quote add eeevil feeds stale code to the rubber ducks |
| 11:30 |
pinesol |
csharp_: The operation succeeded. Quote #239 added. |
| 11:31 |
eeevil |
csharp_: is your branch intended for brodart, by chance? (if you can name the vendor, obv) |
| 11:31 |
Dyrcona |
eeevil: OK. I'm not sure if we have anyone using Brodart. At least, I've not heard of any complaints from libraries so far. |
| 11:31 |
Dyrcona |
OK. Meeting starting.... |
| 11:31 |
csharp_ |
eeevil: Ingram ( https://view.info.ingramcontent.com/?qs=a340f2f20236791c6a884a0ada2e7b923abc501fa88277f182b27e6ddc0dffeafa6b5a44f1b874b5d4dd1ddf539153111c512fb0cd75086a031b6b3d2fd9af2bfe73fad86b33978fc13f8a38850a3814350dbf8821502940 ) |
| 11:32 |
csharp_ |
but we'll need Brodart too, probably |
| 11:32 |
csharp_ |
eeevil: so Brodart just up and changed without announcing anything? |
| 11:33 |
csharp_ |
(we don't usually get the notices firsthand, to be fair) |
| 11:33 |
eeevil |
AFAICT ATM, yes |
| 11:34 |
csharp_ |
jeez, y'all |
| 11:34 |
csharp_ |
don't you know libraries are still excited about Web 2.0? |
| 11:34 |
eeevil |
"upload your EDI messages to the blockchain and..." |
| 11:35 |
csharp_ |
eeevil++ |
| 11:37 |
csharp_ |
eeevil: with my code in place, tlittle and I were able to push files to a PINES-owned SFTP server - that's all the testing we've done |
| 11:38 |
csharp_ |
tlittle has asked Ingram for a test account to push prod files to but that request appears to have flummoxed them |
| 11:39 |
eeevil |
csharp_++ |
| 11:39 |
eeevil |
tlittle++ |
| 11:44 |
eeevil |
it certainly looks like it will work. though, to retain SSH/SCP support, the DESTROY sub should simply add an sftp->disconnect in addition to the ssh2->disconnect. other than that, maybe the need to implement delete_sftp, I don't see any obvious problems |
| 11:46 |
|
terranm joined #evergreen |
| 11:51 |
|
tlittle joined #evergreen |
| 11:52 |
csharp_ |
eeevil: nice |
| 11:52 |
jmurray_isl |
Has anyone had issues with a TT2 OPAC Circ History export timing out or otherwise not able to generate? When replicating the issue, we find the following in our logs: https://pastebin.com/W8GtCZsX |
| 11:53 |
jmurray_isl |
(There's about 470+ additional open-ils.cstore sent XXX bytes of data before the logs in the pastebin.) |
| 11:54 |
eeevil |
csharp_: and to be clear, I do not know (looking through the microscope as I am) whether delete_$scheme is ever used |
| 11:55 |
csharp_ |
eeevil: I feel pretty sure FTP delete is never used, but I may be wrong, eh tlittle ? |
| 11:55 |
csharp_ |
jmurray_isl: yes, we see that often |
| 11:56 |
csharp_ |
jmurray_isl: we created a report to generate the list to give to the patron, then we clear the bib bucket so they can start using it again |
| 11:56 |
jmurray_isl |
csharp_: Is there a mitigation to allow these to export properly? |
| 11:56 |
tlittle |
Not as far as I know--we don't programmatically delete anything on their side. I *manually* do, if they don't do their own cleanup *shrug* |
| 11:56 |
csharp_ |
jmurray_isl: I don't know what the Right™ solution is, but that's what we do to work around it |
| 11:56 |
jmurray_isl |
csharp_++ |
| 11:57 |
jeffdavis |
Bmagic: no, just getting SSO working for us in the OPAC |
| 11:57 |
csharp_ |
eeevil: also, tlittle tells me that Brodart appears to be working normally on our end (no evidence of sneaky SFTP) |
| 11:58 |
csharp_ |
maybe multiple URLs in play? |
| 11:58 |
tlittle |
Last successful order was pushed last night at 6:15PM and we picked up an invoice from them this morning at 7am |
| 11:59 |
eeevil |
jmurray_isl: the general problem there is that the export is being build in a very inefficient way. we probably need to force a limit and "page" the history download. think: like asking your bank for "old" statements |
| 12:00 |
Bmagic |
jeffdavis++ # thanks. There's some chatter and grumbles about bug 2043040 |
| 12:00 |
pinesol |
Launchpad bug 2043040 in Evergreen "wishlist: Single Sign on for Evergreen Staff Client" [Wishlist,Confirmed] https://launchpad.net/bugs/2043040 |
| 12:00 |
jmurray_isl |
eeevil: Agreed. I was just surprised (or maybe I shouldn't be) that one already wasn't in place. |
| 12:01 |
eeevil |
tlittle via csharp_: that's a good data point, thanks! the hostname we're concerned with right now is just ftp.brodart.com, fwiw. there could be migration in "waves" based on the user or (ftp) account |
| 12:02 |
eeevil |
jmurray_isl: nobody uses the library THAT much, right? RIGHT? ;) |
| 12:03 |
|
jihpringle joined #evergreen |
| 12:03 |
tlittle |
eeevil That's what we're connected to as well, so who knows. I checked three different libraries' accounts and all are still good so far this morning, so fingers crossed |
| 12:05 |
Dyrcona |
jmurray_isl: I'm in another meeting, but I think moving the history download away from action trigger will be a big help. |
| 12:05 |
eeevil |
tlittle: thanks! my fingers are crossed for you all as well :) |
| 12:06 |
jmurray_isl |
Dyrcona++ |
| 12:51 |
|
collum joined #evergreen |
| 13:00 |
JBoyer |
eeevil, csharp_, I did push a followup branch to the initial LP that addressed a few things, you'll want to check it out if that's not where you started. |
| 13:05 |
Dyrcona |
jmurray_isl: I'm finally out of my other meeting. circ history has always been a problem, and believe it or not, it used to be worse. I'd like to reimplement it to bypass action trigger and generate the csv directly, but there are not enough of me. |
| 13:07 |
jmurray_isl |
Dyrcona: I understand that all too well. |
| 13:09 |
|
collum joined #evergreen |
| 13:11 |
Dyrcona |
Other than what's already been mentioned, I don't have any solutions. |
| 13:17 |
|
jvwoolf joined #evergreen |
| 13:28 |
|
collum joined #evergreen |
| 13:37 |
csharp_ |
JBoyer: eeevil: ah, I forgot I had opened the bug https://bugs.launchpad.net/evergreen/+bug/2040514 |
| 13:37 |
pinesol |
Launchpad bug 2040514 in Evergreen "EDI SFTP doesn't work" [High,Confirmed] - Assigned to Chris Sharp (chrissharp123) |
| 13:38 |
csharp_ |
thanks, JBoyer for fixing that stuff - I had fixed it on my dev machine but it didn't make it into my finished branch |
| 13:38 |
csharp_ |
I can push a branch adding my signoff |
| 13:40 |
JBoyer |
csharp_++ |
| 13:42 |
csharp_ |
JBoyer: eeevil: updated the bug with a link to my signoff branch - initial commit just has my signoff |
| 13:45 |
|
jvwoolf joined #evergreen |
| 13:47 |
|
collum joined #evergreen |
| 13:51 |
sleary |
UI interest group in 10 minutes: https://wiki.evergreen-ils.org/doku.php?id=community:ui_ig |
| 13:51 |
sleary |
(Zoom room's open if you want to chitchat) |
| 13:51 |
|
collum joined #evergreen |
| 13:59 |
Dyrcona |
i'm trying to login with osrf-gateway-v1 using LWP::UserAgent, and I keep getting a "Service not found" error. I am basically doing this: my $url = BASE_URL . '?service=open-ils.auth&method=open-ils.auth.login'; |
| 13:59 |
Dyrcona |
$url .= '¶m=' . uri_escape(encode_json($credentials)); |
| 14:06 |
Dyrcona |
Ok. If I change the base URL to a VM with 3.7 installed, I get a LOGIN_FAILED because I didn't change the user's password in that database. |
| 14:06 |
Dyrcona |
The VM where I get service not found is running 3.10 with RedisRF. |
| 14:07 |
Dyrcona |
Using my credentials on 3.7 it works. it fails on 3.10. (I also removed the uri_escape because I think LWP is doing that for me. |
| 14:08 |
Dyrcona |
Lemme see if I can "logout" manually.... :) |
| 14:11 |
Dyrcona |
Hey! That worked, too: https://egtest.cwmars.org/osrf-gateway-v1?service=open-ils.auth&method=open-ils.auth.session.delete&param=292625d03b105efaf686d1da92b00a11 |
| 14:12 |
Dyrcona |
I guess I should figure out why it doesn't work on 3.10 with Redis sooner or later. |
| 14:21 |
Dyrcona |
And, it looks like you cannot authenticate with user id. It has to be username or barcode. |
| 14:36 |
|
Stompro joined #evergreen |
| 14:37 |
Dyrcona |
Of course, the data in the 3.7 database has to be different because I guess the 3.10 database had autorenewals run on it. |
| 14:42 |
Dyrcona |
berick: Have you tried osf-gateway-v1 on a machine with Redis before? |
| 14:42 |
berick |
Dyrcona: workin OK here. |
| 14:42 |
berick |
tried /osrf-gateway-v1?service=open-ils.auth&method=open-ils.auth.login¶m={"username":"admin","password":"demo123"} |
| 14:42 |
berick |
well, that cut off, but you get the idea |
| 14:43 |
Dyrcona |
I'm getting Service not found. I wonder if I missed something in the configration? it looks OK, though. |
| 14:44 |
|
jvwoolf left #evergreen |
| 14:45 |
Dyrcona |
I don't have the latest redis commits installed, so I'll update OpenSRF and try again. |
| 14:51 |
Dyrcona |
Yeah, I'm still getting service not found. :( |
| 14:53 |
berick |
running opensrf branch collab/berick/lp2017941-opensrf-on-redis-v3 ? |
| 14:54 |
berick |
other public services working? /osrf-gateway-v1?service=open-ils.actor&method=opensrf.system.echo¶m="hello" |
| 14:54 |
Dyrcona |
collab/berick/lp2017941-opensrf-on-redis-v3 |
| 14:55 |
Dyrcona |
Yeah. I'll try some other things through a browser. |
| 14:57 |
Dyrcona |
Everything says service not found. I'll check the logs. |
| 15:00 |
|
jihpringle joined #evergreen |
| 15:00 |
berick |
the latest commit(s) require full osrf/eg C code rebuilds, in case that's not obvious. |
| 15:01 |
Dyrcona |
Yeah, I did a make clean && make install. I did get this in the router log: /osrf-gateway-v1?service=open-ils.actor&method=opensrf.system.echo¶m="hello" |
| 15:01 |
Dyrcona |
OOps. wrong past. |
| 15:02 |
Dyrcona |
router 2023-11-30 15:00:48 [ERR :22271:osrf_router.c:276:] Service open-ils.auth is not registered on this router domain=public.localhost |
| 15:03 |
Dyrcona |
I'll do the make again. Then I'll look at opensrf configs again. |
| 15:06 |
Dyrcona |
Ok. I have an out of date opensrf_core.xml is the problem. I'll merge the two and see what happens. |
| 15:09 |
Dyrcona |
grr... emerge doesn't work over tramp. I always forget that.... |
| 15:10 |
Dyrcona |
permission denied.... wt... |
| 15:15 |
Dyrcona |
berick++ |
| 15:16 |
Dyrcona |
so, I had just the OpenSRF opensrf_core.xml installed. When I swapped in the one from Evergreen, it worked. |
| 15:16 |
berick |
cool |
| 15:16 |
Dyrcona |
This might explain a problem that I had a couple of weeks ago, but I've been too busy to remember everything.... |
| 15:18 |
Dyrcona |
I should have looked more carefully. |
| 15:30 |
Dyrcona |
MAX_RENEWALS_REACHED: I'm actually getting somewhere. |
| 15:36 |
Dyrcona |
Ok. Now, I have to find ones that have renewals remaining. This might have to wait until next week after all. |
| 15:44 |
Dyrcona |
All right. OPAC renewal works if I login as the patron. I wonder if it works logged as someone else, like me for instance. |
| 15:44 |
Dyrcona |
I think it should. |
| 15:45 |
Dyrcona |
And, it does. |
| 16:48 |
|
sandbergja joined #evergreen |
| 17:13 |
|
mmorgan left #evergreen |
| 18:14 |
|
kmlussier left #evergreen |
