| Time |
Nick |
Message |
| 07:10 |
|
kworstell-isl joined #evergreen |
| 07:43 |
|
kworstell_isl joined #evergreen |
| 07:47 |
|
kworstell-isl joined #evergreen |
| 07:53 |
|
kworstell_isl joined #evergreen |
| 07:55 |
|
BDorsey joined #evergreen |
| 08:15 |
|
collum joined #evergreen |
| 08:49 |
|
mmorgan joined #evergreen |
| 08:58 |
|
rfrasur joined #evergreen |
| 09:07 |
|
mschell joined #evergreen |
| 09:10 |
|
Dyrcona joined #evergreen |
| 09:11 |
|
dguarrac joined #evergreen |
| 09:56 |
|
berick joined #evergreen |
| 10:11 |
Dyrcona |
miker: Regarding Lp 1999274, I'm going to search the code for CTEs that are used more than once in the parent query and test them for performance on Pg 13. If I find any that need fixing, I'll try using the offset trick on them. (I may switch to testing on Pg 15.) |
| 10:11 |
pinesol |
Launchpad bug 1999274 in Evergreen 3.10 "Performance of Search on PostgreSQL Versions 12+" [Medium,Confirmed] https://launchpad.net/bugs/1999274 |
| 10:11 |
Dyrcona |
If I find (m)any more, I may change the bug summary for accuracy's sake. |
| 10:27 |
|
jmurray-isl joined #evergreen |
| 10:54 |
|
sleary joined #evergreen |
| 11:17 |
|
Christineb joined #evergreen |
| 11:34 |
Dyrcona |
I'm trying to add some code in load_rresults in Search.pm to block queries that match a certain regex when POSTed. So far it isn't working. Has anyone done this before? |
| 11:45 |
Dyrcona |
My POST is working. If I change it to a keyword search that returns something, I do get the results in the output. |
| 11:51 |
Bmagic |
got a patch I could look at? |
| 11:53 |
Dyrcona |
Bmagic: I'll share it after lunch, and by "not working" I mean the query is getting to the database. |
| 11:54 |
Dyrcona |
I have an idea for a slightly different take on it. |
| 11:55 |
Dyrcona |
Bmagic: You can see it at the tip of the egdev/rel_3_10 branch in the private CWMARS repo on github. |
| 11:55 |
Bmagic |
Wouldn't it be cool if we could specify the regex in a config somewhere for the filter? As we see different and new malicious attempts on the system, we'd need to update the filter (I would think) |
| 11:56 |
Bmagic |
Dyrcona++ |
| 11:56 |
Dyrcona |
Yeah that would be good. |
| 11:57 |
Dyrcona |
My current attempt probably doesn't take into account something in how the query gets mangled. I was thinking of moving the check to above the preparation step. |
| 12:02 |
|
jihpringle joined #evergreen |
| 12:28 |
|
jeff joined #evergreen |
| 12:34 |
|
collum joined #evergreen |
| 12:45 |
|
collum joined #evergreen |
| 13:16 |
|
jvwoolf joined #evergreen |
| 13:18 |
Dyrcona |
Bmagic++ |
| 13:19 |
Dyrcona |
So, it turns out that my original attempt was OK. Just copying the modified file into place and restarting Apache wasn't enough for the change to take effect. I ended up doing an install, restarting Evergreen services, and restarting Apache. |
| 15:10 |
|
jihpringle joined #evergreen |
| 15:24 |
|
sleary joined #evergreen |
| 16:31 |
|
jvwoolf left #evergreen |
| 16:41 |
|
sleary joined #evergreen |
| 17:08 |
|
mmorgan left #evergreen |
| 19:00 |
|
phasefx joined #evergreen |
| 19:00 |
|
scottangel joined #evergreen |
| 19:00 |
|
tsadok joined #evergreen |
| 19:00 |
|
Stompro joined #evergreen |
| 19:00 |
|
jweston joined #evergreen |
