2025-08-05 GnuCash IRC logs

01:32:54 *** gncbot has joined #gnucash
01:48:35 *** fell has quit IRC
01:49:54 *** fell has joined #gnucash
01:49:54 *** ChanServ sets mode: +o fell
02:57:08 *** hamaryns has joined #gnucash
02:57:08 *** ChanServ sets mode: +v hamaryns
03:25:59 *** hamaryns has quit IRC
03:26:06 *** hamaryns has joined #gnucash
03:26:06 *** ChanServ sets mode: +v hamaryns
03:32:08 *** hamaryns has quit IRC
04:47:53 *** hamaryns has joined #gnucash
04:47:53 *** ChanServ sets mode: +v hamaryns
04:56:59 *** hamaryns has quit IRC
06:45:31 *** bauen1 has joined #gnucash
08:06:34 *** warlord has joined #gnucash
08:06:44 *** ChanServ sets mode: +qo warlord warlord
08:06:46 *** warlord sets mode: +o gncbot
08:43:45 *** bauen1 has quit IRC
09:44:18 *** bauen1 has joined #gnucash
12:12:08 *** mykeylynx has joined #gnucash
12:12:08 *** ChanServ sets mode: +v mykeylynx
12:12:21 <mykeylynx> GnuCash 5.12 Apple OSX The import process does not take a -negative sign and separation of positive amounts and Negative amounts to columns is necessary for import of credit card data specifically AMEX
12:22:46 *** mykeylynx has quit IRC
12:36:42 *** ChanServ sets mode: +v oliver
12:50:40 *** bauen1 has quit IRC
14:09:42 *** bauen1 has joined #gnucash
15:53:27 *** hamaryns has joined #gnucash
15:53:28 *** ChanServ sets mode: +v hamaryns
16:23:54 *** hamaryns has quit IRC
16:27:25 *** hamaryns has joined #gnucash
16:27:26 *** ChanServ sets mode: +v hamaryns
16:29:50 *** hamaryns has quit IRC
17:24:04 <jralls> warlord, bugzilla is stalling out. wiki was slow but completed in a couple of seconds.
17:27:48 <warlord> jralls, I'll take a look.
17:39:54 <warlord> Oh, we're back to lala land
17:39:54 <warlord> 17:39:39 up 1 day, 23:11, 1 user, load average: 278.96, 296.02, 297.38
17:41:30 <warlord> Looks like mysql might be wedged.
17:48:42 *** warlord has quit IRC
17:58:51 *** jralls-m1 has joined #gnucash
17:58:51 *** jralls has quit IRC
17:59:22 *** jralls-m1 is now known as jralls
18:00:03 *** ChanServ sets mode: +o jralls
18:02:04 *** warlord has joined #gnucash
18:02:04 *** gncbot sets mode: +o warlord
18:05:07 <warlord> Okay, I've restarted httpd + PHP, and optimized mysql DB tables. Hopefully that'll help for now, until we get probed-to-death again.
18:05:51 <warlord> and that didn't take long!
18:05:53 <warlord> [Tue Aug 05 18:05:09.788156 2025] [mpm_event:error] [pid 2034:tid 140214906341632] AH10159: server is within MinSpareThreads of MaxRequestWorkers, consider raising the MaxRequestWorkers setting
18:05:53 <warlord> [Tue Aug 05 18:05:19.842098 2025] [mpm_event:error] [pid 2034:tid 140214906341632] AH00484: server reached MaxRequestWorkers setting, consider raising the MaxRequestWorkers setting
18:05:53 <warlord> [Tue Aug 05 18:05:27.706243 2025] [cgid:warn] [pid 2345:tid 140214433474304] [client 146.174.186.70:40618] AH01220: Timeout waiting for output from CGI script /usr/share/bugzilla/buglist.cgi
18:05:55 <warlord> [Tue Aug 05 18:05:27.706867 2025] [cgid:error] [pid 2345:tid 140214433474304] [client 146.174.186.70:40618] Script timed out before returning headers: buglist.cgi
18:08:38 <jralls> Yeah, the bots are relentless. Did you see the stories about Cloudflare's claim that Propensity is spoofing normal browsers and IPs to get around blockers?
18:10:30 <warlord> I did not, but I believe it. And they don't honor robots.txt.
18:13:21 <warlord> I wonder -- if I put Deny All into robots.txt, will it affect anything?
18:17:37 <jralls> You mean besides making the mailing lists unsearchable? Probably not.
18:18:31 <warlord> Right.
18:19:01 <warlord> The bad guys are already ignoring robots.txt...
18:19:08 <warlord> I suppose I could just block /wiki/
18:20:23 <warlord> Out of the last 5000 requests, 3750 are for /wiki/
18:21:24 <jralls> Block it how? I think the only blockers that even half work are Anubis and Cloudflare's equivalent. We talked about Anubis a couple of weeks ago and you're not set up right to use that. I suppose Linas's tight grip on the gnucash.org DNS records precludes using Cloudflare though that would help a lot with the wiki traffic load.
18:22:03 <warlord> I could probably work with Linas to update DNS to use CloudFlare -- but what does that cost?
18:22:21 <warlord> (block via robots.txt -- but again, if they ignore that then it doesn't matter)
18:22:44 <warlord> I'd certainly consider Anubis when I get some significant time to play with the infra.
18:22:50 <jralls> Nothing for small nonprofits. I use it for https://californiaancestors.org. IIRC I didn't have to do anything more than tick a box.
18:24:02 <jralls> significant time to play. Sure. ;-)
18:27:37 <warlord> It's just so frustrating.
18:38:16 <warlord> Of those 5000 requests, they come from 4209 unique IPs.
18:57:40 <Simon> the way I see it there are only two options: reduce the quantity of unique URLs they can see, or add in bot filters
18:58:17 <Simon> I wouldn't use Cloudflare because all websites ending up behind one provider would be had
18:58:19 <Simon> bad*
19:13:20 <warlord> Well, it turns out the FastCGI was not limiting the number of buglist.cgi processes.. There were over 200 of them running. I've gone and limited the number.
19:14:21 <jralls> That's interesting. Can you tell if they were all current?
19:15:09 <warlord> They were, yes, because I restarted httpd several times...
19:15:28 <warlord> I've now limited it down to 50
19:16:44 <jralls> And now I can get to BZ. What happens when the bots are all hammering it?
19:16:56 <jralls> Using up all 50 slots, that is.
19:18:18 <warlord> The issue was MySQL timeouts. Too many processes banging on mysql and hanging, so nobody could get in. I THINK now you'll just queue in with the bots.
19:20:58 <jralls> Hope you're right.
19:22:13 <jralls> But it doesn't look good. I tried to post a comment and the progress bar is stuck at about 1/8th of the way.
19:23:20 <warlord> That's odd -- once you get the connection it should complete.
19:27:37 <warlord> I'm restarting the services again -- changing some of the configs.
19:29:14 <warlord> jralls, try again now?
19:31:53 <warlord> I'm seeing 3-5 reqs/sec. It should be able to handle that just fine!
19:34:38 <warlord> Maybe it's more like 5-10/sec. Either way, should be doable.
19:53:21 <jralls> warlord, It worked and was pretty responsive; a couple of seconds at most.
19:53:25 <jralls> Time for me to go.
19:57:26 <warlord> jralls, have a great evening
19:57:30 <warlord> (glad it worked this time)
20:38:35 *** warlord has quit IRC
21:07:00 *** warlord has joined #gnucash
21:07:00 *** gncbot sets mode: +o warlord
21:17:39 *** jralls-m1 has joined #gnucash
21:17:40 *** jralls has quit IRC
23:10:00 *** jonakeys has quit IRC
23:10:08 *** jonakeys has joined #gnucash