<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<meta name="description" content="IRC LOG for channel #evergreen" />
<meta name="viewport" content="width=device-width" />
<link rel="stylesheet" type="text/css" href="/s/style.css" title="Irclog Stylesheet" />
<link rel="shortcut icon" href="/s/favicon.ico" type="image/x-icon" />
<link rel="canonical"
href="/evergreen/2022-12-12" />
<title>IRC log for #evergreen, 2022-12-12</title>
</head>
<body>
<p><a href="http://evergreen-ils.org/"><img style="float:right; border:none"
src="/s/small_logo.jpg" alt="Evergreen ILS Website"/></a></p>
<h1>IRC log for #evergreen, 2022-12-12</h1>
<p>
<a href="/evergreen/2022-12-11" rel="prev">
← Previous day</a> |
<a href="/">Channels</a> |
<a href="/evergreen/">#evergreen index</a> |
<a href="/evergreen/today">Today</a> |
<a href="/evergreen/2022-12-13" rel="next">
Next day →</a> |
<a href="/evergreen/search">Search</a> |
<a href="http://www.google.com/search?q=site%3Airc.evergreen-ils.org+inurl%3Aevergreen">Google Search</a>
| <a href="/evergreen/2022-12-12/text">Plain-Text</a> |
<a href="/evergreen/2022-12-12/summary">summary</a>
| <a href="https://webchat.freenode.net/?channels=evergreen">Join Webchat</a>
</p>
<p>All times shown according to the server's local time.</p>
<div>
<span style="display: none;" id="filter_toggle"></span>
<span id="summary_container" />
</div>
<form action="#" name="summary_form" id="summary_form">
<span id="top" />
<table id="log" style="clear:both">
<tr class="head">
<th>Time</th>
<th>Nick</th>
<th>Message</th>
</tr>
<tr id="id_l2" class="new special dark">
<td class="time" id="i_517481"><a href="/evergreen/2022-12-12#i_517481">07:10</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">kworstell-isl joined #evergreen</td>
</tr>
<tr id="id_l3" class="cont special dark">
<td class="time" id="i_517482"><a href="/evergreen/2022-12-12#i_517482">07:43</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">kworstell_isl joined #evergreen</td>
</tr>
<tr id="id_l4" class="cont special dark">
<td class="time" id="i_517483"><a href="/evergreen/2022-12-12#i_517483">07:47</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">kworstell-isl joined #evergreen</td>
</tr>
<tr id="id_l5" class="cont special dark">
<td class="time" id="i_517484"><a href="/evergreen/2022-12-12#i_517484">07:53</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">kworstell_isl joined #evergreen</td>
</tr>
<tr id="id_l6" class="cont special dark">
<td class="time" id="i_517485"><a href="/evergreen/2022-12-12#i_517485">07:55</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">BDorsey joined #evergreen</td>
</tr>
<tr id="id_l7" class="cont special dark">
<td class="time" id="i_517486"><a href="/evergreen/2022-12-12#i_517486">08:15</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">collum joined #evergreen</td>
</tr>
<tr id="id_l8" class="cont special dark">
<td class="time" id="i_517487"><a href="/evergreen/2022-12-12#i_517487">08:49</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">mmorgan joined #evergreen</td>
</tr>
<tr id="id_l9" class="cont special dark">
<td class="time" id="i_517488"><a href="/evergreen/2022-12-12#i_517488">08:58</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">rfrasur joined #evergreen</td>
</tr>
<tr id="id_l10" class="cont special dark">
<td class="time" id="i_517489"><a href="/evergreen/2022-12-12#i_517489">09:07</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">mschell joined #evergreen</td>
</tr>
<tr id="id_l11" class="cont special dark">
<td class="time" id="i_517490"><a href="/evergreen/2022-12-12#i_517490">09:10</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">Dyrcona joined #evergreen</td>
</tr>
<tr id="id_l12" class="cont special dark">
<td class="time" id="i_517491"><a href="/evergreen/2022-12-12#i_517491">09:11</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">dguarrac joined #evergreen</td>
</tr>
<tr id="id_l13" class="cont special dark">
<td class="time" id="i_517492"><a href="/evergreen/2022-12-12#i_517492">09:56</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">berick joined #evergreen</td>
</tr>
<tr id="id_l14" class="new nick nick_Dyrcona">
<td class="time" id="i_517493"><a href="/evergreen/2022-12-12#i_517493">10:11</a></td>
<td style="color: #7d008d" class="nick">Dyrcona</td>
<td class="msg ">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.)</td>
</tr>
<tr id="id_l15" class="new nick nick_pinesol dark">
<td class="time" id="i_517494"><a href="/evergreen/2022-12-12#i_517494">10:11</a></td>
<td style="color: #4e00a3" class="nick">pinesol</td>
<td class="msg ">Launchpad bug 1999274 in Evergreen 3.10 "Performance of Search on PostgreSQL Versions 12+" [Medium,Confirmed] <a href="https://launchpad.net/bugs/1999274" title="https://launchpad.net/bugs/1999274">https://launchpad.net/bugs/1999274</a></td>
</tr>
<tr id="id_l16" class="new nick nick_Dyrcona">
<td class="time" id="i_517495"><a href="/evergreen/2022-12-12#i_517495">10:11</a></td>
<td style="color: #7d008d" class="nick">Dyrcona</td>
<td class="msg ">If I find (m)any more, I may change the bug summary for accuracy's sake.</td>
</tr>
<tr id="id_l17" class="new special dark">
<td class="time" id="i_517496"><a href="/evergreen/2022-12-12#i_517496">10:27</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">jmurray-isl joined #evergreen</td>
</tr>
<tr id="id_l18" class="cont special dark">
<td class="time" id="i_517497"><a href="/evergreen/2022-12-12#i_517497">10:54</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">sleary joined #evergreen</td>
</tr>
<tr id="id_l19" class="cont special dark">
<td class="time" id="i_517498"><a href="/evergreen/2022-12-12#i_517498">11:17</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">Christineb joined #evergreen</td>
</tr>
<tr id="id_l20" class="new nick nick_Dyrcona">
<td class="time" id="i_517499"><a href="/evergreen/2022-12-12#i_517499">11:34</a></td>
<td style="color: #7d008d" class="nick">Dyrcona</td>
<td class="msg ">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?</td>
</tr>
<tr id="id_l21" class="cont nick nick_Dyrcona">
<td class="time" id="i_517500"><a href="/evergreen/2022-12-12#i_517500">11:45</a></td>
<td style="color: #7d008d" class="nick">Dyrcona</td>
<td class="msg ">My POST is working. If I change it to a keyword search that returns something, I do get the results in the output.</td>
</tr>
<tr id="id_l22" class="new nick nick_Bmagic dark">
<td class="time" id="i_517501"><a href="/evergreen/2022-12-12#i_517501">11:51</a></td>
<td style="color: #9d6200" class="nick">Bmagic</td>
<td class="msg ">got a patch I could look at?</td>
</tr>
<tr id="id_l23" class="new nick nick_Dyrcona">
<td class="time" id="i_517502"><a href="/evergreen/2022-12-12#i_517502">11:53</a></td>
<td style="color: #7d008d" class="nick">Dyrcona</td>
<td class="msg ">Bmagic: I'll share it after lunch, and by "not working" I mean the query is getting to the database.</td>
</tr>
<tr id="id_l24" class="cont nick nick_Dyrcona">
<td class="time" id="i_517503"><a href="/evergreen/2022-12-12#i_517503">11:54</a></td>
<td style="color: #7d008d" class="nick">Dyrcona</td>
<td class="msg ">I have an idea for a slightly different take on it.</td>
</tr>
<tr id="id_l25" class="cont nick nick_Dyrcona">
<td class="time" id="i_517504"><a href="/evergreen/2022-12-12#i_517504">11:55</a></td>
<td style="color: #7d008d" class="nick">Dyrcona</td>
<td class="msg ">Bmagic: You can see it at the tip of the egdev/rel_3_10 branch in the private CWMARS repo on github.</td>
</tr>
<tr id="id_l26" class="new nick nick_Bmagic dark">
<td class="time" id="i_517505"><a href="/evergreen/2022-12-12#i_517505">11:55</a></td>
<td style="color: #9d6200" class="nick">Bmagic</td>
<td class="msg ">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)</td>
</tr>
<tr id="id_l27" class="cont nick nick_Bmagic dark">
<td class="time" id="i_517506"><a href="/evergreen/2022-12-12#i_517506">11:56</a></td>
<td style="color: #9d6200" class="nick">Bmagic</td>
<td class="msg ">Dyrcona++</td>
</tr>
<tr id="id_l28" class="new nick nick_Dyrcona">
<td class="time" id="i_517507"><a href="/evergreen/2022-12-12#i_517507">11:56</a></td>
<td style="color: #7d008d" class="nick">Dyrcona</td>
<td class="msg ">Yeah that would be good.</td>
</tr>
<tr id="id_l29" class="cont nick nick_Dyrcona">
<td class="time" id="i_517508"><a href="/evergreen/2022-12-12#i_517508">11:57</a></td>
<td style="color: #7d008d" class="nick">Dyrcona</td>
<td class="msg ">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.</td>
</tr>
<tr id="id_l30" class="new special dark">
<td class="time" id="i_517509"><a href="/evergreen/2022-12-12#i_517509">12:02</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">jihpringle joined #evergreen</td>
</tr>
<tr id="id_l31" class="cont special dark">
<td class="time" id="i_517510"><a href="/evergreen/2022-12-12#i_517510">12:28</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">jeff joined #evergreen</td>
</tr>
<tr id="id_l32" class="cont special dark">
<td class="time" id="i_517513"><a href="/evergreen/2022-12-12#i_517513">12:34</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">collum joined #evergreen</td>
</tr>
<tr id="id_l33" class="cont special dark">
<td class="time" id="i_517514"><a href="/evergreen/2022-12-12#i_517514">12:45</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">collum joined #evergreen</td>
</tr>
<tr id="id_l34" class="cont special dark">
<td class="time" id="i_517515"><a href="/evergreen/2022-12-12#i_517515">13:16</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">jvwoolf joined #evergreen</td>
</tr>
<tr id="id_l35" class="new nick nick_Dyrcona">
<td class="time" id="i_517516"><a href="/evergreen/2022-12-12#i_517516">13:18</a></td>
<td style="color: #7d008d" class="nick">Dyrcona</td>
<td class="msg ">Bmagic++</td>
</tr>
<tr id="id_l36" class="cont nick nick_Dyrcona">
<td class="time" id="i_517517"><a href="/evergreen/2022-12-12#i_517517">13:19</a></td>
<td style="color: #7d008d" class="nick">Dyrcona</td>
<td class="msg ">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.</td>
</tr>
<tr id="id_l37" class="new special dark">
<td class="time" id="i_517518"><a href="/evergreen/2022-12-12#i_517518">15:10</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">jihpringle joined #evergreen</td>
</tr>
<tr id="id_l38" class="cont special dark">
<td class="time" id="i_517519"><a href="/evergreen/2022-12-12#i_517519">15:24</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">sleary joined #evergreen</td>
</tr>
<tr id="id_l39" class="cont special dark">
<td class="time" id="i_517520"><a href="/evergreen/2022-12-12#i_517520">16:31</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">jvwoolf left #evergreen</td>
</tr>
<tr id="id_l40" class="cont special dark">
<td class="time" id="i_517521"><a href="/evergreen/2022-12-12#i_517521">16:41</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">sleary joined #evergreen</td>
</tr>
<tr id="id_l41" class="cont special dark">
<td class="time" id="i_517522"><a href="/evergreen/2022-12-12#i_517522">17:08</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">mmorgan left #evergreen</td>
</tr>
<tr id="id_l42" class="cont special dark">
<td class="time" id="i_517523"><a href="/evergreen/2022-12-12#i_517523">19:00</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">phasefx joined #evergreen</td>
</tr>
<tr id="id_l43" class="cont special dark">
<td class="time" id="i_517524"><a href="/evergreen/2022-12-12#i_517524">19:00</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">scottangel joined #evergreen</td>
</tr>
<tr id="id_l44" class="cont special dark">
<td class="time" id="i_517525"><a href="/evergreen/2022-12-12#i_517525">19:00</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">tsadok joined #evergreen</td>
</tr>
<tr id="id_l45" class="cont special dark">
<td class="time" id="i_517526"><a href="/evergreen/2022-12-12#i_517526">19:00</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">Stompro joined #evergreen</td>
</tr>
<tr id="id_l46" class="cont special dark">
<td class="time" id="i_517527"><a href="/evergreen/2022-12-12#i_517527">19:00</a></td>
<td style="color: #ad7900" class="nick"></td>
<td class="msg ">jweston joined #evergreen</td>
</tr>
</table>
</form>
<span id="bottom" />
<p>
<a href="/evergreen/2022-12-11" rel="prev">
← Previous day</a> |
<a href="/">Channels</a> |
<a href="/evergreen/">#evergreen index</a> |
<a href="/evergreen/today">Today</a> |
<a href="/evergreen/2022-12-13" rel="next">
Next day →</a> |
<a href="/evergreen/search">Search</a> |
<a href="http://www.google.com/search?q=site%3Airc.evergreen-ils.org+inurl%3Aevergreen">Google Search</a>
| <a href="/evergreen/2022-12-12/text">Plain-Text</a> |
<a href="/evergreen/2022-12-12/summary">summary</a>
| <a href="https://webchat.freenode.net/?channels=evergreen">Join Webchat</a>
</p>
<div id="footer">
<p>Powered by <a href="http://moritz.faui2k3.org/en/ilbot">ilbot</a>.
<strong>Any questions? Ask bshum in #evergreen on irc.libera.chat</strong></p>
<p>
Evergreen is open source software, freely
licensed under <a href="http://www.gnu.org/licenses/gpl-2.0.html"
target="_blank">GNU GPLv2</a> or later.<br /> The <a
href="http://evergreen-ils.org/blog/?p=583" target="_blank">Evergreen Project is
a member</a> of <a href="http://sfconservancy.org/" target="_blank">Software
Freedom Conservancy</a>.
</p>
</div>
<script type="text/javascript" src="/s/jquery.min.js"></script>
<script type="text/javascript">
IlbotConfig = {
base_url: '/',
channel: 'evergreen',
day: '2022-12-12',
still_today: false
};
</script>
<script type="text/javascript" src="/s/dynamic.js"></script>
</body>
</html>
<!-- -->