Evergreen ILS Website

IRC log for #evergreen, 2019-09-19

| 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:18 book` joined #evergreen
07:08 rjackson_isl joined #evergreen
07:17 bos20k joined #evergreen
07:23 Dyrcona joined #evergreen
08:19 tlittle joined #evergreen
08:30 abowling joined #evergreen
08:45 mmorgan joined #evergreen
09:08 csharp jeffdavis: correct - we have disabled it because it was causing trouble
09:12 csharp does anyone know the "proper" way to enter an all-inclusive call number range in a "Between" filter in reports?  I have a library using  between '000' and 'zzz' and that's excluding some that would seem to be in that range.
09:13 sandbergja joined #evergreen
09:13 csharp of course, dropping the call number filter is another option, but this is a commonly-used template and I'd like to avoid changing it
09:14 csharp also, in my exploration of "between" in postgres, I came across "BETWEEN SYMMETRIC" which sounds like something we should just use by default, at least based on the PG docs description
09:14 csharp BETWEEN SYMMETRIC is the same as BETWEEN except there is no requirement that the argument to the left of AND be less than or equal to the argument on the right. If it is not, those two arguments are automatically swapped, so that a nonempty range is always implied.
09:15 csharp that would rid us of all the "I got no results" tickets that are because they entered the range in the wrong order
09:16 miker csharp: could the "missing" call numbers have a space within the first 3 chars?
09:18 mmorgan csharp: Also, is your filter using the label_sortkey?
09:19 yboston joined #evergreen
09:22 csharp miker: argh - leading space - invisible until I used this magic spell to reveal whitespace: https://stackoverflow.com/a/39493902/1692794
09:23 miker doh
09:26 csharp another use case for trimming filter values (which we've discussed before but I haven't followed up on dev-wise)
09:33 Dyrcona csharp: I often do '|' + field + '|' to find trailing or leading spaces, but that regex replace will work, too.
09:34 Dyrcona Hm... replace + with ||. :)
09:37 csharp Dyrcona: way less trouble - thanks!
09:37 Dyrcona X is a good one to use, too. Anything that's obvious, really.
09:38 Dyrcona I think that '+' was some Sybase muscle memory... :)
09:38 csharp :-)
09:55 cmalm joined #evergreen
10:03 yboston joined #evergreen
10:04 bos20k joined #evergreen
10:33 Christineb joined #evergreen
10:33 khaun joined #evergreen
10:57 sandbergja joined #evergreen
11:02 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
11:11 jvwoolf joined #evergreen
11:11 * dbs wonders if setting a circulation policy to a "0 day" loan will result in the due date being the end of today...
11:11 * dbs will try it out
11:12 mmorgan dbs: We have a rule like that, it does work, or did last time I checked :)
11:12 csharp seeing a pile-up of database backends - many (606) are idle and have a query of 'SELECT auditor.clear_audit_info();'
11:13 csharp and have been in that state for hours
11:13 csharp anyone seen that? or have an idea about where to look next?
11:13 mmorgan csharp: We see that as well, ever since moving to 3.1 (I think)
11:14 mmorgan Havan
11:14 khaun joined #evergreen
11:14 csharp I can resolve it by restarting opensrf everywhere, but that seems excessive and not great practice
11:14 mmorgan er, haven't dug into it.
11:14 csharp mmorgan: thanks for the confirmation
11:16 csharp pg_cancel_backend doesn't appear to be effective in killing these
11:19 csharp to prevent EG from falling over, I'm running a rolling restart of opensrf
11:22 Dyrcona csharp: I have 507 on 3.2, but I've never counted them before. I just figure they're idle connections and will be reused when the connected drone has something to do.
11:24 Dyrcona My count also varies by plus or minus 5 depending on how many times I look.
11:26 cowens joined #evergreen
11:27 Dyrcona I also have a total of 527 postgres processes including the postmaster, wal sender process, etc.
11:27 Dyrcona And that number varies from time to time as well.
11:27 cowens left #evergreen
11:28 Dyrcona Thursday is also NOT a particularly busy day for us.
11:32 cowens joined #evergreen
11:36 csharp a significant number of ours were 18+ hours old - I wonder if opensrf is losing track of them or thinks they're busy?
11:36 Dyrcona I don't know. I haven't looked at the age of any of them.
11:36 Dyrcona I think the value in parenthesis for the host entry is the remote port, i.e. 33352 in 192.168.1.92(33352).  You could check with netstat to see if that port is still in use on the remote host.
11:37 csharp I'll do that next time I see them pile up like this
11:37 Dyrcona I was gonna ask in #postgresql to be sure.
11:38 jeff dbs: yes, we use a circ duration rule like that for items that are "due at end of day":
11:38 jeff name   | extended |  normal  |   shrt   | max_renewals
11:38 miker csharp: almost certainly idle pcrud backends.  I find that pcrud is both more heavily used in spikes (more backends needed in the moment) and tends to not bleed off unused backends quickly like cstore does, so they just sit around
11:38 jeff ---------+----------+--------​--+----------+--------------
11:38 jeff sameday | 00:00:00 | 00:00:00 | 00:00:00 |            0
11:38 cmalm joined #evergreen
11:39 mmorgan csharp: right now we have 67, one is 22 hours old, the rest are minutes old
11:39 mmorgan Actually many are only seconds old
11:41 Dyrcona csharp: According to incognito in #postgresql, that is the remote port, so you can see if they're still connected. I suspect that they are.
11:41 miker csharp: but EG shouldn't fall over just from having connections. you just need to make sure that the sum of  (cstore-max_kids + pcrud-max_kids + storage-max_kids) * hosts <= pg-max_connections ... modulo any reporter or other misc db connections
11:42 csharp miker: yeah, I was considering upping our DB max connections (currently 1000 from ye olden days)
11:42 dbs mmorgan++
11:42 dbs jeff++
11:43 dbs thank you both. Can't believe i didn't think of this before!
11:44 jeff since it might apply to the current conversation, and I've been meaning to ask again: is anyone here using pgbouncer for connection pooling?
11:44 miker dbs: it's only been, like, 12 years ... don't beat yourself up too badly ;)
11:45 csharp miker++
11:45 jeff dbs: it would have been less successful before the "push day-granular durations to 23:59:59" code
11:46 yboston joined #evergreen
11:47 Dyrcona jeff: We're not using pgbouncer.
11:54 Dyrcona I'm down to 453 or so idle processes.
11:55 Dyrcona etime is all over the place from about 30 seconds up to 2 days 22 hours or so.
11:55 Dyrcona 'Course that doesn't mean the process has been idle all of that time. It's just that old.
11:56 jeff pg_stat_activity will have loads of more info, including application name.
11:57 jeff as well as state_change which should help you determine how idle the connection is.
11:57 * mmorgan also recently learned it can also give client_addr
11:58 berick jeff: i'm not using pgbouncer, but i have poked at it and keep it in the back of my mind.  are you using it?
11:59 jeff going back to what csharp said before, pg_cancel_backend not doing anything doesn't surprise me, because there's no active query. I'm pretty sure pg_terminate_backend would kill the idle connection, but I'm not sure how the opensrf client would handle that.
12:03 Dyrcona probably not well.
12:07 sandbergja_ joined #evergreen
12:08 jeff berick: we are not at this time, but similar to you -- poked at, used in the past for other things, thinking of if it would be useful to us in the future.
12:11 * berick nods
12:34 yboston joined #evergreen
12:46 yboston joined #evergreen
13:03 jihpringle joined #evergreen
13:10 sandbergja_ joined #evergreen
13:27 khuckins joined #evergreen
13:30 jvwoolf1 joined #evergreen
13:31 yboston joined #evergreen
13:33 agoben joined #evergreen
13:41 Dyrcona Whee! Spam on pastebin.
13:42 tlittle joined #evergreen
13:46 Dyrcona And, I've got an error message from edi_pusher/RemoteAccount that has a timestamp four minutes later than the closest log message....
13:46 agoben The Evergreen Project Board meeting will be starting in 15 minutes.
13:52 chris__ joined #evergreen
13:52 chris___ joined #evergreen
14:00 agoben #startmeeting EOB/Evergreen Project Board meeting for 2019-09-19, agenda:https://wiki.evergreen-ils.org/doku.​php?id=governance:minutes:2019-09-19
14:00 pinesol Meeting started Thu Sep 19 14:00:03 2019 US/Eastern.  The chair is agoben. Information about MeetBot at http://wiki.debian.org/MeetBot.
14:00 pinesol Useful Commands: #action #agreed #help #info #idea #link #topic #startvote.
14:00 Topic for #evergreen is now  (Meeting topic: EOB/Evergreen Project Board meeting for 2019-09-19, agenda:https://wiki.evergreen-ils.org/doku.p​hp?id=governance:minutes:2019-09-19)
14:00 pinesol The meeting name has been set to 'eob_evergreen_project_board_meeting_for_2019​_09_19__agenda_https___wiki_evergreen_ils_org​_doku_php_id_governance_minutes_2019_09_19'
14:00 agoben #topic Roll Call
14:00 Topic for #evergreen is now Roll Call (Meeting topic: EOB/Evergreen Project Board meeting for 2019-09-19, agenda:https://wiki.evergreen-ils.org/doku.p​hp?id=governance:minutes:2019-09-19)
14:00 agoben Use the #info command to provide name and affiliation
14:00 agoben #info agoben = Anna Goben, Evergreen Indiana
14:00 JBoyer #info JBoyer = Jason Boyer, EOLI
14:00 tlittle #info @tlittle = Tiffany Little, PINES
14:00 csharp #info csharp = Chris Sharp, GPLS
14:00 nfBurton31 joined #evergreen
14:01 jvwoolf1 #info jmvwoolf = Jessica Woolford, Bibliomation
14:01 nfBurton31 I'm here!
14:01 nfBurton31 #info nfBurton = Chris Burton, Niagara Falls Public Library
14:01 agoben Holly emailed that she will not be able to attend due to a previous engagement.
14:01 nfBurton left #evergreen
14:01 gmcharlt #info gmcharlt = Galen Charlton, Equinox
14:02 nfBurton87 joined #evergreen
14:02 csharp looks like nfBurton is having connection blues
14:02 agoben Anyone heard from Chris O?
14:02 nfBurton87 I'm here. I was flopping networks.
14:02 nfBurton87 In our Regional Evergreen Meeting as well
14:03 csharp multitasking++
14:03 agoben Alright, we have a quorum.  Will keep an eye out for Chris O.
14:03 agoben #topic Approval of Minutes
14:03 Topic for #evergreen is now Approval of Minutes (Meeting topic: EOB/Evergreen Project Board meeting for 2019-09-19, agenda:https://wiki.evergreen-ils.org/doku.p​hp?id=governance:minutes:2019-09-19)
14:03 agoben #info Minutes from 2019-08-15 meeting: http://evergreen-ils.org/meetings/evergr​een/2019/evergreen.2019-08-15-14.00.html
14:04 agoben Corrections, updates, suggestions?
14:04 JBoyer none here
14:04 csharp all good
14:04 tlittle Same here, all good
14:04 agoben #startvote Accept minutes from 2019-08-15? yes, no
14:04 pinesol Begin voting on: Accept minutes from 2019-08-15? Valid vote options are yes, no.
14:04 pinesol Vote using '#vote OPTION'. Only your last vote counts.
14:05 agoben #vote yes
14:05 jvwoolf1 #vote yes
14:05 tlittle #vote yes
14:05 gmcharlt #vote yes
14:05 csharp #vote yes
14:05 JBoyer #vote yes
14:05 agoben #endvote
14:05 pinesol Voted on "Accept minutes from 2019-08-15?" Results are
14:05 pinesol yes (6): JBoyer, agoben, tlittle, jvwoolf1, gmcharlt, csharp
14:05 agoben #info Minutes from 2019-08-8-26 meeting: https://wiki.evergreen-ils.org/doku.ph​p?id=governance:eob-minutes-2019-08-26
14:06 agoben Corrections, updates, suggestions?  These were not digitally recorded, so more chance there's something that needs attention
14:06 csharp all good there too
14:07 JBoyer agreed
14:07 tlittle Yeah, looks okay to me
14:07 agoben #startvote Accept minutes from 2019-08-26? yes, no
14:07 pinesol Begin voting on: Accept minutes from 2019-08-26? Valid vote options are yes, no.
14:07 pinesol Vote using '#vote OPTION'. Only your last vote counts.
14:07 nfBurton87 yes
14:07 tlittle #vote yes
14:07 JBoyer #vote yes
14:07 agoben #vote yes
14:07 jvwoolf1 #vote yes
14:07 nfBurton87 #vote yes
14:07 csharp #vote yest
14:07 pinesol csharp: yest is not a valid option. Valid options are yes, no.
14:07 csharp #vote yes
14:07 gmcharlt #vote yes
14:07 JBoyer vote yar!
14:07 agoben #endvote
14:07 pinesol Voted on "Accept minutes from 2019-08-26?" Results are
14:07 pinesol yes (7): JBoyer, agoben, tlittle, nfBurton87, jvwoolf1, gmcharlt, csharp
14:07 csharp typos--
14:07 agoben #topic Chair Report
14:07 Topic for #evergreen is now Chair Report (Meeting topic: EOB/Evergreen Project Board meeting for 2019-09-19, agenda:https://wiki.evergreen-ils.org/doku.p​hp?id=governance:minutes:2019-09-19)
14:07 agoben Nothing to report here.
14:08 agoben Have updates later
14:08 agoben #topic Treasurer's Financial Report
14:08 Topic for #evergreen is now Treasurer's Financial Report (Meeting topic: EOB/Evergreen Project Board meeting for 2019-09-19, agenda:https://wiki.evergreen-ils.org/doku.p​hp?id=governance:minutes:2019-09-19)
14:08 gmcharlt #info No substantive chanegs to current accounts with Conservancy, although there have been corrections to 2018. Balance sheet will be prepared and shared later this week
14:09 gmcharlt #info Admendment and filing fee has been mailed to the Missouri Secretary of State
14:09 gmcharlt #info We've received and will pay an invoice for reimbursement of expenses for the Free Kittens and Beer event at ALA Annual 2019; payment to go out on Monday
14:09 agoben Did you get the statement of work completed from MOBIUS?
14:10 agoben And were you able to address the invoices from Dilly?
14:10 gmcharlt #action gmcharlt will follow up with MOBIUS on getting a current statement of work for payment
14:11 gmcharlt #action gmcharlt will also follow up on Dilly invoices week of 2019-09-23
14:11 agoben Thanks!
14:11 agoben gmcharlt++
14:11 gmcharlt so, nothing else from me on this section unless there are other questions
14:11 jvwoolf1 gmcharlt: I sent you the invoices I have, right?
14:12 gmcharlt jvwoolf1: pretty sure yes, but I'll double-check with you as well
14:13 agoben Moving on then:
14:13 agoben #topic Financial Policy Subcommittee Report
14:13 Topic for #evergreen is now Financial Policy Subcommittee Report (Meeting topic: EOB/Evergreen Project Board meeting for 2019-09-19, agenda:https://wiki.evergreen-ils.org/doku.p​hp?id=governance:minutes:2019-09-19)
14:13 agoben How goes it?
14:14 gmcharlt no action to report, unfortunately & mea culpa, but I'll convene it for a report at the Ocotober board meeting
14:14 agoben Appreciate it!
14:14 agoben #topic SFC Updates
14:14 Topic for #evergreen is now SFC Updates (Meeting topic: EOB/Evergreen Project Board meeting for 2019-09-19, agenda:https://wiki.evergreen-ils.org/doku.p​hp?id=governance:minutes:2019-09-19)
14:14 agoben No known updates here.  Anyone else?
14:15 agoben Moving on then
14:16 agoben #topic Release Manager (3.3)
14:16 Topic for #evergreen is now Release Manager (3.3) (Meeting topic: EOB/Evergreen Project Board meeting for 2019-09-19, agenda:https://wiki.evergreen-ils.org/doku.p​hp?id=governance:minutes:2019-09-19)
14:16 agoben Any 3.3 updates of note?  dbwells?
14:17 agoben Seems to be all quiet, which I assume is a good sign!
14:17 agoben #topic Release Manager (3.4)
14:17 Topic for #evergreen is now Release Manager (3.4) (Meeting topic: EOB/Evergreen Project Board meeting for 2019-09-19, agenda:https://wiki.evergreen-ils.org/doku.p​hp?id=governance:minutes:2019-09-19)
14:17 agoben Things shaping up ok?
14:18 gmcharlt the first beta has been released and the second one shoudl go out today
14:18 gmcharlt and I'm expecting an on-time general release
14:19 agoben Great!  Seemed like the bug squashing went well this last week too.  Hope that's having good impacts across the releases
14:19 agoben #topic Conference Committees
14:19 Topic for #evergreen is now Conference Committees (Meeting topic: EOB/Evergreen Project Board meeting for 2019-09-19, agenda:https://wiki.evergreen-ils.org/doku.p​hp?id=governance:minutes:2019-09-19)
14:20 agoben Any updates?
14:20 tlittle Terran is on the road today, so she asked me to pass along her updates...
14:21 tlittle #info There is a meeting set for next week to meet with the AV company at the conference center to talk about pricing and our AV needs.
14:21 tlittle #info The sponsorship/exhibitor prospectus and conference logo are both actively in the works.
14:21 tlittle And that's really all at the moment.
14:21 agoben Thanks!
14:21 agoben tlittle++
14:21 csharp #info call for proposals for EG 2021 sent to the Open-ILS-General email list on September 9: http://libmail.georgialibraries.org/pipermail​/open-ils-general/2019-September/015924.html
14:22 csharp no bites yet, so...
14:22 csharp #action csharp will send follow-up email to call for proposals the week of 9/23
14:22 agoben Excellent!  Thanks
14:22 agoben csharp++
14:22 agoben #topic Outreach Committee
14:22 Topic for #evergreen is now Outreach Committee (Meeting topic: EOB/Evergreen Project Board meeting for 2019-09-19, agenda:https://wiki.evergreen-ils.org/doku.p​hp?id=governance:minutes:2019-09-19)
14:23 agoben #info Nothing to report this month per rhamby's email
14:23 agoben #topic Unfinished Business: Updated Articles of Incorporation
14:23 Topic for #evergreen is now Unfinished Business: Updated Articles of Incorporation (Meeting topic: EOB/Evergreen Project Board meeting for 2019-09-19, agenda:https://wiki.evergreen-ils.org/doku.p​hp?id=governance:minutes:2019-09-19)
14:23 sandbergja_ joined #evergreen
14:24 agoben As noted above, we've submitted all the paperwork and are waiting on the MO AG now
14:24 agoben Hoping to hear soon that the approved paperwork has been received by Dilly's office.
14:25 agoben #topic Unfinished Business: Dilly's Power of Attorney
14:25 Topic for #evergreen is now Unfinished Business: Dilly's Power of Attorney (Meeting topic: EOB/Evergreen Project Board meeting for 2019-09-19, agenda:https://wiki.evergreen-ils.org/doku.p​hp?id=governance:minutes:2019-09-19)
14:25 agoben I've reached out and haven't heard back on the status of this.
14:25 agoben #action agoben will follow-up again with Dilly on the POA paperwork and to check on the status of the Amended Articles.
14:26 agoben #topic New Business
14:26 Topic for #evergreen is now New Business (Meeting topic: EOB/Evergreen Project Board meeting for 2019-09-19, agenda:https://wiki.evergreen-ils.org/doku.p​hp?id=governance:minutes:2019-09-19)
14:26 agoben I didn't hear from anyone with new business, but the floor is open.
14:26 gmcharlt I have no new busniess
14:27 JBoyer nothing here
14:27 tlittle None from me
14:27 nfBurton87 none
14:27 csharp same
14:27 jvwoolf1 same here
14:27 agoben #topic Next meeting
14:27 Topic for #evergreen is now Next meeting (Meeting topic: EOB/Evergreen Project Board meeting for 2019-09-19, agenda:https://wiki.evergreen-ils.org/doku.p​hp?id=governance:minutes:2019-09-19)
14:27 agoben Scheduled at the Hack-A-Way?
14:28 agoben I think the majority of the members will be on site for the Hack-a-way, so did we want to plan on it then or the usual time the week before?
14:28 tlittle It'd be nice to meet in person if most of us are there
14:28 gmcharlt enough for a quorum in person, do you know?
14:28 JBoyer I think during would work well but don't have a strong preference
14:28 csharp I'm one who treasures every moment of the hack-a-way, so I'd prefer regular time FWIW
14:29 tlittle Yeah, important if we'd have a quorum or not
14:29 sandbergja_ joined #evergreen
14:30 jvwoolf1 I won't be there, unfortunately. But I could call in if needed.
14:30 agoben For those of you who won't be at the Hack-A-Way (Oct21-23), does that timeframe present any issues?
14:30 cowens I will not be there either
14:30 agoben If we do hold it at the HAW, I figured we could video stream it so those who can't attend could still participate if the timing works.
14:31 jvwoolf1 That works for me.
14:31 cowens Me also
14:31 agoben I believe at least 5 of us will be at the HAW, so we should be alright on the quorum front, fwiw.
14:33 agoben But I'm basing that assumption on who has attended in the past and hasn't said they can't come.
14:33 csharp I'm counting 5 too - I think that's dependable, barring the unforeseen
14:34 agoben I have meetings already the afternoon of the 23rd.  Any preferences on times/days from others?
14:34 JBoyer none here
14:35 nfBurton87 No preference
14:35 gmcharlt no preference
14:35 tlittle There's supposed to be a conference meeting at 1pm on the 22nd, but I'm good otherwise
14:36 jvwoolf1 That week looks clear for me so far
14:36 agoben What about lunchtime (ET) on Monday?
14:36 gmcharlt +1
14:36 agoben That way it's not overlapping with the other activities
14:36 JBoyer +1
14:36 tlittle +1
14:36 nfBurton87 +1
14:37 csharp +1
14:37 jvwoolf1 +1
14:37 cowens +1
14:37 csharp agoben: thanks - that addresses my only concern with doing it at the hack-a-way :-)
14:37 agoben #info Our next formal meeting will be on October 21, 2019 around 12pm ET.
14:38 * csharp wouldn't expect it to run long if it's like our meeting so far
14:38 agoben I know Holly probably won't be able to attend that early in the day, but I'll let her know.
14:38 csharp *meetings
14:38 JBoyer Significantly quicker, if I had to guess. :)
14:38 agoben And yeah, hoping to keep it short, but it will be the first review of the fiscal policy, so....
14:39 agoben Not more than an hour though.  Things to do; projects to hack!
14:39 agoben Any further discussion items?
14:39 tlittle None here
14:40 gmcharlt not from me
14:40 JBoyer nope
14:40 agoben Great!  I look forward to chatting with you all again during the Hack-A-Way!
14:40 agoben #endmeeting
14:40 Topic for #evergreen is now Welcome to the #evergreen library system channel! | We are publicly logged: http://irc.evergreen-ils.org/evergreen | Large pastes at http://paste.evergreen-ils.org | Can't speak? Make sure your nickname is registered and that you are identified to freenode services: https://freenode.net/kb/answer/registration
14:40 pinesol Meeting ended Thu Sep 19 14:40:51 2019 US/Eastern.  Information about MeetBot at http://wiki.debian.org/MeetBot . (v 0.1.4)
14:40 pinesol Minutes:        http://evergreen-ils.org/meetings/evergr​een/2019/evergreen.2019-09-19-14.00.html
14:40 pinesol Minutes (text): http://evergreen-ils.org/meetings/evergr​een/2019/evergreen.2019-09-19-14.00.txt
14:40 pinesol Log:            http://evergreen-ils.org/meetings/evergree​n/2019/evergreen.2019-09-19-14.00.log.html
14:40 jvwoolf1 agoben++
14:40 JBoyer agoben++
14:41 agoben Thanks all!
14:41 tlittle agoben++
14:41 gmcharlt agoben++
14:41 csharp agoben++
14:41 yboston joined #evergreen
14:49 cowens left #evergreen
14:53 yboston joined #evergreen
15:04 mmorgan1 joined #evergreen
15:18 khuckins joined #evergreen
15:19 jeffdavis I imagine it's normal for Angular, but 63,000 files in node_modules seems a little excessive.
15:19 JBoyer common and normal aren't the same thing. ;)
15:19 yboston joined #evergreen
15:20 JBoyer Well, I mean they may frequently be, but I like to think not in this case.
15:20 berick 1407 package.json files
15:22 Dyrcona npm is a great way to install exploit code....
15:23 * Dyrcona ducks. :P
15:27 jeffdavis berick: what does that number represent?
15:28 berick jeffdavis: nothing really, just thinking about how much of the content is package management stuff.
15:30 nfBurton74 joined #evergreen
15:30 nfBurton74 Does anyone know if the URL changed for Missouri Evergreen's wiki?
15:31 nfBurton74 libraries.missourievergreen.org seems to be down
16:12 Dyrcona Has anyone encountered/fixed this: I noticed that my Apache access logs all have 127.0.0.1 or ::1 for the remote IP with the nginx proxy.  I believe that I have the RemoteIPHeader configured correctly in Apache and that nginx is configured to send the header that Apache expects.  Do I need to use a custom log entry?
16:13 jeff can you paste your relevant nginx config bits and apache config bits?
16:13 jvwoolf1 left #evergreen
16:13 jeff i.e., where you think you're setting the headers in nginx and where you think you're looking at them in apache?
16:14 jeff and then, what kind of requests are these? all requests, or some that may be being generated internally by mod perl / etc?
16:15 Dyrcona jeff: I think it may be that I need to add a RemoteIPInternalProxy entry or two.
16:15 Dyrcona I'm guessing that Apache is not seeing 127.0.0.1 from nginx but the 192.168.1.X address.
16:16 jeff and, are you running nginx and apache on the same host?
16:17 Dyrcona Yes.
16:18 Dyrcona I'm testing on a standalone server that show the same behavior.
16:19 Dyrcona Eh, no. that's not it.
16:21 gmcharlt sorry for the stupid question, but is mod_remoteip enabled?
16:26 Dyrcona It is, or Apache complains about the RemoteIPHeader directive. I think I've got it. Going to try uisng $remote_addr in nginx config and not $proxy_add_x_forwarded_for.
16:29 Dyrcona And, still no good.
16:30 jeff any change you can paste your relevant nginx and apache config somewhere?
16:30 jeff s/change/chance/
16:30 JBoyer yeah, I think you have to do some custom trickery to get apache to log a different value, because the "client" really is 127.0.0.1 (or wherever nginx is), you have to start logging the value passed in the X-Forwarded-For header, which I'm unsure how to do.
16:32 Dyrcona I'll look into it more next week. Thanks everyone for offering suggestions.
16:32 yboston joined #evergreen
16:32 Dyrcona Or, maybe even tomorrow.... (I wish it were Friday...) :)
16:40 mmorgan joined #evergreen
16:41 gmcharlt https://evergreen-ils.org/security-releases-​evergreen-3-1-15-3-2-9-3-3-4-and-3-4-beta2/
16:44 pinesol Showing latest 5 of 9 commits to Evergreen...
16:44 pinesol [evergreen|Jane Sandberg] Docs: adding release notes for 3.1.15 - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=74fde21>
16:44 pinesol [evergreen|Jane Sandberg] Docs: adding release notes for 3.2.9 - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=db911c3>
16:44 pinesol [evergreen|Jane Sandberg] Docs: adding release notes for 3.3.4 - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=453548d>
16:44 pinesol [evergreen|Galen Charlton] update 3.4 release notes for security bugfixes - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=195d44a>
16:44 pinesol [evergreen|Dan Wells] Forward-port 3.3.4 upgrade script - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=efde2a4>
16:45 Dyrcona gmcharlt++ dbwells++ Bmagic++
16:45 Dyrcona sandbergja++ # Why not, a second time?
16:59 Dyrcona jeffdavis++
17:03 yboston joined #evergreen
17:06 mmorgan left #evergreen
18:11 yboston joined #evergreen
19:09 cmalm joined #evergreen
20:13 JBoyer_ joined #evergreen
20:21 JBoyer_ joined #evergreen
20:25 JBoyer- joined #evergreen
20:30 JBoyer_ joined #evergreen
21:03 sandbergja joined #evergreen
21:17 JBoyer_ joined #evergreen
23:03 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
23:39 sandbergja joined #evergreen

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