Re: [Evergreen-general] Question about search engine bots & DB CPU spikes

2021-12-01 Thread JonGeorg SageLibrary via Evergreen-general
The LONG STRING sometimes contains a word, but it's usually just a string of numbers repeated, like this- $_78110$[$_78110$, $_78110$$_78110$), $_78110$]$_78110$, $_78110$$_78110$. The numbers change which is why I suspect it's a SQL injection attempt. I agree re blocking by IP's. I didn't set

Re: [Evergreen-general] Question about search engine bots & DB CPU spikes

2021-12-01 Thread Jeff Davis via Evergreen-general
Our robots.txt file (https://catalogue.libraries.coop/robots.txt) throttles Googlebot and Bingbot to 60 seconds and disallows certain other crawlers entirely. So even 10 seconds seems generous to me. Of course, robots.txt will only be respected by well-behaved crawlers; there's nothing

[Evergreen-general] Adding New Facets

2021-12-01 Thread Michael Schell via Evergreen-general
Does anyone know how to add a new facet to the results page of the OPAC? Specifically, I would like to add format as one of the filters (ie. DVD, Large Print, etc). I have poked around server admin>MARC Search/Facet Fields but could use some help. Thanks! -- Michael Schell Systems

Re: [Evergreen-general] Question about search engine bots & DB CPU spikes

2021-12-01 Thread Jason Stephenson via Evergreen-general
JonGeorg, If you're using nginx as a proxy, that may be the configuration of Apache and nginx. First, make sure that mod_remote_ip is installed and enabled for Apache 2. Then, in eg_vhost.conf, find the 3 lines the begin with "RemoteIPInternalProxy 127.0.0.1/24" and uncomment them. Next,