Re: [Sqlgrey-users] RELEASE: 1.4.0, security bugfix

[Lionel B. <lio...@bo...>]

HaJo Schatz wrote the following on 12/13/04 14:17 :

> Lionel Bouton wrote:
>
>>> - Ever thought of a "live update" of the whitelists rather than
>>> supplying them with the source/rpm. Ie sqlgrey in say weekly intervals
>>> loading them from sqlgrey.sf.net?
>>
>>
>> Nice idea. I don't want to bloat SQLgrey with the download code (I'm 
>> already worried by its size and what it will be like with SPF support), 
>
> How about just calling an external wget?


SQLgrey will block until the wget returns (Multiplexing has its 
drawbacks...) : you will put connections on hold and if the wget takes 
long enough, break them.

>
>> but I sure can add a hook to make it reload the main whitelists on a 
>> SIGHUP for example. Then it's only a matter of a simple script that 
>> will fetch the download URLs from the conf file, download the 
>> whitelists, make some simple checks, replace the whitelist files and 
>> send SIGHUP to sqlgrey.
>
>
> That could maybe be done nicely in the init.d script. Say a restart 
> automagically loads the latest whitelists.
>

Calling the init.d script seems good, but on non SysV Unices it won't 
work... Sending a SIGHUP to the pid in /var/run/sqlgrey.pid is probably 
more portable.
I'll probably add a reload to the init scripts for convenience though.

Best regards,

Lionel.