Update problems with SQLBlackWhiteList.pm and MS

[Scott Silva]

Mike Jakubik spake the following on 2/7/2006 2:54 PM:
> 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.
> 
The timer in the script reloads the configuration every 15 minutes in the
default. But sometimes the running children might not see the changes until
they die off. It shouldn't happen, but it does. It might just be the children
that already have a batch picked up. There is a patch floating around to have
the list read from the database through the socket, and not into memory, but I
haven't tried it, and since I don't usually remove entries that often, I
haven't seen the need to try it.


-- 

MailScanner is like deodorant...
You hope everybody uses it, and
you notice quickly if they don't!!!!