Update problems with SQLBlackWhiteList.pm and MS

[Mike Jakubik]

Scott Silva wrote:
> Mike Jakubik spake the following on 2/7/2006 2:31 PM:
>   
>> Hello,
>>
>> I am trying to use MailWatch's SQLBlackWhiteList.pm file for my own use.
>> This file is based on the example found in CustomConfig.pm. The problem
>> i am having is that while adding new entries in to the sql database
>> works fine, however when removing them, MS does not seem to see the
>> change until it is restarted. I have taken off the refresh timer found
>> in SQLBlackWhiteList.pm for debugging purposes, and the mail logs verify
>> that the file is reading in the correct amount of entries, however MS is
>> not seeing them until it is restarted. I have looked over the
>> SQLBlackWhiteList.pm script and i cant see a problem in it, it seems to
>> be doing its job, and the logs verify this. Can anyone shed some light?
>>
>> Thanks.
>>     
> You need to at least do a "reload" to pull the lists in, as it is still read
> into memory, not a live DB call.
>   


But I don't understand why when i add new entries it picks them up, but 
not when i delete them. Are you saying there is no way around this, 
other than to force a mailscanner restart after every update to the 
white/black list? This doesn't make sense to me, why is there a timer in 
the script and why is the database re-read then? Could you provide more 
details?

Thank you.